Authoring

Hi,  I have a Python Startup Script using cx_Oracle library, which calls an Oracle Procedure returning a count value. If the count is greater than 0 then I want to stop the Workspace running.   Wondering how do I go about terminating the Workspace?  Thanks!   import cx_Oracle  # Connect to Oracle and Query the table try:     connection = cx_Oracle.connect('user/pwd@orcl')     cursor = connection.cursor()     result = cursor.var(cx_Oracle.NUMBER)     cursor.callproc('check_valid_dataset', (101,result))     if result.getvalue() > 0.0:         print 'Terminating: Some datasets are not available'     cursor.close()     connection.close()      except:     print 'ERROR - Python startup script could not connect to database' 

Hi FMErs  I have a .osm (OpeenStreetMap) file as a reader, then used ListExploder to get the attributes for each feature as it's saved as tags, k (=key), and v (=value) , FME read these tags as a list ,..so I managed to get the columns, but I'm now stuck in how can I convert every key (or k) of the feature, into an attribute, and match to its value (v), see snapshot..  For example, k=maxspeed is an attribute and v= 100 is its value. Note that every feature may have many k's, (i.e., name, lanes, oneway, maxspeed,..etc)   Any idea? Appreciate it..

I have a workbench which writes to some Esri Geodatabase feature classes and need to run some arcpy commands on each target feature class before and after the workbench completes.   At the moment I am hard coding the target feature class names in the python startup/shutdown script, but would really like to pick these up from the workbench by getting a list of writer feature type names.   I'm thinking it must be possible to list the writer feature type names that are defined in the workspace using fmeobjects?

I wrote a script that calculates something with some attributes of a dataset and stores new attributes, something like  ... for AttributeName in MyFMEObject.AllAttributeNames()   if AttributeName[:6]!='LIST_'      MyFMEObject.setAttribute("MAX_"+ParamAttributeName,-1)     MyFMEObject.setAttribute("MIN_"+ParamAttributeName,1000000)  for AttributeName in MyFMEObject.AllAttributeNames()   if AttributeName[:6]=='LIST_'      CalcMaxMin(AttributeName[-8:])     MyFMEObject.setAttribute("MAX_"+ParamAttributeName,-1)     MyFMEObject.setAttribute("MIN_"+ParamAttributeName,1000000)     MyFMEObject.removeAttribute(AttributeName)  def CalcMaxMin(ParamObject, ParamAttributeName):   localValue=ParamObject.getAttribute(ParamAttributeName)   localMaxValue=ParamObject.getAttribute("MAX_"+ParamAttributeName)   local

I'm using FME Professional 2015 and have been trying to set the global origin for the DGN V8 writer but it does not seem to work. From what I understand I should be able to set UOR X Global Origin and UOR Y Global Origin, but I've had no luck. Is there a trick to getting this to work - something I'm missing?

Hello,  I believe this is a simple question, but I am still learning FME.  I attached pictures to help show what I would like to do.  I would like to merge/combine my features within my shapefile together.  I would like each to be separate instead of an entire shapefile with only one feature, so I do not want to use the Aggregator transformer.  Within my shapefile, I have this... which is actually two separate features.      In this example, I would like to combine 5861 and 5862.   I saw this post http://fmepedia.safe.com/CommunityAnswers?id=906a0000000d6OnAAI, so I also tried the LineJoiner

Can I create a published parameter to accept either a value or an attribute name? You see this quite a bit in the transformer parameters, where you can either type in a constant value, or select from an attribute list.  Cheers Keith

Hello I have one attribute table and I would like to merge two attributes into one new attribute in the same table. I though this could work with the attribute creator by merging together two attributes with the help of the arithmetic editor, however this does not work. One attribute is a string, the other one nummerical. Does anyone has a suggestion?

Hello,  I am new to FME and working on a project...  I have merged a zoning polygons together based on their application number. I am now labelling them, there is just one problem, in a couple applications, there are 2 seperate shapes that require the same label, but only one is being labelled. I am using the 'CenteredLabelAdder' transformer.  What am I doing wrong? Thanks for the help! Iris

Hi, I have a workbench where i need to fanout the output (GML writer) based on a chopper set to maximum of 1000 vertices. I guess I should be able to use the fanout option, setting it to the input-chopper but can´t seem to figure out exactlyhow to do it. Can someone point me in the right direction? Christian

Is it possible to fanout AIXM 4.5? From what I read I need to fanout the dataset but I need to do that based on the feature type not a specific attribute. I basically need FME to write out a seperate xml file per feature type in my AIXM source message and can't see how I can do that with the fanout options.  I am using FME 2015

Hello,  I'm sure this must have been asked before but I can't find the answer.  I'm trying to break up a big image processing job by splitting up a directory of jpegs into sets and then passing each set to my worker workbench.  I'm trying to pass the group of jpegs as an list of files to the jpeg reader in the worker though the workspacerunner, however the list keeps being 'fixed' by the engine as it is passed in:  i.e my paths look like this (note i have spaces in my path so require quotes) \\\\prodds\\a folder\\a picture1.jpeg \\\\prodds\\a folder\\a picture2.jpeg  If i run this (succesfully) in the worker directly the reader string looks like this:  "\\\\prodds\\a folder\\a picture1.jpeg","\\\\prodds\\a folder\\a picture2.jpeg"  so following the guidance in here 

Hello all,  Firstly, sorry for adding another looping question!  I have a shape file of buffered polygons and I would like to perform an AreaOnArea action to them against a second basemap shapefile.  These buffers overlap one another in places but I would like to compare each one individually against the second shapefile.  I've tried to set up a loop and I don't think I have set it up correctly. I've limited the features to read to 10 for testing and running it using inspection but it doesn't seem like it will create a single shapefile in the end as I had 10 different layers open in inspector.  Also, do I have the loop iteration parameters set correctly? I have just under 5000 buffered polygons to go through and I don't want it to get stuck in an infinte loop or anything else that could cause it to crash.  I've uploaded screenshots of my workbench  Thanks for taking

Hi,  we are trying to connect to FME Server 2014 programmatically via .NET. We are using the sample code provided by the FME Server Documentation, but get following error:   {"QSIncompleteResponse:Incomplete FME Server response. Expected  [SUCCESS|ERROR]+message. Received: "}  The Server is running and the connection via web is successful. We have tried the code with enabled security and disabled security but both ways were unsuccessful. Our Code is attached:  Any Ideas what we are doing wrong?  Thanks in advance!

I’ve made a user parameter attributelist, that I use in a NullattributeMapper. Then I want to use a tester wich tests only the attributes that I defined in my parameter. How should I use my published parameter in a Tester? (FME 2015). I would like to know since I want to convert these transformers to a custom transformer.   This way didn't work for me:     Thanks, 

I am trying to use the RunWorkspace script that was posted on here in the knowledge base, so a workspace could be run from a python script. I keep getting an error on the line that initializes the FMEWorkspaceRunner object: runner = fmeobjects.FMEWorkspaceRunner(). The error is: fmeobjects.FMEException: FMEException: 896902:. I couldn't find any information on what that error means specifically. What could be wrong?                  

Is it possible to enable/disable a transformer or a connection in a workspace using a published parameter?

I have a routine that writes data into rows in Excel through a workspace runner but once the routine is finished I want FME to open the spreadsheet.   I have looked at both python and TCL but can't get anything to work without runtime errors.   Does anyone have any scripts I would use to simply open an xlsx in a shutdown script.  

create a list of drawings where a certain text string is found

Hi,  I'm reading in some data via the FeatureReader transformer and I would like to write it out dynamically, but when I try to setup the dynamic proprties I get a pop-up message No reader or schema reader found.  Please add a reader or schema reader to workspace that can be used as a schema source.  I can't add a reader or schema reader because the data does not exist prior to the workspace being run.  Any ideas?

Hello, I am passing comma separated list of table names to workbench. It's working fine. Just want to make sure is there any limit on number of characters in parameter. Currently I am passing about 5 table names as a parameter(about 40 characters). So just want to make sure if I need to pass say 100 table names will it support those many characters. Also I am publishing this workbench to FME server.  Cheers

Hi,  I cant achieve to to parse correctly json elements and attributes correctly. The json received is like this:    {   "elements": [ {   "type": "way",   "id": 98815885,   "nodes": [     3325506694,     3325506698,     3325506701,     3325506705,   ], }, {   "type": "way",   "id": 98815895,   "nodes": [     1142949510,     1142941660,     1142983536,   ] } ] }  I am using the JSONFlattener, then the AttributesExposer (with elements{}, elements{},nodes{}, elements{}.id and elements{}.type) and finally the listExploder on elements{}.  The number of parsed feature is correct but there is no data inside the nodes attributes of each features. It's like if elements{}.nodes was empty for each feature.

I have multiple FCs in multiple FGDBs which I need to run through NeighbourFinder to generate distance/proximity info and then write into a single Excel writer feature type. These FCs have certain attributes I want to carry over into the writer but they are all named slightly differently. I would like some suggestions on the best way to carry this out please so it is easy to swap different combinations of Attribute in and out.

Hi,  I have 2 shapefiles with two columns, one is an ID, the other is a description. I need to merge these two datasets into one shapefile whereby if a feature has the same ID but a different description these can get pulled out so I can change them. Sounds simple but for some reason I am really struggling.  Any advice would be very much appreciated,  Thanks!

I would like to achieve the following:  Create a workspace that can be used to read a large number of tables, create geometries with the vertexcreator and write them to a database after changing attribute names based on regular expressions. Attributes differ from table to table and should be preserved.  I can probably achieve this by writing the schema to a feel and rereading that using the workspace runner. However, I feel like I am missing something really obvious. Isn't there a way to use a dynamic writer and derive the schema from a transformer rather than a reader?  Jakob