- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27556 Posts

Recently active

Most replies Most views Newest first

marjan_nikoukarContributor

asked in Data

How to update a dataset using a change table in FME

Hi everyone,I have a feature class in a File Geodatabase that I need to update. I have two sources for these updates: a CSV file with codes of the changed features, which I should use to remove those features from the main dataset, and separate shapefiles for each changed feature that needs to be added back to the main dataset. (I shouldn’t delete and update the whole dataset, I should update the changed features only.)What is the best way to approach this in FME?Thank u in advance for your time.

735

13 days ago

fmeContributor

asked in Authoring

Generate measures on polylines with no measures attached in either coordinates or attribute table.

I tried generating measures on street segments but the measuregenerator is not calculating it right. It starts every segment from 0 instead of calculating from the end log. Any ideas how to resolve or calculate measures on segments with no measures? Thanks in advance!

574

13 days ago

deanhowellEnthusiast

asked in Transformers

Excel Writer - Multiple inputs - multiple sheets - different attributes per sheet

I have a FME workspace reader that reads in the various attributes of a particular workbench and want to send the results to an excel spreadsheet with one sheet per feature. Each feature has a different set of attributes and can’t figure out how to get each sheet to be only the attributes of that feature. Do I just need to have a separate reader for each feature_type or is there a way to channel all features into a single reader?

463

13 days ago

lifalin2016Contributor

asked in Authoring

Connecting multiple points by shortest lines possible ?

I have a large number of points, which I would like to join by simple lines (point-to-point), minimizing the overall summed length of the generated lines. There's no preferred path, but all points must be connected to each other by a single network of lines.My output just needs to be a set of simple lines.Do anyone have an idea on how to accomplish that, other than grinding it out in a PythonCaller ?CheersLars I

26814

13 days ago

vimva679Supporter

asked in Transformers

How to convert 3D Room / Model to 2D in FME

Hello I need help to get it right , i would like to convert 3D Room model into 2D (like how it looks from top). I am using 2D Forcer and outputting IFC , i could see the output in FME Inspector but, when i open the same file in Navisworks etc. it does not get opened...not sure what is wrong.

110

13 days ago

brunoContributor

asked in Transformers

How to automatically expose all attributes with pythoncaller ?

Hello,I use PythonCaller to create dynamically seveval attributes. But how can I get them outside the pythonCaller because I can’t described them in advance in the following area : Thank in advanceBest regardsBruno

191

13 days ago

tonoContributor

asked in Data

Destination Feature Type Routing Correlator

Hi,When running a workspace with cache mode activated i can see in the Translation log that fme form writes ffs, and writes and index and so starts it with a process i am not familiar with: “Destination Feature Type Routing Correlator” and it takes so long to go through.What is this process about? is it possible to avoid?Thanks in advance!

201

13 days ago

fikusasContributor

asked in Transformers

PythonCaller: download from FTP to specific folder

How can I download file from ftpes:// to specified folder? I’m using the script below.import fmeobjectsimport osfrom ftplib import FTP_TLSimport ssldef processFeature(feature): path = '/lsms/' filename = 'apples.zip' ftp = FTP_TLS('FTP-SERVER') ftp.ssl_version = ssl.PROTOCOL_TLS ftp.login('name', 'pass') ftp.prot_p() ftp.cwd(path) ftp.retrbinary("RETR " + filename, open(filename, 'wb').write) ftp.quit() feature.setAttribute('name', filename)

754

14 days ago

deanhowellEnthusiast

asked in Authoring

Workbench Content Summary

Hello, we have inherited a range of very large workbenches and was wondering if there is a way to get a summary report of the major components like parameters, database connections, inputs, outputs and names of bookmarks.

282

14 days ago

maddiegilesContributor

asked in Transformers

AttributeExploder Truncating List Name

Has anyone else noticed when creating a list using the AttributeExploder it truncates the last two characters of the list name, resulting in complications when using a ListExploder downstream because the list doesn’t exist.Using the default settings:Default List Settings in the AttributeExploder Transfomer The resulting list:List Name Is Truncated In Feature Information This broke a workspace that was previously working. It was a niggly one to catch as the only thing that had changed was the FME version.As a workaround, we created a user parameter which had the default value “_attr_li{}” and used that in the ListExploder which worked. FME Form version:FME(R) 2024.1.1.0 (20240729 - Build 24619 - WIN64)

381

14 days ago

anandak

asked in Transformers

How to read Oracle Spatial geometry in between the flow?

I am able to read a Oracle Spatial geometry using FME "Oracle Spatial Object" reader. However when I am trying to read a SDO_GEOMTERY using SQL_Executor, I am not able to expose the geometry attribute. How do I read a SDO_GEOMTERY in FME in between the flow? Regards, Ananda

556

14 days ago

rwachend

asked in Transformers

For speed of running the statistical calculator, is it possible to skip the "Complete" and "Cumulative" outputs when using Statistics Calculator?

For speed of running the statistical calculator, is it possible to skip the Complete and Cumulative outputs and only output the Summary ?

204

14 days ago

fme_can_do_itSupporter

asked in Authoring

Copy coordinates from a list in a Lat/Long column

I had a pair of coordinates stored in a single column named "geometry." I used the Attribute Splitter to separate these coordinates and then exploded the list. Now, I have each latitude and longitude in the same column. Is there a way to copy these latitude and longitude values into separate columns labeled "Latitude" and "Longitude" while maintaining the same order?

464

14 days ago

jaeParticipant

asked in Transformers

iOS18 and HEIC files - are they supported in any version of FME?

It seems that in the iOS18 update Apple made changes to the HEIC file container that means the FME Feature Reader using HEIF (High Efficiency Image File Format) now fails to read the HEIC files.We are currently using FME 2022.2.Is there a later update that will support iOS18 images? Is there an alternative way to read in these images successfully?

361

14 days ago

a_ericssonContributor

asked in Transformers

Column names to several different rows

Hey! I’m trying to do something that in my mind is very tricky, mainly because I don’t know how to do this. I have a table with bird “routes”. For some reason, each bird species is in a separate column, with a value for the number of individuals in that column. It can look something like this: In row 2, at one given location, 1 “Stare” and 1 “Grönfink” have been spotted. There are around 190 columns, making this table a bit odd to work with. To work with this data in a different project, I would like the table structured differently. What i would like as an output is a seperate row for each observation, with number of individuals as a seperate column. So, in this case, row 2 would be 2 rows, one for the “Stare”-observation and one for the “Grönfink”-observation. Basically, turning the column names into attribute values. Does anyone on this forum have any experience from this? Any help would be greatly appreciated! Cheers!/Alex

212

14 days ago

n.dContributor

asked in Transformers

XML (Real-estate cadastre information) to IFC

Hello everyone, I have an XML file containing the registered real-estate data and want to export it as an IFC file. What is the procedure to get the geometries and their atributes out of that file. As I have read, the first step is to use the XMLFlattener. But I do not know on which level do I have to flatten it (Elements to match). There are a lot of nested paths. If I select one path, do I have to select the paths under it? And this flattening process takes a really long time! What is the solution? I would appreciate your help.

452

14 days ago

gboquinContributor

asked in Data

SQL Server failing in SQL Executor in FME Form

Hi, I have a SQL Executor calling a stored procedure. I am running FME Form FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64) and am getting this issue:Microsoft SQL Server Non-Spatial Reader: Failed to connect using Microsoft OLE DB Driver 19 for SQL Server. Provider error '(-2146824582) Provider cannot be found. It may not be properly installed.'The transformer is not failing, but its not producing a result either. Not sure how to move forward with this one. Any thoughts?Thanks

382

14 days ago

marjan_nikoukarContributor

asked in Data

Split attributes and write them as feature classes in a new file geodatabase

Hi, I used an AttributeFilter transformer to split attributes. I want to write each of them as a feature class in a new file geodatabase. What is the best way to do that?Thank you for your assistance.

381

15 days ago

ebygommContributor

asked in Authoring

Directory and File Pathnames - Path Filter now case sensitive?

In 2024.1 it appears that a Directory and File Pathnames reader with a Path Filter set to *.tab only reads tab files with a lowercase extension.In 2021.2 both .tab and .TAB files are readA MapInfo TAB file reader pointing at a folder path such as "E:\Mapinfo\**\*.tab" still reads both .TAB and .tab filesIs this expected behaviour?

483

15 days ago

bmwhbmwhContributor

asked in Transformers

How can i simply split a pointcloud.

I have around 340 .las files and im just truing to split them. As you see in the picture i have a fair amount of distance between these files

565

15 days ago

olivierlParticipant

asked in Transformers

WorkspaceRunner and variable

Hello,I would like to test a variable before running a workspaceRunner or not.if attribute ‘recetteCouche’ = 1 then running workspaceRunner ‘000_recetteCouche..’0’ else if attribute ‘ecritureLivrable’ = 1 then running workspace ‘0000_ecritureLivra...’, etcmy configuration for each WSR is : ‘wait job job to complete = YES’Please, someone have an idea ?Olivier.

Writing to existing SQL Server table

Hello. I have a workbench that reads an XML and splits it into attributes with their values (with one spatial attribute). I am trying to write this data to an existing, empty SQL Server table. If I set the writer to create a new table, it runs fine, but I can't seem to get it to populate my existing table. The workspace runs, and passes with warnings, but when I go to my SQL Server table it is still empty. Any ideas? My writer is configured as follows: Feature operation: Insert Table Handling: Use existing The translation log claims that all of my features have been written, and the data inspector shows them fine, but it just won't populate my table. Thanks!

2496

15 days ago

georedyoParticipant

asked in Data

How to instaure a default value to continue the translation

Hi, i’m working on water treatment facilities. I’ve to categorize them in order to write a excel file which lists the existing and some deliverable. I’ll try to explain the best i can : basically the data are from a gdb, i’ve a tester to sort depending on categories. Some cat can have missing/null values, i need to “force” those missing values into the translation in ordrer to write the corresponding categories in the excel files.my situation now is that the missing values given they’re not written shift the writting in my writer and then do not correspond with their according row.i’ve 9 differents categories so 9 row but when i’ve just 5 filled categories, i’ve those 5 written but it change the alphabetical order in the written row so the categories dosent match the row. How can i say to the translator “if i’ve no values write the default value “0” else “no action”” Thanks, hope i’ve been clear enough

285

15 days ago

ebygommContributor

asked in Authoring

ArcsGIS Portal Feature Service connection - Proxy issues

Using the Httpcaller i can successfully make a rest api call to retrieve a token for an ArcGIS Portal Featureservice. A proxy server is set up but is not used for this url so the call bypasses the proxy. However, I can only set up and use an ArcGIS Portal Feature Service connection if there is no proxy set up at all. If the proxy is enabled, the connection tries to use the proxy even though the base url is on the exception list.

669

15 days ago

ben09loreContributor

asked in Integration

Dynamically changing URL in reader

Hi,I have an URL that I’d like to read in, but it contains the current date and thus is being updated everyday. How may I change the URL within the reader so that it’s automatically up-to-date?I’ve tried define a user parameter as a URL but I don’t manage to make it dynamic there. I thought I could replace the date e.g. 2024-11-05 with @DateTimeFormat(@DateTimeNow(),%Y-%m-%d) in the Default Value URL but it doesn’t work.Any help appreciated!

262

15 days ago

1
2
3
4
5
6
7
8
...
1103

Page 5 / 1103

Badge winners

changeofmotionhas earned the badge Teacher (Grey)
User15923979821343989192has earned the badge Welcome Back
ahmadrezakarimhas earned the badge Teacher (Grey)
oliverquirkehas earned the badge Welcome Back
johnthas earned the badge Student (Bronze)

Show all badges

30,142: 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.