Transformers

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?

Hi everyone, I have split a pt cloud into 2 : Ground and Rest (Ceiling and Beams). and I would like now to calculate the minimum verticale distance (along z axis) between the 2 clouds. to avoid false results with the beams i want to eliminate any results smaller than 2meters. I am a little bit new on FME and i don't know which transformers would be best for this operation if it's doable. Thank you

I have two datasets, where one (a) is holding x/y/z coordinates and the other (b) contains a distance value. I created a line, based on the coordinates from dataset a, and after densifying the line used a measure to get values I can compare to the distance values provided by dataset b. The distance and measure values are not perfect matches, and I would like to accumulate the attributes from dataset b to dataset a based on an a rule like the following: IF 'ref_length' >= 'start_length' AND 'ref_length' < 'end_length' This is what I have so far 

I am looking to use the output of the postgres/postgis function as an input to my fme workbench model, I want to pass the parameter to such postgres function through fme workbench interface and want to use the output generated after running the function .

Hello! I have problem to write several geopackage data to one geodatabase. I used Attribute filter and Dynamic writers. Attributes from all objects comes to each features. How to write data to geodatabase so that there are each features has own attributes? I am not profs with FME yet :) Would be thankful for tips.

Hello, I'm attempting to use an attribute with HTML as a value into the HTML2PDFConverter. What's odd is that said transformer asks where the HTML will originate from (a file, attribute, or URL), but when you select one of those options, it's still asking for the other two as a requirement. Is this a bug?