FME Form

Hi,In case I select ISO format in TimeStamper, does it assume that it is UTC or not nesessarily?How to set it to UTC?  

Hello FME enthousiasts, I've been building a simple workspace for a collegue to get some parcel data from a public WFS. When I run the process it all seems to work (i get the desired parcel written to a File Geodatabase). But it keeps giving a single WFS error in the log, but the error apparently doesn't stop it from running:<WFS> GetFeature URL: `https://service.pdok.nl:443/kadaster/kadastralekaart/wfs/v5_0?SERVICE=WFS&VERSION=2.0.0&REQUEST=GetFeature&TYPENAMES=kadastralekaart%3APerceel&FILTER=%3CFilter%3E%3CAnd%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3EAKRKadastraleGemeenteCodeWaarde%3C%2FPropertyName%3E%3CLiteral%3ERNN01%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Esectie%3C%2FPropertyName%3E%3CLiteral%3EK%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3CPropertyIsEqualTo%3E%3CPropertyName%3Eperceelnummer%3C%2FPropertyName%3E%3CLiteral%3E36%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FAnd%3E%3C%2FFilter%3E&OUTPUTFORMAT=app

I would like to be able to parse a response from the Bentley OpenGround REST API, and am getting somewhere but not far enough!I can use a mixture of attribute exposer and JSONFragmenter to get some information out, but it never quite looks like the table i want. i will be doing multiple queries over the coming months into this api, and will have a different number of columns each time, so cant parse through each data record based on the number of columns i want in that particular query! I can get to the point where i have a feature for every feature in the database, and then i have a _response_body which i need to parse further. i can keep parsing it through jsonfragmenter, and i end up with a jumbled mess where columns are names wrong and the colunn information i want is in the wrong part of the table. it is a simple structure, such as “DataFields” “heade” for column name and “value” for data itself. i will add some screenshots to aid in query. any help would be greatly appreciated!Th

Hello Forum. I’ve just run a workspace. It was successful and produced data as expected. No problems there. However it produced two errors never seen before… Is this anything to worry about? They didn’t seem to affect the workspace or outputs. Thanks,Stuart

Hello,In FME 2023 , in the AreaOnAreaOverlayer transformer the tolérance = “None” parameter has been removed. There only option of “Automatic” or “Custom value”.Question : if there was Tolerance = “none” in pre FME 2023 .fmw scripts, should we use Custom Value = 0 to have the same result as tolérance = none  or “Automatic”?Thanks

Starting soon I will receive about 150 XML files each with a different schema but the element name is include in the file name.  I have many ways to use a single FME workspace to process these files dynamically but have been unsuccessful.  I figured using a Directory File reader and passing the file names to FeatureReader setup as XML then saving to a Dynamic Writer to a database.  No joy. What am I missing for something so simple.

Hei, er det noen som kan hjelpe meg med å lage en fme-modell som konverterer 2.5D bygninger i sosi/quadri til 3D-bygninger ? Det er høyde på alle objekter, men høydene ligger ikke som  egenskaper.Ønsker et filformat som kan brukes i qgis for å bygge 3D-modeller.

Would like to hear the opinions of the collective on best practices for writing features back to a SQL database. Specifically Intergraph SQL in my case, but I guess this could apply to many formats.I have a table with millions of linear features that need to go through a LineCombiner process before being written back to the same database. The big question….what is the best methodology for deleting the old geometry and inserting the new? Two methods I’ve used in the past, each with their own downsides.•    SQLExecutor/DatabaseDeleter based on the unique ID. Main concern with this is if the translation fails after the Delete but before the writing of new features, those features are gone.•    Let the writer do a DELETE/INSERT (fme_db_operation). To me this is safer, but can take twice as long due to number of transactions.I can’t simply truncate the table because we are sometimes only reading a subset of the features in a specific AOI within the database. Truncating would also delete the

Hello everyone. I am working with citygml modeling and I am facing some problems with appearanceSetter. I have a workspace similar to the con terra that I used as a base.Originally everything is fine but when I put an appearance setter before the roofSurface writer (ground or wall too). The geometry traits previously set are automatically modified by the FME. In the image below is the original output.And in this the output with the appearanceSetter.The geometry trait created for polygons was moved to linearRing and a new one was created for polygons.The file is normally opened by the Data Inspector, however, when running Val3dity to perform the validation, the xlink is broken, as it must point to a polygon. EDITED: I forgot to mention that to reproduce the situation above i placed a appearanceRemover just after the reader to remove the original appearance of input data.Does anyone know how to fix it? Thank you in advance for your help. Mcdonnell

We generate certain types of transformers (mostly HTTPCaller) with some attributes prefilled and want our users to be able to copy the content from a file or web source and paste it directly into FME Workbench, or use drag and drop, if possible. We don’t want to use custom transformers, which works, but the overhead would be overkill. The problem is that the paste does not work, CTRL+V does nothing and the paste menu option is greyed out. I tried with a direct clone of a working transformer so the format is correct. If I copy a transformer, paste it into an editor, copy the editors content and try to paste it back to Workbench it won’t work. I don’t know why this does not work but I persume it might have something to do with encoding. Does anyone have a clue how to overcome this issue, or maybe a workaround? Thanks in advance.

Hi everyone, I have an object like the one in the screenshot which is read from an IFC file. And I have some 3D points in a GeoJSON file. I want to copy the object on each point coming from my GeoJSON file.And also, I want to rotate them in their place.  What can be the optimum solution?Thanks! 

Hi, I have this dynamic setup where a postgres FeatureReader reads the schema and the results are written to another database using this schema information to create the new tables. However, a table having colums of type unqualified varchar will be regenerated with varchar(80) and if records are loaded having length >80 the workspace will crash, saying: Error was 'ERROR:  value too long for type character varying(80)I attached the workspace. Is this a bug in FME or am I doing something unbelieveable silly?😕 I'm using FME(R) 2020.2.3.0 (20210129 - Build 20820 - WIN64) on a postgres 12.9 (Ubuntu 12.9-1.pgdg18.04+1). 

I created this line from a set of (X;Y) values of points : I’m trying to turn the lines straight and then buffer them to have a result like this: Is that even possible ? i tried using Bufferer directly then Generalizer , but the result is not good : Any Insight is much appreciated !

I would like to perform a visbility analysis as I’m used to with the esri’s fonction arcpy.sa.Visibility.I tried to build something and after goglling, I read this excellent post  which is not working for me because I’m currently bound with FME 2021.2 and the script  of this post uses a newer version.Is there a way to perform a visbility analysis with FME 2021?Currently it looks like the clipper is not able to work on TIN surface.Any ideas?

How do I write a csv file and name it using the value in the top / first row?I want just one file to be created, (not multiple files like fanout creates) named after the entry in the first row.For example in the table here I have 9 rows and 2 columns. I want to create a csv of all of this data but named “20231207.csv” As a secondary question, you will see the first attribute column is sorted into date order. If this wasn’t sorted into order, what is the quickest way of identifying the closest date to the current date, and then using that identified value to name the csv file?Hopefully this is something really simple!Thanks in advance.Stu

Hello yet again 😅I’m GET-calling a an online database through HTTPCaller which responds with giving me a feature in WKB code (in _response_body), then I run the respective code through GeometryReplacer and tried different WKB Encodings in attempts to get a geometry out of it (this should be a polygon), but no luck.The following encodings give me this:Hex Encoded FME Binary: Rejected (INVALID_PARAMETER_GEOMETRY_SOURCE) OGC Well Known Binary: Rejected (INVALID_PARAMETER_GEOMETRY_SOURCE) Hex Encoded OGC Well Known Binary: Ends up in Output and thus not in the rejected port but it does not create any geometry feature that can be inspected.The code is following, so if anyone has seen this before or is enthusiastic to figure this out with me then feel free to investigate:0010300002084080000010000000E000000931E86C64699244192E9D0891B741D41DBF97EF242992441C3F0110102741D41F4A963551A99244180F3E2341E741D41F4531C970F9924415EBBB401E0731D41AED4B380CF982441BF9A03840B741D41001E5119CB982441BB0A294FED73

Hi.I have another string replacer question.I have a file of text strings (appellation) similar to LOT 1/2 DP 17528 LOT 1/2 DP 13552 RS 16932 18812 19986/7 PT 18813 20862  BLK IV KAPUNATIKI SDI have split the LOT 1/2 DP 17528 & LOT 1/2 DP 13552 into 4 separate rowsTemp, _result, appellationLOT 1/2 DP 17528, LOT 1 DP 17528, appellationLOT 1/2 DP 17528, LOT 2 DP 17528, appellationLOT 1/2 DP 13552, LOT 1 DP 13552, appellationLOT 1/2 DP 13552, LOT 2 DP 13552, appellation What I want to be able to do is remove the temp part from appellation  The resultant appellation in this example would be: RS 16932 18812 19986/7 PT 18813 20862  BLK IV KAPUNATIKI SDI have tried doing this but only ended up removing one part from each instead of both Temp parts. I would be very grateful for any help with this.Regards, Paul

Wondering if anyone can tell me how to clean up the recent files list on the fme form start page,Any clues appreciated, I have a long list of old files I was sorting out, now would like to clean up the recent files list on the start page.

When I try and run the dashboard workspaces they fail with statusMessage File Dashboards/JobHistoryStatisticsGathering/JobHistoryStatisticsGathering.fmw could not be openedWhen I look around the FME Server files I cant find any of the dashboard workspaces. Where did they go? Where can I get them?

Hi I’m interested in using MQTT connector to retrieve IOT messages and then publish to ArcGIS Online. I see there is a MQTT connector as an install.https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/mqttconnector-pkg.htmCan this connector also work with FME Flow (hosted)? I don’t have access to FME Flow at the moment but wanted to know if this is possible for use case above.

Hi all,I am working on a script to replicate a set of feature classes from one enterprise geodatabase that we use for transactional editing purposes to another enterprise geodatabase that we use for publication purposes for the organization. This replication script would be scheduled in FME Server to run on a nightly basis.The issue is that the feature classes I plan on replicating have several domains and subtypes applied to them that don’t translate correctly.I’ve been advised to use the ‘Resolve Domains’ functionality and change the configuration from ‘coded domain’ type to ‘char’.My test workflow involves the below:Copying the feature class via the ‘Import Feature Class’ tool in ArcGIS Pro into the target Enterprise Geodatabase to have the feature class available in both geodatabases With FME:Selecting the ‘Resolve Domains’ checkbox in the Writer at the outset, and using the ‘Insert’ and ‘Truncate Existing’In the Writer configuration, changing the ‘coded domain’ type to ‘char’ and

I am reading datasets and can extract the crs (stateplane) from them. but I need to use a spatialrelator for data that is in WGS. I need to be able to determine incoming crs and set a reprojector on the wgs data right before the spatialrelator. In the past i have only been able to accomplish this by stringing together more than 1 workbench.Any ideas on how to get this done in 1?

Hi everyone,I’m hopeful somebody here will have seen this behaviour before and can help me to understand what’s going on. I’m getting an error when trying to decode some Base64 documents that have been read out of a system but I’m not sure why and I’m not sure I can easily create a sample workflow to demonstrate it, as I’ll explain.The task is to extract specific documents form an API connected to a document management system. I’ve been able to create a workflow that will identify the required document IDs and then extract the documents into feature attributes for me.The document data that is returned to me is in Base64 format. When I post the output data into an online conversion as a test, it is converted into a usable image (in the case that I tried). From this I assume that all other documents will work similarly.When I pipe that output into a BinaryDecoder and ask it to decode the Base64 attribute, it throws an error complaining about the input.When I copy the Base64 code and add

Hello. I have three line vectors in SHP format (Red, Yellow, and Green). All of them are 100% overlapping in plan, but some are shorter than the others.Which transformer should I use to remove the overlapping area from the Green line that intersects with the Yellow line, and from the Yellow line to remove the overlapping area with the Red line? Please refer to the sketch below.I tried with Clipper but it didn’t work. Thanks in advice! 

Hello FME community,I would like to write the values ​​of a list into a column. I would separate them with a minus. It may be that the list of a data set has 1 or 2 or three values.If a list of a data record has no value, no minus was written to separate it. I am attaching 2 pictures to understand it better.