FME Form

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)))'); 

I created a workbench that reads attachments of AGOL feature layers and write them into a GDB. The scripts works fine for features with one attachment. However, when a feature contains multiple feature, it's only reading one in my script. Does anyone know which setting I have to set, to read all attachments for every feature?

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

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."

Hello everyone and thanks in advance. I have a geojson of polygons with the fields 'name' and 'area'. I want to know which polygons touch each other but have different area. I have reached the spatial relator with the predicate 'requestor touches supplier'. This generates an output with the 'related_suppliers' field, which indicates the number of polygons that touch the feature. It also generates a list, which I think is where the solution lies. I've come this far but I don't know how to continue. As a final result, I would like a simple table where each record is a neighborhood relationship between polygons. Thank you so much, Pol  

A colleague recently installed Desktop 2018.0 and later on 2018.1. Workspace seems to run correctly but when the inspector pops up it logs the following error:Failed to create the reader in the worker process for 2D rendering We can see the tabular data but the geometry won't show up.  He does have a 2017 version of desktop installed, this installation seems unaffected by this problem. Any ideas where to look / what to do with these symptoms / logs?

Hello Forum, I have several workspaces where I take a series of csv exports from our other applications and convert to useable GIS files such as tab, shp or gpkg. This example is where I am consuming a csv export from our GMS and publishing as .tab to location A and geopackage to location B. The problem I’m seeing is about the size of the output files. For instance, take this part…  The orange circled writer creates this tab…  Which has a combined files size of 56.9mb…  The blue circled writer creates this gpkg, whic

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.

I have a csv file where the geometry is in LL-WGS84, but displayed into a single field like this: (lat, lon). I am very new to FME, but I think I have managed to first use a attribute trimmer to get the parentheses out. I then do a Attribute splitter, which sends the data into a _list. I send list{0} and _list{1} into a newly made latitude and longitude field for the geodb writer, but I get a lot of warnings saying  "FileGDB Writer: The `Longitude' attribute could not be written. The containing feature has been dropped"So latitude gets written, but not longitude, and I dont know whyAnyone know what I am doin wrong?

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.

Hi I would like to make a REST call using FME HTTPCaller to Validate Network Topology as defined in https://developers.arcgis.com/rest/services-reference/enterprise/validatenetworktopology-trace-network-server-.htmI have obtained the token in the first call, and would like to pass all required parameters in the second call. (see attached)I am getting error:This FME Edition doe not recognise the '' function Any suggestions how the required parameters, inc the token can be passed to fmecaller

I would like to know how to build the JSON body for an HTTP POST request to pass in Published Workspace Parameters, opt_requesteremail (who to send an email to), and nm_jobsuccess_topic (which topic to notify on success) for the Data Download Service.  The goal is to interface with another web application where a user can  to submit an asynchronous "report request," that emails a download link when their report has finished processing. I am specifically looking at the POST to avoid any potential issues with large/complex geometries being passed in as a parameter and being too long for the URL. I had started looking into the FME REST API, and figured out how to define the parameters in a JSON body, but eventually ran into an article that states "A Web Service URL looks similar to the REST API Request URL; however, it exists outside of the REST API. A Web Service URL should be used instead of a REST call if you are intending on using the Data

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.  F

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.

Should it be possible to determine the details of the user or machine that "called" a workspace app shared by a URL link? Currently I'm seeing the name of the "owner" under the "RAN BY" column, but I'm interested in learning more details about the user or machine that made the call.

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.