FME Form

I have a workspace published to FME Server 2022.1.1 (build 22623) in which I want to give the user the option to Truncate Existing or Use Existing via a user parameter. When you create the parameter in the ArcSDE writer feature type, the name of the parameter defaults to fme_table_handling. This works fine when running from FME Desktop 2022.1.1 (build 22623). When running from FME Server, the parameter choice is not honored. It simply uses the choice of the parameter that was made in Desktop before the upload. However, when you change the name of the parameter to something else like 'table_action', it works as intended on FME Server.  Here is a screenshot from FME Server log file, where the parameter name is left as the default value (fme_table_handling). As you can see, the parameter is preceded by only one dash, where it should be two dashes. And also, 'fme-' has been dropped off. I think this is where the issue is occurrin

I'm trying to load OpenStreetMap using FME. This works great with small datasets in 2012, however as soon as I start playing with large datasets (millions of features) I hit the problem that the FME OSM reader acts as a grouper - it reads the entire dataset in before it actually trys to translate everything.  Does this have to happen? Is there a way to disable it or is this a limitation of the XML reader? It's massively slowing down everything because even with 32GB of RAM, FME is still filling it up and then writing to temp disk space (despite the original dataset only being about 7GB uncompressed).  Using 2012 SP4 64bit. 2013 13206 is 5.5 times slower on the small dataset, so not using that despite changes in #13082 to make "it better with large datasets" - not sure what that means.

Hi everyone, I have several Esri personal Geodatabases with similar schema but also some tiny differences.That is, they are required to have identical schema but in fact some don't due to various reasons. Some feature types and attributes are unexpected, while some required ones are missing. Now I want to choose a standard one from them as a template and merge them all to get a standard destination mdb. How can I achieve that?

Within the User Parameters I have added the option to Select a File.More specific the user has the option to select a Geodatabase (Items to Select).When the user has selected the Geodatabase, I like to have the user also select the database of his/her own choice within that Geodatabase. Is there a way to configure that?  

Hi,In my workbench I’m trying to export points and labels from Oracle database to Geopackage file.So I’ve configured an Oracle Spatial Object Reader and a TextAdder. On the TextAdder’s output I can see points with labels. Then I’m adding a writer of type OGC Geopackage.But when I’m trying to run process, the result GPKG file contains only points (without labels).On logs there’s a information: “Unsupported geometry type Text.  Downconverting to Point”If I replace OGC Geopackage writer with Bentley Microstation Desing (V8), then it works properly (I mean the result contains points and labels).How to export labels to Geopackage?

This is supposed to be a quality of life improvement when working with unreliable data providers or when you have unreliable internet connection. I hope this functionallity exists in FME already but I could not find it.I am trying to make a custom node that saves the data stream it intercepts locally and reads that data instead if the original source doesnt come through. There are two problems that I have been unable to solve. One is that i have to run the script with feature cashing to get it to save the files and there is an error upon saving, it does not seem to understande the grouping for some reason:localize_data_2_FeatureWriter (WriterFactory): Group 2 / 2: MULTI_WRITER: No dataset was specified for MULTI_WRITER_DATASET or localize_data_2_FeatureWriter_0_DATASET or FFS_DATASET 

 Hi,I am just in the process of migration testing from FME Flow/Form 2023.1 to 2024.1. It seems all of our GeoDB dynamic writer fails the following error:Esri Geodatabase Writer: Feature Type Definition 'd_y_n' was requested, but not defined. Please visit https://www.safe.com/support All existing runs perfect on 2023.1 Flow and Form - not sure why it fails. Tried all possible scenarios, still fails. I have changed it to a normal writer - then it worked fine.GeoDatabase - SQL Server 2017, SDE Version 10.9.1 (pro 2.9 created)Pro Version 3.3.1 installed on PC / ServerRudy

HiI’ve been constructing http calls to download OSM data to a .OSM file, then reading the downloaded .OSM file via a FeatureReader to generate specific outputs (yes, I know there are downloadable OSM transformers but they don’t do what’s required here).The specific problem I’m having is, not returning way or relation items into the downloaded file (if this is possible).Looking for assistance regarding the http call syntax. Below is what I’ve tried but still only returning point features (same results for both).https://overpass-api.de/api/interpreter?data=[bbox];node[building];out;way[building];out;relation[building];out;&bbox=@Value(_xmin),@Value(_ymin),@Value(_xma

Hi,  I am a total novice with FME - will be going on some training soon, however I am trying to get familiar with the software prior to that.  I have what I think is a very simple task but can't seem to figure it out.  All I want to do is create an excel file with all of the feature classes contained in my geodatabase.  My geodatabase (version 10.1 in ArcGIS) contains feature datasets - although I do not these listed in my excel output.  Sorry for asking such a basic question - I am new to the knowledge areas/and community

We have web application that triggers FME Workspace on FME Flow server. Sometimes (rare case) we receive an error in the application “Failed to access module”.Error in log files point to problem with FME saying:2024-09-11 02:53:36.7457|Warn||||Error occurred in FMERequestor Method RequestFMEJob: System.InvalidOperationException: Failed to fetch transformation: Status: Unauthorized, Url:http://XXXXX/fmerest/v3/transformations/jobs/id/546567I have no idea why it is not accessible, because in 99% cases it works fine.  

Has someone please done a file transfer migration from one Sharepoint Online location (Site) to another Sharepoint Online location (site) and also keeping the original file Metadata, including created date, etc.. Using FME Form?  

When a FeatureWriter fails for whatever reason, is the expected outcome that nothing is output from any of the ports, even if some or all other feature types are successful? In my example I have 2 feature types in a FeatureWriter and 1 of the 2 writes successfully, the other fails (I’ve forced it to fail to test this functionality). I want to be able to take the information from the successfully-written feature type further in the workspace for processing. Is this not possible? Currently I’ve resorted to 40 separate FeatureWriters for 40 different feature types in case 1 of them fails and the other 39 are successful. I do have Rejected Feature Handling set to Continue Translation. This is FME 2024.1.1.1 (B23620).Below is my example. The 312 features for for the one feature type successfully write to my database (ArcSDE GeoDB). I’m ok that the Translation Failed and is actually a good thing, I just want to use the summary and feature counts to write to log tables further along

Hello, I have multiple FBX surfaces with textures as external jpegs which are read in alongside the geometry and coloured accordingly. I need to merge these surfaces into one file using a deaggregator and a meshmerger which works, but when i write this to an FBX file, the jpegs or textures are all individual files which are retained from the original file. Also when i simplify the mesh, it also looses all colours. Is there a way of merging, simplifying a mesh whilst retaining all textures or appearances? Thanks,@takashi @nielsgerrits @hkingsbury @daveatsafe @david_r @ebygomm 

Feature Type: `JobHistoryReader_LoopHere'Attribute(32 bit integer): `Loop to JobHistoryReader_LoopHere1664443291 Input Splitter.BranchingFactory.Count' has value `1'Attribute(string: UTF-8) : `_min_job_age' has value `20220928000000'Attribute(64 bit integer): `_offset' has value `0'Attribute(string: UTF-8) : `fme_feature_type' has value `Creator'Attribute(string: UTF-8) : `fme_geometry' has value `fme_undefined'Attribute(string: UTF-8) : `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENullCoordinate Dimension: 2===========================================================================Loop to JobHistoryReader_LoopHere1664443291 Input Splitter (BranchingFactory): Transformer/Factory JobHistoryReader_HTTPCaller is blocking and cannot be used in a loop, but was found between 'Loop to JobHistoryReader_LoopHere1664443291 Input

Hi FME Universe,Is it possible with FME to integrate EXIF info in a JPEG file without writing a new file?Is FME able to integrate EXIF info in the original JPEG?My first thought is no but maybe I’m wrong?!Thanks!

I need to write datetime to a comment on a SQL table after my postgres SQL writer is complete.This can easily be done like when using a featureWriter like so:COMMENT ON SCHEMA "my schema" IS '@DateTimeFormat(@DateTimeNow(), %Y-%m-%d %H:%M)';This is not possible if i use a regular postgres writer. Only SQL functions are available. This alone is not enough to set a timestamp.Tiny but frustrating neuance between almost identical transformer/writers. What other ways can i inject a datetime into my comment on schema syntax?  

Hello there we have Millions of JPG Photo we want to geotag all the metadata is located in an excel file is there a way to do this via FMEThanks 

Hi communities, I need help for above post which has not been solved yet. I’m totally stuck on this.

Hello, I am configuring FME to receive file uploaded from website through API - POST method. We want the api to directly pass the uploaded file from website to FME for processing. Note that the file is not saved into any DB.The issue I am facing is the the configuration of HTTPCaller Transformer to receive file datatype. Anyone can help suggest on this? Would be very helpful if I can get any advice to configure it the correct way since I’m stuck with this. The logs: 

Hello,I was wondering if FME can read in  data from Oracle SQL Views?If yes, great. How?

Why i am Getiing this warning and error when i try to run workspace on desktop and on server 

Hi all, I am currently using a Dissolver with Attribute Accumulation > Accumulation Mode set to ‘Use Attributes From One Feature’.How does FME decide which feature's attributes are used? I assumed it would be the first one to enter the transformer, but I couldn't find anything on this in the documentation. Kind regards,Joep

The polygons below have corners that are 90 roughly degrees. I would like to split them at the corners so that I get four lines from each polygon for further processing.The two areas below are only examples, but the rest of the data have similar elongated, bent shapes. I tried finding the corners by intersecting against a bounding box but the result was not very useful because of the irregularity of the shapes. My guess is that I would get the best result by measuring where the vertex take a 80-100 degree turn. Any suggestions on how to achieve this? Or other clever ways to breake the polygons appart? 

Hello,I have a workbench which includes Databrick JDBC Connection. It was working fine with FME 2024.0.3.0. However, after upgrading to FME 2024.1.2.1, it starts throwing error “java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.”Feels like something is missing with the upgrade. Has anybody seen the same problem? Could Safe support team please check? thank you.Full error attached below.java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager. at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source) at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source) at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source) at com.databricks

Hi there!I want to create polygons from an attribute that contains a string of coordinates and other information. My problem is that I don't know how to only extract the coordinates from the string and then create the polygons by their ID attribute.  The string in the coordinates attribute looks like this:“{"type":"Feature","properties":{},"geometry":{"type":"Polygon","coordinates":[[[13.707920553133594,60.03475791657763],[13.708950521395312,60.03304306231432],[13.705474378512012,60.03160680337132],[13.702513219759567,60.02997753853561],[13.702255727694139,60.030577803349054],[13.703929426119434,60.03184261136259],[13.706161024019824,60.032571461785544],[13.707920553133594,60.03475791657763]]]}}” ID attribute 1 to 10 Regards,  Ricardo :)