Transformers

I have a workspace which writes multiple tables to a single Geopackage. When running manually it works with no errors but when running via tasks scheduler it fails with the following error: OGCGEOPACKAGE writer: A file system object called '\\xxxx\output.gpkg' already exists.2025-02-10 07:35:51|  25.2|  0.0|ERROR |OGCGEOPACKAGE writer: Unable to open or create file '\\xxxx\output.gpkg'.  Please ensure the specified file exists and is accessible2025-02-10 07:35:51|  25.2|  0.0|ERROR |OGCGEOPACKAGE writer: An error has occurred. Check the logfile above for detailsHow can I avoid this happening? Is this happening because multiple writers trying to access the same GeoPackage file simultaneously, causing a conflict? Thank you!

Hello everyone, I am reaching out because I have run into a problem recently and searched through previous thread and couldn’t quite find my issue with a solution.I am running into a hang up when I run a workspace that triggers an additional workspace through FMEFlow using FMEFlowJobSubmitter. I will paste an example of what the log looks like. FMEFlowJobSubmitter: https://your.specific. - Submitting a request to run workspace 'Your-Workspace' in repository 'YourRepository'…FMEFlowJobSubmitter: https://your.specific - Failed to submit request to run workspace ''Your-Workspace'' in repository 'YourRepository'FMEFlowJobSubmitter - 'Failure when receiving data from the peer' My workflow is submitting around 70 jobs so after this error occurs around 15 times the error switches to:Error: Failed to update access token.FME Flow error: `FME Flow error: `929026:Error: Connection reset''FMEFlowJobSubmitter: https://your.specific - Failed to submit request to run workspace ''Your-Workspace'' in r

Is there any possibility to use an if statement similar to the xmlTemplater: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/xmltemplater.htmThe following code in the jsonTemplater returns the error "JSONTemplater_2(XMLTemplaterFactory): The following error occurred near line 2, column 50 of the query:JSONTemplater_2(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)"Suggestions and code samples would be very welcomed.{    if (fme:get-attribute("IS_GRENZPUNKT") eq "1")    then        "1": {}    else       "2": {}}

I am getting some really strange results when trying to offset aggregated lines. The fat red lines below are aggregated. This is sent to an OffsetCurveGenerator, thin pink lines. In this instance it seems like the OffsetCurveGenerator treats the lines as individual parts and offsets them to different sides (I am looking at only left channel out here). In other cases it fuses the lines into unities that can not be restored afterwards with a Deaggregator.Any ideas on how to resolve this, or workarounds?Edit: I went back and checked the geometries in the examples below, there where to complaints in the GeometrValidator. This is a spinoff from my previous thread:    

I have this XML that I want to update:1<?xml version="1.0" encoding="UTF-8"?>2<batch name="Simple Batch" default="root">3 <!-- This is the starting task -->4 <target name="root">56 <openmodel file="c:\\temp\\test.smc"/>78 <updatemodel file="c:\\temp\\test.ifc" with="c:\\temp\\test.ifc"/>910 <savemodel file="c:\\temp\\test.smc"/>1112 <exit/>13 </target>14</batch>I want to read other files, for example, test1.ifc and test2.ifc in FME, and I want to add them to the XML to be like this:1<?xml version="1.0" encoding="UTF-8"?>2<batch name="Simple Batch" default="root">3 <!-- This is the starting task -->4 <target name="root">56 <openmodel file="c:\\temp\\test.smc"/>78 <updatemodel file="c:\\temp\\test.ifc" with="c:\\temp\\test.ifc"/>910 <updatemodel file="c:\\temp\\test1.ifc" with="c:\\temp\\test1.ifc"/>1112 <updatemodel file="c:\\temp\\test2.ifc" with="c:\\te

Am using DateTimeConverter to change date YYYYMMDD into YYYY-MM-DD (CSV File), it is converting it when check on Visual Preview. But when open in excel, does not show it. Seeing FME_Rejection_Code = Invalid Input

Hello, I have 4 excel documents hosted on SharePoint, I am using a FeatureReader taking in a temp download path.  As can be seen the 4 items are being opened successfully in the featurereader, but the data is not grouped in any meaningful way for me to extract and sort out the various excel documents data (which is varying formatting, some have multiple tabs with differing data/headers between them, as you can see there are 14 schemas (total tabs within excel docs), and 1546 generic bits of data (total rows))I’ve read that I can re-group the datasets by using fme_basename but I cannot work out how to expose this, I’ve found the post below, which offers suggestions of how to expose that data. But the solution it offers is not applicable, I am using version  Does anyone know how I can expose the fme_basename?ORIs there a better way to do this?     

Currently I have 23 CoG’s in an Azure Blob container and I want to retrieve only the area of those CoG’s covered by a rectangle that I use as the initiator for a FeatureReader.Unfortunately, the FeatureReader is reading first all the CoG’s in before making the decision where the bounding box is within, and then it returns the entire CoG, where I was rather expecting it would return the part the bounding box is covering.The CoG’s originate from the Copernicus DEM coverage GLO-30, contain overviews, etc…It takes almost 3 minutes for the FeatureReader to process the request. The bounding box is within a single CoG.When looking at the parameters for the COG reader, then I can see there is actually the possibility to set a search envelope. I could feed the bounding box to the envelope, which sadly is missing in the FeatureReader. Is there a way to speed things up? I only want to have the parts of the COG’s covered by the bounding box used as initiator, basically performing a range request.

Hi All,I’m using the JSONTemplater and I am getting the following errors from FME when it parses the root template:JSONTemplater (XMLTemplaterFactory): The following error occurred near line 81, column 59 of the query:JSONTemplater (XMLTemplaterFactory): "fme.get-attribute": function with arity 1 not declaredIn the root template, I have the following starting on line 80:    "Subfeature1Array": [    fme:process-features("Subfeature-First", "xxxNumber", fme.get-attribute("xxxNumber"))    ],    "Subfeature2Array": [    fme:process-features("SecondFt", "xxxNumber", fme.get-attribute("xxxNumber"))    ],    "Subfeature3Array": [    fme:process-features("ThirdFeat", "xxxNumber", fme.get-attribute("xxxNumber"))    ]Both the root features and the sub-features have an xxxNumber attribute.  I am following what is documented in the Help for the JSONTemplater “Selecting the Sub-Features to Process” section example but have no clue what the issue is. Any help would be greatly appreciated!

Hello Community,I have data in the following format:Attribute value field1 a field2 b field3 c field1 e field2 f field3 g field1 j field2 k field3 l Which transformer can I use to transpose my data into this format? field1 field2 field3 a b c e f g j k l  The names field1, field2, and field3 can be dynamic, and their number may also vary

I am using a WorkspaceRunner so that I can run multiple times the same FME workbench on different DNG separately. Just to be clear I will call the WorkspaceRunner to the workbench that runs the “child” workbench, and i will just call Workbench to the child workbench. I was all working fine the first times and now I find that some User Parameter (in my case “DNG”) I was “sending” from the WorkspaceRunner to the Workbench is not working anymore (I didn’t change the parameter in the WorkspaceRunner but maybe i used it in more places inside my Workbench). When I run it directly inside my Workbench it makes no problem. But when I run it from the workspacerunner the following error appears:  ERROR : Undefined macro `DGN' dereferenced in file `G:\Buzon\Miguel\CQ_topologia_copia\wb-xlate-1738321227449_8672'I think the wb-xlate is a temporary file of some sort. I have a wb-xlate in the root of the project but not the name does not match the one appearing here. That wb-xlate actually contains th

Hello Everyone,I am trying to use RCaller in FME 2024.1.3.0 with R version 4.3.3.To get started, I followed the tutorials, but in every case, the script gets stuck at RCaller. There are no errors or warnings—it simply does nothing and keeps running indefinitely.The last thing I see is: It seems that the connection to R.exe is working.Does anyone know what beginner mistake I might be making?  

Hi All,Need your help fix the below scenario,I have a dataset approximately 100,000 records and these records have Polygon geometryI am using "aggregator" transformer to group the records as per column attribute and it creates 100 aggregated records.My requirement is to show each aggregated record as 1 shape on the map when user clicks on it.Issue: I am facing issue with geometry aggregation. When I plot data on ArcGIS online, I see all 100 aggregated records, but see some empty spots on the map.If I plot the same data on map without aggregating it, it plots fine.looks like something is going wrong with geometry aggregation.Would really appreciate if you could provide some input on how to handle it.Below is the configuration of my Aggregator transformer,  Thanks, 

I’ve got a test filter with about 12 different output ports. My goal is to unfilter all of these but have an attribute of “test result” and the value set to which output port the feature filtered through. Is there a way to expose the output port name? I know I could add attribute creators after each port or set one with a conditional statement but was hoping there was an easier way.

I am using FME Form 2021. I have been running two workspaces for about a year now. These upload spreadsheets to an SFTP site. Every once in a while, I get this error message: The FTPCaller Error Message from the Rejected Port:Error in the SSH layer This error prevents the spreadsheets from being uploaded to the SFTP site. Usually, the error seems to go away after a few days with nothing done on my end, and then the workspaces run normally. There does not seem to be a pattern of when the error is received. I checked the Log Files, and they show nothing unusual. I checked with our IT Network Admins, and they say nothing is blocking files from being uploaded to the SFTP Site.  Here is a screenshot of the parameters in the FTPCaller Transformer I use:  Questions:What is the cause of this error?Could the error be on the side of the folks who manage the SFTP site? (outside my organization)Is it a bug in FME Form 2021?Is this error received when using FTPCaller Transformer in FME Form 2024?Ho

Hi, our ArcMap license will expired tomrrow and will not renew after it expired. Also, I have Arcgis pro installed on my machine and the license is valid (will not expire).Currently all of my script setting is set AUTO under the “Esri ArcGIS Compatibility” . Will the AUTO setting  pick to ArcGIS Pro license, after ArcMap license is expired? or do i have to manually set to ArcGIS Pro in each FMW script individually?“FME Workspace, go to Navigator --> Workspace Parameter --> Translation --> Esri ArcGIS Compatibility   --> AUTO”thanks,Wilson

Is there anyone here already converted esri file gdb or shapefiles to mbtiles? I tried but it's giving me this errors:MBTILES writer: Failed to obtain raster from feature. Only features with raster geometry are expectedA fatal error has occurred. Check the logfile above for detailsThanks for the help.

I have been checking a lot on this link but its not exactly what I want. Combine overlapping/touching lines into one long simple geometric line | CommunityI have one geopackage with lines of different types that overlap, 2 attribute types, the blue type and the red. As you can see they overlap.I want the red lines to take priority, meaning where the red lines are the underlying blue lines should be remove so I only have 1 layer of polygons with the 2 types. Note that the length of the blue line doesn’t always match the length of the red so the underlying blue line have to be cut. I have filtrered them, tried line combiner, line on line overlay which generates INVALID_POLYGON_GEOMETRY_VERTICES error.  Reader polylines with attributes TestFilter, filters and splits the 2 types I want based on the type name ??? Before reader im gonna do a snapper since dataset have some gaps some of the read doesnt reach the entire way to the blue in some instances.  Result example (also want snapper in t

The documentation is not entirely clear here for how to upload files to a ACC store using the AutodeskDocsConnector.I seem to be able to upload folders..However when i try to upload files i get an FME rejection message that says. Any ideas?'NoneType' object has no attribute 'status'AutodeskDocsConnector  

I am trying to find shortest distance from all points to all other points in my dataset.the data set contains network lines and points The points feature has only types (A,B).100+ points of typeA and 500+ points of type B.Is it possible in FME  to have the short path finder to search the short path always starts from point A to pint B.Then write the output to writer. 

Hello,I can Successfully connect SharePoint list in workflow , can perform Insert operation with no issues, as soon as Change Detector finds the record updated from Original Key field with Revised Key field values with update transform in SharePoint list, i am getting error for FMEException -  where last part the PRIMARYFIELDError:Python Exception <FMEException>: FMEException: 929309: Microsoft SharePoint List Writer: Client-side error: '400 Client Error: Bad Request for url: https://cambridgeca0.sharepoint.com/sites/DesignDeliveryDigital/_api/web/Lists(guid'0c80c870-8721-4543-9550-0fedbed2eeec')/Items(PPM01256)' returned from SharePoint. Error message was: 'The expression "web/Lists(guid'0c80c870-8721-4543-9550-0fedbed2eeec')/Items(PPM01256)" is not valid.'  

Hi,I have two Oracle tables: POINTS_TABLE and LINES_TABLE. I’m trying to export both tables to DGN.  I’m using “Bentley MicroStation Desing (V8)” writer. In writer parameters, I filled out “Cell library file”, and now I’m trying to do something to fill “CellName”. How should I do it, to have different “CellName” value for POINTS_TABLE and for LINES_TABLE in my output dgn file?

HiI am having an excel sheet like below. I need to group them in Field name route and assign a value for route field .let's say (routeNo)  or any other unique value.the grouping is based on finding a value that is considerable above of other previous records below is 48. which is very big than other previous ones.Any help is highly considered. Route 1Route 2 

My user on the production MS SQL database has an ampersand (&) in their password and FME can't login with it.Is there any workaround for this without having to change the password ?This happens in both FME Desktop and Server.Edit @TiaAtSafe:The password also contains this special characters $&@=Versions:FME Server 2017.1.1.1FME Desktop 2017.0.1.1 (20170512 Build 17291 WIN64)

Hi! I have tried searching for an answer to this problem with no luck, so i thought i’d try making my first post in this forum!I am working with a polygon layer containing cities. I want to dissolve all overlappning cities by removing common boundaries and thus create fewer but bigger areas. The issue i have is that i want to sort this dissolving/mergeing by the population-attributute of the cities. In some cases there are  20+  polygons dissolved into one, and i want to make sure that the output polygon inherits the attribute information from the city with the largest population. I’ve tried using list-arrays of both population and city-names on the dissolved areas with little success, so i am very unsure of how to proceed.  Does anyone have any tips how to solve this?Many thanks!//Andréa