FME Form

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

I’ve alluded to my question on a few other posts about FeatureWriters:When FeatureWriter fails there is no output | CommunityAdd a Rejected port to FeatureWriter | CommunityBut figured I’d ask a more directed question in its own posting. I’m in a situation where I want to do some post-processing after writing data to each of my 40 feature types. I have a FeatureWriter for each feature type, in an attempt to catch and do no post-processing for feature types that fail, but continue with post-processing on feature types that write successfully. I’ve come to realize that any FeatureWriter that fails, stops the entire workspace. Setti

I am working with a table from a GeoPackage in FME, reading it and clipping based on intersections between categories. When writing the output, the unclipped parts are successfully written to Writer 1 without any issues in the output GeoPackage. However, the clipped parts are written without geometry, even though I can see the attributes correctly in the visual preview on the attribute expose just before writting. I'm confident that I’ve set the geometry type correctly in the writer. What could I be missing here?    

Hello, i have a question for a scanner. the scanner drive through our city. the scannner makes a couple of rounds per day. But i have many record with a timestamp. between the rounds there is a time diffrent say 1 hour or more. how can i crerate a round number that the scanner makes.for example the scanner start at 7.00 en ends at 10.00  (thats round 1) and then starts at 13.00 and ends at 16.00. (thats round 2) the next day is somewhat the same but the count must go on. Beste Regards Robert

When I update one of my destination folders for my writers, all of the writers are updated to run to the same folder. I don’t know why this is happening.When I try and run the workbench, it runs like normal but then as it’s writing it comes with an error: “CSV writer: Failed to open file 'C:\D_xxxxxxxx.csv' for writing.  Please ensure that you have sufficient privileges to write this file.  If the file already exists, please ensure it is not open in another application” after it has written the first file to the folder.This has only been happening since I upgraded my ArcGIS Pro to a newer version that isn’t supported by my current version of FME (which I need to maintain to match the clients version).Any help would be greatly appreciated.