FME Form

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

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 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, 

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

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 behaviou

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:

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

Ultimate Goal: to use FME to test if there are ESRI annotations that fall on top of each other.  Issue being experienced: When the ESRI annotation is displayed in FME Inspector, the annotation has been shifted.  My theory is the “shift” is something to do with the annotation is left justified in ArcGIS Pro and its placement of the annotation is based on a point in the bottom left corner.  In FME the annotation point seems to be placed along the bottom centre.  Question: Is there a way to have FME place the ESRI Annotation based on the same placement point?ORHow can we shift the annotation when being viewed in FME so that it is placed half of the width of the annotations to the left along the annotation axes?   ArcGIS Pro: 3.2.3ArcGIS SDE: SQL 2022FME Form: FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64)FME Annotation Reader Format: Esri Geodatabase (ArcSDE Geodb) 

I use FME Form in different environments for different purposes - on my local workstation (laptop) and also on our virtual desktop environment (VDI, Citrix, headed toward AVD). It was difficult to work across two distinct environments, first with workspaces, but further related to web and database connections.We have OneDrive on both, and while it may not be supported or advisable (but I’m interested to hear from Safe and/or from the community on this point), I have had no (known) complications due to using that for my workspaces and connections. If OneDrive is chatty, or you are concerned about locks or other issues, syncing can always be paused while working within Form.To get the connections working, in Form, I go to Tools, FME Options, Default Paths, and then update the Connection Storage with Database Accessibility: Shared, and set the Database Folder and Shared Key Folder to a location in my OneDrive folder structure. I did this in both environments. If there’s a

Y’all.I have a workspace, that exports a number of database tables to a File GeoDatabase.The workspace uses a FeatureReader and a Writer with three dynamic featuretypes (for point, line and polygon features). The writer is “Esri Geodatabase (File Geodb Open API)”.When I run it in Desktop(Form) 2020.2, it works perfectly.When I run it as a job on Server(Flow) 2022.2, all features issues a warning, e.g.FileGDB Writer: A feature with feature type `HOERSHOLM_Afløbskomponent_point' could not be written I’ve tried running it in Desktop 2022.2, and this apparently doesn’t work either.I’ve tried to upload the workspace from here, but this still fails the same way.The output path is a UNC path to a ZIP file.Does the FileGDB writer have an issue with 2022.2 or any of the above details ?

A client of ours is changing their spatial data format from MITAB to ESRI GDB. They use domains in their GDB and we don’t have an ESRI licence so am unable to read these in correctly with the domains exposed. I have requested the XML to go with it as per what I found in other threads.Is the best way to give it geometry to pop on a map a FeatureMerger with the XML and GDB, matching on an ID they have?I can’t help but think this is a poor way of doing it (it took forever as it’s a large dataset when I tested it), but without the ESRI licence I think I’m a bit stuck for options. Wondering if someone has a better solution.Using FME Form 2024.1Thanks!

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’m converting 135 Revit models to GIS but the coordinate system is not setting (location is Philidelphia but data is appearing in Ohio).  I’ve tried setting the coordinate system (NAD 83, Pennsylvania state plane south, US foot) in the writer and using CoordinateSystemSetter.  Individual models appear properly in ArcGIS Pro.  I’m really baffled by this one; probably something simple I’m missing.

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

I generated TIN by TINgenerator.I would like to procedure to generate TINrelief of CityGML from the TIN.

Hi,I need to set log file path as a parameter. So I ‘ve added User parameter LogFile and linked it to log file inNavigator-Workspace Parameters-LoggingI’m running my workflow as follows:"C:\Program Files\FME2\fme.exe" C:\FME\mz\WybranaSiecPomDgn2k.fmw --LogFile "c:\Folder1\File.log"The problem is, that “c:\Folder1” folder does not exists, and the following error appears:“Unable to open log file `c:\Folder\File.log'. The preceding error has occurred during FME logfile setupProgram Terminating”I was trying to create “c:\Folder1” folder using Scripting-Startup Python Script, but it doesn’t help, probably because FME tries to create log file before Python script execution.