FME Form

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"  $(this).css({'background-color' : 'red'});  // changes td to red.  else if (cell_value == "Good") //if then for if value is "Good"  $(this).css({'background-color' : 'gr

I would like to import a select number of tables from Oracle Spatial Object into ESRI geodatabase_SDE (ArcSDE Geodb), where they are given a new table name.I can do this one table at a time, but is there a method where I can batch or loop this process, as I have a large number of tables to process.I have both the required input and 'renamed' output table names in an excel spreadsheet.Please note - I do not want to import the whole database, only a select number of Oracle tables which are then given a new name in SQLserver.

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?

FME DesktopFME(R) 2019.1.3.1 (20191019 - Build 19643 - WIN32)Running on a server with Windows 2008 R2 service pack 1 I have a workspace that uses an HTTPCaller transformer to get a user token from ArcGIS Portal. I then take that token and use it to read features from an ArcGIS Server Feature Service. This works fine. Then, I use that same token to write to an ArcGIS Server Feature Service through the ArcGIS Portal Feature Service writer. I do this because there is no ArcGIS Server Feature Service writer. But I'm not able to get it to work. Is there a better way to do this (write to a Feature Service sitting on ArcGIS Server)? Below is a screen shot of the ArcGIS Portal writerAnd below is the error from the log. Note that the writer is appending "sharing/content/users/https:?f=json" to the URL. Creating writer for format: Esri ArcGIS Portal Feature ServiceTrying to find a PYTHON plugin for writer named `ARCGISPORTALFEATURES'The workspace does not contain user Python. FME will attempt to

I have CAD file with nomber of layers, each layer represent landuse, i want to knew what transformer i should use to convert the CAD file into GIS personal database , the output to be one feature class and landuse use to be saved in one field.

Hello, i'm trying to read a geopackage via the featurereader and performing a where clause to read only the necessary data - it's not working! is there a known problem with fme 2020 and the featurereader with geopackage?

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. ¿Is it not possible to run it from a command line? 

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 !

Hello, New to using web services here. I am trying to use oauth2 login to Portal ArcGIS Server feature service on a specific layer index and use the REST Query function to pass in a couple of parameters and then have the output to json format.  For instance this is the ArcGIS Server Feature Service on a particular feature layer (e.g. index 3) https://ppp-snoopy.com/un/rest/services/SnoopyUN_Network/FeatureServer/3  Then pass in the string query parameters according to this reference page Query (Feature Service)—ArcGIS REST APIs | ArcGIS Developers  where: GUID = 'abc1234xyz'gdbVersion : Snoopy.Surveyoutfields : objectid, GUIDf: json I am trying use HTTP Caller to access the ArcGIS Server feature service using NTLM authentication and got this error :{"error":{"code":499,"message":"Token Required","details":[]}} I also tried to use direct URL to the ArcGIS Server Feature Service (without Portal) and no luck.  Any help wo

I want to know if there's a way to Generalize (in 3D) a 3D line. Common Generalizer tools are for 2D lines. But is a 3D Genralizer tool exist? I mean if I want to generalize a 3D line from a Z tolerance. Imagine a 3D polyline with ups and downs and I want to smooth or generalize the line. And the resulting line is within 20cm (in 3D) from the original 3D line. Thanks, Frank

Sorry Team, This is not one question.  I have one fme file, which writes (conventional writers)to 50 PostGIS tables. I need table names and total features written counts from fme.Since I am writing to a staging database, I need to do validation of counts, before making / swapping these tables as the main tables for the application.  once I am okay with the previous counts(count from the previous run) and current counts(comparing prev run with the current fme run), we are copying the tables to the main DB. table1 100000table2 50table3 6895698....like this to write these info (table_name , total_count)to one more postgres table ie fme_written_status table. I know our feature writer does this job, but I need to replace all the writers. summary port gives this output with total_features_written.But not one feature writer, I need 50 separate feature writers. because summary port gives total, not table-wise. can I replace all normal writers to feature writer transformers in one go? can I ac

I have selected ~50 records from a shapefile of ~5.5 million records using a column of unique reference numbers. The unique reference numbers are stored in a CSV. I have used FeatureJoiner to join the CSV and shapefile.  The resulting joined records have been correctly selected but the values in final two columns containing the X and Y coordinates have been altered when viewed in the visual preview. Where in the workspace has the change taken place?

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?

Hi,Just wondering if it is possible to transfer photos from one AGOL feature layer to another using a unique ID - maybe via a join or something similar?I can read features and their attachments using the AGOL Feature Service Reader, join them up with the destination dataset, but I cannot write the photo attachments using the AGOL Feature Service Writer.The geometry and attributes are written but not the photos.Thanks,

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 features and write out to an html table (or maybe something else) which would look like (or similar to) the above table. Any ideas are greatly appreciated!  

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?

You can export/import database connections in FMEworkbench (as xml or enc-file), wouldn*t it be nice to have the same function in FME server? Will we see it soon?

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 ? 

Hello, Can someone explain to me why is JSONFragmenter returning json_type = object instead of json_polygon? And how to adjust anything to get valid json_polygon? Parameters of JSONFragmenter: JSONFragmenter returns: Usually for this kind of JSON data I get (with correct geometry): JSON data for correct return is given as attachment, as well as the incorect one.  

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

I am renaming the Postgres tables inside the SQL executor(Postgres).If the task is successful, I need a success mark or flag from the SQL executor(stored proc).here there are two flags variables in my code ie "done2" and "i"But the initiator only comes out, nothing comes from the output port. I need one feature from Result port 1 for success or 0 for failure.Can Anyone help me?CREATE OR REPLACE FUNCTION func1()  RETURNS integer AS$BODY$DECLARE   cntold INTEGER := 0 ;    cntcur INTEGER := 0;   i INTEGER := 0;   BEGIN        SELECT INTO cntold count(*) FROM @Value(table_name_old) limit 10;        SELECT INTO cntcur count(*) FROM @Value(table_name) limit 10;        --SELECT INTO cntnew count(*) FROM @Value(table_name_new) limit 10;        IF cntold > 0 and cntcur > 0 THEN            EXECUTE 'DROP TABLE @Value(table_name_old)';            EXECUTE 'ALTER TABLE @Value(table_name) RENAME TO @Value(table_name_old)';            EXECUTE 'ALTER TABLE @Value(table_name_new) RENAME TO @Value(

Hello there, So I have bunch of points and lines in my database. For the final output, I would like to extract the points/line (possibly the name) that cannot fullfill the following criteria. 1) The points MUST touch the lines, but it can have a tolerance of 1m to the closest lines.2) The starting and ending of the lines MUST have points.  So the sample shows that points 1-6 are correct, while the points 7-9 and the line below (C) are not correct. It is because the line C does not have the starting and ending points. Also, the points 7-9 do not contain lines within 1m buffer.Might I ask what kind of transformers I can use? I am not very good at FME and hopefully someone can give me a hand.Thank you very much. Zach

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.

Hello #FMECommunity!Here is the news about FME for the week ending 22nd October. Community Activities: Random Acts of TransformationSo during our Community Webinar yesterday (depending on where you are and what your 'yesterday' is) Dale and I tried our hand at Random Acts of Transformation (RAOT) which is where we pick a transformer at random and try to explain it in as much detail as we can, with some lesser-known tips and tricks. Fate dealt us an XML-based transformer as our first go, which was a bit rocky, but then we gave a good description of the FeatureMerger transformer and that was a lot better. You can find just that section of the webinar on YouTube, where I hope to post more of these in the future. Community Activities: GeoguessrWe're nearing the end of the Geoguessr subscription (about 7-10 days remaining) and many users are having fun with this:  We still have a few open spots if you want to play, so let me know. Community Activities: Postcard ExchangeSo while

Hi all, Can someone tell me what the fme.uuid file is for when activating a Floating License and what the content means? Kind Regards, Krien Guijt