- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,047 Posts
12,628 Replies

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

3047 Posts

no output from feature writer

Hi, A simple case; insert some excel data into an oracle table and afterwards move the source file.The workflow consists of the following components: The data is written to the oracle table but no features appear from the output port on the featurewriter.Does anyone have a clue to why there is no output?Transformer documentation states that after succesfull writing all features appear from the output port.Thanks!

2050

1 year ago

jp12212Contributor

asked in Authoring

Combine so only a single row for each discipline feature.

Hi there, This one is fairly simple, I want to combine so the duplicate count is on a single row for each discipline feature: should look like: Duplicate UniqueRail Track and Civil 40 22 I've tried aggregator and attributepivot and haven't quite got it across the line! Cheers!

110

1 year ago

checcosisaniContributor

asked in Authoring

REGEX support

Hi can you help me to find the correct regex to extract only the string in bold (ALESSANO) \\\\199.168.30.208\\dati\\pippo\\PUGLIA\\ALESSANO\\INGRESSO\\ALESSANO\\tracciato unico.shp thx Francesco

1 year ago

checcosisaniContributor

asked in Authoring

Extract line from las point cloud

Hi how can extract the line from the las (see picture) of these barriers ? thx Francesco

940

1 year ago

sfsmith250Participant

asked in Authoring

How to set geodb_feature_class_alias with dynamic GDB writer

Hey hey ... I'm successfully writing feature classes from ArcGIS Map Server layers to GDB. My writer names and schema are defined dynamically because I'm iterating over many service layers (with a feature reader, driven by CSV rows). I was able to name my feature classes based on a field (readable layer_name) other than the fme_feature_type, but rightly the writer strips s p a c e s and ( parentheses ). I'd like to use the unmodified layer name as the geodb_feature_class_alias by setting a format attribute (which is exposed and connected), but it doesn't seem to ever take. Advice on how to set this up is much appreciated. Thanks in advance.

Workspace inconsistently freezing on featurereader

Hello, I have a workspace that is attempting to look for substantial changes to the schema/attributes of client data by comparing a past dataset to a new dataset. It does its job well, except for when it freezes. Irregularly, when processing one of its featurereader transformers, FME freezes completely. When it does freeze, the FME process is hung and will not stop/free the license until the machine is rebooted. I am running this workspace via the CLI, but the freezes have happened running from the GUI as well. When it freezes, the log file appears to be attempting to either find a plugin to use for the file, or merging the schemas (based on the last thing written/what would be written next). The freezes sometimes happen on the first featurereader, sometimes on the second. I have grabbed the last lines of the log file below from a recent freeze. This workspace normally takes ~90 seconds to complete, and is still running 16 hours later. I've waited over 48 hours before with no change.

350

1 year ago

mathikuContributor

asked in Authoring

Obfuscating my workspace

I like to use bookmarks in my workspaces, both to hide stuff, to navigate and to run specific parts. If I collapse/un-collapse a bookmark my organized workspace ends up as below. Anyone recognize this issue?

1 year ago

jp12212Contributor

asked in Authoring

Data analysis post-translation with a regex string searcher.

Hi, I'm basically trying to create a dashboard summary of my data but in the statistics stage, want to clarify I'm heading in the right direction as my knowledge of transformers is still young. I'm aggregating information based on a string searcher and want to collect all the object errors from the files and output them with the code name. Hopefully this makes sense with the assistance of the below images (spreadsheet snip is a distilled version of what is in my attribute manager), in short aiming to get utilities - 10 duplicates, 5 outliers, Road - 20 duplicates, 10 outliers etc. Thank you.

1 year ago

jakethepainterContributor

asked in Authoring

Why does Feature Operation switch to Insert in Feature Writer 2023 Form when it is migrated from 2019?

We are upgrading from FME 2019.2 to 2023.1. We migrated our server schedules and are testing them. I have a workspace with 3 feature writers, one each for insert, delete, and update on an AGOL feature service. When I run it on the server the log says it's performing inserts, updates, and deletes.When I download the workspace to FME Form 2023.1 and open the Feature Writers, the Feature Operation shows Insert for all of them!Is this expected?

390

1 year ago

fme_can_do_itSupporter

asked in Authoring

Feature Reader in FME form 2023.1

I am having issues using Feature Reader to access ArcSDE geodatabase in FME Form 2023.1. When opening the Feature reader in the old FME version, there is a DataSet option to select after choosing the Format. I also have the option to create connection files as a user parameter. Now in FME Form 2023.1, After selecting Format, the Dataset option changed to Connection. However, when I try to select a new connection file within the parameters, I am unable to find the option. In my previous FME workspace, I utilized connection files as user parameters. Please let me know if I am missing anything while configuring the Feature reader to read ArcSDE data in FME Form 2023.1. Thank you!

730

1 year ago

parke372Contributor

asked in Authoring

Using attribute from excel reader to write new sheets that are fanned out based on column contents - creating new file with all of the sheets, and editing existing file with a blank sheet?

So i have a sheet that contains a bunch of unsorted rows, and i want to read the most recent file, create separate tabs within the existing file for each unique attribute value and then copy all of the rows with that value into the associated tab. So i've got an excel reader to read the directory, then i'm sorting the files to get the latest one, sampling just the newest one and using featurereader to feed into the writer. i've attached a copy of my workspace for reference, as well as an input file. i've been trying to use this article as a guide:https://community.safe.com/s/article/fanout-1 but what is happening right now is the writer is creating a new file, with NULL as the filename with the new tabs, and, then editing the original file with an empty tab named "fme_blank_sheet" instead of writing them all back to the original file. here is a snippet of the original tab's data: so i'd like all of the unique specialchar values to be copied to their o

120

1 year ago

sunsilk11Contributor

asked in Authoring

Pass parameters to HTTCaller

Hi I would like to make a REST call using FME HTTPCaller to Validate Network Topology as defined in https://developers.arcgis.com/rest/services-reference/enterprise/validatenetworktopology-trace-network-server-.htmI have obtained the token in the first call, and would like to pass all required parameters in the second call. (see attached)I am getting error:This FME Edition doe not recognise the '' function Any suggestions how the required parameters, inc the token can be passed to fmecaller

1 year ago

dbaldacchino

asked in Authoring

Help with webhooks and FME Cloud

I am trying to create a webhook for a sheet in Smartsheet (https://www.smartsheet.com/ ). API documentation on webhooks can be found here: https://smartsheet-platform.github.io/api-docs/?shell#creating-a-webhookAs you can see in the diagram for creating a webhook, the webhook needs to be enabled after creation: this is where I'm having a problem and need some help! The "subscriber" (the callback URL, which for my test case I'm using a topic posted to FME cloud) has to respond with a 200 status and also echo back a "challenge" random number that comes in the response header by including it in the response header "Smartsheet-Hook-Response". Or it can respond with a json that contains this value in "smartsheetHookResponse" attribute.As you can see above, when I try to enable the webhook, the callback URL is triggering the topic (all good here; two attempts shown above). The highlighted string is what I need to return (step #5 of the image in

WMS Service creation- How to implement the GetFeatureInfo operation

Dear all,You have an article explaining how to create a WMS Service. Two operations are explained: GetCapabilities and GetMap (https://knowledge.safe.com/articles/19640/how-to-create-a-wms-service-using-fme-server.html).However, we also need the GetfeatureInfo operation. Is it possible with FME? I have not found information about this operation. It would be very helpful to have a .fmw for the GetfeatureInfo operation, in case it's possible to create it.Thanks in advance and best regards,Montse Marco

430

1 year ago

jp12212Contributor

asked in Authoring

Run workspace just on files (not internal features)

Hi, I'm trying to run the attached workspace on a series of files to check the coordinate system then output the filename and whether it's georeferenced or not. I want to extend this functionality later, but am struggling to just run it on files instead of the features within. Can someone please explain the best way to achieve this - my current way is to run a separate workspace runner and direct it to this, I don't think I'm quite getting it though still. I'm also running a different workspace for internal feature checks, and assume this would be the way to go - to break to an internal feature check, and file check workbench (can't think of clean way to organise the data otherwise.) Thanks!

120

1 year ago

jp12212Contributor

asked in Authoring

Integrating python regex schema check into FME

Hi all, I need a hand integrating this python regex script into the python caller, I basically want to run as per below. I have it all working in python but now have been asked (as work uses FME) to do it here. I'm struggling to understand how to integrate python into the FME workflow. if you could assist setting this up in a basic manner I'm sure I will get the hang of it, but have been struggling for a day or two. (Also I know I could not use python, but I want to extend beyond this functionality later and prefer python) My python script is around the lines of: def check_filename(filename): pattern = r'^([A-Z]{3}-\\d{3}-[A-Z]-[A-Z]{3}-MOD-\\d{2}-[A-Z]{3}-[A-Z]{3}-\\d{4})(-[A-Z]-\\d{2})?(\\.\\w{3,4})$' match = re.match(pattern, filename) return bool(match), filename if not match else "" def check_all_files(): for filename in filenames_: result, reason = check_filename(filename) if result: passes.append(filename)

164

1 year ago

vlroyrennSupporter

asked in Authoring

How to ensure unique output file names for self-serve FME Flow web apps and where to save them?

I have an FME workbench that writes to multiple Excel files (all contained within a single zip file) with the intent that the generated files will not really be stored, but merely returned as the output of an FME web app and discarded soon after. Having to write these files on-disk first means I have to consider "hygiene" between runs so that there's no risk of file name collision/overwriting, while also saving them in a location that is available for the FME Flow server to expose to the user via HTTP. None of the documentation I could find really addresses where to save files meant for use with the "data download service", nor how to ensure that file paths cannot overlap between runs. Is there an FME Flow parameter for this purpose, like a unique run identifier I could add to my file names, or a private directory created only for the output of this run? I'm thinking of something like what TempPathnameCreator outputs, but not as a transformer, since it means

700

1 year ago

jp12212Contributor

asked in Authoring

Why features aren't showing up as user attributes in CSV writer.

This is a simple one but I'm new to this, I just want to output a CSV of the feature data as shown in the image one, in the other image (CSV writer) there is only three showing up. How do I get all to show up so I can export all of them? Can someone please explain what I'm doing wrong here?Thanks!

250

1 year ago

roman00Participant

asked in Authoring

How can i make a translation fail on missing input PostgreSQL table?

When reading a PostgreSQL table with FME Workbench (2023.1) that has been droped (or renamed) before, the error in the logfile looks like: "Error executing SQL command ('select * from "schema"."table" where false limit 0'): 'ERROR: Relation »schema.table« does not exist".Despite of this error the logfile says that the "Translation was SUCCESSFUL". (The parameter "ignore failed reader" is already set to NO.) I need to know, if a table has been deleted (or renamed). So, how can i make the translation fail on missing input PostgreSQL table instead?

1 year ago

corinaal

asked in Authoring

Writing FGDB with 2 layers, one dependent of the other

Hello, quite difficult to find the right section for my question, so moderators, please move it in a more suitable one if it is necessary. I create a FGDB with a feature class and a table. The table shall use the OBJECTID of the feature class, so this one shall be created first to be able to use the OBJECTID in the table. Is there a way to create the FGDB in one wb? Thank you, Corina

1 year ago

i_miss_the_chatContributor

asked in Authoring

Update the location of a point in a table from UTMs

Hello, I need to update the location of a point in an SDE database from UTM's. Is there a way to write an updated location to the Shape* field? Thank you.

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

How to create orientation of a point shape file w:r:t the road centerline

Hello all, I have a point feature shape file and road center line. I need to create the orientation of those point feature w:r:t the road center line .

110

1 year ago

checcosisaniContributor

asked in Authoring

HTTP caller no result

Hi can yu hep me to understand where I can find the result of this website ? I supose I have to search for a json https://egovjesolo.jentecloud.net/jalbopretorio/AlboPretorio https://www.comune.roma.it/gedalbonet/albo/listaatti thxFrancesco

1 year ago

louielou1234Participant

asked in Authoring

ArcGIS for Portal connection never finishes creating

I was able to create a Portal Web Connection from the Template but after I 'Authenticate' nothing happens--the window does not close and I can not proceed to the 'OK' stage and move forward. What is the problem?... this process works fine when creating an ArcGIS Online connection because the Authentication window closes automatically and you can finish the process, but with Portal it just stays open and shows my portal and there is no way to finish the process. Any help would be much appreciated! !

130

1 year ago

Page 15 / 122

Badge winners

bromphas earned the badge Integrate Data with the FME Platform Training
maxelmer1997has earned the badge Student (Grey)
mbarbozahas earned the badge FME Form Basic Training
joshuaharmshas earned the badge Welcome Back
wongyongbinhas earned the badge Teacher (Grey)

Show all badges

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