FME Form

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 

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

Hi ! I have a folder containing about 20000 jpeg files and separately a list in csv format containing names of some jpeg files which I'll need. How can I import in FME only the jpeg files from the list and not all images in the folder ?Thank you.  

I am essentially looping through httpcaller results and need a way to pass a value from the last record returned in a loop, I dont know how many records will be returned. I was using the stats calc to get the max value but that is blocking the loop from running within the one workbench. Does anyone have any suggestions, thank you

Hi All,I have a workbench that reads a feature service from ArcGIS Online exposing the actual attachment attribute associated with each feature and then extracting the photos attached to it.I'm using RasteReplacer to convert the BLOB data to a JPEG and then writing it with a JPEG writer (with the option to save the EXIF data ticked).However, it doesn't look like the EXIF metadata is writing to the JPEG.I'm sure that the EXIF metadata does exist as I have an existing Python script that uses Arcpy to extract the JPEGs with EXIF out from a file geodatabase. But when I do it through the ArcGIS Online feature service reader, it doesn't seem to be retaining this information .Any help on this would be much appreciated.

Hi,I have a script where the user decide what file to add to one of the excel readers. The problem is that the information in the excelfile is new everytime and so are the columns as well. But the problem is that the reader wont update to new columns in the new excelfile. Somehow the first excelfile that is added to the reader is kind of "stuck" there until I remove the reader and add a new one with the new excelf file. But the problem is that this script is connected to a FME server app where the users will be choosing an excelfile in the app and not in the script. So I wont be able to re add a new excel reader everytime. Does anyone here have a solution for my problem? FME version: 2020.1

Within the two data sets there is the common field of subscriber address and address. However I believe there is an issue with the formatting as when I fuzzy matched the Subscriber address with the UPRN dataset the ratio was poor yet when manually checking the fuzzy match output they were mostly correct. Is there an extra step to reduce the issue of factors such as spacing and extra information such as "Nottinghamshire" through transformers? I hope the blurry images below help explain the formats Thank you for any help or advice!!

I have been developing a workbench to be used on different shapefiles via adding a new reader everytime, they would have slightly different attribute names beyond my control. The workbench is now ready to go, but when I have to update the right attribute in a transformer, FME seems to list ALL the attributes that have been handled with previous files with that workbench.. It's really annoying and also potentially generating failures. Is there a way to clear this? To only list the attributes within the readers? I have tried tool>purge temporary files, but it hasn't solved it.  

Hi,I would like to transpose attribute where the unique values in attr_names are columns and the rows are grouped correctly. What I mean is that the values has to be attached to correct feature (see attached picture).The attributes need to be grouped in one row as presented below in the picture with the colors on the side.  FME version: 2020.1

Hi all,I am using an excel file containing several tabs. Each tab corresponds with a feature type in my data. And each feature type/tab has its own specific set of attributes I would like to write to several formats.  Whenever changes are made to this excel file (changing names of attributes, adding attributes, adding tabs, etc.), it does not update automatically. Even if I set the parameter 'Scan Schema in Dynamic Workflow' to 'Yes'. Every time changes are made, I have to delete the workspace resource and add it as a new.  Anyone having similar problems? Or solutions to this problem?Thanks!

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