Authoring

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 th

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 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{}.

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    

Hi guys -  I am still having an issue with my Dynamic Schema workbench working correctly with polygons.  I have finally worked out it is not the workbench itself that has the problem, but my custom-built transformer.  The transformer is a reprojection transformer and when dealing with polygons it actually GeometryCoercer's the polygons into lines to do the projection, then converts them back to polygons.  I believe that this is why when I run my Dynamic Schema workbench on a shapefile polygon, it comes up with the "Features with no schema defined" error.   My question is - is there a way to get the Dynamic Schema function to work, without altering the transformer??  How do I get FME to remember the schema of the polygons before they went through the transformer??  Thankyou

I an reading a feature table having 3 string columns say a,b,c and column X from another feature. Columns a,b,c holds string value(nullable). X has value like "Concat(Concat(a,b),c)". I need to derive final string without running sqlexecutor.  Please let me know how to solve this.  Thanks. Subrat

Hi Guys    I currently have a Dynamic Schema workbench with a custom-built reprojection transformer along with the following transformers that are allowing me to rename the output files and place them in a new relative folder structure: FilenamePartExtractor, StringReplacer and StringConcatenator.    The workbench works correctly on my first lot of files which are quite small in size, but when it comes up against files that are 100MB to 700MB in size, it says "ResourceManager: Optimizing Memory Usage" and stalls, and eventually crashes with a "Fatal Error" and other messages relating to memory.     I have tried writing to a different network drive from the input files, and have also purged my temporary files, but neither has helped.     My custom-built reprojection transformer is very complex and I am guessing that this may be causing the memory problem on the large files, but am wondering if using Dyn

Hi  I have a workspace with Dynamic Schemas which I ran on 5 datasets all which have the same schema.  However, when I tried to run the same workspace on a new set of data which have different schema, it would not work because the Feature Type was still set to one of the previous files.  I cannot work out how to change the Feature Type, or disable it so that it allows for all feature types - otherwise this is defeating the purpose of using Dynamic Schema!  Thanks 

Hi  I am using Dynamic Schema to translate a large number of shapefiles from one coordinate system to another, but keeping the same schema.   I am able to do this successfully however I cannot work out how to suffix each translated shapefile so as to differentiate the translated files from the non-translated files.  I have tried setting the Fanout Parameter to Yes, but it only suffixes the folder with the translated files, not the actual shapefiles themselves.  Does anyone know how to do this?  Thankyou