Transformers

I have a HttpCaller that reads different kinds of information depending on the user input and therefore the attribute column names are all the time different. With the JSONFlattener you can import the column names that you want to expose, but ideally I would like to expose them dynamically. I was wondering if something like that is possible.

I have an excel containing 3 columns with name of Belgian commune in 3 format : one with dash (ex Saint-Nicolas), one its regex counterpart (\\bSaint-Nicolas\\b), and one without dash (Saint Nicolas). My goal is to replace, in a feature layer, the attribute with the dash by the one without the dash. So, for this, I am using a conditional replacement in attributeManager, but it fails ( @ReplaceString(@Value(attributeToReplace),@Value(xls_regex),@Value(xls_FinalName),caseSensitive=TRUE). It seems that it doesn't recognize that the attribute fulfill the condition. But, if I put my condition manually, one commune at a time (attributeToReplace Contains \\bSaint-Nicolas\\b, etc.), it does work ! What am I missing here ?

I want to tile cache images and write them to the folder by Mapbox structure with PNG files.I have tried using WebMapTiler to tile cache images and found it different from Mapbox structure.I tried also Writer Mapbox Vector Tile (MVT) Tileset to write them and i found that the folder structure was correct (Level-Row-Colum) but its file is pbf formatHow do I create tiling cache images with the same structure above when I use Writer Mapbox Vector Tile (MVT) Tileset in order to write PNG files instead pbf files?Pls, help me! ... 🙂

I am calculating angle between two points using the geographical neighbor finder. This returns an angle which starts from East and goes counter clockwise. To map to geographic coordinates I use the formula 90 - angle, if angle < 0 then angle +360 This is resulting in a set of angles which when visually inspected appear to be shifted clockwise. In Washington and on the West coast, this shift ranged from 50-70 degrees. on the east coast, it ranged from 20-40. Louisiana sat right in the middle at 40 degrees. These shifts seem reminiscent of the transforms between magnetic north and true north.  Is there a way that I can derive angles from the geographical neighbor finder so that they line up with angles expected through inspection? Thank you.

I have a Geospatial PDF file, I want to convert it to Raster (Geotif) but I can't put any text into the Raster output. I use the TextStroker transformer before connecting it to ImageRasterizer Transformer but it always error, I also tried some way to run the TextStroker transformer but I have just received only one message "Error running translation".Anybody help me! ..... I'm using FME 2023 version

Hi all,I am almost where I want to be with my FME script, however am encountering a road block as the final portion of the script is writing duplicate records and adding geometry to my target feature class, when I want the original records in the target feature class updated.I have two separate polygon feature classes, one entitled TDE Projects and another entitled TPL Corridors and Concepts. There is one Project Number (text) attribute that only exists in the TPL Corridors and Concepts layer that I want translated into overlapping polygons where TDE Projects and TPL Corridors and Concepts polygons overlap and have the Project Number from the TPL Corridors and Concepts layer inputted into the TDE Projects records.Right now, my script is performing the overlay correctly and inputting the Project Number into a new field I created in the TDE Projects table entitled "TPL Project Number", however it is also generating duplicate records/geometry.Ex: Correct record in TDE Projects w

I am using an Attribute Value Mapper which works well but would like to refresh the mapping data (imported from excel file) at run time so that the Transformer always holds the latest up to date data without having to manually import. Any ideas? thanks!

In my PostgreSQL 9.4.26 (Greenplum Database 6.25.1 build) I like to import a csv with a location written as GEOMETRYCOLLECTION. What is the best practice to import this csv? Table: CREATE TABLE geometries (name varchar, geom geometry); In PGAdmin I can import the script below: INSERT INTO geometries VALUES ('Point', 'POINT(0 0)'), ('Linestring', 'LINESTRING(0 0, 1 1, 2 1, 2 2)'), ('Polygon', 'POLYGON((0 0, 1 0, 1 1, 0 1, 0 0))'), ('PolygonWithHole', 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0),(1 1, 1 2, 2 2, 2 1, 1 1))'), ('Collection', 'GEOMETRYCOLLECTION(POINT(2 0),POLYGON((0 0, 1 0, 1 1, 0 1, 0 0)))'); How can I import the attached csv with fme to this table?For example:id,locationtest4,"GEOMETRYCOLLECTION(LINESTRING(4.79331731796265 51.5768852233887,4.77598190307617 51.5717544555664))" 

Bonjour,  Je rencontre des difficultés depuis maintenant plusieurs jours sur un traitement FME, donc je me tourne vers vous.  Je dispose :d'une API token : thttps://ext.prod.api.e*****.fr/oauth2/v3/tokend'une API GET adresse de(s) PRM(s) : https://ext.prod.api.e*****.fr/address/v1/{{PRM}}d'une table de données avec tous les id unique PRM (388 PRM différents) Je souhaite, requêter mon API selon une variable colonne : la colonne id_PRM de la table PRM, mais je n'arrive pas à requêter mon API. Pour l'instant j'arrive seulement à requêter 1 id_PRM à la fois. D'après mes recherches il faut soit que j'arrive à définir ma colonne comme variable, soit que je créer une boucle Looper, mais je n'y parviens pas. Est-ce que quelqu'un s'est déjà retrouver dans cette situation et pourrait m'aider ? Je vous remercie par avance.  Morgane  

I am working on an Excel spreadsheet that contains employee information from various markets. My aim is to extract this data and import it into the ArcGIS portal. However, the only transformer I know of that can accomplish this task is the ArcGIS Online Connector. The problem I am facing is that it requires a file to be uploaded, which is not very useful in my workspace. I do not want to save my output file; instead, I want to write it directly to the portal. I would greatly appreciate any feedback. Thank you!

I have source data with a special character in it, a right arrow, that is: When outputting to KML, Google Earth complains about this character. Notepad++ represents it as 'SUB'. It may be the Unicode Rightwards Arrow 8594. Whatever it is, I need to get rid of it. I've tried both the CharacterCodeReplacer and the StringReplacer without success. Is it possible?Thanks 

I define a bounding box in JSON as UserParameter but when processing it, the JSONFragmenter fails when I refer to the UserParameter.Simply converting the UserParameter to an attribute, and reading the attribute into the JSONFragmenter works! There is no change to the JSON string done, and the source for the JSONFragmenter offers the use of UserParameters.The documentation for the JSONFragmenter though is pointing at "any string expression, including attribute values and workspace parameters."

I am writing data into the workspace from AGOL and using a template file in the excel writer, but nothing is being written. What am I missing?

I checked into the library and the metafile is actually present I am currently on MacOS 14 (Sonoma), but the error appeared also on MacOS 13.6 (Ventura). I tried multiple FME versions from 2022 and 2023 (most recent 2023.1), but nothing changed. Each app was fully un- /installed and my machine restarted several times.In the following page a found a similar. type of error, but no real solution was posted. https://community.safe.com/s/question/0D54Q0000931q1eSAA/i-get-this-error-workspace-generation-failed-parameter-file-was-privatevarfolderstrrfmmyq590j17jq9ndl8my5lh0000gntfme16356342673728830-can-anyone-helpI hope someone could help me with this. Many thanks.

I would like to create a custom transformer where I can submit a group of attributes ( e.g. all datetime ) and have the output back into the same attributes. Similar to the 'DateTimeConverter' or ' StringReplacer' which allows for the selection of multiple attributes to perform a transformation upon. Is this possible? If so, how as I am unable to find documentation . Other suggestions greatly appreciated. Many Thanks

I have read through the documentation regarding distributed deployment of FME Flow but I can't figure out if all of the distributed engines need an ArcGIS server license, or just the main server. Thanks

At my workspace I can give GUID's to surface polygons. (Lod4Multisurface). But as you know polygons consists LinearRings. With GeometryPropertySetter or Attribute manager I could not access to LinearRing and assign GUID values for them. Am I using wrong trasnsformer or wrong using wrong parameters at related trasnsformers. I will be gratefull if somebody knows how to.

I have connected to an third party data source via an XML url and managed to export this to SHP file format.  The issue I am having is that the latitude and longitude are not being pulled through into the writer. Equally, the lat/long and name of the data source are showing as there own row in the attribute table not as a column. I have attached a snip for reference.  This is my first time using FME so have read a few articles and tried a few differerent transformers to try and get the output I am looking for but to no avail. Any help would be appreciated.

I'm not sure of the significance of the error either. I plan to use the final geometry in a few energy simulations using Rhino and OpenStudio. Is it really necessary to fix non-planar polygons to run these simulations? I could use advice in this matter as well.

Hello everyone, I have a writer, that takes three attributes to write to a text file. Each time that I run the workspace, the text file output is different than the last time. I need the output to be in order. I have a header, a body and a footer that should come in that order. Am I missing something? Do I need to build more attribute types for this to work?

I'm working with a JSON file that is a form configuration. Users complete the form through a company website and there are lots of conditional questions and picklists embedded within questions. It's a real nesting doll of data.  Our form system has gotten bloated so I am taking redundant forms and creating one normalized form, but first I need to break down the configuration of each form and represent it in a CSV format so I can easily see the flow of questions and their sub questions. So far I have been able to download the JSON file, add a reader and perform a couple transformations (reader > list_populator > attribute_keeper > list_exploder > list_builder) to isolate the overarching questions and organize each by an index number (the order which they appear in the form). In total there are 8 main branches of questions, but each of those has dozens of nested sub-layers that go deeper and deeper; many of which are long picklists.  From here, I want to be able to

Hi. I have a DGN file with exploded symbols (img 1).I need to make one line from these 3 following lines and fill the gaps between these lines.Firstly I use Snapper (snapping tolerance set to 2 because gaps are about 1.7) and then LineCombiner. It works well with my test data but at real DGN it works wrong (img 2). I do not want involve marker ("circle" with short line) to process.Thanks.

Does anyone know how to generate a map with FME, I met a resolution issue when creating base map. The wms link looks good in QGIS, but when use FeatureReader in FME, use bbox to get the wanted are, the resolution is super low.

I have a large dataset of points (~21m) with an attribute column that identifies one of 540 groups that they belong to. I need to create a set of polygons that contain all the points in each group and then buffer these polygons so that there are no overlaps or gaps between them. I've tried creating voronoi of the individual points and then dissolving by group, but this was incredibly slow and seemed to generate odd results. The alternative approach I tried was using HullAccumulator by group, which was very fast but I can't think of any way to get around the gaps. Any help much appreciated.

Also "MULTIPOLYGON (((4.9086662233849 52.753664580098, 4.9151035250207 52.749014947513, 4.9148889482994 52.748742188294, 4.9156828821679 52.748157698504, 4.9128719271203 52.746547063843, 4.9067350328942 52.750989153809, 4.9072071016808 52.751261898961, 4.905790895321 52.752222987318, 4.9086662233849 52.753664580098)))"can i create a geometry with this data?