Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

2,959 Posts
12,271 Replies

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

2959 Posts

Recently active

Most replies Most views Newest first

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?

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

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

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

georgiecParticipant

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

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?

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.

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

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

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.

alc33Contributor

asked in Authoring

FME name machine parameter

hi !FME name machine parameter does it exist? I see the name of my computer at the beginning of the log but I don’t find where is this parameter.Thanks !

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?

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

asked in Authoring

So this is going to be a dumb (yes, really their are dumb questions) but I can't for the life of me find a way to simply "print" or export my workspace to PDF for documentation purposes. Sure, there are screenshots but a screenshot of a massive workbench is illegible. When I go to "print" it will let me choose a paper size... but all I want is the ability to a) choose a custom size or b) "print" or export the entire workbench at (say 300 dpi) or something of that nature. Currently the "best" I can do when using Adobe to "print to PDF" is 47 ANSI E sized pages on export! Seriously, there has to be a better way???? Any ideas or suggestions? Note, I've tried programs like "snagit" to do a rolling screencapture but that doesn't work either. Matt

salvaleonrpEnthusiast

asked in Authoring

XMLFragmenter parses only the PAGE_TITLE tag even if i configure my query to be any valid XML like star query

I have an “Extras” attribute that is XML-like with different number of attributes in different order within the attribute value.. When I use the , XMLXQueryExtractor* and configure a query, it only returns rows that has one tag only called <PAGE_TITLE>, like below. The query returns this query result in the list attribute. THe resr of the rows are rejected as invalid XML Queries.For the other failed queries, they have multiple tags, as shown below.What I’d like to do is aplit the tags into field::values regardless of number. This attribute value:<PAGE_LINKS>https://p3tips.com/community/</PAGE_LINKS><PAGE_PRECISEPUBTIMESTAMP>20240905151800</PAGE_PRECISEPUBTIMESTAMP><PAGE_TITLE>Lynchburg Police searching for suspect after armed robbery at Family Dollar</PAGE_TITLE> Woud look like below with all the attributes in the Extras value split into however many tagged attributes.PAGE_LINKS PAGE_PRECISEPUBTIMESTAMP PAGE_TITLE https://p3tips.com/com

bruceharoldContributor

asked in Authoring

Should XMLFragmenter remove geometry?

Hi, I’m finding XMLFragmenter removes geometry, is this expected?Data Interoperability in Pro 3.3, so FME 2024.0.1.0 build 24202.Thanks.

dxirguContributor

asked in Authoring

Export GML with Date attribut using Dynamic Reader and Writer

Hi everyone,I have a workflow that exports data from Oracle to another formats, like Shp, GML... using dynamic readers and writers. This workflow recive some parameters, like table name, that is used to read de Oracle table and to write the file name. The question is about GML file and date values. When the Oracle table has datetime attribute, FME exports as text, by default. I've achived that FME exports GML with attribute as date type, but this attribute has null value, beacause the format of date is wrong. That is, the exported date value is "19630904000000" but it shoud be "1963-09-04".As I said, I use dynamic readers and writers, beacuse I don't know what table will be exported and I can’t see the table structure, neither, when data goes out by Generic port of Reader. So I can't use StringReplacer and DateTimeConverter, because I would need to know the name of attibute. Anyone has any idea how to modify the format of the date?

arthyContributor

asked in Authoring

How to dynamically read excel sheets?

Hi,I have the values of an attribute which corresponds to the names of sheets of an excel file. In other words, the attribute of interest has the values attrib1, attrib2, ..., attribn that also corresponds to the sheet tab names of another excel file.What I would like to do is to be able to dynamically read the sheet tab names of the excel file based on the values attrib1, attrib2, ... attribn that varies per feature. Those values are unique per feature so I won't need to read the same excel sheet twice.Any ideas?Thanks

sam_appletonContributor

asked in Authoring

Deployment parameter - Local value doesn't work

Hi,I have a deployment parameter (Text) that is pointing to an SDE file on FME flow in my shared resources. When I try to set a local value in form, it ignores this value and throws an error saying it can’t access the share resources file path. I’ve tried creating a deployment parameter that is type: database connection, but this doesn’t work either. Here’s the error:This was working a week ago and now it refuses to acknowledge the local value. Many thanks, Sam

schulte.aContributor

asked in Authoring

Help with getting my timestamp data merged correctly so ArcPro time slider will play nice with it

Hello, any help would be greatly appreciated with this idea I have: I am trying to figure out the least convoluted way to take my current data and get it into the format ArcPro likes it to be in to take full advantage of the Time Slider. My ultimate goal is to use the time slider in arcpro and the user can slide the time to show how a floor was occupied throughout time.So, I have a large amount of motion detectors. The data is fed to me like so:SensorName Timestamp SensorStatus 1 12:00 1/1/2024 On 2 12:05 1/1/2024 On 1 12:06 1/1/2024 Off 2 12:10 1/1/2024 Off Then Sensor 1 could be triggered again and so forth Arc seems to want the start and end times in the same row. like so:SensorName Start End 1 12:00 1/1/2024 12:06 1/1/2024 2 12:05 1/1/2024 12:10 1/1/2024 It needs to organize 100s of results from numerous sensors and get the start/stop times on the same row, for the correct sensor, for the correct period of time.

lifalin2016Contributor

asked in Authoring

Template "Microsoft SharePoint Online (safe.microsoft-sharepoint)" not available in 2022.2 ?

Y’all.I’m trying to create a connection to a customer Sharepoint for the first time. And I’m confused.I got something to work in 2020.2, but would rather it ran in 2022.2 (same as our servers). But I’ve also tried it in 2024.1There seems to be two web service templates, (Template) and (safe.microsoft-sharepoint).According to this article they are each designated for use with Sharepoint List r/w and SharepointOnlineConnector respectively.But apparently I can’t create a new web service based on the latter in 2022.2, and the latter isn’t even available in 2020.2So when did this change, i.e. in which FME version ?CheersLars I.

cavarlyContributor

asked in Authoring

SchemaScanner and dynamic FeatureWriter method

I am attempting to write out data using a schema scanner and dynamic featurewriter.It is simply not working. I always get "Unknown feature type 'BOUNDS' passed to the JSON writer.It doesn't matter what I do, always the same.BOUNDS is my fme_feature_type and fme_feature_type_name.I will eventually use group by attribute but it doesn't even work with just one typeI believe I am following the standard practice but I have always been stumped when trying to write dynamically. Please could someone outline the boiler plate method (with the steps ordered) to use a SchemaScanner and Dynamic FeatureWriter in the scenario where one would need to create or overwrite fme_feature_type and fme_feature_type_name or use a custom names for these. As I understand it, I should only need to make sure I have an attribute on the data with the same name as the Schema Definition Name.THANKS! NOTE below, feature_type_name is not available to choose, in this iteration

susmarContributor

asked in Authoring

Snowflake - SHOW GRANTS TO ROLE syntax

I want to display a list of tables/views that a specific ROLE has access to. I can do this in SQL with the command SHOW GRANTS TO ROLE TESTROLE. However, putting this SHOW command directly into a Snowflake Reader WHERE Clause generates an error (syntax error line 1 at position 270 unexpected 'GRANTS'.) and returns nothing in a SQL Executor transformer. Is anyone please able to advise either what the correct syntax is or if there is another approach/transformer that should be used? Thanks.

jhawksContributor

asked in Authoring

Path issues while attempting to load Python module

Path issues while attempting load Python module. FME Pip installed Pypdf. It got installed to: C:\Users\james.hawks\Documents\FME\Plugins\Python\python39\pypdf But workbench cant see that for unknown reasons. Python Exception <ModuleNotFoundError>: No module named 'PyPDF'

narinderContributor

asked in Authoring

Update Fanout expression name with date

Hi,I have a FME workbench and in the Fanout Expression, i have to manually amend the date (YYYY-MM) in the file name each month from 2024-06 to 2024-07 when running at the start of the month for the previous months data.E.g. the fanout expression will look like this:R@Value(ba_id)-2024-06-filename.xlsx So at the 01st August I would amend the above filename date to 2024-07. Is there a way to automate or code the date so I don’t have to manually change from 2024-06 to 2024-07 etc.

1
2
3
4
...
119

Page 1 / 119

Badge winners

jlmiserez_inserhas earned the badge Welcome Back
softwin309has earned the badge English Speaker
mmeyershas earned the badge Welcome Back
ibeezumahas earned the badge Integrate Spatial Data
matt.fosseyhas earned the badge Welcome Back

Show all badges

29,675: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK