FME Form

Hi all, Is there a way of exposing the transformer name as an attribute value? I'm trying to create a generic Emailer in which all the transformer "rejected" ports feed into, allowing easy identification as to where the error occurred in the workspace. Currently I'm creating a separate Emailer and writing the transformer name in by hand for each point of failure. I'm running FME Desktop 2019.2 :)ThanksAlex

I have a scan of an old map, that I want to geo-rectify so that it sits neatly under a vector dataset of property boundaries.I am following the example at this link “Adding GCPs to a scanned topographic map”RasterGCPSetter (safe.com)I have picked three GCPsI have a JPEG Reader for the scanned mapI use a RasterGCPSetter to set the three GCPsI then use the RasterGCPApplier to apply the GCPs (I downloaded GCPApplier from the hub)At this point it all looks great. The Inspector shows that the scanned map has rotated about 10-15 degrees. I am only using three GCPs, so this is an expected result.I then use a GeoTIFF WriterBut the GeoTIFF output has no rotation :-(What am I doing wrong? How do I write out a raster that is rectified?

Hi all,I have geometries (roofs) and I will use the transformer donutbuilder for further processing. The incoming polygons are all planar. The transformer “DonutBuilder” stopped with this rejection code:INVALID_GEOMETRY_DEGENERATEI was hoping to solve the problem with the “Geometry Validator” (fix degenerate or corrupt geometries). But all geometries were ok according to the validator.How can I avoid this error?Does anyone have an idea how I can solve this?

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 ?       

I have a process that includes the GeometryValidator transformer with a check on for self-intersections in 2D. The validation rightly captures those overlapping or crossing segments, but it also incorrectly catches vertices that snap to another segment. These kinds of geometries can be correct, as in the case of a trail that has a T-intersection and loops back onto itself.I’ve not found a mechanism to allow these kinds of errors to be considered valid. Does anyone have a work-around?

Hi,I have a layer of hydrographic network lines. A watercourse is composed of one or more segments, which share an ID. I have two attributes, abscissa_start and abcissa_end, which correspond to the length of the segment in a sequence. For example, in the attached image, I have a watercourse, where the first segment measures 50m, so start_abscissa is 0, and end_abscissa is 50, the second segment measures 80m, so start_abscissa must be 50, and end_abscissa must be 130, and so on. I need to find a way to be able to calculate the two fields abcissa_start and abcissa_end in FME automatically.The segments are always digitised from the origin to the mouth, and the calculation must be done taking into account as the first segment the one at the mouth. They already have a lenght field. Thanks,   

Hello, I want to cut a layer (buffer zone) according to another layer (urban zones), so I set up the transformers clipper but the cutting does not take place and the entities that emerge are the same as at the input (cf. attachment) :Before Clipper :After Clipper : Would you have an idea to make this cutting work so that my buffer zone does not exceed (that it must therefore be cu

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?