General

I see this new UPSERT functionality...Where can I find help docs for upserting to file geodatabase gdb?  Thank you, TylerSAFE FME 2022.1

Hello.I have two excel files (1) and (2) that contain a column of addresses.The "House number" column in the excel file (1) and the "Houseno" column in the excel file (2)How could I compare the two columns and notice the similarities and differences.Thank you very much! 

This is the error I am getting when I trying to upgrade the pip --version in the base image and build a new fmeserverengine image:Step 2/45 : RUN python3 -m pip install --upgrade pip ---> Running in 95e4bf57b3f0Fatal Python error: Py_Initialize: Unable to get the locale encodingModuleNotFoundError: No module named 'encodings'Current thread 0x00007f43b515f740 (most recent call first):Aborted (core dumped)Fatal Python error: Py_Initialize: Unable to get the locale encodingModuleNotFoundError: No module named 'encodings'Current thread 0x00007f43b515f740 (most recent call first):Aborted (core dumped)Service 'fmeserverengine' failed to build: The command '/bin/sh -c python3 -m pip install --upgrade pip' returned a non-zero code: 134 The base image which I took it from :/quay.io/repository/safesoftware/fmeserver-engine:20632 

Hi, After using the NDVI calculator I would like to get the image indices that vary between -1 and 1. How can I do this in FME? Thank´s

Hallo , i have lines data and I have only start point and end point of line .but I would like to get all geometry of points from start till end point.,so I have used chopper to convert lines to points but my problem .I am not sure ,how could i add all geometry of points from start till end point in new attribute for the same id of line .FME 2021Thanks for help .

Hi I am trying to connect to a public S3 bucket and have tried multiple times to connect and download files in the bucket. I just keep getting an error message. I'm probably entering something wrong but I've tried multiple different things and no luck so hoping for some guidance here. S3Connector: There was an error connecting to Amazon S3: 'Parameter validation failed:Invalid bucket name "shaking-layers/": Bucket name must match the regex "^[a-zA-Z0-9.\\-_]{1,255}$" or be an ARN matching the regex "^arn:(aws).*:s3:[a-z\\-0-9]+:[0-9]{12}:accesspoint[/:][a-zA-Z0-9\\-]{1,63}$|^arn:(aws).*:s3-outpo...'. Confirm that your credentials and region settings are correct. Some regions are not publicly available - contact AWS for more information. I have attached a screenshot of what I am entering in the S3 Connector.

Hi, I have a parcel data with various years in the postgis database and I need to executed topology year wise to find out the topology errors across the years. I have query to filter out the data in year wise and the query is (column1 < Year and column2 >= Year). My first question is how to retrieve the various years in DB for that particular area and my second question is how to pass the years to fetch the data pertain to that particular year and pass it on to the dissolver transformer, kindly let me know.     

I have two sets of points, A and B. I would like to create lines between them, only if the distance of this line is < 500 meter.  Currently I achieve this using a 1-on-1 join in the FeatureMerger. For each point in A there is a list element with the coordinates stored for point B. So if I have 300 points of A and 200 of B, I would have a list with 300 features, with each feature having 200 elements. I then explode the list, and then for each point of B, create the feature, and then check if the distance is <500 meter. This is unfortunately very bad performance-wise, since there are a lot of unneeded connections (> 500m) being made. When running the workspace with big sets of points in A and B this can really effect efficiency. Is there a way in which I can check the distance between two points before I create the feature?

Hi,  I'm trying to run an FME process from the command line like I have many times before (fme example.fmw) However, it is opening the wrong version for the workspace. The workspace is in 2022 but the command line is opening 2018 (which is also installed on my computer). Is there a flag or something I could add to my code to ensure it opens 2022? My workspace has newer transformers than 2018 so it crashes everytime I open it I have tried adding it to the system path variable, but this doesn't do anything, unless I'm doing it wrong Thanks

Hi, I have some points and they have an attrobute called code. I want to create a polygon around the points with the same code ( similar to Voronoi).  Can some one help on how to do that. Thanks and Regards, Krishna

Hi. Could someone advise how to write the attributes to the postgres DB, but at the same time write the coordinates in the geometric data type? I have postgis extension in postgres DB. I don't see any such data type in the user attribute tab on the postgres writer. Thank you

Greetings,I have selected the Esri ArcGIS Python 3.7 option, in Translation.I am getting a Python symbol error??Any ideas how to resolve this issue?? The error msg is:PythonFactory failed to load python symbol `FeatureProcessor'Factory proxy not initializedPythonCaller_2 (PythonFactory): PythonFactory failed to process featurePythonCaller_2 (PythonFactory): A fatal error has occurred. Regards,Clive   

I have a table (BKR2) with x and y coordinates, but no address.There is another table (GBA_address) with x and y coordinates with address.i would like to search with x and y coordinates from table BKR2 for nearest x and y coordinates in table GBA_address.Is that possible and how? 

Hi, I have a contour dataset which has been clipped incorrectly and has produced errors in the resulting polylines. There are numerous breaks in it, for example, the 0.8m contour line (see attached image) and I would like to join these together. A straight line is fine. I have tried Snapper and LineCombiner with no success. Any suggestions would be great!Thanks.

I have workspace that currently has one choice dropdown input parameter that lists regional utility companies. The parameter dictates where the input data is read from and where the output data is written. On FME Server, I have setup separate Users for each region. The client has requested that I limit access of each regional User to it's own region. So, say we have Region1 and Region2. Region1 shouldn't be able to run the workspace by selecting Region2, and vice versa. My thought is, if the FME Server User accessing the workspace is available at run time, I could essentially do away with the drop down, and let that dictate which data is processed. Is this possible? If not, what would be my best course of action to accomplish that separation. My second thought was create separate repositories for each region, but then I would need to make copies of the workspace only allowing a single choice in the dropdown. This doesn't seem very efficient, and would pose an issue when upd

Hi all,Just a quick question:What I try to do today is to write a hyperlink from my workspace to a word document. I am compiling a Word document with a bunch of MSWordStylers and one of the paragraphs contains a hyperlink... I have been looking around, and it looks like it is currently not possible to insert a hyperlink to a word document using the MSWordStyler. Is that still true, or did I miss something? And: would there be an alternative route to accomplish this? Any insights will be highly appreciated. Cheers, Egge-Jan

Hell everyone, I apoligize if this has been answered already but I haven't had any luck trying to find a solution. Basically I have a URL in HTTPCaller that I need to append a value at the end of so that I can run multiple GETs. The values that I need to append are stored in an AttributeManager column. I understand that I may need to create some type of looping function that will go through the list of attributes, append the first value to the end of the URL in HTTPCaller, run the GET request, save the results, get the next value in AttributeManager, append to the end of the URL, run the request, etc.. but not sure how this could be configured in FME. Ultimately we will need to place the results of all the GET requests in one data set.

Hi, I have 25000 dgn files and I want to convert all of them into a single shape file and want to add the following attributes in the shape file File name of the dgn as attributeLevel name of the dgn as attribute I would like to convert only the line geometry from the dgn files. Please help

Migrating from FME 2018 - FME(R) 2018.1.0.0 (20180717 - Build 18520 - WIN64)Migrating toFME(R) 2021.1.1.0 (20210730 - Build 21619 - WIN64) We have a web portal that triggers FME workspaces and gets a response. The HTTP Caller is used to POST a request to the portal (JSON message). It works like a charm in FME 2018. Migrating the same workspace to FME 2021, the web portal can trigger the workspace but it gets no response.  We have checked the proxies etc. They all seem to be in order. Looking at the settings of the transformer, FME 2021 has two additional settings.HTTP VersionRedirect Authentication Looking at the help of 2018 - http://docs.safe.com/fme/2018.1/html/FME_Desktop_Documentation/FME_Transformers/Transformers/httpcaller.htm there seems to be no mention of the default version. So, the question is what does FME 2018 use?  The error:

Hello FME Friends, Automation Apps Sneak PeekFME 2022.2 is coming, and with it is an important piece of new functionality in FME Server: Server Automation Apps. So me and my colleague Kezia Yu are hosting a Sneak Peek presentation next week, to unveil this new tool and to show you all how it works and why it can enhance your FME workflows.  LinkedIn doesn't let me set up the streaming link until an hour before, so just reply yes to the above invite to keep informed. Q) How are Automation Apps different from Server Apps?A) Normal Apps are set up to run a workspace. Automation Apps are set up to trigger an automation. It lets us carry out a longer process than just one workspace. Community Survey Last ChanceYou have a final chance now to give me feedback in my mini-community survey. So far, I hear that... You like product news and tips/tricks in What's Up Wednesday, but not certification shout-outs.You don't want too many contests, but you liked FME's Favourite Transforme

Hi, One FME Workbench user in my organization recently had FME Workbench 2022.2.0 (build 22765) installed on his Windows 10 (Enterprise 21H2) machine and it was working perfectly up until a few days ago. He even went on a Basic FME introduction course without any problems. But suddenly, FME Workbench won't even start up. According to Event Viewer in Windows 10, fmeworkbench.exe crashes because of an unknown error in Qt6Gui_fme.dll:  However, FME Inspector runs just fine. To our knowledge, there has been no updates or changes to Windows 10 on his machine. We also tried deleting %appdata%\\Roaming\\Safe Software\\FME\\ but it made no difference to FME Workbench. Does anyone have any other ideas we could try out?

I have a dataset with a mix of 3D lines and arcs. When using the CoordinateRounder, it removes the Centerpoint Z Coordinate and changes the type from ArcByCenterpoint to ArcByCenterpointWithEnds . I do not want this.   

Wondering if anybody have encountered the following issue before. I notice that in FME2019, I can put in any file paths (even non-existent ones intended for C:\\Temp) by text editor. FME2022 seems to block it with a warning and I cannot click OK in the dialogue whenever that happens. This happens both within Transformers and with Readers/Writers. Is there’s a new setting or a toggle switch somewhere that will bypass the warning? This screenshot illustrates the problem when I’m trying to upgrade a EMailer transformer to 2022 version (from 2019).

I am using geodatabase writer and I am using test filter before the writer and my data are lines and points .I would like to change the color of lines and points before writing it as geodata base .my target :when open the geodatabase file later.it shows different colors for different lines depends on specific attribute .so will be possible to change color of lines ?