Best Answers

Hey FMEpedia,  I'm trying to automate the the running of a 2 step process required for multiple admin areas.  My current process is: 1. Workbench with workbench runner kicks of step 1 (for multiple admin areas at a time) 2. Once all admin areas have been processed - redirect workbench runner to point to step 2  Ideally I'd like to have a python shutdown script (or something of that ilk) within step 1, which would process step 2.   Problem - The documentation for python shutdown scripts states you shouldn't use fmeobjects within a shutdown script...however this example highlights that it can be done.  I attempted to follow the example code, but it is dated 2013, so could be redundant to 2015...can anyone assist with: a. Writing a python shutdown script to kick of new workbench, b. Can you use fmeobjects withn a shutdown script?    #FME Variables import fme, fmeobjects status = fme.status runner = fmeobjects.FMEWorkspaceRunner() #Path to Workspace current_workspace_dir = fme.macroValues[

My Process has several Reader: DWG-ReaderTAB-ReaderECW(Orthophoto)-Reader optionalPointcloudXYZ(DEM)-Reader optional I want to adjust my FME process so that my colleagues have to make no adjustments on the actual process. They are not familar with FME. The colleagues should only press the "Prompt an Run Workspace"-Button and then select the files which are needed.  The ECW and DEM files are not needed every time. At the Parameter (Type: Filename(Multiple)) Published and Optional are activated.  The Process only run when i select some ECW and DEM files. When i don´t select i get this error message in the log:     INFORM|POINTCLOUDXYZ reader: Directive '_FIELD_NAMES' has the value 'NO' |INFORM|POINTCLOUDXYZ reader: Directive '_FIELD_NAMES_AFTER_HEADER' has the value 'NO' |ERROR |POINTCLOUDXYZ reader: Failed to open file '.' for reading.  Please ensure that the file exists and you have sufficient privileges to read it |ERROR |BADNEWS: A fatal error has occurred. Check the logfile above fo

I have a table of data that has two fields that have comma separated values in them. Each value is related to each other. So the first comma separted value in Neighbour Code field is related to the first comma separated value in Neighbour Angle field and so on.... The table looks like this    How do I separate these values and create a new record for each value in the fields so the table would look like this:    Thanks  Matt  

Hi,  We are seeing some very strange behaviour from FME Server 2015.0 (windows) where: all the job logs are being deleted instantely (or perhaps every second) even though the maintance job is set up to run every month.If we disable the maintenance 'delete jobs' schedule the logs persist.One of our regular scheduled jobs continues to appear in the job queue list, even though we have disabled it - we then cannot delete the entries in the queue either.Other schedueled jobs, and jobs being triggered outside of the schedular, appear to run as normal. It's like something has become disattached from FME server core, and submitting jobs on their own.  We have tried a restart of FME server, and i'm told the task manager process window was checked for rogue processes, however the issue still persists.  I think my IT service provider will be rasieing a support call, however can anyone suggest things to look at.  I've suggested a full server reboot to kill all processes - but i

I am writing from shapefile to swallworld. I am getting the text "fme_geometry" appended to the end of a text field when I run my conversion. I don't have have the fme_geometry format attribute exposed and even if I did there is nothing connecting it to my text attribute. When I look at the attribute in the inspection point it looks fine. Anyone seen anything like this before.  output looks something like this  blah?blah?blah?blah?blah?blah?blah?blah?blah?blah?blah ?blah?blah?blah?blah?blah?blah?blah?blahfme_geometry

Data: 1-Excel sheet with two columns ABB and NME (abbreviation and full name)  900+ records. 2-Shapefile with Attributes MUNR & MUNL. This attribute has the same abbreviated municipality names as the excel sheet.  What i'm trying to do is create two new attributes (MUNRFull & MUNLFull) on the shapefile that will have the full names.  The statement would be something along the lines of where ABB = MUNR give me the NME output as MUNRFull. where ABB = MUNL give me the NME output as MUNLFull.   

Hi, I'm trying to merge features from 2 excel files with FeatureMerger.. It works if I have a relation one to many but it does not when I have many to many relation.. any idea.. Thanks

I am looking for a shortcut (transformer?) that will change attributes' type and width all at once. Holding down shift  can select all the rows of attributes, but then the change made is not applied to all the rows selected.   For exmaple, in the below picture, I want to change all "char" to "number", and the width from 200 to 20 .

Hi There, I have a road network polyline data with some dangle roads. I need to remove all the dangles using looping in FME. But the master catch comes here...I do not need to give the number of iterations myself. All the roads, having a free node should be looped out of the network spatially giving output of the present loop to the input of the next one regardless of the nnumber of loops. Attached Image can help better to understand more.   Please revert if i am not able to communicate properly. Thanks and regards.  

Hi, How can I select object by attribute from aggregated objects I have an excel files with 1000 lines and shapefile with 100 lines and I have a common id.. I did a Featuremerge to add attributes from excel to geometry. In the result I have 1000 lines (or 100 lines if I do an aggregation with id). I want to have in the result only 100 objects with the recent date (Example for object with id=5 I have in excel date=2015/05/12 with type =x1 and 2015/01/01 with type x2 and I want that id =5 have the attribute of 2015/05/12 with x1).. Thanks for help

Im creating some tables with an oracle spatial writer but its creating them without a primary key.  I am using a sequence in oracle to increment the value but the created table does not have this ID set to primary key.  How do I get a table I am creating to set a column to be the primary key?  (Im in FME 2013)     

I received an FFS file and most of the attributes have their data types/encoding as suffix in the attribute name field (see embedded image). How can this be turned off or removed?  

I have raster grid from which I want to extract contours. I know polyline contours are fairly easy to extract but what I need is the polygon contours.  Is there any way in FME to extract polygon contours out of raster grid?   Using Professional Edition 64/32 on Windows 7 64bit  

Hi!  I'm using FeatureMerger to merge a Shape file and a CSV file, and outputting to a GeoJSON file. The merge works as it should, but is producing seven extra attribute columns that I don't want, even though none of the Format Attributes are selected in the Feature Type Properties settings (csv_line_number, csv_number_of_fields, csv_total_number_of_columns, multi_reader_full_id, multi_reader_id, multi_reader_keyword, multi_reader_type).  This is obviously making the GeoJSON larger than necessary. Can someone please tell me how to ensure these Format Attributes don't get written out to the final GeoJSON file?  Thanks!

Hi,  I have GML dataset with different polygon orientation. I need to get two points in clockwise order from that polygon. E.g. (in WKT): POLYGON ((0 0, 10 0, 10 10, 0 10)) - counter clockwise Points from this polygon: First Point - POINT (0 0);  Second Point - POINT (0 10) It doesn't matter which two points, but they need to be one after another, and orientation must be clockwise. How to determin or change direction of polygon in FME to know what point I need?

Hello,  This is a simple use of the spatial realtor but I can't figure out how to expose the related attributes. I have a set of overlapping polygons, differentiated by an attribute (Type 1- 5). I have a point file. For each point in the file I want to calculate 5 attributes (Type 1- 5), indicating whether or not that point fell within the polygon type.  I thought the spatial relator wiith a groupby "Type" would create a list for each point indicating if it were related to each of the 5 types, accessible through the "_relationship{indexValue}". With the indexvalue being the order of polygon types based on the order the grouby was processed. Can some explain how to properly use this transformer and access the results?  Thanks,   Desired final product: Point, Type1, Type2, Type3, Type4, Type5 1      , YES  ,  NO    , YES  , YES  , NO etc

Hi,  I have a Microstation file in which I am writing to Sketchup. The initial translation from microstation to sketchup works but when I open my sketchup file, the model is placed very far from the origin. Is there anyway that I can move model to the origin?

Hi everyone,  Is it possible to change geometry names for a boundary too? I used the GeometryPropertySetter to set the GeometryName and Traits (see pic below), but it also changes the geometry name for the Boundary IFMELine. I want to set the name for the boundary to curveMember (see Example 2nd pic). The Problem is, that FME is creating a LinearRing for an ElevatedSurface, but i need an GeodesicString. I hope that the geometryname will help me with that.  My geometry:  It should look similar to this:   thanks, Mel

Hi folks,  I have implemented a workbench where a published parameter represents a URL. In FME Desktop and when it is published as a service on FME Server it works ok. The service can be used without problems with a normal string as parameter value and when is used a string encoded as URL.  The problem is that an other workbench (very similiar to the first one in functionality) which works ok in FME Desktop but not when it is published on FME Server and used as a service. It works ok when a string encoded as URL is used as service parameter value, but not when the value is a normal string. (For example, if you use the URL that FME Server UI generate using the values inserted in the form, the service works ok. But if special characters ("/,"+"...) are not encoded in parameter value the service does not work.  In both workbench the parameter definition is the same and along the process the value of the parameter is the same.  Thanks!

I have an ODBC connection to a table that geocodes addresses and writes it to an ESRI ArcSDE feature class. When I run my workspace on my desktop everything works fine, as soon as I upload it to my FME Server I get this error:  Database Error Message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified  It's a System DNS connection and I checked all the drivers and 32bit connections and everything is good. So not sure what is causing it not to work on the FME Server. Thanks!

Hi,   Say I have a massive table (+15million lines) with multiple columns , it has a Field called "category"..the category Field has multiple data values in it.  how do i split the table based on the field category? say the field has 150 categories in it..therefore I need to have 150 tables.  so if the input is 1 csv file.. the output required is 150 csv files separated per category.  I think this could be a test filter with so many filters in it.   thanks in advance.  kind regards, Jubert  

Hi,  How is it possible to search nested lists in FME? By nested list, I mean that list that is returned from SpatialRelator and contains pass criterias.

Has there been a change in FME 2015 in the way that FME writer for GEOJSON determine the projection of incoming features? I have an FME 2012 script that takes LAT/LNG fields from a spreadsheet, turns them into a point using the 2DPointReplacer, and then writes them to a GEOJSON output where the coordinate system is specified as UTM83-10. It actually writes the feature as:  "geometry":{"type":"Point","coordinates":[492699.273158735,5452194.8678692]  However, the same script in FME 2015 writes the feature as:  {"type":"Point","coordinates":[-123.100262444394,49.222495514519]}  In both cases the CRS is specified as 26910. There is no reprojector between the reader and the writer. In the 2012 version, it looks like FME respects the coordinate system of the writer and reprojects accordingly. Is this the case?  Thanks

Hi,  I'm interested if inspector has some impact on conversion time? If I have many inspectors in testing and debugging process, how does this affects time needed for conversion to be done?  Thanks!

Is there a way to send multiple emails in the "Email to" box of the subscription? I tried the format that Outlook uses, that is, each email is separated by a semi-colon:  email1@email.com;email2@email.com;email3@email.com  However, no emails get sent.   Thanks