- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27667 Posts

neaContributor

IS MY 12 DAY OLD POST EVER GOING TO BE ANSWERED WITH SOMETHING THAT WORKS!

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?

1342

6 months ago

jfisch25Contributor

asked in Data

Read ArcGIS Online attachments and Maintain GlobalID's for both features and attachments

I'm trying to write AGOL features and attachments coming from a feature service tied to a Survey123 survey into a SQL Server geodatabase. I've looked through most of the tutorials and questions about this, but in my use case I need to maintain Global ID's on both the features and the attachments. The feature GlobalID's are being used to name photos that get stored in S3, so I can't use the examples that use a counter to create a new relational ID. I have set the "Maintain Global ID's" parameter on the AGOL reader and have exposed the AGOL attachment attributes. The attachments have a Global ID and Parent Global ID, and I figured it would be simple enough to use both of those to create the relationship class in the GDB since that's what the AGOL service is doing. When I query the service, I can see a feature's Global ID and the attachment's Global ID and its Parent Global ID (the GID of the feature it's attached to). Feature popup: Quer

54913

6 months ago

rfacendini

asked in Transformers

How to decode AGOL Attachment to add to Geospatial PDF

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?

432

6 months ago

datamanContributor

asked in General

FME Desktop using VPN Connection

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!

865

6 months ago

virtualcitymattCelebrity

posted in Data

Overwriting EPSG definition in FME

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

250

6 months ago

jp12212Contributor

asked in Authoring

Moving to zero issue with geometry with offsetter

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!

784

6 months ago

mr_fmeEnthusiast

asked in Data

Stop Workspace Execution

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

432

6 months ago

kyp4810Contributor

asked in Data

What version of citygml can I upload to fme?

Can fme only run up to citygml 2.0?I don't know the part about uploading citygml 3.0.

1204

6 months ago

monitotierContributor

asked in Data

FME Errors when opening xml

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

1447

6 months ago

aaronContributor

asked in Transformers

How to expose dynamically created attributes not known in advance

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.

732

6 months ago

tb09114Supporter

asked in Authoring

Error prepending 'C:\Program Files\FME_23781\plugins' to path environment variable. The addition may not exist, or on Windows the resulting path may be longer than 2047 characters

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?

1343

6 months ago

vxn43Supporter

asked in Authoring

How to create unique IDs and autogenerate unique IDs in a Feature Class?

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.

1161

6 months ago

kathyjbryceContributor

asked in Authoring

Dynamo DB - configure AWS endpoint for VPC

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

httpcaller add feature service attachment file not found?

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?

315

6 months ago

rednas40Participant

asked in Transformers

Clipping 3D object

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?

861

6 months ago

jarContributor

asked in Transformers

FeatureWriter failing due to schema lock on FGDB?

I’m migrating to ArcGIS Pro and working on a workflow to convert geodb_pro_annotations to geodb_annotations so that I can edit/create annotations in ArcGIS Pro and downgrade them so that they can be used in ArcMap and read with a legacy tool (that currently has no ArcGIS Pro upgrade path).I seem to be having an issue writing some of the features to a new local FGDB where the FeatureWriter errors out with the following message:“An error occurred while attempting to create a feature using the feature class 'StreetName_Rural_Smaller_LEVEL_63'. The error number from ArcObjects is: '-2147220947'. The error message from ArcObjects is: {Cannot acquire a lock.}”The data is created/edited in an SDE and exported to a local FGDB for this downgrade. There are 25 annotation features containing 1 to 2,000,000 annotation records. This error seems to only occur on annotation features with more than 500,000 annotation records. The others are able to be written out to the FGDB with no issues.I’ve tried

1923

6 months ago

leroyContributor

asked in Transformers

Convert JSON string to table

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?

2968

6 months ago

anteboy65Contributor

asked in Data

Tryging to read Postgres 14 with FME 2023 but getting "Failed to retrieve feature types"

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?

862

6 months ago

cpedronContributor

asked in Authoring

Keeping only certain lines in a shapefile

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.

752

6 months ago

mark2atsafeSafer

asked in Authoring

Connecting Transformers: A Quick Guide

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

3695

6 months ago

ecxContributor

asked in Data

How to create ESRI_OID in polygon dataset? It is missing and causing major errors.

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?

643

6 months ago

daniel.m.getzContributor

asked in Integration

What would cause a Snowflake connection to work on FME Desktop/Form, but hang on FME Server/Flow?

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

561

6 months ago

aaronContributor

asked in Transformers

Dynamically add suffix to attributes with BulkAttributeRenamer

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?

864

6 months ago

matselfContributor

asked in Authoring

Is there a way to dynamically alter field types?

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

1194

6 months ago

waterbeemdsContributor

asked in Authoring

Translate JSON return to table form

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

693

6 months ago

1
...
46
47
48
49
50
51
52
...
1107

Page 49 / 1107

Badge winners

candertonhas earned the badge Student (Grey)
edwardhas earned the badge FME Form Basic Training
pacificwesthas earned the badge Student (Grey)
rark6765has earned the badge Teacher (Grey)
rark6765has earned the badge Student (Grey)

Show all badges

30,363: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.