FME Form

I have a workspace that is calculating the shortest path across a network for a dataset of start and end points (joined as lines). The length of time it is taking to process the data through the ShortestPathFinder transformer is a lot and it sits as follows for hours on end:  Is there a way to speed this up at all? I know I’m trying to process a large amount of data which could be the primary reason but I am curious if there are ways to perfect this process to enable it to complete much faster.

Hello everyone,I'm working on a project in FME and need to filter date values from a CSV file. I have the following requirements:The date should be between 01.01.2021 00:00 and 22.07.2021 23:59. The date column is in the CSV file and is formatted as dd.MM.yyyy HH:mm.I've tried using the DateTimeConverter and Tester transformers, but I'm not sure if I've configured everything correctly. Does anyone have tips or examples on how to implement this?Thank you in advance!

Happy new year, FMEers.Our question-of-the-week was posted just a few hours before I started to review the week. It's about parallel processing and the ShortestPathFinder transformer. Question of the WeekQ) I was hoping to speed up my ShortestPathFinder calculations with "Parallel Processing", but I don't notice any speed improvements. The 2018.1 documentation says "If it is enabled, a process will be launched for each group specified by the Group By parameter." However, the most recent documentation does not mention parallel processing at all. Am I missing something? Asked here by @magnus A) Yes, there are a number of points. The first is what happened to parallel processing in 2019, the second is how to ensure parallel processing works... Parallel Processing in 2019So here's a quick

In the change detector is there any way of transferring an attribute value from the original feature to the updated feature when it's not either a Key Attribute or one of the attributes listed in the matching strategye.g. 

Hi All,I have been building workspaces that get data from an api and write that data to Excel, using Template files. FME Flow can’t access the location of the template file, so what I did was: Make them a published parameter and publish. Then once one Flow, I change the parameters to the Flow resources path where I uploaded the template file as well. I do this in the Workspace properties. However, this doesn’t work, when running the workspace, the log says it can’t open the Template File and still pointing to the old/local location of the template file.What would be the right workflow here?

Sono un neofita del programma, devo convertire un IFC in cityGML con un algoritmo già elaborato. Inserisco il mio file IFC ma mi compaiono questi errori :ISO10303-21: Unknown entity or type name '\xD0\xCF'.ISO10303-21: Invalid file format, unable to continue readingCosa posso fare? Ho provato ad inserire il file in IFC 2x3 coordination view 2.0

Hi folks,I’m hoping this is relatively straightforward and I’m making this more difficult than it seems. I’m collecting images in the field and trying to store the images as blobs in a database. There can be up to 6 images for each property. In the below example only 3 images were collected. I’ve got to the point in my workspace where I’ve joined the images (as blobs) to the survey data, but I’ve got 3 features instead of one. I have a unique survey id. How do merge the data so that I have one feature, with up to 6 images stored as blobs? I’m trying and failing to use lists in the most efficient way possible; via the Aggregator then List Element Filter, then somehow bring the data back together, but this is the point I’m stuck on. Any help is greatly appreciated. Many thanks,Aaron

Hello,I am attempting to use the FeatureWriter to update a spreadsheet. From the screenshot you can see I have Addresses Input into which is pushed 3 updates and 95,393 from the original spreadsheet. The Output port, Addresses adds the 3 records to the original spreadsheet making for 95,396 records. Is there a way to get FeatureWriter to update the spreadsheet so the output is 95,393 with the 3 records in 95,393 updated not added to the output? The FeatureWriter is writing to the same spreadsheet in the Addresses Reader.  

What modules are available in the PythonCaller transformer in FME Server?I am interested in these modules;urlliburllib2requests 

Bonjour la communauté. Je cherche à créer un tableau avec mes données d’entrée et par la suite insérer ce tableau dans un pdf.Pour insérer ce tableau, je devrais sûrement utiliser le pdfpageformater, mais quel transformer va me permettre de créer mon tableau comme je le souhaite. Merci d’avance pour vos réponses.

I am clipping a raster and then running RasterStatisticsCalculator. The results are completely wrong to what I get in ESRI using  zonal statistics and the only stat that is correct is the max value.FME Results: When I export the raster and bring it into ESRI, cell values are different and zonal stats are different Zonal stats results from ESRI:  I would appreciate some help in how best to run zonal stats in FME. Thanks,K

Hello FME Community,I have point data with attributes for the X and Y coordinates of the top-right and bottom-left corners (e.g., X_TopRight, Y_TopRight, X_BottomLeft, Y_BottomLeft). I would like to create a rectangle based on these two corner points.Could anyone suggest the best approach or transformers to use in FME to accomplish this?Thanks for your help!

Hi Team,I am new to FME and would appreciate if you could help me by giving some tips on Error handling in FME, Below is my scenario,My FME application reads the data from Database and writes to arcGIS Feature layer. Application overwrites the data to feature layer everytime it runs.If application fails for some reason, is there any transformer (or any other method) to retry running the workspace again or add some kind of Try/Catch mechanism?Below could be possible error scenarios in my application,    1) Error connecting to Database    2) Error occurred during transformation    3) Error occured writing to arcGIS Online    Thank you in advance,Regards,Syed    

Hi - I am hoping someone can help.Apologies in advance for the long message.I am using FME Workbench 2022.2.8.I am trying to set up a workspace that has three readers (using a SQL database that retrieves data from three separate tables) connected to a PythonCaller and then a feature writer (connected to the Python caller) that writes the data back into a SQL database.I need all the readers to have finished before the PythonCaller is executed as it uses all of them in the script.I initially tried to run this using the built in Translator Python3.9+ but every time I did It said no module named pandas.I attempted to configure my own python.exe that I have as part of anaconda navigator (2024.10.1).I created an environment called fme_env and set the Python version to 3.9.I was able to successfully set up all this, but I encountered the no module called FMEObjects error.I went into my FME installation path and there was a fold

I have a SPATIAL table with the following columns: X_coord, Y_coord and a SPATIAL column GEOMETRYThe X and Y coordinates are adjusted. With which attribute can I adjust the GEOMETRY columns?It has data_type SDO_GEOMETRY (Oracle). Contents of a record:MDSYS.SDO_GEOMETRY(2001, 28992, MDSYS.SDO_POINT_TYPE(201234.5678, 47123.4567, NULL), NULL, NULL)  

I used Workbench 2022 to clip buildings (composite surfaces) onto an area with the clipper transformer. The buildings at the clipper boundary however are open geometries (refer to screenshot). How can I insert closure surfaces to each boundary building to create closed volumes?I tried to coerce the composite surfaces to a solid and coerce them back to surfaces after the clipping, but the method is not reliable, because most of the solids become faulty. Is there another solution? Best regardsAlex

Hi,I’m trying to save a polygon as a GPX track and am running into an issue. Here’s what I’ve done so far:Converted the polygon to a line using GeometryCoercer Reprojected to EPSG:4326 Created track_id, source, and name attributesThe translation completes successfully, but when I try to open it, I only see the attributes and no geometry. Any idea what I might be doing wrong? 2024-10-29 11_22_11-Window.png

Title says it all, Basically I have a workflow:Adding a prefix to the new attribute results in the new attribute not to have any values.Running with prefix:Running without prefix:  Also if I add a prefix, for example _, and have a new field I wish to extract, i.e. “ID” which should result in a new column “_ID” with values, it instead replaces the original id field with the new values, totally ignoring the requested “_” prefix. Workaround is to rename the original values with a prefix before extracting second set of values from nested json.

I have a workbench where I am reading data from a SDE looking for rows updated in the last 7 days then exporting to an excel file. That is working well. I’m also using mapnikrasteriser to create a map and export a tiff image however the new records have no geometry defined so won't show up on my map.  What would be the best option to calculate geometry for those new records?

I’ve successfully exposed a dozen attributes (see green check marks).  Then something changes in the source JSON not allowing me to pull “records.number” and others below “records”.  What’s different? Thank you!! 

Hello  , this is my first post , and I hope  to receive an answer I have in FME an ESRI license that allows me to read from and write to an Arcsde geodatabase . I'm interested in knowing if anyone has successfully edited specific feature classes , made modifications in a workspace (such as adding data , deleting data or moving points to new positions), and then writed the output back to the the same feature classes after editing  by ArcSDE geodatabase  writer.After editing and modifying the data, I understand that in ArcMap, data typically undergoes compression, tracking which data is added and which is deleted.Is it possible to write the output directly to these compression tables ?  Is this step  necessary to do by FME ?Second question :  about writing into Relationship classes I read an  article 

Keeping getting the following error message - Overdue_Emailer: The file 'C:\\ProgramData\\Safe Software\\FME Server\\repositories\\GIS\\Test send Email/Overdue.xlsx' could not be found. It is required to form the content of the attachment Overdue.xlsx Works space created in workbench and published to server. Works fine if a run from workbench and I can see the .xlsx files that are the attachment in fme server repository but still getting an error

Hello,We are using FTPCaller to connect to our SFTP Server via OpenSSH Agent as per the instructions in this article:https://support.safe.com/hc/en-us/articles/25407554321805-Using-a-Private-SSH-key-with-FTPCaller-to-Authenticate-an-SFTP-Connection-for-FME-Form-and-FME-Flow-on-Windows-Systems The authentication is not a problem and we are able to log into the SFTP server, but we are having problems downloading files with spaces in their names, we are trying to download a file named:LB Daily Course Raitings_202409130404.csv the URL set up in the FTPCaller is:sftp://sftpip:2222/Test_Folder/LB Daily Course Raitings_202409130404.csvWe keep getting the error t

Hi all,As part of a development of some routines, I have created a many tab excel file where i inserted Formulae using the AttributeManager and the Cell.Formula naming convention. Due to the nature of the VLOOKUPS i used (dynamically i suppose), i could not do this calculation in FME's Arithmetic Editor.Opening the excel sheet shows the values i do want, given by the formula in the cells. However, when i now come to read this sheet in my next routine, the values are all shown as <missing>. Has anyone encountered this before or have any ideas?Thanks all, kind regards,Jack

Hi all,I have created a custom coordinate system and placed it in the FME documents directory but I can’t access that in CSMapReprojector transformer. Has anyone dealt with this issue? Looking forward to your responses. Thanks