FME Form

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 am having issues using Feature Reader to access ArcSDE geodatabase in FME Form 2023.1. When opening the Feature reader in the old FME version, there is a DataSet option to select after choosing the Format. I also have the option to create connection files as a user parameter. Now in FME Form 2023.1, After selecting Format, the Dataset option changed to Connection. However, when I try to select a new connection file within the parameters, I am unable to find the option. In my previous FME workspace, I utilized connection files as user parameters. Please let me know if I am missing anything while configuring the Feature reader to read ArcSDE data in FME Form 2023.1. Thank you!

So i have a sheet that contains a bunch of unsorted rows, and i want to read the most recent file, create separate tabs within the existing file for each unique attribute value and then copy all of the rows with that value into the associated tab. So i've got an excel reader to read the directory, then i'm sorting the files to get the latest one, sampling just the newest one and using featurereader to feed into the writer. i've attached a copy of my workspace for reference, as well as an input file. i've been trying to use this article as a guide:https://community.safe.com/s/article/fanout-1 but what is happening right now is the writer is creating a new file, with NULL as the filename with the new tabs, and, then editing the original file with an empty tab named "fme_blank_sheet" instead of writing them all back to the

Hi, I have 2 attributes that are text from a pair of text files, i want to combine them into a single attribute. I'm using an attribute text file readers to pick out the text, then creating an attribute for each of the text_line_data ouputs and naming them initial (first file contents): First string contents:******************************************************************************  THE FIRE TROUBLE CIRCUIT IS REPORTING A MALFUNCTION!  ****************************************************************************** 3 and extended (second file contents - second file's filename is contained inside the first file, hence the extra processing):Second file contents:

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.

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