General

Can anyone suggest a really good changedetector tutorial or documentation? I'm having difficulties understanding the output where a change in attributes and/or geometry is found. I can't tell which attributes changed (before and after) and I'd like to see exactly where the geometry change is instead of only seeing which features have changed. Hope that makes sense. I'm still learning.

Say I have the following data; for which I can see the following information in the Feature Information window; feature 1; text (bytes): 48656C6C6Ffeature 2; text (string: UTF-8): World Is there a way that I can filter the features on the basis of the indicated data type (i.e. 'bytes' vs 'string (UTF-8)'?

Examples: 10 > 10 5.1 > 5.09999990463256 10.1 > 10.100000381469727 20.1 > 20.100000381469727 17.6 > 17.600000381469727 20.3 > 20.299999237060547 8.4 > 8.399999618530273 5.3 > 5.30000019073486 207.97 > 207.97000122070312

Hi there I am trying to connect a reader to sharepoint to read some information in. When I press authenticate this is the error that I get. I was wondering if anyone knew how to fix this? All the best -Ed

Either directly or using Python?

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? :(

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

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 this I want Output like this in one single Row and the same layout

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:

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?

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?

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

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.

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 name Is there a FME Transformer that can write a user parameter to the Log? With some surrounding text?

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?

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.

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 !

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.

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

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.

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?

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.

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/1983 I 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.

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