FME Form

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’

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

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 Afte

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

Hello Forum, I have an externally supplied dataset which includes a street name. Some of the street name entries are all in lower case (e.g.: royal road) where it should be Royal Road. However some entries are fine.This is part of a larger regular data process, so I’d like to build in a process that fixes street names to proper upper/lower case (e.g.: royal road would become Royal Road). Is this possible in FME Form?  Thanks,Stuart 

Hi, I‘m stuck at a simple point. I want to make the AttributeKeeper filter from @Value or a User Parameter which is created by the AttributeCreator. Is it possible? I don't find a solution.The goal is to get more attributes late in a row: test_2,test_4,_test_x in the AttributeKeeper from the AttributeCreator/User Parameter.  

I would like to visualise data on the inspector data or in the graphic view after I reprojected it. That would be in the middle of a workspace before using other transformers and just to locate some features. I know it’s possible to write the data in a shape and check the features on another software like QGIS or ArcGIS but I would prefer to do that in FME directly if that’s possible, when I’m building my workspace. Can I do that?

I want to convert JPEG file (4 band) to COG with below parameter:I have problem with “Interleaving Type”:When i chooses “BIP”, i received a message log:“COG writer: JPEG compression supports at most 3 bands with BIP interleaving. Please change the interleaving to BSQ, choose another compression method, or reduce the number of bands”When i chooses “BSQ”, i received a message log:“COG writer: The file layout 'Cloud Optimized Tiles' may only be used with BIP interleaving. Please change the interleaving to BIP or select a different file layout”I need to convert JPEG file to COG with compression method “JPEG” and keep alpha band.Can i do that? Am I mistaken about something?

Hello, I have these dataArea Category Date A  Medium  202301 A High 202305 B Medium High 202306 B

Hi Community, I am facing a similar issues as outlined in the following link : However, I am unable to extract the data from the database. I guess am missing something in the JSON query parameter of the JSON Fragmenter transformer. Attached are the screenshots  Am very new to FME so it’s possible that I might be missing something basic. Any suggestions on how to overcome this would be helpful.