Skip to main content

FME Form

A space to discuss FME Form

10000 Posts
srperdomo
Participant
srperdomoParticipant
asked in Integration
collada to shap

Hello everyone, I hope you are well, I am new to FME, I have a .dae file (Collada) that refers to a 3D model of a tree. I also have a layer of points with coordinates in shapefile format of an inventory of trees. Is it possible to integrate the 3D geometry of the .dae file in each of the points of my inventory?. to finally export it in a 3D viewable Kml file.

40
srperdomo
Participant
juliarozema
Contributor
juliarozemaContributor
asked in Authoring
How to test for Esri ArcPro Arc

We need a way to detect/test for Arcs in our Esri SDE database. We manage a large road line segment. The system that uses this data does not accept Arcs, just polylines. Previously, we edited our data in ArcMap, then run a nightly job to check our data in FME. Using the PathSplitter, followed by the GeometryFilter we could then find any Arcs that had been introduced into our data. Now that we are editing our data within ArcGIS Pro, it seems that Arcs show up as an Arc within Pro, but in FME, the segments show up as Lines and are not flagged with the workflow, mentioned above, using PathSplitter and GeometryFilter. How can we filter/test to find the Arcs in our data? UsingFME 2024.1ArcPro 3.2.3ESRI SQL SDE 10.9.1 Example Arc attached in FGDB. Then the Feature is opened in ArcPro, and an edit session is started to ‘Edit Vertices’, we can see that there is a verity that controls the curve of the line.

111
crutledge
Enthusiast
deanhowell
Influencer
deanhowellInfluencer
asked in Transformers
JSON Templator Correct Syntax

I need to output a list of paired values as a JSON File. I have a list called JSONList with two attributes JSONname and JSONvalue. I am using the JSONTemplater to organise the data. I have the root template set as { "publishedParameters": [ fme:process-features("SUB") ]} and the SUB Template as { "name": fme:get-list-attribute("JSONList{}.JSONname"), "value": fme:get-list-attribute("JSONList{}.JSONvalue")} but I am just getting the name and value as a single line each. How do I change the structure so each name and value pair are separated, similar to the below? { "publishedParameters": [ { "name": "_portalLayer", "value": "parks" }, { "name": "_portalOrganisation", "value": "SWR" } ]}

233
deanhowell
Influencer
aaannas
Contributor
aaannasContributor
asked in Transformers
transformers for spatial analysis

Hi everyone, I am new FME user and I will be grateful if i could get some tips what transformers should I use for such an analysis I need to do: I have two addresses’ database (one is reference), both contain addresses (points) and one contains buildings (polygones). i have to compare that dataset: if addresses are on the building or not and if not how distance is betwen address and builiding. If postalcodes are correct; for example if addresses on street x have all the same postalcode. if address is located on correct street and correct town/village.

183
takashi
Influencer
froberts
Contributor
frobertsContributor
asked in Data
MBtiles Writer and forcing layers

I am having maybe a similar but different issue with the mbtiles writer. For some reasons the Zoom level dialog is not making a lot of sense to me. In my case I would like to force the writer to write out levels 0 to 11. In my head I am thinking I would set minimum zoom level strategy to “Lower” and then the Minimum Zoom Level to 11. My assumption is that when we talk about level it matches up with the table below. However with the above setting I get a mbtiles file with just one level in i (see results 1 below for log). If I instead set Base zoom to Upper and Minimum Zoom to 0 (run 2 below for log), I get a file with 10 levels. This is close to what I want, but I want 11 levels. Any ideas on how to better explain the dialog to me and get me 11 levels?? thanks so much!!! Run 1 log: Feature Caching is ONThe workspace may run slower because features are being output and recorded on all output ports regardless of whether or not there is a connection. Command line to run this workspace: "C

331
desiree_at_safe
Safer
marionmahot
Contributor
marionmahotContributor
asked in Data
List to attributes

Hello everyone,I performed a feature merger between two shapes and obtained a list from this transformer. My list is as follows:insee: 11232code: PTRSURF: 11 insee: 11232code: PPHSURF: 15 insee: 11232code: SPLSURF: 23 insee: 15500code: PPHSURF: 2 insee: 15500code: SPLSURF: 555 So I want to assign the elements of the list to an attribute table (in columns). I have a maximum of 96 elements for a single code, so my resulting table will have many columns.So I want to get this: How should I do this? THANKS

141
takashi
Influencer
aashnaparikh
Contributor
aashnaparikhContributor
asked in Data
Best Approach to Write to Excel Template while preserving the structure, formulas and static values

What is the best approach to write to selected excel cells if I am overwriting using an existing template? How can I make FME understand to apply the formula or the predefined values based on the feature count in my input file ? The template contains the predefined value in the first row. Item ID Program Full Name Master Certificate Number Address Dentist Association XL89 My Input File / Reader File Item ID Full Name Address 12 Jon Doe 14 King St 45 Mary Jane 5 Todds Ave 345 Henry Smith 7 Queen St My expected Output Item ID Program Full Name Master Certificate Number Address 12 Dentist Association Jon Doe XL89 14 King St 45 Dentist Association Mary Jane XL89 5 Todds Ave 345 Dentist Association Henry Smith XL89 7 Queen St

91
nielsgerrits
VIP
rmpayaby
Contributor
rmpayabyContributor
asked in Data
Converting DFX to IFC

I have a DXF-file consisting of lines and surfaces. Is there any standard method on how I can convert such files in IFC?

50
rmpayaby
Contributor
coopersykes
Observer
coopersykesObserver
asked in Transformers
How to get a list of Asana tasks with their corresponding custom field values?

I have been able to successfully connect to Asana by using two resources (attached at the bottom) and extract a list of task names and custom field names, but I have been unsuccessful in using the JSONFormatter, JSONFlattener, and the JSONExtractor tools to create a list of tasks and their corresponding custom field values for a specific Asana project. If anyone is experienced in working with the Asana API to collect this kind of data from a particular Asana project, I’d be really appreciative of any helpful tips to create a final output of a project’s tasks and their custom fields. Thank you so much! https://hub.safe.com/publishers/safe-sandbox/web-connections/asana)

100
coopersykes
Observer
paetzold_s
Contributor
paetzold_sContributor
asked in Integration
Python virtual environment

Hello there, I’m currently working on a workflow for which I need a python package that is not preinstalled with FME. I tried installing the package according to this help page: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/Installing-Python-Packages.htm Unfortunately I got a dependency collision with other packages that are already installed.So I tried setting up a virtual environment but FME doesn't seem to support custom venvs. https://community.safe.com/transformers-9/how-to-integrate-a-custom-python-environment-27779 My question is:Without uninstalling or up-/downgrading the already installed python packages,what is the official way to avoid such dependency issues? Many thanks in advance.

292
paetzold_s
Contributor
aharport
Contributor
aharportContributor
asked in Transformers
Incorrect cell scaling after running Bentley MicroStation Design Writer

Good morning, I'm trying to write some geodb_point features (cell) to a DGN using Bentley MicroStation Design Writer. The MicroStation cell library must be specified in the writer's parameters. The cells are placed in the DGN, but they appear incorrectly scaled compared to the cells in the cell library. If I refresh the cells in the DGN again from the cell library, they appear correctly scaled again. Unfortunately, I have to perform this step manually for each cell. I've tried adjusting various settings in the writer's advanced parameters. To no avail. Can anyone help me?

100
aharport
Contributor
vdeyepc
Contributor
vdeyepcContributor
asked in Authoring
How to Connect to Sharepont Using SharepointOnline Connector using Graph API

Hello Safe Folks, I am trying SharepointOnline Connector with a TenantID, Client ID and CLient Secret. I followed https://support.safe.com/hc/en-us/articles/25407443807117-Getting-Started-with-Microsoft-SharePoint#WebConnection https://support.safe.com/hc/en-us/articles/30678084674189-How-to-Create-a-SharePointOnlineConnector-Web-Connection-with-Application-Permissions In the second URL, it suggests to have but I only have Sites.Selected or Sites.ReadAll option from the ADMIN. After adding the required parameters, I do not get an error but when add sites I get an error. I am using options/parameters for Download Search Query: Unable to execute query: 'Read past EOF' Please suggest and help.

241
j.botterill
Influencer
deanhowell
Influencer
deanhowellInfluencer
asked in Transformers
JSON Templator for Parameters

I am reading in a very poorly formatted JSON file which has hundreds of lines but I just want to extract some key attributes that will then be used to create a JSON file that can be passed to FME Flow to start a work bench using the extracted attributes. I am reading the JSON file in and running it through an attribute manager to get the attributes I need. If I then run through JSON writer I just get a list like this [ { "json_featuretype" : "JSONFeature", "Catalogue Key" : "Data Catalogue", "Layer Name" : "Testville Roads", "Data From" : "Import type from CSV file", "Data Access" : "Restricted", "Update User" : "Alex", "Description" : "Roads data for Testville COuncil", "Dataset Dimension" : "3D", "Data Update Frequency" : "As needed", "Geometry Type" : "Points", "Spatial Presentation Type" : "Vector", "Data Currency" : "2025-11-09", "Initial Publication Date" : "2025-04-15", "Contact" : "Fred Flintstone", "Data Classification" : "Business Impact Levels (BIL)", "Dataset Aggregator" :

232
deanhowell
Influencer
albinepro
Supporter
albineproSupporter
asked in Transformers
Debug Python Scripted Selection

Im trying to implement some dynamic selection based on an API call response. So far I can build a package for scripted selection according to Dynamic choices using Scripted Selection - FME Packages SDK Guide and debug in VS Code attaching to Workbench (Build a Hello World package - FME Packages SDK Guide).The problem is that debugging is bound to running the translation and that is already late for the script I need to debug. The selection scripts are run when filling in the transformer parameters. I need to add breakpoints and inspect the execution of selection script (ScriptedSelectionCallback) during the API calls and browsing the object structure. Is there some setup to make this possible?The final purpose is to get this into User parameter scripted selection in FME Flow. I understand it would work this way in scripted parameter selection as it is in the transformers.

484
albinepro
Supporter
lifalin2016
Contributor
lifalin2016Contributor
asked in Authoring
Controlling execution order - thwarted

Hi list. I have a master workspace in Workbench, which starts with a Creator calling two SQLExecutors, and eventually calls two WorkspaceRunners. Each SQLExecutor fetches a list of tables in a dataset, adding their feature count (numbers of rows). I specifically tell FME to process the smaller dataset (i.e. its SQLExecutor) first, but each “thread” also have a (blocking) Sorter transformer (sorting by feature count) before calling (its) WorkspaceRunner. It seems that the result from the two blocking Sorter transformers are processed by FME in the wrong order regardless of which order the features have arrived. How can I ensure that the Sorter for the smaller dataset (i.e. VAT above) executes first, before the Sorter for the larger dataset ? As is seen, I tried to rename the Sorters, so the smaller was alphabetically listed before the larger, but it didn’t change anything. The Logger logged the larger dataset first.

334
takashi
Influencer
arenscott
Contributor
arenscottContributor
asked in Data
SQL Count function

Hi all, I’d like to use FME to execute some count SQL functions on SQL server (SDE). I’m having trouble with the syntax of the SQL in FME and I’m not receiving any output from the SQL Executor. SQL I’m running: SELECT COUNT(*)from "SDE".SAMPLE;

709
ebygomm
Influencer
mgrupp
Participant
mgruppParticipant
asked in Transformers
ArcGIS portal feature writer fails to fill certain fields when run on FME Flow

Hi everyone, I have a problem that I can't seem to solve. I have a workspace that writes data from a PostGIS database to a feature layer on our portal using the ArcGIS portal writer. When this workspace is run locally on FME form, it works perfectly fine. When it is uploaded to portal and run there, it seems to work fine (the amount of features written is identical to the amount when run locally), but some important fields are not filled. Flow and Form both use the same web connection with the same authorization parameters. Why is it that a identical workspace that runs locally can fill all fields fine, but when run on portal it seems to not be able to fill these fields??? I have put testfilters and loggers in between to check if the fields actually have values and they do, so it must be a writer quirk. Field names between the features and writer are identical as well (all lowercase) so I am at a loss... I am using fme form/flow 2023.2.2 and ArcGIS portal 11.1

563
artw
Participant
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Transformers
adding points to the line

Hi, I have a task in which I have station values attached to the line. I need to select station values and split the line at the station points. Some station points are easy to split; for example, 1789+00, but others, like 1201+50, are not that simple. I am trying to create points between two station points. I want to place points 10 ft apart and calculate station values so that I can split the line at those values. I have attempted to generate points between two station values using the Densifier transformer, but I am not achieving the desired outcome. If someone can assist me in this situation, I would greatly appreciate it.

655
fme_can_do_it
Enthusiast
julianat
Contributor
julianatContributor
asked in Data
DGN Cell Library in FME Server

Hi, I am having an issue of trying to use a dgn cell library and seed file on FME Flow for point features. The workbench works correctly on desktop but not Flow. Is FME capable to read cell library and seed files on FME Flow? This is the error message I get: Any help would be greatly appreciated! Thanks!

741
julianat
Contributor
3d_ff
Contributor
3d_ffContributor
asked in Transformers
FME Python Script for Automated DDH Desurveying (Minimum Curvature, Flexible Intervals)

​@daveatsafe Dear FME Community, I am seeking assistance in developing a Python script for use within an FME workspace to automate the desurveying of diamond drill holes (DDH) using the minimum curvature method. I aim to create a flexible solution that allows users to specify a custom desurvey interval (e.g., 1m, 3m, etc.). Background: Desurveying a drill hole involves calculating the actual XYZ coordinates along its length based on the collar location and survey data (azimuth and dip at regular downhole distances). I've researched existing methods and found the following resources helpful: Understanding Drillhole De-surveying: https://seequent.zendesk.com/hc/en-us/articles/360001547955-Understanding-drillhole-de-surveying Desurveying Methods and Interactive Tool: https://endarthur.github.io/writting/desurvey.html Drillhole Desurveying Python Code (GitHub): https://github.com/WilliamsB39/Drillhole-Desurveying QGIS Geoscience Plugin: https://www.spatialintegration.com/processing-drill-h

404
3d_ff
Contributor
fikusas
Contributor
fikusasContributor
asked in Transformers
Compress FGDB with ArcGIS Pro tool in FME

I’m trying to compress FGDB with ArcToolbox tool with PythonCaller. This gives no error, but nothing happens after running it. What I am missing? Using FME 2024 with ArcGIS Pro 3.4. Compatability is set to ArcGIS Python 3.11. import fmeimport arcpy def compress_fgdb(fme_feature): fgdb_path = fme.macroValues['FGDB_PATH'] arcpy.management.CompressFileGeodatabaseData(fgdb_path, "Lossless compression") return fme_feature

181
hkingsbury
Celebrity
cdog
Contributor
cdogContributor
asked in Data
ArcGIS enterprise update

Hi, I am trying to set up a simple update workflow that doesn’t like me. I am trying to update my enterprise portal with GDB updates and will eventually want to have this run everyday but for now I am just trying to figure out how to update one shapefile and repeat this 30 times. Right now I haver set up a GDB reader going directly into ESRi ArcGIS portal feature service writer to update an existing feature in enterprise and I have got it to write the features but it doesn’t want to publish the feature into portal. Can someone help me figure this out?

498
cdog
Contributor
gennine
Contributor
gennineContributor
asked in Transformers
How to automatically reverse digitizing direction of an electric network

I would like to automatically number an electrical network as shown in the diagram below.If the digitization direction of the features is correct, then I get the correct numbering. I used the NetworkTopologyCalculator and TopologyBuilder transformers to perform the automatic numbering.If the direction is reversed, then the numbering is incorrect.Is there a solution to this problem?Thanks in advance.

272
gennine
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
AzureBlobStorageConnector / Clip LAS file without Download

Hi All, I’m working on a workflow that reads a LAS file storage as blob in a Azure database. I need to clip the LAS file with a polygon (AOI) and then exports the result as LAS file (or other format). After doing some research, the community suggests to set the My AzureBlobStorageConnector settings to download the LAS file and then process the data. My current LAS file is around 10GB and downloading it every time that needs to be clipped is not very good! The total time of downloading the LAS, clip it and re-export it can be crazy! here are my settings: Is there any way to read the LAS file as blob and clip it directly without download it?

503
kailinatsafe
Safer
tb09114
Supporter
tb09114Supporter
asked in Transformers
Challenges with Python in FME 2024.

I have an issue with some Python code in Form 2024.1. I have to make a connection to a PostgreSQL database using psycogp2. When I run the PythonCaller in my workspace then it fails with an error message that psycogp2 is missing (Python Exception <ModuleNotFoundError>: No module named 'psycopg2') I tried to single out the problem in a minimal workspace (attached), but here it works without a problem. Hence, I am wondering how and what is causing the issue. The actual workspace is rather big and I will share a screenshot of the essential part that is failing. The AttributeManager10 receives a single feature from the summary port of a FeatureWriter and in AttributeManager10 all other exposed attributes are deleted, except the site_id (integer) is kept. Unexposed attributes are there only two: fme_geometry -> fme_undefined fme_type -> fme_no_geom Running to the Attributemanager10 works fine. The next partial run of PythonCaller_4 fails with: 2025-04-30 13:46:19| 3.6| 3.4|ERROR |Message Typ

222
david_r
Celebrity

Helpful Members This Week

Badge Winners

  • Student (Grey)
    srperdomohas earned the badge Student (Grey)
  • I Dig JSON
    takashihas earned the badge I Dig JSON
  • Integrate Data with the FME Platform Training
    mramsayhas earned the badge Integrate Data with the FME Platform Training
  • Teacher (Grey)
    aaannashas earned the badge Teacher (Grey)
  • Welcome Back
    mseagren839has earned the badge Welcome Back
Show all badges

Popular Tags

Community Stats

31,148
Posts
118,080
Replies
38,766
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.