FME Form

I have for example 10 excel files in the sourcefolder that all be read from FME but only 8 files have the right basenames to go through the first tester and the rest of the workflow.......i want at the end move the excel sheets from the source folder in a destiantion folder....all that works already.....but now the filecopywrter move all files from the source folder......how and where i can put a condition that FME should only move the excel files which have the right basenames? Cheers and greetzFranco

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 write a different json file for every time window defined in my TimeWindower.To make things simple I'm using the window number as the window ID attribute (when I manage to make it work like this I'll use the window start time).I want to write the data in each time window into a different (json) file and to name them I want to use the window id attribute together with some other string.Right now the first file (string_0) is output as expected but the workspace will only output 2 json files for a total of 4 time windows (I used a terminator after the 4th time window) and the second one is not properly closed.Any idea of what am I doing wrong?

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! ... 🙂

Hello!this is a long shot, but I hope I might find some help here.Is there a way using FME to write Operational layers to enterprise web maps?If you are familiar, there are widgets, like the Drew, which produces an operational layer, which is actually a temporary layer.I would appreciate any kind of help.Thank you! 

In a Esri ArcGIS Portal Feature Service that we are processing some of the GlobalID's are in lower case without the culry brackets. When FME reads these GlobalID's the case is being changed and brackets are added. Hence the GlobalID "26565f7e-615f-43a6-8333-e156adc7cb46" is read by FME as "{26565F7E-615F-43A6-8333-E156ADC7CB46}".  One problem comes about when FME can't update this feature using the GlobalID because FME as reformatted the GlobalID. This problem is verified by using FME to change the case of the GlobalID to lower case and removing the curly brackets which then allows the feature update to occur. My question is, how can I get the Esri ArcGIS Portal Feature Service Reader to read the GlobalID's without reformatting? 

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 original file. here is a snippet of the original tab's data: so i'd like all of the unique specialchar values to be copied to their o

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: THIS INDICATES A MALFUNCTION OF THE FIRE SYSTEM MONDAY THRU FRIDAY, 8:00 TO 4:30 PM, PLEASE NOTIFY Bob MAINTENANCE DISPATCH AT XXX-XXXX ALL OTHER TIMES, NOTIFY THE TELEPHONE OPERATOR.  i'm then using stringconcatenator to combine the two file's contents with a new line between: My expected result here would be

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

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

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, which is 1.3gb in size!…     I know gpkg adds a populated 'id' field, where tab doesn’t. But surely that alone can’t explain the vast difference between the two outputs (tab: 56mb, gpkg: 1.3gb). This issue is replicated across the other parts of the workspace's outputs, and in other workspaces where I publish to gpkg.  In addition, I think it may have something to do with indexing. So, I tried to set the FeatureWriter to not create the index. But this made no diffe

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 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?