Transformers

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

I using geometry validator to rectify the geometry errors . Input of the geometry validator is polygon data from PostGIS database and repaired geometry need to update in same table. While executing the FME it shows "Geometry type (Polygon) does not match column type (MultiPolygon)" . Please advise to clear this error.

Hello. Could someone advise? I have an airport runway and for each runway I have a runway threshold coordinate - start and end. I also know the length and width of the runway between these runway thresholds. I would need to graphically create a polygon that will create the correct visualization for me based on these input attributes. The output format will be a shapefile. The dates of each runway are several times, because depending on the direction from which I land, I have the name of the runway. In reality, it is 2 points of each runway (start and end) and their one length and width. Thank you very much 

I need an FME .fmw file that will convert an Esri point shapefile into an AutoCAD DXF files that will take the 'POINT_ID' attribute value from the shapefile and place it as a text entity to the upper right of the converted DXF point

I need to make an inventory of the GIS data my organization has. As a first step, I need to make a list of the names of the Feature Classes in each of our File Geodatabases.  Is there a way to extract a list of the Feature Class names (not the attributes or schema) from a File Geodatabase(s) to Excel using FME?  I know how to do this in python in ArcGIS Pro, but given I am relatively new to FME, I thought I would try it in FME.