Authoring

Hello: I am trying to implement this portion of Python code on my shutdown script, but I don't get it to work: import pyfme import fmeobjects import os import subprocess logger = pyfme.FMELogfile() fmeExecutable = os.path.normpath(FME_MacroValues['FME_Executable']) workBench = os.path.normpath(FME_MacroValues['Workbench_To_Run']) # update the File Change and Population logs if translation successful if str(FME_Status) == "True": myWorkbench.updateFileChangeLog(FME_MacroValues['FMW']) myWorkbench.updatePopulationLog(FME_FeaturesWritten) # initiate materialized view refresh if changes to either source if FME_TotalFeaturesWritten > 0: logger.log('Updates detected, executing materialized view refresh script - ' + workBench) args = [fmeExecutable, workBench] p = subprocess.Popen(args) -- Runtime errors: FME_END_PYTHON: evaluating python script from string... Python Exception <KeyError>: 'FME_Executable' Error executing string `import pyfme import os import subprocess I have seen several exa

Hello: I have two FME programs: 1) Loads data in one spatial table 2) Loads data in another spatial table I would like to : - Keep these scripts independent, so script 1 can run on demand and to its thing, and - Script 2) can call script 1), for extra processing. My problem is, how do I invoke Script 1) from Script 2)? They both do different data processing, but it will be great if one can call the other. I am struglling with how to invoke Script 1, because there is no way "to trigger" its processing. I would like that, once Script 2 is done, it automatically triggers Script 1. Is this possible to do? I have been trying to do this with WorkspaceRunner, but I don`t get it to "run" Thanks again. Richard.

Kia-ora all, I am trying to use FME to implement a pseudo regression analysis. I have a workbench that performs a core process that comes up with 1 output value to tell me how well various parameters are corellated to a known result. This depends on a bunch of parameters (8 in all), and I need to run through testing each possible combination of parameters (256), turning them on and off, to find the best combination. Now I can create this scenario quite well with nested custom transformers, with each one just setting a parameter to 0 moving to the next nest level, then setting to 1 etc. Last level of nests is the bit where the core processing actually happens. This effectively loops through all 256 possibiities, without technically looping in FME. But I am discovering that this is probably not the most efficient way to do it, as each extra nest adds a load of time to actually working in workbench, as presumably it always has to think of how anything I do affects any nests underneath it.

Hi, Me again. I want to use the date and time the workspace is run as the output file name. At the moment, I am using a creator, timestamper and featuremerger to add the datetime attribute, then using fanout dataset on the datetime. This seems a bit of a clumsy way of doing it, as the featuremerger is slow when processing lots of features. Can anyone think of a better way? Really I want to tag all features with the same value. I could do this by creating a published parameter, but cant think how to populate it with date/time. Thanks, Owen

Hello, Is it possible to only prompt for a published parameter choice depending on the input of another? An example would be, only ask for an input parameter if a particular format was chosen. Owen

Good afternoon. I need to pass in as a published parameter the WHERE clause to the ArcSDE Geodatabase reader. I have created a published parameter named SQL and when creating the ArcSDE Geodatabase reader I attempt to use the parameter in this manner: WHERE Clause: $(SQL) However, attempting to do so causes the below error: Undefined macro `SQL' dereferenced in file `C:\\DOCUME~1\\rolan002\\LOCALS~1\\Temp\\FME_1362421243497_6256' Program Terminating Is it possible in FME to use a published parameter with the ArcSDE Geodatabase reader? Also, is it possible to pass in the SELECT and FROM clauses to the reader, too? (I would need to do this because my statements are coming from a web page and are highly dynamic; if I can't do this, I could live with just passing in the WHERE clause and having a slew of workspaces to handle the possible user inputs from the form). Thanks much. Joe

I have recently had occasion to need to iterate my workspaces; that is, to run them multiple times on varying inputs. When I need to do this on a group of files, I can pretty easily write a shell script to launch the workspace with a different input and output dataset for each of the input files. However, I am now trying to extend this method to iterate over the feature types (in this case, Microstation .dgn levels) within a single file. I can't seem to figure out a way to implement this, though. I need to publish a parameter that controls which level is processed. However, I can't seem to do that. I can't create a reader for a single feature type and publish the parameter that picks which one (it is greyed out), and I can't read the whole file and filter it, because I can't seem to link the actual filter variables to a published parameter. There is probably a way to do this, probably not even using shell scripts, but I can't figure out what it is. Any ideas?

Sometime back with in FME Desktop, if I am correct FME 2003 X2 release there was this cool option in FME to enable in Windows Explorer, summary information on the reader, writer and transformers used in mapping files and workspaces. I am unable to see this functionality in FME Desktop 2013. Am I missing something or is this functionality not available now! Regards SRG

Has anyone had to import a feature class' from a GeoMedia SQL Server Warehouse and maintain the rotation? I have some Water Valves as a reader and I am simply importing into an GeoMedia Access dbf. When I re-add the feature class from the GeoMedia Access dbf the valves all come in at 90deg. I want them to maintain their geometry rotation..... any thoughts.

Prior to FME 2012 I have created custom transformers that have a published parameter of an attribute name that is passed to the custom transformer. If I wanted to set the value of the attribute passed as a parameter I used the AttributeSetter transformer with the Attribute set to the published parameter containing the attribute name. How do I accomplish this in FME 2012 given the AttributeSetter has been replaced with the AttributeCreator? I tried manually typing in the parameter name into AttributeCreator Attribute Name field but no luck. I feel like I am missing something obvious and hopefully some one can fill me in. Thanks, CA

Hi, I am using FME 2012 and would like to write a startup python script in which I can import a python module and call that module's function. I used to be able to do this with pyfme but with FME 2012 I have to use fmeobjects and it throws an error when I do. Two simple test cases below. What might be causing the error? Looks like when I import the custom module, fmeobjects is not getting recognized. Embedded script (works): import fmeobjects def audit_start(): logger = fmeobjects.FMELogFile() logger.logMessageString("audit_start()") for name,val in FME_MacroValues.iteritems(): logger.logMessageString( " %s:%s" %(name,val)) audit_start() Imported script (error): import audit audit.audit_start() audit.py import fmeobjects def audit_start(): logger = fmeobjects.FMELogFile() logger.logMessageString("audit_start()") for name,val in FME_MacroValues.iteritems(): logger.log( " %s:%s" %(name,val)) Error: Python Exception <NameError>: global name 'FME_MacroValues' is not defined

Hello! I have CSV data which contains triangles. Each row contains one triangle. The triangle is defined by 6 attributes, x0, y0, x1, y1, x2 and y2. Is there a way to create polygon geometry using a transformer from those 6 attributes? I'm using StringConcatenator to create FME XML Geometry and GeometryReplacer. It works, but it would be useful to have a transformer, which could do that, something like Creator, but with INPUT port, since Creator doesn't have INPUT.

I have a pretty general question. I want to run FME in batch mode. Where can I get more information on doing so and what is the best way. The article I found on FMEpedia was empty: https://safe.secure.force.com/articles/How_To/Batch-Processing-Method-1-Command-Line-or-Batch-File

Hi Gurus, We are in the process of transiting from MapInfo v7 to Arc 10 and have written a bunch of workspaces to produce Feature Classes in the new SDE. This all works fine. The problem comes now we are about to switch our "point of truth" from TAB to the SDE and we need to run some legacy MapInfo Systems in the process. No problems right? Just author some more workbenches to write TAB files back from the SDE Feature Classes and use the MapInfoStyler to generate their symbology based on the LYR files we already created as part of the migration. Easy-peasy! The problem comes when we have some Branches using custom True Type Fonts to symbolise their data. When we did the migration we got the data custodians to sign off on a symbology change to use standard Esri symbols, but they want to see their old symbols in the legacy systems! Grrrr. Long-winded, but here's the question: How do I use a custom True Type Font library to assign symbology to data being output to a v7 MapInfo TAB file? I

I am evaluating FME 2013 Desktop. The MapTextLabeller feature is of particular interest to me. I need an example work flow that can read several shapefiles, create the labels for all, and write out the labels as points/lines to a shape file with attributes for text, rotation angle, font size, etc. This shape file would be then imported into a GIS software to create the actual labels for display. Any help would be much appreciated.

If you want to use an attributefilter to filter by fme_basename is it possible to autocomplete the basenames of the files that are read into the workspace?

Hi all, Please forgive my long explaination but I don't know how else to describe the problem. We have a bike race occurring soon that requires letters to be sent to residents that will be impacted by road closures along the route. I have a shapefile of the roads used for the route that I intend to buffer, then intersect with the adjoining property boundaries to get the postal information for those who live along the route. The issue I have is that a simple buffer of the route is not enough. For those people who live in dead-end roads who's only exit point is onto the closed road I need to ensure all those residents receive a letter too. Therefore I need to be able to select all dead-end roads that intersect the bike route so that I can also buffer them... I have no idea how to achieve this! The road data is topologically correct so I imagine it it some form of network analysis. Any ideas? Thanks in advance, Bazza

I have a textfile reader and a shapefile writer. Is there a way I can extract the first part of the textfile name and use this as the shapefile name? Thanks

The 'Browse all questions' link does apparently not work yet. Please correct this problem.

Hi, how can I fetch the workbench name and define it as an attribute value? Thanks, Felix

Working with FME 2013 and running into a problem with the WHERE clause setting on a PostGIS reader. Trying to select a single feature using the expression TRACTCE00 = 001811. I've confirmed in my database that this feature actually exists. However, I get the following error message: 2013-01-18 14:46:19| 0.5| 0.0|ERROR |Error executing SQL command ('declare public_CensusTracts_crsr____ cursor for select "STATEFP00","COUNTYFP00","TRACTCE00","CTIDFP00","NAME00","NAMELSAD00","MTFCC00","FUNCSTAT00", AsEWKB("geom") as "geom" from "public"."CensusTracts" where TRACTCE00=001811'): 'ERROR: column "tractce00" does not exist LINE 1: ...om") as "geom" from "public"."CensusTracts" where TRACTCE00=... To clarify: the column in my database is called TRACTCE00, and the error message seems to indicate it doesn't exist. I've tried using single and double quotes but no luck. Does anybody have an idea?

I was curious if the behavior of published parameters from custom transformers changed in FME 2013, but I couldn't find the answer yet. Maybe someone can tell? In his 'FME Evangelist' blog, Mark Ireland once wrote the following: "Published parameters can be a little confusing too. Normally, once a parameter is published the end-user is prompted for a value at run-time. In custom transformers, this is a little different. When a parameter is published in a custom transformer, you can look at it as prompting the main workspace for a value; i.e. it appears on the parameters dialog for the custom transformer, but it doesn’t get used as a prompt at run-time. To prompt for a custom transformer value at run-time, you first create a published parameter within the custom transformer, then - back in the main canvas - locate that parameter in the Navigator window and publish it again." For as long as I can recall, this is always how it worked and I never liked it. Not only because it is one of the

I have some polygons (fields) and each has a primary key ID. I also have some attributes (land owners) stored elsewhere, with a matching ID. The relationship is 1 Polygon (field) to Many attributes (owners). This is because each plot of land can have potentially more than one person who has a stake in the ownership of that plot of land! The solution I'm looking for is the most efficient way of cloning my fields when there is > 1 owner. So if 1 field has 3 stake holders, I want to clone the geometry 3 times and have each owners details tagged to an identical polygon. I can happily build a list at the moment by joining my two flows of data (fields and attributes) using the FeatureMerger but I can't then see an elegant way of cloning the polygons, short of counting the number of group elements and then Cloning and Indexing with lots of duplicated Transformers. Does anyone out there have any bright idea's that I'm missing? It's got to the stage where I have snow blindness! Many thanks...

Hi, I'm facing an issue when using a published paramater which is in cyrillic. When i set the published paramater manually in the workbench and it is properly fetched and written at the ouput. (I'm using version 2013) When I try running the workbench from command line (defining the parameter directly in batch file and also tried to use it within parameter file) the parameter is badly encoded at the ouput. I tried to search on this topic, so I tried the set the code page as 1251 in the batchfile but with no success. Do you have any idea if this is dos/windows issue or an FME issue and is anyone able to use published parameters in cyrillic (or other language with special chars)? Thanks for the tips. Zdenka

Hi Folks, I am new to the FME Desktop. I would like to ask if there is a way to export / generate the script after I have defined the detail of my translation in workbench? For instance, the script of the parameter, reader & writer configuration and the transformer used. Is there any method to achieve this? If yes, then I can customize it based on the generated sample script. Thanks in advance for your advices.