FME Form

Hi there, I have a workbench published to FME Flow. In the workbench I have a SharepointOnlineConnector which reads in an Excel Sharepoint spreadsheet, and downloads it to my shared data source in Flow server.  The workbench runs successfully and the output (a table in ArcGIS Online) says it has updated, however the values are all old data.  When I run the workbench manually from Form, the SharepointOnlineConnector reads the current data in the Excel.  Any pointers on how to get Flow to read the current Excel Sharepoint?

I am writing to a file gdb, I will need to run my workbench to update this file gdb each month. The schema of my incoming tables may change so I have used a schema scanner with a dynamic writer.I want to use drop and create for table handling but it is not behaving as expected. Instead of dropping the existing feature class it just appends the entries to the existing table.I am not sure why this is happening. Of note, my feature classes are also within feature datasets. See attached screenshot of writer settings.  

I’m trying to follow the FME Form course from a MAC and one of the very first exercises is using a Esri Geodatabase (File Geodb Open API) writer. Unfortunately I’m getting this error on the platform. Is there any workaround for this?

Error: “the number of points is less than required for feature”,  We are extracting data from CAD files. The destination is layers stored in ESRI file Geodatabase. Copying the features from the generated layers to other enterprise geodatabse layers result in the error below:  CAD file: http://www.mediafire.com/download/ii2dszjoo4zoij4/AsSamou_Hebron_MasterPlan_05_X_03.dwg    Workbench   Extracting the Roads polygon (Roads = Boundary – Landuses)    

Hello! I'm working with one of our legacy systems built in Microsoft Access, and I need to extract data from a query. So far, the only method I’ve found involves using the system caller and command prompt. Are there any alternative ways to achieve this?I've tried using the system caller, but I’m encountering security issues with the runtime version. It appears that I need to set the location as trusted, but I can't do that with the runtime alone. We're aiming to avoid installing the full version of Access, so we're limited to using just the runtime.

I am trying to upload a tif stored in my PC locally to the contents in arcgis online. I can upload the shapefiles efficiently but not tifs. Can someone advise? Thanks!

I have lines and their vertices should be written to XML (using XSD-driven XML-Writer).I extract the vertices coordinates into lists using the “coordinate extractor” .Now I need to find a way to output those coordinate pairs to xml, so that the output looks like this:Is there a way using the “list concatenator”?

Good day,I have a featurewriter and I want to give the dataset the same name as the display value (and not the value itself) of a parameter for which I used a choice configuration. How can I do it ?

I am trying to find a functionality within FME that allows me to replace substrings based on a lookup table. Since I have several hundred mappings, chaining string replacers together isn’t really an option.Basically something like an AttributeValueMapper that looks at substrings instead of the whole value only or a string replacer that accepts multiple string/replacement inputs.Is there such a transformer or any workaround to do this?Thank you! 

Hi everyone, I want to create a Esri Personal Geodatabase whose structure is specified in an Excel table. Is that possible? How can I achieve that?

Hello,i’ve recently worked with a raster from a NetCDF file and noticed, that loading the raster in FME gives a different raster than loading it in QGIS or ArcGIS-Pro (see Screenshots).Data can be found here: https://opendata.dwd.de/climate_environment/CDC/grids_germany/daily/hyras_de/precipitation/ My question is why? Has anyone experienced this behavior before?    

I am using SystemCaller Transformer to unzip the folders to particular directory using this command""C:\Program Files\7-Zip\7z" x "@Value(source_directory)" -o"@Value(_unzip_directory)" -aoa" This process usually runs at night as subprocess within a FME Workspace. All Zipped folders are at same location. My concern is it skipped to extract one of the zipped folder. To check if there is any issue with the zipped folder I checked by running the FME process Manually and it worked fine(extracted all the zipped folder).I also checked by running the same through task scheduler from same user with which the process runs at night, and again it worked fine and was able to unzip all the folders. What could be the cause of FME skipping it? Any help would be highly appreciated.

Hello people. I am having an issue that i cannot resolve. I am using the FME for 2 months now. Basically i have a workspace that performs pointOnRaster value extraction, does some calculations based on the result and writes to table/excel file/csv or whatever. Because i want to run this process over 10 000 files i created a workspace runner that loops trough a folder of *.nc files and compares them to one single shapefile containing the points. Regardless of the output format or the different approaches i've tried i am not getting the whole batch of results written in the output. For example i ran the workflow over the first 326 files and the WorkspaceRunner gives me 326 successfully processed entries. But the output file contains only 87 entries. If i run that workspace again it gives me between 67 to 90 entries but nothing close to 326. The log file doesn't indicate any kind of a problem. I've tried to do that with vector files as well, but still i am having the same i

Good day,I have the following parameters in my script:AVE_AVENUEBLVD_BOULEVARDCTR_CENTREPL_PLACERD_ROADEach parameter is set up as a choice, when running the script you have the option to chose YES or NO for each parameter.Later in the script I want to retrieve the parameters for which YES has been chosen. I want to create a new attribute whose value is a list of the parameter names (keep only the letters before the underscore). Let’s say AVE_AVENUE, BLVD_BOULEVARD and CTR_CENTRE are set to YES ; PL_PLACE and RD_ROAD are set to NO. A new attribute called “address” is created and its value should be: ‘AVE’, ‘BLVD’, ‘CTR’. How can I do so ? Thanks for your help.

I’m fairly new to FME and need help to get started on a workbench. I have a text file i need to convert into a readable format. Each line has information about a specific device and should be parsed into separate columns. The blank spaces also need to be removed. What transformer should I use? Any help is appreciated!

Hello,so far we are transforming IFC models to geodatabase feature class, which works fine so far. Unfortunately this IFC export step seems one step to many in the overall workflow and I was asked to change the workflow, so that revit project files can be used directly. As fme does have a revit reader I thought it would be possible, but unfortunately despite trying every imaginable parameter setting for the reader it was not possible to read more than one feature that did not contain some kind of meta data...but the “survey point” instead. The fme documentation also only focuses on how to export from revit to ifc and after wards use it in FME.Is it therefore impossible to transform from .rvt files to a multipatch geometry feature class in Esri geodatabases? Or am I missing something?

I am using the Schema Scanner with a dynamic writer in my workspace and it is awesome except that it often incorrectly identifies some of my integer fields as date/time fields. If I turn off the date/time detection then my actual date/time fields get written as strings or integers. Right now I am running it with date/time detection on and then I put an attribute manager on the schema and find the ones it has incorrectly identified and manually adjust them but I feel this kind of takes away from the dynamic nature of the schema scanner. Is there a better way to do this? I wish I could tell it to ignore certain fields or specify the fields that it should look for date/time in but again that is taking away from the dynamic nature of the bench. 

Using an Esri ArcGIS Online connection and the Esri ArcGIS Online (AGOL) Feature Service reader, I'm unable to read a feature service that has been shared to our organization.When looking at the select form, i’m only provided my user folder and a groups folder. The feature service i’d like to read isn’t owned by me or shared with a group. Is this as-designed or is there another way to read it? Thank you  

HiI am able download files with the ProjectWiseWSGConnector.Now, I want to download files in a flat set, but this does not work for me.If I treat the flat set as a file and try to download it. The translation is successful, but nothing is download.And I can't list the content, because in list mode the flat set isn' visible, since it is treated as a file by the transformer.Any help would be appreciated.

Ran into an error that I don't know how to approach. The full report line is: ERROR |Cannot have multiple factories with the same name. Multiple factories were assigned the name 'blablabla Output Collector' What does this mean and where should I start looking to solve this? I might ad that this error showed up suddenly. I tried to remove the most recent changes but it persists.

Is there a transformer that dynamically identifies features where all attribute columns are empty? This could be done with a Tester, but that requires the attributes to be known, and a new setup for each dataset. I was curious if it can be done “on the fly”.

Hi everyone,I have a feature class in a File Geodatabase that I need to update. I have two sources for these updates: a CSV file with codes of the changed features, which I should use to remove those features from the main dataset, and separate shapefiles for each changed feature that needs to be added back to the main dataset. (I shouldn’t delete and update the whole dataset, I should update the changed features only.)What is the best way to approach this in FME?Thank u in advance for your time. 

Hi there, I am a new user so this may be a newbie error. I have just tried to install FME on my Ubuntu Workstation. It is running the latest version, 24.10.  The latest version that FME lists has isfme-form-2024_2024.1.3.24627~ubuntu.22.04_amd64.debso I downloaded that.  It fails to install with a long list of failed dependencies. Is this install going to be possible?  TIA.Kerry

I have a FME workspace reader that reads in the various attributes of a particular workbench and want to send the results to an excel spreadsheet with one sheet per feature. Each feature has a different set of attributes and can’t figure out how to get each sheet to be only the attributes of that feature.  Do I just need to have a separate reader for each feature_type or is there a way to channel all features into a single reader?

I have a large number of points, which I would like to join by simple lines (point-to-point), minimizing the overall summed length of the generated lines. There's no preferred path, but all points must be connected to each other by a single network of lines.My output just needs to be a set of simple lines.Do anyone have an idea on how to accomplish that, other than grinding it out in a PythonCaller ?CheersLars I