Transformers

I am wanting to change the the background color of a table cell based on the text value within the cell. I.e. if the value in the cell is "Good" change the background color to green and so on. I am converting an excel table to html table using the HTMLReportGenerator then created custom html where the script below runs but the output doesn't work. I just get the html table with no background colors. The jQuery code below seems to work when testing it using this site - jQuery toggleClass example - JSFiddle - Code Playground : <script> var cell = $('td');  cell.each(function() { //loop through all td elements ie the cells var cell_value = $(this).html(); //get the value if (cell_value == "Bad") //if then for if value is "Bad"

I would like to save the feature count from a reader and later use it as a conditional check before writing the data back to the database. For example if the reader feature count is 600, I would like to make sure there are 600 features after processing and before writing the feature back to the database. I have experimented with trying to connect StatisticsCalculators to get the count, VariableSetters /Retrievers and the Terminator, but cannot get everything to work and it seams overly complicated for something so simple. Especially since I can see the feature count on each connection line. Any input or suggestions?

I have developed a workbench that reads from Oracle SDE geodatabase and writes to a filegeodatabase. If I run it from fmeworkbench, it works fine but if I run from a command line, I get the following error: The Esri Product license used by this machine does not include licenses for the 'ArcServer' licensing levelThe ArcObjects license 'Standard' is being selected from the Windows registryThe Esri Product license used by this machine does not include licenses for the 'Standard' licensing levelThe ArcObjects license 'Standard' is being selected from the Windows registryThe Esri Product license used by this machine does not include licenses for the 'Standard' licensing levelUnable to load a library in the folder: D:\\Program Files\\ArcGIS\\Server\\framework\\runtime\\ArcGIS\\bin64. The error number returned from GetLastError is: 126I have 64 bit background geoprocessing installed.

Hi,I'm creating objects in 5 different tables and I have a requirement for the object's IDs to be unique accross all 5 tables. I also need to set the starting ID value with a UserParameterSuppose I had 3 features created in each table.My objective would be :Ids 1 to 3 in table AIds 4 to 6 in table BIds 7 to 9 in table C...Would anyone have a suggestion for the best way to do this?I've tried with counters and feature holders but I haven't been successful. Strangely, I get something liketable A : 1,2,3table B : 1,2,3table C : 4,5,6although it seems to me I'm doing the exact same thing between table A and B and between table B and C... Cheers !

I am reading in a spreadsheet with 41 sheets. I get the unique values(UniqueValueLogger) and throw out the NULLs(tester). Then I hit the SQLExecutor that runs for each of the unique values. Next is the NoFeatureTester. If a work order exists, it drops to the OpenWorkorders transformer which writes the information to a file. If there are no open work orders, I need those unique values to be sent to the next SQLExecutor for further processing. How can I get those unique values back out to send to the 2nd SQLExecutor transformer?

I am trying to go from this: to this:Where "Current Weather" is the first "validTime" record and "Next 24 hrs" is the second "validTime" record. I messed around with the concept in excel and came up with the following which might work but can't seem to replicate it in FME: I've played with the AttributePivoter, StatisticsCalculator, AttributeExploder, and others and just can't seem to alter the table to something similar to what is shown above. The idea would be to go from reading in arcgis server service feat

When using a portal feature service for a table and a feature, joining them via uniqueid (guid 38) the feature joiner fails to join even though the guid is value. The dataset is branch versioned. Am I missing something?

Hi.I'm trying to find the nearest polygon (city polygon) to a set of points (border posts).And I tried out the neighborfinder transformer. It seems to work fine except that it doesn't add the attributes of the nearest polygon to the point feature.What am I missing ? 

Hi community!How can I transform a pointcloud LAS in a mesh OBJ?Tnkx to everybody

Unfortunately, the source data can't be obtained as one package. Instead it can only be retrieved through individual SOAP calls. As such, the workflow obtains a dynamically generated list of relevant ID numbers retrieved through an initial GET request and then uses those ID numbers to construct the respective URLs for the individual GET requests, which obtain the data that I need (but it stores the XML retrieved through each GET request as a separate record/attribute). The workflow is for a regular batch update process using the externally sourced data to update my data.

Hi everyone, I need to create a user parameter (choice with alias) that contains CRS used by ProjReprojector, but, in the parameter configuration, the CRS used by ProjReprojector aren't listed.I'm using FME(R) 2020.2.1.0 (20201130 - Build 20806 - WIN64). By the way, I need to use ProjReprojector because RDN2008 / UTM zone 32N isn't present in the Reprojector or CSMapReprojector list. Thanks 

I have a workspace which merges several Shapefiles. The filenames/locations are handed over as parameters and the workspace is called through a batch file. How can I accomodate cases where some of the input files are not present? There is no interaction between the missing Shapefiles and the other ones in the workspace, they just get written to a common destination.

I am looking for a method to remove the outcrops, circled in blue, from the building fotprints below. The generalization algorithms I have tried "soften" the polygons to much and make them look a bit organic. I would like to keep 90 degree corners as much as possible so that the viewer quickly can identity the shape as a building. It might require a different process but I would also greatly appreciate suggestions on how to fill out the "jagged" corners circled in red. Cheers! 

The extents of the shapefile bounding box are -100 (left) and 100 (right) and -200 (bottom) and 200 (top). Since there is no prj I don't know the units, but I do I know the shapefile is supposed to be a UTM 12 north map projection and I know all the other CRS parameters (so I am able to create the correct prj for the shapefile). In addition to this, I know the x-offset and y-offset and scale values that must be applied to the shapefile. My question: how do I apply the offset and scale to the shapefile? I believe these offset and scale values were derived when the file was converted from CAD. Thanks!

Does's it possible to use where clause for more than one feature type? f.e. [gas_distribution]cp_bond_wire where id > 0; [gas_distribution]cp_rectifier where id > 0Two where clause delimited with ";".

In TestFilter, is there a trick to allow specifying the list index range in the Test Clause?e.g., _list{[0-2]}.fruit = 'Apple'rather than specifying each element index to test for individually:_list{0}.fruit = 'Apple'AND _list{1}.fruit = 'Apple'AND _list{2}.fruit = 'Apple'without going into PythonCaller way?

I am trying to read in multiple files from a folder at once which contain a specific text string in the title and not any files that don't contain that string. I want it to be dynamic, such that if the files in the folder change, the reader will update as I want to put this at the start of a workflow which will put all the features from each individual source file into a single file and perform some transformations with that data. I have managed to figure out making a reader that looks at a folder and all its sub folders, but it reads in all the files in the folder, some of which I don't need/want. Is there a way I can apply a search filter to the reader so it only brings in files that have certain terms in the title?

Hi FME community, I'm creating a workspace to automate a proportional spatial sum.I have polygons with employment data.And I have bus stops that I'm using to create multiple buffers as my zones of interest. I'm testing this with zones I've already caculated with MapInfo GIS software so I know what values I'm suppose to have in the end, and i'm able to compare this with FME workspace results. I get the expected result when I aggregate all my stops points from all buses indifferently: But I also need those stats for each bus separately. To do so, instead of aggregating indifferently all points, I do it with a group by using my bus name attribute.But the results are way off.

How to find the distance between two point efficiently. Have used Linebuilder with a larger dataset and it takes ages, workspace with test data is attached.

Hi FME Community,I have a large polygon and I would like to devide or split it to mosaics. do you know a transformation capable of doing it for me automatically.Thank you in advanceArash Hokm

I have a geotiff in tif format & ovr format. I want to convert this to another format such as a CSV or autocad format but I can't seem to get the correct output. Any help is appreciated

I have a workbench that fetches data from an API and updates a Web App in ArcGIS. I am using the Teams Connector to publish update information to a relevant Teams channel. When running this workbench locally I receive no error and the message publishes successfully to Teams. The Problem: After publishing the workbench to FME Server in Cloud, I am receiving a strange error which I cannot seem to find the solution to on any article. The error and workbench are shown below. Error: Workbench: Looking forward to hearing any opinions.

Hello all,I am using CoordinateExtractor to extract the start and end coordinates of line features. Most lines have only a start and end but some have an intermediate vertex. I want to extract the start and end for the list created but if I use the -1 I get no results (according to the help 0 should be start and -1 should be end)  If I open the text editor it is showing a problem with the expression  Can anyone let me know what is the correct syntax to get the end point, please?

Thanks to Debbi L for her help today and pointing me to:https://community.safe.com/s/question/0D54Q00008FXAFASA5/i-have-a-100-ft-line-that-curves-and-then-turns-back-into-a-straight-line-how-can-i-use-fme-to-only-gather-the-straight-line-after-the-curve-only-i-basically-want-to-cut-out-the-curve-and-only-grab-the-line-after-the-curve While this helped, I am at a loss as to how to buil

Hello, How would I remove specific vertices from a feature that are stored in a list, the vertex remover only allows one vertex be removed. I have a list with: Coordinate Index - vertices_to_remove{}.vertice_indexX - vertices_to_remove{}.xY - vertices_to_remove{}.yZ - vertices_to_remove{}.z Thanks