Authoring

  Hello,    In our company exists a forest-wide UPN suffix company.it and almost all user accounts have the explicit UPN set to fistname.lastname@company.it. This value is also set in the Active Directory userPrincipalName attribute.   Now we have configured the fme server (FME Server version is FME Server 2013 SP4 - Build 13547 - win64) to perform IWA (SSO), so users authenticate through Kerberos.  Since we are given the Kerberos principal, i.e. implicit UPN (sAMAccountName@company.it), which does not match anymore with the userPrincipalName (explicit UPN), the IWA fails, as can be seen by the fmeserver.log.    Thanks in advance for your help.      fmeServer.log:  Tue-19-Nov-2013 09:00:47 AM   INFORM   RequestHandler-Thread   408041 : (Login Module)     Authenticating single sign-on token "YIIH/gYGKwYBBQUCoIIH8jCCB+6gMDAu...".  Tue-19-Nov-2013 09:00:47 AM   INFORM   RequestHandler-Thread   408057 : (Single Sign-On)   Negotiation complete; authentication granted for user "MSchgraffer@S

Ok, I know attributes with the same name in the source and destination are automatically connected, assuming the case is the same. If this occurs, the connection arrows will turn green and the attribute information will be pushed across.   I have attributes that are the spelled the same in both the source and destination, but one is lowercase and the other is uppercase. Even though the connector arrow is yellow, the source information is still being populated in the destination attribute. Is there a way to disable the automatic mapping?    I’m currently using FME Workbench 2011.    Thanks in advance.   

Probably I am missing some obvious things here but I cannot seem to make this work. I have a published parameter "code", which I receive via user input from the command line. Let's say "--code ca" My script should extract two private parameters using the "code" value. I created a private parameter to extract these values: n = FME_MacroValues['code']    code = ["ab", "ca", "ny"] name = ["Alex", "Carl", "Nelly"] status = ["aall", "cast", "noo"] def find_element(n, code):      index_element = code.index(n)      return index_element    FME_MacroValues['my_name'] = name[find_element(n, code)]  FME_MacroValues['my_status'] = status[find_element(n, code)] The idea is to get the two values: $my_name, $my_status because for the moment, they both are received via user input. In this way, the user would have less data to input. This

Hi, Hopefully someone can help me with these fundamental questions about the way a workbench executes, this is for Oracle DB interactions as readers or using SQL Executors.  1) When you hit run in Desktop or FME Server starts processing the workbench does it do connection tests on the readers and transformers?   2) In what order will it process the workspace?  For example if i have reader/processing/writer workflow and also a completely separate reader/processing/writer workflow in the same workspace which executes first?  Behavior I had seen was that the one at the top of the workspace goes first but then I've just experienced something to the contrary happen.  Also if i change the order in the navigator does that effect the execution order?  I've looked for something relating to this in the documentation but not been able to find it. Thanks    

Hello,  I noticed in the Aggregator transformer that there is an option "Attributes to Average, Weighted by Area", is there a way to weight the average by length for a line feature? If not, do you have any recommendations on a different way to get that result?  Thanks for your help!  Amanda

Hello, I am using attribute accumulator to group features and I need to use the "Input is Ordered By Group" option.  I have a list such as this:  1 1 4 4 4 2 3 4 4 1 1 1  and I want the results to be the following: 1 4 2 3 4 1  where it maintains the order as it groups, and the 1 and 4 appear twice in their correct place in line.  However, when I use this tool what I get is: 4 2 3 4 1  Notice that it skips the first group.  It found the 4 twice and placed them correctly, but the first 1 was skipped.  Am I doing something wrong?  thanks, Kristi

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