FME Form

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

Hi all,I have a set of input street lines with certain attribute (POSTAL CODES), and I would like to create area polygons from unique values of such postal code attribute. Street Lines with postal code attributeI have utilized AreaBuilder for such purposes and this is an example of the output: Inner polygons created by AreaBuilderThis is the params I have for such transformation:What I would like to have as an output is the area covered by all the street lines with unique p

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? 

Hi all,I am using Change Detection to compare 2 geodb_tablesAt the delete ports, the correct number of deleted rows is 2But it is not being cleared in my writer, the result in the output table is still 11Please let me know how to fix this error.For the geodb_point and geodb_line data, the result is completely correct, only geodb_table has an error as I showed above. 

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

Hi,This is a question that is really related to another piece of software (lastools) but it is using a product of FME.Basically in lastools you can colour a point cloud by an aerial image (the same as PointCloudOnRasterComponentSetter). I want to set up a script to do it in lastools because that is faster for this task.Anyway, lastools only accepts one raster (tif) as an input. I have multiple overlapping rasters. The overlapping parts are identical. What I want to do is merge these rasters and chop to the extents of each input point cloud.That is all easy but I’m having a little trouble getting it to work. It seems that lastools doesn’t like the RasterMosaicker transformer. The input (pre merged) rasters work fine, and even the clipped rasters (clipped but not merged). Which I’m taking to mean my writer properties are correct. I can’t see any difference in properties between ones that work and a mosaicked raster. I.e the bands/palettes are all the same b

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  

Hi,I was wondering if you could please provide me with a sample FME script that uses PythonCaller or PythonExecutor transformers.I’m trying to setup FME Form to ensure PythonCaller is working. As well, would greatly appreciate any instructions you could provide to configure FME and Python and ensure that PythonCaller would work.Thanks, Wilfredo

Hi All,Today’s million dollar question: I have created a workflow to process some polygon and table data into a template GDB. The process isn’t too complicated but I think the most consuming transformers in the process are the DataTimeConverter and the FeatureWriter. I have done some tests but assume that processing around 94M of records will takes days. Mainly, writing 94M of records into a gdb template will be a nightmare.Here is a screenshot of the workflow, I have also attached a version of it:How can I improve the performance of the workflow and process around 94M of records in a clever way?Open to suggestions :)Thanks

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 FME lovers,I'm getting blocked when trying to access this website, via POST:https://lastkajen.trafikverket.se/api/Identity/Login Using HttpCaller from FME 2022.2, I have:But, no luck, a http_status_code = '400' is sent. On the other hand, I've had no issues using Postman:  I guess I'm not filling well the HttpCaller settings, right? Thanks!

Hello everyone , I am willing to combine 2 cityGML files that has the same CRS but with different LODsi need this in my studies project and i wonder which transformer shall i use , can someone help I am still new to FME software .I’ll be so thankful to any feedback ! Regards, 

Hello!I created a workbench using FME 2022 and then updated to the FME 2024 version. After the update, I also updated some transformers.Now, I need to revert to FME 2022, but some transformers are incompatible and not visible on the workbench.Is there a possibility to restore those transformers to a previous version to be compatible with FME 2022?Thanks!

I have a workbench that imports a lot of data into PostgreSQL (~90m records across 3 tables, 1 containing spatial data) and we've identified a possible need to vacuum the tables. The data is "cleansed" post-import via a SQLExecutor that deletes data, creates data if necessary. However, we're unable to vacuum analyze (Analyze is fine) the data once that occurs as it appears that the SQLExecutor wraps commands in a Transaction Block - which means we cannot Vacuum. Any ideas on how we can perform vacuum via the SQLExecutor or have another strategy we can utilise? I am unsure whether using the writer's post-write execution of SQL in a parameter is performed before or after the VacuumAnalyze option that FME provides. I've seen some information around setting Autocommit to on/off within the SQLExecutor but this does not work in the newer versions of PostgreSQL.  We are using an Azure managed database

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 

I am using inspection point before and after the CoordinateRounder transformer to notice that only few coordinates are rounded while others are left untouched.  Is it something others have noticed?

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 have an XML file generated by a specific SW, and there is an issue with one element, which content I cannot influence as I would like to. So I decided to try to update it with XMLUpdater, but I am just walking in the circles.The (very simplified) file looks like this:<?xml version="1.0" encoding="UTF-8"?><gdb:Utilities xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:atr="atr"... etc.> <gdb:Data> <gdb:BiogasStations> <bgs:Records> <bgs:Record> ... <atr:IDZone>58KVK-96</atr:IDZone> <atr:IDSpecific>0</atr:IDSPecific> ... </bgs:Record> <bgs:Record> ... <atr:IDZone>58KVK-07</atr:IDZone> <atr:IDSpecific>0</atr:IDSPecific>

The images are successfully uploaded, but the server assigns the incorrect mime type. This causes the images to download, and not display in browser. I have tried setting the 'content_type' manually to 'image/jpeg' - but the server seems to assign the mime type to 'application/octet-stream' every time.  my config is below. am I using the wrong syntax/config? thanks.... Multipart upload is as follows:  

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?

Hi All, I’ve tried to add in a custom coordinate system and it just doesn’t work. I’ve restarted my computer twice and the co ordinate system won’t come up in the csmap reprojector. I would love to use the online webform that has been created, but I am unsure at which username and password is required to log-in. My usual FME doesn’t work. I’ve created a file in the FME folder in documents and edited both coordinate files in the reprojector folder. This is what I have written below:# COORDINATE_SYSTEM_DEF PerthCoastalGrid1994     \\#      PROJ TM                                  \\ #      UNIT METER                               \\#      SOURCE "spatialreference.org"            \\ #      DT_NAME GDA94                            \\#      EL_NAME GRS1980                           \\ #      DESC_NM "Perth Coastal Grid 1994"        \\ #      GROUP AUSNZ                              \\ #      PARM1 11

I have a script that is supposed to run some .bat files base on calling defined SystemCallers. I have 3 System caller as each for DEV, HUB, and PROD environments. and I want to control which to run with User Parameters as belowCan you please let me know how I can control which SystemCaller to run based on user selection (For example: if user select the DEV then only the SystemCaller-DEV)

Hello there, I feel like this should be incredible simple, but I feel like I am banging my head against a wall.  I am trying to update the name value in this JSON, ‘cp2regions’ to ‘new_name’ for example: {  "featureType": {    "name": "cp2regions",    "nativeName": "cp2regions"}}  Using this this workbench;Set up like this : I can’t seem to find a good tutorial/example workbench on how this Transform works. Many Thanks!