Authoring

Hello everyone,  I have a question about FME behaviour. I am writing a custom SQL Spatial writer and managed to get it working (for inserts, updates and deletes are in the making), but there are some aspects of how my writer's methods are called that I can't get my head around.    Since it is a database writer I would have expected to see the startTransaction and commitTransaction methods getting called at some point, but this doesn't happen. I expected that specifying a writer type of DATABASE in the .db file would tell the FME what methods to call, but clearly my understanding of this isn't quite right. Can anyone out there shed some light on this for me?    Any tipps/ideas would be much appreciated.  Cheers, Jan

When using Dataset Fanout, writing to File Geodatabase formats, is it possible to update existing geodatabases in the output rather than create new ones?  I have some national datasets and some polygons that define regions of the country. I want to split the national datasets into separate file geodatabases, one for each region, each containing the relevant parts of the input datasets for that region.  I've set this up with a single Reader, bringing in the region polygons. For each of the national datasets there is a FeatureReader to spatially select the features and the output of each of those goes to a separate output feature type. All the outputs are on a single geodatabase writer, which has Fanout Dataset selected to write the results from each input region into a separate geodatabase.  This works fine. However now I have some additional input datasets that I would like to split by region and save into those same geodatabases. How can I add the new feature classes into the same

Hi FMEers Hopefully this is an easy question for someone to answer. I've got a workbench that dynamically reads WFS and output a selected feature type to a file geodatabase.  I'd like to extract some fme attributes from the input data (such as fme_coordinate_system).  I know that you can use the attribute exposer transformer or expose some of the fme attributes in the the reader but I can't figure out how to get the coordinate system (not set at runtime - read from WFS by the reader) into an attribute. Does anyone know how to do this? Thanks Rob

Hello FMERS, We are planning to move from using batch files for error checking the daily FME workbench's log files for success or failure.  Ideally we would like to write workbench parameters to the PostGreSQL database which then could be interrogated by another script  Does anyone have an example of a Python Shutdown script which  uses a PostGreSQL writer to add parameters such as FME_STATUS / data time into a PostGreSQL table.  Regards Andrew       

We are moving away from connecting to SDE via a 3-Tier connection type to a direct connection type.  We have several hundred workspaces with connections to SDE with the 3-Tier.  I was wondering if anyone has wrote a script or know of an easy way to do change the parameters in how it connects in some type of batch process so we don't have to edit and touch each one of our workspaces manually.  Any advice or asiistance would be appreciated.  Thanks Travis

Is it possible to expose the field aliases from a file geodatabase or personal gdb?

Hi,  I'm searching for a solution in fme. I have huge set of points, representing cell towers. Now I want to generate a complete network, where all towers are connected. The final result should look like a spiderweb.  Any ideas how to deal with this? 

I have a set of shapefiles.  For each project, the shapefile names and the attribution names of the shapefiles are different.  I want a workbench to search the attribution of all shapefiles, for a particular word/term.  For discussion purposes, say I want to find the word 'password'.  I don't really need to do anything with the data, I just need to determine if the 'password' exists in the data anywhere.   I've played around with Schema readers and Feature readers, but haven't found a solution yet.  It's almost like I need a way to rename the attribution names to something generic like 'att1', 'att2', 'att3', etc...so that I can run a simple testfilter.  But with the attribution names changing with each dataset, I'm not sure how this would be accomplished.

Any way to get the CAT-reader to display its fme_basename?

Hi,  FMW has been encrypted by adding a password, then I deleted the password and saved, at the same moment I opened the fmw and found it was still encrypted.  Then I closed the workbench, I cann't reopen the fmw, because I can't input an "NULL" password.

Is there a way that parameters can dynamically change based on other published parameters?  For example the initial parameter could be 'AssetType' the choices would be Water, Sewer, Drainage... then the second parameter would be 'Location' and depending on what was selected as AssetType this list would be different.  The only way I can think of at the moment is to have 2 parameters called 'SewerLocation' and 'WaterLocation' with different values available, it would be preferable if there was a better way.

Hi, I am attempting to create a workspace that requires a dynamic schema based on most attributes from 1 SHP file plus a couple of attributes from another SHP file.  I will be intersecting the 2 SHP files using a SpatialFilter.  And I want to output a SHP file with all but 1 of the attributes from SHP file A (always the same one) plus one or more of the attributes from SHP file B (these will be input as a comma-separated list in a published text parameter).  I have gone through all of the examples I could find, including the ones with workspace resource readers and custom formats and Python scripts, but I can't for the life of me get them to work!  Any insight into what my workspace should look like would be greatly appreciated!

I would like to do a  feature merge using the address fields in two tables. One address has the format of:  123 MAIN ST  The other table has the format of:  123 MAIN STREET VANCOUVER  I know that I can change the first to be exactly the same as the second, but then I have to do the same with  123 W 1ST AV  1323 W 1ST AVENUE VANCOUVER  ...etc.   Is there a way to do an SQL-like "IN" for the merge? That is, to merge where the first address is IN the second?  Thanks   

I'm having difficulty understanding how to access attributes within a custom transformer.   I have a workflow that takes two sets of input features, call them sources and candidates. Each has a unique ID field, call them SOURCE_ID and CAND_ID.  I want to spatially match the features from one set (the candidates) against the features from the other set (the sources), determining the source feature that the greatest proportion of the candidate feature is closest to.  So each candidate feature is split into points (vertices) and each vertex is matched to the nearest source with a Neighbour Finder. Then I summarise to find what proportion of each candidate was matched to each source. So that uses a ListBuilder, grouping by CAND_ID, and a ListHistogrammer to find out how many vertices in each candidate were matched to each SOURCE_ID.  This all works, but now I want to put it into a custom transformer. Within that I need to access the value of the CAND_ID field, to put as the Group By in

I'm very busy today and need FME training...;-) I have three feature classes in feature class A and feature class B i have features which have an attribute STAU_ID the features which belongs together have the same STAU_ID but i have to split it in two feature classes because of geometric conditions. Now i want to take the feature with STAU_ID = 1 from feature class A and intersect it with feature class C. The lines from feature class C which are in the result i intersect then with the feature from feature class B which have the STAU_ID = 1....that in one workflow    The i want a loop to do it with the features from feature class A and B which have STAU_ID = 2 and so on snd so on   I have to do in that way because features from feature class C can intersect more features from feature class A and B with different STAU_IDs ...but i want to set the attribute STAU_ID then to the features from feature class C....so i have to do a loop    So whats the perfect way to do this

I have two line features which contains hundreds of lines...but some of them have the same ID's.....i will create a polygon with lines which have the same ID's....i know easy question, best way?

Hello,  I have a workspace, where I read data from a non-spatial and a spatial database. I write the data to a dynamic schema into an Esri file geodatabase.  The workspace runs fine, when I start it with FME, but it doesn't write any data to the geodatabase,  if i call the same workspace with a batch file.  What can be the problem?  Thank you for your help.  Isabell

Hi:  What would be a work around to filter the features in the FFS reader, similar to other data readers that have the WHERE Clause parameter?

Hi all,  I know this is a simple question, but I can't get it to work for some reason.  I want to take polygons that all have an School_ID and filter out the ones that have an ID not equal to 0...  I'm trying to use an AttributeFilter, but can't get it to work...  I have set the "Attribute to Filter By" to the SCHOOL_ID column.  ...and set a "possible attribute value" to various values, including <> 0, <> "0", > 1, etc. to no avail.  I can get the tool to work if I set a possible value to a valid SCHOOL_ID, such as 263...then the resulting feature class has only that 1 feature in it.  Any thoughts appreciated!  Thanks,  -mb

Hi,  I cant find a way to expose format attributes on multiple inputfeatures.  I got a load of inputfeatures for wich i wish to expose ie 'fme_feature_type' There is no provision for this??? 1 by 1 is like..a lot of tedious clicking.  It would be nice if there would be. (i am still on 2012 version btw)

I have 2 ESRI Shape polygon datasets, which should be combined and exchange attributes. The first shows boundaries of some hundred property units, the second shows some thousand mapped features inside. The task is to summarize the area values of all mapped features included in each property unit and add the result to a new property unit shapefile.  INSIDEPOINT_REPLACER for the mapped features and POINT_ON_AREA_OVERLAYER / FEATURE_MERGER followed by AGGREGATOR works well one-to-one basis as long as I have no overlapping property units.  Now I need a good idea to do the same with overlapping property units, mean to collect the mapped features more than one time. Thanks for any ideas / help.  

Hi, I have a doubt about FME. I have a reader that reads a .mdb Geomedia , and a Writer to put the .mdb data into an Oracle Database. The problem is: I have to create in the writer manually , all the attributes that I want to see in the oracle. I would like to know if there is a way to make this dynamicly. Without going into the writer and typing all the information. I want the same attributes from the reader in the writer without typing the information. Is there some way?   

Hello,  I would like to have a parameter that is set from data that is sent to it from a webpage. When you create a parameter the prompt asks for a prompt. I am not sure what to set here. I need to have the pararmenter look at the data sent from the web page and set that so a creator can use it to set parameters. I am fairly new to FME also so any help would be great thanks. 

FMEpedia article - "Extracting a schema subset for dynamic schemas" was very helpful when I challenged this question: Dynamic schema partial merge from 2 data sources   However, the article doesn't seem to be enough in the current FME, I hope the article will be updated. In the meantime, I'll share two things I got from my experiences with you.   1. Python script The script in the article doesn't work in FME 2013 SP3, because it uses old "pyfme" module. I tested the method described in the article with this script:  -----  # Example for "Extracting a schema subset for dynamic schemas" import fmeobjects   def keep_defs(feature):     att_name_list = feature.getAttribute('attribute{}.name')     att_ntype_list = feature.getAttribute('attribute{}.native_data_type')     att_ftype_list = feature.getAttribute('attribute{}.fme_data_type')     to_keep_values = feature.getAttribute('

Sorry - this might be simplistic, but I'm trying to run fme from a command line providing a file with a workbench and a parameter specifying the search envelope to use when reading features.  My command file named cnp.cmd and contains this:  C:\\\\Projects\\\\FMEWorkbenchOutput\\\\test.fmw \\\\ --GEODATABASE_FILE_SEARCH_ENVELOPE 102991123 -5143701 103346900 -51186100  when I execute fme with:  fme COMMAND_LINE cmp.cmd  it executes the workbench (which exports data from an ArcGIS file geodatabase to an AutoCAD drawing) but it does not recognize the search envelope.   Any suggestions would be greatly appreciated.  Thanks, Ed