FME Form

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.OBJECTID < b.OBJECTID 

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 link, I receive the following error message in Python:Python Exception <AttributeError>: 'NoneType' object has no attribute 'name'Request for Assistance: Since I am new to FME, I am unsure about the root cause and implications of this error. I am seeking guidance an

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 something I'm missing, or is this a bit of a bug? K

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 control file action 'Ap

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

or one reader and several writers? and there are some extra output feature must be derived from open data first.

I have a large polygonal dataset and a point dataset with 178 records. I need to select the polygons that have a point within them, merge the attributes of the two and then write out a polygonal feature class to later be consumed in GIS project inside Arc Pro. I have tried Point On Area Overlay but the output Point data does not contain any attributes from the Polygonal dataset and vice versa. I have also tried Spatial Relator / Spatial Filter with no luck. Any suggestions greatly appreciated!

Has anyone encountered issues with 4-band jp2000 files written by FME Server crashing in Kakadu?  The error is:"A `jp2_channels' object indicates the presence of "      "more colour channels than the number which is associated with the "      "specified colour space. This may happen while reading a JP2-family "      "data source which contains an illegal channel definitions (cdef) "      "box, or it may happen while writing a JP2-family file if the "      "`jp2_channels' object has been incorrectly initialized." 

I have a WMS that I can open in e.g. QGIS. Both the FeatureReader and the OGC WMS reader can show me the different selectable layers in "Properties". But when I start the translation, I get a 404 error saying it cannot be found. This is the WMS I'm trying to read: https://geodata.naturvardsverket.se/planeringsunderlag_o_strategier/wms?layers=Sannolikt_och_potentiell_kontinuitetsskog  Why and what can I do about it?

We are using HTTPCaller to batch geocode thousands of records, but we are running into an issue with special characters that are causing the HTTPCaller transformer to fail. As a workaround, we've been using multiple (20+ at this point) String Replacement transformers to catch and modify the special characters before going to HTTPCaller.  Geocoding the same input table using the Geocode Table wizard in ArcGIS Pro completes without issue.  Are there certain characters that HTTPCaller cannot handle, or is there a better or more robust workaround than using String Replacements? Can anyone offer insight into why the input table geocodes successfully in ArcGIS Pro without any data sanitization/cleansing in ArcGIS Pro, but fails in HTTPCaller?  Thanks in advance for any help you can over. @natalie_campos​ @acueva​ 

I'm currently using a file gdb reader, a statistics calculator to get the total counts, attribute manager to create fields called Today_Count and Yesterday_Count and then the conditional value in attribute manager to try and compare the two counts and return a 1 if they're exactly the same but I can't seem to get the comparison to happen. Also how do I set this up so that if the counts are exactly same I can send out an email notification?