Authoring

Hi, I am creating a data download service with FME Server that should provide an ESRI File Geodatabase and an MXD file. The MXD file should be postprocessed with Python and arcpy in a shutdown script to fit the feature classes, extent and projection of the extracted data. The workspace transfer the MXD is to the FME Server output location together with the File Geodatabase. This works well in FME Desktop. The MXD is accessed programatically using an output folder published as a parameter. The same method does not work with FME Server. How do I access the MXD file in the FME Server output location programatically from Python? Regards, Knut Olav

Apologies if this has been asked before, I have tried searching Google/FMEPedia for it, with no luck. I'm having trouble getting the "request" string in our emails sent from FME Server 2012. Our previous FME Server 2010 emails - used the variable %request% - however I'm having no luck using } Below is what I have for our current "success" template: <fmeblock>Your FME translation (job ID {id}) has succeeded. Click on the link below to download the result:&#10;&#10;{urlPrefix}{ResultRootDir}/{@getFileName(@zip(OutputLocation))}&#10;&#10;</fmeblock><fmeblock>INFO: FME Request Parameters&#10;&#10; : This download file will only be available for 7 days, then it will be deleted.&#10;&#10;</fmeblock> <fmeblock>Time Started: {timeStarted} &#10;&#10;Time Finished: {timeFinished}</fmeblock> Which results in this: Your FME translation (job ID 306) has succeeded. Click on the link below to download the result: http://ERRDWAS89:8080/fmedatadownload/results/FME_2B5C0113_135543773925_15784.zip INFO:

Hi, I want to create a point for each species row 11, need create 3 points with the column name as an attribute NB the source data has approx 50 columns OBJECTID * SHAPE * WPT East North Date Azolla_filiculoides Blechnum_minus Carex_breviculmis Carex_geminata Carex_maorica Carex_ressectans Carex_secta Carmichaelia_corrugata Centella_uniflora Cheilanthes_sieberi Cordyline_australis Crassula_colligata_subsp_colligata Dichondra_repens 1 Point 26 2461536 5747297 4/12/2012 2 Point 27 2461489 5747326 4/12/2012 x x 3 Point 28 2461468 5747298 4/12/2012 x 4 Point 29 2461491 5747229 4/12/2012 5 Point 30 2461469 5747199 4/12/2012 x 6 Point 31 2461437 5747167 4/12/2012 x 7 Point 32 2461419 5747160 4/12/2012 8 Point 33 2461396 5747017 4/12/2012 9 Point 34 2461347 5746960 4/12/2012 10 Point 35 2461399 5747254 4/12/2012 11 Point 36 2461400 5747277 4/12/2012 x x x 12 Point 37 2461039 5747366 4/12/2012 13 Point 38 2461035 5747371 4/12/2012 14 Point 39 2461026 5747372 4/12/2012 15 Point 40 2460993 57473

Hi, I'm trying to connect to a database using the ODBC 3.x data reader. The parameters seem correct and I can see the tables in the Table list. When I try to add the data I get the error: ODBC2 Reader: Now reading schema for gistxtaxes Database Generated Error Information: Database Error Message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Table/View/Synonym not found (7519) Database SQL Statement Text: SELECT * FROM "gistxtaxes" WHERE 1=0 SQL State: 42S02 Variable Information: ODBC2 Reader: Failed to get schema for feature type 'gistxtaxes'. Continuing with next feature type in the list I can connect to the data base and add data in ArcMap using the same connection parameters. Any idea what's going on?

We have two default subscriptions on FME Server which are email tasks that occur on success or failure of a workspace: EmailJob_Success & EmailJob_Failure. Can these be assigned to specific repositories? What if you have two download portals on the same FME Server, can they have different e-mail templates assigned?

What does it mean when a writer is dynamic and what are the dynamic schema settings doing? Thank you to anyone can help.

I was wondering I do a lot of ad hoc workbenches to various databases and geodatabases. Is it currently possible (if not I would like to suggest it as an improvement) save the conection properities for teh databases I frequently. This would be a huge time saver and save on problems with typos.

How do I change/or add a Palette Name of a raster?

Hello Im trying to View my stored data on Oracle with FME Universal Viewer 32 bits. I have installed Oracle_Client 11g 32 bits on my PC. Also I have Win 7 64 bits When Im Trying to did it, it sent this message: Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`orcl', userName=`itu', password=`***', dbname=`') Failed to open database with username='itu', retrying using uppercase username Environment variable ORACLE_HOME is not set.

Is there a known issue concerning FME (in my case 2011SP4 and 2012SP3 aswell) about not being able to truncate Oracle base, stating: Truncating table `EESTITOPO.HYB_VOOLUVEED_75T_J'... Failed to truncate table `EESTITOPO.HYB_VOOLUVEED_75T_J'. Table may not exist However, when truncate is defined in the "SQL To Execute Before Translation" under advanced writer properties, then truncate operation succeeds. Thank you, Raivo Alla Estonian Land Board

??Windows?????????: fme.exe wb-xlate-1353554731187_5952 --SourceDataset_MapGis6x """""C:\\Documents and Settings\\Administrator\\My Documents\\1.WT"" ""C:\\Documents and Settings\\Administrator\\My Documents\\1.WP""""" --DestDataset_MapGis6x "C:\\Documents and Settings\\Administrator\\My Documents" ???? ... Feature Manipulation Engine 2012 SP2 (20120417 - Build 12238 - WIN32) FME_HOME is 'C:\\Program Files\\FME\\' FME Desktop Professional Edition (floating) Permanent License. Machine host name is: fangjun START - ProcessID: 904, peak process memory usage: 26024 kB, current process memory usage: 26020 kB FME Configuration: Command line arguments are `C:\\Program Files\\FME\\fme.exe' `C:\\DOCUME~1\\ADMINI~1\\LOCALS~1\\Temp\\wb-xlate-1353554731187_5952' `LOG_STANDARDOUT' `YES' `LogCount' `C:\\DOCUME~1\\ADMINI~1\\LOCALS~1\\Temp\\wb-xlate-counts-1353554731187_5952' Shared directories for formats are : C:\\Documents and Settings\\Administrator\\My Documents\\FME\\Formats;C:\\Program Files\\F

Hi, is there any way we can bring in an input file based on today's date? For example, if we save a file from a database every day, and today's file is called "20121114_Switch_Data.xlsx" can we have a default input (reader) to prepend today's date and grab the latest file?

Hi, I'm trying to debug a workbench and was and was wondering if it's possible to see the flow of one particular record. About 85k records (all with a unique ID) go into the workbench and flow through a network of transformers before all coming out via a single writer. I have identified several features that have been processed incorrectly but in order to work out what went wrong I need to work out the path they took through the transformers. Any suggestions on how to achieve this? Thanks

What is the best way to specify the output attribute name on a custom transformer? I can add a paramter , but the logical transformer (AttributeCreator) let's me link the value of an attribute easily enough, but not it's name.

I am reprojecting Rasters, 63 of them. They are all pretty much the same size 1.1GB. It took 2h to reproject the first one. now we are at # 32 and it's taking around 4h. Is there a way of doing a memory dump or starting fresh after each raster when doing batch reprojection? Thank you. Dominic

How do I specify what type of number I want for arithmetic operations? For example, when use the Attribute Creator and then the Arithmetic Editor to divide two numbers that are integers, the result is a rounded/truncated integer, but I want a number that is 3 decimal places...

Dear Team, I have installed the FME server 2012 on 2 servers. Now I would like to configure FME core server failure. I did the config changes in process monitor.txt but didn't work. Could you please help me out with this / Thanks a bunch in advance

I am using FME to produce a number of .xls files and need to rename those files by adding the current date (and time hopefully) to the file name at the end of the process using a shutdown python script. I have cobbled below together from information I have found online but it won't work and I don't have python knowledge to fix it. import os, datetime path='C:\\FME' to_ext='*.xls' for file_name in os.listdir(path): root, ext = os.path.splitext(file_name) t = os.path.getmtime(file_name) v = datetime.datetime.fromtimestamp(t) x = v.strftime( ' %d-%m-%Y') os.rename(os.path.join(path, file_name), os.path.join(path, root+x+to_ext)) I would appreciate any help. Thanks

In FME Server 2011 SP2, how do I configure the data download URL sent to the requester in the email, to show/use a preconfigured name in the URL versus the actual server name and port? For instance the download URL may look like this: http://myrealservername:80/fmedatadownloadresults/FME_7F685958_1352851611722_5036.zip. How do I configure it so that I can alias the server name and port for something other than the actual server name? Also is there a way to allow the user to name their FME results so it's not a long list of numbers/characters for their zip file (which would also make it easier to find specific log files when debugging workspace results)? Thanks!

Which FME desktop edition is suitable for Intergraph G/Technology platform?

Is there any class based FME training in the U.S.? More specifically in the west coast?

Is there anyone interested in doing FME Desktop training in New Plymouth / Taranaki at some stage?

Does anyone know if Tkinter will be wholly included in the included version of Python for FME? Currently I can import the module, but I get an error saying that TCL might not be installed properly. In the past Tkinter has been excluded from FME's Python, but I think the ability to be able to present a form to the user in the startup script would be useful

I have FME batch files that will run manually, but when started by the Windows scheduler they get hung when attempting to open a geodatabase. I suspect this is a Window scheduler problem, but I will glady accept any suggestions/thoughts. Below is the last couple of lines of the log file. |INFORM|Loaded module 'GEODATABASE_FILE' from file 'C:\\app\\FME\\GEODATABASE9.dll' 0|INFORM|FME API version of module 'GEODATABASE_FILE' matches current internal version (3.7 20111219) |INFORM|Opening the Geodatabase reader Have any of you out there in FME Land experienced a similar problem?