FME Form

Greetings, I should read and write features one by one, namely in the feature reader I have a condition by which I retrieve data from the database, more precisely the ID. But every time I should first write a feature in the database that gets a new ID, and when reading the conditions for the second time, it should select that new ID, and not immediately select that first ID for me. how to create this?

Hello, I am working on a project which will fetch information and save to local machine, then I use xsd-driven-xml reader to read in the files to parse data down streams. I noticed that reader activate before HTTPCaller task and caused the httpcaller failed to create file in the designated location. How to specify the reader to activate only if my HTTPCaller successful? I have already have the tester set up and will be able to tell either failed or success, but xsd-driven-xml reader did not have condition parameter setting or anything for me to make sure it activate after tester passed. I can separate this into two workspace, or create custermized transformer to encapsulate some condition tester and xml reader together, but thought there might be better way and would like to ask for help here. Any information is appreciated. 

Hi!I have a shapefile with a lot of lines with the same geometry, but different data. They are the fibers of an optical cable.How can I shift them parallelly to each other?

Hi All,For a project I need to write a geodatabase with a time_only field in one of the objects.To be able to do this I had to change my Python Compatibility to Python 3.9, which only works if Arcgis Pro 3.2 is installed.Otherwise I get this very helpfull error:But I don’t want to use 3.2 as default. Now I have 2 folders:C:\Program Files\ArcGIS\Pro2_9C:\Program Files\ArcGIS\Pro3_2I manually renamed the Pro folder to include the version number.The issue now is that FME can’t find my Arcgis Pro, which makes me very sad 😥. How can I tell FME to just use C:\Program Files\ArcGIS\Pro2_9 and stop looking for  C:\Program Files\ArcGIS\Pro.Only when I want, I manually will change the folder to 3_2. 

Hi,I would like to write custom hatches in a DWG file. But our FME Flow is deployed with Kubernetes.So the OS is Linux.Since the RealDWG writer is only available on Windows, I will need to use the other DWG writer (Acad).Where should I put these .pat files to write these custom hatches successfully?The documentations says:The ACAD format writer will look for custom hatch patterns in custom <filename>.pat files located in folder specified by the ACAD operating system environment variable, or in the related folder for any installed AutoCAD product.On windows, I have tried to create an “ACAD” environmental variable, pointing to a folder where I placed my .pat files. But no result.Secondly, will this be possible on a Kubernetes FME Flow?Thank you in advance Jasper

FeatureReader does not recognise attributesHello all, I am having problems with a FeatureReader that does not recognize the attribute columns of a CSV file.The background is, I regularly download the GNAF dataset from Geoscape Geocoded National Address File (G-NAF) | Datasets | data.gov.au - betaThe GNAF arrives as a zip file containing a large number of CSV files. I only need five of them.I have built a Directory and File Pathnames Reader that returns all of the CSV files, which I then filter down to just the five that I want.I am attempting (but failing) to build a FeatureReader that reads the CSV file.I should point out that the CSV file is actually a pipe-separated-value file. The separator is a pipe “|” and the file extension is “.psv” But I have confirmed that a normal CSV reader does successfully read the psv file.Now, the FeatureReader is successfully reading the correct number of features. And FME automatically recognises that two of the columns are LONGITUDE and LATITUDE and

Hi !I don’t know where to post that so sorry if it’s the wrong place 😊When I use the button “alignment Middle” the alignment is vertical and when I use the button “alignment center” the alignment is horizontal. The action seems to be the opposite of the picture on the button.Do you have the same thing? On FME 2018 is the reverse and it look more logical.FME version : 2024.0.1.0Thanks !

Hi,I’m on the version 2024 of FME Workbench, I have to calculate a number of neighbor between points (let’s say 5) in a distance (of 20 for example).But the issue is that I don’t know how to export the 5 distances in specific attributes…If someone can help me I’d love that !

 I have dgn/dxf formatted CAD 3D lines which are "cables" below the ground. These cables are sometimes 1m below ground and sometimes 50cm and 10cm etc. below the ground. I have pointcloud LAS data as ground elevation data.Now I want to extract the cables(lines) which are below the ground upto 50cm. I want to cut the cables layer with elevation model to selct the cables network from 0 to 50 cm below the ground.How can I cut those lines? I am trying with qgis and FME but, unable to get the right solution. Anyone has idea what software or methods to follow.

Current Version: 2024.0.3.0 (20240603 - Build 24220) Since upgrading from 2023 to 2024, some weird behaviours have happened.Some critical workflows have not been outputting the correct information on our public facing website.In this case, I’m referring to the Building Control (BC) header on that page after you type in an address.Instead of stating that there was a BC information against a property, it would say no information found.Whilst investigating I found the following:  The result of SQL Query was outputting NULL values as a string value called {NULL}.Never seen that before. Therefore, the Conditional Value was returning the wrong information. i.e. If xxx IS NULL and xyz HAS A VALUE….Subsequently I had to add a StringReplacer to fix this anomaly for now. SQL StatementWITH bc_html_aggAS(SELECT blpu_uprn,  ARRAY_AGG(bc_html) AS bc_html FROM myproperty.buildc_html_temp     GROUP BY blpu_uprn ORDER BY blpu_uprn)Select     Distinct(bc_html_agg.blpu_uprn), b.address_string, bc_html_ag

Hi,I want to write a RealDWG using custom hatches on FME Flow.When working on FME Form, we put the hatch files in <FME install folder>/plugins/realdwg/Support and it works. But when uploading the workspace to FME Flow, where should these files be placed? Is there a designated location for them in the Resources?Any help appreciated.Cheers,Julien

HI All,What the best way of loading data into a blank template GDB? Attributes, domains, etc are already set up in the template GDB but need to know how to load data into the template using FME,Do I need to use the template GDB in the writer and then map the fields from the reader to the writer?Any idea how to do this?Thanks 

In FME Form 2024.0.1.0 I got an error when trying to read data or schema with “Microsoft SQL Server Non-Spatial” Reader: “Unable to decrypt data”. On the same server, connection with SQL Server Management Studio works fine.Does anybody know this problem or has a solution?Regards, Martin

HelloI have several GDBs with several FCs in different subdirectories. However, all GDBs have the same structure (same FC with identical attributes). I would like to merge all the data depending on the FC and then process it further in an existing workflow. Using the example, I was able to read and save all data, but it deleted all attributes and combined all FCs into one single FC. My question now is how I could read all FCs with the same name from all GDBs, merge them in one FC and then process them further in an existing workflow.

Hello!I have a GIS layer with a field named “yttyp” wich contains all various of attributes since its a text type.I also have an Excel-file with allowed attributes. How can i check if there is unallowed attributes in my GIS layer that is not in my Excel-file, and list them in a new excel-file. I have tried change detector, listsearcher, featureMerger but i dont get it to work.

I simply need to update a geometry column in a SQL Server table that is previously set to NULL. Could someone provide me with a simple example? I can't do it neither with a SQL Executor (previously using a GeometryExtractor to convert this geometry in Microsoft SQL Server Binary) nor with a featureWriter. I found this conversation from a while back but it didn't help me:  Thank you!

Good eveningI produce a worbench wich create a file gdb and different features class (table, polyligne, polygon) from a excel file wich describe :fme_feature_type_name fme_feature_type_alias name alias fme_data_type geometry native_data_typeIs it possible in the same excel file  :to create domain value (domain code and domain describe) to apply Global Id to apply editor trackor Thank you

Hey all,  I am very new to FME and this may be a basic question, But I currently can’t find the answer elsewhere so I figured I would post and see if anyone can point me in the right direction.  Currently, I am exporting from a GE small world database and moving the data to a FGDB for data analytics in other software. This is a complete export of all available data. That much I have been able to figure out with a few minor transformations. What I can’t yet figure out is how do I export only a small portion of the database. Say by a predefined polygon within the existing data set.  For example My DB crosses a number of contiguous cities all having a defined boundary within the drawing. How do I tell FME to select and export only the lines and other objects within the city boundary of interest and excluded the data within the other city boundaries? Ultimately I need this breakdown so I Can export this to AutoCAD since the full DB is entirely too large for one drawing.  Any help is apprec

HelloI find this workbench on this website and i try to use it with FME 2024. It doesn’t work with the new version and i would like to know what is the issue. Could you please explain ?Thanks a lot

I’m trying to retrieve data from a nested JSON response of an ODATA Feed.For testing, I try to access the “Emails” property of this ODATA example service: https://services.odata.org/V4/(S(hg4u5ox0x0r2rjva5qwwra05))/TripPinServiceRW/PeopleThe JSON structure is as follows:{ "@odata.id": "http://services.odata.org/V4/(S(hg4u5ox0x0r2rjva5qwwra05))/TripPinServiceRW/People('russellwhyte')", "@odata.etag": "W/\"08DC9753B5381A6D\"", "@odata.editLink": "http://services.odata.org/V4/(S(hg4u5ox0x0r2rjva5qwwra05))/TripPinServiceRW/People('russellwhyte')", "UserName": "russellwhyte", "FirstName": "Russell", "LastName": "Whyte", "Emails": [ "Russell@example.com", "Russell@contoso.com" ], "AddressInfo": [ { "Address": "187 Suffolk Ln.", "City": { "CountryRegion": "United States", "Name": "Boise", "Region": "ID" } } ], "Gender": "Male", "Concurrency": 6385516329

Hi,I'm working with Sentinel-2 images. I would like to know if it's possible to use FME to remove or clip clouds from images. Does anyone have any ideas? Is it possible to use Google Earth Engine (GEE) with FME?Thank you.

Hi.Could I please ask for a little assistance. I have about 1700 GeoTIFF files that I need to convert to 1700 JPG2000 files. So it is a 1:1 conversion for each file.I am familiar with converting GeoTIFF to JPG2000, but how do I do this en masse?FME Workbench 2020.Yours sincerely.James Blythe.

Hi. I have the JSON data below and I have managed to expose attributes from this using the JSONFragmenter but am stuck with trying the extract the thirdparty.names from this record. As there are multiple names in this nested array I need to extract them either as a comma separated attribute. i.e. Leicestershire County Council, Mr J Tomms. Or as a list that I can work from. I cant seem to expose this attribute due to it’s nesting. Any help with the correct transformer and configuration would be great. Currently using FME Form 2023.2.2 but can update to 2024 if it is easier.           {            "_index" : "xxx",            "_type" : "_doc",            "_id" : "667951b042fcaa46307d1935",            "_score" : null,            "_source" : {               "coi_num" : 68902,               "engagement" : {                  "mail" : "Bob@home.com",                  "objectguid" : "8dc75819103e4e408684a75f87fd320b",                  "dn" : "CN=Bob Smith,OU=Rural,OU=Worcester,OU=FGUsers,DC=fg

Hello, GML always writes a hyperlink at the beginning of the output, how can I fix this?

I have been trying to automate uploading/deleting from a Google Drive Shared file using a GoogleDriveConnector, which I thought was recently changed to support shared drives. The first issue is that the files do no automatically overwrite if they have the same name, they create duplicates, whereas if you upload manually the files will become versioned. To get around this, I assumed I would be able to identify and delete the older file first before uploading the new file, however when trying to delete the older file I get:"2021-10-20 15:19:39| 21.6| 0.0|INFORM|Delete_existing_file: Object with id "File ID" does not exist on Google Drive. Nothing to delete". (I have removed the ID for this post). I have permissions to delete from the drive, and I have created the shareable link manually as a check to confirm that the file ID is correct and exists. I can successfully upload new files to the said folder, but I'm trying to avoid a scenario where I have a load of outd