FME Form

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?

Hello. I have a question please. I have a DWG resource that I need to transform to SVG. I managed to export the geometry, but I don't know how to bind the styles - line weight, transparency, etc. Can someone please advise? Thank you

Can AGOL Feature Service writer be used to write pdfs on AGOL?

Hi!  I have an issue with the Clipper-Transformer, that I would like to use for a batch deploy. The clipper input is a Shapefile with about 1.7 Million polygons, defining a grid. The clippee are a few hundred Point Clouds as LAZ, that should be clipped according to the grid. I use batch deploy because otherwise the Point Clouds fill up the disk space and make FME crash.  The issue I have with batch deploy is, that the $hapefile (Clipper) is re-read everytime a new clippee is loaded, which is very time consuming.  Thanks a lot and with regards, Matthias

I have two tables. One is a large ODBC table in which I only want to extract the data when the modification date is greater than the last date of another table. The SQL for what I want to achieve is simple ; SELECT * FROM table1WHERE modwhen > (SELECT MAX(modwhen1) FROM table2);Any help is appreciated.Thank you,  

So, I have a little issue, that I cannot get to the ground of. Maybe someone can help. So, I have this TIF File, which I am trying to convert into a SHP file. This is how the TIF looks: And this is how my FME Flowchart looks like:  But... When I let it run I get a SHP file, yes, but it looks like this:  Lots of triangles instead of one solid block. Can someone tell me, what the issue is? What am I doing wrong?

How can I replace different texts in a dwg file with the help of pairs of search/replace data from 2 columns in an xls table?