FME Form

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

I want to extract specific lines from a log file, based on an regex. However, instead of getting a whole line as match returned, or even better a list of matches, I am getting <null> returned. What I want from the log file are all the warnings. I used an AttributManager and set the Attribute Value for the new attribute to @SubstringRegularExpression(@Value(_log_attr),^.*\|WARN\s{2}\|.*$,0,0,5)The last parameter is already misleading, since I usually do not have an idea of how many warnings there might be in an arbitrary log file, but for the sake of my test it would work.I would expect that the first match (out of 5) is returned. Ideally, a startIdx of -1 would give me the last of the five matches, but that doesn't work either. For the fun of it I was testing the same expression within a StringSearcher and here, there is a match. However, the attribute containing the matched result, who is supposed to return "

Hello, I was using a HTTP caller with a web connection fine on FME Desktop and Server - This was running fine on a daily schedule. I then realized that the HTTP caller needed to run in a loop so I got it working on both Desktop and server fine. The issue is, the workbench will only work for one day on the server, and then it returns a '401 Unauthorized' the next day. I find that if I re-publish the web connection, the workbench runs fine......until the next day. Does anyone know if this is a glitch or if there is some work around? The workbench was previously running fine until I added the loop and there hasn't been any changes to web connection each time I publish Any help is welcome!  Many thanks, Sam

I have a lot of LAZ files and generate a couple of polylines in ArcGIS. for these polylines I need to extract the points classified as 'ground' from the LAZ files.What transformer allows me to do that, and how to deal with polylines intersecting with several LAZ files?

Hi.I am wanting to utilize a webhook to kick off a process and have set up a sample site based on Send Source Data to FME Server with HTTP POST (safe.com).This example uses a text file to kick off the process but I am wanting to use the webhook URL with a parameter (key field). Is this possible? If so, what would I use as the initiator of the workspace and how would I pull in the parameter?  Any help would be most welcome! 

 I have attached an excel spreedsheet. I would like to merge and convert the table in sheet 1 ("Year_2035') and sheet 2 ('Year_2050') into a table structure like that one in 'RequiredFormat' sheet. I have never transformed such a complex data structure in FME before. Can anyone kindly help with good suggestions?

Hello everyone,  I am trying to round the x, y and z components of Pointclouds to a precision of 3. I have tried the coordinaterounder but as is already stated in the Coordinaterounder documentation (http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/coordinaterounder.htm) the behaviour of this transformer can be erratic. For some points I get far more then 3 decimal places, while for others it is rounded to an integer. I have also tried the Pointcloudexpressionevaluator as in this solution (https://community.safe.com/s/question/0D54Q00009HJ87MSAT/rounding-ifmepointcloud-xyz-components-with-pythoncaller) but this also does not seem to work for my data.

I'm trying to create an xml document where part of the information in the comment is coming from an attribute. However in the XMLTemplater everything within a comment is output untouched, including {fme:get-attribute("_comment")}. Thoughts on how to work around this?Attached is a sample workspace demonstrating the issue. Build 2022.0 If I create an attribute in advance: <!-- comment should resolve attribute @Value(_creation_instance)--> and use {fme:get-attribute("_comment")},then the braces are replaced with &ly; and >.If I use {fme:get-xml-attribute("_comment")},there are some xml parsing warnings:XMLTemplater (XMLTemplaterFactory): The following error occurred near line 1, column 51 of the query:XMLTemplater (XMLTemplaterFactory): invalid content passed to fn:parse-xml(): loader parsing error: Extra content at the end of the documentand the res

Hi Folks, I'm setting up a HTML web connection to an API using OAuth2, and one of the parameters that I must specify is grant_type=client_credentials. However, in the 'Retrieve Token Parameters' dialog in the preview window, I see that grant_type=authorization_code. Is there any way to change this? If I enter it in the URL section, will it overwrite (even if it doesn't show the change in the preview)? Thanks!Tyson

Hi all,  I have a strange error message in FME Server. I try to create a sqlite file, but it says it is locked. This file did not exist before running the Workspace. Transaction starts at 0.73 2021-12-2 16:37:35 | SQLite 3 Writer: Opening `\\fme-server******\resources\data\GIPOD\GIPOD_Beta_Token.sqlite' for write operation74 2021-12-2 16:37:37 | SQLite 3 Writer: Failed to open database '\\fme-serve********\resources\data\GIPOD\GIPOD_Beta_Token.sqlite'. SQLite3 Engine error: `database is locked'75 2021-12-2 16:37:37 | SQLITE3 writer: A fatal error has occurred. Check the logfile above for details76 2021-12-2 16:37:37 | JSONExtractor (JSONQueryFactory): A fatal error has occurred. Check the logfile above for details77 2021-12-2 16:37:37 | HTTPCaller_3 (HTTPFactory): A fatal error has occurred. Check the logfile above for details78 2021-12-2 16:37:37 | AttributeKeeper (AttributeKeeperFactory): SQLITE3 writer: A fatal error has

Hi, Does anyone know if there is also an issue for writing textures to geometry for OBJ and FBX format writer in FME v2022.2? It seems the same issue for Sketchup writer has been fixed. During test the issue for OBJ and FBX format seem to be present.

Group ID should start from 1 for each unique Attribute 1 value and the smallest value of Attribute 2 for each Attribute 1 value should get it as follows:

I have simple script with adding color palette to raster ASC after cell value replacer . In ouput GeoTIFF i received too many palette colors represented with black color. |In attachment i send script. It's possible to have only 3 selected colors without black numbers?

Hello Sir / Madam, I have a gdb file that have several layers. I am just wondering how can I extract all attributes from the layers?  I tried "Schema" reader and list exploder to explode the data. However, I only able to get one table attributes. May I ask how can I extract all attributes from all layers? I have attached a sample data in here. Hope someone can give me a hand. Thank you! Thank you in advance.

Hello Sir/ Madam, So I have a CityGML file, which is based on XML. In each of the 3D model, I would like to extract the attribute name and values. Basically, what I want is that those with gen:string attribute name and bldg are the values where I would like to retreive. Here is a part of the file <gen:stringAttribute name="BuildingStructureID">    <gen:value>15169952</gen:value>   </gen:stringAttribute>   <gen:stringAttribute name="BuildingCSUID">    <gen:value>3917120211T20050430</gen:value>   </gen:stringAttribute>   <gen:stringAttribute name="BuildingID">    <gen:value>1108233601</gen:value>   </gen:stringAttribute>   <gen:stringAttribute name="ModelIdentityNumber">    <gen:value>B391712021101062A0</gen:value>   </gen:stringAttribut

This would be simple to do in Excel, but I can't figure it out on FME. The problem is I need to transpose or pivot rows to colums, as in example (I have formatted and calculated the totals to first box):I have tried with AttributePivoter and AttributeCreator/Aggregator, but it doesn't work. Any help would be appreciated, I've tried to google, but with no luck. I have also tried to pivot the unprocessed data and calculate it there.

Hi, Yesterday I came across the situation where I wanted to split a text file into several portions. For 'new lines', the file contained both single Line Feeds (i.e. LF or \\n) as Carriage Return - Line Feed (i.e. CRLF or \\r\\n) combinations. Thus both the Unix End Of Line (EOL) methodology and the Windows EOL methodology were present. I used the StringSearcher to match relevant parts of the text file, and then wanted to use (concurrent) all_matches{}.startIndex to fetch the relevant portions of the file. However, I found out that when I then use the found startIndex in e.g. the SubstringExtractor, it doesn't doesn't return the same (starting) characters as found in the match. Digging a bit deeper, it seems that the StringSearcher all_matches{}.startIndex seems to skip counting CR (\\r). I'm guessing it identifies CRLF (\\r\\n) as an individual character c.q. index? See the screenshot below for a demo workspace il