Transformers

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,

I have a shape file that doesn't have the elevation coordinates. I have the extracted x and y and with those I am looking for a way to solve for z or the elevation. Can this be done in FME, and if so with what transformer?

Dear FME-Community, I have a question concerning FME. I would like to convert a huge CityGML file into small tiles of e. g. obj-Files. I have seen that cesium is able to produce 3D tiles. Is this also somehow possible with FME? The end product should be 3D meshes for CAD software/ or something like obj-files. Maybe there is a direct way working with FME or maybe there is a work-around with cesium and FME...   Thank you so much for your help in advance!  with kind regards, Christian Lendl

I have several main polygons and sub polygons in it, but sometime sub polygons have same name as mentioned in attached snap, attached is the only example, I have lot of data, how can I find duplicate polygons within main polygons?In blue color, name is for main polygon and in black color, name is for sub polygons.If anyone can help with workbench then it will be really helpful.Thanks in advance.

Hello everybody, My project need to convert amount dgn files (more than 2000 files) to shapefile and I want the output also are multiple shapefile which equal dgn files. I'm a newbie in FME, so who know the exactly way to convert multiple dgn files let's support me. Thanks for everyone!

I have an FME-workbench which manipulates data originating from either Excel or Access. Since I want to use the same workbench for dozens of different Excel and/or Access-files and every file has multiple Features, I don't want to create a new Reader every time, but just indicate the path to the corresponding file.The data structure is given and supposed to be the same for every input file. However, sometimes that is not the case, i.e. some additional columns are added in one of the Excel Sheets . Now, I am interested in finding additional/missing columns, but that's where I start getting lost... I tried to compare the attributes of my desired Input file and the Example file (with the correct data structure) via Attribute Transposer and ChangeDetector, but it did not work dynamically as the Reader seems to remember and thus keep all the Attributes it has ever seen so far - and not only the attributes actually present in the desired input file. Please let me know if I should giv

Hello!I'm having a near meltdown trying to figure out how to rework a process that I have and hope the community can help a bit. I'm working on a project that is determined a suitability analysis on which curbs are best suited for EV installation charging. By using the SpatialRelator, I am currently processing millions of feature lines (the curbs) and comparing each line to 20-30 different datasets (polygon areas that have been prepped with preconfigured parameters) to see which of them overlap. I then use a ListExploder to explore those relationships, and then a FeatureMerger that merges the different individual "scores" for each of those 20-30 datasets. Then I run it through an Aggregator to basically generate a total "score" from each of the datasets that intersects with a particular line feature, grouped by the line feature. For a smaller dataset, it works fine!However, trying to run 500,000 features using a WHERE clause lasted over (last I checked) 18

Since FME 2021.1 I get many python errors around None values: Python Exception <TypeError>: Attribute value cannot be None. Use setAttributeNullWithType() to set a null attribute value. Is anyone else having the same issues? It occurs with FME Desktop as well as FME Server