- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27668 Posts

Most replies

Most views

Newest first

stuarmitagehomeContributor

asked in Authoring

Is there a better way than using a ridiculous number of Feature Joiners?

Surely there’s a better way than this???I have a json file with lots of attributes hidden in lists. So I use 5 ListExploders to expose those attributes.The ultimate goal is to then combine all of those attribute fields into one massive table, using the unique identifier field of “NODE_ID”.As you can see in the screenshot the Node list then feeds into AttributeFilter to reduce the number of features a little.So far so good… but this is where it goes a bit mad. I then need to combine all of those 5 exposed lists into one table. FeatureJoiners are then used to try to merge the datasets together.Those in the left hand bookmark are joined using an inner join to try to get as many features with the same NODE_ID value combined into the same row in the table.Those in the right hand bookmark then use a full join to pick up any stragglers from the first bookmark.I have 200 JSON files to work on, and this example uses just one of them, so I have to try to account for all output ports, to ensure n

Writing data into an ESRI File geodatabase writing to a feature dataset

I need to set up a workspace to write a file directly into a specific Feature dataset within an ESRI File Geodatabase - is there any way I can set this up.

3683

6 months ago

thomasmartiContributor

asked in Data

Reading RGB from ZFS Pointcloud

HiI got an ZFS Pointcloud (here) with integrated RGB colors. These are greytones (concrete) and visible in Autodesk Recap. From Recap i can export the PointClound to an e47 file and the colors are still included.But i got over 1’000 files, so I want to convert them with FME. With the ZFS Reader i can load the PointClound, filter it with the header information as decribed in the help (reflection), but the color is missing. Regarding the help, FME can read the color from an color file, linked in one of the header information, but I got no such files, the colors are integrated. How can I get access to these RGB values (color_red, color_green, color_blue)?

512

6 months ago

narinderContributor

asked in Authoring

How do I get my FME workbench that uses 2 Readers pointing to SQL tables to be outputted to Excel template writer but the two outputs to saved to two different tab sheets.

I’ve got an FME workbench that picks up 2 seperate SQL tables in the two readers and the data is sorted and the filtered. It then needs to be output to an Excel template containing 2 tab sheets and save the data from each SQL table onto the separate sheets.Test copy of workbench looks like this:This first attempt only outputted the data from the first reader onto both tab sheets in excel.Then did this:So this did pick up both readers but instead of saving the one excel template with the data outputted to both tab sheets, it created to excel files with the data being populated on the tab sheet.Essentially I want to pick up both sql readers, sort them and filter them and then output to the excel template but the data gets saved onto sheet 1 and sheet 2 for example for each reader and then save the one excel file to the drive location!Am I missing a step or should i be using different transformations, etc?Appreciate any suggestions?

362

6 months ago

lindsayContributor

asked in General

Read Excel File from SharePoint Online as Attribute, Rather than Downloading

I am trying to create a workspace to read the contents of an Excel file from SharePoint directly into memory to then operate on, rather than download the file to a temporary location first. I understand that I should be able to read files to memory by using the SharePointOnlineConnector with 'Action: Download' and 'Download as: Attribute' settings, and have had a degree of success with a simple text file that I'm using for test purposes.The '_contents' attribute returns the full content of my text file, as below:However, I'm not sure how to deal with this attribute to make it usable after this point… I've tried passing the '_contents' attribute to a CSV FeatureReader as the 'Dataset', but this didn't work, as the reader tries to open a file at the location specified within that attribute. I guess I've already read the CSV file with the SharePointOnlineConnector, so now need to work with the attribute directly...Reading an E

4424

6 months ago

lorenrouthContributor

asked in Authoring

PythonCaller: No Geometry or original attributes are returned

This script works, but leaves out the geometry and original attributes. My hunch is there’s something wrong with the close(self) function, but I’m stumped. The code takes a feature id number and list of nearby ids from a NeighborFinder list, where it matches them up and assigns a _group_id attribute to use with the Aggregator. Really, it should be part of NeighborFinder. The way I had been grouping features is to use two or more AttributeCreators and assign a common Id from the feature and id list. It’s a hassle because you end up with duplicate features. Very inelegent. I have seen a few posts on missing attributes, but I can’t see how they apply to my code: import fmeimport fmeobjectsfrom collections import defaultdictclass FeatureProcessor(object): def __init__(self): self.og_ids = [] self.closest = [] self.lines = [] def input(self, feature: fmeobjects.FMEFeature): id_number = feature.getAttribute('_count_Glaz_H') if id_number is not

382

6 months ago

hoa_leContributor

asked in Data

Getting attribute information of multiple polygon intersected by line

Hi everybody,I have a map with 'Layer A' (polygons district boundary) and 'Layer B' (lines roads).I would like to add a field on my 'Layer B' table with the name of every district crossed by each road.In this example, I would like my Road 1 attribute to tell me it crosses 'City A', 'City B', 'City C', and 'City D'. And my road 2 attribute to tell me it crosses ‘City A’.Could you please show me how to make it? Thank you

707

6 months ago

vkiContributor

asked in Transformers

catch error in sql-statement run in the SQLExecutor

In an sql_executer I run an sql-statement that updates a table, but does not output any features. If there is an error in this update, an error message appears in the log file, but the translation as a whole is successful. How can I intercept this error so that the translation aborts if there is an error?

262

6 months ago

kardemummabulleContributor

asked in Transformers

RCaller

Hello,I have a general question regarding the RCaller. I have been actively coding in R over past 10 years, and started playing with integrating my code into FME for automating some of the analyses about a year ago, but what bothers me most is that FME is always putting up a fight whenever facing more complex custom R functions, i.e. loops, advanced raster processing involving raster lists/stacks, LiDAR, etc. It is always a problem when trying to get FME recognize the results as fmeOutput, and it is just never easy compared to how other things work in FME...It just seems like the RCaller is so basic in FME, rudimental even, not allowing no unleash the full R potential within the FME environment. Hence is my question to you, have you guys considered developing it further or is it because nobody is really interested in using R inside FME? Or is it just my subjective opinion and I am basically missing something? :)@dmitribaghThanks in advance.-Sveta

1775

6 months ago

rudystricklan1Contributor

asked in Transformers

Remove Geospatial PDF White Collar

Is there a way to specify removal of “white collar” areas in Adobe Geospatial PDF outputs? I don’t see any options in the Page Size parameters to restrict the output to be just the extents of the Reader-specified image source.

312

6 months ago

salvaleonrpEnthusiast

asked in Transformers

What's the quickest way to get to AI Assist for Regex?

Just curious. Currently it takes about five clicks using the AttributeManager to get to AI Assist. Any shorter way?

382

6 months ago

lazarlubomirContributor

asked in Transformers

How to create WKT in FME

Hello,I created bounding box in FME and I need to get from this polygon WKT file. How can I reach this in FME please?Thank You so much!

5312

6 months ago

lorenrouthContributor

asked in Authoring

'Error Running Translation' immediately in version 2023.2.4. Works fine in v2023.2

I was installing a Python module and pipeline (spaCy and en_core_web_sm.whl) into FME2023.2.4. spaCy installed fine, but pip would not install the pipeline and I got this message: Since then, my FME 2023.2.4 will not work, at all. No translations will work. I made a blank Workspace with just a Creator and still immediately got: “Error running translation”.What’s going on? Did I break it? Do I need to reinstall? My FME2023.2 works fine with the same Workspace.Any help is appreciated.

482

6 months ago

scarecrowContributor

asked in Transformers

Error "The table name or field names may be too long or invalid for the server"

Hello,I’m trying to read specific feature classes from an SDE database using a user parameter within a feature reader.I’ve not had a problem with this previously so not sure if it’s a bug (I’m using FME 2023.1.2.0 (20231110 - Build 23641 - WIN64) The issue I’m having is:When selecting feature classes manually in the ‘Feature types to read’ section of the Feature Reader window I can select as many as I want and they’ll all read fine.When using the user parameter (please see settings in screenshot below):Selecting one dataset reads fineSelecting 2 or more feature classes I get the error “Error creating feature dataset 'feature class a feature class b'. The table name or field names may be too long or invalid for the server” Thanks for you time

1213

6 months ago

joaniegeo99Contributor

asked in Authoring

Error using User Parameter for FeatureReader dataset

FME(R) 2023.1.1.0 (20230928 - Build 23631 - WIN64) FME FormHello,I have a set of QAQC workspaces that I’m trying to run in sequence with workspace runners. I have a parent workspace that, using scripted parameters, generates a bunch of output file names where I’ll write the results of the various workspaces, and runs workspace 1, then workspace 2 then workspace 3. I only want to run workspace 3 if my tests ‘Pass’ in workspace 2. So I write out a CSV file called _qaqc_status.csv in workspace 2 with ‘Pass’ or ‘Fail’ as the only attribute; the file location is in with the data and is variable.The problem comes when trying to read the parameterized file name ($(QAQC_STATUS_CSV)) with a FeatureReader; I get the following error message Worker 27572 > CSV reader: Failed to open file '' for reading. Etc, etc.and my CSV doesn’t show up on the output ports. If I hard code the FeatureReader dataset to an existing csv it works fine.Any help is appreciated, or even a workaround suggestion. Th

302

6 months ago

dcoxContributor

asked in Authoring

Help using string replacer

I am trying to join a SharePoint table with no geometry to a set of polygons (about 2000 rows). The table has unique project titles for for each polygon that I want to use as a join field; but the polygons themselves are stored as fgdb files deeper within the SharePoint file structure and they are a non-standardized legacy dataset that I am trying to aggregate (hence why I am transferring them all over to SharePoint as the first step). When writing the fgdb’s I am also exposing the file path as the fme dataset field, so the unique project id’s in the table are a part of that file path. I am trying to use the string replacer to replace all the characters leading up to, and after, the project title with nothing so that only the project title is exposed. Sadly I can’t just count the characters as there are different folders within the file path with different names and character lengths so now I am trying to come up with a more complicated regex expression that will trim the start and th

705

6 months ago

alanalibertiContributor

asked in Integration

kml placemark name as output dwg layer name

Hello allI’m trying to achieve the above, so far I’m struggling on how to find out the KML reader ‘placemark name’ property, to write it as a DWG layer name.Could anyone point me out on how to do that? Thanks

625

6 months ago

fme_hansContributor

asked in Data

Shorten a line on both sides

Hi, How can I shorten a line by 10 cm on both sides?

422

6 months ago

cosminciotinaContributor

asked in Transformers

Assign first vertex start as different km than 0 for snipper.

Hi.I’m using the snipper transformer to extract portions of a line at specific values from the attribute table.I set these parameters for the transformer. I set these parameters for the transformer.The problem that I noticed is that the program considers the first vertex of the line as 0 and the last one as the maximum, and the snipper will split between these two values.Is there a method to define the start value using another value, not 0? I would like to start from 4.21 km.Thanks.

241

6 months ago

marjan_nikoukarContributor

asked in Data

how to downloads data from an FTP server using FME

Hi,I have FTP Link, User, and PasswordHow Can I download a file using FTPCaller?Thank you for your assistance

862

6 months ago

oscarwParticipant

asked in Integration

Blocked from connecting to ArcGIS Online services

Unable to connect to ArcGIS Online services through FME Form. This issue began at approximately 4pm AEST on 5th June 24. No connection issues were apparent earlier in the day. Can anyone suggest a solution to this? I’m unable to add a new connection or use an existing.Wondering if this is an FME or ESRI issue?Updating access token for 'BCT Enterprise'JSON Error: Access to this application has been blocked. Please contact your administrator to allow access to this app.Unable to update access token for 'BCT Enterprise'Python Exception <FMEWSException>: Type: 4, Number: 1, Message: Failed to get authorization query string.An error has occurred. Check the logfile above for detailsMany thanksFME version 2023.2.2.0

772

6 months ago

gogopotter90Contributor

asked in Transformers

how to write the new data into different Feature Classes into Esri arcsde ?

Hello ,i would like to create new points and new lines in FME and write the output in Esri arcsde (I have license for that )I have to write the new data in Feature class and and table class and establish a foreign key relationship between the data between the two classes . 1. is there other classes should I write the new data into it ? what should be i edit in workbench and the next steps to show the data in arcmap without any problem ? Arcmap generates obj_id when we add the new point ,will be possible to write obj_id that not used before in arcmap ? does anyone did a simple workspace ,could upload it to understand the idea ? thanks in AdaVance Fme 2021

2eightContributor

hello i am trying to write something in excel format but the result are like in the picture, how to write the data from the start of each rowplease suggest

926

6 months ago

mnilukaParticipant

asked in Data

IFMEMultiSolid to Multipatch

Getting the below error when trying to write the IFMEMultiSolid to Multipatch. I’ve tried to deaggregate the geometry but that didn’t work.The 'HAS_Z_VALUES' keyword is set to 'AUTO_DETECT'. With the exception of MultiPatch feature classes, the dimensionality of new feature classes will be based on the first feature written to the feature class. (Features with no geometry are considered 2D)A default z-value of '0' will be used for all 3D features where z-values are not providedEsri Geodatabase Writer: Not simplifying geometries being writtenTransactions are being used by the Esri Geodatabase WriterEsri Geodatabase Writer: The field 'OBJECTID' in table 'Dissolved123' will not be updated since it is not editableProcessing on a solid has failed. The solid may be too complex, not closed, or not orientable.Esri Geodatabase Writer: Failed to write geometry to MultiPatch feature class `Dissolved123' +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `Diss

301

6 months ago

liseContributor

asked in Data

Joining two tables based on comparison of values

Hi, I am trying to do check if data is correct in one of my tables compared to another one. To do that, I thought about merging/joining the two tables based on columns and conditions. The common column between the two tables is the City Code (postcode). Then I need to compare landmark values, which represent the location of objects in space. I managed to join them based on the City Code column but I don’t manage to do the landmark values comparison yet. More context:My actual data is fields of grass along roads. Each section of road belongs to a city (City Code) and is separated into categories of landmarks. For example a road within city 1 is separated into groups of landmarks ranging from 1 to 1.5; 2 to 3; etc.; and the field X is situated at a specific landmark value 2.5.So the field should be in the landmark range 2 to 3 because its landmark value is higher than 2. The tables: The first table has 3 columns and links city code and landmarks to a unique ID: City code: the city pos

1834

6 months ago

1
...
42
43
44
45
46
47
48
...
1107

Page 45 / 1107

Badge winners

lalchandhas earned the badge Expert (Grey)
lalchandhas earned the badge Teacher (Grey)
lalchandhas earned the badge Student (Grey)
koronada92has earned the badge Expert (Grey)
rajulkumar12389has earned the badge Teacher (Grey)

Show all badges

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