FME Form

I am struggling to read two geometry columns from this database. If I set Handle Multiple Spatial Columns to "No", it only gives me one of the two columns. If I set it to "Yes", then I get the above error. What does it mean to have a "Custom SQL SELECT statement"? Mine is nothing fancy: select building_id, floor_id, space_id, agency_code, space_type, space_category,usable_sq_ft, obj.objgeom, SDO_UTIL.interior_point (OBJ.objgeom) from esm.esmobject obj join esm.att_space ats on obj.IDOBJECT = ats.IDOBJECT where building_id = 'BD0303' and floor_id = '01' It was also difficult to retrieve data tables. I had to type in each one. Luckily there were only two. If I let FME search for tables, it errors: My connection seems fine. I am able to access all tables and do more complicated queries in SQL Developer. Any info is appreciated. Thanks, Loren

I've created a workspace server app which allows the user to select a projection from the list of FME coordinate systems and reproject their data. The desktop workbench has access to our FME server (e.g. \\\\A-FME\\FME\\CoordinateSystems) and is able to choose from the list of custom coordinate systems created by our survey department, but the server app does not list the custom coords. I've manually copied the custom files to the server (/a-fme/fmeserver/#/resources/browse/FME_SHAREDRESOURCE_ENGINE/CoordinateSystems?name=Engine) but it still doesn't list any of the coords. I've followed the instructions as stated here. Any ideas or suggestions will be much appreciated.

I am using a change detector before uploading anything to portal. I am able to use Inserted and Deleted without any errors. However, when I try to run anything from the Updated side it sends back the Error Code: "Operation rolled back." Any ideas as to why this might be happening

Hello everyone, This is the FME news for 19th January, 2022. Favourite Transformers Poll Thank you to everyone who took part in my "Favourite Transformers" poll over the last couple of days. Here's the top-ten list of favourites: FeatureReader TestFilter AttributeManager FeatureWriter HTTPCaller AttributeCreator FeatureJoiner Tester FeatureMerger SpatialFilter So in my not-very-scientific method, the FeatureReader is the FME Community's favourite transformer ever! Some statistics: There were 65 different transformers mentioned. There were 4 FME Hub transformers on the list. The highest Hub transformer was the NoFeatureTester (22nd). The least-loved favourite was the JSONFragmenter. Of the most-used transformers, 6 of the top 20 were not anyone's favourite! Inspector, AttributeRemover, AttributeRenamer, StringReplacer, AttributeFilter, Counter I'm not sure why no-one likes the Counter! But none of my personal favourites made your top-ten, so I'm obviously no judge. My highest-ranked fav

Hello, I'd like to "remember" an attribute and use it to populate an attribute of another feature in the same execution. I thought AttributeKepper would do the job (because of the name haha), but the value of the attribute is empty, except in the first pass through the breakpoint.

As the question suggests I cant seem to find instructions on how to convert LAS scans to GLTF format and retain the color_red, color_green, color_blue values. I've expereince with successful conversion of CAD models to GLTF but the resulting LAStoGLTF refuses to play ball. I've tried various combinations of reading LAS > use PointCloudPropertyExtractor to expose color data and even forced the issue with PointCloudLASClassColorSetter but all to no avail. The resulting GLB is created using default white colors leaving me with non-viewable model. Is this translation just too new a possibility for GLTF writer or am I missing something fundamental here (most probably I hope!). Thanks for any advice. Source LAS from Drone: Resulting GLB model:

module skp/skp is unavailable for use with this fme edition

Hi everyone, I have a series of regularly produced Excel files, each containing a number of sheets. The number and name of the sheets in each file isn't fixed. I can read data from all the sheets no problem by keeping the reader parameters blank - but annoyingly for these files the header starts on row 2 and in some cases junk is written into row 1. As such, FME picks up attribute names from row 1, so for one sheet the attribute for column B might end up named"995" and for the next sheet it might be "376", so I end up with a lot of attributes where there should be one - ideally just called "B". Is there any way to force the Excel reader to always use column letter as the attribute name regardless of how many sheets are in a file and what they are called?

Hi all, I have an issue when I'm running my workspace. It throws a Python error relating to what I'm guessing is something with the python version: File "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\lib\\site.py", line 177 file=sys.stderr) ^ SyntaxError: invalid syntax Warning: not all FMESessions that were created were destroyed before shutdown. This may cause instability Warning: not all Stashed Objects that were registered were dropped before shutdown. This may cause instability I'm using Data Interoperability extension to ArcGIS version 2020.2 and have ArcGIS Pro 2.7.2, since I need to be able to write to an SDE and we dont have that license to our regular FME version. But I do have a regular installation of FME, so I'm wondering if the issue could be related to different python versions between the two? I do not have any individual python software installed - everything is installed via either FME or ArcGIS. Another colleague has experienced the exact same err

Hi There, I've got a question that seems to appear a fair bit within the forum but I have so far been unable to find a methodology that works for my case. I'm attempting to identify water mains within a water distribution network that have accidentally been duplicated, incorrectly split and not removed, or more generally are errors that went unnoticed. What I think it boils down to is isolating where lines overlap exactly (Scenario B of attach image), where mains have been split and a segment wasn't retired/removed when (Scenario A), or where a segment was completely replaced the old segment wasn't removed or retired (Scenario C). *Orange segments below are the erroroneous segments I'm attempting to isolate. From the forum posts I've read here there's a lot of talk of using the LineOnLineOverlayer which I have tried using. However, I'm don't want to report on valid intersects where mains are connected to each other. I've have some difficulty trying to weed these false positives out of

https://www.railml.org/index.php/en/

I can't create the exact footprint through RasterExtentsCoercer, even i have set the Extents Type as 'Data Extents'. The transformer only allow me to generate a rectangle that covers the entire extents. My aerial imagery is in RGBA, possible the alpha band caused this issue. Is there a way to create the exact footprint? PS: i have attached a sample image. Thanks and Regards, Jian

Hi I have a LAS (LIAR) file and I want to convert it to GLTF. FME can help me with the task? Does the trial version work for me?

Hello everyone, So I would like to generate a HTML report by using "HTML Report Generator". For the final product, I would like to generate the report with the "current time" on the HTML page. This is what I write in the text editor: KE Indoor run on @DateTimeFormat(@DateTimeNow(local),ISO) The output is: KE Indoor run on 2022-01-18T16:58:52.1754106+08:00 However, this is what I want for the result: KE Indoor run on 2022-01-18 16:58:52 May I ask how can I fix the problem? Thank you in advance.

How to back-up FME Server content. I can find articles on "configuration" backup - but how about content?

Hello, I have an issue with generalising contours inside a tiling system. All contours need to match at tile edges, hence a surface tolerance of 0 is required. When this happens, vertices are added in what seems to be every 0.1m. Therefore i need to generalise. The standard generalizer causes overlaps between different elevations, so the only option is sherbendgeneraliser but it takes an age with the amount of vertices. I have tried adding a generaliser with 0.1 tolerance before the sherbend generaliser but this also causes overlaps. I want vertices roughly every 5m or so in the output. Question: How do i fix these generalised overlaps? is there a quicker way to speed up sherbendgeneraliser?

I consider to replace my Http callers by the Asynch Http caller. I am curious whether other users have experience with this Asynch HTTP Caller. This is related to this idea which is worked out in a transformer. Because the test suite states 'failed', I doubt whether I can use this transformer safely. Anyone experience with this transformer?

I need to truncate the existing table and append data. I have two tables one from versioned sde and the second table is in FGDB. I need to delete rows from the table in sde and append data from FGDB. I have to do field mapping after appending data from FGDB. I am not sure what would be the workaround to accomplish this task. Please suggest any workaround.

Hi, I'm trying to figure out how to write nested attribute structure to a GEOJSON file. For that reason I've prepared some sample data for a Quick Translation to see how FME would set up the writer feature type properly. But surprisingly, my nested structure is lost during that translation! So in fact my test endet up in two questions instead of delivering a solution: 1.) Why does the Quick Translation fail 2.) How do I set up the GEOJSON Writer properly to build the desired nested structure. 2.1) In case JSONTemplater is the solution to this task, how do I have to set it up properly? I spent some time playing around but never came up with some suiteable result, especially for proper GEOJSON (geometry handling, type defintion and so on). Find attached my sample file. Looking forward to any suggestions (and maybe solutions 😁 )

Hi, I am having problems with converting a TIN surface to a raster with height information. The input data is a LandXML which contains a surface of type IFMECompositeSurface. Right now I feed the surface into the RasterDEM generator with the following settings: The coordinate system is EPSG:28992 so the surface tolerance is set to 1cm, however the results are quite jagged: To give you a sense of scale, the image above is for an area of around 1300 meters wide so the the jagged points seen above are sometimes a 100 meters wide. To check my results I decided to convert the result to a pointcloud so I could take a look and compare it with the original surface in the 3D view in FME Inspector. In the image below you can see that the pointcloud that was created from the raster actually dives beneath the original surface: Does anybody have an idea what could cause these problems? I a doubting whether the RasterDEMGenerator is the right transformer for this job. I already have a workaround whe

Hello! I would like to filter strings which have two or more capital letters consecutively. I suppose it can be done with regular expressions but still didn't find the right expression...

Hi, I am getting the following error from FME Server: The custom transformer 'DateTime_Standard' referenced by this workspace was found, but could not be loaded. The custom transformer was created with a newer version of FME Workbench I have a workbench uploaded to FME server which contains 3 custom transformers. Each custom transformer presents the same error when I run the workbench. Both the workbench and the 3 custom transformers are in the same repository when the workbench is ran. The FME desktop version for both the workbench and all 3 custom transformers is: FME(R) 2021.1.2.0 (20210903 - Build 21627 - WIN64) The FME server build is: FME Server 2021.1.1 Build 21619 - win64 I assume to fix the error, I need to match FME desktops build to FME server so I have attempted to source FME desktop Build 21619. However that is not available on the safe software download page: https://www.safe.com/support/downloads/#past-versions I would prefer to avoid upgrading FME Server at this stage b

The application itself is closed. And when I restart the application, a new fmeworkbench.exe process is started. This happens when I haven't done anything in the application yet. Didn't run a workspace or created one. I also tested it with the simplest workspace I could think of: a Creator with an Inspector. In that case the process fmedatainspector.exe is started. That process also never closes. I use FME Desktop version 2021.1 as part of ArcGIS Pro on a Windows 2016 VMWare machine. Does anyone have an idea what might cause this behavior?

Hi there, I am looking for a transformer or a solution that allows me to check if any attribute of a feature has a specific value (e.g. string "remove"). Only then I want to remove the attribute. Renaming would work as well. Thanks for your help.

I'm trying to calculate the percentage of nodata cells within a raster by using the point cloud combiner + point cloud splitter in fme to extract the value of cells with data vs cells with nodata, and get a ratio. It's clearly not the right approach as it is taking forever. Is there a better way to do this? Usually it would be fore raster tiles with 1,000,000 cells. Counting the nbr of nodata cells in each file basically