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,996 Posts
12,389 Replies

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

2996 Posts

Recently active

Most replies Most views Newest first

vkiContributor

asked in Authoring

Error connecting to Oracle-DB, but only on FME Form (FME Flow ok)

We recently updated to 2024.1 (FME Form and Flow).We have some jobs, that run daily on FME Flow, that read features from an Oracle-db and write to a PostGIS-DB.I downloaded one of the workspaces to FME Form to change something. But in FMEForm I cannot connect to the Oracel-DB anymore. I get this error:Error connecting to Oracle database: message was `OCI_INVALID_HANDLE'. (serverType=`ORACLE_NONSPATIAL', serverName=`xy', userName=`xy', password=`***', dbname=`')I uploaded the workspace again to FME Flow and there it ran successfully.Any ideas, what could be the problem? Thanks in advance.Vera

karnilContributor

asked in Authoring

localize data at any point in the script?

This is supposed to be a quality of life improvement when working with unreliable data providers or when you have unreliable internet connection. I hope this functionallity exists in FME already but I could not find it.I am trying to make a custom node that saves the data stream it intercepts locally and reads that data instead if the original source doesnt come through. There are two problems that I have been unable to solve. One is that i have to run the script with feature cashing to get it to save the files and there is an error upon saving, it does not seem to understande the grouping for some reason:localize_data_2_FeatureWriter (WriterFactory): Group 2 / 2: MULTI_WRITER: No dataset was specified for MULTI_WRITER_DATASET or localize_data_2_FeatureWriter_0_DATASET or FFS_DATASET So as the image suggests the custom transformer saves the data stream here at 3 points. It dynamically creates local files named by the customTransformer instance name and with dynamic schema.The second pr

conchContributor

asked in Authoring

HTTP call syntax to retrieve OSM data

HiI’ve been constructing http calls to download OSM data to a .OSM file, then reading the downloaded .OSM file via a FeatureReader to generate specific outputs (yes, I know there are downloadable OSM transformers but they don’t do what’s required here).The specific problem I’m having is, not returning way or relation items into the downloaded file (if this is possible).Looking for assistance regarding the http call syntax. Below is what I’ve tried but still only returning point features (same results for both).https://overpass-api.de/api/interpreter?data=[bbox];node[building];out;way[building];out;relation[building];out;&bbox=@Value(_xmin),@Value(_ymin),@Value(_xmax),@Value(_ymax)https://overpass-api.de/api/interpreter?data=[bbox];nwr[building];out;&bbox=@Value(_xmin),@Value(_ymin),@Value(_xmax),@Value(_ymax)

timwarfeContributor

asked in Authoring

SharePoint Online Migration

Has someone please done a file transfer migration from one Sharepoint Online location (Site) to another Sharepoint Online location (site) and also keeping the original file Metadata, including created date, etc.. Using FME Form?

lifalin2016Contributor

asked in Authoring

Python executable and site-package folder in various versions (e.g. 2022.2.6) ?

Hi.Is there an authoritative list somewhere of which versions of FME uses which versions of Python ?So far I have: 2020=3.7, 2021=3.8, 2022=3.9+3.10, 2023=3.11, 2024=3.12I’m assuming that the Python executable is located in [FME_ROOT]\fmepython###\python3.exe (or the dll’s). Is this correct ?And where is this executable’s site-packages folder located ?Is it at [FME_ROOT]\python ? Or [FME_ROOT]\python\python312 ? Or somewhere entirely different ?And is this location the same in an FME Engine for Server/Flow ?I’m contemplating adding a special Python package for use in both desktop and server.Cheers.

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

stuart_misoParticipant

asked in Authoring

Use existing Oracle table schema for writing into csv

I have a whopping great big table in my workbench with 2100 attribute fields in it! 😯The data originates from JSON files, and I need to write it into several csv files.The csv files need to pick up the schemas of tables in an Oracle db. These tables have a couple of hundred attribute fields / columns in, so many of my attribute fields will be dropped from the massive table in the workbench when creating the csv. This is good!The Oracle tables do not feature in the workbench at all, so I just need to grab the schema of the existing tables, bring them into the workbench, and use them in the csv writers.I’ve tried to use Schema Scanner, and Schema Mapper but with no luck. I am sure the answer must be really simple and I am doing something wrong.Any help will be much appreciated.Stuart

kanteyemaodoContributor

asked in Authoring

points isolés fme | Isolate Points in FME

j’ai deux couchesUne couche de points (ponctuel) et couche de lignes (linéaires).je veux vérifier les points isolés ou non connectés de ma couche ligne.solution svp.en pièce jointe les supports (points) à vérifier qui ne sont pas connectés aux lignes (tronçon). I have two layersA layer of points (point) and layer of lines (linear).I want to check isolated or unconnected points of my line layer.solution please.attached the supports (points) to check which are not connected to the lines (section).

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

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:

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

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?

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

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.

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

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.

virtualcitymattEvangelist

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

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

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.

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

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 ?

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)

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

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.

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?

1
2
3
4
...
120

Page 1 / 120

Badge winners

akohas earned the badge Welcome Back
ericwhuhas earned the badge English Speaker
ericwhuhas earned the badge Chinese Speaker
ericwhuhas earned the badge Welcome Back
kanjaniheena59has earned the badge FME Form Advanced Training

Show all badges

29,835: 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