- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,024 Posts
12,530 Replies

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

3024 Posts

Recently active

Most replies Most views Newest first

helmoetzContributor

asked in Authoring

Duplicate records reading from zipped open file gdb

Hi this puzzles me: using FME(R) 2022.2.3.0 (20230131 - Build 22789 - WIN64), when reading an Open File Geodatabase from a zip file, features are duplicated. I created and attached a template which demonstrates the error. The workspace uses two readers to demonstrate the phenomena, both of type File Open Geodatabase.The first reader reads from ..\test.zip\test.gdb The second reader reads from ..\test.gdbRecords on the first reader are duplicated. When reading from just test.zip the duplication does not take place. Is this behaviour as meant to be?

161

16 hours ago

peteratqfesContributor

asked in Authoring

AttributeWriter and DataStreamer

Hi, If I’m writing a fme-binary attribute out to jpeg using an AttributeFileWriter is there any way to publish as DataStreamer on FME Flow?

182

1 day ago

sussexpeteContributor

asked in Authoring

FME Workbench and other FME Form software broken by VMWare Tools

Since updating our FME Form host computer with the latest version of VMWare Tools, FME Desktop, FME Data Inspector, and all other FME Form GUI software does not run.We briefly get a spinner and then nothing. The problem was noted on FME version 2021 but is a problem with all version of FME Form up to the latest version FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64).It is still possible to run Workspaces in batch mode.The issue seems to be with OpenGL as indicted in the log, below.I would be interested if others have the same issue and, if so, how the issue can be resolved.Here is a snip from the log file:VMWare Tools v12.5.0.24276846Faulting Module = vm3dgl64.dllWorking Version = 3.5.3.2Faulting Version = 3.6.0.0 Event Log:Faulting application name: fmeworkbench.exe, version: 2021.7.41.21614, time stamp: 0x60f7b7a5Faulting module name: vm3dgl64.dll, version: 3.6.0.0, time stamp: 0x66a16726Exception code: 0xc0000005Fault offset: 0x0000000000e3696dFaulting process id: 0x1becFaulting

137314

1 day ago

fbastian73Contributor

asked in Authoring

sequentially looping a workspace using attribute values

Hi,I am wondering if someone can give me some ideas on how I could pass the result of a sql query from a sql executor so that the result or specifically an ID is passed sequentially so that each is fully processed before the next one starts. So the result is as shown below. The attribute I’d like to pass one by one is either the device_id or the row_index.I have had a look at this post iterating/looping a workspace using attribute values | Community but cannot formulate the workbench to do this task.Any suggestions very welcome.Thank you.fb

375

1 day ago

kalbertContributor

asked in Authoring

Replace JobWaiter with HTTPCaller

Hello,FME Flow announces the deprecation of the JobWaiter transformer:2024-9-2 10:59:42 | FMEFlowJobWaiter (ServerFactory): FMEFlowJobWaiter was deprecated in 2024.1.0. Its support lifetime is limited because the v3 FME Flow REST API will be removed in future FME releases. When the v3 API is removed, this transformer will stop working. Please update this workspace to use an HTTPCaller to call the relevant REST API directly instead.Question: Is there any ‘how-to’ with a sample workspace which REST call can be used to replace the JobWaiter functionalities? My sample scenario would be: You have 5 jobs running in parallel (wait to complete NO), JobWaiter polls every 20sec until all 5 job_ids are received and completed. all 5 jobs must have _status SUCCESS before Job #6 is called.I tried GET /transformations/jobs/id/{jobid}/result but it failed with 404. Any hint?thanksKlaus

14512

2 days ago

wilContributor

asked in Authoring

close connection to postgres db after query execution

Connection to postgres seem not to close after query execution to postgres db. We are here allowed to have 5 connections to the postgres db and with the SQLExecution for each feature entering the transformer, a connection is established but seem not to close after the the query has been executed. After 5 features have entered the sqlExecutor I receive an error message: Error connecting to PostgreSQL database.....................: 'FATAL: too many connections for role "xxxxxxx"Is there a way to close the connection after each featue that enters the SQLExceutor? We are using FME 2021.1

sterlaParticipant

With a permanent licence fme desktop hit much engines do we have available ?

418

3 days ago

sterlaParticipant

asked in Authoring

reutilization of permanent fme desktop Licence in new machine

Hello, In the case of having a permanent FME Desktop license, can it be reused on new machines ( i want to use it only in one engine so i would like to know is it possible to use it in anothe engine), or do we need to purchase new ones?

181

5 days ago

rzel24Contributor

asked in Authoring

GoogleBigQueryConnector Failed to Authenticate

Hello,I’m having a hard time figuring out why a json file created with a Text Writer is not accepted by the GoogleBigQueryConnector.I have an original JSON Key File downloaded from Google Cloud for the Service Account we are using to authenticate to BigQuery. This JSON file works fine and I am able to authenticate and select the Dataset I want to upload data as well as the table in that Dataset.The problem is that since I have to use a system environment variable and specify the service account key file location in that variable in order for the GoogleBigQueryConnector to be able to use Service Account instead of Web Connection, it seems the GBQC takes the project_id specified inside that json file and uses it as default project to log you in, which means that even if you have access to different projects in BigQuery you can only access 1 project per Service Account Key File.Here is an image of the error I get for when the GBQC tries to use the JSON file to authenticate into BigQuery:

465

6 days ago

stuarmitagehomeContributor

asked in Authoring

Flow - How do I configure a published workbench to read all files in a Resource folder

Hi,I have a workspace the reads json files: I need to publish this to Flow, and configure parameters to enable the user in Flow to read files from a certain folder. This will change several times, and I do not mind this part being a manual process.I am unsure of exactly how to configure this.I have set up a Folder and Pathnames user parameter:I have configured it to select Folders, and called this “SourceDataset_PATH”. I have then configured the parameter for the json reader to point at the SourceDataset_PATH parameter. I publish to FME Server, run the workspace: I have used “Browse Resources” to find a folder “Test 1 file” and hit Run.If fails after a few seconds:54 2024-11-13 17:17:27 | The file 'C:\ProgramData\Safe Software\FME Server\resources\data\WACSTEST_1_to_5\Test 1 file' could not be opened 53 2024-11-13 17:17:27 | Opening the JSON reader with source dataset 'C:\ProgramData\Safe Software\FME Server\resources\data\WACSTEST_1_to_5\Test 1 file' 52 2024-11-

264

6 days ago

georgiecContributor

asked in Authoring

Reader is making my schema lower case

I have a series of Feature Services in ArcGIS Online. Unfortunately they contain attribute names of varied case. This is proving difficult for me when I try to create a dynamic workflow that updates the data in ArcGIS online. When the Reader reads the source data (also of varied case), it converts them all to lower case.Therefore, when my workflow tries to write to ArcGIS online, it cannot find matching attributes to write to because the case is different.It is now too late for me to change all the layers on ArcGIS online to lower case because of downstream dependencies. Will I have to write a separate workflow for each individual layer and individually do the field mapping?Or is there a way around this ?

344

6 days ago

georgiecContributor

asked in Authoring

Dynamic Feature Reader - picking up schema for 1st feature type only

From a csv file, I determine the target layers that I wish to update on ArcGIS online.The following 2 transformers build the source layer name deriving it from the csv data.My source data name is an attribute titled “portalservice_andfolder”This is fed to a dynamic reader that reads my enterprise portal for each layer.There’s an issue with the Reader. Refer blue summary for settings.I’m getting all the features come through but only the schema for the FIRST feature type only.Refer the below image which is the result <Generic> port from my reader. The schema port has a count of 1 when there are actually 2 source layers.The image below shows that the fme attributes are missing for the second feature type.I tried throwing in a SchemaScanner after the Reader but still only arrived at one schema. The issue appears to be in the Reader transformer.What am I missing here ?

110

6 days ago

jdhContributor

asked in Authoring

Dynamic raster recoding

Hi,I have a scenario where I need to recode the pixels of raster, but the values are determined at run time.I have a list of from-to values, but what is the best way to implement that?The RasterCellValueReplacer will take attributes, but not a list. Is there any way other than looping through the list and recoding the raster one value at a time? There can be anything between 1 and 300 elements in the list.

404

7 days ago

pgammieContributor

asked in Authoring

Dyanmic ESRI File Geodatabase Writer: Drop and Create not working

I am writing to a file gdb, I will need to run my workbench to update this file gdb each month. The schema of my incoming tables may change so I have used a schema scanner with a dynamic writer.I want to use drop and create for table handling but it is not behaving as expected. Instead of dropping the existing feature class it just appends the entries to the existing table.I am not sure why this is happening. Of note, my feature classes are also within feature datasets. See attached screenshot of writer settings.

606

8 days ago

matiassalinasContributor

asked in Authoring

Esri Geodatabase (File Geodb Open API) in Mac arm64

I’m trying to follow the FME Form course from a MAC and one of the very first exercises is using a Esri Geodatabase (File Geodb Open API) writer. Unfortunately I’m getting this error on the platform. Is there any workaround for this?

Error: “the number of points is less than required for feature”,

Error: “the number of points is less than required for feature”, We are extracting data from CAD files. The destination is layers stored in ESRI file Geodatabase. Copying the features from the generated layers to other enterprise geodatabse layers result in the error below: CAD file: http://www.mediafire.com/download/ii2dszjoo4zoij4/AsSamou_Hebron_MasterPlan_05_X_03.dwg Workbench Extracting the Roads polygon (Roads = Boundary – Landuses) What might be the issue here? Thank you Best Jamal

16812

8 days ago

fmeContributor

asked in Authoring

Generate measures on polylines with no measures attached in either coordinates or attribute table.

I tried generating measures on street segments but the measuregenerator is not calculating it right. It starts every segment from 0 instead of calculating from the end log. Any ideas how to resolve or calculate measures on segments with no measures? Thanks in advance!

574

13 days ago

lifalin2016Contributor

asked in Authoring

Connecting multiple points by shortest lines possible ?

I have a large number of points, which I would like to join by simple lines (point-to-point), minimizing the overall summed length of the generated lines. There's no preferred path, but all points must be connected to each other by a single network of lines.My output just needs to be a set of simple lines.Do anyone have an idea on how to accomplish that, other than grinding it out in a PythonCaller ?CheersLars I

26814

13 days ago

deanhowellEnthusiast

asked in Authoring

Workbench Content Summary

Hello, we have inherited a range of very large workbenches and was wondering if there is a way to get a summary report of the major components like parameters, database connections, inputs, outputs and names of bookmarks.

282

14 days ago

fme_can_do_itSupporter

asked in Authoring

Copy coordinates from a list in a Lat/Long column

I had a pair of coordinates stored in a single column named "geometry." I used the Attribute Splitter to separate these coordinates and then exploded the list. Now, I have each latitude and longitude in the same column. Is there a way to copy these latitude and longitude values into separate columns labeled "Latitude" and "Longitude" while maintaining the same order?

464

14 days ago

ebygommContributor

asked in Authoring

Directory and File Pathnames - Path Filter now case sensitive?

In 2024.1 it appears that a Directory and File Pathnames reader with a Path Filter set to *.tab only reads tab files with a lowercase extension.In 2021.2 both .tab and .TAB files are readA MapInfo TAB file reader pointing at a folder path such as "E:\Mapinfo\**\*.tab" still reads both .TAB and .tab filesIs this expected behaviour?

483

14 days ago

ebygommContributor

asked in Authoring

ArcsGIS Portal Feature Service connection - Proxy issues

Using the Httpcaller i can successfully make a rest api call to retrieve a token for an ArcGIS Portal Featureservice. A proxy server is set up but is not used for this url so the call bypasses the proxy. However, I can only set up and use an ArcGIS Portal Feature Service connection if there is no proxy set up at all. If the proxy is enabled, the connection tries to use the proxy even though the base url is on the exception list.

669

15 days ago

r7Contributor

asked in Authoring

Problem reading and writing from file geodatabases frrom ArcGIS 10.8 in a FME Flow Worspace

I have ArcGIS 10.8 with 64bit Background processing installed and am using the latest version of FME Form (FME(R) 2024.1.3.0 (20240927 - Build 24627 - WIN64))I want to read data from an ESRI File Geodatabase with the Esri Geodatabase reader and writer and am having sporadic compatabilty problems. At the moment I cannot read from the geodatabase but I can write to it. Other times, I can’t write to it either.I have set the translation parameter to ESRI ArcMAP.I have also reinstalled ArcGIS 10.8 and this morning I updated FME Form.I have also realised, that after the problem arises, if I restart FME I can write to the File Geodatabase again.Why am I still having problems?

313

16 days ago

lifalin2016Contributor

asked in Authoring

Bug in FME ? - "SQL to run after write" triggered even after a Terminator is activated

I would assume (dangerous in this case), that a Terminator would halt processing completely.I have a workspace, that imports from a WFS. It errs because the provider made a breaking change by removing a column in the read dataset. This issues a rejected feature, which triggers a Terminator.But even then, the postprocess action of my SQL writer is triggered.Why does this happen ?If a terminator is called, it indicates that the workspace has failed. And then triggering postprocessing is a dangerous action, as this usually requires the writing to have been completed without errors.Is this not a bug ?Using FME 2022.2.6 on FME Server/Flow.Cheers

FME Server: aborted job keeps running on engine

Whenever we cancel a running job (in our case: using the REST API), the job is cancelled successfully on the FME Server core (the job reports itself as aborted when we fetch the status), but the engine on which the job is running (on a different physical machine than the Server core) just keeps on going: the job simply runs until the end of the translation. This is not what I expected, but since I don't see any errors in the server logs e.g. about communication issues with the engine, I started to wonder.Is this intended behaviour? If so, are there ways to actually stop the job process on the engine as well? If not, any suggestions on how to fix this?

7918

19 days ago

Page 1 / 121

Badge winners

charisphhas earned the badge Welcome Back
hsnhas earned the badge Webinar Watcher (Grey)
hsnhas earned the badge Welcome Back
vojtechmyskahas earned the badge Welcome Back
delaneytoursihas earned the badge Student (Grey)

Show all badges

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