Best Answers

Hi authors.FME workspaces are stored in a specific and well-known structure on an FME Server. So finding the path of another workspace is feasiable.I'm wondering whether I can use WorkspaceRunner to submit other workspaces on an FME Server instead of FMEServerJobSubmitter ?Is this completely no-go, or are there benefits, such as running more workspaces within a single job ?It would also simplify building and debugging on desktop.Any insights are appreciated.Cheers

Hello,An enterprise geodatabase reader interprets a value in a date field as: 20130426000000A file geodatabase reader interprets the same date value as: 20130426This is a problem when comparing date values in ChangeDetector, as they are always noted as an update, even though they are essentially the same value.Does anyone have any ideas on how to make the 2 dates comparable?

Hi, I am trying to IMPORT an EXISTING relationship feature class and FME complains about the name being too long....I cannot rename the Relationship feature class since it is a part of an existing data model. The table/feature class name 'WaterstaatswerkWaterkering_Waterkering' is too long for Oracle (!!??) to accept. Please shorten the name and try again I think this is a FME limitation that should apply if you are going to CREATE the table, but should not apply if the table/relationship feature class already exists! Anybody any thoughts/ ideas on how to go about this?

How can I convert raster boundary to polygon? Raster Domain is equivalent tool in ArcGIS / Pro.

Can FME desktop call Open API data after receiving coordinate information from a file? Basically the client will supply a lat/long from CSV file and then we want use those coordinates to get data from our API source. Request format: https://<apiURL>/data/lat={lat}&lon={lon}&exclude={part}&appid=[API KEY]

Hi all,I was wondering if the same way that I can easily access to the layer content via ArcGIS Online, ArcGIS... can be made too via FME Desktop. I've tried the "Esri ArcGIS Portal Feature Service" reader, but not sure if I needed to have credentials for authentication. The URL:https://geodata.antwerpen.be/arcgissql/rest/services/P_Portal/portal_publiek2/MapServer/83 My purpose is to only read features from that service.Thanks,

Hi,I have a script that does an area calculation using arcpy, the two calculated areas are output in the log, I need each one of them to be output as an attribute, how to do this? I'm new to python at FME.  log: The output, it doesn't help me at all.  Thank you for your help  

Undefined macro `SourceDataset_FILEGDB_3_FILEGDB_3' dereferenced in file `A:\\...\\...\\FME Worksapces\\wb-xlate-1459541027202_6756'Program TerminatingThis error happened to me today for no identifiable reason. If anyone has encountered this issue or has an idea as to why this could happen I encourage you to share your thoughts here. After this happened two files were created in the folder where I store my work spaces (Not where temp files go).wb-xlate-1459541027202_6756ANDwb-xlate-145865875395_6136A peculiar thing happened to one of my readers and it kept "resetting" to not being set (<Not Set>). So you could not open the containing folder or edit the path. It had no options, but the schema and the reader were still in the workspace.At first I tried rolling back to the very beginning of my work flow history to check if the translation would run when it used to run, but no, I got the same error.The problem can be fixed by copying over the entire workflow into an

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 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?

Hey community!I need some coach, anytime I run any script, FME ask me what is the input file.Can I remove this option? (Attached image).Tnkx a lot to everybody!

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!  

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 ? 

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(

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 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

I have an excel spreadsheet where the attribute name changes based on a formula, every time we fill in an X in line 2 the attribute has the same name, but the number can change to 1,2,3 and 4. I created a reading dynamic, but when for example the COD_STREET = 0 in the dynamic FME reader keeps showing COD_GATE = 4 in one of the attributes, what am I doing wrong? attachment follows the spreadsheet

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.

Looking for more information on FME Server 2018 and Fault Tolerance.

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!

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 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'm looking to build a workspace for an FME Server App to read a generated QR code that has a CSV list of attribute values in as an attribute and further transform it. Does anyone have any experience?