Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
cnorth
Contributor
cnorthContributor
asked in Authoring
HTTP caller Update Salesforce records

Hi, I am looking into a way to setup the HTTP Caller to Update a record in Salesforce, the writer is not suiltable as this is best for bulk, my JSON has the case ID and teh name of the field that nneds updating.I’m not sure how to setup for updating and not sure how to ensure refresh token works?I have followed this guide, https://support.safe.com/hc/en-us/articles/25407494166029-Connecting-to-Salesforce-in-FMEbut it doesn’t connect, coming up with a network error?

290
cnorth
Contributor
syahrastania
Contributor
syahrastaniaContributor
asked in Data
Error while trying to open IFC file. Error ISO10303-21: The input data contains a syntax error

Hello.I’m trying to convert and IFC file into CityGML 3 file using the ifc-to-citygml3 FME Workspace, but when I tried to Run it, it shows this error.ISO10303-21: The input data contains a syntax error at the beginning of the file. The file should start with 'ISO-10303-21'. Ensure the file is in an ASCII character system, with no byte order marker.Unexpected character: #ISO10303-21: Invalid file format, unable to continue reading Can anyone help me fix this issue?

792
syahrastania
Contributor
b-rad
Contributor
b-radContributor
asked in Transformers
Why is StatisticsCalculator returning null for min and max?

Hi, I’m having an issue with the StasticsCalculator returning some nulls for min and max. And also some unexpected rounded max values. Input data I’m calculating statistics on avg_dur field and grouping by SEG_ID. Unexpected results highlighted. The avg_dur field is data type real32. For some reason changing the data type to real64 results in the stats being calculated as expected.The ave_dur field was originally imported from an esri shapefile with data type . 

1073
b-rad
Contributor
tiffany_deq
Contributor
tiffany_deqContributor
asked in Integration
Unable to Write Point features to Esri ArcSDE

I have a non-spatial table in MS SQL database with lat/long coordinates. In my workspace I use the VertexCreator + EsriReprojector to create point geometries in our standard projection. Now I want to write the point features to a new feature class in an Enterprise Geodatabase (SQL Server back end).  The database connection I am using for the writer has permission to create table in the geodatabase and I am able to create feature classes in the geodatabase outside of FME.  But in the workspace, the translation fails with this error:“An error occurred while attempting to create the feature class 'My_New_Feature_Class'. The error number from ArcObjects is: '-2147216035'. The error message from ArcObjects is: {This geodatabase does not support this client or operation [This geodatabase does not support this client or operation] [My_New_Feature_Class]}I have searched for this error code and do not find much out there, so I am hoping someone here may have add a similar error and found a solu

1172
tiffany_deq
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in Data
Geometry Challenge - Identify percentage of overlap (Lines)

Hi All,I’m working on an automation that needs to identify those lines that follow the geometry from another layer. The following screenshot explains what I need to do: Red line follows a river (not exactly the same geometry but pretty close) and need to identify those red lines that follows the blue centerline….I was thinking maybe I need to calculate the percentage of overlap between red and blue?There’s other locations where the red line only overlaps the blue lines for a little section so I can ignore those, see belowAny idea how to approach this?

1092
ctredinnick
Supporter
cdog
Contributor
cdogContributor
asked in Data
Issues updating AGOL data from shapefile

Hi, I am new to FME so might be making a rookie mistake. But I am trying to update AGOL from a GDB shapefile but it won’t update in AGOL. I have managed to get everything to work and it shows the updates but its not sending the data to AGOL. What am i missing here?   

293
hkingsbury
Celebrity
mcannalea12
Contributor
mcannalea12Contributor
asked in General
I have a fairly simple problem but can't seem to figure it out. I need to copy one excel file to another folder and rename the copied file. I've tried using the PATH reader and the File Copy Writer but nothing seems to get copied. Any ideas?

I have a fairly simple problem but can't seem to figure it out. I need to copy one excel file to another folder and rename the copied file. I've tried using the PATH reader and the File Copy Writer but nothing seems to get copied. Any ideas?

3738
riad.hamoudi
Contributor
karol
Contributor
karolContributor
asked in Integration
Read embedded url in Google Sheet cell?

Hi everybody,My client has a spreadsheet that contains a list of Google Map urls embedded in text, inside cells in a Google Sheet. Using the Google Sheet  V4 reader, I am unable to read the url of the embedded text into the workspace. For example, I cannot read the url for the Google Map url for Safe’s location in this spreadsheet.  I’m really hoping to mine the lat/long coordinates from these urls. I use FME Desktop V2021.2.2.0 in production, but have Form V 2023.2.1.0 available, if needed.Thanks!

6005
danilo_fme
Evangelist
myadegaryiutac
Contributor
myadegaryiutacContributor
asked in Transformers
Keeping Color when converting DWG to GDB/SHP

HiCurrently I am converting a DWG file to GDB (file) / SHP,The DWG file itself has line and polygon and they have color based on their different layer name.Once I read the file, it showed only FME feature name, I used AttributeExposer to add autocad color column and a few more useful information, then I used DWGStyler and FeatureColorSetter but once I write the file to GDB or SHP and bring the data to ArcGISPro, the layer has only one single color. (Please see the attachments) Can someone give me a clue how to solve it? 

1682
nielsgerrits
VIP
offi24
Contributor
offi24Contributor
asked in Data
Build 3D Line using x,y,z text file

I have a .csv file with x, y, z coordinates. From these points, I want to create a 3D line. Currently, I have the issue that the z coordinates are not being transferred onto the line when I create a line from the points. Does anyone have an idea of how I can proceed?

1087
nielsgerrits
VIP
michael_v307
Participant
michael_v307Participant
asked in Data
ArcGIS Feature Service Reader to Excel Writer missing feature tables

I had a FME scenario running to read the feature service and related tables and write to an excel file. I have the excel writer setup to “Fanout” the dataset which used to drop each table from the feature service into its own sheet within excel. I went back to run the FME scenario and when I check the excel outputs some of the tables are missing. Prior to running the scenario I check to make sure all the tables are checked and that the reader is seeing all of the tables, which it is. I check “select all” and run the scenario but when I check excel I get 6 of 9 tables. I have double check every setting and even started a new FME template and recreated the reader/writer but I still don’t get all the tables in the excel output.Can anyone help me out? Thank you

201
nielsgerrits
VIP
abnan0001
Supporter
abnan0001Supporter
asked in Data
Excel to GDB with Domains, Fieldnames and Field Alias

Hi Everyone..I was able to find a workspace from community this template attached and did few changes to it and it is working as expected with sample template provided in workspace to create a GDB with domains , fieldnames and field alias.      1) This workspace consider single default words in domainlist provided in excel  only like Domain1 -      Attached Sample_1_Workspace template - works with 2023 version.This workspace consider single altered words domainlist like alphabets(A,B,C….) in Attached Sample_2_Workspace_template - works with 2023 version  This workspace consider 2 words in domain list like FME form in attached sample_3workspace_template -doesnt work and workspace fails.. If there are any special characters or space it doesnt work like : FME Form or FME_Form. I have attached error log and all sample data files with with each workspace.. Any Experts Kindly support : How can i resolve this with text as FME Form or FME_Form (with a space or special characters. Thanks

1789
debbiatsafe
Safer
awagih
Contributor
awagihContributor
asked in Data
RVT to GDB

Greetings, I’m trying to use an ETL to convert RVT files (2023) into File Geodatabase multi patch, however, the following model produces the right objects, but in the wrong location, even though when reading the RVT file directly in ArcGIS Pro, the building falls in the right place. Any clue? 

331
jovitaatsafe
Safer
larue
Contributor
larueContributor
asked in Authoring
Need Help with Batch Processing Using Workspace Runner

I have been trying to set up a batch process to create dwg files, adding a template based on the respective input file.  I have tried to follow the advice from the links below, but am missing something or what I am doing isn’t quite the same.  At any rate, my workspace fails after trying numerous different configurations.  Published ParametersBatch processing I have attached the two Workspaces.  The goal is to apply a CAD template to it’s respective output file, with the inputs controlled by the WorkspaceRunner parameters. The Workspace that outputs dwgs takes inputs from three sources:  Two different folders of CAD files (one of which also happens to be same as the template but used for a different purpose), and a spreadsheet .  Any insight is appreciated. Thanks.

1270
larue
Contributor
ma_bnm
ma_bnm
asked in Authoring
Measuring distance between polygons

My dataset contains some river basins polygons, with 1 forestry polygon falling into each one. Each river basin also contains multiple habitat polygons. I am trying to measure the distance (edge to edge) between the forestry polygon and each of the habitat polygons falling within the same river basin. I’ve done some spatial joins to associate each forestry polygon and each habitat polygon to it’s respective river basin, but I’m unsure how to measure the distances between them, while grouping by river_basin_id. Any help would be greatly appreciated.

1181
geomancer
Evangelist
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
AttributeManager - Arithmetic expression (Decimal Places)

Hi All,I’m trying to improve the performance of my workbench by reducing the number of transformers. I was able to use AttributeManager to calculate the length of lines with the expression @Length() but I can’t work out how to round up the value up to 3 decimal places,Is that doable using the arithmetic expression instead of AttributeRounder transformer? 

2583
galigis
Enthusiast
geomax
Contributor
geomaxContributor
asked in Transformers
DWGStyler color setting

Hello,I am trying to convert data from shapefile to DWG.To do that, I am using the DWGStyler to assign the correct setting to each object.Reading the post in the community, I am able to use the DWGStyler using a template and the right color is assigned to each object in CAD so, I see the match between the color in the canvas and the color in the Layer’s list. But, in some cases, I don’t have the template and when I open the file in autocad I can see the right color in the canvas assigned by the DWGStyler but in the Autocad list layer I see all layers in “red”, I attached an example. How can I resolve this situation to have the perfect match for the layer’s colors to avoid a manual rework without using the template? Thanks Max  

972
geomax
Contributor
dor1411993
Contributor
dor1411993Contributor
asked in Integration
FME Flow Apps- redirecting to a loading GIF while running the job

I have a Flow App, which performs a relatively long process, which at the end directs the user to a certain url following the success or failure of the process.The url reference is made by a single HTML writer at the end of the process.My problem is that this process can take some time,And in terms of the user experience, the customers are not aware that the process is running behind the scenes.I want to make a reference to some kind of loading GIF that will at least show them that something is really moving behind the scenes..And this is where I need your help.Because if I write to two HTML writers, it simply downloads the two HTML files for me,It does not direct me HTML line after HTML, but simply disrupts the process.Does anyone have a solution?It doesn't even have to be a reference to the HTML of the loading GIF, just an indication in terms of the user experience that will tell the customer: "Don't worry, a few seconds and you move to the next screen"Thank you!Dor

655
kidega
Contributor
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Authoring
Get a list of filenames based on the user selection?

I’m working on an upload process via REST call and I want to use FME to do the upload.For the API I need to provide a list of file names in advance. I want this to just work and I want to be able to use FME’s multiple file picker to allow the user to pick folders, multipler files or just a single file. etc.Does anyone have a good/robust method for getting a full list of the files (and filenames) that this input could be.My initial plan is to split up the input parameter into a list and then figure out what are folders and what are files and for folders I would use a PATH reader to get the files.I guess I need a “MultiFilePathResolver” kind of thing. 

622
virtualcitymatt
Celebrity
joy
Enthusiast
joyEnthusiast
asked in Integration
Will there be Git integration with FME Workbench?

Hello everyone, I have colleagues who were wondering whether there would be git integration available with fme workbench.I understand now at the moment there is no integration directly in fme workbench with git. However it's possible to manually check in .fmw scripts in git I heard, but I think it would be an useful functionality if you dan do that directly from fme workbench. I was wondering whether something like that would be available in the future.

5037
joy
Enthusiast
anteboy65
Contributor
anteboy65Contributor
asked in Transformers
PointOnPointOverlayer stores duplicates in list, how to read from Pythoncaller?

Problem in short:I have a lot of points which some has identical coordinates. PointOnPointOverlayer does this for me and store the “twins” in a list name. Now I want to use a Pythoncaller to loop through the list of each feature and figure out if some or none of the twin attributes has a value that should update the the major feature. The problem is that I cant seem to reach the list variable created in PointOnPointOverlayer from the Pythoncaller. It seems to be exposed when running with feature cache and checking output from PointOnPointOverlayer. What’s the magic for reading the list, looping throug it and check the attribute values? Tried this example code from the PythonCaller just to see if I could reach the list but can’t see anything:  

914
anteboy65
Contributor
buchsteiner_24
Participant
buchsteiner_24Participant
asked in Authoring
Snap line endpoints to points in the z-direction only

Hi everybody!I have a point layer and a line layer. The line layer consists of connected lines, and at the lines endpoints there is a point from the point layer in the exact same location. I moved the points in the z-direction because their height had to be corrected (new z-values were derieved from a point cloud). Now i also want to move the corresponding line endpoints in z-direction as well so that they again match the points in x, y and z. I guess the AnchoredSnapper with Group Processing could do the job but don’t know how to prepare the data for that. Can anyone help me with this? red: original position of points and lines; green: points moved in z-direction due to height correctionQuestion: How can I make the lines follow the points in z-direction? I am grateful for any advice!

651
nielsgerrits
VIP
fmegrinder
Contributor
fmegrinderContributor
asked in Transformers
Extract map extent from MXD

Hey! I have an 50 diffrent  MXD and I need to retive the map extent from start  in every mxd. There is an option to igonore map extents.But is there an an way to extract the start extent? 

260
fmegrinder
Contributor
fred.haan
Contributor
fred.haanContributor
asked in Data
Utility Network (UN) (Esri) - Update Attributes

Good morning,I would like to use FME processing to "periodically" update the values ​​of certain Utility Network attributes.This concerns the updating of data which potentially can be versioned, but I am only considering here the updating of "descriptive" (simple) attributes which are not involved in asset group assettype distribution rules and which have no impact on connectivity rulesDo you have experience of the best methodology to use and perhaps illustrate this with an example Workbench?THANKS 

470
fred.haan
Contributor
redgeographics
Celebrity
redgeographicsCelebrity
asked in Authoring
Importing database connections in FME on Linux, no gui

One of my clients is using FME on Linux with only the command line interface and is having some trouble importing database connections. Specifically: they don’t know how to do it on the command line.I can’t find much in the way of documentation for this. I suspect that if it is at all possible it may be through the APPLY_SETTINGS command, but other than that I can see that that exists, I can’t find any indication anywhere on what those settings may be and how to set them.Any clues? Anybody with an old manual somewhere? I do have old installation cd’s and dvd’s going back to FME 2005, but I don’t think I have a computer with a cd or dvd drive anymore 😅 Hoping one of the other long-time users has something stashed away...

1379
virtualcitymatt
Celebrity

Badge Winners

Show all badges

Community Stats

31,801
Posts
120,812
Replies
39,424
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.