FME Form

So I want to delete the duplicates, or find the distinct combinations across two columns.I know I can do that with SQL on a database. But I just have a table here and want to do that directly in my FME script. Does someone has an idea?

I use XMLtemplater to design my XML file from Excel, but i have problem with the result:This result, it coincides with each output data field: I want to group like this:And this is my model FME:Anybody help me, pls !in my excel file, the fields "table_id" in sheet "table" and "table_id_field" in sheet "fields" are key fields to link these two data tables together

Hi,I'm downloading a bunch of text files from an FTP server and the contents of each file is stored in an attribute. The format of a text file is as follows : Station1;2022-04-12;09:00;Var1;True;30.4;Var2;True;0.5;Var3;False;0.0;Station2;2022-04-12;08:00;Var1;True;33.4;Var2;True;0.5;Var4;True;10.3;Station3;2022-04-12;09:00;Var1;True;27.4;Var3;True;0.5; What I would like to do is transform this text to a table as in the attached screenshot, but I have not found any easy way to do it in FME. Would you have any suggestions? Thanks! 

Workbenchs/ Connection String work fine on existing server. Moved them over to a new server and get: ArcGIS Desktop 10.8.1 and Background georproccessing 64 installed, TNSNAMES is fine, can ping to oracle server.  822022-5-13 12:41:01 | Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216028'. The error message from ArcObjects is: {No SDEHOME environment variable set}832022-5-13 12:41:01 | Please ensure the connection parameters are correct (server=`sde', instance=`sde:oracle$sde:oracle11g:ocspub', user=`encdirect', password=`***', database=`', version=`SDE.DEFAULT') Edit: added SDEHOME Variable C:\\Program Files (x86)\\ArcGIS\\Desktop10.8\\bin Still no good  FME Server 2021.2.5Build 21816 - win64

I'm upgrading from 2016.1.3.2 to 2021.2.5.I have geometry stored in PostGIS -> GeometryReplacer converting from Hex OGC WKB -> optional Reprojector -> Shapefile or FileGDB (both types). According to the log files, for 2016, there's barely mention of GeometryReplacer and Reprojector, but for 2021, there's a significant chunk of runtime devoted to passing through the two transformers. There's minimal changes to make for them to upgrade so it's bizarre why it's adding nearly double the runtime. (See log attachments) For production concerns, jobs are taking several more hours to run. Here's metrics for another dataset:2016:2021: Thanks,Janet

I'm having a few issues with the ESRI ArcGIS Portal Feature Service Writer (using the FeatureWriter). I'm writing to a known ESRI Feature Service using Branch Versioning, and I'm creating a new branch to make the edits in. Using FME Desktop 2021.0.3 (64 bit), I'm finding I can write the Inserts and the Updates to the service, but not any Deletes? FME is completing successfully, so the ‘call’ seems to be successful, and no errors seem to be returned in FME, but any Deletes just don’t seem to be appearing in the branch. I've checked permissions in ESRI, and the user does have editor permissions (including Deletes), and I've successfully deleted a feature using a Branch in ArcGIS Pro itself. Anybody had a similar issue, and if so, how did you overcome it? Many thanks,

I am trying to covert geotagged photos from a mobile phone and convert them into a KMZ file, every works great except the actual photos are not being inserted into the KMZ file... How do I fix this? 

I have added an extra column in the shapefile using attribute manager. How can I edit the values in that column?

Hi!In the translation log, i have tried to add a specific row (in my case row 85) to attribute table without any result. Is this possible to do it? The pythoncaller script (Esri Arcgis Python 3.7) look like this: import fmeimport fmeobjectsfrom arcgis.gis import GISfrom arcgis.apps.storymap.story import StoryMapfrom arcgis.apps.storymap.story_content import Image, TextStyles, Video, Audio, Embed, Map, Text, Button, Gallery, Swipe, Sidecar, Timelinefrom arcgis.gis import Itemfrom arcgis.apps.storymap import Themes class FeatureProcessor(object):  def __init__(self):    pass  def input(self, feature):    gis = GIS("home")    new_story = StoryMap("9f1567e92c514baabdc2e595776bfdc8")    new_story    new_story.nodes    newFeature = fmeobjects.FMEFeature()    self.pyoutput(newFeature)    print(new_story.nodes)  def clo

Presagis Creator allows formatting of a hierarchy where polygons can be organized under groups, objects, and naming of polygons. When I read in an OpenFlight file with these attributes and output it to the FME OpenFlight writer the polygon names are all empty. Is it possible to define a hierarchy where groups, objects, and polygons can be customized instead of empty nodes? I included a generic screenshot showing how I would like to organize the FME writer output. Thanks!

I am trying to create features out of a large json file that has many objects mixed in with arrays. I can almost get what I need by using the following query:json["Domain"]["Classifications"][*]Unfortunately, it leaves out a crucial attribute. Here is a screenshot of the json file where it has me stumped:Here is a link to the entire file.The attribute underlined in red is what I am looking for. There are hundreds of them at this level, all differently named. I have not yet found an example of this schema type, with hashes within a hash. In addition, the schema is not uniform. I can get to where it will separate the

I have a shp file generated by QGIS with three decimal places. In FME, the feature reader seems to auto round the field. I tried to change the "Numeric attribute type handling" to "explicit width and precision", still doesn't work.  Is there any way to let FME read the data as same as QGIS? ​

I am looking to dump from results of the SQL Executor into a DB table (fields not known). Looking for ways to do it. I see there is Schema and Result port for SQLExecutor. Not sure how to use both in order to insert the data into a table.

I am trying to write a 4 digit year into an existing MySQL database. The field type is year with a length of 4. Therefore, one would think that a 4 digit integer would write into it, but it does not. I get a warning saying "MySQL Writer: Skipped feature due to invalid date/time string". This seems extremely basic, but how do I turn a4 digit integer (e.x. 2012) into a date field that MySQL will recognize as a year?

This is less a question and more of a finding to report. In 2016, File Geodb Open API treats date values "1901-01-01" as "19000101000000", but in 2021.2.5, the reader treats the same value as "000000". The effect is the record gets thrown out, despite the writer saying all features are written.We've had to build in a StringReplacer to find all the "000000" to replace with the original date value.Is this a bug? Update:Affects "1900-01-01" as well.

I have road events from different groups and time lines.. so the geometry doesn't always match but they want me to push them together. is it possible to just use the PathName, Start Measure and End Measure to join many events together?  Example: All Path's have3 events Weight, Height, Width. I want to be able to merge them together like Snipper or LineOnLine so I can join the Start and End Measures where they break.. If needed in Python or Transformer preferably so I can complete this on the fly from two databases to compare.  

Hi, I have loads of vertices that belongs to polygons and want to change the start vertex so that the polygon always start and ends in the lower left corner. The order of the vertices must stay in the same order so its possible to rebuild the polygon. Spatial sorting works to identifiy which vertex that should be the start vertex but messes up the order of the other. Thanks

I have a process where I determine the last ID number used for two id fields using statistics calculator. I then use an aggregator to merge the two ID's. I then bring about 100 records from another table and am wanting to add these ID's to it. But what is happening is that the two ID's are just being added as another record instead. I have tried using variable setter & retriever but those didn't work at all.

Hello, I am trying a simple conversion from KML to csv. I need to write all data from ExtendedData element, it may be SimpleData or Data key/value. All I want is csv file with custom data from kml.  In a workbench I have  Generic reader which reads KML ( GENERIC Reader is requirement)  CSV Writer to write to csv  I have connected reader to writer directly no transformer and I expecting csv file. I yet to put CoordinateExtractor to get coords from file. So I am expexting only data to be written to csv. But when I run the workspace all I get is blank csv.  Here is a sample KML.  <kml xmlns="http://www.opengis.net/kml/2.2"> <Document>   <name>My Golf Course Example</name>   <Placemark>     <name>Club house</name>     <ExtendedData> 

I have a problem when creating a workflow in which additional attributes are linked via an identical ID from Excel (name) and Ifc (ETL_TYPEN.NAME). The problem is that not all attributes from the Excel list are recognized and linked and the geometry is taken over in the updated IFC (Writer).

in FME 2020 the behaviour of Generic Reader changed in a way, that "Guess format from extension" for GPKG now defaults to GEOPACKAGE_RASTER instead of GEOPACKAGE (vector). This broke a workflow in our application. Why was this changed ?

Hi, I have a 3D modell as object file. I will convert this to cesium tiles!I tried this way:Reader -> CoordinateSystemSetter -> Writer (Cesium 3D Tiles) But if I import the tiles inside cesium (e.g. cesium ion) I do not get georeferencing. So the model is not display at the correct location.  Is it possbile to assign a georeference to an obj file?

Hello Sir / Madam, So I would like to subtract both "Top Height" and "Rooflevel" attributes. I use attribute manager to calculate the value@round(@abs(@Value(TopHeight)-@Value(ROOFLEVEL)),1) The result is shown as below.However, I want my result to be <null> if either TopHeight or Rooflevel is <null>. May I ask how to do it? Thank you. Zachary

Hi,I'm trying to read in various Caris CSARPC files and some fail with the following errors: (Had to sanitises paths)I've moved the FME temporary file location to a network share that has plenty of space as I thought it was running out on the C: drive, and it is writing the temp files in the correct location.It also is not consistent, I can run other CSARPC files through reader and it works fine, some a lot big then others, not sure what is going on?? Output"FME Configuration: Source coordinate system for reader CSARPC_1[CSARPC] set to `_FME_0' as read from input dataCoordinate System `_FME_0' parameters: CS_NAME=`_FME_0' DT_NAME=`WGS84' PROJ=`MRCATK' QUAD=`1' SCL_RED=`1.0000000000' UNIT=`METER' Storing feature(s) to FME feature store file `\\\\XXXXX-share4\\XXX_GIS_Warehouse_Scratch\\temp\\wb-cache--zD5304\\Main_CSARPC -1 2 -1 0 7d1dc4d5b02aac6f53ce8974ab35efb9a70c671b.ffsu

I have a 2016 workspace that I'm upgrading to 2021.2.5. The basic workflow is SQLExecutor -> GeometryReplacer -> Clipper with an AOI -> FileGDB.What comes out of the DB is the geodb_type which helps to determine features get routed either the polyline or annotation feature class. GeometryReplacer is used to convert from WKT so that features can be clipped with the AOI. From SQLExecutor, geodb_type has values (geodb_polyline, geodb_arc, geodb_annotation), but when it comes out of GeometryReplacer, geodb_type values are all missing. So after clipping, everything gets routed to the polyline fc, which will produce this error: "Cannot write a non-linear feature to a polyline feature class." [geometryreplacer_geodb_type.png] My workaround is to use GeometryFilter to route the features + a new AttributeCreator to hard-code geodb_type values to ensure the right features are created in FileGDB, rather than rely on geodb_type va