FME Form

Using FME Form 2024.0 and DGN v8Hello All,I have a DGN file with an OLE Embedded Excel Object. I am able to locate the element that represents the OLE object and can return all the typical IGDS information about the element itself, size, layer, model its in etc. What I would really like to do is investigate tabs, rows and columns content within that embedded Excel. Does anyone know if there is a way for FME to read an embedded Excel object from a DGN  file? 

Hi,I'm trying to clip raster data using a 1k*1k grid shapefile. I'm not achieving the desired results as the clipping is imperfect, resulting in gaps or extra pixels. My goal is to clip the raster strictly within the boundary without any additional or missing pixels.Could someone please suggest a workflow for this?sample data: 

I am trying to re-write an IFC file including its Type Objects. The IFC reader can either output them as single IfcTypeObject feature type or as separate feature types (IfcWallType, IfcDoorType, etc). Reading the Type Objects works fine for me. After manipulating the data, I would like to write them back into their relevant feature types, e.g. IfcDoor together with IfcDoorType, related through the ifc_type_object_id and ifc_unique_id attributes (I'm unsure how the unique IDs should be created but I simply used the UUIDGenerator where required) I also tried reading and re-writing the IfcTypeObject features. However, the Type Objects seem to be missing from the outputs, giving me warnings like the below. If anyone could help out here? IFC: Unable to write objects of type 'IfcWallType'IFC: Unable to write objects of type 'IfcDoorType'IFC: Unable to write objects of type 'IfcBeamType'IFC: Unable to write objects of type 'IfcSpaceType'IFC: Unable to write

I have a workflow that includes transformers and a Python caller. The output of the Python caller generates CSV, GeoJSON, and SHP writers. The workflow has a user parameter called OUTFIELDS, which specifies the fields that should be written. How can I achieve this? I tried using AttributeExploder, but I couldn't dynamically generate the list of fields.

Hello Forum, I have a workspace which consumes an incoming geojson and then outputs three .tab files based on datestamp value combinations (via TestFilters): Active sites – where the start_date datestamp is in the past and the end_date datestamp is in the future Closed sites - where the start_date datestamp is in the past and the end_date datestamp is in the past Upcoming sites - where the start_date datestamp is in the future past and the end_date datestamp is in the future This workspace is doing exactly what I want it to do, so far. However, it’s entirely possible that there may be occasions when no object falls into one of the categories (e.g.: Upcoming sites). At the moment, if that happens then the workspace does not create an output. In this scenario I’m left with the most recent previously created output, where there were Upcoming objects. But in this scenario I need the workspace to create a tab output , but with no objects within it. Is it possible to programme this in into t

Hello dear Community,Despite having a Sorter, DulicateFilter and Tester right out of the gate in my model, I still seem to be experiencing this issue on the ID field of my model - OGCGEOPACKAGE writer: failed to execute insert : UNIQUE constraint failed If I run it one at a time, it seems to work, but I'm trying to write to make different Geopackages, with 4 tables in each (with spatial data). I've been racking my brain about this for some time, changing writers from manual to automatic, deleting any output data after each test run to ensure it's not conflicting, making sure there's no duplicates in the ID field that would trip up the writers, but to no avail - and wondered if anyone here may have a lifeline to throw me.Thank you

HiI would like to add a raster to a DWG and have the path to this external reference set as a proper relative path.When you write a raster to a DWG file, the AutoCAD writer automatically writes a PNG in the folder of your output DWG.If you keep this PNG file next to your DWG, it will always open. However, if you insert this drawing in a new drawing, the link to the image breaks.This is caused by the path of the external reference (raster) that is not properly set a relative path.If we look at the created path from FME in Autocad, we see this:If you change the path type to relative in autocadThen the saved path changes to: I have tried to copy this in FME, but no effect:​​​​Any ideas?Jasper

Using FME 2021, and 2023 SQLExecutor, I am running a simple query to return data from a non spatial table in SQL Server, but I am getting an empty column in return The number of rows are exactly 145 and SQLExecutor result is showing that but the visual Preview just showing an empty column (again with correct 145 rows) I even added a AttributeManager to script but same result is happening Can you please let me know what I am doing wrong here?

Hi,I am trying to write a DWG file with the units set to US survey feet. I can’t get it to work, its is in completely the wrong spot. I’m not entirely sure you can, but I’m not enough of and expert with FME (or US survey feet).Looking at the help file for my FME version (2023.2) it doesn’t have us survey feet as a possible unit to set the insertion units to.I have the unit set in a template file and that doesn’t help when the help says it should use this when I don’t explicitly set it.I am writing to a 2018 DWG (as that is the newest). I know for older versions of DWG you could not set US survey feetDoes anyone have any ideas? Surely US survey feet is a more common unit than the parsec for a DWGThanks

Hi,I would like to create a workbench that will allow the user to make unique slecection from Excel document by entering not only value but also the operator. Is that functionality available?Example  

I have created over 200plus parameter fields and the alignment is off but can’t edit them. Not sure how to do this. I’m new to FME Workbenches and can’t see a way to update this. I’m using the CAT so that these fields can be ran into ArcGIS Pro. I have a huge workbench and not sure what to do next. I would love any help.

Hi All,I have successfully created a workflow that populates an empty template GDB with a relationship class (1 to 1) pre-created in ArcPro. The workflow works fine but I’m thinking to publish the same data onto our Portal for GIS platform to avoid the manual process of publishing the GDB through ArcPro.As far as I’m aware, FME will not create the relationship class and I was thinking to upload an empty template GDB (with 1 to 1 relationship class already created) to Portal for GIS and then point my FME to the feature hosted layer and fill the layer with the data,I have done some basics tests but can’t see that the relation class 1:1 works fine in Portal for GIS (even the empty template has set up correctly the relation)Does anyone have some experience publishing data onto Portal for GIS (or AGOL) with relationships?Any ideas more than welcome,

I'm seeing the following lines in the Translation Log:AutoCAD Reader: Entity type of 'AeccDbAlignmentStationLabeling' found, but not supported. Skipping entityAutoCAD Reader: Entity type of 'AeccDbAlignmentMinorStationLabeling' found, but not supported. Skipping entityI'm reading a .DWG in as an AutoCAD Civil 3D format file. Am I interpreting this correctly that station labels are not supported by FME?

I would like to convert surface data (like mesh or LandXML) to IFC (using for example the ifcTriangulatedFaceSet class). I think, it has to be quite easy but I have no idea how to write those IFC data.I attache an input example-file (LandXML).Thank you very much for any suggestions.Franco

FME Desktop 2022.2Objective: I want to terminate my workbench if the FeatureJoiner spits out any UnjoinedRight records. So this means, even if there are any Joined records, I want these to also terminate in the flow because there are UnjoinedRight records being caught.  Workflow and Logic:I have the following set up but it is not working. Notice in the screenshot below, I added a counter to the UnjoinedRight port, and a Tester. If the Tester conditions are met, they Pass and I want the Joined record to move along. If the Tester conditions are not met, then they Fail and I don’t want the Joined records to continue and would like the workbench to Terminate.  Why is the Joined record still continuing, if the Tester conditions were not met (Failed). The value of the _count_unjoined is 1, thus, as per the conditions, they are not met, so then it sends it to Failed and to the Terminator, BUT the Joined record keeps going, which I don’t want. I thought the Tester logic would stop this. Eventu

Hello,I have a workbench 2022.2 that writes out data from a join of another feature service to an SDE feature class out to an existing service. I am using an attribute manager, see below, before a date formatter and reprojector. However, when I run the workbench, the writer always gives me a mismatch on attribute sizes error in manual and automatic modes. I have tried to update the attributes to the values listed in the error but it always seems to revert back. I know I am missing something simple but for the life of me I cannot see what.Thank you for your time. Scott

Hi,How can I calculate NDVIRe, using RasterExpressionEvaluator? NDVIRe=Band 8 (NIR)+Band 5 (Red Edge 1) / Band 8 (NIR)−Band 5 (Red Edge 1)​I don´t know to configure the transformer properly… Thank´s 

Hi!Is it possible to backup a PostgreSQL database (or a specific table) using FME?

Hi everyone,I have an SHP file related to some parcels. For each parcel, there is a corresponding folder and contract (with the same name). My goal is to create a workspace based on the ready SHP files (using a simple tester transformation). The SharePointOnlineConnector should then download the corresponding contract from SharePoint and place it in a local directory.My main challenge lies in how to locate each contract. Currently, I’ve set up the SharePointOnlineConnector to create a list from the directory. Then, I use another SharePointOnlineConnector to download the contracts. However, during the second SharePoint transformation, I encounter an error:SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0//sites/[my_share_point_name].sharepoint.com,3a2333c0-9794-425a-9978-a2eb613fc15b,c38a05da-86b2-48bd-a5b5-e80371d96e57/drives/b!nqLU0gc2Y0OJ_TIlc0aqVX_zKy7OiIFPltGPSW8STP_RoqJOec4jSbMoWXb1-7Y7/items/01MI2PLMPJAT7XK24RXZGJDFNW2D7PE4KR: The resource could

I have a number of CustomTransformers which contain some python - this python may or may not include some third parts python dependencies. It’s not only python, they also use regular old FME transformers as well.I’ve been playing around with the package development guide and doing some testing. I can see how to import third party modules for just normal CustomTransformers. I’d really like to be able to use the package manager tools here to help with dependencies, however, it seems like from my experimenting that fme based custom transformers can not benefit from these tools.Does any one know anything or have any comments on this?

Hi,  I have one SCL band from sentinel II and would like to convert in polygon pixels with value 3 and 9. How can I do this using FME? Thank´s

Hi,I want to clip a point cloud with a 3D Object (Box). The 3D Object has z values and should overlap the point clouds. Now when I am using the Clipper, I recognize, that the point cloud is not overlapping the 3D box, because it is not using the z values. How can I proceed in this case, that both have the same elevation and that the clipping is working?Point Cloud on the correct elevation of 280m. 3D Object at the ground (not using its z-CoordinatesThanks in advance

I have address data in CSV format. there are address number ranges, street address from number and street address to number, and sequence code (1 for odd, 2 for even, and 3 for consecutive).I need to expand these ranges into individual addresses based on sequence code and write them in a new CSV.Any guidance for doing this task in FME would be appreciated. Thanks

Hi everyone,I'm working on a project where I need to process multiple IFC files and write the data to a PostgreSQL database using an FME workbench. I've written a Python script to automate this process, which includes getting IFC input from the user and executing the FME workbench. However, I'm encountering problems when passing multiple IFC files to the FME command line.Any ideas? Main Idea:Getting IFC Input from User: The script prompts the user to enter the path to a directory or a single IFC file. Running the FME Workbench: The script constructs and executes the FME command with the provided IFC file paths and other necessary parameters.I am using a PythonCreator at the start of my FME script to catch these arguments and read with FeatureReader. Currently, when I look at the FME log after I run the external Python script, I see that the paths are not parsed as parameters. Main error I see in the log files is the following:2024-06-21 21:52:52|   0.4|  0.0|ERROR |ISO10303-21: Unable

My question is about the following: I want to create Geopackages from about 20 Oracle spatial datasets. Each dataset must be stored in a separate geopackage.For Example: Oracle dataset 1 must become Geopackage 1, Oracle dataset 2 must become Geopackage 2.  The names from the Oracle dataset must also be copied into the Geopackage.In addition, each Geopackage must be zipped.Is there a way to automate this in FME? I was already thinking about the AttributeExposer, but I can't get it to work.Thank you in advance.