FME Form

I stumbled across the following challenge in FME:how to deal with NULL values if you want to perform a calculation for a new attribute. For example, I want to sum up values (could be any other kind of arithmetics).The expected result is fine as long as no NULL Value is involved. FME turns any calculation into a NULL result if any NULL is involved (see documentation).   The question that haunts me is, how to treat those NULL values as 0 in the calculation without changing the value to an actual 0 (as the NullAttributeMapper would). The result I am looking for is the following: If all values are NULL i want the r

I would like to download all shakemap files. I can download one based on event ID but how do I download all of them. I have specified a folder for them to download to but I have tried a few combinations to get all of the files to download however no success. So the 2022p955929 could change and there are many zip files to http://shakinglayer.geonet.org.nz/api/v1/events/2022p955929/latest.zip I have tried this and the $ sign but they don't workhttp://shakinglayer.geonet.org.nz/api/v1/events/*/latest.zip

dear FME,I've been having problems with converting dgn(v8) file format to dgn(v7) file format, and after exploring the forums looking for a solution, I encountered a similar problem with reference number PR#72482 that no solution was posted to it, and I wanted to know if anything has changed regarding the referenced problem, or is it still a low priority for a fix? thanks in advance

So far in searching I've only found instances where the Oracle DB was dumped into file geodatabases via copy and paste. Then another copy and paste into the target DB. Sort of a part two question:Regardless of the method used for the migration is it possible to process deltas from Oracle to Postgres directly?

Hi, I have two lines. One original one, and a generalised version of it.  Is there a way that I can compare the two so I can see if there are any major spatial differences? I want to look for error locations that I need to fix before I smooth again. For example a deviation of over 0.1m between lines Any help would be great Thanks  

Hi all,  I am using FME desktop to publish XMLs out. I'm currently using the XML templater and need to edit one of the attributes that is coming through via a feature reader.  The sub template expression looks like this (redacted some lines due to data):<data> <dataid>{fme:get-attribute("dataid")}</dataid></data> There's several other attributes in the XML but I'm not interested in those.  Basically what I would like to do is trim the value in that attribute as the attribute has the current format ABCD*00000000001. I only require the numbers in the attribute and only want these written to the final XML output.  How do I go about making changes to the XML attributes. I have tried looking at XQueries but not got very far. Many thanks

I am having trouble opening fmear data files on my Samsung A32 cell phone following installation of the FME AR app from the Google Play Store.The Samsung A32 is running Android 12 and “Google Play Services for AR” (ARCore) version 1.35.223110433 dated (16/12/2022) is installed. The version of FME AR that has been installed is V1.4.0 (dated 22/08/2022)I have downloaded the tutorial “Creating FMEAR Datasets from 2D CAD Models" – CreatingFMEARFromCAD.zip and put the fmear files onto my cellphone’s SD card under the documents area.Below is a screen shot of the FMEAR app where it is being run using a white piece of paper for clarity as to what I’m seeing on screen is shown below. I’m not seeing anywhere on screen or in the app settings for where the app is to find the fmear files to open and I would be very grateful if someone could help me and point me in the right direction.

I'm trying to use the AttributeTrimmer to trim forward slashes from the beginning and end of a string (e.g. - /SomeText/) but I can't find the correct escape character. Thought it was a backslash. Who knows what I need to use to trim /SomeText/ to SomeText? (FME Desktop 2020.1.2.1 - build 20624). Thanks, Aaron

For example: If one resource is working on Task A, he wants to add comments/updates on work progress, so that the next resource who will picks up that same task is aware that someone is working on Task A and picks up another Task B to work on. (These notes/ comments should be displayed in ESRI Dashboard)

Hi, I'm trying to do two things. Firstly, trying to add GDA 2020 zone 56 Australian Height Datum (AHD) to las files that currently have no projection. Second, trying to add GDA 2020 zone 56 ellipsoid (GRS 1980) height to las files that currently have no projection. I'm able to reproject each las files using the reprojector functions, but this is for the horizontal coordinate systems not vertical height. Is there a way to add AHD and ellipsoid heights to the las files within FME? Thank you for your time

Hi, I have a large point dataset and line dataset in ArcGIS. For each point A, I need to 1) create point B on the line which is nearest to the point A. Ensure point is snapped to line2) Generate a line between points A and B I have tried using NeighborFinder, with the line set as the base. However this doesn't create an additional point dataset on the line. Any suggestions

Recently I had to move FME to a new Computer where I cannot use the same Windows-User for FME Authoring and Batchs.This way, I had to change my Database-Connections to Public, so that the Batch-user can successfully execute my FME-Batchs.I did the same for my Onedrive Web-Connection (change to Public).Now the Onedrive-Connection works in Workbench directly, but not as a Batch (with my Batch-User "fmebatch") Log:2022-12-13 10:13:29|   0.4|  0.2|ERROR |OneDriveConnector: Invalid connection, make sure your install path for FME is in your system environment variables2022-12-13 10:13:29|   0.4|  0.0|ERROR |Error encountered while calling method `input'2022-12-13 10:13:29|   0.4|  0.0|FATAL |OneDriveConnector_CALLER (PythonFactory): PythonFactory failed to process feature2022-12-13 10:13:29|   0.4|  0.0|WARN  |An error has occurred. Check the logfile above for details2022-12-13 10:13:29|   0.4|  0.0|INFORM|Translati

Hi All,I've been having a lot of issues trying to get code execution on FME server via System Callers. Been through every forum post about this without success. I've attached a workspace that I'm using to create BAT files and run them with System Caller. SystemCaller 1 and 2 will run on desktop, but not on the server.The server log shows:Failed to Execute `"C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\engineresults\\b80d9262-f6b1-4c81-8f97-a505f68c95b2\\TauDEM_Run01.bat"'Failed to Execute `"C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\engineresults\\b80d9262-f6b1-4c81-8f97-a505f68c95b2\\TauDEM_Run01.bat" abc'SystemCaller 3 and 4 will fail on desktop and server. At this point i'd be really keen for a workflow that Bypasses the System Caller. I'm really happy with the BAT file being created, but executing it on the

Is this a known bug? Is the only way to fix this to upgrade FME Server?

We have 14 units of incremental license, but we don't know, how we can use it. Can you tell us if this license requires Flexnet, or should we activate it in another way? Please let me know which solution for this type of license would be appropriate?

Can someone please suggest something to  improve the performance?

FYI - I'm fairly new to FME and would like to start using it much more in our workflows, any help is appreciated. I'm converting a model from Revit to FBX. Where I am transforming the coordinates to a local ENU CS prior to export. I have created a transformation matrix using the Python Caller, where I intend to use the generated coefficients in a 3DAffiner. Manually adding the coefficients into the 3DAffiner works well:Here I simply printed the values of a1-c4 with the first run of the workspace, then pasted these values into the 3DAffiner to produce the FBX file. What I want to do is pass the a1-c4 attribute values from the PythonCaller into the 3DAffiner, as below:Although I recieve an er

I ran into some quirkyness with lined custom transformers today\\Normally, when one has a workspace with a linked custom transformer, and you change the stuff between the input and output ports of that transformer, the next time you run this workspace uses the new functionality. That is when you save the transformer and don't make a new version.The parameters of the linked transformer are not changed. Obviously that goes for the published parameters, you set in the workspace through dropdown menu's etc. on the linked custom transformer, but it also seems to go for the private parameters of the linked transformer.It looks like they are stored in the workspace as wel in some sort of way. When you have changed these during the rework on the Linked transformer, still the old private parameters seem to be used when running the workspace!In my case the private parameters were python-scripted parameters in the linked transformer. I changed the python-scr

Hi, Using a standard browser there is no problem using Mapillary API and navigating to: https://www.mapillary.com/connect?client_id=XXXAfter submitting my credentials there is a redirect that gives a code in the url: https://localhost/?code=XXX Using the httpcaller I get a annoying problem that I only get a http status code 200 and a response body saying that I need to use different browser. I am using a web connection that would deal with authentication. Any ideas? The documentation is here:https://www.mapillary.co

Hi I was trying to use ArcGISONLINE Connector transformer to connect my services available within this account and the admin account also.. I was trying to login , after providing the username and password , Fme is reverting back to login page again  May i know , what might be the error

In the new, fantastic, InlineQuerier (2023 beta), a geometry column can be selected. Is there a way to call directly the geometry of the feature without geometryextractor? On the same topic, is there a way to define the ouptput geometry without using an ST_asText followed by a GeometryReplacer?

Hello,  With help from this community I was able to round the x,y,z coordinates of a pointcloud (see->Rounding IFMEPointCloud XYZ components) and it seems to work when I click on individual points they have 3 digital numbers (=precision). However, when I write them with the Pointcloudxyz writer to a .xyz file the precision is not correct. This topic has been discussed here: https://community.safe.com/s/bridea/a0r4Q00000HbrBDQAZ/point-cloud-writer-support-precision-control. Is there already a solution in place ?  I also tried the pointcloudtopointcoercer-> coordinate extractor -> csv writer but the first transformer is already taking a long time to run so it would not be an efficient solution. Thank you!

On the VM there is a C drive with 80 GB on the C drive and 80 GB on the D drive. Wanting to ensure we don't run into any issues.

I use FME 2019.1.3.1 with ArcGIS Desktop 10.8.1 (also have Background Geoprocessing Tools installed) and I have encountered a problem when reading a specific table in an ArcGIS Geodatabase. The Geodatabase is stored in a MS SQL Server database. This have worked well for a long time but for the last days, I got this error:2021-05-06 11:20:22|   1.6|  0.0|ERROR |Column 34 is 2021-05-06 11:20:22|   1.6|  0.0|ERROR |Error while performing SE_stream_query. Specified where clause is '"Column1"=28310'.:SDE_ERROR_CODE(-66) Invalid parameter value passed to function2021-05-06 11:20:23|   1.6|  0.0|ERROR |A fatal error has occurred. Check the logfile above for details2021-05-06 11:20:23|   1.6|  0.0|ERROR |2021-05-06 11:20:23|   1.6|  0.0|ERROR |A fatal error has occurred. Check the logfile above for detailsNothing has changed in the workspace since last time it runs successfully so I guess that there is something in the database. I can r

Hello, I have the following date string(s):...which I need to convert to datetime objects. They appear to be 'iso datetime with offset', however I continually get invalid format with auto detect or manual choosing format. I have tinkered with several other input formats to no avial.  Any ideas?  Thank you, TylerFME Workbench 2022.1