Authoring

According to the docs when using FMEServerWorkspaceRunner you can specify the value of published parameters to be a value from attributes of the feature that triggered the job: "Any published parameters associated with the server workspace must be given values. These values can be taken from attributes of the feature that triggered the job to be submitted, or can be typed in (in which case they will be the same for each job that is sent via the transformer)." But I can't seem to find how this is actually done in Workbench. The wizard page lists my published parameters but does not have the usual drop-down arrow to allow me to specify the feature attribute to assign as the value. I also tried setting the value using the macro @Value(attribute_name) but all that did was pass through the string. So is this an error in the docs or am I missing something obvious? FME Desktop 2013 and FME Server 2013

Hi Guys, yu, its met again. I have a question. If i do this $(DestDataset_CSV) as a scripted parameter and tcl script: $FME_MacroValues(Outputdir)\\\\$FME_MacroValues(csv_name).csv (just a simple concatenation) Then $(DestDataset_CSV) ends up like Outputdir\\csv_name the extension is missing. Only when i add this extension to $FME_MacroValues(csvl_name) =filename.csv i get Outputdir\\csv_name.csv wich is correct. Why is this? (in this case i wanted the user not to have to enter the extension, though i changed my mind on that point already..;) Also i have boiled down the issue by Robbie B Creating dynamic attributes per "fme_basename" to just this It consist of 3 workspaces, 2 of wich have callers, an intricate parameter construction, 2 startups and one shutdown script. Now one can pick a directory and read files and their attributes straight to (in this case) excell. I think this workspace might inerest you all because it shows a workaround on the issue of dynamic attributes. No exposi

I have a workflow which has 1. Genereric Reader 2. Sampler - Which will send onle 1 feature 3. GeometryFilter- To decide geometry type of source data possible values are Polygon, Point and non-geom data Now I have 3 different workspaces for above 3 conditions. To decide which workspace to run I have written a shutdown python script which will run WorkspaceRunner and it will decide which workspace to run. but I am not able to use vaiable I set in workflow to decide the workspace. In short I need to use variable defined in workflow in Python script? Note: I don't want to use WorkspaceRunner as I am publishing this to FME server.

Hi all, I have a workspacerunner that calls a very basic workspace. All this workspace does is call a csv and writes it to a Excel file. I parametrized the outputdirectory and output filename. Strange thing is, when i use "Directory(output)" and "Filename (output)" parameters, no parameters appear in the workspacerunner. When i use "choice or text" parameters for both variables; no parameters appear in the workspacerunner. But..when i use both, finaly parameters appear in the workspacerunner. See pic. But this is ugly : I want just one set. Now i have solved this by making 1 set (the "choice or text" ones) private parameters so they don't show in the workspacerunner parameters. Anyone know how i can tackle this, just on set without need to hide some by making them private?

Hi guys! I'm finding it quite difficult to figure out how to dynamically produce attributes per my "fme_basename". So let me explain what I have, and what I want. My source is a folder with multiple undetermined shape files in. My output is a .xls file that simply lists the attributes present for each shapefile within my source. So in other words, my writer fans out by "fme_basename". Everything works fine, but instead of each shapefile being represented by a new tab, I'd like for them all to be on one page, in other words, an attribute created for each shapefile found. The intent of the entire workspace is just to summarise all shapefiles for the user, so that they can ensure all fields that should be present are, for each shape file. So what I have is: "ATTRIBUTES" (The field I created that lists all present fields) Type Name level etc [Roadnetwork] (This is the tab in the xls) This is present for each tab generated, where each tab is named accodring to the shape file, such as Roadne

Hi, I am using FME Desktop 2013, Build 13448 to try and complete the following workflow. Read in CSV's from a directory; as these have have differing numbers and names for attribute fields, before I complete the required processing. NOTE that all input files will have the 3 required I need even if they are named differently (extra fields can be ignored). I had planned to create a lookup.csv to manage the mappings and then use the schema mapper to read in the Survey CSV and the lookup csv and then create an output with only the 3 required fields with the new names. However, I must be doing something wrong as it is not working as imagined. Input Survey examples: File1 Schema EAST,NORTH,HEIGHT File2 Schema easting,hei,Nothing,date,time File3 Schema X,Y,Z,Time Lookup,csv old,new EAST,NEW_EASTING easting,NEW_EASTING X,NEW_EASTING NORTH,NEW_NORTHING Northing,NEW_NORTHING Y,NEW_NORTHING HEIGHT,NEW_HEIGHT hei,NEW_HEIGHT Z,NEW_HEIGHT expected output NEW_EASTING,NEW_NORTHING,NEW_HEIGHT date, tim

I want to create a workflow which daisy chains a number of workspaces using workspace runners but there may be a complication. Workspace 1 Reads a list of files and passes only the first file (Survey01) from directory A to Workspace 2 (Wait for job to complete is set to Yes) Workspace 2 The first file comes into Workspace 2, the name of the file is used to find a matching pair from directory B (Survey01Attribution). Then temporary versions are created of both files and placed in a TempDirectory, specfici names are given (this is required for Workspace 3) Survey01 will be TempA Survey01Attribution will be TempB Then another WorkspaceRunner is used to invoke Workspace 3 Workspace 3 When Workspace 3 starts The TempA and TempB files are opened and an InlineQuerier is used to perform a join, the resultant table is then output (an attribute is used to name the file Survey01Joined) Then and only then when Workspace 3 is completed do I want workspace 1 to send the next file to workspace 2 and

With the schema reader I can get all the "feature type name" from: - shapefiles (...\\**\\*.shp) - File geo database (test.gdb) But how can I get all the "feature type name" from an ArcSDE? or from an oracle database?

Hi there! I'm a bit stuck with something that couldn't possible as hard as I'm finding it to be.. I have a folder with a bunch of shapefiles in, and I simply want an xls output (fanned out by fme_basename) with an attribute that lists all the attributes in each shapefiles. So in other words, my workspace creates a tab for each shapfeile, but I can't figure out how to just list all the attributes present. I simply want to know which attributes are present. Here's an example of what I'd like: "ROADS": (imagine this is one of the xls tabs) "Present Attributes" (This is the field/attribute I create for each tab) "user" "date" "direction" "type" etc etc.. I hope this explination makes at least some level of sense. Thanks in advance,

There is an option SQL Statement to Execute before Translation on the writer side. I have a fairly complicated T/SQL stored procedure that prepares the source data. I don't really want to bother adding all that complexity to my workspace. It would be a lot of work and besides, the current procedure works fine. When does the execute SQL Statement Before Translation on the writer execute? Does it execute before anything else happens? Or does it execute after the rows have been read before any translations have been executed? Is there any way, within the workspace, to execute the stored procedure before the readers read any records?

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 biggest multi-ID. This should not affect the geometries, just reassign the attributes. I tried several approaches with ListBasedMerger and StringSearcher but don´t find the right way. Anyone any ideas ?

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. I really would prefer to use t

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, os mxd = arcpy.mapping.M

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?