FME Form

Good morning,  I'm currently facing a really weird issue. In my workbench I have a Reader that is loading a quite large Excel file, containing multiple tabs. I decided to remove all the unwanted data from the Excel sheet and keep only the tab I really need.  When I try to update the Reader feature types the Excel tabs that I just removed keep showing! I have tried adding this Excel sheet to a new workbench; same result.  What I've tried so far: - Adding the Reader to a new workbench in 2018.1 and 2019 beta. - Purged temporary files in FME. - Restarting FME / computer - Ran Windows disk cleanupNothing helped, I'm still seeing the tabs I deleted.   Cheers, Ed

I thought I knew how to do this but it broke for some reason. My workspace has a GDB that contains a feature dataset that has domains assigned to a few of the feature classes and it also has topology. I set up a simple transformer to sort and do an area calc. Then, I need to write back to that same GDB while keeping the domains. I recently lost the domains assignment and when I tried to update the workbench now it fails to write anything. I've tried multiple methods and each has a failure like 'cannot delete layer that has topology' or 'cannot make edits out of an edit session'. How should I set up my writer? I'm not sure I want to overwrite existing if I can help it.

Hello. The WRITER called Esri ArcGIS Server Feature Service Writer does not seem to exist. The reader is there.. but not the writer This is not AGOL and not Portal - just “Esri ArcGIS Server Feature Service Writer” It’s in the documentation as existing and I do need to write out to an Esri ArcGIS Server feature service using a rest endpoint url Please point me in the right direction if I’m missing it somehow. If it’s not there, why not? The documentation is at https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/arcgisfeatures/arcgisfeatures.htmThanksJim

Hello all! Relatively newbie here.I think my question is simple but I am just struggling with finding a query for it. I have a table in an SDE. An example of the structure:object_id        job_id          update_start                               status1                     xxx              2/15/2024 13:00:00                  Success2                     xxx              2/20/2024 13:00:00                  Success3                     xxx              2/25/2024 13:00:00                  Fail I am using a FeatureReader to read this table and I need to extract the most recent succesful run from this table (i.e. in this case only row 2). I am using the where clause but it keeps returning me blank and I ran out of ideas. Any help is appreciated!Regards,

I am trying to post an AGOL attachment (i.e. an image) to a Cityworks Work order using the HTTP caller. My goal is to post a unique image to a unique work order (i.e. an image of a sidewalk crack for a sidewalk work order, a pothole image for a pothole work order etc.). The issue starts with my file. I am using AttributeFileWritter to write the file. I use a variable from the feature layer to name my output file (i.e. @Value(WorkorderID).jpeg). This writes to my output directory with no issues. When I go to try and upload this file, when I feed it the PATH + file name + file extension it results in an error “HTTP/FTP Transfer: Failed to open file for resource upload”.  When I explicitly “Select” the file it will upload without issues.  My workflow is as followsI write the image file  I make the call

Hi All,Fairly new to FME, and brand spanking new to Rest APIs.i have an API integration that i worked out in Postman, but, i’m struggling to translate that to FME workbench for use in an FME Server Automation.In postman, i have to use a GET to generate an antiforgery token, then use a POST to log in, a second GET to update the antiforgery token and then a second POST to send the actual content i want to .. uh.. send.now, in Postman, my request looks like:GET {{DeskAlertsURL}}api/xsrf/getwith the following auto generated headers:Cookie:Host:User-Agent:Accept:Accept-Encoding:Connection:and the actual request headers look like (i {{shortened}} some of them for readability):GET https://URL/DeskAlerts11/api/xsrf/getRequest HeadersUser-Agent: PostmanRuntime/7.36.0Accept: */*Postman-Token: acbb9ca8-9dc2-44b1-888e-63468a39523fHost: desk

Hi,I have a SQLExecutor with a dynamic SQL Server query like:SELECT * FROM value(@table_name)Obviously, as it is a dynamic query I don't expose any attribute.Then, I connect the schema and generic outputs to a featureWriter (CSV).When I run the workspace, It finish suscessfully but It doesn't generate the CSV file.The same problem if I try to generate the CSV file with a dynamic writer instead of a featurWriter.However, if I replace the SQL Executor with a dynamic featureReader, the CSV is generate correctly.I need a SQL Executor because the query will be a bit more complex.I think It is something related with schema but I missing something.Could anyone help? Thank you un advance! Regards. 

Hi all, I have a GeoTIFF with 1 rasterband (UINT8) that has palettes with 3 values (RGB).Example: I will convert this tiff into a three channel (RGB) tiff.Is this possible with FME? thanks in advance!

Please feel free to take your best guess about the title of this post in the poll. Then, if you are curious about the answer, check my new transformer OpenAIOSMReader and the LinkedIn article.  

Is it possible to run workspace runner with “wait for Job to compete” = YES and setting a number of the concurrent processes? It should work the same way as “wait for Job to compete” = NO with the only difference on the time of showing the success or failure of the process run.

Hello.Is there a possibility to read an ifc file, retrieve a list of all attributes (like it is present after running a workflow once and click on import from feature cache in the attributeKeeper), be able to select the ones to keep and keep only those in the writer? Or at least read a textfile with a list of attributes separated with , and use them as attributes to keep?I build a workflow to work with IFC data and at the moment I specifically create a “new” workflow for every file, manually adjust the attributeKeeper from the feature cache and run the workflow with the same file a second time. I do not know beforehand which attributes are included in the ifc file, and it can differ with each file.I already figured that the attribute keeper can’t work with user parameters. I tried using the Attribute Exposer with “Import from Dataset” or the Feature Reader Schema Output for a dynamic writer...but either I did not understand the answers given in other community q

Hi All, I’m struggling to explode/conver the fme_aggregate to fme_polgon. I have already used 2DForcer and GeometryCoercer already, settings in the screenshot below:This comes from a DWG file and I need to create the outline boundary as AOI,Any ideas?

I have a dataset of features that I'm trying to insert in a Postgres (pg14) database. That data has a number of text columns that together make up a "report name" plus a timestamp. The name and timestamp together make up the primary key of that dataset. There are also some more columns that contain the actual data. The table I'm inserting this in currently has 800 million rows, and I'm inserting in batches of around 50k rows about a hundred times a day, so keeping indexes small is important. Given the above situation, the text columns from the "report name" have been put into a separate "dataset_reports" table" (~60k rows); with the timestamp and actual data being stored separately (with a foreign index) in their own heavily partitionned "dataset_reports_data" (~800M rows) table. In order to insert data in that table, I need to upsert dataset_reports with all the unique report names in my feature set in a first pass, then get the FK value for all these reports and t

Hi Community, I am using some SQLExecutors in my workbench and the this is taking so much time to execute. Is there any way I can execute it faster. Is it because the statement going from fme to outside db and execute it in batches of 1000 and commits the edits making the whole delay?. Is it possible to execute the whole sql actions using a plsql script and bind it to fme?. I may also need to have logs or exception tables for plsql script. Is it possible through fme?

Hi! I'm trying to transfer the information from the layers and tables of one geodatabase (with domains and relationships) to another geodatabase with a different data model. I need the GlobalIDs from the reader  geodatabase to remain in the writer geodatabase. In some tables/layers, I manage to keep them by setting "translation type: none" and "preserve GlobalID: yes," but in others, it's necessary for the translation type to be edit session, and then the GlobalIDs are not preserved. Is there any way to maintain the GlobalIDs regardless of the translation type or in any other way?I have read several posts regarding this issue but I can't find a solution.thanks!     

Hello! I have recently started working with FME Flow. I’m just testing the possibilities of writing to the Fme flow temporary resource directory, which causes the translation to fail immediatly. My script is just a reader, which in this case is reading from a shapefile, as well as a feature writer. The featurewriter is set to write to [FME_SHAREDRESOURCE_TEMP] and the response i’m getting when running the workspace is this:  Has anyone encountered this before, and is there any hope for me and my workspaces in FME flow? Thanks!/Alex

I am using ArcGIS Desktop 10.8.1, ArcGIS Pro 2.5 and it is working well in FME 2023+But in FME2024 version I have problem with reading and writing geodatabase, I get the following error message:“Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details”“Failed to obtain any schemas from reader 'GEODATABASE_FILE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information”“Workspace generation failed.  Parameter file was C:\Users\Acer\AppData\Local\Temp\FME_1709721529788_18364”I guess the FME2024 version has prob

We have FME 2022 with floating lic, with 2 editions, Database, and ESRI.   Would like to install FME Form 2024.0 along side FME 2022.  I know at some point Safe did away with Lic Editions, any idea if we can use the same  FME 2022 lic file and make it also work for FME Form 2024 ?  .

I have a workspace in FME Form 2021. It includes an Automation Writer. This writer writes keys from FME Form to my Automation in FME Flow 2021,  Given this is the 1st time I have pushed FME Attributes into an Automation as Keys, just being curious, I clicked on the “View Written Data” icon in the Automation Writer. It gave some errors and a new windows opened with red in the parameter boxes. It would seem wise to disable this icon when a Automation Writer is chosen. Are there any plans to do this? This does not impact my workspace or Automation. It just seems a bit annoying, unless I am missing something? See my screenshots for a better illustration of what I see happening: 

Hi,I have a shape file and want to create some geometries and annotations and export them as IFC.The geometries are correctly exported. But the Annotations are really small in the exported IFC file. I used the Scaler before exporting the IFCAnnotation. But the problem is that the scaler doesn’t change the Size of the text, but also the location of it. Can anyone help me please to make the Annotations larger and also have them in their correct location?

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