- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,045 Posts
12,618 Replies

When you subscribe we will email you when there is a new topic in this category

3045 Posts

Shared + Personal Database Connections

I have a database of shared connections in FME. I can use that to share my public database connections with coworkers, but they cannot edit that file (I believe this is because it's encrypted with my key). That's fine, but as a result - the person using my shared database/web connections can't create their own personal connections anymore without switching back to their own user database. Switching back and forth from the shared file to their own file seems like a pain. Are we doing this right? Is there a better way to do this now?

140

7 years ago

sussexpeteContributor

asked in Authoring

Conditional Attribute using derived output value

I want to extract a UK postcode from a free-format address field, but only if there is one.I am using the AttributeManager transformer with a new output attribute value: @Substring(@Value(OriginalAddress),@FindRegEx(@Value(OriginalAddress),"[A-Z][A-Z][0-9][0-9] [0-9][A-Z][A-Z]"),8) This works but I am getting unwanted results where a UK postcode is not found.An important point is that OriginalAddress is a derived output attribute: @UpperCase(@Value(OccAddress1) @Value(OccAddress2) @Value(OccAddress3) @Value(OccAddress4) @Value(OccAddress5))I would like to say something on the lines of: If there's a postcode then get postcode else don't bother.Is this possible without resorting to using a python transformer? Trying to set a Conditional Value in AttrubuteManager does not work in this case as only the original input attributes are recognised in the Output Values builder of the Test Conditions (that is, it's only seeing the OccAddressN fields).

590

7 years ago

annette2Contributor

asked in Authoring

Named database connections on FME Server - limitations?

Hi,My 2015 FME workspace was ready to be published to FME Server 2015 but named connections aren't supported. I see they are supported in 2017 so we will need to upgrade.My question: are there any other known limitations with the named connections on FME Server 2017 that I should be aware of. I'm using the named connections in the following way:I have 3 Oracle spatial connections in the Navigator using named connections linked to 3 published parameters. I also have 70 Joiner transformers, using Oracle Non-spatial, that reference the named connection as a published parameter.Are the above supported if I publish to FME Server 2017.1?I'd like to test but I don't have enough time allocated in this sprint to do so.Thanks,Annette

Query a workspace for resource dependencies

I am trying to publish workspaces via the REST api. Ideally I would like to programmatically get the workspaces dependencies before publishing to make sure the resources are on the server. When I manually publish via Desktop I get a warning about dependencies, I would like to access this info before publishing with REST. I am making the REST calls with Python so if I had a way to get the dependencies with Python that would be real neat.

2217

7 years ago

lifalin2016Contributor

asked in Authoring

Bug in FMW-to-FME export

Hi,It seems I've uncovered an error in the automated (when run) export of FMW workspace to FME mapping file.My setup includes a custom transformer, which contains a SpatialRelator. I just parameterized the SpatialRelator's "Input Ordered" and "Group By" entries (by choosing the automated creation of new published parameters). The "Group By" ends up as an optional "Attribute List (space delimited)".However, the workspace now fails with:f_51(TransformFact): Definition of transformer 'SpatialCrossJoiner_SpatialRelator' is invalid. 'PROCESS_GROUP_BY' statement doesn't have 2 tokensI then exporting it to an FME, and searched for "PROCESS_GROUP_BY", and found it.FACTORY_DEF * TransformFact:9:SpatialRelator \ FACTORY_NAME "$(SpatialCrossJoiner_WORKSPACE_NAME)_SpatialRelator" \ FACTORY_META_PARAMS \ TRANSFORMER_NAME:"$(SpatialCrossJoiner_WORKSPACE_NAME)_SpatialRelator" \ TRANSFORMER_PARAMS:XFORMER_NAME,$(Spatial

7 years ago

osalexContributor

asked in Authoring

using a prefetch query to populate a list parameter

Hi,I don't think this is possible but would be glad to be proved wrong. Can anyone think of a way to populate a list parameter from the result of an oracle query. I have an oracle schema where users can add tables. At run time I want the user to be able to select two tables from a drop down list and use those. Each time the workspace is run these table names would be different.

7 years ago

rob_dpfem

asked in Authoring

Where is propertiesFile.properties

I download FME server from the FME web site today October 16 2017 (FME Server 2017.1.1 64-bit windows FME Server build 17650)I am setting up an active/passive architecture. Mostly as derscribed on the web site https://docs.safe.com/fme/2016.1/html/FME_Server_Documentation/Content/AdminGuide/Active-Passive-Basic-Architecture.htm Everything has been going as described until after I setup the FME web services a third windows server 2016 VM. For the web application server I chose the FME Server Web Application Server (port 8080) I get stuck when I get to the first step in configuring the FME server for Failover. I can't find the web application properties file (propertiesFile.properties) specified as step 1 after the windows install at https://docs.safe.com/fme/html/FME_Server_Documentation/Content/AdminGuide/Install-the-FME-Server-Web-Services.htm#Install. I suspect its in <FMEServerDir>/Utilities/tomcat/webapps/fmedatastreaming/WEB-INF/conf/ but I can't find fmedatas

163

7 years ago

asked in Authoring

Attribute to specific form

Hi,Was thinking what would be simpliest way to make this..For example making 1-2000-K35 to 0012000K000035So idea is to have bunch of values into this same form.. (000-0000-K000000, without "-")Not sure how to explain it easier.For now I can make it with splitter, bunch of testers and concatenator.. Would think there is easier way to make it. Maybe with some regular expressions?

7 years ago

fmelizardContributor

asked in Authoring

Where can I find more resources about workflow management and parallel processing?

After today's webcast, where can I find more content about workflow management and parallel processing?

7 years ago

safetestesriuk

asked in Authoring

Is an article available about Batch Processing?

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

7 years ago

ian_s

asked in Authoring

Does anyone know of any tools to automatically document workbenches an organization may have in a searchable way? Similar to DocUtils for python?

7 years ago

tale

asked in Authoring

Fanout on dataset level not working in a chained workflow in FME Server 2016

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

jdhContributor

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

Manually trigger a recover

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

2700

7 years ago

chriswilsonContributor

asked in Authoring

Connections partially disappearing at runtime

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.

7 years ago

steveg374

asked in Authoring

Auto Connect not working in the Attribute Connections window

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 to write schema field names and data types

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

660

7 years ago

whkartoContributor

asked in Authoring

Transfer attributes from neighbouring text features

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!

7 years ago

vid

asked in Authoring

Atribute Manager- deletion of the atributes- saving to csv

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.

7 years ago

velasquezvictor

asked in Authoring

Errors using FMEServerJobSubmitter

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.

260

7 years ago

reveszContributor

asked in Authoring

Is it possible to set job_id initial value after install?

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

FME Python - Can't find module (ArcPy)

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\\

How Can i create parameter at work space level, that parameter values need to change at runtime ? it is possible in FME desktop 2016.

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.

7 years ago

erik_janContributor

asked in Authoring

Are you looking for a FME training class?

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.

7 years ago

egaru

asked in Authoring

Passing parameters from a workspace to a scripted parameter of a custom transformer

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

7 years ago

Page 77 / 122

Badge winners

qunhrwywnxamhas earned the badge Teacher (Grey)
qunhrwywnxamhas earned the badge Student (Grey)
babarkashif99has earned the badge Teacher (Grey)
babarkashif99has earned the badge Student (Grey)
yufewfj347has earned the badge Expert (Grey)

Show all badges

30,539: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.