Using readers and writers to extract and load data.
Recently active
HI,For test purposes I'm reading from two ESRI FileGDB with a FFS writer (no further transformations).Now I recognized that the FFS writer wrote an additional .fts file. It's binary and larger than the.ffs (e.g. 5MB vs 11kb).What is the meaning of .fts files?thanks, Klaus(FME Server 2017.1)
I already have a lot of 3ds files with textures for building. I'd like generate CityGML LOD3 data from these 3ds files.For LOD3 data generating, I think the first and the biggest problem is how to classify Window, Door and Wall.I think it is possible to crop or edit the window or door in 3D MAX.But I don't know how to assign the properties such as Window, Door and Wall.If you have any idea or experience, please share your experience.
Hi, we have SmallWorld 4.2 and would like to automatically export data to another database using FME server on a daily basis. As stated here, the connection service to FME is started automatically in SmallWorld 5.x, not in previous versions. I need to know if it is possible to automate the start of the connection service. The idea would be for example to start automatically the connection service at 1 AM everyday and then start the export workflow on FME server at 1.05 AM. Is it possible with version 4.2 of Smallworld ?Thanks in advance !
Is there a way to retrieve the URL of documents within sharepoint?
I've been working with Minecraft maps and FME for a while, although I'm struggling to develop a way to use change detection for a batch of 40 Minecraft maps, compared to a single map. My main issue is related to improve processing, because processing Minecraft maps as PointClouds is almost impossible due the large files it generate. How could I use change detection in Minecraft maps in optimized way?
I have osm file for my city, I am using Libosmium to read it, and I'm storing nodes of each way as Vertices of My Graph, and making edges between each 2 adjacent nodes in each way, and calculationg eucledian distance between them, the problem is that : The ways are not connected with each other ! I can't reach my destination from my target, even though there is a route, but there is no node intersect between the ways (No common nodes) so I can't reach my destenation ! What nodes should I add to my Graph, and how to bridge them correctly ? so I can reach my destination from My Node ?
I have a user that requires a non-spatial SQL Server Table provided to them as a Tab Separated CSV file. I have found the CSV writer, but cannot find an option to output as tab separated instead of the Comma Separated.Does anyone know if this is possible?Thanks very much for your time.Cheers
I have two inputs that I'm trying to write to multiple pdfs, one is constant and the other changes with a fanout. But I can't get it to put both inputs on one pdf. I'll try and explain with an example:Input one is a roads dataset, input two is a neighborhood's dataset. I'm using a dataset fanout to produce a pdf for every neighborhood and want the roads to also be on each pdf. I can't seem to combine the two, at the moment I get a pdf for each neighborhood and a separate one for the roads. What am I missing?I'm new to FME, so apologies if this is something really simple that I've missed!Andy
Hello,I am trying to migrate PDFs with the FileCopy writer. I have destination path and file names with lengths from 260 - 300+. They fail, but if I change the path to be shorter they all succeed. Am I mistaken in thinking that FileCopy limited to 256 as its max pathname character count? Is there a way around this? Has anyone else run into this issue?Additional info:FME(R) 2019.0.0.0 (20190328 - Build 19238 - WIN64)Windows 10 Thank you for your advice,Andy
When "Overwrite existing file=No" in a text file writer, new data is appended to the end of the file. But if the file output is gzipped then existing file is overwritten. I am testing:The first output is gzipped and the second one not.If I execute the workspace () several times, the .txt file grows but the .txt.gz not. Any suggestions?
I'm having trouble combining contours onto a geotiff raster prior to draping. Can anyone help me to find a process to get the contours onto the Geotiff, preferably with labels on the contours.I've tried the contour generator and a shape file but having real difficulty projecting the contour data onto the raster successfully.
Hi,I had fme desktop 2018 with a fixed license, then i switched to fme desktop 2019 with a floating license, and now i can't open my old fmw files.Once i try to open an old fmw file it gives me an error : File cannot be opened : user may not have sufficient privileges to read the file. (but i still can lunch fme dekstop).Any ideas ?Thank you,Soukaina
Hi, I need to create pdf report(as the attached), would you tell me what transformers that I need to use.the reader is AGOL or sde database. I cannot use HTML2PDFConvertor because we not allow to load WKHTMLTOPDF.exe. thanks a lot
I have an AutoDesk Recap Mesh file(.rcm extension) is it possible to translate this to an Esri I3S file using FME Desktop?
Hi,I'm relatively new to FME and am coming up against an issue when setting up user parameters that will allow a user to specify an individual geodatabase feature class.I want to allow a user to select a specific feature class from a geodatabase, similar to how you can specify individual feature classes within ArcGIS when using geoprocessing tools. While I can specify which feature classes should be read when reading a geodatabase, when this geodatabase is set up as a user parameter, the user can only specify the input geodatabase and FME will then look for feature classes using the names that I used during creation of the workbench.Also , If I have taken two feature classes from one geodatabase and another from a separate geodatabase, I will only have 2 user parameters available; one for each geodatabase. Ideally, for the user, I would want three user parameters, one for each feature class and for it to not matter if these feature classes are in the same or separate geodatabases.C
I am trying to make an overview of crosssections of infratsructure (a levee). I would like to plot all crosssections in 1 graph in excel. I managed to make 1 excel per cross section, but I would like to plot them a bit like this: This is made in Fme, but has 2 problems for me:- 1: I can't 'turn off' certain cross sections since it's a png (that's why I want to do it in excel)-2: I made an attribute column with cross section number, an x-value (-50 to 50) and a z value. I grouped them per cross section number. This causes the graph lines to go straight back from 50 to -50 on the next profile (the straigh lines). I would prefer not to have those lines.So: how do I get 1 excel graph with all cross sections on top of eachother without the 'return lines'?
Hello,I'm trying to split a CityGML file into multiple OBJ files based on gml_id. For exemple I have a gml_id like this : "BU_69381A"(A to Z)"39" and I want to split at every letter in brackets.Do you have an idea of how to do this?Thank you in advance!
Hello,I used FME Workbench 2017 to generate an IfcSpaces from shape file with footprint polygon and height information. I managed to create space geometry but I could not create longitude and latitude for IfcSite. These values were empty ($). Is there a way to fill theses values with FME Workbench 2009 ? Knowing that today I use a not very powerful method which consist in replacing the text of the end line of IfcSite definition : .ELEMENT.,$,$,$,$,$) by another one with right values : .ELEMENT.,(42,45,2,206849),(0,-25,-12,-380875),0.,$,$) Or perhaps is there a way to write ifc_object_placement for IfcSite which could be another solution to have correct placement ?? Thank you in advance for your help Best regards Bruno
Hi,Soon I will migrate the graphical data (shape and Oracle Spatial) to the ArcGIS feature class on SAP HANA (ArcGIS Pro 2.4). This test migration should be done with FME Desktop Workbenches and the productive migration from FME Server. Question: In case of using FME Desktop Workbenches, must ArcGIS Pro software be installed on the computer or are there workarounds (copy DLL's,...)?Any feedback would be appreciatedThanks and many greetingsEwelina
I have a dynamically generated list called comments as shown below using json templater and sql creator transformers. List contains several objects and I want to generate id for every object as one of the attribute of the same object.I also want to set an attribute called solution as a boolean true or false. But the attribute lies inside the object and cant set its data type. Is there any solution for this? I am transferring the data to Mongodb by creating a json file from sql based data.Capture4.PNG JSON Templater code 2 is -[fme:get-json-list-attribute("_list{}.commentObj")]Here after mearging data from Oracle and Mongodb in Feature mearger, I am creating a json object using first json templater using below code -First JSON Templater code -{"user": {"user":fme:get-attribute("TKT_NOTESUSER"), "username":fme:get-attribute("fullname_notesuser"), "_id":fme:get-attribute("mongodb_id") },&qu
I am having problems writing to I have the following workspace It reads in the following file
I was wondering if there was further documentation on the FME server database. I'm looking to create a REST service from the database that we can use in conjunction with Operations Dashboard to show statistics about FME server in real-time (specifically things such as last time a job was ran, the status of the job, errors from the job (if any), run time, etc). Currently I'm harvesting data nightly to get a summary of the performance over the day, but it would be nice to be able to create a rest service that would show all the data together without having to heavily use an FME engine to push data to ArcGIS Enterprise (Portal) or ArcGIS Online.
I have a large GML dataset (200.000 features) In FME Desktop (build 19630) it runs great in a FeatureReader set up for GML (both ignore application schema yes and no) but in FME Server it stops after the 1034th feature with a message that it has an unexpected end of input (for both ignore application schema yes and no).I did notice the XSD that is provided had too a short a field for certain values (but shouldnt matter for ignore application schema = yes)https://www.aerius.nl/files/ftp_upload/habitatkartering.gmlThen if I run a generated workspace from GML2GML in FME Desktop and ignore the schema the resulting GML will end in FME Server (build 19630) with an unexected end of tag.Bug or I'm missing something? FME Server and GML haven't proven me yet
Hello,I'm trying to set the ground and all the building to 0 elevation in my CityGML and keep the buildings in 3d.Do you have any idea how could I do that?
I have an Excel file which has the header on the 3rd row. The first and second rows have additional information. My actual data values start from row 4. Is there any way in FME to remove the first two rows and use the 3rd row for attribute names? I have attached my example file.Thanks in advance.