Best Answers

Hello,I have configured a SystemCaller to delete all files and sub-directories within a specified directory, without deleting the specified directory. Originally, the plan was to have this at the end of the workspace, but now, we want the directory to be emptied at the start of the workspace, before any of the readers are initiated. I know this can be done using a startup Python script, but I was wondering if there is a way to call a startup command line command (so I can use the code I already wrote). I thought about changing my first reader to a FeatureReader, then using a creator to initiate the SystemCaller, then have the SystemCaller initiate the FeatureReader... but I was wondering if there was a more direct way to do this?Thanks!Courtney

Hello,I would like to know how to extract M value from PolylineZM? CoordinateExtractor seems to extract the x,y,z values.Thanks!

Hi, There used to have a transformer for generating Great Circle Routes in Google Earth developed by Dmitri in the FME Store. I can't seem to locate it anywhere now. I am working on a project to plot the flight routes between airports and this tool would be a time saver. Please advise if it is still available.  Regards, Lawrence

In a SQLExecuter, I'm using a SELECT statement where PKey IN (@Value(ID) I'm getting the oracle error:ORA-01795: maximum number of expressions in a list is 1000,as the number of of concatenated ID's passing the query is exceeding the 1000 limit.so I used an Aggregator and a Smapler trying to split the stream of data entering the SQLExecuter (every 1000 features), but that didn't work as I wish.. (pass a pack of every 1000 features to SQLEXECUTER)Any idea?

Dear FME-Users,  I’ve 3 input rasters with the same CRS, extension and resolution.  The aim is to get 1 output raster by combining all pixel values.  For each pixel the highest value from the import rasters should be used.  In the attachment you’ll find 3 rasters. The color cyan is “low” and the colors to red are “higher”.  Do you have an idea?  Thank you so much.  Best regards!  Konrad

Can anyone provide advice regarding the easiest method to swap raster bands around? For example, I have a 4 band raster, Band{0} Interpretation Type (Red16) Band{1} Interpretation Type (Green16) Band{2} Interpretation Type (Blue16) Band{3} Interpretation Type (Uint16) And I want to complete the following swapping Band{3} -> becomes -> Band{0} Band{0} -> becomes -> Band{1} Band{1} -> becomes -> Band{2} Band{2} -> becomes -> Band{3} Is it possible to manipulate/flip the bands directly within the raster? (How would this be done?) Or do the bands need to be separated into singular elements and then recombined and ordered? (How would this be done?) Also relating to this example, in the source raster described above, the Interpretation type of band{3} differs from Bands{0}..{2}. If the bands were swapped would I need to also need to change the interpretation types as below? Band{3} Interpretation Type (Uint16) -> becomes -> Band{0} Interpretation Type

Dear FME-community, I use NetCDF-Data for a FME-Transformation as input (Reader). The problem is that there’s no CRS (Coordinate Reference System) deposited. I've add a screenshot (Inspector) in the attachment. "Koordinatensystem" stands for CRS and "Unbekannt" stands for unknown (Line 2).What I’m doing wrong? Has somebody an idea with transformer I’ve to use? Thank your very much and best regards! Konrad

I do not use my FME Cloud account anymore, but I still get invoices. How can I close the account?

I've written a workspace in the 2015 version of FME, with five readers, which all have one column headed 'REFERENCE'. The transformer 'DuplicateRemover' is producing two outputs: 'Unique' and 'Duplicate', but the inspectors reveal that both outputs contain unique values. In 'Duplicate', there are both duplicate values and unique values. Why is this, and how can I resolve this to produce only duplicate values in the 'Duplicate' output?

I have a simple workflow trying to find a shortest path between 2 points. I am using a Cook County (Chicago) road network and a Creator to enter from and to points. In spite of different snap distances I keep getting an error "No shortest path found from...".My workflow is attached and the network file is from:https://catalog.data.gov/dataset/tiger-line-shapefile-2013-county-cook-county-il-all-roads-county-based-shapefileTIA,George

I have a dataset which needs joining. I need FME to identify which attribute values differ between touching features along the split, preferably producing a single attribute containing a message eg. "These attributes differ: #, #, #, etc". There are hundreds of attributes and I can't think of an easy way to do it.Thanks!

Can I use something similar to update and ERSI File Geodatabase. I am trying to use the fme_db_operation but no data is being updated

I am currentley using FME 2015 and i want to use dgn styler to , amongst other things, set the color of polygon object to a microstation V8 dgn file.  For some Features i need to set the rgb value, for other features the indexed color from the color table. But in the resulting dgn file i do not see the desired result at all. For rgb values i use , for example 124, 211,64 values, for the indexed color a numerial value from 0-255 range.  What am i doing wrong here ?

Hello There we build a service to doeload data direct from the Data base , some time the user cear a new view or table that represent layer we in the request we will send the table name as parameter but worksapce need to scan the availability of that table each time the request commes and complet the process for the down load , this way we dont have to predefine the table in the work sapce in advance Any idea how we acheive that

I can't find anything in the documentation about how how FME Server stores published parameters in scheduled jobs.Are published parameters that are passwords encrypted? Or does FME server store these parameters as clear text behind the password dots? See the screenshot below that shows exactly what I'm talking about:

Some of our systems have one and some have the other. We have separate license servers of ESRI and FME. The Data Interop ext. does not use an FME Desktop license while the FME Ext for ArcGIS ext. does. What is the difference between the two?

Getting stuck with a SQL statement that i'm using for the InlineQuerier. I normally do not work that much with SQL code and only use if to perform simple one on one joins. I am working with one data frame at the moment that contains multiple attributes and i want to create an extra attribute based on these. An short example:<code>ID  road_name           road_type    Type     Traffic1   bakerstreet         elements     B        light2   bakerstreet         elements     B        light3   piccadilly circus   asphalt      A        heavy4   woodstreet          concrete     A        heavy5   settlerstreet       concrete     A        heavy6   woodstreet          concrete     A        heavy7   settlerstreet       concrete     A        light8   settlerstreet       concrete     B        heavyI am trying to give all the features a unique RoadID based on all 4 attributes so i can merge them later on. The new attribute RoadID must be a data type Integer and the value should be matching a uniq

I am looking to adapt an existing workspace containing a feature reader that reads in an ESRI geodatabase with certain existing feature types to read and corresponding output ports for those feature types. The feature reader's source dataset path is set to a folder containing multiple geodatabases, with the particular geodatabase in that folder to be read being set dynamically depending on the fme_basename for another gdb that is read into the workspace beforehand. I'm looking to change the folder that the feature reader looks in, but keep the feature types to read and also the output ports the same - however when I try to do this and even if I specify the output ports the feature reader loses all output ports save for schema, generic and initiator. How do I avoid this?

I have an FGDB feature class which includes a "DBOperation" attribute with values of INSERT, UPDATE, or DELETE. I want to assign these to fme_db_operation but when I do this in an AttributeCreator, it gets changed to...<at>Value<openparen>DBOperation<closeparen>I've changed the AtrributeCreator to Conditional Value which seems to be happier.Has anyone else had this experience?

Hello,Is possible to inform or write jpeg_exif_xresolution and jpeg_exif_yresolution header in a jpg image created with FME Server?Thanks in advance 

Hello all FME User`s,I created a Workspace that split a attribute and create a List of attribute.My attribute: C:\\Temp_FME ENC 50124_012.zip\\50124_012.zip If take a look my Workspace the transformer ListSearch founded a wtong list attribute.My goal that i want to take: Attached my Workspace.Thanks in Advance,

I have read this: https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.htmlAnd tried to fix it with all these steps, with no luck. UPDATE: With respect to workspaces these was updated from FME Server 2015.1.3.1 - Build 15573 - win64 to FME Server 2016.1.2.1 - Build 16674 - win642017-01-24 20:12:10|   0.1|  0.0|INFORM|FME Configuration: Using Named Connection values from 'XXX' for MSSQL_ADO_12017-01-24 20:12:10|   0.1|  0.0|INFORM|Creating reader for format: Microsoft SQL Server Non-Spatial2017-01-24 20:12:10|   0.1|  0.0|INFORM|Trying to find a DYNAMIC plugin for reader named `MSSQL_ADO'2017-01-24 20:12:10|   0.1|  0.0|INFORM|FME API version of module 'MSSQL_ADO' matches current internal version (3.8 20160224)2017-01-24 20:12:10|   0.1|  0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Read 2 DEF line(s).  Found 9 attribute(s)2017-01-24 20:12:10|   0.1|  0.0|INFORM|Microsoft SQL Server Non-Spatial Reader: Opening `XXX' for read operation2017-01-

Hi I am trying to use a regular expression to split an address. It sounds relatively simple but I keep getting caught out on some of the address inputs:Here are the scenarios. So I want to split the address after the - but in these scenarios I might have a range like the second one or there might be a space after the name or there might not.On Gas Limited- 37 Hunua RoadIxom Operations Pty Limited - 135-147 Waterloo Road