FME Form

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.  

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

I am creating a series of small jpeg files using a feature writer with each jpeg getting it's name from a unique value (myRLU_@Value(RLUOID)). I recently upgraded to 2022.1.1 from 2021.2 - things were working until I upgraded. I have 20 records coming into the FeatureWriter and 20 showing in the Summary port but no records passing through the output port.The FeatureWriter creates the jpgs but does not pass through the records to the testfilter transformer? Has anyone else had issues with this in 2022.1.1? Any ideas how to get this running again? Could this be helpful in diagnosing the issue: FeatureWriter_5: Bulk features are not supported because the expression contains a function call After playing around some more - looks like the issue is the FeatureWriter using an attribute as the output filename. When I change it to a "hard-coded" value, the records are available in the output port.

I want to use the same condition for each attribute, with the only variation being the attribute/field name of the attribute to which the condition applies.

Hi All, I have a list of data features like thisName   Phone Number   CitySmith   123-456-7890     New YorkBob      987-654-3210     HustonIn addition, I have a single lookup feature like thisCompany   Idxyz             123I would like to merge the lookup feature into the list of data features like thisName   Phone Number   City             Company   IdSmith   123-456-7890     New York    xyz             123Bob      987-654-3210     Huston       xyz              123 I thought I can use transformers FeatureMerger or FeatureJoiner to do this. However, since I don’t have a common attribute to compare, neither of them works. Can anyone help me on this issue here? Thanks,-John

A have one dataset (Dataset A) that has contains fields, one of which is CityName; example value “Sudbury”. I have another dataset (Dataset B) that contains a field made up of comma delimited AltNames; example value “Gran Sudbury,Grand Sudbury,Sudbury, etc.I need for these features to be joined in one dataset if the value in CityName matches any one of the comma delimited names in AltNames, however different records have different numbers of alternate names and it cannot match with a section of a comma delimited value. For example, Sudbury != Grand Sudbury.I think that lists may solve this but I’m not familiar with the transformers that might enable this process.

Hi All,I’m working on a workbench to help my team with some geo-processing. The plan is to upload the workbench to FME Flow therefore my team can run it on demand.I have included a FeatureReader transformer at the beginning of the workflow to read a GDB containing cadastral polygon data. This is an User Parameter in the workbench therefore the user will be including the input.The GDB should always have the same fields/order, any variation in the scheme...the tool will fail,How can I check and inform the user at the beginning of the process that the scheme doesn’t follow the standard GIS schema?I was think about the SchemeScanner or ChangeDetector...but open to suggestionsHere is a very basic screenshot that shows two FeatureReaders → Features To Read (Only Schema), 

Hello everyone ,i am currently working on Lidar data , i am reading a set of points from a json file and creating vertices based on the coordinates.here is how the json file containing the Lidar data looks like :  (a bunch of (x,y) set of points)in order to make use of FME point cloud specific transformers i need to convert these points from point geometry to Point cloud geometry , any idea on how i could do that ?Thanks in advance