Transformers

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

HI there,I have access to an API that returns flow data. The data is structured with a serial id (unique to each logger), ID (sequential, but only to each logger) and the data value (float).The API would run every 12 hours and just would return the last 12 hours of data with overlaps. The API creators have suggested that by fetching the max ID for each serial number in the existing data I should be able to return the data from the api that doesn't already exist. There is no provision in the API to pass these values as a parameter so will be using FME to achieve this.I could output the data from the api into a holding table and use a FeatureJoiner to the existing data so insert the new rows, but the static table will grow exponentially and I can see this becoming a huge problem in time.Is there a way to grab the max ID for each serial number from the static table, fire this against the holding table and grab only the new values which are greater than the max(ID) for each serial no

i have a road network of 4 areas and it is categorized as external and internal road, The features has an attribute as number of lanes so i want a HTML or Excel file based on the total sum of lengths each lane has. Thanks in Advance

I have a py script. It takes in 3 parameter,Input file gdbFeatureClass nameOutput file gdbWhat it does, is to copy the contends of the featureclass to the outputfile gdb and I would like to convert it to FME Can some help me with this conversion? Please remember it may be configured for any filegdb and any featureclass name so a static linking won't work. My initial findings is the use of "Generic" option of FeatureReader

Each .DWG file has to haev the same file name as the source .LAS that it is converted from. what is the best way to set this up so it converts all of them one at a time without too much user input?

Despite the fact that the nad83 and wgs84 datums are supposedly identical, there are several ways to get from one to the other and they result in different placement. ESRI recommends this transformation: WGS_1984_(ITRF00)_To_NAD_1983FME appears to use this one: nad_1983_to_wgs_1984_1 I am using AttributeReprojector on a dataset with several coordinate systems. Is it possible to indicate a specific geographic transformation for nad83 to wgs84 when using this? Thank you, Randy McGregor

Hello everyone I got a little lost in this problem, I have three columns segment, direction.I would like to obtain another order column which will be incremented in the event that we have a change either on the segments or on the direction, I tried to give you an example which explains the situation, thank you in advance

Folks, we are trying to call an Oracle Stored Procedure using SQLExecutor that send the student information and it return student_id back to FmE to be used in subsequenct translations. any idea how to do it in FME. store procedure nameintsertStudent(name,address,class) return student_id.Apprciate your help!    

Hello. I would like to know How can I use FME to transform KML to CAD with 3D shape.The first image below is my KML file in Google Earth which I use 3DForcer to generate the height of buildings.I also want to see them in AutoCAD, so I transform this KML file to DWG without any transformers.Only the reader and the writer.I refered this question:https://community.safe.com/s/question/0D54Q000080hgkVSAQ/converting-kml-to-dwg-stretches-the-original-shapeBut the result seems that there's no height line in CADI want CAD shows just what I saw in the Google Earth, How can I do that ?

I am reading an Oracle spatial table and writing the content to an ArcGIS Online feature layer (hosted). There are no transformers in between. The shape_area in the ArcGIS Online feature layer is larger than the actual area the object has in Oracle. there is a factor of 2.61 between them.There seems to be a new area calculation taking place in the writer writing to the ArcGIS Online feature layer that does not seem to be right.How can I prevent that? Greetings, Hans

I've got two data sets with some commonality in length data, one coming from KMZ (S1) and one a csv with no spatial data (S2). I would like to merge the datasets. S1 stores lengths as stationing with start and stop (St. 0, End 100)S2 stores lengths as stationing but more granular (St 0, End 25 etc) My first thought is to try and split stationing from S1 to match S2 then merge the geometry to S2 since that has the data I want to keep but I'm wondering if there is a way to do this I haven't come across yet. Any Ideas?

I want to find the biggest possible box inside an area, like the opposite of a bounding box. It should also be oriented.

I am looking for a sumproduct like function in excel that i can use on data i have in FME. What i am really after is a weighted average of certain groups of data. I have the products solved for in separate fields but i can't sum within their groups.