Skip to main content

Authoring

Creating and organizing workspaces. How to use Workbench.

  • 3,194 Posts
  • 13,106 Replies
3194 Posts
lifalin2016
Contributor
lifalin2016Contributor
asked in Authoring
Controlling execution order - thwarted

Hi list. I have a master workspace in Workbench, which starts with a Creator calling two SQLExecutors, and eventually calls two WorkspaceRunners. Each SQLExecutor fetches a list of tables in a dataset, adding their feature count (numbers of rows). I specifically tell FME to process the smaller dataset (i.e. its SQLExecutor) first, but each “thread” also have a (blocking) Sorter transformer (sorting by feature count) before calling (its) WorkspaceRunner. It seems that the result from the two blocking Sorter transformers are processed by FME in the wrong order regardless of which order the features have arrived. How can I ensure that the Sorter for the smaller dataset (i.e. VAT above) executes first, before the Sorter for the larger dataset ? As is seen, I tried to rename the Sorters, so the smaller was alphabetically listed before the larger, but it didn’t change anything. The Logger logged the larger dataset first.

334
takashi
Influencer
scarter
Contributor
scarterContributor
asked in Authoring
Error when writing a selected polygon (via TestFilter) to PDF

Hello Forum, I’m experimenting with using FME Form to create a PDF showing the result of a TestFilter query on a read-in feature (polygon dataset). I have this… Creator FeatureReader Reads in the polygon dataset TestFilter Finds a specified record in the source dataset by specifying an attribute and a value. This produces the required selection. PDF Styler PDF Page Formatter FeatureWriter Writes to type=Adobe Geospatial PDF NOT YET ADDED: I will eventually bring in base mapping and add titles etc. But I don’t need to get to that stage yet However, when I run the workspace this error is generated… ‘PDFPageFormatter_2 (PDFLayoutFactory): Invalid page object 'PDFStyled' parameters 'MINX;-117;MINY;803;WIDTH;112;HEIGHT;39;FIXED_ASPECT;Yes;CLIPPING_ENABLED;No'. All point positions must be a positive number’ I’ve looked in the settings of the PDFPageFormatter_2 transformer but I cannot see values such as MINX, MINY, WIDTH, HEIGHT, FIXED_ASPECT or CLIPPING_ENABLED. But the error is saying that

351
debbiatsafe
Safer
vdeyepc
Contributor
vdeyepcContributor
asked in Authoring
How to Connect to Sharepont Using SharepointOnline Connector using Graph API

Hello Safe Folks, I am trying SharepointOnline Connector with a TenantID, Client ID and CLient Secret. I followed https://support.safe.com/hc/en-us/articles/25407443807117-Getting-Started-with-Microsoft-SharePoint#WebConnection https://support.safe.com/hc/en-us/articles/30678084674189-How-to-Create-a-SharePointOnlineConnector-Web-Connection-with-Application-Permissions In the second URL, it suggests to have but I only have Sites.Selected or Sites.ReadAll option from the ADMIN. After adding the required parameters, I do not get an error but when add sites I get an error. I am using options/parameters for Download Search Query: Unable to execute query: 'Read past EOF' Please suggest and help.

130
vdeyepc
Contributor
S
smas1
asked in Authoring
Dynamic Attribute creation

I have a json which i am getting through http caller. This json contains data as well as schema details. The schema details are like this Column Name, ColumnIdentifier and Data is like this [{ColoumnIdentifier : Value}] Now i want to create new attributes based on schema details. I have looked into python caller but i think you cannot create new attributes. is there any transformer by which i can create new attributes using my json as an input?or a python function to create new attributes

36411
australgis
Contributor
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Authoring
NeighborFinder

Hi. I am using neighborFinder to align the points to the closest line segment. Points are connected to the Base, and lines are Candidates. I have also merged candidate Attributes. I am trying to join the Line segment from NeigborFinder with the original line dataset to get the closest line, but I am getting point geometry. is there a way to retrieve the line segment from the neighborFinder output? Thanks!

402
takashi
Influencer
vxn43
Supporter
vxn43Supporter
asked in Authoring
WFS Error

I am using the OGC WFS Reader to try and connect to my site in the TreePlotter App (cloud based app by PlanIT Geo). I have the API Key and other parameters. When I run the Reader, I get these errors (from log file). Does anyone have an idea on what could be causing this? (I followed the instructions from their website: https://support.treeplotter.com/knowledge-base/wfs/) 2025-04-28 16:32:25| 0.8| 0.0|ERROR |<ows:ExceptionReport version="2.0.0=" xmlns:ows=" http://www.opengis.net/ows/1.1= " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance= " xmlns:planit="planit: https://pg-cloud.com/planit= " xmlns:wfs=" http://www.opengis.net/wfs/2.0= " xmlns:gml=" http://www.opengis.net/gml/3.2= " schemaLocation=" http://www.opengis.net/ows/1.1 http://schemas.opengis.net/ows/1.1.0/owsAll.xsd= "> <Exception exceptionCode="CODE WILL GO HERE=" locator="FeatureInPolygon">="> <ExceptionText> https://pg-cloud.com </ExceptionText> </Exception> </ows:ExceptionReport> 2025-04-28 16:32:25| 0.8| 0.0|ERROR

101
birgit
Influencer
simeon.simic
Contributor
simeon.simicContributor
asked in Authoring
from polygon to multipolygon

Hello everyone, I need help with polygons and multipolygons with my geometry, i read shape file if that is important1. Which transformer should i use, or how can i see if my geometry is polygon or multipolyon ?2. How can i change type from polygon to multipolygon, what should i use for that change?

443
takashi
Influencer
achambers_ciri
Participant
achambers_ciriParticipant
asked in Authoring
AGOL Hosted Layer Only Receiving Geometry, no attribution

I have a very basic workbench that includes one section reads from an SDE and writes to a hosted AGOL layer. It is set to truncate existing. The script writes all the polygons as expected but none of the attribution for the polygons comes through. I have confirmed the attributes are correctly named. I have tried removing and re-adding the hosted writer. Weirdly, the script also writes different data to a separate hosted layer and that functions fine. Has anyone else had this happen? Any ideas on solutions?

192
hkingsbury
Celebrity
gregbensnoco
Contributor
gregbensnocoContributor
asked in Authoring
Unable to double select transformer

I can click on the desktop and add a transformer but when I double-click the title bar of the transformer, nothing happens. I can’t click and move a transformer either. I can edit a transformer in the left Navigator. I can’t add connectors between transformers. Reinstalled same version (2023.1.1.1) because that’s the version we use. Still same problem. I can run an existing workspace but the transformers seem to be unselectable. I don't have this problem when FME Workbench is on my laptop screen and not my external monitor. I've built dozens of workspaces on this external monitor without issue. Problem started last week. In Display Settings I extended the laptop display to the external monitor. >>>> It turns out if I change Display Settings to Show only on 2 and back to Extend Displays the FME workspace is fine.

222
gregbensnoco
Contributor
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Authoring
AI for workspace documentation?

Has anyone been using AI to write documentation for a workspace? I’ve found that some models are really good a looking over a codebase and putting together a readme for example. I’ve been experimenting with with workspaces and have also had pretty good results with copilot inside visual studio. would be great to have an AI Assist button inside the Help section in workbench.

565
hkingsbury
Celebrity
dave_oppd
Contributor
dave_oppdContributor
asked in Authoring
Corporate SSL Interception with FME Form/Desktop

My company does SSL inspection/interception which is causing errors when trying to view background maps in FME Form. I have seen ways to fix this for the FME Flow (Server) side, but is there any way to change any configurations for FME Form to handle this? The CA certificate for our authority is in the Trusted Root Certification Authorities certificate store on machines so I’m not sure why it isn’t trusted if FME is using the machine’s certificate store for trust. Below is an example of error seeing from FME Flow 2025.0.1 (but have seen on previous versions as well). Stadia Maps Reader: Failed to load 'https://tiles.stadiamaps.com/tiles/alidade_smooth/5/19/14.png'. Error: 'HTTPSConnectionPool(host='tiles.stadiamaps.com', port=443): Max retries exceeded with url: /tiles/alidade_smooth/5/19/14.png (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Missing Authority Key Identifier (_ssl.c:1018)')))'Python Exception <FMEException>:

320
dave_oppd
Contributor
vxn43
Supporter
vxn43Supporter
asked in Authoring
Update Data in AGOL using zipped File GDB

I have a zipped File GDB that I have uploaded to AGOL using the ArcGISOnlineConnector. The next step is for me to update the data. See 2nd screencapture in red circle, “Update Data”. Is it possible to update data in AGOL using FME? if yes, what transformer do I need to use?

141
nielsgerrits
VIP
sveouu
Contributor
sveouuContributor
asked in Authoring
FME Form User Parameter conditional visibility

Hi, I am using FME(R) 2025.0.0.0 (20250228 - Build 25208 - WIN64).I was glad to see that with FME 2025 there is now the option to apply Compound Conditions to the User Parameter display.However, I believe there may be a bug in the Compound Condition Dialog settings for the User Parameters.Any type of compound condition triggers an “Invalid Parameter” response.Applying a Single Condition works fine. Thanks,Svea

443
sveouu
Contributor
vxn43
Supporter
vxn43Supporter
asked in Authoring
How to update Date Modified in SharePoint Online?

I have a SharePoint Teams Channel that has Documents; a single zip file is the only document that I update. I am using FME Form 2021. I created a workspace using the Path Reader and SharePointOnlineConnector. It uploads a file to SharePointOnline and overwrites the file already there. I run the workspace with no errors. When I go into SharePoint Online, I check the file and the Date Modified does not change. The Date Modified should say “a few seconds ago” or have a timestamp. This is not a SharePoint List. Is there a way to modify the timestamp in SharePoint Online so that I know the file uploaded using FME was updated (overwritten) in SharePoint Online?

203
crutledge
Enthusiast
vxn43
Supporter
vxn43Supporter
asked in Authoring
Zip a File GDB but exclude a named Feature Class

I am using FME Form 2021. I have completely re-written this post. What is the best approach to zip all Feature Classes in a File GDB without having each Feature Class show up individually in the workspace? I have 25+ Feature Classes and do not want them all to show up separately. Just want to zip up my File GDB. Sorry about the incorrect subject header.

382
takashi
Influencer
helmoetz
Supporter
helmoetzSupporter
asked in Authoring
Generic reading GML on a web yields http 404

Hello, I am trying to read data of different formats, controlled by a resource list. I isolate web services with a separate WFS FeatureReader, I do not have database resources and for the other resources I use a Generic FeatureReader, with the REAL_FORMAT parameter set to: <Guess format name from extension> Some resources include gml files on a web location (URL). The Generic FeatureReader usually reads them correctly, with one exception that gives an http 404 error (Not Found). I can avoid the error by choosing OGC GML (Geography Markup Language) for the REAL_FORMAT parameter. But I cannot control this from my resource list, only with a published parameter. I have tried adding an OGC GML resource reader, but this does not help. The Guess format parameter apparently does not make the right choice. Does anyone have an idea how to solve this, without adding a tester with a separate FeatureReader or using a WorkspaceRunner? I'm using FME Form 2022.2.4 (Win) Below an extract of the workspa

544
kailinatsafe
Safer
stlj
Contributor
stljContributor
asked in Authoring
Best way to update prefetch cache in stram processing

HiI work with stream processing and need to validate data in real time against a database using for example a database joiner. We have an MQ connector recieving large volumes of real time data. For best performance, I need to cache the dataset I am validating against, but the question is, what is the best way to update the cache? The data is updated in the database once per hour and there is 1.000.000 records in the table. A timewindow change can trigger cache update in Fme, but I can´t find out how to solve it, and what readers/transformers to use./Stefan *Edit, caption should be Stream processing….Cant edit.

423
mattmatsafe
Safer
danraleigh
Contributor
danraleighContributor
asked in Authoring
Provide a Drop-down List of Fields in a Feature Class, Shapefile, or Feature Service

I am seeking to mimic a script tool in ArcGIS Pro that I’ve constructed. The script tool provides a user with a list of fields within a shapefile, feature class, or feature service once the user has supplied the file path. Once the field has been chosen, the user can then select a feature from a list of features in the dataset with information from the field selected in the previous step. This allows the user to indicate a feature to run from a dataset rather than running the entire batch of features. I am struggling to find a way to prompt FME to assess an input file to provide that sort of list (in ArcGIS Pro this is done with the Validation page of the script tool). I’ve tinkered with incorporating User Parameters, but I feel like I’m missing something. If this sort of process is possible, I’d welcome some feedback and suggestions!

181
crutledge
Enthusiast
enrico.artini
Participant
enrico.artiniParticipant
asked in Authoring
Copying files to two different destination folders

Hello I would like to copy files contained in an input folder to two different destination folders using filecopy writer, but I can't set two different destination paths.Do you have any suggestions?Thanks a lot in advance Enrico

444
enrico.artini
Participant
fme_junior
Contributor
fme_juniorContributor
asked in Authoring
Spatial filter with overlapping polygons

I merged a population raster with polygons (buffer) to find out how many inhabitants live in each polygone (buffer). I used the spatial filter for this operation and the results are mostly satisfying. There is one case when the results seem to be wrong : that is when I have overlapping polygons. In that case, each population raster in only use for one polygon. Which setting should I change to make sure that the entire population raster is checked for each polygon (buffer) in order to have the correct value for population?

231
takashi
Influencer
scarter
Contributor
scarterContributor
asked in Authoring
Reading files from Sharepoint into FME Flow

Hello Forum,. I would like to connect to files stored in SharePoint. This is a redacted example of one of the URLs…. I’ve seen the ‘SharePointOnlineConnector’ transformer from https://support.safe.com/hc/en-us/articles/25407532347661-Reading-and-Writing-SharePoint-Libraries-with-FME. However that only works on build FME Build 24577 or higher. We’re on build 23619 - note that we are planning to upgrade in Summer 2025, but that’s a while off. Is there a way of reading from SharePoint without the SharePointOnlineConnector transformer? I see I can select Microsoft SharePoint List as a reader format in FeatureReader. However when I enter the URL (the un-redacted one in the image above) I’m then asked what features to read. When I then select the ellipsis I get this error Am I misunderstanding how the reader works? Do I need to present the reader with a different set of information per file in SharePoint? Is there another way of doing this? Thanks, Stuart

232
scarter
Contributor
scarter
Contributor
scarterContributor
asked in Authoring
Extracting geometry values from json to create geojson files in FME Form

Hello Forum, I’ve been provided with a set of json files (note, not geojson, but json). Within each json file I know there are geometry coordinates pairs. See this screenshot of the json in Notepad++… How can utilise FME to open each json file and pull out the geojson elements to create a geojson showing the polygons? I’ve attached an example project json file. Note that I’ve changed the extension from .json to .txt to get through the Forum blocker not allowing json files. Thanks,

11321
takashi
Influencer
aashnaparikh
Contributor
aashnaparikhContributor
asked in Authoring
Excel File Reader - Dynamic sheet selection

Description I have a excel template file which I have in the excel reader dataset as a reader file. This file only has the name of the attributes and no features. I am trying to implement this job for the end user where every month they can upload the excel file with the same template structure, however different features month on month basis. I want to set up my parameters in a way that based off the template populated, it reads the file every month when uploaded by the end user and also give an ability to the end user to mention the sheet name in the prompt.

573
takashi
Influencer
bhk
Contributor
bhkContributor
asked in Authoring
How To Switch Workflow Base on the Attribute Valye

Can you please let me know how I can switch and select the workflow based on the value of Attribute? For example I need to select and continue between continuing PythonCaller or PythonCaller_2 based on the value of operation IF ‘operation’ == ‘ADD’ THEN Continue with PythonCaller IF ‘operation’ == ‘REMOVE’ THEN Continue with PythonCaller_2

302
redgeographics
Celebrity
hlouie
Contributor
hlouieContributor
asked in Authoring
Read MRSID without Alpha Band (Color Infrared)

In the past I've received 2 file MRSID files, 1 RGB and 1 Color Infrared, this time got a 1 MRSID file with all 4 Bands. I can RasterSelector then RasterBandRemover and get the RGB, this takes a little longer as I need to pass it thru transformer. Question Can I read a MRSID and only select the RGB Bands and not read the Color Infrared (Apha) as if I don't need it why read it (would this speed up the Workspace processing)?

644
kailinatsafe
Safer

Helpful Members This Week

Badge Winners

Show all badges

Popular Tags

Community Stats

31,140
Posts
118,065
Replies
38,760
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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