FME Form

Hello,I’m trying to connect hundrets of feature types to different transformers (see screenshot). Connecting them via “Feature Type Connections” window only works if you have a clear mapping/names for your input ports. Connecting them by hand is way to slow and error-prone.I’m sure there must be a better way. Many thanks in advance.

Hi,I have a table (that started life as a JSON table, lists exposed etc) containing multiple attribute fields and rows. One of the fields contains CLOB data, like this:<cmAstLocSpId>148606829</cmAstLocSpId><criticalityDetails><criticalityReasons><criticalityReasonsList><criticalityReason>CMEH</criticalityReason></criticalityReasonsList></criticalityReasons></criticalityDetails><cmOsgridref>NZ30272359</cmOsgridref><cmOsnorthing>523598</cmOsnorthing><cmOseasting>430279</cmOseasting><cmRegion>TEESSIDE</cmRegion><cmRepairRegion>TEESSIDE</cmRepairRegion><cmDnoArea>NP (NE)</cmDnoArea><cmCreatedByUser>DAVID</cmCreatedByUser><cmCreationDate>2023-11-23</cmCreationDate> I want to turn the normal text into column / field headings, and those highlighted in bold into values in the relevant column. eg the first column will be “cmAstLocSpld” and t

hello experts,I am trying something that to some of you may be quite simple so I hope one of you is able to help me out.All i am trying to do is to append/add the value cnt from the inlinequerier to the existing excel file.I am trying to write the cnt value into the count_of_errors value where the incoming feeder name is the same as the destination one (in excel file).thank you,fb

See 12 day old post. I appreciate the gamification of the user base but it is not a game when I have a critical, work FMW that that isn’t working.  There has got to be something better than this support.  Am I not entitled to some level of solution based, tech support for the software fees paid?

I am trying to decode attachments from my layer in ArcGIS Online into a JPEG, and it keeps failing. I tried the workflow in this article (using BinaryDecoder then go into RasterReplacer), but I get an error saying BinaryDecoder (TextEncoderFactory): Invalid Base64 character '137'. Next I tried the workflow in this other article (using just the RasterReplacer) and set the format to JPEG / JPEG2000. Doing that results in the records being sent to the rejected port. With just the RasterReplacer, if I set the format to PNG I can get the images to come through, but I need a JPEG in order to write it to a Geospatial PDF.  Is there another step that I am missing, or some other way to write the attachment to a pdf?

Hello, we have started using FME Desktop with a VPN connection. It takes about 20 -30 Minutes until the programm starts. It remains with the message "Initializing Start Window" the whole time. We have set a new environment Variable like one Post said but there are no changes after that.Has anyone any Idea how can we solve this problem? Thanks in advance!

So I’ve been trying to overwrite a coordinate system in FME, usually I work with EPSG codes. In FME most (if not all ) projections has an EPSG associated with them. When searching for a coordinate system you can just throw in the EPSG code. It’s great.I discovered that one of FME’s coordinate systems (EPSG:3004) by default uses a pretty poor translation to WGS84. I wanted to update the definition so the EPSG code would work better. I defined a new coordinate system in the hopes that when picking the EPSG code it would take my user defined system over the FME one. I found that the only way I could get the EPSG number to link to my new definition was if I actually gave it the same name as the one in FME Any other name and using the EPSG would always revert back to the old unprecise definition. In this case “MonteMario_1.Italy-2”. Of course now I get what looks to be duplicates in the list. Interestingly, no matter which you pick you always end up with the same coordinate system getting u

Hi all,I can’t seem to get the Offsetter to properly take this geometry - it keeps rejecting (properties below).I broke out this to another workbench and it worked find with a simple solid - just wondering what is happening here as I can’t seem to figure it out. The geom. disappears after the offset.Any clues as to what is happening?Thanks! 

Hi,How can I stop the translation if one Tester in my workspace pass 0 features in the ‘Passed’ port? Thank´s

I have FME v2024 with a Floating License. I have Windows 10 Enterprise installed. I am almost out of space on my disk where my "Temp" folder is located.The persistent problem I have with FME is that every time I try to open an XML file, although I do have the reader for it, I consistently get the same 6 errors. I have tried opening other files and there is no problem with those, only with XML files.[1]: HTTP transfer error: Timeout was reached[2]: Please ensure that your network connection is properly set up[3]: No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered.[4]:Failed to obtain any schemas from reader 'CITYGML' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information[5]:Workspace generation failed. Parameter file was C:\Users\User1\AppData\Local\Temp\FME_1717067304960_7084.Login

I am creating some attributes dynamically, which are then present but unexposed. I will not know the names of these attributes in advance. How do I expose them so I can do some downstream processing with the attribute values? I can’t use the AttributeExposer since I don’t know the attribute names in advance.

I am on Form 20240521, build 24219 on Windows 10 and I am getting the error stated in the title. Following the discussion in I checked my path. FME is in the path and the path currently has a length of 1652 characters.The plugin directory exists and there are 62 directories and 400 files inside…The error warning shows up several times, two times in relation to two different FeatureReaders (version 14) .FeatureReader 1:format: shapefile error: Error prepending 'C:\Program Files\FME_23781\plugins' to path environment variable.FeatureReader 2:format: geopackage error: Error prepending 'C:\Program Files\FME_23781\plugins\gdal' to path environment variable.The next time the error shows up is in relation to a FeatureWriter:format: Esri Geodatabase (File Geodb) error: Error prepending 'C:\Program Files\FME_23781\plugins\..' to path environment variable.Any suggestion on how to deal with this, apart from what was mentioned in then earlier thread?

I need to create unique Ids for a point feature class. Also, when a new point is added to the class I need to the unique Id created automatically when the workspace is run. I have created a workspace that includes the File Geodatabase Point Feature Class Reader then the Counter Transformer to create a new field named _count and a new field in AttributeManager named Facility_ID.  All the unique Ids will be formatted as follows: BLDG-000000001, BLDG-000000002, etc…When a new Building Point is added to the Feature Class, the Facility_ID field will automatically be populated with a unique ID in sequence increments of 1; example if the highest unique id in the feature class is BLDG-000000109, then when a new building is added it’s unique id will be BLDG-000000110. What else do I need to do? any assistance is much appreciated.   

We have FME Flow (Windows 2024.0.1) installed in an EC2 instance in a VPC. The DynamoDB reader uses the public endpoint: dynamodb.<region>.amazonaws.com.Can this be modified to use a VPC endpoint?For example: vpce-0a06cf963f9d04a28-3wilx6xm.dynamodb.us-west-2.vpce.amazonaws.com We need to do this for all AWS endpoints, S3 and SQS.Thank you,Kathy

Anybody tell me what I'm getting wrong here? Document Link path is valid. No errors in the FME log but attachment not found in the http response? 

I have a 3D buffer that I want to clip with a 3D object. If I use the 3D clipper then it will be only clipped in width, but not in depth. Any solution for this problem? 

Hello,I have the JSON string format like this “[[{"name":"Column1","value":"Value1"},{"name":"Column2","value":"Value2"},{"name":"Column3","value":"Value3"}], [{"name":"Column1","value":"ValueA"},{"name":"Column2","value":"ValueB"},{"name":"Column3","value":"ValueC"}]]”And I would like to convert it to table like:------------------------------------------------Column1 | Column2 | Column3Value1    | Value2     | Value3ValueA    | ValueB    | ValueC Is there any transformer can help me to do so?

I’m running FME Form 2023 and creating a new script with a reader wich fails when looking up tables. Message given: Failed to retrieve feature typesCould not open the enterprise geodatabase because the local version of arcgis is not compatible with the server's SDE version.On the laptop I have both Arcmap 10.7 and ArcGIS PRO 3.1 (AGP) installed. When creating the reader I use a connection file created in AGP. I also have FME 2018 but this is 2023. The reader is defined as “Esri Geodatabase (ArcSDE Geodb) / Embed Connection Parameters” as the geometry format in the database is ST_GEOMETRY. To me it looks like files from ArcGIS 10.7 is found and used which doesn’t work. Is there any way to force FME 2023 to use “library files” from AGP 3.1 or is there another way to solve the problem?

I am currently working on updating and maintaining a workbench from a previous colleague and am having a little trouble with adapting to a certain aspect of the output schema that we need to follow. The shapefile that we are reading from has multiple very close together lines representing the different vertices of a kerb feature, anywhere from 2-5 lines. Without manually removing the excess lines, is there any way to only keep the lines that would represent the back-of-kerb, or rearmost line.

Hi FME'ers,I wanted to write up a brief guide to connecting transformers (and other objects) on the FME canvas, and rather than making a full blog post out of it as I've done before, I thought I'd experiment by posting it in the forums here.So here's a quick guide to the shortcuts for connecting transformers. I'm hoping that it covers any techniques you might not be aware of. Guide to Connecting TransformersMethod 1: Drag and ReleaseI'm sure you all know this method, but here it is anyway:You drag a connection from one port and drop it at a second port.Method 2: Quick Add with InsertHere we have a connection between a reader and writer feature type. The workspace author wishes to place a transformer between them. Rather than place and then connect the transformer in a number of steps, the author can do it in one by pre-selecting the connection:In other words, whatever is selected when you use Quick Add, that's where the transformer is placed.Method 3: Drag-a

I am joining a data table with polygons, via a FeatureJoiner using a common value between the two datasets, both data sources come from a sql database. I am outputting a spatial table (the polygons, joined with the data) to another database.I am encountering a strange issue when I try to open this data with ArcGIS Pro, I have never come across this before - The ESRI_OID does not exist. I was not aware this was required previously either.This is causing various issues with viewing the data and publishing it, or joining it within ArcPro. I am getting this error on the esri GIS server when I try to view the polygons/or view the table. here is what the output data rows look like:It is a very simple dataset with geometry. I’ve never had to make esri_oids before in any of my workbenches, does anyone have any insight to what might be going wrong?  

I have a snowflake connection that works perfectly on desktop, and most of the time hangs when I push it to FME server. My connection to snowflake is a service account with a username and password. I am using the SQL executer transformer to run a query against a table of shipping data in snowflake. I have also tried the workflow with the Snowflake Non-Spatial Reader, and the feature reader.Running it on desktop is no problem. Just about any query I throw at Snowflake returns data, even up to 700k+ rows. When I publish to server, the job almost always hangs up right at the point where the query is submitted. I say almost because when I shrink the query down to just 1 or 2 records returned, the job will return that data. Based on this information, I am assuming my connection between my FME server and the Snowflake instance is good. Any thoughts as to what could be causing the jobs to hang?  FME desktop version 2022.2.1FME server version 2022.2.1

I’m trying to dynamically add a suffix to all attributes in two Excel files. The suffix will come from the last 10 characters of each Excel file (fme_basename), which is the date the file was produced. I have not been able get this to work using the BulkAttributeRenamer. When choosing the Action “Add String Suffix”, only constants appear to work. I’ve tried using the Text Editor to dynamically create the suffix in the String dialog. I’ve also tried creating the suffix beforehand with an AttribuiteCreator and choosing it for String. Neither work. I’m using FME Form 2023.2.0.0 (Build 23764). Any insight or advice?

The Swedish DOT offers extensive road data as Open Data. It is packaged in an ESRI Personal Database (mdb) with 120+ tables. I want to dynamically load all of the data into Postgis for local storage.However, quite many fields, scattered in the database structure, are of the type CHAR with a width of 2147483647 (sic!). Of course, no post contains that many characters, and FME tries to convert these fields to VARCHAR with the same width. This breaks the translation with the message that the type VARCHAR cannot exceed 10485760 characters.So in short, I need a way to filter and catch all tables with fields of the type CHAR, with a width of 2147483647 and alter the width to either the actual content of the field, or a static value that does not truncate what's in there.Regards, Mats.E

Hi, I have a JSON return form a HTTPCaller with schema info. An example of the return looks like this:{  "name": "Administration",  "properties" : {    "Id" : {      "type" : "number",      "required" : true,      "description" : "The given Id for the object"    },    "GeoType" : {      "type" : "string",      "required" : true,      "description" : "The type of object"    },The json continues here with more schema info.I want to turn the information into a table like this:  I have 82 other JSON returns with the same layout but other “name” values and exposing them all takes to much time. I have tried to use JSON transfromers but so far no succes.Is there a more dynamic solution to transforming the return to my desired solution?Thanks in advance,Sander