Data

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? 

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

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?

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,  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  I have a workbench that I use for making ortho photo’s. I’m using this same workbench for over 4years now and since last week I’m getting always the same error. It’s says: jpeg2000 writer: Could not perform compression. I don’t know how to solve this, as it has worked always before… I installed the lastest FME form yesterday. I get the same error.   I don’t know for sure, but one time I looked at the edit header option under tools to solve something, but I don’t think I changed anything. Could that result in this error? 

I have a lot of SDE connection files that I would like to create named connections for in FME Form 2024.I would like if possible to automate this by creating an xml file to import.  I can use the Directory and File Pathnames Reader to get the path and the name for each sde connection file, so I am thinking I could use FME Form  to  create a xml file with all the entries I need and import that into the fme_userconnection.data filer whiteout having to do this manually one by one.I do not need to specify anything special in the connections,  version, credentials etc. can all be defaulted, so the 2 values I need are the path and name, which I can get.  I tried making a single conn and then exporting to see the xml format, but al the values are encrypted. Is there any kind of xml template or example xml I could use to see how to do this ?       

What happened to Revit appearances in 24.1? Or did I miss some new setting? 2023.224.1 

Hi All, First of all, thank you for taking your time to read this post.FME Desktop 2022.2Objective: Using the Feature Reader I’m trying to dynamically have a user input an existing sde table name (so the user is prompted to insert the table name that already exists), then I have a reprojector followed by the FeatureWriter to Drop and Create the table in a new projection. The table to be dropped an create will be the same one inserted by the user. Hence, this table already exists. Error: ‘Feature Type Definition {feature here} was requested, but not defined’. I checked another similar post, but I still can’t get my workbench to work.  I have a Feature Reader set as follows: When I run the workbench, the FeatureReader do

Hi All, First of all, tanks for reading my post. FME Desktop 2022.2Objective: Using the Feature Reader I’m trying to dynamically have a user input an existing sde table name (so the user is prompted to insert the table name that already exists), then I have a reprojector followed by the FeatureWriter to Drop and Create the table in a new projection. The table to be dropped an create will be the same one inserted by the user. Hence, this table already exists. Error: ‘Feature Type Definition {feature here} was requested, but not defined’. I checked another similar post, but I still can’t get my workbench to work.  I have a Feature Reader set as follows: When I run the workbench, the FeatureReader does not show the

I have a feature class with cycling and walking routes (with ID and Name) and a feature class with the starting points of the (circular) routes. I want to write all the routes in the feature class to separate gpx-files. Each gpx-file should have the name of the route in its filename.I tried with the ‘fanout’ option in the writer, but the resulting files are no gpx-files and are very small (1kB), so without content I guess. Any advise? 

I try to read a dgn file using FME and have some special results. The data is in epsg:28992 (Netherlands RD new) which is in meters. But it reads lines with the following coordinates:189492.31655848716, 348069.1188694655, 28.224907750701906 1.7976931348623158e+304, 1.7976931348623158e+304, 1.7976931348623158e+304 189492.31740355192, 348069.1195426307, 28.22490763540268 189492.31655848716, 348069.1188694655, 28.22490775070190The second coordinate seems to be very far off and not correct. I am able to delete the points from the lines which are that far off, but I wonder if anyone knows this as a bug, a feature or a setting?Thanks for looking,Niels

When I try to connect to a MySQL DB I get an error message related to the encoding format of the server. As I’m not an admin I can’t change the encoding of the Server. How can I solve this issue in FME Desktop 2022.2.---------------------------Fetching Feature Types Error---------------------------<b>Failed to retrieve feature types.</b><p>MySQL: the MySQL server does not support the utf8 encoding. Aborting translation---------------------------Close   --------------------------- Thanks for helping me out. Kind regards,Guy  

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 t

Hi there.I was wondering which type of parameter is used when enableing vaccum analyze tabel in a Postgis writer feature type (https://www.postgresql.org/docs/current/sql-vacuum.html) . Is it a FULL vacuum? all I see in the logfile is: Vacuuming and analyzing table ....Any tips on how to query that information from the database?Thanks in advance. Itay 

Hi,It’s been several times I can’t achive to do this, but I’m sure there is a way.I have the following table :And I want to get the following result : The thing is : I don’t know in advance what will be the name of IndA and IndB (and there can be more than 2 values, so more than 2 columns in the result table). I achieved to get my result table with an inlineQuerier, but I need to enter a fixed value for the Indicateur values.select "Zone", max(CASE WHEN "Indicateur"='IndA' THEN Valeur ELSE 0 END) as 'IndA', max(CASE WHEN "Indicateur"='IndB' THEN Valeur ELSE 0 END) as 'IndB'from "Input"GROUP BY "Zone" Any idea ?

I am currently trying to migrate my Geometric Network (GN) system data to the Utility Network (UN) and would like to include attachments in the FME workbench. Currently, I have a workbench that successfully migrates the points, lines and polygons (Assets, domains, and attributes) to target UN features but I am not sure how to handle attachments. Should attachments be handled in a separate bench?The attachments would be mapped from the source tables to the new UN attachment tables. For example, hydrant attachment table would be migrated to Device attachment tableCan attachments be migrated using FME? What type of transformers and workflow needs to be utilized to move this type of data?

I have set up a dynamic workbech with the follwoing setup. Its from SQL Server to geopackage. It has been working fine daily for months until today when i noticed one record was missing geometry (geometry was null in the target geopackage databse). Why does this single record fail to write? Checking the geometry types in the source database (STGeometryType ( ) ) for the feature type they areGeometryCollection LineStringI dont understand why it is failing when I am using a dynamic workflow in the first place?Where should i start to look for errors, is there anything i can do? I have been poking around for a long time to try to make sense of it. One thing i have found is if i look at the feature with the Feature information window there is a “fme_geometry” attribute with a value of fme_aggregate. The attribute fme_type is of fme_collection.The failing feature is the only one whch is a fme_aggregate, so i am

I'm reading in ECW file to get the Filename, X Y Min, X Y Max. Write to excel, I do not want the image/raster in my excel file.How do I get rid of the image?

I have an ETL workbench and would like to create a text file where I can write some information while running the workbench. The information I would like to write includes:The path to individual readers The feature counts of each reader The coordinate system of the each reader How many objects have been written to the databaseI don't want to use logging per se because it writes basically all information.What alternatives do I have? Can I only do it with python`?