FME Form

Hello , i would like to create a line between two attributes that has coordinates at same tableThis table has many points .Id_1 | x1 |y1|id_2|x2|y2 x1 ,y1 relates to id_1x2,y2 relates to id_2Both of them are points. How could I create a line between id_1,id_2 and add text that include the value of id_1 and add text of value of id_2FME 2021

As an eg. there are 4 records i wanted to check how many null values are present for each records .

I'm trying to write to a table in Azure SQL using a sde connection file.There is no error when running the workspace but nothing change in the table.What could be the issue? 

P.S. When I have managed to get this to work, the attributes from the various features read by the FeatureReader aren't being written.

Hi Community, I'm trying to run an existing FME 2018.0 workbench on FME 2020.2. and just received ArcObjects is: '-2147219879' error. Tried to search online but couldn't find the workaround/solution. The FME workbench reads a GDB and applies metadata based on XML file as well as an excel file. Attached the log file for reference.  Any help more than welcome 🙂

Within Sophos can exclude event id but as file locations for each transformer is different would have to keep adding them. Command used to install like below. Have excluded paths with no success. Is it possible to install transformers from command line rather than within FME application. Tried to use below command but file not found. Manual install may get round Sophos blocking . Thanks in advance for any advice supplied. pip install --force-reinstall --no-deps --no-index --find-links C:\\Users\\test\\AppData\\Roaming\\Safe Software\\FME\\Packages\\22800-win64\\PackageFiles\\safe.s3connector\\python --target C:\\Users\\test\\AppData\\Roaming\\Safe Software\\FME\\Packages\\22800-win64\\python\\safe.s3connector --upgrade --no-compile fme-amazons3'

I'm working in an Oracle database, where there are multiple duplications of features with matching geometry that shouldn't be in a table named "TDS71"."METADATASRF". There are millions of records, and I haven't found a native FME transformer that can handle this in a timely manner (Matcher, AreaOnAreaOverlayer, etc). So I'm experimenting with deleting the duplicates in SQLCreator. For now, I'm simply just trying to return all but 1 of the duplicated geometries, and will worry about deleting after I can identify them. The code below is returning many more features than expected. I'm not really sure why to be honest. For example, a feature is duplicated 6 times in the database. From the query I have currently, 15 records are returned. Does anyone have experience doing this in SQLCreator/Executor?select a.OBJECTID, a.SHAPEfrom "TDS71"."METADATASRF" a join "TDS71"."METADATASRF" bon sdo_relate(a.SHAPE, b.SHAPE, 'mask=equal') = 'TRUE'and a.OB

I have workspaces that allow a users to define an area of interest when looking for data. Instead of the openstreetmap coming up, now it is just a grey box. Coordinates still get passed, but the user cannot see where they are drawing their polygon.

Introduction: I am encountering an issue with an Esri ArcGIS Server Feature Service link. Over the past few days, the link has been functioning correctly; however, starting yesterday, it started throwing an error. As a newcomer to FME, I lack the necessary understanding to interpret the error message, specifically the AttributeError: 'NoneType' object has no attribute 'name'. I would greatly appreciate any assistance in resolving this issue.Problem Description: The link causing the problem is as follows:Link: https://mapservices.weather.noaa.gov/tropical/rest/services/tropical/NHC_tropical_weather_summary/MapServer/Details: Upon accessing the aforementioned ArcGIS Server Feature Service

Hi folks, While working with some JSON data, I seem to have noticed that null values are sometimes interpreted as a literal string, instead of a true <null> value (like non-existent/empty). When I just tried to replicate this, it seems that different FME JSON transformers seem to handle null values in a different manner. E.g. when using a JSONFragmenter or a JSONFlattener, it seems that null values are indeed recognized as true <null> values (like non-existent/empty), but when using a JSONExtractor or an XMLXQueryExtractor (with a JSONiq query), it seems that null values are returned as a literal string. Of course in the latter case I could add a NullAttributeMapper transformer to change the literal string 'null' to the <null> value, but this seems like a bit of a workaround (and also, how would you then distinguish between a literal string value "null" in JSON, and the true null value) Is there som

PDF2TextReader does not recognize my published parameter for selecting a pdf file into the transformer. Is there any workaround this? PDF2TextReader runs when I select the pdf file directly but not when I use a parameter in selecting it.

It looks like Deployment Parameters might make some of our processes more manageable. Is it intended for use with workspace runners? Is there any documentation out yet for this new feature?  

I have a workspace which is scheduled through Windows Task Scheduler on a Virtual Machine. This workspace writes out to an Excel file on a mounted drive. When running the workspace manually, it has no issues. However when running through Task Scheduler, the workbench gives an error "Can't open file for writing". The target Excel is not opened anywhere and I do have writing permissions for it. Has anyone dealt with a similar issue before?

I have a table of values with ID, Start, and End. Starting with the first row, I need to select the next row where the start value equals the end value of the first row. I need to repeat this process for the entire table. For example, I'd select row 1 then row 4 then row 6 then row 9 then row 13...Any thoughts on how to do this? 

For a job that has been working for years, it is now endlessly polling job status and returning awaiting worker. In Server, the last message you get is about the Socrata Write executing. In the desktop software you get more information and it reflects endless polling. Something has changed and I'm having trouble figuring out the cause. 2 of 24 of these (county specific) ran and the rest hung, and now even the two that ran initially will hang. It appears to be happening in the last step involving the Socrata Writer. This is the last log information, with the "Polling the job status: Awaiting worker" repeating endlessly. Other jobs that write to Socrata are still working. It isn't blanket failure on writing to Socrata. Any thoughts on cause or leads to investigate are welcome. ThanksSocrata Writer: 0 features treated as points, 0 features coerced to point, 0 features with unsupported geometries written without geometrySocrata Writer: Invoking Socrata DataSync with

I have a zip file that has a csv file and multiple jpgs. I tried a CSV feature reader-- not a CSV reader-- as I was trying to read the file with in the zip file but that didn't work. I am using FME 2022.2.2. Is there a way to only extract a particular file from the zipfile? I dont want to unzip the entire thing as it will take a long time. Thanks in advanced.

I have this GML dataset (https://service.pdok.nl/hwh/administratieve-eenheden/waterschapsgrenzen/atom/downloads/administrativeunit.gml). I tried all kinds of configurations with the different GML readers (although I expect the INSPIRE GML reader to be ready for it). I can't get it to work. I also don't have much knowledge of the ATOM standard. Any directions for help?

Hello,I am experiencing difficulties reading an Oracle Spatial table with FME.The table (linestring) has about 250K records.FME starts to log the first 10000 records after about 10 minutes. And then 10000 at a time every 6 minutes.The table is displayed in GeoMedia and also QGis in about 5 minutes.Feature Caching is disabled.I have tried both with the reader and with a SqlCreator. Same results.What checks/configurations can I try?This is the first time it happens and not sure if some metadata could be wrong or corrupted.This sounds strange because of the tests with other products.TIARoberto

We recently upgraded our FME server and now the file upload in Server apps is no longer working? When i click upload file the app says "There was an error uploading the file."

I have an intermittent problem where an FMEServerJobWaiter fails to wait for a job to complete and rejects it after 30 mins-or-so when in fact the job is still running and completes successfully (it gets rejected with a 502 gateway error).Is there a difference in the way the FMEServerJobWaiter works compared to the Wait for Jobs to Complete parameter in the FMEServerJobSubmitter? - might that give more reliable performance?Using FME2021.2.

Hello ,i am working with file geodatabase then writing the output into file geodatabase so my input :file geodatabase and it contains ObejctIdbut when I write the output into file geodatabase after finish work on the data .i have found that the output contains new attribute called objectid_1how to avoid the data from creating the new objectid_1 because I have already attribute Name called objectid and I do not need extra .fme 2021 thanks in advance

def add_double_slash(file_path):  modified_path = ''  for char in file_path:    if char == '\\\\':      modified_path += '\\\\\\\\'    else:      modified_path += char  return modified_path # Example usagefile_path = r'C:\\Users\\Username\\Documents\\file.txt'modified_file_path = add_double_slash(file_path)print(modified_file_path)

Greetings, I am trying to replace values using the AttributeValueMapper, it is not replacing the attributes in the field  I would appreciate any assistance to resolve this issue. 

I want to create an Workflow in a Workspace where i load data from a Transformer and then create an Folder with the Name of the Attributevalue and then write the other Data in an Excel file in the created folder. To Create the folder with PythonCaller was easy, but i have no idea how i use the Attribute Value in the Excel writer Destination.

HiI tried to download some data using OSM downloader but I recevid an errorcan ypu help plesae ? thx Francesco