Authoring

Hi All, I'm trying to amalgamate records from several tables into one with only 2 attributes - the ref (from the originating table) and the table name (created using the Feature Type Name from the originating table). However, when I try this the Tablename attribute contains the full path for the file not just the table name.  Can anyone help me with this one? Thanks.

Since upgrading to FME Desktop 2015.1 and Server 2015.1 we've hit an error writing dynamic features to a file geodatabase:  Unable to find the schema definition 'Scheduled_Ancient_Monuments' for feature with feature type name 'Scheduled_Ancient_Monuments'. Ensure the feature type name is correct and that its schema definition exists in the schema source  We haven't changed anything between 2015.0 and 2015.1 and it worked fine previously. I've attached two images showing the Feature Type Properties as they look in 2015.0 and how they look in 2015.1.  Thanks,  Peter.    

Hi,  I was wondering could anyone help me with a problem that I am having with Oracle Geometry Validation.  I initially got an Oracle Dmp file containin a polygon dataset which have a Tolerance of 0.0005 and Irish National Grid 29900, I have implemented the Oracle Geometry Validation with the Tolerance check of 0.0005 and all features have validated with no issues.    The Oracle spatial dataset was then transformed into an ESRI SDE Feature Class within a Feature Dataset which uses the Irish National Grid spatial 29902 reference system with all the standard defaults used i.e. x,y tolerance 0.001 and x,y resolution 0.0001.  All features loaded successfully into this feature class.  The data was then exported to an Oracle dmp file and provided to another person who imported the data into their Oracle database and into their Database Schema.  I was asked to analysis on the new schema so therefore the data was provided back to me as an

Hi guys,  Lets say I'm reading in several shape files. They are called "Birds", "Dogs" etc.The 'fme_feature_type' has the same name. There is an Attribute with the name "Race" (containing e.g. 'Finch', 'Crow', 'Falcon' ...) I need a csv file with the field names set to the feature type and the races beneath it. It should look like this:  Birds        Dogs               Fish Finch        labradoodle      ............ Crow         dachshund       ........ Falcon      pit bull terrier    ....   much obliged 

Hello,  I am running a workspace, and have created a custom transformer similar to https://knowledge.safe.com/articles/Samples_and_Demos/Looping-with-Blocking-Transformers  However, there is an error that comes up: Custom transformer 'JoinLoop' does not have a port named '' which is suitable for parameter 'LOOPBACK_INPUT_TAG'  My parameters are Elevation and _iteration_count... I cannot figure out the Loopback issue.

Hello, I would check the veracity web link from a FME process.(I need to know that isnt a dead link. Do you know a FME transformer for it or if i have to develop an algorithm ? thanks Alexy 

Hi World,  I have a XLSX file with two sheets in it and I want to use each sheet as a template for two different sheet in two XLSX writers but the same XLSX destination file. I tried to do so and it is not working. My first sheet (writer) gets empty after the data is written into the second sheet (writer). It looks like the "Template Sheet" parameter isn't working. I chose my Template File but if I let the Template Sheet empty for the two writers, nothing changes.  I've read in the doc : When you specify a Template File, you can select one of the sheets as the template sheet. Click the browse button to view the list.  Where is that list?? I don't see any sheet list, I have to write it down by my own... Cheers!

Hello! How I can to take this attributes from autocad block? I need it for converting to postgis database.  I don't see these attributes in FME inspector

I have a FME workbench here and at certain points the output of transformers is connected to two other transformers. So the workbench get seperated in several branches. I wonder in which sequence order the transformers are activated. This is important, because in the several branches editing is done on the same objects. Is it possible to steer this sequence order?

Hi, new to FME here  I've got a basic workbench that reads all xlsx files of addresses in a folder, joins them with an existing table to geoencode it, and then outputs it to one of three Oracle Spatial Object writers depending on some other attributes. It processes fine if I run it through the workbench, but I'd like to batch deploy it, which raises some problems.  I went through the batch deploy wizard, but when I run the autogenerated .bat file it stops after processing the first excel file with the message "The instruction at 0x107e183a referenced memory at 0x0000002c. The memory could not be read".  But if I change the .bat file's contents from   fme "D:\my_project_xlsxr2oracle8i.tcl to  fme "D:\my_project_xlsxr2oracle8i.fmw" It works fine, just like running it through the application.  These are the contents of the .tcl file  set workspacename {D:/my_project_xlsxr2ora

Good afternoon,  I have this issue come up now and again and I'd like to be able to solve it. But I frequently get excel spreadsheets that neet to be mached to a Point Layer in SDE. Normally I take the geometry of the SDE layer and keep the attributes of the spreadsheet. I normally use the FeatureMerger transformer. My problem is sometimes the number I use to match on is sometimes odd in the spreadsheet such as having trailing zeros or just any number of extra characters (normally 8000+ rows). So question being is there a way to do a "Loose match" on the fields to come up with a match? Thanks!

Hi I am trying to convert shapefiles to DXF. I have a CAD template file (.DWT) which contain definitions for linetypes. However I need to specify a linetype based on an attribute.  I am using the DWGStyler in FME. Is there any way to set a particular linetype based on the feature subtype.

I have a directory with several subdirectories and four tif-files in each of them. The 4 tif-files have to be merged and the name of the new file has to be the name of the subdirectory.tif. All those new files have to be output to the same, new directory.  So my problems are (I tried different things without success): - how do I get the names of the subdirectories, so that I could use them as the new filenames? - how do I loop through those subdirectories? (I guess I could use a workspace-runner, but then I would have to get the names of the subdirectories first > could this be done with the Schema-Reader...?)  Thanks in advance Vera 

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