- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,032 Posts
13,814 Replies

When you subscribe we will email you when there is a new topic in this category

4032 Posts

Most replies

Most views

Newest first

nitinshahaneContributor

asked in General

Can one execute Data Reviewer Checks using FME Workbench?

Either directly or using Python?

Undefined macro `UNIT' dereferenced in file

Hi guys, i'm having an issue when i run my workspacerunner. Undefined macro `UNIT' dereferenced in file `G:\\wb-xlate-1690810120428_4936' I't s workbench build in an older version (2021) of FME. And now i want to run it in 2022 FME version. But it keeps saying that error. I also tried to create an new workbench, with new readers.....but it won't work. What I am doing wrong? :(

2040

1 year ago

dustinInfluencer

asked in General

Dynamic listing of parameter names

One thing I prefer to do when building a new FME tool is to log the input parameters in a startup python script in order to facilitate debugging when things go wrong. A sample of the code I use is below.import fmeobjects fmeobjects.FMELogFile().logMessageString("Input parameter 1: ") + FME_MacroValues["parameter1"], fmeobjects.FME_INFORM)fmeobjects.FMELogFile().logMessageString("Input parameter 2: ") + FME_MacroValues["parameter2"], fmeobjects.FME_INFORM)This has worked great for a long time, however it's cumbersome because I need to manually enter the names of the parameters. I'm curious if there is a method for returning the names of parameters dynamically in the startup python script, and then loop through them to include in the log file. If this is possible, I could keep my startup script the same between all tools and simply copy it into new tools without having to modify.

How to get home licence in fme 2023 version

Multi rows in One single row

i have multi rows coming from the source and I want all that rows in one single row and layout same as I mention below Data Source coming like thisI want Output like this in one single Row and the same layout

1 year ago

dannymeusContributor

asked in General

Advanced Feature Type Parameters of the wrtiter in FME server are different then the upladed workbench writer table genaral settings.

When viewing (in FME server) my workbench that I uploaded tot FME server I see different Advanced Feature Type Parameters settings then in my Workbench on FME desktop. In my workbench the settings of my writer are 'insert, drop and create' after I upload the same workbench to FME server the settings in server seems to be 'insert, create if needed'.Why is that? I do not expect the settings change while uploading tot FME server. If I run the workbench from server the outcome is that the writer used the 'Drop and Create' and not the 'create if neded'...this behavior is confusing settings in my Workbench on desktop: the settings in FME server of the same workbench after uploading to server:

1 year ago

leif

asked in General

DJI metadata from images

We have photos in jpg format that were taken with a DJI drone. Usually all EXIF data are easily accessible using the JPEG reader, but not the DJI custom metadata. We need to access the data that shows up when opening the image in a text editor: I tried reading the files with a text reader, but that gives several thousand lines of text and no way of seeing which line of text is connected to which image. This should be a common problem for everyone with a DJI drone? Any suggestions for now and maybe a DJI photo reader or DJI EXIF reader in the future?

2990

1 year ago

aaronp_osniContributor

asked in General

How to process feature types one at a time for LAS files stored in a zipped folder (that contains many many zips!!)

Hi folks, I have LAS files that are in zipped and stored in a folder. There are 16 LAS files to each zip. Furthermore there are about 100 zips in the folder I'm accessing the data from! The zip files are about 2.5GB on average and I would like to process each zip at a time (sheet1.zip, sheet2.zip etc). I'm adding height attribution to building polygons using a clipper which is a blocking transformer, then the point cloud statistics calculator. I can use the Directory reader to produce a list of zipped files and feed these into a Feature Reader, then use a clipper to clip the LAS data to the building polygons. However the clipper is a blocking transformer which will wait for the FeatureReader to finish. Ideally I want one building polygon dataset for each zip (sheet1.shp, sheet2.shp etc). I need to somehow loop back to the start of my workspace and start again with the next file on the list produced by the directory reader. Anyone have any ideas?

140

1 year ago

dustinInfluencer

asked in General

Geopackage compatible with Intergraph/Hexagon Geomedia

I'm looking for information regarding writing features to geopackage with geometry compatible with Geomedia. I have found the article dealing with Geomedia geometry in Oracle (listed below), but nothing for geopackage. In my testing, FME successfully writes, but the tables are not visible in Geomedia. https://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/oracle_spatial/GeoMedia_Geometry_Repres.htm

480

1 year ago

thijsknapenContributor

asked in General

'Paste as Text' option for Copy-Pasting to Annotations in Workbench

Is there by any chance some kind of 'Paste as Text' option when Copy-Pasting text (often from online sources) to Annotations in Workbench? Personally I sometimes copy online sources to Annotations. However, I constantly struggle that also formatting is copied. For example, when I copy the following from this FME Community question;and paste it in an Annotation of FME Workbench, the result is;Whereas I would like to get;Is there some option/menu in FME Workbench to do so? I'm looking for something similar to the 'Keep Text Only' paste option in Microsoft Office. ps. Currently my way to work around this, is to first paste text to notepad, and then to Workbench.

320

1 year ago

nicholasContributor

asked in General

How to write stuff to the Log?

I would like to write some messages to the Log, at the end of a successful Translation.For example, the source schema & table name and the destination schema & table nameIs there a FME Transformer that can write a user parameter to the Log? With some surrounding text?

Tester filter not working

I am trying to get the result when both "insert" and "unchanged" have values, but if one of them doesn't have a value, it's going to fail. Can anyone please help?

How do I write changes to a MYSQL database?

This is my first time using FME to update a database, I usually just write to another file. I have connected to a specific table in the database (multimedia objects) and I've basically filtered and done a string replacer on some instances in a specific column (product_uri). How do I now save these changes in the database? I just want to replace the 156 cells I string replaced and keep everything else as it was.

680

1 year ago

user01Contributor

asked in General

Copy cell value to another in the same column with condition

Hello, I think the answer is easy but I don't know how to do. For each fme_basename value, I want to copy the B3 cell value to the B1 cell.Thank you !

330

1 year ago

wrijsContributor

asked in General

How to feed a workspacerunner parts of a 60 million dataset.

I would like to input only 1,000,000 features at a time from a single 60,000,000 feature dataset (Parquet) to a workspacerunner. Can I use featurReader for this? I could select features based on attributes (dates or names) but I cant proces the data per tile or a spatial filter.

1 year ago

gogopotter90Contributor

asked in General

How RMinimumSpanningTree works ?

Hallo ,i have read an article about RMinimumSpanningTree . will be possible that someone provide me a sample workspace to understand it clearly . Thanks in advanceFME 2021

100

1 year ago

mattwilkieContributor

asked in General

How to efficiently compare log files across Server and Desktop?

I have a workspace that outputs fewer features when run from Server than when it is run from Desktop. The log files are ~2700 lines long so finding out exactly where they differ from each other is quite hard. I would like to feed the log files to a diff & compare program like WinMerge but the number of inconsequential differences between log files are too high. Even after removing timestamps I'm still getting hundreds of differences. How to search/parse/transform/rewrite the log files so only the notable differences are apparent? For example it doesn't matter that the path of DLLs are in different locations (in this scenario, in others it will be). It also doesn't matter that hundreds of HttpCaller download requests differ by a few milliseconds and/or 1 byte. However it very much matters the total number of features written is 2654 instead of 2658.

602

1 year ago

carolina_wContributor

asked in General

Spatial database indexes with fme

Hi, I have a question regarding the “create spatial index” option in the spatial database writer for Oracle.If you’re truncating an spatial table with an existing index. Do you still need the create index option on or is it redundant? And if not, is there any performance loss in keeping it on?

1710

1 year ago

wrijsContributor

asked in General

Meaning error message: An error occurred. Here is the information that FME was able to find on the error. Skipped 1491038/1512811 rows in column recordid

Hi, does anyone know the meaning of this error message I keep getting:An error occurred. Here is the information that FME was able to find on the error. Skipped 1491038/1512811 rows in column recordid.Does the problem lie with features number 1491038 until 1512811? Or any time comumn Recordid has value between 1491038-1512811? Or only feature 1491038 of 1512811 features. It's an error I keep getting and those exact numbers come up. The dataset I am trying to reed is a Parquet dataset.

1 year ago

benvkContributor

asked in General

Formatting a list to be included within an email.

Hi, I have a workbench that processes data of X number of rows. At the conclusion I would like to send an email to summarise what was done. I would love something like: Hi Ben, We have just updated the table with 32 new rows. Here is a summary of the data added: ASSET ID | NAME | DOB 150 | Ben | 02/02/1992 151 |Tony | 01/01/2001 .... .... 183 | Michelle | 03/03/1983I have added a statistics calculator to my workbench, this is currently able to give me the summary (total number of rows) to include in the opening sentence, but I am not sure how to add the 32 rows to the email, formatted as a table. I know this has to be such a simple task, I just cant work out how to do it! Thank you.

900

1 year ago

spidermanContributor

asked in General

Find neighboring points

Hello , i would like that each point to find the neighbor point .each point connects with other by a line .so I have a starting point ,i should find the neighbor point and the neighbor point find the next neighbor and so on .my problem : how to let each point to stop looking for the neighbour point if the next point is a starting point because some points are connecting to starting point FME 2021

110

1 year ago

wrijsContributor

asked in General

Tips for handeling huge Parquet singel file, trying not to load in the complete file.

Hi, what is the best way to avoid loading in a complete huge singel Parquet file (58 million records). My memory keeps running out. I have the option to split the data into smaller pieces with a Tester transformer selecting the data on date and then saving it to further process, and have done that with a child-parent workspace, and a tester + published parameter for the dates. But it still seems to go wrong due to memory problems. The process takes very long to save by date, especially loading in 58 million records before running the data through the tester. I would love tips on splitting up the data before loading in the complete 58 million records. or any other tips for dealing with Parquet files.

ARCGISONLINE MetadataOverwritter

I get the following error when I feed XML as an attribute from the XML updater. Reading in an XML file is no issue though.This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins

180

1 year ago

spidermanContributor

asked in General

How to provide geospatial pdf the real coordinates ?

Hello , i am new with working with geospatial pdf files.I have Problem that geospatial pdf has no real coordinates .My pdf consist of lots of building ,i am asking if I provide one building with real coordinates manually Will be possible to change coordinates of all other building to real coordinates automatically .what should I do to change coordinates of pdf to real coordinates ,any ideas ?Thanks in advance .FME 2021

280

1 year ago

gogopotter90Contributor

asked in General

Is there a method to open DGS or PFD format from DIGSilent power factory ?

Hello ,How to open file has extension pfd or DGS format from power Factory DIGSilent ? The only exporting format from power factory is PFD or DGS ,There is no license or other option in power factory to export other formats .is there a method to open PFD or DGS file in FME and export the data from it ?FME 2021

5820

1 year ago

Page 22 / 162

Badge winners

kraaz9395has earned the badge Expert (Grey)
kraaz9395has earned the badge Teacher (Grey)
kraaz9395has earned the badge Student (Grey)
dmccullagh.npcahas earned the badge Integrate Data with the FME Platform Training
sclarke_97has earned the badge FME Form Basic Training

Show all badges

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