Transformers

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 nam

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

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 (l

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

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 CAD

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.

i would like to use OSM Openstreemap , i have downloaded BPF for a city from Geofabrik Download server ,is that the correct extension or which extension should i download ?  could someone provide me with an example for OSM Workspace ?and what shoud i do ? i would like to show output geographical map for polygon as Google maps . FME 2018Thanks in advance

I am trying to split an attribute using a regular expression as there may be differences within the attribute. For Example the attribute may be as AA9A or B7BHowever some of the attributes are formatted as CC7 or DD6 I therefore do not want to remove the last character from these, all I need to extract is AA9 or B7. Is there a way with a regular expression to search for a character, potential character and then a digit?Or is there a better way to achieve what i am trying to do??Thanks in advanceAndy