FME Form

Hi, After a migration to Office365, FME is unable to open Access files. The following error is given: Microsoft Access Reader: Unable to find provider 'Microsoft.ACE.OLEDB.12.0', falling back to 'Microsoft.Jet.OLEDB.4.0'. The 2007 Office System Driver might be missing from your system; follow this link for more information: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id;=23734 Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source=K:\\dienst VR\\02_rapporten\\Lijst_SEVESO-inrichtingen 2016.accdb;User ID=admin;Password='. Provider error `(-2147467259) Onbekende database-indeling K:\\dienst VR\\02_rapporten\\Lijst_SEVESO-inrichtingen 2016.accdb.'We tried installing 2007 Office System Driver, as given via the link in the error message, but this did not solve te issue. The following error message still appears: Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.A

Host Revit file has 137 linked files. When I try to read even a small portion of these I get the error. Failed to obtain any schemas from reader 'REVITNATIVE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information. I’m using a FeatureReader linked to the Metadata.LinkedInformation output of the host Revit file (first strcating the LinkedFilePath and Name attributes). I get this error even when I limit the input to one record. Separately, a FeatureReader (along with Creator to initiate) can read one of these files. I saw a similar post where the answer was to change the FME_Temp folder. I don’t think this will make a difference since I get the error when only trying one file. I would try this but I need admin rights to set this up on my computer and I won’t be able to get that until next week. Also, I would rather know for sure before I ask. Thanks in advance.

Hello! I am new to using FME and I am working on converting an FBX file storing a 3D terrain model into a CityGML format. I have come across with two questions. How to generate a TINrelief from an FBX file in FME? Does a TINrelief have/need a GML/JSON encoding in CityGML/CityJSON for conducting further geospatial analysis? Can it be a TIN file or a Geotiff file? Thanks!

Is there a way to join two tables using the between operator (SQL). I know I can use SQLCreator but I would like to do this join directly in workbench. sql example: TABLE1.*, TABLE2.* FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.NAME = TABLE2.NAME AND TABLE1.DATE BETWEEN TABLE2.FROM AND TABLE2.TO

Hello, I want to create a workbench for a datastreaming service, that will be call through fmedatastreaming. I want to test and call this service with a FME workbench including an httpcaller transformer. Il a want to pass information through an Upload Body. How this information will be pass and how to interpete this in the workbench of datastreaming? Do you have an exemple ? Thanks

I have a work process that inlcudes running FME jobs daily.I would like to automate logging of potential errors. To do so i am thinking of just reading the .log files from the workbench(es) and search for error as keyword to catch if something went wrong in the translation. I thought it would be straight forward to implement, but i cannot find a way to read .log files using FME directly. Instead I am thinking to use a python script. But I wanted to ask here if I have missed an easy method to check log files for errors.

Hi, I am using FME Workbench 2024. I am wanting to know if I can use a loop or iterative process of some sort to individually run multiple feature classes and shapefiles through a single AttributeKeeper Transformer for each data source, possibly using the names as an iterator. I am working on bringing in utility data from multiple sources and ultimately writing them to a single geodatabase feature dataset. First, I want to clean up the fields and only keep certain ones. Each source of data has a different schema. Currently, I can only use an AttributeKeeper on each feature class/shapefile in order to later output each to its own feature class in the output geodatabase. This would make for a messy workspace with many of the same transformers. Any advice would be greatly appreciated!

Hi All, I am working with lists and require some guidance on the below scenario I have list which contains 'n' elements. I would like to add a sub-element to each element in the list. Assuming my list name called as "list{}" Example: (My list currently looks like this) List{0} element1 element2 element3 List{1} element1 element2 element3 List{2} element1 element2 element3 List{n} element1 element2 element3 I would like to add new sub-element called "element4" at the end of each list element (i.e., add "element4" as sub-element below "element3" ) Expected Output (I would like to achieve something like below) List{0} element1 element2 element3 element4 List{1} element1 element2 element3 element4 List{2} element1 element2 element3 element4 List{n} element1 element2 element3 element4 In Java world, I would ideally use looping to iterate through the list and add sub-element. Not sure how to perform similar scenario in FME. Would really appreciate your help in achieving the above expected ou

Hi! I have a list, containing between 5 and 50 values (varying). How can I append a value to this list? I can only assume there has to be a non-pythonic way, but I struggle to find one. My approach was to use AttributeCreator, but I can't dynamically specify the position in the list. Had the list size been fixed, then that's a solution - but not in this case. Any ideas?

I have a database NAME1. If I open them as Oracle Non-Spatial I can access the following tablesNAME1.AANAME1.BBNAME1.CCNAME1.DDNAME1.EE If I open them as Oracle Spatial I can access the following tablesNAME1.CCNAME1.DD The database contains more than 50 tables. They must be transferred to POSTGIS database with a different schema name: name2 I have already looked up some things in the community. But those are old posts and some transformers don't even exist. What is the best way to approach this? in short:Oracle NonSpatial tables and Spatial tables from 1 database to POSTGIS database with a different schema name. Who can help me and or has an example? Thanks in advance

Before the web presentation of Safe and FME changed to what they are now It was possible to find the zipped FMEData. Data that are pointed at in almost every exercise in the FME Academy, community postings and videos. The new FME page does not provide the “knowledge” structure anymore as before and all links in the community etc. are pointing straight into Nirvana. I can see that these resource now can be found at https://s3.amazonaws.com/FMEData, however, I cannot get a listing of the content of this bucket and I always end up with a 403. Without a listing it is impossible to guess the specific file I am interested in… Can somebody point me to an URL where I can get the latest version of the FMEData?

i have daily & repeated work in geospatial data and I did it manually it takes a lot of time

The IFC data was exported using ArcGIS Pro. After importing it into FME Data Inspector, the following errors occurred: ISO10303-21: Skipping instance #50: Instance is not syntactically valid An error has occurred. Check the logfile above for details Failed to specify the feature index as constraints on the reader Could anyone please help with this? Thank you!

When trying to read an IFC file, I am getting an error ISO10303-21: Skipping instance #1154: Instance is not syntactically valid. How can this be fixed?

Hello! I’m trying to use the Cartegraph Connector and could use a hand. In the past year or so, I believe the API URLs have been updated compared to when this custom transformer was originally made. Now, I am having trouble with the very first step which is authenticating. I think I’m using the wrong URL to have my username and password accepted by the API. Also, this custom transformer was created in 2022 and may not work any longer for various reasons due to versions. As a test, using Postman, I have tested some API URLs and can successfully connect and perform a GET command and get back data. This shows that I’m close.. something works in Postman - so we’re on the right track.. now to get FME to connect. Because this is a work matter, I cannot share a great deal of information openly here. If anybody has a clue about getting connected to Cartegraph as it’s configured today (2024/2025) that would be awesome. Thanks and take care Jim

I’m at working on matching indoor point cloud data to gml LOD2 data using ICP so I want to transform my gml data to a point cloud data to help ease the matching. Can anyone please help me? question is how do I transform GML LOD2 to point cloud data? also if there are other suggestions to complete this task. Thank you

I need to copy records from one hosted feature layer in ArcGIS Online to another hosted feature layer. Schemas are identical. Some of the records in the source data have an attachment (only 1 per feature/record so only in the 0 position in the list). No problem getting all of the records to write from the source to the destination but the attachments are not included. Anyone know how to do bring over the attachments with the rest of the data?

Hi, I have some villages (Primary and secondary villages), each containing a main folder, a subfolder, a data folder, and some empty folders. I will designate one village as the primary village. All sub-village files/data will be stored in the main village folder. Only location path links will be kept in the secondary village folder (marked in red color). Other data will be sourced from different locations (Marked in green color). Finally, I must validate whether all folders and data have been correctly segregated or not. I am currently performing this process manually, which involves copying, pasting, and validating each folder and village individually. This manual process is quite time-consuming and manpower. Kindly help me about this test cases and workflow. I am new to FME and am eager to learn more about its functionalities. Thanks.

Though experienced with reading WFS's, I'm a little bit frustrated about reading a WFS2.0 in the FeatureReader. It seems it is not paginating. Checking the WFS GetCapabilities, 'FeaturePaging’ is not mentioned. I want to query the WFS with a polygon. So that is my initiator. But I'm not sure whether the results exceeding the 50k or 100k or even 200k. That's why I want some sort of ‘FeaturePaging’. Anyone an idea on how to solve my issue? It's probably simple, but I can't see it at the moment.

Hello Forum, I have two polygon datasets, each with just one object in it. The edges of the two polygons abut in places. I’ve created a workspace where I‘m reading in the ‘Above’ polygon dataset and the ‘Below’ polygon dataset. I want to create a line feature of where they share a border. To do this I’ve used an Intersector which gives me a new _overlaps attribute… The exact line I require is where _overlaps = 2… So, I added a TestFilter to filter out where _overlaps = 2… But when I wrote that to a new feature no geometry was created. So, I added a LineBuilder, hoping that that would force the line to be drawn. But the resulting FeatureWriter is still not creating a line dataset - it creates a dataset, but with no geometry. Any ideas? Thanks, Stuart

Hello Forum, Is it possible to artificially create a polygon based on the lower edge of an existing polygon? Imagine I have an existing polygon, I’d then want to create a new polygon that snaps to the lower edge of the existing polygon. The depth of that polygon doesn’t matter, for example it could just be roughly 50 metres away from the shared boundary. What really matters is that is snaps to the lower edge of the existing polygon. An alternative approach could be that the artificially created polygon is a doughnut polygon which wraps around the existing polygon to say, a depth of 50 metres. I could then split it manually where required… I hope this makes sense. Any ideas? Thanks, Stuart

Hello everyone, I have some published user parameters, and the choices will be retrieved from the database. Is there any way to have the user parameters to be updated automatically once the workspace opened? Thank you everyone.

hi ! FME name machine parameter does it exist? I see the name of my computer at the beginning of the log but I don’t find where is this parameter. Thanks !

Hi, I need help. I have an attribute column X with string values ‘S001’, ‘S002’, ‘S003’, and ‘S004’, all lined up in 1 column with 4 rows corresponding to the string values. I would like the output Y should to be a single row list, having just one column and one row, containing the four values: Y = (‘S001’, ‘S002’, ‘S003’, ‘S004’) Could you please advise how this could be done in FME Form. Greatly appreciated. Thanks, Willy de Vera

Hi, Could you please provide an official documentation on how to configure FME Form to access the latest Python version from Anaconda distribution as well as its machine learning libraries. Admittedly, there are topics already posted in the community related to the subject; however nothing seems to work for me. BTW, I’m running FME(R) 2024.1.2.1 (20240906 - Build 24624 - WIN64) on Windows 11 Enterprise Thanks in advance, Willy de Vera