Transformers

What is the best way to write and read to/from sharepoint subfolders without downloading or uploading first the files or folder using Sharepoint online connector?

Hello ,i have used topology builder Parameter :end node and intersection , tolerance automatic .I need it to to let the lines properly noded .but my problem that it create intersection point for cross lines ,as even „X“ or „T“ .how could I use topology builder end node and intersection and avoid effect on cross lines ?my target : to let the line properly noded then count the no. of overlaps point on line . I have used topology builder end node only ,it does not create intersection point but my network need to clean so I have to clean the data first .what should I do ?FME 2021 thanks in advance .

Hello. I have been tasked with pulling a large amount of XML from BLOB fields in a table to find relationships between the data. The problem I'm having is every approach I've tried has stalled FME Because of the large number of attributes I'm pulling out of the XML after XMLFlattener and AttributeExposer. I have attached one blob field, and each of them are basically the same, just larger or smaller. The results I'm picturing in my head are grouped by the Equipment GUID and Cable GUID. 

I have a point feature class in a geodatabase. It doesn't contain metadata yet. I want to write one for it. I think I need to use XML Templater. But I can't read directly from GDB by adding a Esri GDB reader. what should my source be?  

I have an excel file that does not have any merged cells. Any cell that is left blank is supposed to take the value from the previous row. How do you do that in FME without looping through a list? This is what I haveAnd, this is what I want (with grey-color being the items I want to automate with FME): 

Hi.. I have an FMW workflow that reads a shapefile with H3 polygons. Each polygon has a HEX color attribute (eg #000000). I need to do 2 operations: Style the shapefile filling each polygon with color using the HEX attributeRender and write the layer as a raster image (Geotiff or JPG) Can this be done, and how? Thanks, tC/.

I am trying to read a GeoTIFF that has LERC compression.I created a workbench in FME 2021 that read and mosaiced some GeoTIFFs with LERC compression and wrote them to GeoTIFFs with LZW compression. I was able to do that successfully.However I'm trying to do the same thing now in FME Workbench 2023.0 with the same files and I'm getting the following errors: 2023-08-15 13:18:41|   0.1|  0.0|INFORM|GEOTIFF reader: Opening file 'C:\Temp\DEMs\CB11_10000_0502.tiff'2023-08-15 13:18:41|   0.1|  0.0|WARN  |GEOTIFF reader: C:\Temp\DEMs\CB11_10000_0502.tiff: C:\Temp\DEMs\CB11_10000_0502.tiff:LERC compression support is not configured2023-08-15 13:18:41|   0.1|  0.0|ERROR |GEOTIFF reader: C:\Temp\DEMs\CB11_10000_0502.tiff: Cannot open TIFF file due to missing codec.2023-08-15 13:18:41|   0.1|  0.0|ERROR |GEOTIFF reader: Failed to open the dataset 'C:\Temp\DEMs\CB11_10000_0502.tiff'. Please ensure source data is valid and correct reader is selected2023-08-15 13:18:41|   0.1|  0.0|WARN  |GEOTIFF rea

I have a flow that pulls from an excel doc to an oracle database table. I have created LOVs based on some of the fields. Game plan is to create drop down list in my application.Question: How can I, within the flow, compare and replace the excel fields Descriptions with the LOV table ID value?Thanks

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 slides like I see in the tutorial. The attribute names aren't fixed, so the Attribute Filter doesn't work, at least not that I can see so far. https://community.safe.

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): This is the warning/error I'm getting. It seems as though the WorkspaceRunner is not respecting the space-delimited format of the Features

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**#.AlarmName",    "IsTicker": false,    "lifetime": "1d",    "computers&quot

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.