- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,045 Posts
12,618 Replies

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

3045 Posts

Most replies

Most views

Newest first

clairestoddartContributor

asked in Authoring

Adding previous month name to output filename (python)

I am looking for a way to add the previous months name to the filename of an output Excel e.g. Filename_August.xlsx.I have been trying to do this with Python (I am a Python beginner) as a Private Parameter using the following:from datetime import date, timedeltafirst_day_of_this_month = date.today().replace(day=1) last_day_prev_month = first_day_of_this_month –timedelta(days=1) prev_month_name = last_day_prev_month.strftime(“%B”) print prev_month_nameThis works in python but it fails in FME.Any ideas?

FeatureReader resets PostGIS schema to my saved default.

Windows 7 / FME Desktop 2017.1.0.0 build 17539FeatureReader with PostGIS. In the FeatureReader, in the (PostGIS) Parameters, in Schemas for Table Listing, the schema "data" is saved as my default. Works like a dream.Every now and then I need to edit a workbench with another schema already configured. Now it comes: when I open the FeatureReader to edit the Feature Types to Read, I get Failed to retrieve feature types. I believe my default PostGIS schema setting is overriding the original configured schema.I wonder if this is how it should work.

I'm a very new to FME. I'm trying to transform a geodatabase file with several items to a dwg file using the Clipper and shape file boundary. The clipping appears to be working correctly. However, each layer within the new dwg file has a copy of every object. Each layer has the same properties like color, linetype, etc.

1300

7 years ago

davideagleContributor

asked in Authoring

What does it take to get a badge around here? (Friday Fun)

I was recently putting together an example of calling a third party application and wrapping it up in a custom transformer and I thought I'd share a (fun) variation I came up with to demonstrate a point.Filtering the posts on the Knowledge Center is now a little more functional than it used to be and a few of you will have noticed that the filter options build the URL to a standard format, so of course you can get FME to do that for you too. Quite a few websites use this approach and communicating with APIs is quite similar, so FME lends itself to the task very well.Given that I'm feeling pretty hard-done-by, that I did post a question on TLAPD (Talk Like a Pirate Day for those land-lubbers out there) and yet I still wasn't granted a "special" Pirate Chief badge. I thought I'd create a small BadgeChecker transformer that incorporates:- Custom Transformer technology - Embedded, though it could be exported and shared. - Attribute hierarchy in the AttributeManag

180

7 years ago

venuContributor

asked in Authoring

Create Attribute and Populate values from table

I have a table information and that needs to be transpose like shown below screen shot.Parcel number is more then 1000 and each parcel bldg type up 30 plus types.Please can advise to achieve this task.Thanks in advanceVenu

270

7 years ago

Anonymous

asked in Authoring

Routing a Workspace in a Workspace Runner

In FME Server 2017 you can route a job to a specified engine by specifying the tag for that engine in the Job Routing Tag box in the Advanced panel of the Run Workspace dialog. However, I am calling the workspace from a workspace runner using the FMEServerJobSubmitter tool. There is no facility in the workspace runner to enter the job routing tag. Also, when I publish the workspace runner to FME Server, there is no place to put in the job routing tag. I tried setting the FME_SERVER_REQUEST_PARAMETERS parameter to "tm_tag=my_engine_tag1" but it still failed when I ran the workspace runner because the workspace did not route to that engine. Is there a way to set the job routing tag either when you publish the workspace to FME Server or when you call the workspace from the FMEServerJobSubmitter?

100

7 years ago

tnarladniEnthusiast

asked in Authoring

allowing users to map attributes

So the scenario is: I have an SDE featureclass with attributes A,B,C. User has shapefile with attributes A,bob,C,D. I want to create a workspace to be run on FME server that will allow the user to map one, many, or none of the fields. I'm not sure how to go about this. I also want to map the matched ones so the users will only have to match the remaining, but still give them the option to change the mapped one if they so choose. Thanks.

Errors in attribute removers

I have noticed that when an error is present i attribute removers the mapping to the writer is not correct.I am using ESRI interoperability's FME engine and have had very bad experience.On esri version 10.2 the error is visible in the mapping - the "lines" will be moved around, On ESRI veriosn 10.3 its ´really bad, because the lines are correct but data is put into wrong Places.Is this a know error ?

7 years ago

miikamakela

asked in Authoring

Batch analysis of FileGDB layers

Hi,I have a situation where I have two file geodatabases. They contain subsets of data from the same spatial areas and have a structured coding (see example image below).As the layers can be large I wan't to process them in a workbench one pair at a time. But there are many pairs, so I would want to batch this. I know of a method to do this using PATH reader and WorkspaceRunner, when the inputs are Shape files. But with the PATH reader you can't map in to FileGDB layers. I do not want to convert to Shape, as I would loose the complex attribute names.Any suggestions how I could send each pair at a time to a WorkspaceRunner in batch? Attached is the logic how it would work with Shape-files.Thanks for any ideas!

7 years ago

bhargavi

asked in Authoring

How to export multi geometry join filed in smallworld to shape files using FME?

Example: MagikSF> vl.collections[:l!foreign_facility].at(45281100).lg_scale_annos $ a sw:db_set MagikSF> print(!) $ db_set: l!for_facility_lg_scale_anno226:(gis_id(1160218,959604322,45281108)) l!for_facility_lg_scale_anno226:(gis_id(1160218,959604322,45281110)) MagikSF> foreign_facility is joined with other large scale anno collection and in smallworld it is returning as ds_set. while exporting that, it is going as char and taking "db_set" as value in text format which is not correct .how to export this particular field.

7 years ago

maremareContributor

asked in Authoring

Is it possible to Filter attributes in feature information window?

Hi,Is it possible to set the attributes in the Feature information window so that the colors in the color will be displayed in the same color as igds_color without using the workbench? (Fme Viewer set fme_color like igds_color when input dataset) Is it possible to make a filter on attributes in the Feature information window so that we see only certain attributes in feature information windows?

Checking if previous or next Feature exists

Hello,I have a set of node data. Some of those nodes will have an empty attribute. I am trying to populate them (call it "config") based on previous or next feature. The condition is should be somewhere along these lines: If Feature[-1] exists AND Feature [+1] does not exist, then Config = feature[-1].ConfigAdversely, Feature[-1] does not exist AND Feature [+1] exists, then Config = feature[+1].ConfigIf both exists, then Config = feature[-1].Config. I am trying to write out the conditional statement and have adjacent feature checked. The conditions only allow for checking if an attribute is null, missing or has an empty string. I don't seem to have any option for the existence of a Feature itself. Any one have any idea how I can go about that? Thanks!

Oracle to Shapefile-Field Length?

Hi, I have geometry in one Oracle table and attribute information in another which I am merging using feature merger. This works fine, the problem I then have is that I need to write to shapefile and it truncates fields to 254. In one particular field there are 100+ attributes that are over 2000 characters in length. I know I can use substring extractor to extract various lengths but does anyone know how I could ‘automatically’ create x number of attributes (each less than 254 characters) so that I would have 10 attributes of 254 length etc. that would make up 2,540 characters? Thanks

7 years ago

jdhContributor

asked in Authoring

Parsing Filename(multiple) parameters

What method do use to parse the Filename (multiple) parameter in python? I currently use source = FME_MacroValues['Param1']if source.startswith('"'): from shlex import split fileList = split(source[1:-1])else: fileList=[source] but it feels clunky. The assumption is that if it's a single file, it is not wrapped in quotes, but if it's multiple files it is: ""file1" "file2" "file3""

7 years ago

pratapContributor

asked in Authoring

Attributes

Hi,When I use FeatureReader and read the data, I'm receiving features with attribute names ending with (encoded: utf-16) and (32 bit integer). When I use the normal reader, I'm receiving the attributes as-iseg: id (32 bit integer) and ATTR1 (encoded: utf-16)Could any one tell me how to get the attributes as-is because I have to use the same attributes in featurewriter and write the data with Automatic attribute definition There are 1295 feature classes which is not possible to define the attributes for each feature type...Pratap

7 years ago

fmelizardContributor

asked in Authoring

How can I stop FME from sending usage statistics?

When I installed FME I think I checked Yes, when asked if I want to report usage statistics Anonymously to Safe Software. But I don't want to report this anymore. How can I turn it off?

7 years ago

stihe

asked in Authoring

Remove outliers in a list

I have a vector dataset containing buildings and a raster dataset containing elevation data.I am looking for a way to find the mean and maximum value of the roof of each building.So far I have converted the raster dataset to points, extracted the raster value to an attribute and clipped it with the building polygons. The StatisticsCalculator can help me finding the mean and max value in each building, but before doing that, I would like to remove the outliers.So the question is: how can I remove the top and bottom 5% of the values in a list?

OfficeScan and FME Desktop

Trend Micro Office Scan quarantined my 2016 FME desktop and in the log it comes up with unauthorized file encryption. I have been able to reinstall FME to a new location but eventually is get caught again.Has any other users experienced the same issue?

FME and Python best practices

Hi, it would be great if we could get some "official" input from Safe on this issue:https://knowledge.safe.com/questions/53449/running-python-in-fme.html

7 years ago

pinkopoContributor

asked in Authoring

Re-run reader after error in workbench

Hi guys,I am trying to setup a workbench to download data from various feature servers. the reader's format is Esri ArcGIS Server Feature Service and i use feature writer to write the data.I've been having this below error notice once a while, but it's normally gone after i re-run it after a while. Python Exception <HTTPError>: 502 Server Error: BAD_GATEWAY for url- Is there a way I can setup in my workbench to let it keep running after one of the readers has this error? - Can I let the workbench re-run that reader after receiving this error?Thanks

7 years ago

lifalin2016Contributor

asked in Authoring

Expanding the FME Workbench GUI with custom buttons ?

Hi,I base my production runs on FME mapping files, which I create from Workbench workspaces by using "Save As". This way I can mess a little with a the workspace without throwing my Is it possible to add this 5-click procedure as a nifty custom "macro" in the Workbench GUI toolbar ?I.e. save workspace as mapping file with the same name and in same folder, prompting for overwrite if required.Cheers.

110

7 years ago

lifalin2016Contributor

asked in Authoring

Setting custom "Application Name" in connection string ?

Hi,Our IT department now wishes to have all connections to the central admin database (MS/SQL) identify themselves properly. I.e. not as e.g. ".Net SqlClient Data Provider" etc.FME does identify itself as "FME(R) 2016.1.0.1" in this case, but it would be nice, if one could overwrite the connection default "Application Name", e.g. with a custom workspace related name.Is this possible ?Cheers

How can I resolve "No module named arcgisscripting" resulting from a Shutdown Python Script in a workspace?

My PYTHONPATH system variable is set to the following and python.exe and pythonw.exe are both in the D:\\apps\\Python\\ArcGIS10.5 folder. This script works fine in the Python window in ArcMAP.D:\\apps\\Python\\ArcGIS10.5; D:\\apps\\ArcGIS\\Desktop10.5\\bin

620

7 years ago

tomw202Participant

asked in Authoring

TweetStreamer - Is it possible to retweet and follow a tweet/user

Hi, I'm using the TweetStreamer to monitor a few key words, when I hit these key words, I'd like to retweet the tweet, and follow the user who created it. I can't see an obvious way around this at the moment, so am looking for suggestions!

7 years ago

aaronfisher82

asked in Authoring

How to pass data from one workbench to the next workbench

I am trying to chain together multiple workbenches so that when one workbench finishes making changes to my data, that changed data will be passed on to the next workbench. I am using a WorkspaceRunner at the end of the first workbench to begin the next workbench. I have been trying to find information on how to read the data from that WorkspaceRunner into the next workbench, but have been unable to find any clear information about how to do this.What reader should I use or steps do I need to make to accomplish this?

1240

7 years ago

Page 79 / 122

Badge winners

rekhaeyhas earned the badge Expert (Grey)
rekhaeyhas earned the badge Teacher (Grey)
rekhaeyhas earned the badge Student (Grey)
soniaesahas earned the badge Expert (Grey)
soniaesahas earned the badge Teacher (Grey)

Show all badges

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