Transformers

When I am using a regex in a string searcher, the output is as expected. When I am using the same regex as @FindRegularExpression in the Attribute Manager, my script always fails. What do I need to modify in the Attribute Manager regex? Thanks

I have a workbench that goes as follows:Read in attributes from a CSV. The attributes are locations, and Join those records with a buffer and spatial relator to find potential conflicts near the input locationWrite out the records to a PPT fileThe input table would look something like this  Location 1 | Table Text 1 | Table Text 2Location 2 | Table Text 1 | Table Text 2Location 3 | Table Text 1 | Table Text 2 And ideally, the final PPT file would look like this:Title Slide: Location 1Table Slide: Table Text 1Table Slide: Table Text 2Title Slide: Location 2Table Slide: Table Text 1Table Slide: Table Text 2Title Slide: Location 3Table Slide: Table Text 1Table Slide: Table Text 2and so on It's in step 3 that I run into issues. I can't find a way to dynamically filter attributes so that I can write to separate sl

Hello , i have many lines and many points .i have used anchored snapper then topology builder then edge output as in input network for shortest pathfinder and I used every point connector transformer for points to get lines to use it as input for from to shortest path finder . my question : i need to find all routes that possible .shortest path finder has found many paths but there are still too many no paths .How could I find all routes between points ?then extract ids from each route .i hope there is a good idea let me know .i have spent much time but no success .fme 2021

I have the following problem: I have multiple csv files with multiple columns. I want to dynamically change which columns to read.I have a user parameter to define which columns to read.  Even though the " Attributes to Expose" Parameter of my FeatureReader gets updated correctly the Reader dosn't read the correct columns.Only after opening the properties of the Reader and closing it again by clicking "Ok" the Read reads the correct columns.  I'm using FME Desktop 2020.2.3.0 on Windows 10 Maybe someone can tell me if this is a bug or if I'm just overlooking something. Many thanks in advance !

Hii all,How can I optimize the performance of my FME workflows when dealing with large datasets? Any best practices or recommended settings to consider?Thanks in adavnce.

I'm working in FME2023 build 23283 using an Intergraph SQL Warehouse reader. I have a rather lengthy process that deals with comparing a single 'target' feature class against multiple other 'candidate' feature classes (defined by published parameter via Features Types to Read on the reader. This process needs to be reiterated for several 'target' feature classes. So instead of trying to implement Group By throughout the workspace, I've decided to use a WorkspaceRunner to run the workspace separately for each 'target' feature class.  The issue I'm running into is passing the Features Types to Read parameter from the parent workspace to the child. I have simply copied all the published parameters from the child to the parent workspace. This is the command line being passed (non-pertinent info redacted): 

I am using a featurewriter to update 3 three fields. For this update, I am only exposing the fields that need to be updated, because I have found that works best.However, I need the rest of the fields in the dataset downstream.I ran an attributeexposer to reveal the other fields, but they all come in with null values. These fields do exist in the dataset, and they do have values. How do I access the fields in such a way that I can see the values in them?Thank you,Randy McGregor

Hi everybody, I was wondering if anyone can help me with clamping 3D Building Tiles to the Cesium World Terrain. We are developing a 3D web application with Cesium JS and we need to have our 3D buildings sit flush with the Cesium World Terrain. Our input into the application are 3DTiles. I know you can clamp citygml files to the terrain with the in-built clamp to ground tool in Cesium ion but is there any way to get 3DTiles clamped to the ground in cesium JS or with the help of FME?We use FME to create our 3D Tiles but we have not found a way to get the buildings to line up with the terrain. Is anyone here aware of anything I can do in FME to get my 3D Tiles output lined up with the Cesium Terrain?  I would really appreciate some help on this! Thank you,Jan

Dear Sir/Madam, I would like to export fbx to cesium tiles.  My FBX model structures are follow11-NE-12A\\BXXXXXX11-NE-17A\\BXXXXXX I would like to export at the same folder structure in Cesium tiles.It gives me an error when I use the fanout expression. And now, I only able to create the following folder structure. 11-NE-12A\\BXXXXXX\\BXXXXXX11-NE-17A\\BXXXXXX\\BXXXXXXMay I know how to fix it? I have attached my sample data and fmw in this email. And I hope some experts can give me a hand. Thank you

Hello, I imported a point GIS dataset into FME to export it with datasmith into unreal engine. The dataset is point based (I used vertex creator). When exporting to unreal, the scene is empty. Essentially, I need to convert each point into a 3d object (like identical cubes) which will be read as a static mesh with UE. I am banging my head against the wall trying to figure out how to do that.... I tried to play around with 2dboxreplacer and 3dforcer but they don't give me any results.Any help or tips will be very much appreciated. Thank you so much!!!  

"extent" field stores information like '0103000020430D000001000000050000009C43A5BC013D5EC15.............'

Hi, I'm really new to FME, and am a little confused about how to do something. I have an existing automation built by an integrator that parses some emails for specific text. those are then bundled up various ways and sent out to various entities via email. I want to also send an API request with some of that data in it - the vendor i'm sending it to doesn't support a login auth, just tokens, though so i ended up making a workspace to send the call. However, i'm kind of confused as to how i get the outputs from the previous workspace into this one? I see the output keys from the writer, but, I don't understand how to get those keys into the next "run a workspace" My schema for the API looks like:{    "version": "v1",    "alert_text": "route.Email**#.RAWMESSAGE",    "title": "route.Email**#.Alarm

I'm working on data transformation and trying to achieve a task using FME. I have a dataset with two columns(From and To), and I need to match values from one column(From) with values in another column(To). The third column(ID) corresponds to the value present in col From, so eventually, I have to match the value in col From, find it in another col To, and populate the ID value(in new col ID2) in a new column.Essentially, I want to find instances where a value from the first column exists in the second column.Could someone guide me on how to set up an FME workflow to accomplish this? I got an understanding that it can be performed using AttributeCreator using Enable Adjacent Feature Attributes, though not sure if it can, and how!I appreciate any help or insights you can provide. Thank you in advance for the assistance!The ID1 values in the below image are IDs of col From. I have to populate ID2 values that refer to To column.

Hello Community, I am currently working on a project that requires me to integrate spatial data from various sources like Shapefiles, GeoJSON, and CAD files into a unified database. While trying to use FME to accomplish this task, I've run into some challenges. Specifically, I am having difficulty with the coordinate transformation and managing attribute schema mismatches. I've followed the tutorials and documentation available but still find myself stuck. Could anyone with experience in this area guide me through the process, or perhaps point me to some advanced resources or tools within FME that may assist with these issues? Thank you in advance for your assistance!

Hi.I have a workspace, built with 2020.2.5, that utilizes FeatureWriter to build a zipped shape file for attachment to an email.In FW I'm adding some variables to be propogated along with the datasets, i.e. adding them to "Additional Summary Port Attributes". This works fine in 2020.When uploading the 2020 workspace to our 2022.2.2 FME server, it still works fine.I just tried to create a workspace in 2022.2.2 (open+save as), and now the additional variables are all set to blank strings. This is so both on desktop and when uploaded and run on server.I then did the same test with 2023.0, and the same problem exists, at least on desktop (can't test it on server as my server is 2022). The version of FeatureWriter is 0 in all versions, suggesting that it is the same transformer since forever. Please advise.Cheers.

FME beginner here, I'm trying to do a pretty straight forward export from an sde based database to file geodatabase, the only real criteria I'm after is preserving the ObjectId values in the output. Everything tried results in the ObjectId resequencing itself in the output per normal, our client has built relationships on the OID (why I'll never know) so we need to preserve them in the extract. Any help is appreciated.

After georeferencing CAD in ArcGIS Pro, generating World (wld3) and Projection files (prj), FME doesn't position the drawings correctly despite enabling advanced options. Why?

I've tried using FME Desktop on one of the new M1-based MacBooks. When running workflows I notice that I get considerably more memory optimization messages and warnings than I do when running on an Intel Mac or on Windows. The result seems seems to be lower performance. I'm not really surprised as it is a brand new platform and Safe probably haven't had time to test this properly. It would be interesting to hear if anyone else have experienced the same thing. I'm also curious to hear if anyone from Safe can shed some light on the matter.Judging by my tests so far it looks like FME could potentially perform very well on Apple Silicon once the memory issues have been addressed and a universal executable for FME Desktop is available. For more details and results from running FME workspaces on Apple Silicon (and Intel Macs / Windows) I wrote a blogpost

Hello friends,Im a new user of FME. I have a dgn file with hundreds of points with or without tags. i need to convert this dgn to shp with unique custom ids. Is it any procedure or transformers to do this in fme. I mean each point should get unique id number I tried with many videos and tutorials didn't solve my issue thanks

Hello, In my current project, i mostly use UTC datetimes, except for one process, where we need local time (Paris).  For example, i need to convert "2020-04-29 12:00:00" (UTC) to "2020-04-29 14:00:00" (local).  To convert my UTC datetimes, I could use the rule "+01:00:00 winter" and "+02:00:00 in summer". However, the day the times changes is never the same from one year to another.For example, in 2020, Winter time (one hour difference with UTC time) was adopted on October 25th, and Summer time (two hours difference with UTC time) was adopted on March 29th. In 2021, Winter time change will be adopted on October 31st and Summer time will be adopted on March 28th. Moreover, the conversion will not occur at the specified datetime ! This conversion could be run six months later, a year later… because we are processing data long after it was created. So I can not rely on the time of the

Hello, I'd like to add a geo-referenced and framed text (see attached) to a GeoTIFF.I've used the transformers on the attached screenshot.Everything runs without error but the framed text does not appear on my output GeoTIFF.Could you help me? I'm new to FME. Thank you in advance,Camille

I have a polygonal tax lot feature class where about half of the features are being rejected from the Point On Area Overlayer Transformer with a rejection code of "INVALID_POLYGON_GEOMETRY_VERTICES". How do I fix these so they are recognized by the transformer?

Hi all one more time,I didtutorial example: Transpose a Table Using FME. Is it possible to further modifythe table according to the images below, please?  Values could be"x" or any other. Thankyou all :)

Dear All, I am facing the following issue. I have 2 datasets (which are quite large) that contain a series of common attributes. I have a 3d table that stores the attribute names that I would like to compare (no geometry comparison).  What I would like to do sounds very simple (sorry, I am newbie to FME...) :loading the 2 data, add prefix, merging them based on a key attribute (they will then have attributes like source1_col1, source2_col1, source1_col2, source2_col2, etc.)load the data that contain the column names I want to compare (e.g. col1, col2, etc.)iterate over col1, col2, etc. and for each of this value use TestFilter testing sth like "@Value(source1_$(column)) = @Value(source2_$(column))", write the unfiltered in an excel file on "$column" sheet) I have tried thousand things (custom transformer, ChangeDetector, workspace runner), but could not achieve exactly what I would like