- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,026 Posts
12,531 Replies

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

3026 Posts

Recently active

Most replies Most views Newest first

sigtillContributor

asked in Authoring

DataDownload service - when no e-mail

Looking at the regular Sample\\austinDownload.fmw.When running this through the GUI with an actual email in Email result to field. The workspace will run, create a datadownload url and notify the topics DATADOWNLOAD_ASYNC_JOB_FAILURE or DATADOWNLOAD_ASYNC_JOB_SUCCESS and send e-mail. That is nice When I DONT write an e-mail. It will NOT notify the topics and it will not send an e-mail. So far so good. However how to replicate this through the REST-API of FME Server? I found the 8 year old thread regarding this: Using REST API submit, how to send email (safe.com) However have there been some changes on the REST API the last 8 years to better handle this?

209

1 year ago

arthyContributor

asked in Authoring

How to read all tab in ACC using AutodeskBIM360DocsConnector?

I would like to be able to read other tab in ACC. Right now the AutodeskBIM360DocsConnector transformer returns only the list of files within a project which correspond to the first tab. I can't read the other tabs such as reviews or Issues @david_r , @andreaatsafe , @Takashi Iijima and others , any ideas?

1 year ago

kmc5678Contributor

asked in Authoring

How do I prevent the Postgres Writer from naming all fields to lower case?

When I update the writer and uncheck "Lower Case Attribute Names" under Table Creation it automatically rechecks it after I close the window. I just want to retain the same field name format from the table I'm reading from.

221

1 year ago

bruceharoldContributor

asked in Authoring

Can anyone tell me the CKAN server URL for Open Canada? This is for the CKANConnector.

To create a web service for CKAN connecting to the Open Canada server, I have tried various permutations around https://open.canada.ca/data/en but no luck. Thanks!

222

1 year ago

itayContributor

asked in Authoring

Attribute index in dynamic writing

Hi there,I have a process in which separate gdb are written and indices are created on specific attributes. The next step of the process merges these separate gdb into one using dynamic writingWhat I want to know is do these settings (creating the indices) are carried over when writing dynamically and if not is it possible to index the specific attributes after the writing? (some python voodoo magic….) Thanks,Itay

1 year ago

anandakundu

asked in Authoring

Is it possible to connect to SQL Server database over SSH using FME

I need to connect to SQL Server database hosted on Azure cloud. It is currently blocked within LAN network and we are looking at option to connect to database over SSH or HTTPS. Is it possible to connect to SQL Server database over SSH using FME?

946

1 year ago

ebygommContributor

asked in Authoring

SchemaMapper - catching partially matched features

I'm using a schema mapper to update a number of attributes that have string values to a corresponding code. I'd like to catch features where one or more of the attributes to be mapped have a value that isn't in the schema mapping table. There doesn't appear to be an easy way to do this, since some of the attributes on the feature are mapped, the feature exits the mapped port. Has anyone come up with a good solution for this?

Creation of Published Parameters on FME Desktop

I was following to do a tutorial on "Extracting Data within a Clipping Polygon using FeatureReader" but I do not know how to create published parameters from the Navigator. I am knwe to FME. Can you please help.Regards

381

1 year ago

kateaewContributor

asked in Authoring

Is it possible to revert transformer names to their original?

I have been tasked with sorting out 100s of workbenches. In the majority of them the names of the transformers have been customised and should be in annotations rather than the actual transformer name, for easier readability. E.g. SQLExecutor is actually named Table_xxx or FeatureWriter is Named xxx_Output. I'd like to know if there is an easy way to just revert the names back to the original transformers names. I can't find a way myself, other than manually going through each one and changing it myself. EDIT: This is on FME Desktop 2022.1 Thanks!

1 year ago

mlufkinContributor

asked in Authoring

Creating Bingo cards?

Hi there,Slightly off the wall here, but has anyone created a workspace that can create Bingo cards? Ideally a 5x3 grid of random numbers between 1-90, but no repeating numbers...?Obviously, RandomNumberGenerator can give us a way to actually play the game...but I'm thinking whether FME can create the cards for users to play with..?Thanks!

Hallo! I have a general question about the dll's on fmeserver. There seem to be a lot of people having problem with this, but I cannot really find a good solution for it. In my company we have many scripts running on the server (2017.1.2.1 build 1775.) In my case I have made sure to use the same version when I develop in fme workbench.Often we have .dll's that can be found but not loaded, and the script doesn't do its job. This causes frustration for our customers. (An interesting perspective is that we didn't have any problems in our test-server, but they started right away on the production-server). We have tried to analyse if there is any systematics in this (specific scripts running just before, changes in python-version, engine-specific etc., but with no good results).Is there a way to get by with this problem? /Anne

173

1 year ago

mferwerda1111Participant

asked in Authoring

Error with Decimal xx.x format ODBC to Hive table

Any thoughts on the below error, trying to load data into a Hive table that has columns defined as decimal 11,2Value is 6500, I have also tried stringformatter to 11.2f, and hard coding value to 6500.00, and a few other things like setting the value to double(@Value(my_amount), etc. Database Error Message: [Cloudera][ImpalaODBC] (370) Query analysis error occurred during query execution: [HY000] : AnalysisException: Possible loss of precision for target table 'xxx.xxxx'. Expression 'CAST(65000 AS DOUBLE)' (type: DOUBLE) would need to be cast to DECIMAL(11,2) for column 'my_amount'

440

1 year ago

bhkContributor

asked in Authoring

How to Author A User Parameter to Select Which Writer to be used when having same Data source and many end point

I am writing a WS which is reading an Excel sheet for two Writers which are supposed to write in two different environments (DEV and TEST) As you can see since the source data is same I am using only one stream workflow instead of duplicating the transformers for each writer (DEV and TEST) I have created a User Parameter like this Now, can someone please let me know where and how should I assign this into the workflow to select the endpoint (Which Writer to be used)? Thanks

How to pass a user parameter to a custom transformer and used in a pythonCaller?

How does one pass a user parameter to a pythonCaller that's inside a customTransformerimport fmeimport fmeobjects def processFeature(feature): p = FME_MacroValues['SomeUserParameter'] print p I read here "If you put your pythonCaller inside a custom transformer, the parameter name changes to {customTransformerName}_SomeUserParameter. "I tried then doing this below but still does not work.import fme import fmeobjects def processFeature(feature): p = FME_MacroValues['{customTransformerName}_SomeUserParameter'] print p What am I doing wrong?

2234

1 year ago

ingallaContributor

asked in Authoring

Automate running workspaces when date in folder and files change....

AllI am having trouble automating some workspaces as the data and folders that I receive are containing dates in the format MMMYYYY as shown below...\\\\server\\FMEData\\DataDownloads\\Supplier\\Data\\Data\\Name_Mar2020 The files are supplied as shapefiles and they are also named Name_Mar2020.shp etcHow can I automate the running of these workspaces for when the folder or file name changes to the next month?? I have tried using the * in various places, but to no avail and don't want to have to run these manuallyI know this is something obvious, but just cant figure it out... Regards

1 year ago

matthieuvContributor

asked in Authoring

How to make a test workspace for a custom transformer

I've created a custom transformer which I think can be of use to other FME enthousiasts. I want to upload it to FME Hub as described here Publishing an Item to the FME Hub (safe.com). It states that it is best practice to upload an test workspace as well, but the information provided on how to do that is minimal. Is there somewhere a template available?

hi ,when I try to open my project . ERROR "The design point file to be loaded does not exist" appears there is no files. it appears empty if you know how I can recover my work? thanks.

Devo eseguire un intersect tra due dati poligonali, selezionando, su uno dei due livelli, i dati in base ad un'espressione.

Nel livello in cui devo selezionare i dati, devo applicare l'espressione Area >1

1 year ago

checcosisaniContributor

asked in Authoring

Error run woprkbench FME academy Workspace Prototyping

Hi when I run the exercise-workspace-prototyping.fmw I received this error can you help ? thx Francesco

How to use Environment Variables in User Parameters ?

Hello,I'm working with FME Desktop 2015 with a WorkspaceRunner transformer calling several workspaces where i have to use an environment variable in the path of some private variables.For example: %ENVIRONVAR%\\dat\\myfile.txtThe problem is that the called workspaces don't recognize the value of the environment variable defined by the Windows System. I have tried to assign the value to the environment variable inside the workspace but it is not a good solution in this case because every PC could have a different value.Is there some example about to do solve this problem?Many thanks in advance!A.

37915

1 year ago

dms2Contributor

asked in Authoring

FeatureMerger as a blocking transformer when no features reach its Requestor port

Does the FeatureMerger actually work as a blocking transformer when no features reach the Requestor port? I mean, for example in the workblow below, I assume the Creator transformer will go first but after that, will it read the json file, wait to see if any feature enters the Requestor port and then go on through the rest of the flow? I'm reading and writing the same json file so it's critical to know. It works as expected so far but if anyone knowing for sure could confirm I would appreciate.

Why is the Spatialrelator tool merging attributes but inserting blank values?

I'm trying to do a spatial join between two AGOL layers, one is a strip map and the other is parcel data with owner info. I want to merge the two and create a table with the owner information and its respective page number. I have been using the SpatialRelator tool; the parcel data are Requestors, the strip map pages are Suppliers, Spatial Predicates are intersects/touches/within, and merge attributes are checked with Merge Supplier as the Accumulation Mode and Supplier as Conflict Resolution. The SpatialRelator will create a table with all attributes merged but all of the supplier data is shown as "<missing>" (and it's definitely not missing in the AGOL layer). I have tried a few different combinations of this but I just can't seem to populate the entire table. Has anyone ever encountered this problem?/Does anyone have any ideas on a fix?

144

1 year ago

checcosisaniContributor

asked in Authoring

Hi, after following the OpenAI GPT-3 webinar I would like to ask if is it possible to create a process to detetc/extract the traffic sign from images using OpenAI GPT-3 in FME thx Francesco

1 year ago

ingallaContributor

asked in Authoring

Looping in a URL

Hi All I have a URL in the format http://blah.com/images/{index] where the maximum index value will be the total number of records minus 1. So for three images the indexes would be 0, 1, 2 What is the best way to take the attribute imagecount and loop to the URL for the correct number of times starting at zero??? Just getting a bit confused now....Regards

read image in Excel sheet

Hi,Is there any way to read an image from a excel sheet or expose the hidden attribute/row that contains it?Thanks

684

1 year ago

Page 16 / 122

Badge winners

carstenhpthas earned the badge Teacher (Grey)
offi24has earned the badge Welcome Back
jakes3has earned the badge Teacher (Grey)
whichwayisnorthhas earned the badge Student (Grey)
gzanotto_gahas earned the badge Integrate Spatial Data

Show all badges

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