FME Form

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!

I am interested in a way to translate these database (Tape) files into a usable format. Anybody have experience? Extended Binary Coded Decimal Interchange Code (EBCDIC) is an 8-bit character encoding used mainly on IBM mainframe and IBM midrange computer operating systems.EBC format descriptionCategory: Document filesApplication: -Mime-type: application/octet-stream

My workbench run successfully but when I enable parallel processing on a custom transformer, and 'FME has stopped working' error/APPCRASH occurs.  I have tried:using only one group to process to rule out having too many parallel processes, I have tried setting to minimum, moderate processing. I have tried publishing to FME server and running.  All fail as long as parallel processing is enabled on the custom transformer. Does anyone know the solution for this?

I am trying to extract All the parameters along with values from Revit to MS Excel using FME Desktop. I tried to extract but i could only get very few parameters and those are instance parameters. I need to Extract All the Instance and Type parameters.

Hi,  I have a list of polygon geometries in WKT format, some simple polygons and some multipolygons.All are using the MULTIPOLYGON type in the WKT, for example : MULTIPOLYGON(((1 1,1 2,2 2,3 3,3 1,1 1)))MULTIPOLYGON(((1 1,1 4,4 4,4 1,1 1)),((2 2,2 3,3 3,3 2,2 2)))MULTIPOLYGON(((1 1,1 5,5 5,5 1,1 1)),((2 2,2 3,3 2,2 2)),((3 4,4 4,4 3,3 4)))But some of them don't have the first coordinates repeated at the end, so it is not a valid WKT.If I take the same examples, it would look like : MULTIPOLYGON(((1 1,1 2,2 2,3 3,3 1)))MULTIPOLYGON(((1 1,1 4,4 4,4 1)),((2 2,2 3,3 3,3 2)))MULTIPOLYGON(((1 1,1 5,5 5,5 1)),((2 2,2 3,3 2)),((3 4,4 4,4 3)))I want to find all the features lacking the last coordinates repeated. Any idea how ? Until now, I tried building a list with all coordinates, it can work for the simple polygon but for multipolygons I don't know how to handle it.

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​ 

I have an FME-workbench, and eventually I want my data to be stored in a postgreSQL database. This works perfectly fine with the PostgreSQL-writer.  However, I need to populate multiple tables which underlie several constraints. Thus, the order of when what reader is run, matters. Moreover, I would like to instantly read the written data for further manipulation (my DB automatically generates an ID (by a sequence) which I need to merge to other tables as a foreign key before writing those tables to my DB). Any help much appreciated!

i have a small cartographic map in pdf format ,i have added it in my workspace then i have clipped it ,and i tried to write it again in Adobe geospatial pdf by feature writer transformer ,i get an empty file .it does not want to open .what i did wrong ?i would like to save it again in pdf ,how could i achieve it ? is there a way to read pdf as Raster .Thanks for help Fme 2018

I have amount Shapefiles and I want calculate value of attribute as shapefile name. Who can help me? Thanks so much!

Is there a way to read or write to an MP3 (Music) or MP4 (Video) file's ID(3) Tags? There is plenty of software out there that allows for the editing of a variety of ID(3) tags in music or video files of the MPEG variety, however it might be useful for a Reader to enable those music / video files that identify their origins to be located from their tags onto a map.Anyone wanting to create a catalogue of their music or video would find the reading of the built-in data tags in their music / video files useful too.....just a thought.

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?

Is there an upgrade procedure to upgrade the workspace to work in the new version? Or is this a bug in 2021.1?Screenshot of attribute filter that's not working.

Do we have an In Memory Table something similar to the FeatureHolder but takes a dynamic schema? Or is there a writer that can take dynamic schema without specifying a disk destination?

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 3 input to pdf page formatter transformer,after that i got pdf output file and it looks as i wish .but i have new idea ,that i would like to put the same output as shown in pdf ,feed into directly in Excel sheet .do we have a method to achieve that ? because at end i have to take screenshot of pdf file then add in excel sheet manually ,but if there is a method directly ,it will be better. Thanks for help FME 2018

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?

Hello everyone!I have a sample Revit file which contains the basic elements of a Revit file.I am interested in performing certain geometric tests through the FME, for example: Are certain elements in a place where they are not supposed to be present, Is a certain element in the right room,Does the element of a toilet for example, have enough space according to the standard we will define.And so on.When I approached the task, I was sure that the FME would be able to solve it without any problem at all, and then reality hit me.Any action I try to do with the help of the transformers I know (I work mostly in the GIS world, and know it's a little different from BIM), I do not succeed.For example:I intentionally inserted a foundations between the walls, and I expected to see that when I make a clip between the wall and the foundations, one object will be inside.What am I missing here?Do I need to move the 3D objects through another process before the required actions can be performed?Or

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 a unique value logger attached to a table and a workspace runner. It took me a while to realize it, but what it does is goes through each unique value and runs the entire 'child' fme once for each unique value, but it runs all unique values each time it runs . I put a test filter on the input table in the workspace runner workspace so that it only has one unique value to 'give' the runner and that solved the problem.This seems very strange but it works. Does anyone know why this works like this and if there's a less 'hacky' way? Thank you,Randy McGregor