Transformers

Documentation mention 'Syntax Highlighting' as an option in the advanced text editor.Is it possible to set the highlighting scheme to a given language (SQL) from a stringConcatenator transformer? 

Hi all, I have a 3D mesh in a DWG file (3D surface of a pavement) and want to convert its footprint to a single polygon in an Esri file gdb polygon feature class (for use in 2D GIS). Can ignore all attribute information. Tried following this post but without luck (I think I need more detailed instructions re settings for each transformer). Anyone here able to help me? Thank you!https://community.safe.com/s/question/0D54Q000080hgjISAQ/turning-a-mesh-into-a-polygon

I've tried using the raster selector but it always fails (probably because I do not know how to correctly introduce the parameters)I am attaching a print screen of the Raster Calculator from QGIS with the "Expression" I used to filter my raster image. Thanks

Hi, We are collecting data with Esris Survey 123 and I would like to export the data within the shapefile (table) to specific cells within a excel template. With our gathered data we would like to make excel reports where different data ends up in different single cells within the worksheet. Anyone who has a simple smart solution for this?

Checking this, but surely this has to be a Bug? FeatureJoiner in Left Join Mode and Right Hand Side Conflict Resolution is overwriting LHS Attributes with NULLs where:a) There was no matching Feature on the RHSb) The Attribute Name exists on both the LHS and the RHS I would have thought that for any Left Feature that did not match any Right Feature, there is no "conflict" to resolve and it should exit the Transformer with the same Attribute Values as what it went in with? 

I have simply transformed an IFC file to OBJ format, but the default result is that everything has the same flat grey colour. I notice that I can edit the created "materials.mtl" file afterwards to change the different material types, and when I then import the created OBJ file into Blender, I see that the new colours are there. I would like to automate this however, for example making all walls a certain colour, all floors a certain colour, etc., or even changed their colour based on attributes. Is this possible? I see under the OBJ Writer parameters that I can specify a custom Material Library File, but I don't have one to start and I would prefer to simply generate it dynamically, just with the colours for each feature that I specify. How can I do this? I tried using a ColorSetter transformer just after reading some specific feature types but that didn't do anything.

I'm trying to group together polygons from a single dataset that are in close proximity to one another (0.5 metres). I've used a NeighborFinder (Candidates Only) which gives me a value for distance and have set it to give me a Close Candidates List so that it returns more than one neighbour. However, it is not clear to me how I can tag the features that meet the criteria for belonging to the same group and I have no attribute that I can group by

I have a simple workbench that reads a postgis database and outputs an excel file based on a user parameter in which the user enters a filename that filters the input table into one record. This works fine within FME, however I'd like to create a batch file that runs the workbench from the command line. The problem I have is getting the batch file to prompt for the user parameter. It just runs the workbench with the last parameter I set within FME. I'd like to be able to run the batch file and get the prompt for the parameter in the command line.

I'm trying to analyse an area/DEM with these two criteria:  -Even sloping terrain steeper than 1:20 and total slope height > 5 m.Finding areas with slope of 1:20 (5%) could be done with the slope function. But I can't figure out an easy way to filter these areas to only include areas with slope height over 5 meter. I.e. the total vertical height form start of slope to top should be at least 5 meters.Anyone have any ideas or thoughts on this problem?   Background: The criteria are to identity possible land slide areas (quick clay), so it's already clipped to only include areas of old marine sediments. https://www.ngu.no/en/topic/quick-clay-and-quick-clay-landslides

I have a shapefile or esri geodatabase file of Appraisal data that I need to join to two different appraisal data tables based on a single field and add the table fields to the original file. What transformer(s) should I use?

My inputs are 3D point shape files and 3D point clouds in LAS format. These have been re-projected from OSGB to London Survey Grid using the transformer - SnakeGridProjector. The XY positions of the data are converted correctly but the Projector is set up to handle 2D data and the elevation values pass through untouched. It is a 'black box' projector so can't itself be manipulated to incorporate elevation shifts. Ideally a fixed value needs to added to the elevation to complete OSGB/LSG re-projection. We can apply the Z shift in alternate software, but would like to add this stage within the FME workspace if possible.

Hi All - I am attempting to take a geo polygon and shrink, rotate, and offset the polygon to the correct location. For this I was attempting to use Affine Warper. The polygon I'm trying to change is the "Observer" and I have a geojson polyline with 2 points as the "Control" that I want to shrink the polygon down inside. No output is given in the Affine Warper.

Day one in FME... Coming from an SSIS background. What would be the approach to dynamically set a reader location based on the results from a transformation? I'd like to take the Joined results I have and for each filepath start a whole new batch of work. The readers have me stumped as I'm used to being able to set the source locations using an expression. I can see I'm not able to add a reader in a custom loop. Just looking for a push in the right direction. (see below). Could be I need to re-wire my brain for FME use too!

Why does the FeatureMerger flip some line directions when supplying their geometry to another feature? It seems that only features that begin running in a southerly direction are flipped. Here is the transformer: Input:Output:

Is it possible to use a dynamic writer to update? I want to read multiple feature classes, join each feature class and then update the joined records in a different database. Matching columns are not available when selecting Update feature operation.

I am a very new user to SAFE FME and I am still learning the tool. What I am trying to figure out is how to publish a .hyper data source file to our on-prem tableau server. I am using the 2020.1 version of safe fme with the new .hyper writer. My basic question is how do you do this. More specifically what I need help understanding is: (1) how to write the XML into Safe FME to do this per tableau (see this document: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api_ref_publishing.htm); (2) can I do this without having to save a .hyper file locally; (3) can I create a macro to make this easier for others and adjust the settings (like append the data, replace the data, etc.).  Thanks in advance, Greg.

Does anyone know if it's possible to write with multiple DWG templates. I've tried making a published parameter and defining the template fil as AutoCadSource but it seems it only applies the first one.  I need each corresponding template to be the original file that I'm reading in because they're all different and have different block names within them.   Thanks!  /Jacob

I'm trying to rename an attribute based on a user parameter. For this, I used the BulkAttributeRenamer since both AttributeRenamer and AttributeManager don't seem to accept user parameters as valid inputs for an attribute name. This worked fine for the first time, renaming the attribute appropriately to the value of the user paramter. However, when I change the value of the user parameter, the new name doesn't seem to propogate through to the output.  In the picture you can see I try to replace _2 with _$(YEAR_2). The first time I ran this, I used a parameter value of "2010" whch worked fine. Now when I change the value of this parameter, the output still shows only _2010 instead of the new value. I need to do this so that the output file has the correct attribute names, instead of the temporary ones I use during the workflow. Does anyone know how to accomplish this? Thanks!

Hi,I upgraded from 2018.1.2.1 to 2020.0.0.1 on windows 10 machine.I have a workspace that reads feature classes from the SDE, inline queries, attribute keeper, FeatureWriter (1 per FGDB, SHP, DWG, GEO, CSV, KMZ), before file copy inserts a text disclaimer into the zipped folder. Previously this process worked flawlessly (years), now the featurewriter deletes the previous zipped folder before the FileCopy writes/inserts the disclaimer. If i remove the disclaimer the featurewriter deletes the previous zipped folder, if rerun with nothing in the workspace, it correctly writes out.I get the warning below when it deletes everything when overwriting.MULTI_WRITER: Skipped adding of some files to zip file '\\\\ncservfile\\database\\xx\\xx\\xx\\Recreation.zip' because they already existBelow is a sample of the workspace. Any help would be greatly appreciated!

I created a Choice Multiple parameter and when i start the workspace i can check some values. But how can i test on the checked values? I tried a tester but that doesn't seem to work.

Hi I run for the first time the trainer then I run the classifier now I would like to add new records to the trainer to improve/refine the results How can do this ? Thx Francesco

The FME version is 2019.2

I have a python caller that is failing and giving me a key error here is the log message:2020-09-01 10:34:39| 636.8| 0.0|INFORM|Found 561025 features2020-09-01 10:34:39| 636.8| 0.0|INFORM|Consisting of 26411 transformers, 160252 nodes and 374362 bits of conductor2020-09-01 10:34:47| 637.9| 1.1|WARN |Python Exception <KeyError>: u'5405483'2020-09-01 10:34:47| 637.9| 0.0|WARN |Traceback (most recent call last): File "<string>", line 119, in closeKeyError: u'5405483'           2020-09-01 10:34:47| 637.9| 0.0|FATAL |PythonCaller_2 (PythonFactory): PythonFactory failed to close properly2020-09-01 10:34:53| 643.8| 5.9|ERROR |PythonCaller_2 (PythonFactory): A fatal error has occurred. Check the logfile above for details The python script is attached The thing is, it ran perfectly OK one day and then the next day when i ran it and ever since it has kept failing. No changes to the workbench,but data updates overnight. The value referenced '5405483',

Hello, I have created a workspace that works as it is in FME 2018.0.However now, when trying to upgrade, I seem to be getting validation errors, which I have not encountered before. After examining the outputs, they are different, as seen on the image.When running the translation in FME 2018.0 every feature is treated as FeatureMember, since 2018.1 it is behaving as seen on the right side, it's one giant FeatureMember. Any help how where can I fix this in newer versions? Thanks for any help,Radek