Authoring

I want to run a batch process to load a series of file-based datasets in a folder, do some simple transformations and export each to a database table.  The workspace in the image below is run by a workspace runner.  The complication is that each source has some standard columns and an unknown quantity of additional columns, which need to be loaded into the database as a new table.  If I configure the workspace with one source file, the schema config will not be correct for another file.  How can I set the schema definition to be dynamic?  I’ve been researching the subject but have not found the answer. 

when I am using AnchoredSnapper Reader Cad civil Writer : oracle spatial  Anchor : arcsCandidate : pointsSnapping Type : vertex Snapping it working fine Anchor : arcsCandidate : pointsSnapping Type : Segment SnappingTolerance zeroerror ORA-13347: the coordinates defining an arc are not distinct  same Snapping Distance in both  Why does this error occur when using Segment Snapping, The anchor is not supposed to move even with the Segment Snapping selected

So I was testing the 2025.1 Beta and was curious to try the new DocumentPDFStyler after seeing it mentioned in Seattle a few weeks ago at The Peak of Data and AI 2025. This caught my eye and I cannot find anything about this new “Safeguard”. What is it and why are the run icons disabled and not the same as other transformers (ex: Run from this, run to this...)?  

Hello, I have an AGOL Hosted Feature Layer that contains Fire Hydrants. There are 5,000 points.I want to update from a File Geodatabase with new Fire Hydrants. There are 5,004 points (meaning there are 4 new hydrants that do not exist in the Hosted Feature Layer).In the AGOL Feature Service Writer (highlighted in blue in the screenshot), to update this Hosted Feature Layer, would I use INSERT in Writer Mode? I want to upload only the 4 new Fire Hydrants to the Hosted Feature Layer from the Fire Geodatabase, thus preserving the existing records in the Hosted Feature Layer.  Would I use Truncate Yes or No?    

Can you help us complete this list of URLs used by FME? Some of our users work in environments with limited access to the internet and need to request access to specific URLs via a proxy . We are building a list of URLs used by FME and we are asking you for more input. Below are URLs we know FME may access in typical use. Are there other URLs you think we should add to the list? We will edit this list as answers come in.Of course, there is a multitude of web services you can connect to with FME using Web Connections and the HttpCaller transformer, and we don't want to add them all here. We are looking for URLs used by FME Workbench, standard FME readers and writers, and FME transformers. Please note: You can, of course, run FME without any internet access at all but you won't be able to use the FME Hub or access resources on the web.Workbench Startupwww.safe.com/ *fmestartup.safe.com/Help and docs:docs.safe.com/ FME Hubhub.safe.com:443**fmehubproductionopsworks-appstorage-c2mc0

I don’t know if this is a bug in build 25220, or if it’s the intended behavior. But it’s very different from past versions, and will likely cause issues in our workflows.When the ‘Merge Attributes’ option is unchecked, no Candidate attributes are carried forward in the Passed port as a shown in this screenshot. The Candidate attributes are only carried forward in the Failed port.If the ‘Merge Attributes’ is checked, the attributes are passed: However, the issue is that there is no configuration in the ‘Merge Attributes’ section that will only pass the original attributes from the Candidate. You are forced to either merge the Filter attributes, create a prefix on the Filter attributes (and likely have to remove in bulk post-SpatialFilter), or simply use the Filter attributes. No option will spatially filter the Candidates without altering the schema.I’ve found this behavior in many transformers that have the ‘Merge Attributes’ option, including SpatialFilter, SpatialRelator, PointOnArea

Hello, have bumped into the problem of generic reader not being able to read a GML and have read the literature on how to circumvent this by adding a separate reader as a resource to make the generic reader understand my GML’s. But I cannot get it to work the reader just runs and doesn't find data, no error or warning, Total Features Read 0.,So my GML is pretty straight forward as there is no problem getting FME to read it with a OGC GML reader without needing to set XSD schemas and so forth, just reads it in by default. I have tried various settings in a GML reader that have all worked and then copied that workflow when I add the reader as a resource without any luck.Have I overseen some step here or any ideas what I might be doing wrong? Send hilfen, Hlynur 

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.htmMy 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? 

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

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.

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.1Example 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 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 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? 

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

I’m seeking other users experience with Background Maps in FME Workbench/Form. I use OpenStreetMap.org tiles (and sometimes MapBox tiles) as background maps when following data through a workspace. But more often than not maps take more than 30 seconds to appear, or not all.I originally assumed it was my organisations VPN, or security software agents, or network bottlenecks, but my independent tests on other external systems ruled these out.So I explored other possibilities.Here is a view of network traffic on my machine with a map at the town level. Not much happening.But look what happens when I then Zoom to Extents so the maps scales to all of Australia. Look at the spike in network traffic - some 6MB to draw a map?From what I can estimate FME is requesting hundreds and possibly thousands of map tiles for any given zoom request.What happens next is that OSM will either block or possibly throttle my IP for a period of time.Mapbox seems to perform better, but looking at my stats I’m c

In FME Form 2023.2, we used a dynamic JSON writer setup that wrote a separate file per input SQL file. Each input could have a different schema, and the setup dynamically handled this just fine using: fme_feature_type set from fme_basename (filename sans .sql) JSON writer with Schema from Schema Feature This worked perfectly — each JSON file had its full dynamic schema.After upgrading to FME 2025.0, only the first JSON file is written with its full schema. All subsequent files contain only the subset of fields shared with the first file. Unique fields in later inputs are silently dropped.Example: A.sql has fields: ID, APR_KG B.sql has fields: ID, MAY_KG Result in 2025.0: A.json: includes ID, APR_KG B.json: includes only ID — MAY_KG is missing Nothing changed in the workspace. This appears to be a regression in how dynamic schemas are handled across multiple feature types or files in newer versions.Can Safe confirm whether this change is intentional?

Why does FME Flow (or FME Desktop) store files in the My Documents folder?Why not use AppData\Roaming or AppData\Local? 

This is starting to annoy me - in 2024.2, whenever I create a bookmark around something, FME automatically zooms to it. Is this a setting that can be turned off? 

Something I recently learned about with FME is that each HTTPCaller seems to equate to one session - there are most likely a lot of cases where this isn’t true but I had some weird issues recently where a series of calls working intermittently. The process was creating a document container and then uploading files into it and then closing the container. I used 3 separate HTTPCallers for this. When testing from FME desktop it worked sometimes and others it didn’t work. I spent a tonne of time trying to debug what was wrong in my POST. Finally it seemed like it was working, I published to Server and directly had issues again. Looking into the Debug logs I noticed that with each new instance of the HTTPCaller there was a new connection to the service BUT that connection was going to a different IP. The host was using a load balancer to handle API requests. Turns out my container was being created on one server and my follow up requests were hitting the other server.After I fed everything

I have a workbench which is calling data back for 8 reports via 8 different httpcallers. I can add a date parameter to the URL to call back one date at a time. I have 60 dates I need to individually grab the data for.How can I get it too complete the workbench, move on a day and run it again, and again...and so forth, through a list of dates?

*Aka Data Virtualization Transformers, but with the french touchSince I’ve been publishing a bunch of Data Virtualization custom transformers lately, I figured it was time to make a post about them—what they do and how to use them.FME Flow’s recent update introduced a cool new feature: Data Virtualization.https://community.safe.com/product-updates/introducing-fme-data-virtualization-38066?tid=38066&postid=86#post86This feature lets you build your own APIs using FME workspaces.To make that work, your features need to include certain attributes required by the Data Virtualization writer, such as: response.status_code response.body.content response.body.content_type response.body.content_file_path response.headers{}.name response.headers{}.value Data Virtualization Writer  After manually setting these with an AttributeCreator a few times, I thought: why not create a tool to make this easier?So I made the DataVirtualizationResponseSetter !DataVirtualizationResponseSetterThis

Has anyone run into an using the OGC WFS Reader for a WFS hosted by QGIS Server where the coords are swapped? Before I go back to the provider with the observation “hey I think there’s a bug in how your service is being delivered” I’d like to check that it’s not a known issue etc. To use the service I had to do the following: Thanks for any ideas!

Hello,  How do I add a datestamp to a file name in the Excel Writer? I tried adding @Value(_timestamp) to the Writer output and all I get is the file name Bldg_Pts_@Value(_timestamp) as the file name. No date.   

Hi everyone,I need help, when i upload my shape file in fme which is in gaus kruger coordinate systemI want to change coordinate system into epsg 32634, and when i use coordinate system setter, it changes, but its not exactly how i need it to beSo i need to do something called transformation, and i need help with how to do that, if its posible to do transformation in FME? 

Hello,I have a question regarding the implementation of dynamic attributes.I created a flow to turn a single attribute into text for the actual values of the column and row of an attribute; Following the pattern below: Original AttributeGoalAfter achieving this, the biggest problem is that these 'dynamic' name attributes come as unexposed attributes.Unexposed AttributesI could simply place an AttributeExposer and resolve this case, but the problem is that the flow will run in several different scenarios, and the values (A, B, C, F) will never be the same; they can vary to anything (G, H, T, Z, B, A, or K, LL, BN, XS, D).Therefore, I need the exposer to work automatically as well, but I couldn't make it receive @value(list_name); it literally exposes the value '@value(list_name)' as if it were an attribute with the name of the code. Thank you for your assistance!Best regards,