Transformers

I am working on a longterm project that will take csv files, turn the data into fme points and then use them to publish an agol web map. I have been trying to play around with the agol writer to publish the new feature layer. Whenever I use the writer to create a new feature layer, the data is lost, somewhere in the process and i get a blank layer with no data in it. Furthermore, when I try to insert data into these layers, nothing happens, the writer says it runs successfully but there will be no new data in the tables, they will remain blank. The final goal of this project as I said is to take csv data files containing point data and automate the process of making a web map with them. Is FME's writer unfeasible for this task? Do i need to accomplish this goal using Arcgis REST Api? The CSV datafiles typically contain the following: Latitude, Longitude, Object ID, Completion Status, Address, and a notes field. If I need to use python, how do I write my code so that it will use the

Hi all, I need clarification whether FME supports migration of Smallworld Electric Office data to ESRI Utility Network. Any lead in this aspect will be quite helpful. Please share if any portal is available as reference.

Hello,I'm having difficulty getting the results I want out of the Spatial Relator and AreaOnAreaOverlayer. Essentially, I'm trying to identify overlapping polygons within the same layer, where the overlap area is of a significant size, so that I can separate these out into separate layers in a fan out at the end of the process. I want to do this by creating a field and populating that with a value, where the first / bottom polygon remains in the original layer, but additional overlapping polygons are allocated an increasing number so they can be separated into a new layer - all the '0's, '1's and '2's together. I don't want to identify or attribute what are essentially topology errors (very slight overlaps), as these need to be reviewed and fixed manually, just what are considered 'legal' overlaps so they can be topologically cleaned separately. I have an (incredibly bulky and inefficient) solution, using both SpatialRelator and AreaOnAreaOve

Hello.  I would like to remove (replace with no text) everything what is after dash also with the dash. What I have: test - fmeWhat I want: testCheers, Oliwer

Hello all,I need to read glb-files and run a spatial transformation on it. Every glb shows one floor of a building with all its rooms. On the walls there are textures of photos so it looks like the view inside the room. The exterior walls show the same image as from the inner backside, because the building photos where only taken from inside, not from outside the building.FME can not read glb, so I tested some software to create different formats which FME can handle, like fbx and dae.When I look at the glb, fbx or dae in a 3D-Viewer, I can see the photo projections correctly. But in FME Inspector and after transforming the data to cesium 3D Tiles at exterior walls the inner room images are only shown outside. On the inner side there is the image missing.Is there a way to show the same images at the exterior walls and also at the inner side or change some settings so I can see the images only at the inner side and not outside?I am thankful for any help!Best regards, MiHue

I am not getting the results that I expected. I believe it may be because I do not have anything connected to the 'Initiator' for the SQLExecutor transformer. What I was trying to do, was to execute the SQL statement and if no results were returned then proceed with the workspace. If records are returned, then send to the Writer. This sql statement should return 1 row.

Hi,I am trying to read data Oracle non spatial data from a View and create an output in Oracle Spatial.Although the process writes to the Oracle Spatial table and you can view the attribute data OK the data does not seem to be spatial and I can't see any data on a map. I have learned through passed experience that the Spatial Column must be changed from GEOM to SHAPENot sure if this is because i can't set the Eastings and Northings in the Reader to Types x_coordinate and y-coordinate?You can set in a CSV Reader but not Oracle? (if this is the issue)  Thanks

I need to run a sql statement to determine if my workspace should run. If the sql statement returns any records, then I need to terminate the flow. If nothing is returned then it is okay to run the workspace. I would like to pass in a user parameter as a string to be used in the sql statement. Is this possible?

I have 4 lines and I constructed a polygon by using AreaBuilding. Now, I would like to clip the polygon with a 60 m offset from the northeast point. How can I do it? https://i.imgur.com/U59AcpG.png

Dear FME community, I have CityGML tiles which I converted into KML or KMZ files. They are in a certain folder structure. Now if I open single KML files they will only display in 2D with the inspector transformer. Is there a way to load all the files that belong to the KML structure? So that it displays in 3D? When I upload it in Google Earth it works just fine. At the end I would like to convert these KML or KMZ files into 3D CAD files like dwg or obj. Thank you very much for your help. With kind regardsChristian Lendl

Hi everyone,  I have a polyline shapefile that represents a transport route. I also have a point shapefile of markers along the route. I want to be able to split the polyline into segments between the points. I want to retain the route rather than use line builder to create segments between the points.  I have tried using the PointOnLineOverlayer transformer but I end up with significantly more line sections than I am expecting. For example I have a line with 27 markers along it. I am expecting to get 28 segments when I split the line at these points. Instead I am ending up with 61 as the line is split in locations where there is no point (highlighted blue part is on of the output lines). I think this may be a result of the aggregate geometry parameter. When I run the polyline through the aggregate filter it says the line is an aggregate. I see that the aggregate options in the PointOnLineOverlayer are deaggregate (which I think explains why I get more line segments than I was expectin

I have input points with multiple coordinate systems. I am trying to use esri reprojector on them, using a table for the input and output coordinate system and the geographic transformation.After MUCH testing, it appears to me that the geographic transformations are not being read. I hard-coded the identical value that is in the table and the features ended up where I wanted. When I set the value to get read from the table, they don't. I am pretty sure I've entered it correctly.Note: since I ran successfully with a hard-coded value, after switching to reading the table value it is working correctly. Logical explanation is that it is not reading the table. Input coord is read from table. Output coord sys is hard coded (wgs 1984), geographic transformation appears to be ignoring table values.

Hi there,I'm having problems with my workspace. It's quite big:reading an oracle data basetransforming and calculating datawriting to SpatiaLiteAnd all this on a virtual machine.I cannot provide the workspace and data here as they are sensitive, but I'll try to explain what I already did:The wohle workspace will throw an error. Sometimes because of memory space issues, sometimes unspecified (just 'Error during translation').I already set FME_TEMP to another disk.I did run it in debug mode: no hints on the abrupt termination.I disabled some parts of the workspace to get a focus + activated caching: while running part by part including writing to SpatiaLite, it didn't fail! But: I saw the temp-directory increasing up to 40GB.I ran the workspace in batch mode - failed. What else can I try? It seems to be a space issue (disk and/or memory). Does anyone else have experience on that (especially with a virtual machine)? Cheers,Maria

I have a line and a point dataset. The lines have measures, generated with the MeasureGenerator. Some lines are partly overlapping, so they share part of their route. The lines have a "ROUTENAME" and the points have the same attribute, indicating which line they are associated to. Now I want to derive the measure value of the points along the route, but only on the route they are associated to. How can I make the PointOnLineOverlayer and MeasureExtractor take into account the "ROUTENAME". Now some points get the wrong measure (of another route on the same location). Any ideas to help me out?

I have exported an AGOL featureclass as a JSON and GeoJSON featurecollection as I need to use the httpcaller to push the data to another feature layer in AGOL. I need to use the caller as I need to see the to/from objectID's for further record manipulation. However, I am really struggling with the format of the json to read from the file. Any pointers would be appreciated. thanks. Example exported JSON below{ "type" : "FeatureCollection", "crs" : {  "type" : "name",  "properties" : {   "name" : "EPSG:3857"  } }, "features" : [  {   "type" : "Feature",   "id" : 1887,   "geometry" : {    "type" : "Point",    "coordinates" : [     12897276.605700001,     -3756547.8676999994    ]   },   "properties" : {    "OBJECTID" : 1887,    "description" : "100 James St.\\nreplace pit lid and patch with cre

Hello Safe Software, The functionality to disable transformers in FME Workbench is a very useful functionality that I use quite often in the iterative stages of workspace development/authoring. But as of now when a transformer is disabled in a workspace in FME Workbench, FME features do not pass beyond the disabled transformer. Can Safe Software look at adding the ability in FME Workbench to let FME features pass through a disabled transformer. In other words, the transformer though still in the data flow but since made inactive (disabled) should simply let FME features to pass through without any manipulation it is actually expected to perform on the FME features entering it. Regards  SRG

i would like to add 6 extra character empty space at end of attribute value that include text . How could i achieve that ? FME 2018

I have a CSV file with Longtitude and Latitude fields (more than 10.000 records) and I want to convert these to point (shapefile). After that I want continue use a polygon to select which points intersect with it? I tried to use VertexCreator and SpatialFilter or PointOnAreaOverlayer but it didn't work like my expect. So who can help me to solve this problem. Thank you so much!

Hi everybody, I have a table which a column contain content as "province_district_ward_2020" and I want to split it into a word. Example: Before: "HoChiMinhcity_District1_ward1_2020" After: "HoChiMinhcity" / "District 1" / "Ward 1" / "2020"I tried use StringPadder or StringReplace but the result which It's not my expected result. I think there are wrongs in my process. Can you help me know how to work it? Thank you so much!

Hello, I need to rebuild polygons from points, but need certain vertices' criteria.Polygons need to be digitised in a clockwise direction (can use orientor transformer for this)Polygons need to start with a vertices which has highest z value.How do i define the start vertice for the polygon when rebuilding the polygon? Thanks @Takashi Iijima​ @david_r​ @Hans van der Maarel​ @ebygomm​ 

do we have method instead of creator to add text in pdf ouput file ? but i would like to do that without opening the workspacemy text that i want to write in pdf ,it will change and i do not like to open the workspace everytime to change it .when i am using quick translator ,could i add also empty field and write the text that i want to see in pdf out from workspace .is there method to do that,because the name of pdf file should change from time to time y.Thanks for help FME2018

I am using esrireprojector and am getting input coordinate system values from a table. One coordinate system is being rejected and I don't know why.I have entered it as 'EPSG:32000' and as 'NV-W' both of which FME normally recognizes.With ESRI reprojector, it is rejected, but other values are accepted. I know 'NV-W' is a legitimate coordinate system code. I tried entering the full ESRI descriptions and that was truncated and rejected.Confusing to figure out exactly how to enter coordinate information. There seems to be more than one coordinate code for some systems, and then there are the completely different ESRI codes.Any help would be appreciated.Thank you,Randy McGregor

I cannot understand why I get the error message MS SQL Server Spatial (JDBC) Writer: Error writing feature. Error: Attribute 'DATECOLLECTED' does not contain a valid timestamp The timestamp I want to write is for the moment hard coded as 2021-07-20.The databse accept this format confirmed with successful update SQL update dbo.Featureset "DATECOLLECTED" = '2021-07-20'where ID = ... Why does FME fail to write to my db? Any suggestions?

Hi there, I'm dealing with data conversion from IFC to CityGML by FME, which is a pretty complex workspace. In the final output, I wanna merge IFC attributes in EXCEL format into the CityGML data. so the whole workspace contains 1 IFC Reader, 1 EXCEL Reader, 1 CityGML Writer to complete one model conversion.  It works fine if I set the EXCEL reader by selecting Individual Feature Types (select Single Merged Feature Type would fail, I'm not sure why).  However, as I have plenty of IFC models (as well as related EXCEL files) for conversion, I want to batch run the workspace using command lines. The issue is each of my EXCEL files have different file name, sheet name, attributes numbers & names, the EXCEL Reader could not automatically read the data if just by changing the EXCEL name. I've searched other posts and tried Generic Reader, Schema Reader, etc. it still doesn't work. Thanks in advance for any ideas/suggestions! :D

Hi,I'm trying to set up an FME workspace so that the name of the output file at runtime is followed by the date the output file was generated.For example: "myexcelfile_20210720", where "myexcelfile" is the prefixed name and "20210720" the current date.How can I implement this with the FME Desktop Excel Writer? Regards,