Authoring

Hi,    I have two workbenches out of which first one will generate a list of spatial tables,as per which second workbench will read from those Oracle spatial tables. Any idea how to implement this approach?  Thanks, Subrat 

Hi dears.    We have a technical question regarding the connection FME using the reader ESRI Geodatabase through the direct connection option.    We are getting the following error message below when trying to connect to the database GIS / Esri.      Opening the Geodatabase reader    FME has checked out an Esri license. The product checked out is 'ArcInfo'    Installed ArcGIS version is '9.2'    Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error[ORA-12545: A conexão falhou porque o objeto ou host de destino não existe    No extended error.]}    Please ensure the connection parameters are correct (server=`dummy', instance=`sde:oracle10g:\\;LOCAL=PJTP', user=`UOMSUSER', password=`***', database=`PJTP', version=`UOMSMGR.OMS_DMS_SINC')    A fatal error has occurred. Check the logfile above for details    FME Session Duration: 13.

hello?     There are some groups in my AutoCAD DWG data. Groups in Autocad means a whole that when you select a group in AutoCAD ,you'll select all element in it. But when I read these groups data in FME, they'll be auto exploded even I set the 'read group' parameter to 'yes' in Reader. And I could not find some relationship between those features which are one group. How can I resolve this problem in FME.

I recall that in previous versions of FME you could occasionally get forced to version 9 of MapInfo by including a column type (date) or coordinate system that wasn't supported in earlier versions, but it appears that with 2013 SP2 now all of my MapInfo output has been forced to version 9 with no changes in the workspaces.  Has anyone else seen this?  This is pretty critical for me as most of my MapInfo users are still on 8.5.  I'm putting in a support request for this too, but wanted to ping here as well.

Hi There,  Currently my workspace runs a number of calculations (such as legth and counts) on all shapefiles contained within a selected folder, and then writes them all to an Excel spreadsheet. There are also two additional parameters to define:  1. Selecting a shapefile 2. Selecting an Attribute (The list of attributes comes from the folder selected earlier)  And for this individually selected shapefile, additional, seperate calculations are done.  The Problem I have though, is that every thing seems to work perfectly, and my calculations for the parameter defined attribute seems okay... But, I have no way of extracting this value, or turning the parameter value back in to a attribute to populate in the spreadsheet.  Example: Step1 - Folder is selected containing all shapefiles Parameter: FOLDER - (ROADS.shp, RIVERS.shp, LANDUSE.shp, etc...) Step 2 - Additional single file (within that folder)  is selected to run extra tests on Parameter: FILE - ROADS.shp is selected Step 3 - Attribu

Hi,  I have hundreds of datasets that I need to process.  I attempted last night to batch process 8 of these datasets overnight.  However, coming back in the office this morning I found that it is saying it is out of memory, and that none of the datasets processed at all.  I was hoping to get some advice on improving memory capacity so that I am able to batch process a lot of files at a time.  Unfortunately I don't have many admin rights on the company computer so it will be difficult to change many of the settings.  Keeping this in mind, if you have some simple and effective solutions for assisting in memory capacity, it would be greatly appreciated.  I don't have much experience in fiddling with memory and caching settings, so a simple and clear explanation would be great.  Thanks,

Hi there,  I've been struggling with what seems like a very menial task for quite a while now. This is FME 2013 SP2.   Well, I have a directory of shape files I do some basic calculations on with a dynamic schema, such as counts, length, etc. These calculations are then written to a csv file, and split into line, polygon, or point features, with a GeometryFilter. This all works Dandy. Currently, there is a fourth tab I have created, that functions based on a parameter (Called Summarize_FRC) that allows you to optionally select a specific file. A tester I added then checks if that parameter is present, and if the test is passed, it writes out to the fourth tab.   In short, in addition to the line, polygon, and point feature tabs my workspace creates, I want to be able to specify a specific file, were that file and that file alone continues to my fourth tab writer.   The main things I struggle with is that in the parameter options, when choosing Type “Filename (Existing)”, there does

Hi All,  I want to submit a job to fme server at the end of a "published workbench". Is there any way to achieve this? I googled that it is possible through a python shutdown script. Can someone give any pointers for this approach.  Thanks

Hi,  I am trying to do a Batch Deploy using the Wizard in FME 2009, but am running into some trouble.  I selected three datasets in the "Select Source Data" dialog and then selected the directory I want the outputs to be saved into in the "Set Destination Location for" dialog and checked "Retain source dataset basename in destination path".  However, after running it, it is producing an output on the first dataset and nothing for the rest, and the output it is producing does not have the soure dataset as its basename!  I'm not sure what I'm doing wrong...  Thanks,

Hi !  I have a reader on my FME Desktop 2013 workbench which opens data from an Oracle spatial database.  Reading the data take a long time, since it is a huge dataset.  The first step of my process is to use a SpatialFilter in order to select the features of my dataset which are included in a relative narrow region.  This means that I opend a lot of data that are not used in my process.  In order to avoid this, I can specify a Search Envelope in the parameters of the Reader. I guess that by doing this I only open the feartures that are within this envelope.  My question :  In the Search Envelope, I have to manually define the Min X, Min Y, Max X, Max Y values. Is it possible to derive these values automatically from another dataset ?  My idea is to add another reader on my workbench to open the delimitations of all the municipalities, to "TestFilter" this data in order to select only the municipality I need, to derive the Min X, Min Y, Max X, Max Y values of this municipalit

Dear,  I'm using FME Desktop 2013.  I click on "Add Reader", then I select the format "Oracle Spatial Object" and then I click on the "Parameters..." button. A new window opens, called "Oracle Spatial Object Parameters". This windows contains fields related to "Database connection", "Constraints", ... I complete the required fields and click on the OK buttons to add the reader on my workbench. All works perfectly and I can read the data.  Now my question : once added to the workbench, how can I retrieve the "Oracle Spatial Object Parameters" window of the reader ?  Thank you for your help !

So, lists are hurting my brain again. For some reason I just can't get my head around the FME implementation despite being fine with arrays in general.  For each feature I'd like to create an empty list at the start of the workspace, with a structure like this:  _list._x _list._y _list._text  Then, at various points during the workspace I need to push a new element onto the end of the list (doesn't matter which end). So half-way through, the list may be:  _list{0}._x = 123 _list{0}._y = 456 _list{0}._text = "text"  and at the end it may be: _list{0}._x = 123 _list{0}._y = 456 _list{0}._text = "text" _list{1}._x = 999 _list{1}._y = 666 _list{1}._text = "hello world" _list{2}._x = 321 _list{2}._y = 753 _list{2}._text = "goodbye world"   At the end of the workspace I'll ListExplode it. That part I know how to do.  So two requirements: a) How do I declare the empty list. b) How do I populate it?  If populating the list (b) automatical

Hi,  (currently running FME server 2011 with an oracle repository DB)  Can any one point me to some metadata around the repository schema, in particular information on the column descriptions, i'd like to generate some reports against the database - but without geussing what the data columns represent.  I'm strugelling a little to understand the timestamps in the job tables in particular.  i.e when is a job submitted , queued, started, finished and deliverd.  I had assumed it was this order, but the time stamps don't seem to match this assumption.  Also, anyone got any suggestions for other useful reports to run against the repository information?  job duration, workbench failure (as opposed to job status), log path are all useful things i've extracted to date, which allow for useful incident managment and proactive capacity mamangement.  The idea that led to this question was trying to get an understanding on how hard the engines were being run - i.e when were jobs sta

Hi All,  Is there any python code to include in Shutdown python script area of workbench to terminate the fme.exe.  This is required so that, when fme.exe is not exited after translation is successful message.  

Why does Fme workbench  is still running after Translation was successful message is displayed in the translation log window ? 

Hi David ,  Thanks for your reply.  But my issue is the Fme.exe is not terminating after i get  "Translation was successful"  message in my workbench screen. I checked the task manager and  fme.exe was still available over there.  Inorder to exit it, i need to abort the operation. Can u suggest me any fix for this ?  Thanks, Srini

Hi there, I am trying to migrate Oracle dump datas into gdb. The reader reads every column except raw format type and giving a warning "skipping column". Has anybody have any idea?

Hello everyone!  To Run my FME Server Workspace i used the "Developer Information"-Button and copied the HTML Code to my FME Server in the ROOT-Folder.  When i open the HTML Page via Browser the DataUpload-Page appears and i can search for Data to upload.  If i then click the "RUN" Button to run the workspace i always get "HTTP Status 401" Error: This request requires HTTP authentication ().  Any Ideas? I already activated integrated authentication in IE-Options.  Thanks in Advance!  Ulf

Hi FMEers,  I am trying to wite out a KML from a single csv file using one of the fields as a fanout. There does not appear to be an option to use Fanout Dataset for OGCKML...am I missing something?  As an alternative I was trying to fan out feature types in a single KML output file using one of teh csv file attributes as the fanout. There translation completes but complaind that the fanout attribute didn't exist or had no value...but this is not the case and the translation succends if I remove the fanout by Attribute in the Feature Type?  Any help would be greatly appreciated.  Thanks, Mike

Hi dears,  when will be released the final version of FME 2013 SP?  Thanks in advance.  Kind Reagards.  Ramon Rocha.

Has anyone been able to link (not import) via SQL a choice/alias list to a published parameter to dynamically update the list based on the linked table at runtime.  I.e. the goal is not have to continually import / update choices each time the workbench is executed.   

My company has just upgraded to FME Workbench 2011 from 2007. Can someone tell me where to find the manual for FME Workbench 2011?

I have a workspace that compares a PATH HIERARCHY data set attribute of video file names to a GeoMedia Feature data set attribute of sewer segment names and does a feature merger on the two datasets when there is a match.  Sewers are usually videod from upstream to downstream and the video files are named according to the direction in which the camera was travelling.  My workspace gets quite a few matches BUT...there are occasions where the videos are named from downstream to upstream which causes my feature merger to send that video name to the incomplete branch.  I would like to parse the video name attribute and use the result to create a new attribute that is the reverse.  So 'MH07-121 to MH07-122' would become 'MH07-122 to MH07-121' in the new attribute.   Could someone please suggest an approach that would accomplish this for me?   Thanks.

Hello everyone,  Is there a way to sort a list using only a part of the attributes in a list--specifically a number?  What I need to do is re-order attributes according to an ID number from lowest to highest. Here is what the attributes look like:  34N27W_100700      34N28W_700700        35N27W_100100     35N28W_700100  These need to be placed in fields according to the order of the last six numbers only.  35N27W_100100      34N27W_100700         35N28W_700100    34N28W_700700  If I create a list out of these attributes, I can only sort alphabetically, which produces the wrong order.   I have tried separating the numbers into a list that I can sort but then the rest of the ID gets lost and I'm having trouble matching it up again. Does anyone have any ideas about how I can make this happen?  Thanks! 

Hello,  I have a workspace that updates an existing excel template.  When publishing it to a data download service, it writes the excel file, but doesnt use the file specified in the writer.  I know this is because the data download writes to a temp location, not the writer output folder - is there anyway to force it to use a template?  Owen