Transformers

I'm using the JSONTemplater and have an attribute list. My (sub) template is {"id": fme:get-attribute("sumo_id"), "crosswalks": fme:get-list-attribute("_list{}.poly_id") }Which works fine if i have multiple list elements,  but becomes a string if I only have one. {    "id": "390335938",    "crosswalks": ["225790", "2833648", "15808"]  }, {    "id": "126630292",    "crosswalks": "1243410"  } when I'm looking for {    "id": "390335938",    "crosswalks": ["225790", "2833648", "15808"]  }, {    "id": "126630292",    "crosswalks": ["1243410"]  }, Is there anyway to force the JSONTemplater to keep the array, or baring that what is the best way to post process the templater results?

Hello everybody, If you have seen the image, the labels displayed near the points they mention the order or the route of GPS, I would like to know is there a possibility for example to eliminate the segment which is near point 70, because in real life it should snap on the other segment. https://zupimages.net/viewer.php?id=21/27/j24o.png

I have a directory structure containing source raster tiles (512x512 pixel png files) in TMS (XYZ) format at level 10. These have been provided to me by a third-party.From these I'd like to generate levels 9 & 8 so additional layers can be shown in a leaflet app. I thought FME and the WebMapTiler would be the answer, but I'm struggling to get this working. So far I have the following in workbench: A PNGRASTER reader that reads all the source files from the existing directory structure.A PythonCaller to calculate the bounding coordinates of the source tiles using a python function from here - https://wiki.openstreetmap.org/wiki/Slippy_map_tilenames.A RasterGeoreferencer to georeference the rasters usign the above coordinates.A RasterMosaicker to generate a single raster.A WebMapTiler (set to GlobalCRS84Scale, Minimum Zoom=8, Maximum Zoom=10) to generate the raster tiles at level 10, 9 & 8. A PNGRASTER writer with the name set as the Y (row) attribute and a fanout express

Hello,​So I have a data, which is called "Amendment Date". The format is as followDD/MM/YYYY HH:MM:SS. ​I would like to make a checker to check if the input data are correct. I tried the attached steps and it seem ONLY works on correct order. If the data is wrong, it said ERRORS and cannot run the transformer. Would someone please guide me how to do valid the format. Thank you.

How do I convert a date such as 12/31/1979 to Julian date in FME?

Hi All,I am working a project ,where client asked us to add suffix to a attribute value .This attribute value is not a Unique , in order to make it unique we have ad suffix values as shown below image , requesting you all to provide a solution ? to reach this requirement! (the suffix number should be 4 numbers)Thanks in advance.

291 / 5000  ÜbersetzungsergebnisseI'm looking for a transformer with which I can create a buffer around a line. This buffer should have a defined width. The line has z-coordinates.At the end I would like to continue using the buffer polygon that was created and the polygon should receive the z-coordinates of the line.  

I am currently using a ChangeDetector to determine which fields have been updated in two different databases. The change detector works as intended and creates a list of different fields have that have been updated. The problem I have is that all the updates need to be written to a database on a one-by-one basis and currently I cannot find a way of sorting the updates by the specific field that has been updated. The updated list created by the ChangeDetector has specific attributes called "attributeName" and "revisedValue". I want to use those two attributes to create a new single attribute which is named after "attributeName" and has the value from "revisedValue" that indicates to my database which field need to be updated and the value that has changed.

Hey community! how can I convert a point cloud in this sense? When I put my obj in Unity I have this problem....

I've got a 3D DGN of a bridge out of Bently. I'm following the instructions in the Creating FMEAR Datasets from 2D Cad models article. Since it's already a 3d model, I'm assuming that I dont need the extruder or offsetter. So it should just show up if I convert it, right? I do get a layer list and scale information in the app, but the surface dots disappear once it loads, and nothing else shows up.

The work flow of this process is that there is an excel spreadsheet from another department that is updated with one new record everyday. This excel document is the source for another spreadsheet that we use in our department where there are formulas that update columns. What we are noticing is that when the workbench is run the next day it will not pull the new record automatically. If I open this excel spreadsheet and save it manually then the FME excel reader will pull the new record. What can I do to get the FME workbench to pull the new record?  Thank you, Laura

I have data for various sites and some sites have been digitised more than once and have overlapping polygons. However, these are not virtually identical polygons. They only partially overlap. I want to find the sites that have overlapping polygons. I tried using SpatialRelator with "Intersect", using the same data as both Requestor and Supplier but it picked up instances where one polygon was actually adjacent to another but probably just overlaps a tiny bit. This resulted in 3700 out of 3900 having more than 1 related candidate which doesn't really shortcut the process. "Contains" wouldn't work because not all overlapping polygons are completely contained.

I have a workbench in which I translate XML files to featureclasses in an ESRI SDE geodatabase. The featureclasses are versioned. I use a featurereader in which I specify the child version. That version is then created by the featureader since it doesn't exist before the start of the translation. Updates are done with an SDE geodatabase writer in this version. I specify in the parameters that the version is to be reconciled and posted after the translation. After posting, the version should be deleted. This is also indicated by setting the appropriate parameter. When I run this workbench in FME desktop, this works fine. However, when I publish the workbench to FME server and run it via an automation, the version is reconciled and posted, but it is not deleted. The log displays the following error:Error deleting the version 'versionname'. The error number from ArcObjects is: '-2147217140'. The error message from ArcObjects is: {The version is currently in use. [versi

I have some data that i am trying to replicate from 1 DB to another, but I cannot create the readers for several FCs that contain arcade expressions. I get the The error number from ArcObjects is: '-2147211773' message. I am running FME 2021 (64 bit), and have ArcPro installed and the Esri ArcGIS Capability is set to Pro. One thing I can't seem to get is the ArcPro Python listed under Python Compatibility. But I do see that listed in FME 2019 on the same machine. Any thoughts on whether or not this should be working and if so, how I can get it to work?

I'm new to FME and tried to use the Rcaller transformer. However, the software lags at the log point "processing Rscript" and does not finish the translation but does not give back an error. This is also the case if I try to run the Rcaller example dataframe() script without any input data. See screenshots for details. Any help much appreciated.I'm using FME 2019.2 with R >=3.6. Translation log:Rcaller parameters:FME Translation Options:

I need to check the encoding of several files. For this I can use a scripted parameter like so: featureType =open('F:\\PGV\\Projektarbejdsmapper\\P4\\SCSV_til_kontrol\\scsv_2021e1_2021e3\\\\2021e1_lev_k_fortidsminde.scsv')t = str(featureType)return t With a Creator and a ParameterFetcher i get the following attribute:<_io.TextIOWrapper name='F:\\\\PGV\\\\Projektarbejdsmapper\\\\P4\\\\SCSV_til_kontrol\\\\scsv_2021e1_2021e3\\\\2021e1_lev_k_fortidsminde.scsv' mode='r' encoding='cp1252'> When I try to do this with a useparameter like so: file = FME_MacroValues['SCSV_file']featureType =open(file)t = str(featureType)return t This returns the following log:Starting translation...INFORM: Using Python interpreter from `C:\\Program Files\\FME\\fmepython38\\python38.dll' with PYTHONHOME `C:\\Program Files\\FME\\fmepython38'INFORM: Python version 3.8 loaded successfullyERROR : Python Exception <KeyError>: 'SCSV_file'INCLUDE -- fai

Hi everyone,I wonder if there is any way to force the SurfaceFootprintReplacer to not ignore holes in polygons?I have 3D cityGML data and want to get only the footprint, using the SurfaceFootprintReplacer the result is image Nr.2, all holes are gone and merged to one polygon. There is a custom converter called "GroundSurfaceExtractor" (I found somewhere in the web), what does it correct but this one takes around 10 times longer to calculate. Any hints?(btw: the cityGML does not include "ground_surface" elements to query for, I tried this one...)Thanks a lot!Building Polygon in 2D:SurfaceFootprintReplacer Result:

Hello,An enterprise geodatabase reader interprets a value in a date field as: 20130426000000A file geodatabase reader interprets the same date value as: 20130426This is a problem when comparing date values in ChangeDetector, as they are always noted as an update, even though they are essentially the same value.Does anyone have any ideas on how to make the 2 dates comparable?

Hi there, I'm using the UpdateDetector transformer and it's detecting changes with lat/long fields where numerically there's no difference. This is because in one reader (the CVS reader) these two fields have trailing zeros, while in the other reader (an oracle table) they do not. What's the best way to resolve this?

RegEx, FontEncoder and StringReplacer experts, please help! I want to replace regular text characters in a text string attribute with entirely different unicode characters, and be able to use them as geographical labels.For instance, let's say that I want to convert the character "A" (unicode U+0041) in my text attribute, to the Roman numeral "I" (unicode U+2160), and label my map with that.  Some other characters should use other conversion codes - maybe using a lookup table. Is it possible?

Does FME support ESRI Representation when mapping data between two file geodatabases? If so how do you go about setting this up?  Thank you, Sam

Hi, I am trying to IMPORT an EXISTING relationship feature class and FME complains about the name being too long....I cannot rename the Relationship feature class since it is a part of an existing data model. The table/feature class name 'WaterstaatswerkWaterkering_Waterkering' is too long for Oracle (!!??) to accept. Please shorten the name and try again I think this is a FME limitation that should apply if you are going to CREATE the table, but should not apply if the table/relationship feature class already exists! Anybody any thoughts/ ideas on how to go about this?

When using PointOnPointOverlayer (POPO), after FME 2018, I experience performance issues. With FME 2018.1.2.0 (20190225 - Build 18590 - WIN64) I could use the POPO with 600,000 records and this portion of the job use to run in 30+ minutes. Now with FME 2020.2.1.0 (20201130 - Build 20806 - WIN64) it takes 7+ hours. I also tested briefly with FME 2021.1.3 (Build 21631 - win64) but saw no significant improvement. What options are available for removing this additional 6.5 hours of processing time? Similar issue to this article from 2017. Thank you in advance for your time :) Julia Highlights from the logfile:2021-10-21 14:11:59|  0.4| 0.4|INFORM|FME 2020.2.1.0 (20201130 - Build 20806 - WIN64)2021-10-21 14:11:59|  0.4| 0.0|INFORM|FME_HOME is 'C:\\Program Files\\FME2020\\'2021-10-21 14:11:59|  0.4| 0.0|INFORM|FME Desktop ESRI Edition (floating)...2021-10-21 14:12:50| 50.4| 0.0|INFORM|Creating spatial index of 2 point features2021-10-21 14:12:50| 50.4| 0.0|INFORM|Completed spatial in

Hi. I was trying to figure out a way to rename all the fields of my output shape using a PythonCaller. I used the "BulkAttributeRenamer" to rename the fields, but just using a single parameter as: prefix, sufix, lowercase, uppercase etc and it's not enough. When I tried to use PythonCaller, I could change only the attributes itself, but not their field's name (I used the function setAttribute(name, new_value))Is there a python function that can set the AttributteName ?

I’m trying to define a transformation process between Intergraph GeoMedia SQL Server Warehouse (Reader) and Esri Geodatabase (File Geodb API) (Writer) using FME Workbench 2015. I have defined a schema file in a spreadsheet that is added in the Workspace Resources (Schema - From Table) to be used as Schema Source for my writer. The features that I am reading are coming with geometries like: `fme_geometry' has value `fme_aggregate' and `fme_type' has value `fme_point' OR `fme_geometry' has value `fme_point' and `fme_type' has value `fme_point'. Basicly this means that my source contains multipoint features and single point features. In my schema file I have defined the Geometry Type Value as fme_point. When the process tries to write the multipoint feature it fails with the message: Failed to write Geometry to feature class … with geometry type 'esriGeometryPoint'. The process works if I manually set the geometry output to geodb_multipoint but I w