FME Form

I have a workspace that reads from a very large table in MSSQL, unpivots the data and does some minor/simple processing in FME, then writes the data out to postgres. This workspace takes around 3 - 3.5 days to finish on FME Server. Reading the data doesn't take long, but processing and writing does. In an attempt to speed up the process, I tried to apply parallel processing by wrapping the entire process in a custom transformer with FeatureReaders and FeatureWriters instead of 'native' readers and writers to concurrently read different sections of the table, then process and write the data. I wanted to test the performance on FME Server with the writers turned off and minimal parallel processing (4 child processes) but it fails rather quickly with the following error: 3682021-12-13 14:55:51 | Error in child process '1', exited with code '1'3692021-12-13 14:55:51 | f_38 (TransformFact): Error in child process '1',

Hello FME'ers,Welcome to the last What's Up Wednesday post of this year. FME and the log4j Security Vulnerability (CVE-2021-44228)You have probably heard that a security flaw exists in the Apache library log4j, and that it is so serious that it has a 10/10 rating. In short, FME is NOT affected by this flaw. Although this library is included with FME, my understanding is that it's not used in a way that can be exploited. Of course, we'll still update it to a secure version as soon as we can, and may offer a patch for older FME versions. Plus in some cases, you can remove the library to ensure that there is no problem. For more details, see

FME server get current logged in user from token

Hello, I am trying to convert text strings like Jan-2019 to date . The text strings don't have the day values. I have tried using DateTimeConverter transformer and the date time functions in AttributeManager but it doesn't work when I specify %b-%Y. However, with the DateTimeConverter, when I convert text values like Jan-05-2019 using %b-%e-%Y , it is correctly converted to 20190105 .  How can I achieve the same to convert the dates like Jan-2019 without the day value to 201901 ? Thanks

I am in the process of converting a large Excel file to separate JSON documents for each column in the Excel, keeping a common ID column that each JSON document must contain. The hard way of doing things is using an AttributeKeeper to preserve the common ID column that I need and the specific column that I want to make a JSON document for, with a separate writer for each JSON document. Is there an easier way to do this, similar to a Fanout but instead of grouping by rows of similar feature types I can do it by column?

The documentation for the counter transformer references parameters that are no longer available in the latest counter version. How should the new counter be configured to pickup the count start from another counter in the same workspace?

I have a workbench that reads multiple Microstation files, and for some of the files, I need to remove some of the cell's so they are not written, and I have done this. I then have to write all the files to one Microstation file.  My issue is the remaining cells are not coming through into the Micostation output file. Each file being read has a different cell library and I have not had any luck combining them to 1, for the writer to read. so in the documentation I read that  "the cell members are assigned a unique cell sequence number in the igds_cell_sequence_number. This number can be used to later regroup the cell components if that is required." But I can not find anything in documentation on how to regroup them. I would like to try this to see if it helps me once I expand the cells. Has anyone done this before, and can offer some help? As this is my first time working with FME and Microstation files

I have several polygons in my workspace and I want to consecutively clip a subset against each other (see attachment). Of course I can do that all manually but if the input changes, then the workspace has to be adapted each time. I thought of using the aggregator to have the features on "first level" with a list of all features of the second level. Next step could be a custom transformer with a loop. Do you have any other suggestions? I am also not to deep into custom transformers and looping, so any advice is welcomed ;-)

Hi,I have FME Server 2021.1.2 Build 21627 - linux-x64.I have a problem with the filter jobs by user.It's impossible to find some users. For example with the user "generic".It's very embarrassing... As you see, it's works fine in the menu User Management 

-Because while the new data coming from httpCaller should be written to AttributeFileWriter, first the file starts the parse process. In this case, it causes old data to be processed instead of new data. -If I delete this file from desktop then run the workflow from fme server;-Fme server run workflow and see engine logs;Why do it works first parsing file then httpCaller ? True way that is it gets httpCaller new data firsly and write to file.

Error: An error occurred while installing package 'C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\PackageFiles\\safe.emailer': An error occurred while installing Python package with 'pip install --force-reinstall --no-deps --no-index --find-links C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\PackageFiles\\safe.emailer\\python --target C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\python\\safe.emailer --upgrade --no-compile fme-emailer' : Process crashed. Done both as a std user or an admin. Same issue. Any assistance greatly appreciated.  

I have a very old file while contain contour lines. And then I obtained a new DEM from which I generated new contour lines. Visually I can see that between 2 files, the contour lines of the same elevation differ in distance and they differ from one elevation to another. Is there any way I can get a statistical result about max, min, mean between these files? And is it possible to visualize this?

Hi!, How to create geometry from x,y coords received in .shp file? we need to migrate these coordinates as geometry in smallworld. Thanks

related to https://community.safe.com/s/question/0D54Q00008q2P5rSAE/fmeserverjobsubmitter-unable-to-connect-to-fme-server?t=1638881772264

How to Identify if an intersecting route is from Left or Right . I have my routes data as polylines whichever which i am testing out. How can I achieve this in FME? Thank you!

On our machine running FME Server, we have both ArcGIS desktop 10.6.1 and ArcGIS Pro 2.7 installed.  When we run workspaces that require an ESRI license, FME Server can get a license, but pulls a license from the ArcGIS desktop 10.6.1 license pool (As shown below). The same thing happens when the same workspace is run in FME Desktop. 2021-12-14 01:10:07 | The ArcObjects license 'Advanced' is being selected from the Windows registry2021-12-14 01:10:18 | FME has checked out an Esri license. The product checked out is 'Advanced'2021-12-14 01:10:18 | Installed ArcGIS version is '10.6.1' How can I configure FME server to check out a license from the ArcGIS Pro pool? Preferably the advanced concurrent use license. We followed the step by step instructions for using ArcGIS Pro with FME server in this article without succes:

I am loading in a large address data set in CSV format The reader has wrongly classified my coordinate columns as "time". This causes the VertexCreater transform to add incorrect geoemtries When I click "User Attributes" on the Reader I cannot change the column type from time. Everything is greyed out. How can I best override this  

Hi FME altruist, I am a new member of this community and trying best to strive on using FME for my new job. In a task, I am asked to assign a percentage value (computed by area on area overlayer) of a parent lot to its child lot. For example, in this image, I have first dissolved the two child polygons (1 and 2) and computed the percentage value. But now I cannot assign the value to its child lots. I have tried different tools (e.g. SpatialRelator, NeighborFinder) that can return like 'select by location' and then create a field :)

I have FME Small world Edition license on my system but I am unable to read the data as it shows below error. Please help me with this.

Hi FME communityI have successfully added a web connection to my Sharepoint site following this tutorial https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection using the Client ID multitenant method.Then when I browse the Site: parameter (image below) only a subset of all sites in my organisation are showing. My goal is to read files hosted in Sharepoint just as if they are sitting on my hard drive. Anyone have any suggestions on my issue above or know of an alternative way to connect to Sharepoint?Thanks

XMLUpdater is changing all " to " when I'm updating a single path within an xml document. Is there a way to prevent XMLUpdater from doing this?

MapInfoStyler parametersFor a Region, how do I set the Fill Background Color to be transparent?For example, Fill Pattern 30 is diagonal lines. I want the spaces between the diagonal lines to be transparent, so I can see the layer underneath.

I want to make sure that I have the same number of records in each group. What transformer to use? btw I want to preserve each record's attributes values as I want to write the records to a db later on.

Hi Everyone I have come across an ifc file where the Feature Reader does not find all IfcSpaces when reading a file.  Both ifc Viewers DeSite and Solibri manages to read the files, but the Feature reader loads maybe only a third of the objects. My suspicion is that there has been some post editing of the Ifc file by some third party software or created with a plugin EDM? EDM Software:https://jotneit.no/express-data-manager-edm Example of Ifc FileStructurehttps://essxnce.wordpress.com/2019/07/31/190731-searching-how-to-make-ifc-file-from-non-ifc-file/ If someone know how to read there files with success, please give me a shout out! If not, I imagine this needs to become a feature request to be able to r

I'm reading a number of json files each with their own set of records. I can see I need to expose many attributes but without adding hundreds of lines (the index goes to 142). Is there any easy way to go from screengrab below to web site structure at http://reg.bom.gov.au/products/IDT60801/IDT60801.94850.shtml: