FME Form

Hello ! I want to extract files wich have everytime a different expression but there is some text who would be everytime in the file name : Example : [200072692_ZONE_URBA_20220412] “ZONE_URBA” will be the text present everytime in my extract file. I want the String Searcher to download the files which only contains “ZONE_URBA” The numbers in the example before and after “ZONE_URBA” will change everytime because they are the number of the EPCI (french administrative numbers) After calling ZIP file from HTTP with HTTPCaller, I use the ZipExtractor to extract the zip file. Then I use the StringSearcher but I don’t know how to configure the parameters to recover only the ZONE_URBA files … Anyone got an idea ? I think it’s not something impossible but i’m beginner. Sorry for my english, I promised I’ll improve !! Thanks a lot Here my work chain :

This is really strange—I’ve never seen this behavior before. After saving and closing my workbench, all other FMW files in the same folder disappeared automatically. At first, I thought I was imagining things, but other users have reported similar issues before. [Post link] Version: 2024.2.1 (Build 24801) OS: Windows 11 24H2 (26100.2894) The only change I can recall is that I recently uninstalled all old FME versions, but that shouldn’t somehow trigger file deletion, right?

I have a MapInfo table which I want to modify by inserting and/or deleting records. I would like to modify the MapInfo table in place. I think that I can use the Precisely MapInfo Extended TAB Writer Feature Type Parameters? https://docs.safe.com/fme/2022.1/html/FME_Desktop_Documentation/FME_ReadersWriters/mapinfo_extended/mapinfo_extended-ft-param-w.htm My software is FME Desktop FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64) But how do I build a workspace that performs this task? How do I build a Writer transformer that recognises an existing MapInfo table?

Hi all, I seem to have an issue with writing to the Temp folder location (E:\\Temp, in this case). I will get an error like the following - Failed to write feature data to `E:\\temp\\wb-cache-NSPL_V3.2_ShortName-rUhMFp\\Main_FeatureJoiner_20 -1 24 fo 0 JOINED 0 6641bd2679d46e05f371fbb029766a8cafbc270f.ffsupdating' I've tried creating a new workspace from scratch, renaming it and I am able to copy files to that folder without any issue. I also ran FME Workbench with elevated privileges and as a different user, even with a different Temp location but no success with any of them. Has anyone here had anything like this occur? And if so, is there a known way to resolve it? I've deleted all Temp files and again, no change. All a bit odd out of nowhere! Thank you

I am having some issues converting a .NVD to .GDB to display in ArcGIS Pro. I can get the attributes all across but cannot view the geometry in FME Does anyone have any guidance on how to transform the geometry so it displays in a geodatabase in ArcGIS Pro? Thanks

Question: Is there a way to speedup the geocoding process or an alternative approach like a diifferent Geocoding service people got good results from? Background of question: I have a dataset of 21.000 adresses and want to geocode them using the Geocoder. Geocoding Service: OpenStreetMapMode: Foward To run the first batch of 500 adresses took approx. 10 minute to run which is not that fast to be honest.

I’m migrating to ArcGIS Pro and working on a workflow to convert geodb_pro_annotations to geodb_annotations so that I can edit/create annotations in ArcGIS Pro and downgrade them so that they can be used in ArcMap and read with a legacy tool (that currently has no ArcGIS Pro upgrade path). I seem to be having an issue writing some of the features to a new local FGDB where the FeatureWriter errors out with the following message: “An error occurred while attempting to create a feature using the feature class 'StreetName_Rural_Smaller_LEVEL_63'. The error number from ArcObjects is: '-2147220947'. The error message from ArcObjects is: {Cannot acquire a lock.}” The data is created/edited in an SDE and exported to a local FGDB for this downgrade. There are 25 annotation features containing 1 to 2,000,000 annotation records. This error seems to only occur on annotation features with more than 500,000 annotation records. The others are able to be written out to the FGDB with no issues. I’ve tr

I have a word template with me and I would like to use that template to create a new document along with the custom content dynamically. Cheers, Srikanth

Hi, I have a CSV file containing ObjectID and associated AttachmentNumber values.I want to group the ObjectIDs so that the total number of attachments in each group is as close to 1,000 as possible.How can I achieve this?

Hi, I use a FeatureReader for two purposes: to clip features with a polygon, and to select some desired geodatabase layers (of several geometry types: point, line and polygon). After the “succesful translation” the new geodatabase has been created. However, this database seems to be empty. What could be possible causes? Wrong Schema/Data Features of the FeatureReader? In the Reader I have: In the Writer I have: Connectiefile is the file where the polygon for the clipping purpose can be found. Other schema sources are not available.Any ideas?

Hi all, I have .shp data sets (100+) which I read with feature reader. The attributes’ values are saved as list ,attribute “ID” for shopA.shp has values as {0, 2, 4, 8} and another attribute “Desc_”: {cake, bread, drink}, my aim is to save them as json file so the json will look: { "uuid" : "1b2299d1-b97a-48d9-9a99-9994491ebb34", "path_directory_windows" : "O:\\M\\A\\B\\", "members" : [ { "base_name" : "shopA.shp", "created" : "20240225", “attributes” : [ “ID”: “long”, “0, 2, 4, 8”, min = 0, max = 8, mean = 3.5, median = 3, mode = None, “Desc” : char(256), “cake, bread, drink” ] }, { "uuid" : "322299d1-b94a-48d9-9a99-99944912bb34", "path_directory_windows" : "O:\\M\\A\\C\\", "members" : [ { "base_name" : "shopB.shp", "created" : "20240225", “attributes” : [ “ID”: “long”, “1, 2, 3, 4”, min = 1, max = 4, mean = 2.5, median = 2.5, mode = None, “Desc” : char(256), “cake, orange, apple” ] }, Thank you so much in advance. Mag

Hi, I’m having trouble retrieving only the number of attachments associated with each Object ID for a layer published to ArcGIS Enterprise. Currently, the only way I’ve found is by expanding the full list of attachments, but this process becomes very slow when dealing with a large number of attachments. Is there a more efficient method to get just the count of attachments per Object ID without having to load the full attachment details? Thanks in advance for any guidance.

​ TLDR: sys.path does not contain FME_MF_DIR, so I can’t directly import a local Python module. This contradicts FME’s documentation. What am I missing? Hi all, I’m having problems importing a local Python module located in the same directory as my FME workspace. Could you help me find out what the problem is or am I missing something? According to the PythonCaller documentation, FME will search both the standard Python module locations and the workspace location to find the module to be imported. However, when I try to import my module in <workspace directory>/feature_processor/__init__.py with the following code: from feature_processor import FeatureProcessor I get the following exception: Message Type: fme::internal::_v0::py::ExceptionPython Exception <ModuleNotFoundError>: No module named 'feature_processor'Error executing string `from feature_processor import FeatureProcessor'Factory proxy not initializedFeatureProcessor (PythonFactory): PythonFactory failed to process featureAn e

I'm working with FME 2021 and have run into a challenge regarding dynamic GeoJSON handling. I use the HTTPCaller to retrieve GeoJSON from several hundred different services. Each service returns features with different attribute schemas. My goal is to dynamically expose all attributes and the geometry from each GeoJSON response and write them to various formats (e.g., GDB, Shapefile, etc.). I've tested workflows using JSONFragmenter and manually selected attributes, but this approach doesn't scale—it’s not feasible to manually configure the schema for hundreds of unique GeoJSON sources. Is there a robust and dynamic way in FME 2021 to automatically expose all properties (attributes) in each feature, regardless of schema, along with the geometry? Appreciate any guidance or best practices for handling this kind of dynamic schema in FME 2021.

I need to get from an Excel configuration file a parameter for the Buffer distance of a Bufferer transformer. What’s the best way to do this in order for the parameter to be accessible by the Bufferer transformer ? I have tried the VariableSetter and VariableRetriever transformers but what I don’t like about it is that I give the value to every feature that passes through VariableRetriever. Plus the VariableSetter/Retriever method doesn’t work well with cache.

I want to publish feature services to arcgis enterprise portal not using ArcGIS Pro [Share ribbon] tools. Is FME an appropriate tool for this or is it better to use arcpy and the arcgis python API? The source feature classes are in SQL Server in Enterprise Geodatabase. The GDB is registered with Portal as a datastore. We do not want to copy the data to Portal (the resulting feature services should not be hosted).

I was extracting tables from a PDF file by following the steps in https://support.safe.com/hc/en-us/articles/25407564475277-Extracting-Text-and-Tabular-Data-from-PDF#h_01HW3Z9Z37Q33NQQ7R0XBGEVB0. However, I encountered a challenge some words are misspelled or broken when extracted, even though they appear correctly in the PDF viewer. I suspect this is because the PDF was exported from a graphic design app such as Adobe Illustrator. I realized this when I copied text from the PDF and pasted it into a Word document the same issue occurred (correct me if I’m wrong) is there a transformer can help fix or reconstruct the text?

We need a way to detect/test for Arcs in our Esri SDE database. We manage a large road line segment. The system that uses this data does not accept Arcs, just polylines. Previously, we edited our data in ArcMap, then run a nightly job to check our data in FME. Using the PathSplitter, followed by the GeometryFilter we could then find any Arcs that had been introduced into our data. Now that we are editing our data within ArcGIS Pro, it seems that Arcs show up as an Arc within Pro, but in FME, the segments show up as Lines and are not flagged with the workflow, mentioned above, using PathSplitter and GeometryFilter. How can we filter/test to find the Arcs in our data? UsingFME 2024.1ArcPro 3.2.3ESRI SQL SDE 10.9.1 Example Arc attached in FGDB. Then the Feature is opened in ArcPro, and an edit session is started to ‘Edit Vertices’, we can see that there is a verity that controls the curve of the line.

Hello, I want to replace the list of attributes of the ChangeDetector with a user parameter. The attributes of the original and revised features are not exposed. The user parameter is in Python: it's a string derived from another parameter (example: 'field1 field2 field3'). I don't get any error but I guess values are not considered. I have the same problem​ with other transformers based on the same attribute list type (AttributeExposer). It is an issue or a problem with the string? Thank you

Hello, I am having difficulties creating a spreadsheet with 2 sheets. In the screenshots included I have 2 Excel Writers. I have chosen Fanout Dataset since I want the file name to include a timestamp. The workspace runs successfully. But only a single sheet in the spreadsheet is written. Daily Totals is included as a sheet in the spreadsheet, and Running Total is not. What do I need to do in order to include both sheets: Daily Totals and Running Total (seen as two Writers in the screenshots below). When I do not choose Fanout Dataset, the two sheets are written to the spreadsheet, but the file name has no timestamp. When I use Fanout Dataset one sheet is written to the spreadsheet and the file name has the timestamp. My workspace includes the DateTimeStamper Transformer that creates the _timestamp attribute. .

I need to transfer a PG table that has a geometry (line) field in below format, to another PG table on another database using FME. I know it’s already in the workable final format. If I just run queries as below and save results directly to the target database using DBeaver, it works fine. geomfromewkt(comm_path_line_geo)::geometry as sp_geometry But somehow it’s not working on FME to transfer from one to the other. I tried SQLExecutor alone and also with GeometryReplacer. I tried queries inside SQLExecutor this way: select geomfromewkt(comm_path_line_geo)::geometry as geometry from my_table and this way: select comm_path_line_geo::text from my_table and then to process with GeometryReplacer and also this way:select comm_path_line_geo as sp_geometry with this, the FME transformer would convert automatically convert it to binary geometry format but it’s not usable at the end tool. They all didn’t work. Can someone please help? I know this shouldn’t be that difficult because it's already

I am trying to create a webservice to access Sharepoint. FME has been registered in Azure but when I try to set up the connection the conditional access policy blocks my connection. It looks like it has something to do with the way the http user client provides info to Azure. With the FME default http user agent you just get a blocking error, with the system default http user agent you get this: It looks like the http User agent does not provide the device ID (apparaat-id): Not available (niet beschikbaar). The conditional access policy demands a registrered device so it blocks this connection. I can make a Azure connection directly from Chrome or Edge in other apps. what is the way to a solution for this problem?

Hi, I am facing the problem mentioned in the title, especially when I want to detect Self-Intersections in 2D. FME detects a lot more Self-Intersections while PostGIS is fine with the geometry. What are the reasons? As we want to build up a standard quality gate for our data, I need to be certain that both ways - either using PostGIS or FME - act in the same way. What is the configuration then for FME to match the behaviour of PostGIS’s ST_IsValid function? Thanks in advance! :-)

Hello, so we regularly download the whole catalogue of polygons for England, seen here: Dataset Download - Use land and property data I would very much want to automate this as its a tedious task to manually download them all one by one, so I’ve investigated the calls that my browser makes when calling this data and it first sends a very simple call to very simple URL’s containing the Zipped data, as seen here: https://use-land-property-data.service.gov.uk/datasets/inspire/download/Amber_Valley_Borough_Council.zip Which in turn takes you onward to a Amazon service that just gives you 60seconds to fetch the data, as seen here: https://datapub-prd-s3-bucket.s3.amazonaws.com/inspire/Amber_Valley_Borough_Council.zip?response-content-type=application%2Fforce-download&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIASNNJI2YGUWCWQTWF%2F20250522%2Feu-west-2%2Fs3%2Faws4_request&X-Amz-Date=20250522T125638Z&X-Amz-Expires=60&X-Amz-SignedHeaders=host&X-Amz-Signature=c8a0384597f39f35e7be798cff4

I have 7 features, which each represents a route with unique trip_id. Each of these features have a list, containing buss_stop_id along the route and element index, as well as next sequence value. I want to add, either in the list or in the features after list exploder, the value for the buss_stop_id for the next one. I played around with list builder and exploader for a long time and cant figure it out. Tried some ugly solution @Value(_list{@Value(_list{0}.next_sequence)}.buss_stop_id) but did not worka s intended So in my example I want the end result to be something like next_buss_stop_id an attribute in _list{1} which is the buss_stop_id from _list{2} Meaning _list{2} = buss_stop_id = 363, next_buss_stop_id 364