FME Form

Hi, I have a point cloud of a rail line. I also have a guideline of the position of each rail (within +/- 0.1m) What I want to do is fit a template to the point cloud at increments of 0.5m along the guideline. This is to extract the location of the running edge. Does anyone know how to do this? I currently do this in Topodot, but that is a semi-manual process which is time consuming. I'd like to automate it

I have a Group in my company ArcGIS Online (AGOL) that holds multiple, shared, hosted feature layers, each based on a feature service and having multiple layers both spatial and non-spatial.  As such, each hosted feature layer is a Feature Layer Collection in Esri-speak.  Many of the non-spatial layers in a hosted feature layer are attachment tables, so others are relationship tables.  I need to read the schemas (as schema features) of every layer in every hosted feature layer into one big stream.  Alternatively, I could read all the features and shove them through a SchemaScanner.  In either case, I need FME entities, and I need to be able to loop through all the hosted feature layers.  Because FME FeatureReaders for AGOL Feature Services can process only one feature service at a time, I can't process all the hosted feature layers in the same workspace run.  I can think of a way to use multiple worksapces and WorkspaceRunner s to do the required looping, but that is kludgy and comp

I have 3D polylines that I’d like to split at specific elevations (3,000’, 5,000’, 7,000’, and 10,000). Any ideas are welcome!

After upgrading to FME desktop 2022.2.3.0 (20230131 - Build 22789 - WIN64) I cannot read any of the sde tables on postgres (10) backend. The FME desktop 2021.2.3.0 (20220131 - Build 21812 - WIN64) version still works. I've played with the Esri Argis compatibility workspace parameter without any succes. The version of Arcmap is 10.6.1Here is a relevant part of the logging:Worker 8020 > Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220952'. The error message from ArcObjects is: {The Product License has not been initialized.}Worker 8020 > Please ensure the connection parameters are correct (server=`localhost', instance=`sde:postgresql:localhost,5435', user=`sde', password=`***', database=`lais', version=`sde.DEFAULT')Worker 8020 > It could have failed t

Since the FME desktop workbench can be run through windows schedular on the VM. Hence what can be the excluding factor for the FME server? Appreciate your views on the same. Thanks

I noticed that when I went to add the Geocoder transformer to a workbench there no longer was a transformer called Geocoder. I am using it to connect to an ArcGIS Server Rest geocoding service. I saw a Geocoder ArcGIS Online transformer and other system specific Geocoder but not the original "Geocoder" transformer.

Dear community, I would like to create a cityGML file from a db, which structure I don´t know. I have found a table, where building parts like in the picture are saved as polygonz, but I can´t aggregate them into one solid. The _geometry field I got from an GeometryExtractor, because there was no possibility to see the geometry attribute in the FeatureReader. Is it possible to aggregate those faces into one solid?  

Mdenoise is an denoising algorithm for topographic use that preserves sharp edges. It's part of GDAL, so I was wondering if it maybe was integrated in FME, but under another name? Or is there an transformer that works in a similar way?  Some background to mdenoise:https://personalpages.manchester.ac.uk/staff/neil.mitchell/mdenoise/ 

How to extract photo attachments from an fgdb esri file?

I am trying to access a JSON API by using a HTTPCaller and I am struggling with passing an array object as a Query String Parameter. The documentation for the 'extra' key I am trying to access looks like this. The code sample they give where you can see the 'extra' parameter as an array is here:{ "key": "xxxxx-xxxxx-xxxxx-xxxxx", "query": "High Street", "country": "gbr", "id": "town=Maidenhead", "extra": { "exclude_areas": [ "gbr_channel_islands", "gbr_northern_ireland", "usa_non_contiguous" ], "exclude_pobox": true, "best_match_only": true, "no_groupings"

I have a workspace with a sql connection which can be ran with "run workspace" tool on FME server. However when I published it as a FME Server App (No authentication required) and ran the app resulted in this error. From completed jobs in FME Server UI, the two runs have the same user. And the user has full access to and is the owner of the connection. What could be the issue?

I would like to POST a zip file to a workspace in FME Server and read the shapefiles from it. The problem is that the shapefiles could be multiple directories deep. In workbench, I can use [**\\*.shp] as indicated here, but this is not retained on the FeatureReader dataset path when the zipfile is posted to the data streaming service in FME Server. Is there a way to achieve this?

I am currently working on a workflow that downloads a file from ArcGIS Online and I am then uploading the attachment to Cityworks via the API. The file is downloaded with a general name and I'd like to change the name of the file before passing to the API. I have done some digging on this forum and I am not seeing a way to dynamically change the file name based on other attributes in the middle of a workflow. Would I have to build a custom transformer to do this? Any ideas or examples appreciated, thanks!

Hi, I have a DFX file and would like to convert to an OBJ file, however it does not convert cleanly. Has anyone come across this and converted correctly. Many thanks

Using HTTP caller, how can I automatically fill-in the upload body? I am able to post the any test I paste in the upload body field, but I would like to fill in automatically the text of the upload body, with the output of an attribute manager.

I'm parsing data from an SFTP call to get the file name. I'm returning _list values that have all the FTP properties of each file. I use an AttributeCreator get the length of this string as an attribute (ListStringLength=69) --- @StringLength(@Value(_list))-rwxrwxrwx  1 user   278361 date 00137 0001539147T ABCDEFG1234567.jpg I'm also using the AttributeCreator to get the starting position of the file name based on the prefix as another attribute (StartingPosition=33) --- @FindString(@Value(_list),"00137 0001539147T")278361 Mar 21 09:49 00137 0001539147T ABCDEFG1234567.jpg From here, I tried to simply subtract. But that didn't work.@Value(ListStringLength)-@Value(StartingPosition) = a string value 69-33 So then I added an SQLExecuter and did the math in SQL and output the FileNameLength.select @Value(ListStringLength)-@Value(StartingPosition) a

Hello, I have a dataset in excel that I would like to simplify the data into a newly created status field. For example all records that are 1000 will be status A, all records that are 2000 will be status B, all records that are 3000 will be status C. I will then import the data into GIS to symbolize based on status. I am creating testers for each status type and then joining it all back together. I was wondering if there was a single transformer that I could put in all my criteria and have the status field updated. I think this should be fairly simple but not finding the right transformer. Thank you

Hi I have the intersection points in point feature. I want to have attribute field as the street address as 2 St/3 Ave. The street network has line features. is it possible to get this happened to point feature at intersection? thanks in advance.

I've looked all afternoon for the answer to this probably simple task. I am working with a feature class in a gdb. The feature class has a unique_id field that may may be populated with duplicate numbers or be null. I need to find all the dup ids or nulls, calculate them incrementally based on the last highest unique id while leaving the other records alone. I was able to put something together that seems to work when if I set the writer to overwrite existing gdb. Is there a way to do all of this and just update the existing gdb? I don't want to loose the other feature classes and tables in the gdb. I'm pretty new to FME!

I have a workspace which takes a dgn file(A) and matches it to another dgn file (B). dgn file (A) contains little changes everythime I have to run the workspace. These changes need to be braught to the second dgn file (B), and this workspace automatically (often succesfully) does that.  However, if I have run this workspace once, and then changed something to the first dgn (A), the reader will not automatically load the new data in dgn file (A).  I dont know how to fix this, obviously I dont want to delete the reader and put a new one back everytime a small change is made.  Is there anyway to make the reader completely reload the data everytime I run the workspace?

We used to have the following 'Emailer' Transformer in our FME Desktop /Server 2021.2.2 and it worked fine: However after upgraded to 2022.2.3, we experienced the following Python Exception error for Emailer:Any idea how to fix that? Thanks.

I have several Feature Classes in a FileGDB and would like to convert these into a Geopackage. Therefore I would like to remove/not read the different schema-names / Schema-prefixes.A Feature Class "WAS_LABEL/WAST_TEXT" would be read as "WAST_TEXT" without the schema-name/prefix.Is there an easy way to achieve that? The FeautureClass-Names in the geopackage need to be "flat" without schemanames...

Here is an example: I want to remove the small dots inside that circle. Thank you.

I am doing a simple SQL query that I created MS Sql Server. I pasted it into the SQL Creator and ran it, and it was successful. I then go to expose the attributes by populating them from the SQL Query, and nothing shows up. Below is my query. Can someone please tell me how to fix this. I have tried using the Delimiter statement at the top, but that doesn't work either. Here is the query: With AcscerRecdQry as (Select lpm.permit_no as PermitNumber, lpm.permit_id as PermitID, lpm.version as PermitVersion, gc.code_desc as PermitStatus, soclpm.soc_id as ScheduleID, soclpm.schedule_name as ScheduleName, (soclpm.ACSCERYearDue - 1) as ACSCERRptPeriod, soclpm.ACSCERYearDue, Case When (IsNull(soclpm.received_dttm,'') = '') Then 'No' Else 'Yes' End as ACSCERRecd, 'Permit Schedule Does Not Exist' as QA_

At our organization we have an extensive FME server installation with a lot of machines for the engines and cores. We have Apache tomcat 9.0.50 installed, but have a lot of issues with this version of tomcat in combination with fme server 2021.1. Our decision was to install a newer version, 9.0.68., recommended for fme server 2022.2. We succeeded to upgrade tomcat without deinstalling FME server. However we are interested if we can expect issues.with this version in the future. If you need more information please let me know.