FME Form

Hi everyone. I have a XLSX files with field for the name of a PDF. I have also a folder with the PDF. I want to compare if all the name in the XSLX file have a PDF on thr folder (with the PDF). Thank for help :) 

Hi Team,While synchronising the data between 2 enterprise GDB (2 separate SQL Server virtual Nodes) getting following error and terminated the FME process. Error info:2021-12-10 10:13:48| 281.5|197.2|ERROR |Error while updating feature in the table/feature class 'DBO.DESIGN'. The error number from ArcObjects is: '-2147207419'. The error message from ArcObjects is: {} Note: There are not indexes, constraint rules on Both DBs. Kindly assist us. RegardsVIPLAW

Hi,  After converting the tif to ecw, ecw always comes with a background. I don't see the background in FME inspector or ArcMap, but there is always a background in Smallworld. Is it a way to remove the background colour of the ecw?

Hello, I am attempting to test if an input date exists between a date range - I'm struggling to find the correct syntax or transformers to do this (after 40 minutes of trying). Can anyone help? Currently my input is to AttributeCreator the time for now - @DateTimeFormat(@DateTimeNow(),%T)Then so far I have used a Tester to see if it was greater or less than two times e,g, >= @DateTimeFormat(09:00:00, %T) OR <= @DateTimeFormat(09:05:00, %T)But predictably this doesn't work as it will always be greater or less than one or the other. I would like to use BETWEEN (if I was using SQL).Is there an efficient way to do this in FME? Other than converting the time to a number (which would mean regex-ing the leading '0' up to midday) and then comparing numerical values in a (presumably) AttributeRangeFilter?Apologies if I am missing something basic! Help very much appreciated 🙇‍♂️ 🇬🇧

I have an AIXM 5.1 file which clearly states at the beginning that the encoding of the file it is in UTF-8. However, when I use the AIXM 5.1 Reader suddenly all my attributes are in UTF-16LE which is not what I want. I could use the AttributeEncoder to change everything back to UTF-8, but that seems like a waste of time as my data was good to start with. Also is my geometry converted into XML and reading that will give errors as declaration inside the attribute is then UTF-16LE while I converted the attribute to UTF-8.

Hello, here is what I am trying to do in a workbench that is attached here:1) Input data are .xyz file with a list of 3D point coordinates, jpg + jgw files with DEM photo2) I need to create surface TIN + set an appearance to it3) I need to export it into a format that Trimble Connect is able to process.(https://community.trimble.com/viewdocument/supported-files) - There is a list of 3D supported formats The problems that I run into:1) Data need to have a defined coordinate system.1) I need to create a FME Cloud app, where customer is able to run this transformation themselves. 2) The formats that Trimble Connects do not support textured surfaces / solids3) FME Cloud does not support many writers that Trimble Connect would be able to process D

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.