FME Form

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 th

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.

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:0010300002084080000010000000E000000931E86C64699244192E9D0891B741D41DBF97EF242992441C3F011010

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

Hi folks,I had a question regarding creating an FME script that takes attributes from a system of record dataset into an existing record created in a feature class within an Enterprise Geodatabase.Workflow consists of the following:Two layers with the same information and attributes in different systems of record – one in an asset management system and feature class in an Enterprise Geodatabase.No integration exists between the two systems yet as there is a new replacement system being developed in a project, but in the intermediary, it has been decided that the business will be updating the asset in the asset management system, then updating the feature class attribute table in the Enterprise Geodatabase. Therefore, they will be maintaining two datasets in tandem until the pilot project for the replacement system is complete.The difference is that the layer in the asset management system only stores XY/Lat/Long values whereas the

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’

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.

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.  

Hello,I created a model and I want to export it as citygml, but the model does not appear in the FZK gml viewer. How can I solve this problem? Am I making a mistake in the writer? I added my data and FME WB. Could you please check it and share what I am missing?

As per my knowledge, FME does not supports reading Multi-part Annotation features from Geodatabases (File or Enterprise).Is there a way or workaround to handle reading and writing Multi-part Annotation features?

Hello, I'm sure it's a pretty simple question, but somehow I can't see the wood for the trees to find the answer.I have a list (.xls) of coordinates in the form <name>, <x_coord>, <y_coord>. The coordinates are, for example, in the form N 51° 06.796 E 3° 14.545.Now I want to save the information in an FGDB and would have expected the VertexCreator to help me with this. Unfortunately, all my values are completely rejected. My further attempts - removing all spaces; using the HUB Transformer "DegreeFormatter" or Decimal Degrees Calculator all failed. For this reason, how do I manage to get the coordinate format into a form so that the VertexCreator accepts it? Thank you very much.

Hi there,I have a question about the unit of coordinate in the iFC file, which i wanna clippe with another solid. The coordinates are 1000 times bigger, and the clipper could thus not find overlaps. How can I adjust the coordinate value: using the expression evaluator, and divide all the coordinates with the value 1000? if tho,How can I access all my coordinates because I could not find an attribute that enables that? I also tried the coordinate extractor but it is only another copy of the coordinate values, which doesn't update the geometry coordinate value in the IFC . If anything i understand it wrong pls point it out! thanks in advanceFang