Transformers

I have been getting this error a lot: Excel Writer: Failed to open the dataset 'FILEPATH\\FILENAME.xlsx'. Error message was 'No such file or directory.'XLSXW writer: An error has occurred. Check the logfile above for detailsExcel Writer: Dataset 'FILEPATH\\FILENAME.xlsx' contains no data and is therefore not a valid Excel file. No file will be createdXLSXW writer: An error has occurred. Check the logfile above for details It will happen a few times and then the workspace will run as normal. This occurs in any Workspace I use that has an Excel Writer. In the Task Manager, if there was a process I could end, I would do that. It still happens.  Any Ideas?Thanks,-Loren  

Hi guys a silly question here, is there a way i can expose the attributes before use dynamic schema to write them out? I'm using feature reader to read a list of sde feature class from csv file but hope i can expose their attributes for further processing before write to the destination.. Thanks!

Looking to create a csv output as a 'dat' file for import to another system. basically rows of text with the fields essentially defined by the number of characters they occupy in the row, padded as necessary. So, i need the output row length to be fixed for each field, and yet I only have the otpion of vchar.In online documentation I can see reference to a datatype of char, but this is not exposed in the fme writer.Why is it missing? / Why have I missed it?Help appreciated.Using FME Desktop 2022.1.2.0

I am trying to tint some terrain shadows (raster) with overlaying polygons of different colours (RGB). Thing is that the polygons are larger than the shadings so VectorOnRasterOverlayer colours a larger area than I wish. I only want to tint the "black/greys" in the raster, not the white areas. I have tried to filter out the unwanted areas using a RasterExpressionEvaluator, setting everything beyond break point to white. Unfortunately I have not been able to figure out a syntax that does not also change the hues. Any ideas on how to approach this? Looking at the example below I would like to keep the darker/shaded areas and shift the flat ones to white.  

Hi,When i insert with the jsontemplater a date in the mongodb writer the type of date is always string even i choose isodate, fmedate......etc. Can i have a type date in mongodb via the jsontemplater ? Thanks a lot

When I specify an HTTPCaller with a defined header, then everything works as desired. However, as soon as I want to enter a conditional value (the same values that work alone), I get an error message: This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins. Unfortunately it's the same behavior when I define conditional User Parameters and use them as HTTPCaller headers. Is there a way you can use conditional "header" values in a HTTPCaller or is this a bug? Best regards

Hi, I am struggling to put a simple Python script in gdb Reader/Scripted Parameter Value that will allow me to read only polyline. Could someone please push me in the right direction?

I have a dataset of curves (lines) automatically generated from the DTM. I have some topological issues that I want to detect automatically ( photo). I used the geometryvalidator transformer, but I can't seem to detect them. How should I proceed? Thank you for your help

Hi all, we have just updated from FME Desktop 2021 to FME Form 2023.1.1.2. I want to create a mapping file .fme, but the option .fme is missing in the Save As- dropdown menu. Has this option been removed by Safe Software? Or has this functionality been transferred to another menu? Does a workaround exist? Thanks for your help!

In the atrributes below I want to specifiy the usage of each building, for example building (_gebaeude) 504. Is there a way to do this in FME using the createAtrribute Transformer? There are over 40 buildings each with a specific usage and name

Hi All, I'm working on a workflow to bring the information from 3 separate layers into my analysis output. SpatialRelator would do the work but also want to create the lists in order to concatenate values into the same cell. I need to concatenate different fields but ListConcatenator only allows one at time, Screenshot below shows the fields I want to concatenate with the following structure: ListConcatenation A = GM_SiteRef + GM_TypeListConcatenation B = LandOwner + LandOwnership_Status + LandOwnership_TITLE_NOListConcatenation C = LEP_Site How can I make it to work and have multiple ListConcatenators? I'm trying to avoid any filter or tester as won't work.... PD: I would also need to add a ListDuplicateRemover before the concatenator to avoid duplicates in the sam

Hi there, I have a workspace that fills out an excel spreadsheet and then pushes this into Sharepoint. I want to hide the first five columns in the spreadsheet (so I can unhide them when I need to check, but the user doesn't have to see it). How do I do that? I tried hiding them in the spreadsheet in Microsoft 365/Excel Online, but they revert to showing every time the process runs. I tried in the FeatureWriter Paramaters> Edit Column Formatting> Cell Protection> Hidden in the first five columns, but that didn't work.Thanks in advance for any guidance you can provide.

A workflow we use at work is as follows: Geometry data is stored in SQL Database (attached screenshot - SQL Geometry.png). It is a multi-part polygon and looks to be correct.I use a SQL Creator in an FME job to get the data from the SQL Database. We call a stored procedure to get this data but no transformations are performed in this GET.I use a Geometry Replacer in the FME job with the following settings:Geometry Encoding: Microsoft SQL Server BinaryMS SQL Server Format: GeometryAfter this Geometry Replacer the shape looks correct in FME Inspector, but the Type looks incorrect (attached screenshot FME Data Inspector.png)The shape looks rightIt is classed at the top level as an IFMEMultiArea type of 1 part which is not right. It seems to have classed it as a shape with 1 part (a donut) with an outer boundary and 2 inner boundaries.I'm pretty sure the data conversio

I want to create a PDF report like this , where i have HEADER and the value below   In this yellow boxes 'PDMS' column could go in this attribute values  this is my FME workflow to insert HEADER but , the values / attributes are coming from Excel output , so i need to insert them in this boxes like sum / average , total count etc. 

I need to split this polygon using as a reference the rows, how can I do this? These polygons are initially rows, which I transform into polygons using AreaBuilder. As a result it generates 2 polygons, however I need to fragment the polygon into more parts according to the rows.

I have configured tester transformer with user parameter, such that feeding the user parameter through command line will automatically provide the criteria to tester transformer for filtering. 

Hi All,I'm facing some odd behaviuor with the AttributeFilter, Tester, TesterFilter. The screenshot below shows that my data includes 'g2a' values in the attribute table but I filters that value in any of the transformers cited above the values doesn't show up?  Here is another snapshot of the AttributeFilter (unfiltered) after importing all values From Feature Cache:  Why does it go into the Unfiltered values?  Any idea more than welcome 🙂Thanks

Hey community! How can I do a visibility analysis, from several observation points to several points or lines of sight?I can use 3D vector data, LiDAR data and DEM from LiDAR data. Anyone has a "script type" to explore?😊 TNKS a lot guys!

My configuration in the JSONTemplater looks like this:  {  "type": "Feature",  "geometry": {    "type": "Point",    "coordinates": [      fme:get-attribute("X"),      fme:get-attribute("Y")    ]  },  "properties": {  "33064" : fme:get-attribute("33064"),  "33085" : fme:get-attribute("33085"),  "33103" : fme:get-attribute("33103")  }} As result I get: { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ 7.61438690276304, 47.5603635244644 ] }, "properties" : { "33064" : "", "33085" : 94328460, "33103" : "2. von B Spezmast Nr.55" } } The numb

Hi;I created a very simplified version of my custom transformer.All it does is find the center point and define the layer name for the future dwg writer.Attached is a custom transformer and workbench example, where dwg writer creates a dwg file with point in the default layer that come from custom transformer.When I use the transformer in "linked" mode and start the entire workbench, I get an error.When I use it in "linked" mode but with the use of feature caching to the transformer, and then I only start the dwg writer with "run to this", then it's ok.When I use the transformer in "embedded" mode, everything works fine.The difference in the translation log is in line:"Using MultiWriter with keyword `PRIMARY_DEST' to output data (ID_ATTRIBUTE is `multi_writer_id')"in embedded mode and"Using MultiWriter with keyword `REDIRECTED_DEST' to output d

I have changed the project file extension to .zip and extracted the XML documents, but getting nowhere with Esri ArcGIS Layer Reader (safe.com) Have also tried pointing a regular xml reader at them. Any ideas?

Hello,I have a (tough) nut to crack.A TestFilter of a job, run by a WorkspaceRunner, receives data but does not copy them into his output.TestFilter_12_INPUT (TeeFactory): Cloned 2589 input feature(s) into 2589 output feature(s)TestFilter_12 (TestFactory): Tested 2589 input feature(s) -- 51 feature(s) passed and 2538 feature(s) failedTestFilter_12 LR valid Transformer Output Nuker (TeeFactory): Cloned 45 input feature(s) into 0 output feature(s)TestFilter_12 BT valid Transformer Output Nuker (TeeFactory): Cloned 6 input feature(s) into 0 output feature(s) The very same job, when run manually it gives this information : TestFilter_12 (TestFactory): Tested 2589 input feature(s) -- 51 feature(s) passed. I don't understand why the behavior changes according to the way of launching it. Someone has an idea ?  

Hi there, if I have a dynamic filename within a csv or feature writer, e.g. "@Value(LINK_DIRECTION)_@Value(SIMULATION)_@Value(TECHNOLOGY)_@Value(BAND)_@Value(CARRIER)_@Value(TYPE)_@Value(SERVER)-importfile" it takes about 25 seconds to write one million files. If I write simply to test.csv, it takes about 2 seconds.Both variants writes only one file. I tried also to group by within the featurewriter with option "Complete Groups when Group Changes". All records are within the same group.User Attribute Definition is in all cases set to "Automatic".What did I wrong? What's the best way to just write into a csv file, with various attributes in the filename?Thank you for any help!I'm using FME 2022.2

Or is there a certain way the csv needs to be structured in order to take on a new schema? Thank for your time.

Hello everyone! I have dataset with two entities - points with Z coordinates and quite complex multilines. Is there any way how to gain Z values from points to vertices of line? Points have the same XY as vertices of line. Sample below:I have tried the way with SurfaceDraper or with Chopper and PointOnPointOverlayer, but results were not as I expected. Thank You so much!Lubo