Authoring

Has anybody tried to update specific attributes to an existing table?  I want to update a few attributes without changing the structure of my table.  Ex: I have an existing Hydrants feature class (GeoMedia SQL database) and I add 5 new hydrants to my workspace.  I update the Neighbourhood and Mapsheet attributes they are located in using the PointOnAreaOverlayer.  The only problem is i'm reading and writing to the same Feature .....this in return doubles my amount of records or overwirtes (drops) my table completely...    Bottom line is, can FME Read AND Write to the same feature class without changing the output name / structure of the table?     

Hello, I have an ESRI Geodatabase Reader using a WHERE clause (Parameters / Advanced / .. that works good. Now I like to import Feature Types to perform the same query.  Unforunately the Where Clause needs the feature class name in the sub-query:  (ATTR1, ATTRDATE) IN (SELECT ATTR1, MAX(ATTRDATE) FROM SDE.FCNAME GROUP BY ATTR1)  So my question is: is there a way to set the where clause on the Feature Type level instead of the Reader level? Or is there a way to replace the feature class name with a variable/link that points to the appropriate Feature Type?  I appreciate any hint klaus

Hi there,    Simply renaming a value is quite easy using the AttributeValueMapper, however, I'm completely stumped as to how I should go about this when the source value are dynamic.    To get into details:    What I need is very basic. For example, If I have a value like "ROAD" I want to rename that value (and all other present values) to something like "ROAD_X". So I simply want to add the suffix, "_X" to the existing value.    This would be simple if my source was not dynamic, in the sense that it simply points to a folder, and whatever's in there gets run through the workspace.    So, is it possible to add "_X" or something similair to an unknown value with ValueMapper, or any other transformer?    Thanks in advance,  

Hi there,  Slightly odd question that I think I know the anwser to but thought I'd just see if anyone out there has any bright ideas.  We have reader file that undergoes some transformations through a workspace, but what the customer wants to be able to do at the end of the workbench is bascially rename the file based on a new filename that has been generated through the process (but not modify the file in any way).  Is there anyway to do this?    I'm guessing not and already using AttributeFileWriter to write the name of the file out to a simple text file where I can wrap the workbench call up in a batch file where I can write some simple code to do the renaming there.  But if anyone can suggest a better way I'd love to hear it!  Cheers  Dan

I have just downloaded FME 2014, when I edit the reader feature type properties and de-select the exposed user attributes, they still come through in the workbench.

In regards to Linked Looping Custom Transformers, is there a way for Variables to persist through iterations? Currently the Global Variables persist per feature even though FME seems to process a single iteration at a time rather than perform all iterations for a single feature before going to the next feature.  What i'm seeing is: Iteration 1: 1st feature goes in, global variable set to a. Needs to be looped. 2nd feature goes in, variable appended to a, b. Needs to be looped. 3rd feature goes in, variable appended to a, b, c. Needs to be looped  Iteration 2:  1st feature goes through loop, yet variable's value is a. 2nd feature goes through loop, its variable value is b.  This is likely following the flow of features yet the log file is extremely confusing as it shows the processing via iterations rather than tracing a single feature through all iterations.   

Has the option to update a reader changed in FME2014? Is it now part of a different component on the reader right-click context menu?  The 'Edit source FileFormat location'  option doesn't seem to re-read the file, just change source path.  Any ideas?  Thanks, Simon

Hi,  i just noticed that if i have more than one writer in my workspace and choose only the output of one for the DataDownload- or DataStreaming-Service only this output gets written to FME_SERVER_DEST_DIR. The other writers write their output to the default, in the workspace file configured path. How do I avoid conflicting file access with concurrent user session for such a workspace? I need a unique filepath for a temporary file in my workspace which should not be included in the download/streaming output. I could use a private python parameter which generates a filename (e.g. with a timestamp) or i could perhaps utilize the UUIDGenerator to achive unique filenames... Or I could use the FME_SERVER_DEST_DIR parameter and extract the unique part of it to use it e.g. in %TEMP%.  But perhaps FME Server has some variable/function i could use directly?

I've run into some incompatibilities between the Desktop edition I'm developing on (2013 SP4 build 13547) and the server I'm deploying to (2013 SP3 build 13528). I was hoping someone could point me to a desktop copy of build 13528.  Thanks!

I have connection details to connect a Sybase DB an I try to figure out how to connect using the ODBC 3.x reader. I have no knowledge about ODBC. so my question is, what do I have to type in the Database field of the ODBC 3.x Parameter window. I have a username and pwd, and my connection details are similar to the following  Default DB: db_prod Server Name: MONUM99 DBMS: Sybase ASE  Any hint is appreciated 

Hi,  Iam attempting to write data using dynaminc schema in a workspace, it fails with the following warning:  Unexpected execution path. Please contact Safe Software A fatal error has occurred. Check the logfile above for details ... Last line repeated 2 times ...  I am writing to ESRI geodatabase feature classes. When i disable the writers and run the workspace, everything works as it should do. I have used dynamic schema before succesfully and have tried many different variations of parameter setting but to no avail.  Any help much appreciated!  Thanks,  Chris.

I have a workspace that uses the TwitterStatusFetcher to search one of our Corporate twitter accounts for Winter Gritting notices. This transformer has suddenly stopped working as of Jan 15th. Is this anything to do with Twitter restricting access to SSL/TLS traffic? Using FME 2013 at the moment but will upgrade to 2014 in the coming days.

I need to merge two files (excel). I want to retain the common fields, but I want to remove duplicates, but also flag the data sources.  So for Example I have:  Readers File A Name, Postcode, DOB Bob, NG1 1AA, 01/01/1970  File B Name, Postcode, DOB John, SW1 1AA, 01/01/1980  Writers File C Name, Postcode, DOB, FileAFlag, FileBFlag Bob, NG1 1AA, 01/01/1970, Yes, No John, SW1 1AA, 01/01/1980, No, Yes  I can merge the File A and B , simply by using 2 AttributeCreators and 1 AttributeKeeper and a Writer.   ------------------------------------------  The problem starts where I have duplicate entries and want to merge the data. See below:  Readers File A Name, Postcode, DOB Bob, NG1 1AA, 01/01/1970  File B Name, Postcode, DOB Bob, NG1 1AA, 01/01/1970  

Hello,  I have an xml file such as :  <Content>     <a n="test1">value1</a>     <a n="test2">value2</a>     <a n="test3">value3</a> ... </Content>  i am trying to read this content with an xfmap script ( through an XMLFeatureMapper) I want to create a Feature by "a" element with : - an attribute named "name" -> the value of the attribute "n" - an attribute named "value" ->   the value of the element "a"  I was hoping to make this like :  <?xml version="1.0"?> <xfMap>  <feature-map multi-feature-construction="true">     <mapping match="a">        <feature-type> <literal expr="Content"/> </feature-type>     </mappi

I have a workspace that reads a table and then outputs a map per polygon feature using a fanout on the writer. This relies on there being an attribute called Name with unique values within the source table.    I'm trying to make this a bit more robust and catering for situations where an attribute called Name might not exist (e.g. it's actually NAME or name)    I can use a Schema_mapper to rename NAME and name to Name but this doesn't cater for the situations where the unique field is called _name or even ID :-)    What I'd really like to be able to do is get the user to type the field name to be used to fanout when selecting the source input but I can't figure out if this is possible. Any ideas?

How would I find the nearest neighbor feature that has the same ID attribute as the base feature?  Ex: All line features (candidate) have a unique ID. All point features (base) have a matching ID to the line features, but are not necessarily in close proximity to each other. In the output, the points should have a relationship with the line of the same ID.   Thanks

Hi,   Any alternates for Select by Attributes ??

I have a list of counties in Georgia with their corresponding FIPS code (13xxx) where 13 is the state fips for Georgia. Each county FGDB has a a parcel and point feature class and they are named by State Code (GA), FIPS code (xxx) followed by undescore and either point or parcel as suffix. I'm consolidating all feature types from each county FGDB into one state FGDB. All the features on the reader will  pass through a FeatureTypeFilter transformer so that each feature type will be copied into the new FGDB. However, instead of the original name (GAxxx_point or GAxxx_parcel), I'd like to use the county name followed by the parcel or point suffix and some other prefix. Without renaming each feature type in the writer, I'd like to use my county/FIPS code list to name each feature type dynamically. Any suggestions?

Hi all, a good comming year of course.  I have a question concerning conditional attributing. In this case it concerns the attributesetter.  I have a dem raster to wich i added a pallete. I do a conditional setting to change the colors (kind of a colorrange) adn create a new colormap. test if _matched_parts{0} between 0,10 outputvalue @Value(_bandnr{0}) 73,255,255 elseif etc.etc. This results in a error.  If i do this same in an attributevaluemapper i get the same error.  When i do the test in a testfilter and connect a attributecreator with the same tests and outputs it works. ( i do have to remove the evaluation in the attributesetter, else it will try to evaluate "@Value(_bandnr{0}) 73,255,255" wich is a simple concatenation.) This is not desirable because i get a lot of transformers.  Am i correct to assume that the valuemapper and conditionalsette

I run FME Server and created a workspace yesterday to process OS AddressBase csv files. I kicked the process off yesterday and left it running when I went home.  This morning when I came in my PC had rebooted (and lost the connection to the Server). I logged back on to the Server and started FME. I opened my Address workspace to see how it had got on - the workspace was blank - no transformers, no readers, no nuffink.  The folder where my Workspace was saved contains 3 files ...  (a) the Workspace fmw which still has everything in it (if you open in Notepad),  (b) the log from yesterday which showed the process ran OK and finished after an hour.  (c) a recover file which contains  <?xml version="1.0" encoding="windows-1252" ?> <RECOVERY_FILE HWND="65876" COMPUTER_NAME="GISBUILD" USER_NAME="mitcheli$">   <UNDO_STATE FILE=&quot

Hi there,  I have a set of large CSVs (without a Header for attrib names) with a variety of different record types distinguished by the value of the first column ... so I would expect to use a TestFilter to split into their separate feature types - Type A, Type B, and so on.  Once I've isolated these different feature types I want to rename the attributes (by default they'll be Col0, Col1, etc.). The attrib schemas are different for different feature types.  I have a set of header files, each a single line, one per feature type ... which contain the attribute names. - Col0 in the TypeA-Header file contains the new name of Col0 for TypeA features from the big CSVs.  Is there a transformer I can use ... rename the attribs of this feature type using the values of the attribs in this line of this file - one column at a time?  I know I could use the SchemaMapper but that'd involved editing my header files. Jus

I tr to execute the following arcpy function from a fme workbench:  arcpy.CalculatePolygonMainAngle_cartography("FeatureLayer", "poly_angle")  from the PythonCaller transformer to calculate a polygons main angle. What I can't really understand (as my python skills are absolute nonexisting) is how to wrap than inside the template function interface. I have tried to integrate the arcpy- function like this:  --- import fmeobjects import arcpy  def angleFeature(feature):     ang = arcpy.CalculatePolygonMainAngle_cartography("FeatureLayer", "angle")     feature.setAttribute("angle", ang) --  but when trying to run the workbench I get the following error  ERROR 000732: Input Features: Dataset FeatureLayer does not exist or is not supported  so Im stuck with the problem that the function cant find my source (

Hi  I have a project that converts a GML file into 6 individual shapefiles. I have mapped all the attributes from the GML file to different names in the shapefile in order to comply with the 10 character limit e.g -  featurecode > featcode versiondate > date  Now I want to name the shapefile dynamically from a publish parameter so I used the attribute creator to create a new attribute called "feature_name" with the value:  $(name)_TopographicArea  and this outputs a shapefile with the correct name. so far so good......  The problem is the shapefile now contains multiple additional attributes that I didn't select or want in the resulting shapefile. How do i retain the schema mappings that I made?  Any ideas?  Mike  

Hi FME'ers,   I have some base features, and candidate features from another data set, sent through the SpatialRelator (Equal, Within).   For the base features that failed these spatial relations, I do a Densification. Together with a densification of the candidate features, I send the features through the anchored snapper, with which I can improve my results with a second SpatialRelator.  However, sometimes the first SpatialRelator has no features in the failed port (all the objects have been found). In this case, I don't want to carry out the Densification because there won't be any candidate feature for the AnchoredSnapper. This extra processing time is not necessary.  How can I start the densification ONLY if there are features in the Failed Output port of the SpatialRelator? I tried to solve this with a variable, but it didn't work out. Or should I try harder? The only use case I found, was 

Hi all    A short introduction to my script so far: I have two readers     a. NewsArticle (s stands for source)  ID-S   |   Text     |    Country_S     |      Sector_S  1.              ...  ...               ...  30             ...    b. Shapefiles of all different sectors  ID-dB   |   Sector_dB  |   Country_dB  |     1.               ....   ...              ....  30000    .....    The mail goal is to assign the different Newsarticles to the correct sector (in order to map the news). I am doing this by an inlinequery that Takashi suggested. This query's output are all the articles that are both matched by country as by sector. (lets say 14 out of the 30 articles).  I would now like to use the rest of the articles (that have not been assigned to a specific sector) to be linked at the country level. I have a shapefile of all the countries.