Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
jasonc
Contributor
jasoncContributor
asked in General
Branch Versioning Problem trying to replace data

Updating a GIS Layer in a database that is using Branch Versioning from a GIS Layer that uses traditional versioning. The branch version feature service that I am updating is set to a specific version where I am not reconciling or posting the results to default. I set the Feature Type Handling to Truncate existing and feature operation to Insert. The branch version layer is not truncating, and I am getting a duplicate record result instead of a single set of records. It appears that it is not truncating. I am also Getting the following errors : ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '' and the message was: 'Could not access any server machines. Please contact your system administrator.'. Details: ''ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for detailshttps://community.safe.com/s/forums

2170
evieatsafe
Safer
jeremiah567
Contributor
jeremiah567Contributor
asked in General
Where can I locate data for posted tutorial on the website so as to use it for practicing purpose. For example, I want to do hands on training on common GIS operations on this link https://community.safe.com/s/article/area-and-distance-measurements.

Where can I locate data for posted tutorial on the website so as to use it for practicing purpose. For example, I want to do hands on training on common GIS operations on this link https://community.safe.com/s/article/area-and-distance-measurements.

80
jeremiah567
Contributor
E
engelm1324
asked in Transformers
1. How do I export, to an excel template, data from a Survey123 form that has related tables? 2. Rather than overwriting the excel file, how can a create a new excel file from the Parent record, while integrating in the Survey123 related tables

I have a Survey123 form, that needs to be exported to a specific excel template file. The Survey123 form has 1 layer (parent record), and two related tables associated with that single record. The final format for the excel template would need to be 1 file per record, with two sheets (from the two related tables). Prior to exporting out to the template files, I would need to filter the data down by a site name For instance, a site (that I have filtered down to) may have 4 records taken on it, so I would need to create 4 separate excel files, based on a Plot ID field. Each on of these excel files would then have 2 sheets based on the related tables of the record. Open to suggestions and comments. Thank you!

2213
E
rich_snyder
Participant
rich_snyderParticipant
asked in Integration
GeoPDF layer hierarchy

Does FME support writing a hierarchy of layers to GeoPDF? I can't find any documentation on how to do it.

230
rich_snyder
Participant
wlangejans
Contributor
wlangejansContributor
asked in Transformers
Is there a way to establish parent child relationships between line segments?

I am working with conductor line segments and need to establish a parent child relationship between these lines. For example I would like to assign conductor "2" a parent value of "1" and a child value of "3". Has anyone accomplished this task or have an idea of how to go about this?

140
wlangejans
Contributor
claireco
Contributor
clairecoContributor
asked in General
How to copy attributes from one layer to another after spatial joining?

Hello I'm doing a spatial join between a polygon layer and a point layer. For polygons that are "passed" I want to retrieve the attributes of the corresponding points. Wich transformer should I use ?Thanks

1170
dustin
Influencer
L
lutfi
asked in General
Hi, I am an absolute begginer in using FME and I highly appreciate any outputs to my question. Anyway, I am trying to remove unnecessary areas inside of polygons (shown in the image) and connect neighbouring vertex togather.

60
L
V
vladimirb777
asked in Integration
Pandas library not installing for Startup Python Script to run

I am trying to set up the Startup python script to be able to run a process which taps into Smartsheets API and converts it to an excel, which I then separately read into FME and runs through an FME process. I'd like to have the python code run every time before running through the data processing workflow I set up. I have added my python script, set the interpreter to 3.10 and have installed modules into the Documents\\FME\\Plugins\\Python folder using command prompt : C:\\Program Files\\FME>fmeworkbench.exe python -m pip install pandas --target C:\\Users\\vberg2\\Documents\\FME\\Plugins\\Python . It ran and successfully installed pandas, along with a few other modules I installed after. I am however getting this error when I try to run the FME workspace: Python Exception <ModuleNotFoundError>: No module named 'pandas._libs.interval'. When I look into the folder directory, that file is there.  Am I missing a step, or did I install pandas incorrectly?  Thanks for

2390
Y
limo
Supporter
limoSupporter
asked in Transformers
How to visualize chart data using a color ramp?

We have generated a chart by using the transformer "HTMLReportGenerator".As result we have something like this:Now we wanna color each data point inside the chart differently. Something like this: In fme I can only choose one color for the hole data atribute!Is it piossible to create different colors for one data attribute?  

293
ebygomm
Influencer
I
inba
asked in Transformers
I am facing challenge while transforming data from XML. The challenges are while reading an element it gives incorrect format.

I am facing challenge while transforming data from XML. The challenges are while reading an element it gives incorrect format.

30
tomf
Supporter
T
tr98
asked in Transformers
Validate a JSON file against a specified schema

I have a schema JSON file that I want to use to validate various JSON files. What transformers can I use to perform this functionality? JSON Validator only validates syntax and not schema so what's the alternative for this?I have added pictures of the sample JSON schema and also the JSON file that needs to be validated against that schema.

2460
T
gogopotter90
Contributor
gogopotter90Contributor
asked in General
How to integrate FME Server with SAP BW ?

Hello ,Will be possible that FME Server integrate with SAP BW ?i would like to deliver the data output of fme to sap bw Thanks in advance 

1020
gogopotter90
Contributor
johnglick
Contributor
johnglickContributor
asked in Integration
Connect to an api that uses a hashed challenge and verifier (PKCE) as part of the oauth2.0 flow?

It seems I have no place to force FME to include the code_verifier parameter in the request body to obtain a token (see requirements below). Any ideas of how to work around this in FME? The postman equivalent is selecting the grant type as "Authorization Code (with PKCE)". I can use the same challenge and verifier more than once, just need to include it in the body rather than a querystring.  Per the platform's API docs: Parameters sent in Request Body, Form-URL Encoded. (cannot use JSON or querystring)code=<code received in callback url>client_id=<Application OAuth Client ID>client_secret=<Application OAuth Client Secret>grant_type=authorization_coderedirect_uri=<User redirect URL (from step 4)>code_verifier=<User Generated Code Verifier>  

400
johnglick
Contributor
S
sresree
asked in Transformers
Oracle Materialised View Refresh

Hi,  I have a requirement to refresh a materialised view in Oracle database, read the view and then write to a CSV file. Reading of the view should only happen after the view is refreshed. Tried using 2 SQLCreatorsFirst one,BeginDBMS_MVIEW.REFRESH(SCHEMA.MVIEW_NAME);End; Second One,Select * from SCHEMA.MVIEW_NAME; How to make sure that Materialised View will be read only after the view is refreshed? Thankssresree   

564
geomancer
Evangelist
R
rb12345
asked in Data
If i have an outline of the UK and coordinates dotted around the UK represented as points, is it possible to create polygons which 'colour in' the UK based on the closest point? and if so, what approach should I be taking?

Ultimately, i aim to end up with a map where you know depending on your location, where your nearest point is, represented by area.

140
R
Q
quangig
asked in Data
How to convert DGN to DWG ?

Dear All,I need a full video tutorial to convert objects on Micrcsation v8i software to Autocad software using FME software?Someone did it, please guide me.Thank you very muchPham ngoc Quang

1740
Q
Z
zacharylee_1204
asked in Transformers
Transformers questions

Hello Sir/ Madam, I have several transformers that I am not quite understand even I checked on the "help". I hope someone can give me a hand. May I ask what is the purpose of using transformer "Creator"? I often use "reader" to add the data. However, I saw other people use "Creator", may I ask why?What is transformer "GeomtryCoercer" does? It said to reset the geometry type, what does it mean?How about "Aggregator" and "Deaggregator"? does it mean to combine and separate data? Thank you.

170
Z
K
kojinkuwahara
asked in General
I want to convert a file with extension ".SFC" in FME. SFC does not seem to be included in the Reader's Format. Is there a possible way to deal with this?

SFC (Scadec Feature Comment file) files are used to store CAD data and are included in the SXF (Scadec data exchange format) format of the CAD data exchange standards.

220
K
nedwaterman
Contributor
nedwatermanContributor
asked in Transformers
TopologyBuilder not finding correct edge

I'm using the TopologyBuilder with default settings to create linkage in an ESRI sourced water network - mainly because there's no node-to-node connectivity like there is in Oracle.Generally its working well but has thrown up an anomaly. The transformer has created the edges of a line which should be two adjoining mains at the left and right edge, but instead the left edge is showing as joining to itself. In the picture the highlighted main should be showing with a left edge of edgid 83360 and the right edge of edge_id 83331. Instead the left edge is 83391 - which is itself:   Any ideas why this is happening? I have used a snapper and GeometryValidator and there appears to be no issues with the geometry. Do I need to add a tolerance into the TopologyBuilder?Many thanks in advance!

150
nedwaterman
Contributor
B
bigjonas69
asked in Data
Generate simple trees from Point Cloud (LIDAR)

Hello,I want to create simple mesh trees from Point Cloud (LIDAR) in FME. And the closest thing I came to was with the "PointCloudSurfaceBuilder" transformer.Can anybody help me with this, please. The file is the way I want the final trees look like (it seems like it is about 8 piece of pentagon polygons for each tree).And the file is the closest I came in FME.I attach the FME-Workbench file and the input LAS file (and it looks like this ).Best regards,Jonas

4640
caracadrian
Contributor
hugues
Contributor
huguesContributor
asked in Transformers
HTML report with point and polygon on the same page

Hi. I try to create a HTML report (with Esri Leaflet) with point and polygone on the same map. It's possible ?

90
redgeographics
Celebrity
D
dwinvegas
asked in General
Training postGIS database down? Cannot connect to sample postGIS database (postgis.safe.train.com) to complete FME Academy Trail Integrate Data with the FME Platform.

100 % new to FME and FME Academy. As a new user I have started my first trail, Integrate Data with the FME Platform. The third Module, Transform Data, has the student connect to a postGIS database, called fmedata at: I have tried this as documented, but get no response. A ping to this returns: Pinging ec2-54-214-172-21.us-west-2.compute.amazonaws.com [54.214.172.21] with 32 bytes of data:Request timed out. Is the database available? 

730
ryanatsafe
Safer
M
mnikosz
asked in General
Log file workspace parameter is missing

I use Data Interoperability extension. I try to change the location of the log file, but the Log file parameter is missing from Navigator > Tool parameters > Logging . There is another ETL tool in the same toolbox, where I can see the parameter. Any ideas why is it missing, and how can I make it visible? Thanks.

110
evieatsafe
Safer
joy
Enthusiast
joyEnthusiast
asked in Transformers
How to convert from dgn (v8) to ifc?

Hello everyone,For my colleague I would like to convert dgn (V8 and 3D) to a IFC file.I tried based on the following link that converts dwg to IFC. I tried to adjust the workbench from that link to make it work with Microstation (V8), however I am already stuck at the Creating the Space Geometry part. There are a lot of attributes for which I don't know what the Microstation equivalent is and I am not sure whether what I want is to currenlty possible to achieve in FME desktop 2022.For example I don't know the Microstation equivalent of these autocad attributes:Height LongName Nameautocad_entity_handleI was wondering if someone can send me in the right direction

4940
daveatsafe
Safer
inframan
Contributor
inframanContributor
asked in Transformers
Spatial data and Tabular data will not write to the same GDB.

I have a workbench that reads .dbf tabular data and .shp spatial data and writes both to a Fgdb. It works fine if I manually point to an existing gdb but when I try automate gdb creation by exposing the "fme_dataset" and use that for a location and filename, via fanout, it only writes the tabular data. I can get it to write the spatial data but it comes out in another gdb labeled "null."  I'm guessing that since the dbf and shp and not directly linked the writer doesn't see the "fme_dataset" based gdb as an option. I've even tried directly linking the table to the shp with an AttributeKeeper but its still creating a second "null" gdb instead of inserting the spatial data in the "fme_dataset" based gdb.

110
inframan
Contributor

Badge Winners

  • FME Form Basic Training
    dezuviriamhas earned the badge FME Form Basic Training
  • Welcome Back
    dwade10has earned the badge Welcome Back
  • Integrate Data with the FME Platform Training
    johnrochehas earned the badge Integrate Data with the FME Platform Training
  • Student (Grey)
    westerbrinkhas earned the badge Student (Grey)
  • Teacher (Grey)
    westerbrinkhas earned the badge Teacher (Grey)
Show all badges

Community Stats

31,798
Posts
120,793
Replies
39,417
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.