Authoring

So we have an issue where the ID is being used also as the Object ID. This of course is a big problem because any database or GIS software will overwrite the ID. So to get around this I want to create an attribute in FME and then fill that with the Object ID values to preserve that number. I can create new attributes with the attribute creator but I can't find any examples or forum topics on how to call out an attribute value to fill it with. I've only seen constants or using this empty column later.

Hi,  We are currently evaluating FME Desktop in the hopes that we replace MapTiler with FME and write tiles in the same folder and naming structure that is used by MapTiler.  We are attempting to use the WebMapTiler transformer and the raster PNG writer to write a folder and file structure that is compatible with TMS which is used by our tile server. The folder structure needs to be in the format of ../ZoomLevel/X/Y with Y being the actual file name. I've been able to use the dataset fanout to get the files into folders that match the zoom level but can't figure out how to get a second fanout to the X folder. Also, it looks like the file names may not be setup the way we need.  

How do I send a Slack notification if my workspace fails? Easy to do if features are written, bot not sure how if no features make it through the feature writer.

Example:I've got a list: "_list" with as attributes _list{}.ratio.  _list{0}.ratio = 0.10_list{1}.ratio = 0.25_list{2}.ratio = 0.30And I want to add a list attribute: _list{}.ratiosum with as result:_list{0}.ratiosum = 0.10_list{1}.ratiosum = 0.35_list{1}.ratiosum = 0.65In Python I would do it like this: sumlist = [] s = 0 for i in range(len(ratio)):  s = s + ratio[i]  sumlist.append(s) But how is the relation between the python and the list in FME? This doesn't work:def processFeature(feature):    s = 0    for i in range(len(feature.getAttribute{'_list{}'));        s = s + ratio[i]        feature.setAttribute('_list{%d}.ratiosum' % i, s)      This gives an syntax error; it is not possible to get the length of the list with the len() function? 

@david_r @takashi @erik_jan

Dear FME community,I have an attribute from an WFS which has values of more than 200 chars. I want to trim down the length of that attribute because my database only allows for a specific length. Is there a way to "cut" the attribute after a specific length so that it doesen't exeed for example 200 chars. The values after that can be ignored (only the first 200 signs should be taken).Many thanks for your help and kind regardsThomas

Hello,I've got a workspace. When i open this workspace i get a fault. So, I can't read the whole workbench. I am missing a few transformers. Is t possible to view this workbench in a way to see how it's bild?

Hello,I have a shapefile with approximately 200 tiles that contains an attribute value for each (e.g. 52A, 52B...). I am trying to output the data where each individual tile or attribute is applied with a SpatialFilter (contains and touches). The only way I know going about it is by using a Tester and changing the values manually each time I run the workspace. I know a loop can be applied to the workspace but I couldn't find any guidance or documentation on dealing with this. Thank you,

Hi, I would like to create a new custom FME function similar to current "UUID()" function. I have successfully built and tested the "CenterOfMass" C++ sample of the SDK "pluginbuilder" folder.But I have a few questions:The function only works when it is copied in the "plugins" folder. It does not run when it is copied in a "Shared FME transformer" folder. Can I configure it? It is an issue when we have not write-privileges in this folder.The new function is not recognized in the "Attribute Editor Form" as a valid function (Other functions provided by FME have blue color). Can I configure it? Also, I would like to define its syntax and parameters. Is it possible?Possibly related with last question, To successfully run the function I must write &q

I'm trying to store the sysdate to an oracle database table; i have already acquired the system date by Timestamper with format "FME Date/Time (^Y^m^d^H^M^S)" and setting my attribute. I get an error when the process is trying to wrtite this attribute to the oracle table. Do I need to use some transformer or oracle string conversion function ? (like to_date('@mysysdate', 'YYYYMMDD')thanks in advance

Whenever I set a workflow to 'Dynamic Schema' all the feature type names in the destination schema differ from the source schema. The geometry type name gets attached to the feature type name. Example: -Isohypsen ->Isohypsen_line-Schutzgebiete -> Schutzgebiete_polygonHow can I prevent this from happening? I want the feature type name unchanged (obviously)

Hi,I want to run a script several times. Every time the input data changes. I thought, this could nicely be done by triggering FME by means of a commandline batch. However, when i start the batch, only the dataset which is connected within the workbench is used. It seems, as if the sourcedatasets from the command lines are ignored. The parameters I have copied from the first lines in the log window. I have simplified the attached workbench to the key issue of importing and writing a shape file. Also attached you find the batch file and some data.Any ideas?

how would i alter a workspace to export files as they are finished rather than holding them all in memory / temp files until everything is processed?the input is about 200gb of Mapinfo files so this is taxing my system quite a bit. FME seems to not write anything until its completely gone through all the files.I have a feature reader that processes all the *.tab files in a folder and clips them where they intersect an input polygon it then saves the files into an identical folder / name structure.FME 2016 ESRI Edition - 16gb ram i7 4790k

I currently have a workspace that determines a file location, and then a workspace runner uses this as the source parameter for the 'child' workspace.If I run the child workbench in isolation, I can specify multiple file locations and both source files are read.e.g. "D:\\Folder1\\File1.gz","D:\\Folder2\\File2.gz"But if I try to use this as a parameter for the workspace runner, no output is read. Is there a different syntax I should be using within the workspace runner?

Morning All,Im trying to select the top two attribute names(calculated by largest values in attributes) of 6 attributes.. i have 6 attributes which contain a number (0-5), This number is then multiplied by a weighting (1-5)depending on the attribute. I do all this in an expression evaluator , ie attribute 1 x3, attribute 2x 5, attribute 3x 2, etc etc. My expression evaluator sums all these attributes to get a total score, excellent. I now need to know which 2 attributes (1-6 ) make up the largest portion of the total score.I have tried with listPopulator for the 6 attributes, then a listsorter, then attributecreator (@Value(_list{0}),@Value(_list{1})). This however returns the original attribute value, not the attribute name..... Any help/suggestions appreciated. thanks steve

I'm attempting to perform some transformations on an ESRI shapefile in FME and am running into some issues. The attributes within the shapefile are all in Spanish. When I export back out to ESRI shapefile, it is not retaining the shapefiles' originally encoded language properties, instead inserting incorrect special characters. Here is a view of the shapefile attributes table in ArcCatalog: Here is a view of the shapefile through FME Inspector: As you can see, FME does not seem to recognize Spanish characters. It hasn't been a problem for us when writing from shapefile directly into our Microsoft SQL database- we just updated user attribute types in the writer from varchar to nvarchar and it handled the character encoding issue pe

Dear Support Team, Require your assistance on the below issue. Unable to connect to the floating licence server. Suddenly i lost connection with FME Server. It is unable to established connection. Below error it is showing.Please advise if I am missing something. Or how would I resolve this issue. Thanks in advance for your help.

I received a text file that has descriptions about features as follows: ADD FUSE 9911 { PHASES =1; PORT_A = <123>; PORT_B = <234>; ATTRIBUTE[county] = "SEATTLE"; ATTRIBUTE[street] = "MAIN ST"; ATTRIBUTE[facility_id] = "1324"; ATTRIBUTE[feeder_id_1] = "FD1"; ATTRIBUTE[feeder_id_2] = "Null"; }; ADD 1p_conductor 125623 { ... }; Now, how to create individual features out of these? 1. I tried Aggregator: groupby - text_line_data Separator character: }; 2. Tried to loop text_line_data and break whenever "};" is encountered. But both didn't work. Is there a simple way to do this?

Dear all,  Has anyone tried versioning FME workspaces with a versioning software such as TFS? If yes, how did it go? Did you experience any issue?  Thanks in advance,  Maryse

Hi all,Am I right or since FME2016, we cannot anymore create "Named Database Connections" using FME2015 naming convention?I remember that the connection name was automatically define as:user@server:port/databaseSo now on fresh install of FME2016, I cannot set my previous define named connections because chars : and / are no more allowed. So I need to adapt all my scripts or there is a magic trick somewhere?Thanks for any infos and best regards.Rémi

I have an issue where a dynamic workspace working with hundreds of data sets needs to be able to expose fields if they are DateTime. Due to the sheer number of datasets and fields I don't really wish to hard-code this into the workspace. I was hoping there was a way to expose fields when they are a particular datatype, in this case DateTime. The reason that I need to expose them is due to json not having the ability to write out DateTime fields correctly, they need to be converted to strings using the dateformatter. The workspace is dynamic and may open hundreds of datatypes depending on the parameters coming in. I don't want to have to hard code but I am thinking I might need to expose all the relevant fields within the FeatureReader, I am using FME 2015.1.The date formater works fine but the attributes must be exposed to be able to select them within the transformer. Thanks in advance!

Hello,I need to analyse a number of polygons which represent buildings, the data i need is the inner corner of every point and the length of every segment. I'm using the polylineanalyzer to get this data and this works as long as the polygon is a solitary object. If another polygon is adjacent to the one being examined it seems that the common lines are being kept out of the examination in the polylineanalyzer. The number of lines which flow out of the polylineanalyzer are less than the total number of polygonsegments.Has anyone an idea how to bypass this? best regards & thanks

I have selected certain features from a table based on a certain attribute value. From another table I have done a selection as well to get only one specific feature. Now I would like to add the attributes and their value of the feature of the second table to all the selected features of the first table. I can not use the Featuremerger because the features of both tables don't have any attributes in common.

So i have a workspace that - imports all ascii grid files in a directory  - does a raster to point conversion (RasterCellCoercer) - offsets points by half cell size - so point at cell center rather than lower left corner (OffSetter) - adds XYZ attributes (AttributeCreator) - Finally writes to MapInfo Tab filesby default FME seems to import all my ascii files and hold everything in memory before committing the outputs. so my model is a RAM hog.How can i adapt the model so each ascii tile goes through the process one after another which should need significantly less RAM.

Hello, I hope someone can help me with this (i think simple) question. For my study I need to Data Interoperability extension in ArcGIS. The objective is to create a 5 kilometer or 5000 meters buffer around a cycle route in Europe. I must create this buffer with a spatial ETL tool in the FME workbench. In the workbench I cannot find where I can set the unit settings to meters or kilometers. Where can I set the unit settings to meter or Kilometer? Thanks in advance.