Transformers

I have a workspace set up to write into an Excel spreadsheet in Sharepoint. I am able to control the cell width in the writer parameters to a designated number.  I also want to set the cell height to auto fit because I have the text set to wrap, but some entries have a lot more text than others. When there's longer text entries some of the text gets hidden until you double click the cell. Is this possible in the FME Excel Writer? If I were to manually do it in Excel this is the step I would take.

I have this table of data (as an example)I will be receiving data for each object, and I want to cross check that every attribute (column) that has Yes is provided in the dataset. Please could someone advise me how to go about doing this and which transformers I should be focussing on?I was trying to maybe create a list for each object (but failing at the moment) so am a little stuck. Thank you in advance!

So when I place a reader und just look at the untransformed model it already has the wrong geometry. Changing the settings for stroking doesnt help. It seems like FME just doesnt like curved volumes, but that seems like a big lack in capability, which seems unlikely, because I havent found anything about this topic here. Is there a way my file can be read correctly or at least closer to the truth? The way it is now, I cant really use it. Here is an example:The color and height difference are intentional. What isnt, is that the lower object lost a few vertices compared to the higher one.

I am creating a workspace converting from shapefile to cesium 3Dtiles. The workspace is completed, but it can not set the color by values of specific attribute. I am trying to use "AppearanceSetter" or "FeatureColorSetter" but it won't allow to set various values of one attribute by colors like value 0-1:Green, value 1-2:yellow, value 2-3:Red. I'm new to FME, so if you don't mind, please kindly help me out how to set up. Thank you.

Dear people, When using the Spatial Relator I get a list of "Spatial Predicates to Test" to choose from. This list is rather limited, it seems to me.  However, the documentation for this transformer describes a "Dimensionally Extended 9 Intersection Matrix (DE-9IM)" at the bottom. This offers more options. But, as far as I can see, the string representation of a DE-9IM is only output as a list attribute with the result. I haven't tried that yet, but I assume that the DE-9IM that comes out corresponds with what is chosen from the list for "Spatial Predicates to Test". Or does it give the exact spatial relationship according tot DE-9IM? Anyway, I would like to compose a string representation of a DE-9IM to use as a spatial test parameter in the Spatial Relator. Is that possible? Kind regards,Ferdinand.

I would like to convert ecw files into other raster formats, and since I do not know what output format other users prefer, I would like to provide a public user parameter with a list of available raster formats in FME, and use the parameter to specify the format used in the FeatureWriter. Looking at the FeatureWriter I cannot see the possibility of dynamic, or even a selection of output formats. It also seems rather cumbersome to get a list of all raster formats FME is able to write. Is there a possibility to tweak the FeatureWriter to take the format from a user parameter list?

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 se

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 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