- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,048 Posts
12,635 Replies

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

3048 Posts

jelleContributor

Undefined macro `FME_JOB_ID' dereferenced when using ParameterFetcher in a Workspace triggered by WorkspaceRunner

I have a chain of WorkspaceRunners that I need to bring to FMEServer, but it should still be possible to run them in Workbench as well. So, I created a TestFilter where '$FME_JOB_ID' NOT has a value. If it does not have a value, a WorkspaceRunner is triggered. It fails with the message:Undefined macro `FME_JOB_ID' dereferenced in file `ReferencedWorkspace.fmw'An error occurred during the batch file execution, 1 translation failed. The following error message was raised: #2 : Undefined macro `FME_JOB_ID' dereferenced in file `ReferencedWorkspace.fmw'The parameterFetcher in the 'ReferencedWorkspace.fmw' causes this error. The Workaround I made was to put a value 'N/A' in the 'FME_JOB_ID' of the ReferencedWorkspace (which also contains a TestFilter but with '$FME_JOB_ID' NOT has a value or = 'N/A'). So two questions:why do I get the Error message in the first place? The Main procedure does not require the 'N/A' value for the FME_JOB_ID. It seems that the WorkspaceRunner does not resolve

1344

5 years ago

agelfertContributor

asked in Authoring

Is there an easier way to send a summary report of successful workspace completion?

I have a workspace that runs using FME Desktop and the windows task scheduler. I would like it to send out an email notification upon successful completion that includes a total record count, a list of ID of all the records, and a timestamp.In my specific instances, I'm using a FeatureWriter to write lines of text to a number of text files that are named using fanout and a unique ID field. What I've come up with works but it feels clumsy. The screenshot below leaves out the actual FMW processing and starts with the Writer (bottom left) and another branch feeding in records.Maybe you agree - there has got to be a better (more out of the box) way to do this, right? If so, I'm all ears.Footnote: Most of my stuff runs in FME Server which utilizes notifications there (although not with the above type of summary), so I have never had to dig into bolting on things after your writer finishes up,

Creating a list from an attribute

I have created an attribute from a database table for planning applications and this ultimately will populate an excel spreadsheet.My question is in the excel spreadsheet it is coming though with the code of the different application types and for the audience that the spreadsheet is intended for it would make more sense to have the description pulled through.i.e in the spreadsheet it is showing as ADV and i would like to convert this to advertisement consent

390

5 years ago

dustinInfluencer

asked in Authoring

WorkspaceRunner question

I am working in FME2017. I have a parent workspace that calls on a child workspace via the WorkspaceRunner. Initially, both workspaces are stored in the same directory. If I move the parent workspace to a different location, the directory specified in the WorkspaceRunner automatically updates to the location I move the parent into. Since the WorkspaceRunner can no longer find the child workspace in the location being called, all the parameters are now cleared, and the WorkspaceRunner is flagged as an incomplete transformer.I can work around this....But, is this expected, or is this a bug?

210

5 years ago

nedwatermanContributor

asked in Authoring

FME Server Error: Found an uneven number of server parms

I've uploaded a workspace to FME server which runs on Desktop but errors out there:All the parameters are completed, but when I try to run the workspace FME Server returns this error: When I click on the View Details button I get this: Does anyone have an idea what I am doing wrong? I've attached the workspace.ThanksNeil

scarterContributor

I'm trying to understand Fanout better. I ran a test with a planning appeals points dataset where I set the output to split the source data into subset .tab files based on a the 'decision' field. This worked and created 19 tab files as there are 19 possible decision values in the source data. However there are two issues: 1 The process places the outputs into their own folders (e.g.: the process creates a folder called Split decision which then contains the tab file showing just the split decision valued records. (It’s doing this because of the issue raised in point two below) Is it possible to places all 19 output .tabs into the same directory folder? 2 The output tab files are all called the same name as the source file. The source file is called ‘LBS Planning - Decided appeals’ and all 19 output files are also called ‘LBS Planning - Decided appeals’. Can FME rename the output files along the lines of the value it is sub-setting? So, for example, I’d want one of the 19

5 years ago

oiram

asked in Authoring

Merge Aircom Enterprise Files

I have to write multiple consecutive datasets (adjacent tiles) to Aircom Enterprise files.Is there any possibility to merge new data of adjacent tiles to the existing clutter file in the folder instead of overwriting it?

5 years ago

deanhowellEnthusiast

asked in Authoring

FeatureWriter attributes settings not holding

Hello FME Support, I am running FME Desktop Version 2019.1 and have found that the user attribute settings are not holding after being changed in the FeatureWriter.I have an attribute called "category" which was using the conditional option to set one of two options. I wanted to add another option that had multiple parts First thing was that I had to type the 'AND' as it wouldn't select from the list and secondly it did not save once I pressed OK.

5 years ago

vajnorcan

asked in Authoring

Custom FME Parameters (not server)

Hi all, I'm FME newbie, though I kind of know what this thing does. I've inherited around 30 fme workbenches I need to update, as a developer I'd like to get things in the config files for different environments so I'm externalizing the props (parameters) via the Private Parameters (scripted). As I have to do this for all 30 workbenches, is there a way I can add my own custom params directly into FME that would become available as FME Parameters? Thank you

5 years ago

freddie_kwak

asked in Authoring

Loop through attributes by specific id that matches column name

Hello everybody, I hope somebody can help me with the following challenge:I have 2 datasets/dataflows in a workbench:-1. MeldingData: One set contains registered data like roadnumber, type of animal, status, etc-2. FormData: The other set contains the pulldown menu options from the iASSET application database where the value is shown in the first dataset. The set MeldingData has colomn names like data.100003, data.100004, data.100024, etc. The number of the colomn from MeldingData matches the colomn id from FormData. I want to replace the code in MeldingData with the matching value/label from FormData, so it makes the dataset more readable.An example: the first row of MeldingData has value 05 in colomn data.100004. This means that this notification/call is made on roadnumber N373. Al the other colomns need to be processed simmilar. I attatched the workbench and an excelfile with the MeldingData and FormData. I hope you understand my explanation. If you need more information, please let

5 years ago

tnarladniEnthusiast

asked in Authoring

modify value of attribute in second position

I want to modify the attribute in the second position of an excel. I can get the schema of it and the attribute{1}.name is the actual name of the attribute. But now how do I put in a new value because attributeManager, or tester expects you to know the attribute name and I wont have that.

5 years ago

boubcherContributor

asked in Authoring

Change Detector , dynamic schema

Hello there Is there a way we could apply the change detection but reading dynamically each orgine and revised input , because we have a large number of table to check Thanks

How to add features to table combining two sources?

Hi,I need to merge data from two tables and create third table that groups features by year (see picture below). Is there any easy way to do the task? I am stuck with this and tried FeatureMerger but no luck so far...

5 years ago

bwassersteinParticipant

asked in Authoring

Prepare an isolated, unrelated database table for a file fanout without an existing fanout attribute

I'm reading in a single Access database with multiple tables that contain a common attribute, then outputting multiple Access databases via a fanout on that common attribute. It's quite a simple translation. However, I have an isolated, unrelated table that does not have this common attribute field, but I would like this table to be written (in its entirety) to each fanned out Access database. To illustrate this I'll provide an example:Input DBtable name: StateStateAreaPopulationAZ14AK25CA36 table name: RoadsStateRoad_nameLengthAZa7AKb8CAc9 table name: ContractsContract_nameDescriptionthisetcthatetc Output DBs - Fanned out by "State", but I want the Contracts table to be written in it's entirety to each.AZ.mdb - contains the "State" & "Roads" tables (with just "AZ" records), and the "Contracts" table in it's entirety.AK.mdb - contains the "State" & "Roads" tables (with just "AK"

5 years ago

mikeherel

asked in Authoring

Hadoop Data Connection Configuration with Kerberos Support

I am trying to configure a Hadoop data connection in FME Desktop 2018.1. I have installed the JDBC driver supplied by iut IT team so I no longer get a driver error bit I now get the error below. We use Kerberos security but it's not clear to me if this is supported in FME Desktop for this connection type. Is it? I use the same connection parameters as used in Oracle SQLDeveloper, which works there.The error seems very generic but any help is appreciated.Error Log:java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://ourServer.com:10000: Peer indicated failure: Unsupported mechanism type PLAINat org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:222)at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)at COM.safe.fme.jdbc.JdbcCommon.openConnection(JdbcCommon.java:467)at COM.safe.fme.jdbc.JdbcReader.openHelper(JdbcReader.java:187)at COM.safe.fme.jdbc.JdbcReader.open(JdbcReader.java:157)Caused by: org.apache.hive.org.apache.thri

Loop and Clipper with Overlapping individual output

Hi, I looked at many previous questions but didn't find a good answer to solve it so I make a new question with many screenshots. My Workspace.I create 1 box between 0,0 and 100,100 and 20 random circles with a radius of 5 with a center within that box. I send all circles to a custom transformer "cutloop"(I somehow need to attach a loop within here, and maybe an expressionevaluator and tester this is the main part I need help with)My writer is a dwg with a fanout expression so if I run it as it is now I get 20 "InsideX.dwg" layers for each cut box feature. This is very important part, I must have one file for each part of the box where a circle overlaps. My problem as it is now, is that some circles overlap, and since all features are read as one, the inside is not working correctly and I dont get full circles. I want individual full circles for the box which is inside each circle. (Inspected before I write each circle separatly) (Blue now I want red)Everything

metadata update (multiple tags)

Hello,I am using XML updater to update geodatabase metadata and it works well with single tag value.However when there are multiple tags it updates all of them with the same value. XML path in XMLUpdater: dataIdInfo/tpCat/TopicCatCd – before the change <tpCat> <TopicCatCd value="007"></TopicCatCd> </tpCat> <tpCat> <TopicCatCd value="018"></TopicCatCd> </tpCat> XML path in XMLUpdater: dataIdInfo/tpCat/TopicCatCd, change value: 44 – after the change <tpCat> <TopicCatCd value="44"></TopicCatCd> </tpCat> <tpCat> <TopicCatCd value="44"></TopicCatCd> </tpCat> Expected results after the change<tpCat> <TopicCatCd value="44"></TopicCatCd> </tpCat> <tpCat> <TopicCatCd value="018"></TopicCatCd> </tpCat> Any help much appreciated. Many thanksMagda

FME AR App (Android): displaying a model below ground plane

I have a model (the pipe) that's below the ground, and a polygon (red) on the ground that I want to use to anchor the pipe model, like in this video (and second image below): https://youtu.be/W6uzB2A8T5s?t=85My (obj) 3D model has the red polygon on elevation 0 and the pipe with negative elevation. Unfortunately, when I load the fmear file, the bottom of the entire model (polygon+pipe) becomes 0, and the ground plane polygon floats in the air, which makes the placement impossible. Is there a way to push the pipe below ground? Since the app is on github I wouldn't mind trying to compile it, I just need to know what to change. For now hardcoding the offset would work too.

5 years ago

takashiContributor

asked in Authoring

Sharing: Detailed Profiling of Workspace Running Performance

Hi all, Try adding this line in your workspace header (Menu: Tools > Edit Header). ----- FME_PROFILE_RESULT_CSV C:\\FME\\prifile_result.csv ----- Then run. A csv file describing detailed profiling of the workspace will be created, like this image. Today a seminor on FME was held in Tokyo as an official activity of the World Tour in Japan, Kevin@Safe told us this secret directive. He also said that a user interface such as a button will be added to Workbench for this functionality in the near future. I like this hot information very much, so would share with you! Takashi

REVIT, Python and FME

Hello, we are conducting a topic on BIM and GIS for our graduation project. We added the modem models in the building model that we modeled through REVIT and then added their shooting areas as a 3d sphere. In the 2-storey building, the sphere added to the modem in the ceiling appears on the base of the upper floor. This problem is also suggested by our teacher to solve the python and write a script about it. So we need to write a script that would prevent the overlay of the circles we added on the modems from the walls, but I couldn't see an example of this before, nor did I find any code written on python. I have a limited knowledge of Python, but I think we can handle it if we have a topic or an example. We will then integrate the Python script with the FME program. I'm waiting for your ideas related to the Python code that we will integrate into the model in the revision.

5 years ago

vchalmel

asked in Authoring

Is it possible to make a transformer wait for the termination of another one ?

Everything is in the title, I have several operations on a single input dataset branching through several levels of operations. Ultimately I have some mongodb writers and python callers loading transformed data. I want to be sure that one python caller won't start before another one has ended (the first one will create documents, and the second one pushes elements into arrays within those documents).

9030

5 years ago

agelfertContributor

asked in Authoring

Trigger email notification after TXT line writer completes?

I have a process that writes a number of text files. Just figured out how to populate an email with a number of pieces of information about each runtime, time, feature count, etc. But it's basically sending the email in parallel with the writer finishing up. I would like to have the writer trigger the email, similar to how it's described here.https://knowledge.safe.com/questions/4963/sending-mail-in-fme-desktop.htmlI can replace my TXT writer with a feature writer and write to TXT but there appears to be no fanout feature with the FeatureWriter? if that's so, is there another way to have the email kick off only after text writer completes?

110

5 years ago

gabriel_hirschContributor

asked in Authoring

FME 2014 alpha release on Linux/Mac?

Even if its a couple of months before FME 2013 will be releases I'm eager to try out FME 2014 on both Linux (Ubuntu) and Mac OS X. Is it possible to become a alpha/beta (or even pre-alpha?) tester of FME 2014 in some way?

5 years ago

lazarlubomirContributor

asked in Authoring

How to configure TXT structure

5 years ago

mukhtargContributor

asked in Authoring

Looping or workspace for Iteration

Hello,I have some shapefiles in a folder Is there any way the workbench does select all files one by one and do the processing. The workbench that i have designed works fine for one shapefile and gives me the output in Excel in sheet 1.Also i have created a workspacerunner.This is not giving me the desired output. I need output of all the shapefiles in excel in different sheets respectively.Any help is much appreciated.

1830

5 years ago

Page 41 / 122

Badge winners

lundg1has earned the badge Integrate Data with the FME Platform Training
bezearvhas earned the badge English Speaker
bezearvhas earned the badge French Speaker
bezearvhas earned the badge German Speaker
paul.stanleyhas earned the badge Welcome Back

Show all badges

30,410: 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.