Best Answers

Hi all,I'm having issues configuring the JSONTemplater to output my data.I currently have 7 rows, with 2 unique IncidentIDs. I'd like to aggregate the postcode data and geometry for these 2 IncidentIDs so that the json can be used on a webmap showing all the postcodes associated with an incident: I've configured my ROOT and SUB templates but the JSONTemplater fails at the root. Can anyone see what I am doing wrong?ROOT:{ "type":"FeatureCollection", "features": [ fme-process-features("SUB") ]}  SUB: {    "type":"Feature", "properties":{"Postcode":fme:get-attribute("POSTCODE")},    "geometry": {fme:get-json-attribute("_geometry")}} Thanks in advanceN

attribuut : Oracle Non-Spatial Writerparameter : Table Handling (Use Existing/Truncate Existing) Is it possible to adjust the values ​​of Table Handling (Use Existing or Truncate Existing) in a flow? In a daily data dump, there can be a mutation file or an initial file per table (csv file).Based on that I want to determine Table Handling.  This will save a lot of work. Now I still use 25 CSV files out of more than 100. This may increase in the future. For example, of those 25 files, 5 can be initial files and 20 can be mutation files. It will be written to Writer Oracle Non-Spatial.For the Feature operations I use fme_db_operation. I hope my question is clear. Thanks in Advance

Today I was helping one of the users in my organisation with some code in a PythonCaller. The value returned by fmeobjects.FMEFeature.getAttributeType — Python FME API FME 2023.0 b23309 documentation (safe.com) is an integer. The list of possible values is defined by the list of constants here Features — Python FME API FME 2023.0 b23309 documentation (safe.com) What I am missing is which constant represents which integer value. Are these available somewhere?  This would have been helpful understanding me and my user what was happening.

how can i extract the attributes [Equipment-ID, Cleint-ID, Height and Date] from this xml? Any help will be highly appreciated. Kind regards,Keller.

I am unable to see FME badges in my board.I completed FME basic training and some part of FME advance and server.Please share the link for that.

How would I configure ftp caller to upload multiple PDF files to an ftp site?I tried Transfer Type - Upload a File and used a wildcard in the path, *.pdf, but this was rejected. I know how to use FTPCaller to upload a single file. I have included a screenshot of the FTPCaller parameters I chose but these result in a rejection.  I want to upload all ftp files in a particular folder to my ftp site.  If FTPCaller cannot upload "all pdf files in a particular folder", what other transformer should I use?

Hello , i am trying to create connection between FME HTTP callers and azure AD . the connection is succeeded with http caller i .what is the next step ? i have added the requested url with tenant id and client id and client secret .it seems to me that it is working . what should I do now to upload specific file through http callers ?could someone advice me ,thanks in advance .Fme 2021

I was following the FME Desktop Basic 2022.1 web training (trailhead). Now I can't find my progress or training anywhere. Is there something i missed?

To get a file validated, users can send an email to the FME-Server with the file attached. In an automation we first check, whether theres an attachement at all and whether the extension of the file is correct. If so, a validation-workpace starts, If not, the user gets an email back.This works fine, as long as there's just one attachement. But we now have a user with a grafic-file in the email-signature. FME-Server counts that as attachement too and sends him a mail, that he has to send a file with the correct extension, even though the file is there...I would have to loop through the attachements, if there were more than one, but how can I do this?(We are using FME Server 2020.0.2.1) Thanks in advance!Vera 

I have data coming in from an instrument. It contains the readings for gasses like oxygen and H2S.  I am trying to create a report to highlight the highest value in a given hour on a given day. With the table below: Instrument 1 | 10:00 AM | March 1st | Unit ABC 123 | H2S 10 ppmInstrument 1 | 10:05 AM | March 1st | Unit ABC 123 | H2S 5 ppmInstrument 1 | 10:10 AM | March 1st | Unit ABC 123 | H2S 0 ppm...Instrument 1 | 10:00 AM | March 2nd | Unit ABC 123 | H2S 10 ppmInstrument 1 | 10:05 AM | March 2nd | Unit ABC 123 | H2S 15 ppm... I would want the report to show me the following,Instrument 1 | 10:05 AM | March 2nd | Unit ABC 123 | H2S 15 ppmInstrument 1 | 10:00 AM | March 1st | Unit ABC 123 | H2S 10 ppm because those values are the highest gas reading for each hour, (10 AM as a record, 11 AM as another etc) on each unique day. I have tried the statistics calculator, but it doesn't allow you to accumulate the other attributes, or allow you to find unique fields to 're-merge'

Hello ,i have different points and lines as output of FME . i would like to write the output of Fme directly in new map view in arcmap . thanjs in advance fme 2021

Feature cache works great as a method to inspect all transformers after a workbench has ran, but causes a few issues for me.it hurts performance to cache each and every transformerI lose all the cached data if FME crashes or I close the workbench.I am looking for advice on ways to cache or otherwise save output from only a few transformers. My only idea is to write features out to a file, and later bring back in with a writer. are there other transformers I may not be aware of that can save/recall data after restarting the workbench? 

I've PostGIS table with two geometry types - Point & Polygon. When I read table, I'm only able to see Polygons. But point geometry column is only shown in table and unable to visualize. Is there any way to visualize point geometry instead? How do we explicitly mention for which geometry columns to be visualized? Thanks!

Hi there,we have a workspace where we check with a HTTPCaller, if an URL has data to download. This workspace works perfectly in FME Form.  If we notice, that there are no data available, we want to become an E-Mail in order to react on time. We have created an automation in FME Flow with an E-Mail-block.  Now we do not know how can we make the match: No data to download (FME Form) -> Action failed way in FME Flow in order to send the mailData to download (FME Form) -> Action successful in FME in order to log a message how can we make it? Thanks a lot in advance

I am creating the desktop version first but it will eventually be published to FME Server so the specific file choice would need to be done using a user parameter.Ideally, I would like the generic reader to be able to accept any of the following file formats: feature class, shapefile, GeoJSON and CSV. I have created a published user parameter for File/URL which would allow the user to locate the file they wanted to run through the workbench.Currently, when I try to add this user parameter in as the Dataset for a generic reader, I get the following error:Workspace generation failed. Parameter file was C:\\Users\\********\\AppData\\Local\\Temp\\FME_1697209596703_9204. I have also set up a workbench where I tried filtering to feature readers for specific formats e.g. feature class would have it's own Feature Reader where the Format is: Esri Geodatabase(File Geodb) and the Dataset is still my user parameter. However, in this example, it needs to know the name of the feature class(Feat

Hello everyone, is there any way how to generate next letter of alphabet? E.g I have feature with value "A" and I wanna generate next letter in alphabet, so letter "B". Is there any function for that? Thanks a lot! Lubo

Does any one know how to read the latest file from a One Drive folder. I'm able to select a file from the One Drive folder using a Microsoft OneDrive (Graph) web connection, but I can't find a way to read all the files in the folder and then find the latest. I have read the question regarding reading the newest file for a folder https://knowledge.safe.com/questions/65203/read-only-the-newest-file-from-a-directory.html. It's very helpful condeptually. I would appreciate an thoughts or insight. Thanks,Frank

Hello everyone,Is there a way to drap a 2d surface or polygone into a 3d surface (like in the picture joined). If there is in which format do we need the surface and polygone to be? Thank you in advance

I am using a SchemaScanner to prepare a dataset for dynamic writing to a PostGISWriter. How do I write to the columns for PrimaryKey and Geometry in an dynamic environment?

Hi there,We have an excel file with an easy table. Just 2 columns: Position and Id. The file has about 100 lines.We want to read the file and process each line. We have tried with a custom transformer but we are not able to process the lines individually. If we read the Excelfile we get the 100 lines and all lines will be process at the same time. If we convert the lines into a List, we get the error "Transformer/Factory test_loop_2_ListBuilder is blocking and cannot be used in a loop, but was found between 'Loop to test_loop_2_Looper1697190238 Input Splitter' and 'test_loop_2_Looper1697190238 Input Splitter'".  Has anyone an idea to make it?I have found this link (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/transformers_custom_looping.htm) but it helps me only with the loop. Not how I can process the ids separatelly. Many thanks in advance!

I have a point array of addresses, and a line geometry layer of streets, and I need to be able to get the ID of the nearest line to the point that also has a couple matching attributes. What are the best options to consider?

I want to move files from one folder to another. I have added the FileCopy Writer to my workbench and set the parameter to Move, not Copy. I am using FME Desktop 2021.  I think I am missing something because when I run the workbench it runs successfully but no file gets moved. I have included screenshots of my workbench.

I have about 1,000 KMLs in a folder, all with the same schema and only one feature each (line features). I want to bring in each KML into a single feature class in a file geodatabase in ArcGIS Pro and populate a field in that feature class with the unique name of each KML. Is there a way to even do this in FME? Thanks!

id,v1,v2,v3,v4,v522,hi,hi,1,2,322,hi,hi,1,2,322,,,,,33,hi,hi,2,3,433,hi,hi,2,3,433,hi,hi,2,3,433,,,,,44,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,,,,,

I have a bunch of points that fall on or near a linear features (routes/roads). Is there a way to use the Locate Features Along Route tool in FME to identify which route those points fall on?