FME Form

HiAttached is workspace what wrong with it, as I can't write the output in to feature class inside esri gdb. 

How to convert the neatest distances in neighbour finder to individual lines?

Hello,Is it possible to transform a table (ie from Postgresql, or Excel) into this complicated Json format within FME please? I have attached the json file and also a small dummy sample excel file (which doesnt quite have the correct column headers as its a work in progress).I am completely new to JSON and I have done the JSON Templater tutorial but no idea how to actually apply it to my needs!!Help wanted!!

Hi,I am having trouble reading the names of the groups with which the layer is shared in Esri Enterprise. I am using an HTTPCaller with the following settings, but the Share info does not appear in the JSON response.The only information I get is:   "access": "shared". Could you please advise on how to retrieve this information?

Hi  Please advice on the best option(s) for data store that FME can read and write to, also one that Power Bi will be able to read and connect to.The data to be handled has no geospatial element to it. Thanks

Hi there,I recently installed ArcPro 3.2 on my machine with the data interoperability extension. Looking under the hood, the data interoperability extension uses this FME version, FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64). When I use the WorkspaceRunner transformer to run a simple workspace (read a text file and view in inspector), the transformer fails to read the published parameter, is says "Specified workspace has no parameters or could not be read". If you run the workspace using the workspacerunner, it gives you an error, "2023-08-03 14:20:14|  2.3| 0.0|ERROR |WorkspaceRunner_ExecutorAndRouter (TestFactory): An error was encountered evaluating a TestFactory test: An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner_df4bad67_c886_4b16_8145_a18050c02ff01_runner {} {F:\\ETL\\TEST\\Workbench\\TESTING/workspace1.fmw}' -- unexpected token "END" at position 0; expecting VALUE". Is this an

Hello All,I’m having an issue where SchemaMapper prefix whitespace (space) when using fmeexpression=.I attached a sample workspace and would appreciate if anyone could test before submitting ticket. This issue came apparent after upgrading to FME 2023. for example: col0=’2’, col1=’3’-->using “fmeexpression=@Evaluate(@Value(col0)+@Value(col1))” returns value “ 5” or “fmeexpression=@Evaluate(@Value(col0)@Value(col1))” returns value “ 23”Previously, using “@Evaluate([return “@Value(col0)@Value(col1)])” returns value “23”. I know 2023 introduced new functionality to SchemaMapper, per transformer help doc and https://support.safe.com/hc/en-us/articles/25407523665165-SchemaMapper-Advanced-Schema-Mapping.  Would appreciated if someone could test before submitting ticket. Output SchemaMapperDoc 

Hello! I am having some trouble overwriting a hosted feature layer on ArcGIS Online that is public and has editing disabled. I have a geojson file that is updated fairly regularly and I would like to create a workflow that reads the geojson and writes it to an AGOL feature service. I have that initial-publish workflow down, but after I log onto AGOL and change the feature service to public (sharing) and disable editing, subsequent runs of my FME tool fail and produce an error stating,  "Feature Service 'xxx_layer' does not support writer mode ''. Its owner may have disabled inserting or editing features. Writes may fail if the current user is not the owner or administrator". That error makes sense since I've disabled editing to the feature service, but I'm wondering if there is a way for FME to overwrite the feature service without me having to enable edits on the AGOL feature service. Because the data is public facing, I cannot allow edits to be enabl

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

I have about 500,000 building footprints that are collected to varying degrees of accuracy. I would like to true these footprints so the corners are either 45 or 90 degrees on the polygons as depicted below. Is there a means to do this using FME desktop? The corners are typically within +/- 5 to 10 ground units of being true.  Before:After:

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 everyone,I have a question about the Reprojector. In the reprojector in FME Form, my desired coordintion systems are available:  But when I publish it to FME Flow, some of the coordinate systems are not available to select from: Could you please help me to solve the problem? Thanks!

Hi all,FME supports writing to USD file, but there is no option in the reader for USD.  How would I go about reading a USD file in FME? Thanks,Michael

HiQuick question before I fall back on trial and error, because my dataset is quite big, but does anyone know if changing the partitioning attribute order on a partitioned parquet writer determines the partition folder hierarchy?  The doc says its the schema order which determines the partition hierarchy, I’m hoping to override the reader’s attribute order.  I’m hoping manually editing the writer attribute order will determine partition hierarchy.  Thanks.

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, 

Quick and easy question I hope: does FME 2024.2 support the new ArcGIS Online data types (Date Only, Time Only, Timestap Offset and Big Integer) as described here: https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/time-is-on-your-side-with-new-field-types-in-arcgis-online/

Hi!I’m running FME Form (2024.1.2.1) alongside ArgGIS Pro (3.3.0) on a VM. I have one complex workbench that contains an ArcSDE Geodb Reader (amongst other Readers) that  runs successfully within FME Form. While trying to call the workbench from Windows Command Prompt the translation fails. Inside the application log file the following messages are displayed:|INFORM| The Esri product license used by this machine does not include licenses for the ‘ArcServer’ licensing level|ERROR| Unable to load a library in the folder: C:\Program Files\ArcGIS\Pro\bin. The error number returned from GetLastError is: 127|WARN| An error has occured. Check the logfile above for details|INFORM| Translation FAILED with…I can successfully run other workbenches that do not contain the ArcSDE Geodb Reader from Windows Command Prompt.I’ve verified the Environment variables, for the PATH to have my FME installment, for having an ARCGIS_LICENSE_FILE variable pointing to my ArcGIS licensing server to see if I can f

Hello thereI wonder if I can delete, replace, etc features in the published FS layer (ArcGIS portal) using FME.I think FME is not able to access the Portal Feature Service Layer that supports Web Scene Layer.I am using FME form 2024.Thanks 

Hello everyone,I have a question regarding the fme_feature_type. I encountered a problem in my workspace regarding the SchemaMapper which (after working properly before) gave me the following error:SchemaMapper_Mapper (SchemaMappingFactory): A required column was not found in the table. Row fme_feature_type will be skipped. After doing some testing I realized the attribute fme_feature_type was <missing> across the board in this particular conversion which I believe is required for the SchemaMapper to work. I’m somewhat stumped because sometimes the workspace functions properly and the attribute has proper entries. I noticed especially with larger datasets that fme_feature_type just goes missing between transformers. Some culprints that I found were for example the SubstringExtractor and the AttributeKeeper. The data goes in with fme_feature_type properly filled and comes out with the data missing.I don’t think this is expected behaviour but maybe someone can shine some light on w

Hi All, I am trying to gather information on upgradeable transformers and see that current version is available as part of fmw file extension. I want to know where does it get the information on latest version, Is this information saved somewhere. In this example, AttributeManager is currently at ver 2 but latest version is ver 4. I am not sure where this version information stored. 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