FME Form

I am trying to do incremental updates from a secondary database (ArcSDE Geodb) because the entire original dataset is > 400k rows and times out or chokes FME. But I have tried about seven different ways and cannot get the WHERE clause to do anything meaningful (except 400 fatal error, which is maybe meaningful but not useful). If it does not fail fatally, it just brings the entire dataset in, or crashes at around 325k. The current attempt is DATEDIFF(day,CURRENT_TIMESTAMP,[Updated_On]) < 2  -  I also tried various permutations of [Updated On] > DATEDIFF(day,-1,@GetDate) but that seems pretty clearly to not work for ESRI data (there are so many years of FME advice online, searching is a bit hazadous). [Updated_On] > DATEADD(day,-1,CURRENT_TIMESTAMP) worked using SSMS to hit the secondary database directly, but seems to do nothing in FME... I do not have any control over the source database format

MongoDB Reader creates Geometry Collections if the mongo collection contains more than one geometry field. Is there a way to choose which one of these fields should be treated as a geometry?

Hi everyone. I am reading data from an Esri Geodatabase. I have an issue with the Shape area reading as negative values. I have tried the geometry validator with Area Orientation set to “right” as with “Allow Left” and “Check doughnuts only” does not deliver any repair results. After the feometry validation, my repaired results still contain the negative area values. Negative values after geometry validatorIs there another way of solving this, I know the issue can be resolved in ArcMap wit geometry repair is there a similar way of doing this with FME?

Hello! I just got ortho images from Realworks, but I got images without coordinate system and some information in txt format. Is there any way to put this txt file as a coordinate system in FME?At last, I would like to get EPSG : 3857 geo referenced ortho images.   

Hi Support, Just wondering when the official FME 2024 version is expected to be released. Thank you

Hi everyone, I have some DEMs. I combined them (PointCloudCombiner) and have created surfaces on them (PointCloudSurfaceBuilder) and exported them as LandXML. The problem is with the borders of the DEMs. They are not connected. How can I solve it?Thanks! 

 Hi, I am having an issue with feature readers and XML. I have a process which downloads an XML file from an ftp site, and the file name changes daily.  Upon download, I am trying to trigger a second process which reads the downloaded xml, so I can then split it into separate records (hence why reading in as text will not work, as I need the xml fragments). I use a path reader, to get the file name, but when I put ‘Path_Windows’ as the dataset, i get this error: error message  If I choose to ignore the message, and run to the featurereader, It reads in the correct amount of records (59), but the schema is blank. Blank Schema

Hi there, Just wondering if anyone else is getting locked out of Sharepoint with the connector transformer....it seems to have started last week when MS further eroded support for IE but we dont know if it related...basically, we have been using the SharePointOnlineConnector for months without issues...but now all of our workbenches are failing with the attached error message. --We can/have re-authenticated the connection with no problems, but it just keeps throwing this error...any thoughts anybody? Thanks very much!

Hi when I try to setup the coordinate system for my reader to EPSG7792 the Arcgis data interoperability doesn’t have  Can you support please ? thx Francesco  

Our company has a new credit card. So, I have to change it in the billing in FME Hosted. But there no place to do this. As far as I know i'm the admin, so should have all the rights.Does someone have an idea?

I am attempting to convert a DXF/DWG file into the IMDF format. Following the instructions outlined in the first and second articles, I have successfully preprocessed and located the DXF file.However, I am encountering an issue at part 3 of the process. The Reader does not seem to be reading any features as expected.The tutorial I'm following can be found here. One thing, I updated the reader format from Autodesk AutoCAD RealDWG DWG/DXF to Autodesk AutoCAD DWG/DXF.Because I could not load module '/Library/FME/2023.2/plugins/realdwg/realdwg.so' .But i do not think that causes the problem.I would greatly appreciate any assistance in troubleshooting this problem. Thank you.   

Hi All,I have created a workspace that reads all GDBs included in a folder (and subfolders) and export a few attributes to an excel file but now need to bring the GDB name (path_filename) into the final output. I tried to expose the attribute to bring it along the workflow but seems isn’t part of the unexposed attributes.I was expecting to see the GDB name as part of the Generic elements (within the unexposed attributes) but the GDB is only in the <Schema>,How can I bring the GDB name as column in the final output (excel file in this case)?<Generic> screenshot<Schema> Screenshot

Dear FME community, apologies up front for being a novice python userI am trying to use the python caller transformer to execute an external .py file. However my external .py file does not have any classes therefore I don’t know what to do with the ‘Class to process features’ parameter in the transformer. If I run the python caller regardless, it executes my .py script fine, but crashes at the end with this error message “PythonFactory failed to load python symbol `FeatureProcessor'”. This is because I’m using the default ‘FeatureProcessor’ as my parameter for the “class to process features”, which I know is wrong.My python script simply generates a JPG file and saves it to a directory.I hope someone can assist and I haven’t totally missed the point.Regards, Damian

Hi. I need to know how can I get data between two characters.I have an attribute like this:10 12 Street (Main) CamnoreFirstly I need to get data between two characters ( ) and Secondly I need to convert it into two columns with this result:10 12 Street Camnore10 Main CamnoreIs StringSearcher is helpful? if yes how can I get this result?I really appreciate your assistance

I need to transfer a file to an external agency, who has set up a ftp filedrop locationI am required to use TLS/SSL Explicit encryptionI have been given an ftp URL ftp://a usernamea passwordAlso, my organisation has a proxy server, which I think I have to specify in some wayIs FTPCaller suitable for this task? 

Hi community,I would need your help to make my FME code smarter and more dynamic. I am retrieving data via API. The problem is that I can only retrieve 100 items per page. I have 6 pages so I duplicate 6 httpcaller to be able to recover all of my data.Wouldn't there be a more dynamic way to retrieve this data without having to duplicate the httpcaller, maybe by looping but I don't know if it's possible on FME.In the first call, I have the information about the number of pages.Thanks for your help

Hi everyone! I am new to using FME software and I am trying to use FME Form to extract information from a PDF using the Adobe Geospatial PDF reader.  I was wondering if it was possible to somehow extract the color of the text in the document. For example, if I had a PDF document with yellow highlighting and blue highlighting, being able to extract the bits that are only yellow and only blue.  Thanks!

Hi, I have been working on CESIUM 3DTiles generation, but I am facing challenges because the results are not aligned with my intended goals. Specifically, I am unable to achieve the desired mesh quality. The input files consist of a GeoTIFF with a resolution of 6 centimeters per pixel, and the point cloud data is stored in a LAZ file containing over 250 million points. Despite these inputs, the resulting mesh quality remains disappointingly low. I am seeking guidance on how to improve my workspace and achieve a high-quality mesh. 

I am using the FME REST API v4 to try and retrieve all Workspace Apps (and Automation Apps and Gallery apps) but I only get http status code 404, although I see in Fme Flow that we have over 20 Workspace Apps. I can retrieve Schedules, Automations and Workspaces just fine. Is it a bug? Result:HTTP/1.1 404    NO_RESULT    {"message":"FME Server Workspace App automations does not exist."}    404 This works:$(FME_SERVER_URL)/fmerest/v3/schedules?limit=-1&offset=-1This doesn’t work:$(FME_SERVER_URL)/fmerest/v3/apps/automations?limit=1000&offset=0 

Hi There,After a recent upgrade of ArcPro (to v 3.1.0) I am now seeing this notation in FME Desktop and FME Server logs....Current installed ArcGISPro version '3.1.0' is unsupported. Minimum supported version is '2.3.0', and maximum supported version is '3.0.0'....what does this mean exactly?...do I need to upgrade FME?...on Desktop it doesnt seem to make a difference (I can still successfully run operations), but now some Scheduled Services are failing in FME Server and I am wondering if this is the reason. Thank you 

Is it possible to read field aliases from an ArcGIS Feature Layer? I see there is a way to do this if connected to an Esri File Geodatabase, but the data I am working with is service based. I am currently using a FeatureReader connected to ArcGIS Enterprise.Thanks in advance!Sasha

Hi,I'm attempting to filter the records in the reader using the WHERE Clause, but I'm having trouble making it work. I'm trying to select all entries created after 20230718. I've tried the following equations, but it failed."created_date">20230718000000.000000"created_date" LIKE '20231718%' Error ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Invalid data type for expression ["created_date">20230718000000.000000].'. Details: '' ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Invalid data type for expression ["created_date" LIKE '20230718%'].'. Details: ''

When I run: .\fme.exe python -m spacy download en_core_web_sm I get the following error: Expected an even number of command line arguments, instead got 3 for command line: >>  `pip'  `install'  `https://github.com/explosion/spacy-models/releases/download/en_core_web_sm-3.7.1/en_core_web_sm-3.7.1-py3-none-any.whl' <<Program Terminating I was able to install “spacy” to my Python environment, however I need to install the models for spacy as described here: https://spacy.io/usage/models Is there anything I can do about this error?

Hi all,Is it possible to tile a raster based on the defined polygons (coming from a shape file) and not based on the dimensions or number of tiles?

 Hi everyone ,Is there any way to create an area using the limits of area geometries in input ?For exemple , if my geometries look like this  : and if I use the BoundingBoxAccumulator transformer ,it only creates a box based on the limits of the input . But I want the output to be like this :  Any Insight is much appreciated !