Authoring

Hi guys,  I am reading an XML that contains list elements that do not start with 0 and therefore are not recognized by FME. Well they are and then again they are not , I can count the number of elements but I cant explode it> which is what I want.  Any ideas on how to tackle this?  Itay  

Hi Everyone, I have looked through all of the community information and knowledge base for some help on this but can't find anything to help with the issue.  I am trying to use templating in email notifications and I can't get the client specific keywords to be anything but _undefined_. I would like to include the directory of the transformation results in an email to certain users when a job fails. That way they can see in the log where the issue is.  Thanks in advance :)

Hello,   I am fairly new to using FME but I wanted to solve a problem using this software.  I have a spreadsheet with all kinds of different newsarticles wich I would like to spatially assign (automatically) to a specific country. In the newsarticles, a country name is often mentioned. I was thinking if there was a way to use some kinf of search transformer which could search for country names (in the articles) and also add a new attribute value (the country name it was assigned to).  I have two readers, the spreadsheet and a shp file of all the countries. It would prove usefull to read all the different search options (all the countries) from the shp file.  Any suggestions? thx in advance   

Hi everyone,  I have concatenated joiners on my workbench and I am trying to create new user published parameters because the paths are being changed depending on the date of update.  The problem is:  The published parameter of the first joiner is created successfully, I move to the second joiner and create the second published parameter. When I click 'OK' the newly published parameter overwrites the first one.  What am I doing wrong?  Thanks in advance Gianluca

Hi all, Generalty i use ListConcatenator to concatenate ALL list items. I need to concatenate list  items without the first item. Is there a specific transformer that can i use?  Thanks an advance.  FarFar

Hi All, I look for lists comparaison. For example : i have 2 lists list1 that contains (1,2,3 values) and list2 that contains (2,3,4,5). The result is 2 lists ListOut1 and ListOut2  that contain the differences : ListOut1 will contains all list2 values that don't exist in list1 => ListOut1 values : 4,5 ListOut2 will contains all list1 values that don't exist in list2=> ListOut2 values : 1.  I dont find tranfermer that can helps me. I look for python script but i need help.  Thanks an advance. FarFar

Is there a way to geolocate a layer that is in a non-earth coordinate system? I can get three points to define the geolocation. I presume that this should be sufficient?  Regards, Chris Mugdan

Hi,  I have a workbench that I want to run on windows task Scheduler. What windows scheduler did was just opens up the workbench but it actually didn'tt run. I have workbench that downloads the data and save in my local geodatabase? I wanted to schedule a task so that it downloads the data everymonth?

I am using FME 2012 SP4 to exposed a number of GeoMedia Format attributes on our text features coming from an Oracle DB i.e. geomedia_text_string, When I run the WB the attribute name changes to oracle_element{0}.geomedia_text_string which looks like a list to me. I have tried to use list manipulators to get to the text string but a list is not exposed.  Any thoughts on how to get to these format attributes so that I can export them?  Cheers

All,  Is it possible to run part of a workflow?  I've got a process that reads 12 feature classes of ~85,000 features each.  I got to the very last one, and it bailed out.*  Can I just re-run that 12th one?  *bailed out because adding a writer takes the DB name of the reader - why?

I just noticed that FME Community Answers is now more than one year old. Hurray! I would say it has proved to be better than the old Google-groups channel. However I am a bit sad that there have been no development, change, upgrade on these forums for a year despite multiple suggestions from heavy users:  I know this might not be a focus-area for SAFE for the moment - however I would say improving this community is getting more and more important because all other parts of SAFE`s operation is so good! (Webinars, tutorials, videos, blogs, tweets, demo-workspaces, apps, events, world tours etcetcetc)  Some threads I found: https://safe.secure.force.com/AnswersQuestionDetail?id=906a0000000coNFAAY  https://safe.secure.force.com/AnswersQuesti

  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

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 t

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

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.