Authoring

Hello all,  I wanted to create a data naming tool in FME, essentially I have a list of values (currently in a SharePoint list but could feasibly be moved to a SQL Server table if required).  For each section of my data naming tool I want to look up the user friendly term in my table using a drop down list control in FME (e.g. Look up the value "United Kingdom") and return the coded value (e.g. UNK).  This would be done for 54 category items to create something like: "UNK_01_M2_SE_HealthCentres_20140529.shp”  The first four items are the returned coded values for the drop down list items, the text in the middle (HealthCentres) is a free text field, and finally the date is system generated.  The sticking point I have is that the values the user chooses from the drop down list must be dynamic as this list will constantly be updated.  Does it sound feasible?  If so what transformers would get me on the right track?  Regards,  Kevin

Hi All,   I was wondering if it Is possible to connect to a Oracle Non-spatial database without having the Service name set up in the tnsnames.ora file?  I'm using a Esri ArcSDE reader in my workbench so I am trying to use the same parameters to keep it simple to deploying on another machine.   Thanks

Can someone tell me where the snap to grid and view grid functionality in Workbench 2013 was relocated to?  It's not under "View" anymore.

Hi there,  I'd like to use the folder name of the location of my shapefiles as a attribute value. I've exposed fme_dataset t provide me with: C:\\Deployment\\FME Workspaces\\Stats\\April\\Network.shp  It's just a simple xls writer, with a "Source" attribute I created. All I want populated in the "Source" attribute is "April" or whatever else the base folder where the shapefiles are located is named.   Thanks in advance,

Hello,   how do you batch process two readers?  eg; I have 30 very large shapefiles that I want to analyse against a tiled grid.  I have one folder that has the 30 shapefiles and another folder that has a tiled grid of a certain area, about 26 tiles, tiled because of the large volume of data (it has to be tiled, no way around it).  So, how do you batch this so that shapefile 1 will be analysed against all 26 tiles and written out to it's new shapefile, then shapefile 2 will be analysed against all 26 tiles and written out to the new shapefile etc etc. Seems to be a double batching of somesort. When there was just 1 tile in the tests, the batch wizard helped but not anymore.  thanks

When I view my collada files in a text editor the geometry tags look like this:  <geometry id="Geometry1" name="building_Roof">  But when I expose the _geometry_name attribute in FME it actually contains the geometry id not the name.  I want to see the geometry name because it is more descriptive - is there any way to expose it?

I have 1 ESRI Shape polygon where each polygon has an ID which represents the object it belongs to. Some polygons belong to one object some belong to multiple objects. Each object is unique.    Geometry      ID                                                    NEW ID  1                   AAAAA                                             AAAAA-BBBBB  2                   BBBBB                                            AAAAA-BBBBB  3                   CCCCC                                           CCCCC-DDDD-EEEEE  4                   DDDDD                                           CCCCC-DDDD-EEEEE  5                   EEEEE                                            CCCCC-DDDD-EEEEE  6                   AAAAA-BBBBB                                AAAAA-BBBBB  7                   CCCCC-DDDDD                             CCCCC-DDDD-EEEEE  8                   CCCCC-DDDD-EEEEE                   CCCCC-DDDD-EEEEE  ....    I want to substitue the ID of all polygons which IDs are part of the

I created a workflow with attribute modifiers, and I can't get my output to display the updated attributes.  It will either have the input attributes, or only the first 10 letters of the correct attributes when copied from transformer.  How do I fix this?  Thank you, Courtney   

I want to include the workspace name as part of some metadata I generate   Running the workbench as a workspace the $(FME_MF_NAME) variable returns my workspace name Once I convert it to a custom transformer (CT)  this variable returns the fmx name rather than the calling fmw name  I set a published parameter to the value of the $(FME_MF_NAME)  in the CT Running as a Linked CT I get the following error   Starting translation...  Undefined macro `ArcGIS_MetaItemDescription_FME_MF_NAME' dereferenced in file `C:\\Users\\scooter\\Documents\\FME\\Transformers\\ArcGIS_MetaItemDescription.fmx' Program Terminating  Translation FAILED.   Running as an embedded CT I get the correct result   When I embed and run it using a private parameter I get the same error  Starting translation...  Undefined macro `ArcGIS_MetaItemDescription_FME_MF_NAME' dereferenced in file `C:\\Users\\scooter\\Documents\\My FME Workspaces\\wb-xlate-1399417605939_8048' Program Terminating  Translation FAILED

Hello,  I am transforming GML exported from Caris Source Editor, into GML (with coded values being translated).  In my Reader I have three feature types, which share some, but not all attributes. I use several different transformers on all of the features, then use a FeatureTypeFilter to send the records to the correct Writer Features. There are also three of these - matching the reader features.  The attribute names in the writer are different from the reader, so the attributes must be connected manually. That works okay, and the values (e.g. xml_char type attributes) will transform and appear in the destination file. So far, so good.  However, as soon as I shut the workspace and re-open it, half the connections are lost. Seemingly, the ones that are kept are the ones that appear in all three of the reader features, any that only appear in one or two of the features are lost and need to be reconnected everytime.  *Pulling my hair out here!*  Any ideas?  Thanks Dan  

We are trying to connect to Microsoft Azure SQL DB in cloud thru our client FME to transfer data.  Is it possible to connect SQL Azure with Encrypt connection option from client FME as available for SQL Server and shown in the attached screenshot.      It's critical to our deliver  can someone in FME support reply ASAP ?  Thanks & Regards  

I'm not sure if this is more a Python, FME, or Esri question...  So here's the situation - a user has a MXD document open connected to an ArcSDE database with a version.  I have a workbench to write to this database but the user doesn't want to manually type in the ArcSDE version name as a user parameter (how it's currently setup).  Instead they want what ever version they are current connected to in the MXD to be used in the workbench.    I've scraped together some Python code I've found to create a text file of the current version name for an open MXD but I'd like to use this value (or maybe instead the returned value) as a new private parameter to use in the workbench.    Two issues right now:   It lists the version name for all layers (I just want one record)  It writes to a text file    Should it just return the version name so FME can use it as a parameter?  If so, how do I do this?  Here's the code I have so far (I'm a Python novice so please bear with me!)  import arcpy, 

Hi,  I was wondering i this is intendend.  On a reader i choose to not expose certain attributes, say SetA I thought this would exclude them from further operations.  I do a comparison with another set, SetB. This set has an attribute wich should be, on passing certain conditions, passed to SetA. This attribute is one of the none-exposed in SetA., as SetA is not allowed to dictate its value. Now i found that not exposing the attribute on set A does not exclude it from the operation, it fouls up the result. Even after not exposing it, i still need to remove the attribute.  Seems somewhat uselss to me, that option to expose or not on the reader, or not ?       Gio

Hi all,  I have a wokspace that becomes suddenly very slow when editing. Making connections goes normal untill I add up a some (8x)  testers + atrubutecreators in series. So not adding up an enormeous amount of links on this point. But after adding these 16 transformers making a connection takes +30mins.  The workspace does not contain any custom transformer (as I read that this can cause similar behaviour) and the complete workspace contains +/- 200 transformers.  Any suggestions on this?  Thanks, Rob

I have a shape2shape multi function workspace that I would like to use with two datasets.  This requires multiple readers but two of them can be swapable.  That is in one instance I use reader A and not reader B and the other I use reader B and not reader A.  I could have two work spaces but it means maintaining changes on both.  So it seemed to me to be more efficien to have one and disabling/enabling the readers I want.  The question is that  the workspace seems to be opening the disabled reader along with the enabled one.  Would this affect performance if there are very many files to open?

Is there a limit of element in a list ?

Hello there,   I have some data in the following structure (with some other columns not really of interest) which needs to be represented as features with only one input into each column;    Each feature represents a polygon; there needs to be just one code under 'TYPE' and one under 'TYPEAR'. Where there are more then one code in a column, i need those to become new features (taking the UniqueID of where it came from). The corresponding positions of the code in TYPE and TYPEAR are correct (ie 1st letter goes with 1st decimal value etc)  n represents the fact that I have many files like this with many 1000s of features in each one.  So, i used AttributeSplitter for 'TYPE' and also for 'TYPEAR', splitting by the comma, creating a list for each attribute. I then used ListExploder for _listTYPE{} and _listTYPEAR{} and created a new feature based on the lists.   However, exploding by one list is all fine - eg Exploding  _listTYPE{} will create a feature for

Hi, I'm trying to create a custom transformer (2014 SP1). Unfortunately ListBuilder fails to expose _list - but it does so just fine when it's part of a regular workspace. This in turn means that later things that rely on _list can't be set up because the interface won't let me type in the list name.  If I cheat (as I have in the attached) and set it all up outside of the custom transformer and then copy it in then what happens is that I get a "incomplete transformer" warning.  I've tried using "attributeExposer" but that doesn't allow exposing of Lists as best I can tell and I can't see any other form of exposing a list inside a transformer.  So, how do I use a list I need to create within the custom transformer?

Hi!  I would like to know why the fme_feature_type attributes is removed after passing the lines features through areaBuilder transformer inserted inside a custom transformer.  Even more weird, just after areaBuilder, Im doing a FeatureMerger to restore all attributes to each feature as they were before going through some transformers, but only fme_feature_type is not passed.    Anybody may provide explanations on this? Thank you, -Max Demars

I have a simple FME 14 workspace that transforms a Sybase table into an ESRI gdb table with the option that the Writer uses the attributes from the Reader (Copy Attr. From Feature Type). all worked well.  Now I added a AttributeRenamer to change the name of some (not all) attributes. That leads to a resulting table where all (renamed and unchanged) attributes are chars with length 200.  So, how can I tell the Renamer only to re-name and not to change the data type ?  any hint is appreciated klaus

I've copied my workbench into a new ArcToolbox "FME ETL Tool" and now the Log File Workspace Parameter is no longer available.  The log files are being saved, but there doesn't seem to be a way to change the location they are saved.  To find the log, I went into ArcCatalog Options --> FME --> View Logs... which opens up the following location:  C:\\Users\\<user name>\\AppData\\Local\\Safe Software\\Interoperability\\logs  Is there a way to change the location of where these logs are saved in a FME ETL Tool?  

I have a workbench that calls 5 other workbenches (using WorkspaceRunner).  What I want to do is gather all the log files that are created after the workbenches have run and create one log that contains all info.  Ideally I want to a report of features read, written, errors, and warnings.  Not sure how to tackle this one - any thoughts on where to start?

Hi there,  Simple question really (I hope), is it possible to merge two surfaces by a common id?  I have multiple surfaces and only want 1 output, they have same id number but I can't seem to find any method of combining them into 1 feature.  I am initially using SurfaceOnSurfaceOverlayer to remove overlapping features, but then I end up with lots of surfaces, I want to then join them back together, but neither FeatureMerger, Merger or MeshMerger work.  Any suggestions?  Dan

Hello,  I want to create 3D-pipes out of 3D-polyline-shapes. So far I am able to create them by splitting the polylines into Vektors, rotating them, so they all are orientated to the Z-vektor and than create for example a circle, extrude it and rotate that pipe back to the original position. This leads to nice pipes as long as they don't have curves. Because curves leads to spaces between the pipe-segments of one polyline.  So my question: Is there a chance to draw that pipe along the whole polyline like the follow-tool in Sketchup for example, so I can get a closed pipe along a polyline?  

Hi, im having some problems with the BulkAttributeRenamer, i've read quite a few other answers and online articles bit can't seem to fix my problem;  I have a reader '2005Unique' and a writer '2005Gridded'. There is also a reader called 25kGrid, all .shp.  There are a few attributes coming from 2005Unique that I want '05' appending to the end of (for reasons of inter-year comparison further down the line). Eg Land to Land05 and Area to Area05 etc etc. Originally in my tests I simply renamed the attributes in the writer, stuck 05 on the end of them, as I was only testing data with this one year.   Now i'm coming to run the data across 5 year files, 05 to 09. I am looking to set up the dynamic schema to read each year file one by one and write them one by one but obviously i cant just leave the writer attributes with 05 as a suffix, it has to change to 06 when the 2006 stuff runs through.   So i set up a SubstringExtractor pointing at the fme_basename