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

scarterContributor

Finding and replacing a null value with a blank. Possibly with StringReplacer

Hello Forum, I have an attribute in a gpkg dataset containing year values (e.g.: 2016). Where a year is unknown the value is <null>. When this dataset is translated into tab or geojson any values of <null> get shown as -9999. I assume that's how the MapInfo tab translator sees <null> values. But instead of -9999 this I want any <null> value to be blank. With StringReplacer I know I can replace a value such as 2016 with 3016, not that I would want to do that!. But when I type in <null> as the 'Text to replace' and leave 'Replacement text' blank, the output still shows -9999 instead of it being blank. I wonder if there is a special way of specifying <null>. How do I effectively replace <null> value in an integer attribute with blank? I've seen https://community.safe.com/transformers-9/replace-value-with-a-null-1778 but that doesn’t quite cover it. Thanks,Stuart

6310

3 months ago

jp12212Contributor

asked in Authoring

How to print a raster view of a dwg surface isometrically as a png

Can you provide guidance on how to convert a DWG file to a PNG image and then embed that PNG into an HTML PDF using FME? Specifically, I'm interested in preserving the visual elements like colors, hatch styles, and line widths from the original DWG file.Here are my transformers.Thank you.

261

3 months ago

amelchiorreContributor

asked in Authoring

GeometryExtractor does not keep polygons orientation in geoJSON

Hey I think I found a bug in the GeometryExtractor, where the geoJSON writer and the GeometryExtractor that writes geoJSON geometry to an attribute lead to different results. I have a sample workbench where I buffer a point, the GeometryExtractor writes the coordinate following the wrong orientation (clockwise vertex order) but the geoJSON writer generates the correct geoJSON (counter-clockwise vertex order).is there any way to fix it? I need to write the geoJSON geometry string into an attribute. Thank you,Andrea

733

3 months ago

vassokObserver

asked in Authoring

How to rename FID from Geopackage to MI_PRINX using Dynamic workspace?

Hi, I am trying to rename the default fid from geopackage to MI_PRINX in my workspace, but it keeps writing as fid.

141

3 months ago

virtualcitymattCelebrity

posted in Authoring

Just sharing - parallel lmits fmeworker (FME Form)

So I have a big job to process and I’m trying to work out some theoretical numbers for the client (a rough estimate on the processing time range depending on various factors). I want to leverage the fmeworker limit of 16 parallel threads (I’m assuming a machine with essentially unlimited resources) because the fme.exe limit is 8.I have a batch job of many tiles with many rasters and features which all need to be processed at once. The easy thing to do is to just throw it to the workspace runner but the license only gives me 7-8 parallel threads (which is probably more than enough to be fair, most likely CPU will not be the bottle neck).Anyways for fun I did a test to see what the limit was on the number of parallel groups to send through a custom transformer when parallel processing was on. I pretty quickly got the following error: An error has occurred. Check the logfile above for detailsf_6 (TransformFact): Transformer 'ThreadLimitTester': Unable to create worker; try reducing the pa

384

3 months ago

a-a-ronParticipant

asked in Authoring

Did safe remove ESRI File Geodatabase reader / writer?

Just started my new job and the work environments are very similar (ArcInfo / Advanced License; new office FME Professional edition - old office FME oracle edition) and all I can see is the Open FileGDB reader writer. Wondering if safe discontinued the ESRI File GDB reader and writers?ArcPro 3.3.2 - advancedArcMap 10.8.2 - infoFME 2023.1 - Professional

633

3 months ago

nic_ranContributor

asked in Authoring

FME Server REST API : get automation tasks/items

Is it possible to retrieve automation tasks/items using the FME Server REST API? Specifically, I’m trying to find all workspaces that are run by automations and I’d also need to determine the published parameters passed to each workspace.The Schedules and Notifications (Subscriptions) REST API methods allow all “items” to be retrieved, which provides access to the workspace details but this does not seem to be exposed in the REST API for Automations…I’m using FME Server 2019.2.2 Build 19817 - win64.

608

3 months ago

scarterContributor

asked in Authoring

Fanout failing to write fanned out files

Hello Forum, I’m attempting a fanout on a geojson file based on specifying an attribute. This is a simple task which I’ve carried out dozens of times before with success on other datasets. However, for some unknown reason it’s failing to fanout on a particular dataset. I’ve read in the geojson with FeatureReader. This is connected to a to a FeatureWriter. In the FeatureWriter I have… Selected format: Geojson (Geographic JavaScript Object Notation)Browsed to a destination UNC path and ensured the .geojson extension is shown. Note that the geojson writer it defaults to .json extension, so you have to change it to .geojson manually.In Parameters changed ‘Reproject to WGS84’ to NoIn General>Feature Type Name selected ‘open text editor ‘ and then selected Primary_Function from the FME Feature Attributes list. Note that Primary_Function is the attribute I wish to fanout on. The attribute exists in the source dataset and does contain values. However, this then fails to write fanned out geo

646

3 months ago

georgiecContributor

asked in Authoring

Reference a Global variable within a Tester Transformer

I am trying to compare the total of features from my original data source to the number of features ultimately written to a dataset. I thought I’d create a variable from Statistics Calculator result to refer to in my Tester. Is there a way to reference the global variable I have set within the Tester phrase ?If not, is there an efficient way of comparing the stats between the beginning and the end ?

585

3 months ago

arash_hokmContributor

asked in Authoring

create polygons from polyline

Hello FME community,I'm trying to create polygons from Polylines. With Aerabuilder I could create 95 percent of Polgons. As you can see in the picture, in some cases no polygons were created.Polygon creation failed (yellow frames)

381

3 months ago

basmContributor

asked in Authoring

Custom loop transformer for oData web service loop doesn't work

HiI’m using oData web service url to do http request and extract data.The request fetches every 5000 requests, I want to loop until ‘oData.nextlink’ attribute in the data is nil\empty.Its frustratingly taking so long to resolve this issue !FME doesn’t allow feature holder\sampler in loop, and there is no proper help\round about method.And can’t see \ debug from custom transformer fmx file .. so, how to resolve ?Attached are my ETLs, (main ETL & custom) (2023.0 version) for reference, can anyone please help identify issue and advise for fix Please ?Thanks

344

3 months ago

ronaldhummelinkContributor

asked in Authoring

(plans for) CUDA usage by FME Form?

Hi, I'm currently in the process of making available a new Windows VM for FME Form users within our organisation. Our IT guys anticipated also using this machine for ArcGIS powerusers; but that's not preferred by the application manager team.As such it has some lovely CUDA GPU capacity assigned. Which is a bit of a waste if we don't use it. Can FME use CUDA for certain work? Are there plans for using CUDA?If there is no clear case for retaining the GPU, i intend to give it back to the resource pool. There is no guarentee I can ask it back: it is a finite resource, first come first serve.

641

3 months ago

lazarlubomirContributor

asked in Authoring

Broken workspace?

Hello,please help me! During translation I can read error message "ERROR |MULTI_WRITER: No MULTI_WRITER_TYPE{*} or MULTI_WRITER_TYPE{NULL} was specified" -> whats wrong please?

12310

3 months ago

scarterContributor

asked in Authoring

Finding matching records between two datasets based on a specifed attribute

Hello Forum, I need to find the records from one dataset where the value in one of its attributes is the same as the value of an attribute in another dataset. For example, If I have two datasets (A and B) I want the output to show which records in A have shared value in B, based on a specified attribute. I want the output to be a selection of A. Something like this… I’ve tried Matcher, but that didn’t work for me. Thanks,Stuart

473

3 months ago

tnarladniEnthusiast

asked in Authoring

Where is the "recover" file if Form crashed before it's named and saved?

I remember back in 2021 when this happened, someone from Safe was able to point me to where the “recover” file was saved. Please help me again as i have created a very robust workspace but have not saved it and it would take me 3 hrs to recreate this workspace

653

3 months ago

georgiecContributor

asked in Authoring

ArcGIS Online Writer - Restoring a feature service when error encountered

I’m a newby to FME.I’m about to write workspaces to refresh a list of AGOL feature services. So far I’ve written a simple one that works on a small service.I’ve got a few questions.When I search for potential pitfalls in this forum, they are 5+ years ago and relate to AGOL time outs and also issues updating large datasets. . I’m on the latest release of Form & will use Flow (Hosted). Are these issues still relevant these days ?My largest dataset is our Cadastre being about 140K features. Am I safe to use the Writer ? I am doing truncate & inserts. One might argue that I could use ChangeDetector beforehand, however, I reckon the processing required to compare 140K features would be greater than a simple truncate & insert. (am I right?) If an error is encountered, I would like to quickly restore the destination feature service back to what it was. Any tips on the best approach to doing that ? My idea is to copy the destination service elsewhere in AGOL before commencin

Reader aborts reading complete data set, but workbench continues to run. Can I have the workbench fail when this occurs?

I have an FME workbench that runs every 10 minutes that reads from an ESRI Feature class in a SQL database. Once in a blue moon I get the following warnings.Unable to retrieve feature from table/feature class 'xxx'. This feature, and any other feature from 'xxx' that cannot be read, will be skipped. The error number from ArcObjects is: '-2147154945'Unable to retrieve feature from table/feature class 'xxx'. Aborting reading from table 'xxx'. The error number from ArcObjects is: '-2147216010' Yet the next run 10 minutes later has no problems. When this occurs I want the workbench to stop rather than proceeding with the incomplete data set. Is there a way to force a termination when this happens?

1187

3 months ago

milo89Enthusiast

asked in Authoring

Is it possible to return FME 24 to a Classic View?

I’ve been dabbling in the latest release of FME Form 2024 for a little while now and I’m just not getting the benefits of the new look, specifically the removal of colour from most icons.I could go into personal reasons why colour helps myself with attention to detail, concentration and focus but I’m just wondering if it’s possible to get a classic look while utilising any new functionality.

2377

3 months ago

markcoopersdcContributor

asked in Authoring

Naming of zipped shapefile using user parameter

HiWe need to allow users create a zipped shapefile with a single feature. The shapefile needs to be named as the reference for that feature (an attribute in the table)I can create a zipfile by clicking the zip icon in the dataset field of the writer. However, this just creates a zipfile which is named after the folder it is saved in.Is there a way to name the zipfile using an attribute? Or is there a way to automatically rename the zipfile? Thanks

241

3 months ago

melvinngenoContributor

asked in Authoring

Transformers

I have a shapefile with sub areas and I want to create an FME workbench to assign the areas to 3 operators with the condition that the operators don't work on areas close to each other. which FME transformers can I use as I want the output to be 2 shapefiles one with a list of areas that can be assigned to the operators at a particular time and another one with a list of areas that cant be assigned at that time.

231

3 months ago

geoffgillParticipant

asked in Authoring

Importing data into Choice - User Parameters from Excel

Hiyas,I’m having an issue where I try to import data from a excel spreadsheet into a Choice user parameter.I only ever get the first row to import, even though it displays all data.Choice → Choice Configuration → Dropdown → Import from datasetDataset = My excel fileFormat = Microsoft excelParameters shows the valuesNextImport Mode - Import from: Attribute namesNext Import then results in only the heading being imported; Am I missing something really obvious? Thanks,

hiyhelgContributor

Dear FME community.I hoop you will help me with the question I have. It seems simple question, but I could not solve it. I want to find out overlapping pipelines in the same dataset with different owners. I want to have list of the piplines who overlap with each other and who have different owners.I used line on overlay transformer but I could not get what the result I wanted. Any help is apricated and thank you in advance

975

3 months ago

hkingsburyCelebrity

asked in Authoring

Process timeout at the workspace level

At the FME Flow (we’re looking at 2022.2 specifically) level, many people will be familiar with the ability to set time outs for queuing and running Through the API you can also specify these by using the Job Directives: https://docs.safe.com/fme/html/FME-Flow/ReferenceManual/Job_Directives.htmThe scenario that we’re facing is there is an external process (not FME) that is setup to call a bunch of different workspaces depending on what is passed through. This is a process not managed/administrated by us. Depending on the workspace called, we want to specify the running expiry at the workbench level, of course this could be doing with logic in the external process using tm_ttl/tm_ttc, but that would mean needing to release updated code each time we want to change this.We’ve tried specifying tm_ttc as a workspace parameter (both published and private) but FME Flow doesn’t acknowledge it. Talking with @todd_davis we’re both sure you used to be able to do this (specific run time limits at

1036

3 months ago

jack.fifootContributor

asked in Authoring

KML nested donut not rendering correctly in Google Earth

Hi all,Using FME(R) 2023.2.1.0 (20240104 - Build 23774 - WIN64) and tested in 2024 also.When I write a KML that includes multipolygons (aka nested donuts, aka inner rings) the records display correctly in FME Inspector (correct outline and fill) but when opened in Google Earth the fill is missing for records that have polygons within polygons (ie a donut hole has polygons within it). Simple polygons and simple donuts have correct fill.I’ve tried reversing the orientation with Orientor.Also tried playing around with the DonutHoleExtractor without luck.Any good ideas for a fix?

522

3 months ago

sam_appletonContributor

asked in Authoring

JSON Templater - All rows in one output

Hi All,I have a json templater which i’m using to create a json that has ‘firstname’ and ‘lastname’ - there’s 3 rows of data.I created the following in the root template but it outputs the 3 separately:{ "firstName" : fme:get-attribute("first_name"), "lastName" : fme:get-attribute("last_name")} I then tried creating a sub template -with the following settings: Here is the output I get:{ "firstName" : "first2", "lastName" : "Last1" }{ "firstName" : "first2", "lastName" : "Last2" }{ "firstName" : "first3", "lastName" : "Last3" } I can see that it’s missing an extra set of curly brackets, and when trying to run this result through a JSON validator it fails and gives this message: “Unexpected non-whitespace characters were found after the JSON text” I’ve looked at the JSON templater documentation and the exercise but I can’t seem to get this working.Any help would be greatly appreciated Many thanks, Sam

301

3 months ago

Page 4 / 122

Badge winners

fredjudsonhas earned the badge Welcome Back
ryanwillshearhas earned the badge FME Form Advanced Training
jurgenhas earned the badge FME Certified Professional
sagarsingla85has earned the badge FME Certified Professional
nickruiterhas earned the badge Welcome Back

Show all badges

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