Authoring

I'm wondering whether there is a Knowledge Base article on batch processing using the workspace runner

I am trying to create a data download service in FME Server 2016 (single engine), but have run into some problems.I have a master workspace that is created as a Data Download Service in FME Server.The master workspace is structured as follows: The data order is chopped into sub-orders and passed into an FMEServerJobSubmitter. The workspace called by the FMEServerJobSubmitter stores the exported data into a folder (the folder name is specified as a parameter in the FMEServerJobSubmitter). When all the sub-orders are completed, a FeatureWriter (FileCopy) moves the folder and its contents into the FME_SERVER_DEST_DIR, and the data is then zipped and shipped.Most of the writers in the sub-workspace have fanout, and this is where my problems begin:The writers that only have fanout on the feature type level work fine. For instance, a shapefile writer that simply produces shapefiles with different names works perfectly. The writers that have fanout on the dataset level produce junk files. For

What would cause an an fme.exe/fmeworker.exe process to become suspended?

Folks,I have an odd scenario. I was working on a workspace and my PC crashed. It was not FME related. In fact it was during a file copy and there's some issue with my network card driver.I had unsaved edits.I found a recover document that points me to another location with a "wp_" prefix file. It looks like this is some kind of log of edits. Checking the "wp_" file it seems to have most of my edits.The odd thing is on restart I wasn't given the option to recover.1. is it possible to trigger a recover?2. is it possible to parse the "wp_" and get some if not all the pending edits back?Thanks in advance

I may have missed something, but when I run the workspace I'm working on right now one of the connections - between a Sorter and an XMLTemplater - partially disappears and only shows behind the feature count. See the attached screenshot. Any ideas there?This is in 2017.1.1 build 17650, 64-bit.

The "Auto Connect" button in the Attribute Connection window is not working. This has been a problem for a couple of years now, but I'm just now reporting it as a problem. Is this happening for anybody else? Is there some way to fix it? It would save me loads of time if I could get it to work properly.

How can I write feature column names and data types only to excel, ie, no data. For example, take a feature reader of any type and print the column names as rows in excel, and adjacent print the data types. Name | textSize | intDiameter | float

Hi,I'm facing some troubles to figure out how to transfer some attributes that are present on some text lines to subsequent text line features. See below a screenshot of my data situation Whenever -99 occurs a new dataset begins. The next two number are static values and then various measured records will occur. What I'm trying to achieve is, to pass on the two static values to every record ot the dataset. As soon as a new dataset (-99) begins the mechanism should reset and now use use the most recent values for inheriting.Find attached my current workspace together with a small sample dataset. Thanks for your help!

Hello!  I am FME beginner. I am working with table where I have 38 different attributes. I would like to extract only 2 of them. I used for this AttributeManager Parameters where I simply set Action for attributes which are not interesting for me as REMOVE. However after Adding Writer and saving documents as .csv I got result like on the left side (Fig. 2). I would like to get result which is in the record J. I assume that this tool just clean content which refers to specific attributes instead of deleting whole atribute with all values.in FME Data Inspector result of my deletion looks like this so I don't understand why is it saved in the .csv file in other way with all pipes. I know that I could copy content of the values from data inspector and paste it to .xls sheet or .txt file. However, I would like to do it fully automaticaly.  Any tips? Or should I use different tool for atribute deletion? I am grateful for all hints.

Hi,I'm following the tutorial on FME Server Workflow Management, when I try to get the output from the previous workspace ran by FMEServerJobSubmitter using output_datasets{} I'm getting the error:'SPATIALITE reader: file 'output_datasets{0}.path' cannot be located. Please ensure the file exists and is accessible' I'm usign FME 2017.0.1.1 Build 17291 and the latest version of FMEServerJobSubmitter, I notice the latest version does not have the option 'Ouput Data Location', according with the help, Output Data Location needs to be set to Temporary Folder . Thanks!Update: I need a way to tell the next jobsubmitter the output location of a file.

Before I get my hands dirtyI regularly backup the fme_job_history table for analysis. When I upgrade FME Server I'd like the job_id to remain consecutive instead of restarting from 1.Is there a way to set the starting job_id after a re-install?In SQL Server fme_job_history.job_id is not an identity column and I cannot see any hint in sqlserver_createDB.sql

Hi,I'm running FME Desktop 64bit and trying to run a Python shutdown script. The script utilizes ArcGIS Pro tools and is written in 3.5.I get "Python Exception <ImportError>: DLL load failed: The specified module could not be found." I narrowed it down to the arcpy module. The initial arcpy that comes with ArcGIS Desktop is 32bit, however, Pro comes with arcpy as well and is contained in C:\\Program Files\\ArcGIS\\Pro\\Resources\\ArcPy. This is the one I'm trying to use. My script is below.import os import arcpy print (os.path.abspath(arcpy.__file__))The above script runs successfully in Sublime and IDLE (ArcGIS Pro), but the error occurs in FME. Here are the things I've tried already:Change the FME interpreter to the same interpreter as Sublime (C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\python35.dll)Change interpreter to Esri ArcGIS Pro 1.4/2.0+Python (3.5+)Copy ArcPy folder from Pro/Resources to C:\\Program Files\\ArcGIS\\Pro\\bin\\

Hi All,I need write custom XML, that contains list of child's for each element. for that i am using XML template and SQLexcuter. but the problem is for SQL execute need to pass the value as a dynamic.SQL excute transfer fallowed by creater trasformer.ex : Create-->SQLexcuterex : Create-->SQLexcuterex : Create-->SQLexcuterI need to pass Id values for Common.Please help on this.

After talking to @RylanAtSafe, I want to create an opportunity for FME trainers to publish their training schedule on the Knowledge Center.All Certified FME trainers are invited to publish their In-person FME training here.This is not replacing the Safe Software training calendar, but merely an additional opportunity to share the FME knowledge.

Hi everyone I have an issue with Scripted Parameters inside of Custom Transformers (CT). More specifically, I have a published parameter in a workspace that receives the path to an SDE connection file. This parameter is linked to a CT attribute. Inside of the CT, a published parameter receives this path. Then, several private scripted (Python) parameters read credentials from a configuration table based on this sde path. The credentials are then used in a PythonCaller in the CT.However, the content of the original Sde-parameter from the workspace cannot be used in the scripted parameters of the CT. Instead of its content, only the name of the parameter ("$(Sde)") is there. But when I hard code the path into the corresponding parameter of the CT in the workspace (instead of linking it to the published parameter), it works.Do you have any idea how to fix this or to get a functioning workaround? To illustrate the problem, I attached a simplified example of my issue. I tested th

Hi,A customer requests a nation wide set of themes to be "cookie-cut" into separate municipalities. Each municipality should have a complete set of themes in its own sub folder.I'm using a dynamic output to TAB, with Table name set to:(A)Value(MUNICODE)\\(A)Value(fme_feature_type)But FME just substitutes the "\\" (and "/") with an underscore, so all tables end up in the same folder.Is there a way to tell FME to create the sub folders and put data into these ?Cheers

Hi! I have a workspace with two HTTPCaller transformers. Both of their output ports are piped to some logic to generate features and write to database. There is a FeatureHolder between the HttpCallers and the writers, such that nothing will be written before all the HTTP calls are finished (either complete or error). Both of the HTTPCaller <reject> ports are piped to a Terminator transformer. I want to make sure the workspace will terminate without any feature written to database, if any of the HTTP calls fails. When I test ran the workspace with some failure in HTTP calls, it did what I want. However, because I couldn't find instruction to help me make sure Terminator will always be executed first, because conceptually when a rejected feature is travelling towards the Terminator, another feature may come out of FeatureHolder and race towards the writer.Any way I can make sure that?Thank you!

Hi all, I have a workbench which returns multi page .Tiff files as xml then outputs back to Tiff. I use the XML Flattener, TextDecoder and RasterReplacer transformers to decode and rasterize the images. I then write to Tif but the writer only returns the first page of the multi page Tif. Any ideas on how to return all of the pages? Below is a screenshot of the process. I'm thinking it could be something to do with the RasterReplacer not populating the tiff_subdataset_name' which delineates a multi page Tiff file.Thanks,Stuart

Hi, I would like to know if the following is possible and how: I have several identical Access backend databases (one for each client, same scheme - different data, several relationships, links and foreign keys). I would like to merge all of them to one MS SQL database and add an identifier for each client data. One time only! How to handle original relationships? Example: InvoiceID and InvoiceLine for each original database. I’m talking about Access DB, but I could convert them all to MSSQL and then merge… All front ends will connect to this database, but each client will be able to see only each own data. Any help? Thanks! Jairo

Hi,Web and Database connections are great but you can create the same name for Web and Database in FME Desktop under options, but when you load it to Server it comes back with duplicate name already existSurely options in Desktop should adhere to the same rulesJust an observationRudy

Is there a notable performance difference between SQL Creator performance vs. Oracle table Reader performance. We have a script that take 3.5 hours to run and are looking for ways to help it along.

This answer probably exists, but still can't find it...I'd like to install custom reader on FME Server (2017.1.1.). Double clicking installs only on FME Desktop.Thank you,

HI! I installed Anaconda on a windows server, for all users, then I followed the set-up in my workspace TOOLS > "FME Options" > Translation >  "Python Interpreter" checked "Use Custom Python Interpreter" and provided the path (C:\ProgramData\Anaconda3\python36.dll)The log then shows : Loaded module 'PythonFactory' from file 'C:\Program Files\FME2016\plugins/PythonFactory.dll' FME API version of module 'PythonFactory' matches current internal version (3.8 20160224) The user-specified Python interpreter `C:\ProgramData\Anaconda3\python36.dll' is version 3.6 (PythonFactory): A Python installation could not be detected. PythonFactory could not initialize A Python installation could not be detected. PythonFactory could not initialize A fatal error has occurred. Check the logfile above for details

Hi,Initially, auto-layout is working well, but suddenly showing the error as shown below...Does anyone came across and identified solution for it...