Skip to main content
  • EN

Authoring

Creating and organizing workspaces. How to use Workbench.

  • 3,284 Posts
  • 13,475 Replies
3284 Posts
jbresler
Contributor
jbreslerContributor
asked in Authoring
Turn on logging of SQL statements in 2014 workbench

Is there a way to turn on logging of the SQL statements that FME is issuing to Oracle in Workbench 2014?

284
jbresler
Contributor
nfri
Contributor
nfriContributor
asked in Authoring
Intersect with lenght along line (station values)

Is there a way in FME to run a workflow similar to esri Intersect tool where a 1 line feature (1 route) could intersect a second line feature (roads) with multiple lines and get a point feature for each crossing point with the distance along the first line feature. Basically crossing point and stationing along a line?  

442
nfri
Contributor
parke372
Contributor
parke372Contributor
asked in Authoring
XLS->XLS - copy validation formulas?

I am looking to have a workspace run by a workspace runner to parse out some data to be grouped by individual tabs based on an attribute name.i have an excel workbook with a dozen or so sheets, each sheet is a type of mechanical system with 3 columns - Column A is BLD which is a string building name. Column B is System Type which had data validation in place with named table references and Column C is System Name which is a string value.i am using a feature reader with the read formulas checked:i want to have the workspace runner pass a value for BLD and search all of the sheets for matches - for instance, it looks something like this once run:  The workspace is finished, except for the writer - i want to create a new workbook for each unique BLD feature and copy from an excel template that has the existing named ranges for the various data validation lists from the original read file - however, i can’t get the validation to copy, nor the sheet with the named ranges.my writer is set up

310
parke372
Contributor
dataman
Contributor
datamanContributor
asked in Authoring
Use Case - calculate shortest route to several schools

Hello everybody! some weeks ago I asked for help with our project: calculate the distance to all schools in the city having as input one address. (Server App - calculate shortest route to several schools | Community (safe.com)) I have done it using FME Desktop (2022.2) and the result looks pretty nice:In addition I get the shortest paths to each school (each school has more than one entry).Now I have uploaded the GDB with the streets and the Shapefile with the school entries to the FME Server Ressources.I have created a server app (workspace) and run the project.There I receive this error:2024-9-30 09:01:48 | Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more detailsWhy it works loc

574
bwn
Evangelist
S
sui_huang
asked in Authoring
How to count FeatureWriter transformer's output into "Feature Written Summary" of the log?

Hi! I have a FME workspace using FeatureWriter to write record to some tables. When running it from desktop, it populates the tables as expected. However, if I look at the log after job is completed, the "Features Written Summary" section at the end seem to be misleading by show "0", while I know that there are actually features written.Do I need to do any change in my FME workspace to add the count to the summary? Thank you!Below is the summary part of the log:Below is the part of log for FeatureWriter, which does give the count:

14611
kailinatsafe
Safer
p15rajan
Contributor
p15rajanContributor
asked in Authoring
Raster Image -- Radiometric Calibration and Atmospheric Correction

Dear All, Could you please let me know is there any transformer to do Radiometric calibration and Atmospheric correction in FME?  Kindly let me know the details. Thanks, Siva 

712
p15rajan
Contributor
salvaleonrp
Enthusiast
salvaleonrpEnthusiast
asked in Authoring
Creating an attribute that accumulates count of duplicate values (sequentially)

I was able to do a cumulative count of duplicate values (where duplicate is “-1” only) using a Group By on a Counter transformer shown below. (Added note: I should have added this to remove ambiguity - SORRY. The output as shown below in the Preview is the desired output. I only care to know the number of consecutive sequential values when the value is “-1”. If the pattern changes and another series of duplicate “-1” appears, the count starts with “1” again. I don’t care if the pattern for duplicate values are greater than “0”, like “2420” on the Preview.)  Since I have more than a dozen of these attributes, I’d like to use an AttributeCreator instead but I can’t seem to use the CurrentAttribute() to accumulate duplicate values.In addition, everytime a sequence of “-1”s begin (as shown in row 143 above), count starts at 1 again.Any suggestions?

17310
salvaleonrp
Enthusiast
scarter
Contributor
scarterContributor
asked in Authoring
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

11710
scarter
Contributor
jp12212
Contributor
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.

431
donalmateer
Safer
amelchiorre
Contributor
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

1203
DanAtSafe
Safer
vassok
Contributor
vassokContributor
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.   

191
bwn
Evangelist
virtualcitymatt
Celebrity
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

564
virtualcitymatt
Celebrity
a-a-ron
Participant
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

853
a-a-ron
Participant
nic_ran
Contributor
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.

908
ebygomm
Influencer
scarter
Contributor
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

956
scarter
Contributor
georgiec
Contributor
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 ? 

1365
georgiec
Contributor
arash_hokm
Contributor
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) 

621
bwn
Evangelist
basm
Contributor
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  

364
basm
Contributor
ronaldhummelink
Contributor
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.

1111
emma.at.safe
Safer
lazarlubomir
Contributor
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?

14410
emma.at.safe
Safer
scarter
Contributor
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

2133
scarter
Contributor
tnarladni
Enthusiast
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

2153
redgeographics
Celebrity
georgiec
Contributor
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

432
georgiec
Contributor
T
tgroeneveld
asked in Authoring
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?

1787
emma.at.safe
Safer
markcoopersdc
Contributor
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 

281
redgeographics
Celebrity

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,397
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.