- - 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

Can you add a feature reader (specifically an Esri Geodatabase file) to a custom transformer?

7 years ago

chauContributor

asked in Authoring

FeatureReader from Oracle to FeatureWriter, all attributes end up being 200 char

Hi!I am trying to download a set of data from my Oracle database. I have created a simple workspace with a Creator, a FeatureReader and a FeatureWriter - connected in that order.I the reader I connect to my database and select a table. The writer I configure to export to an ESRI Shape file completing only the dataset and the shapefile name.When I look at the "User attributes" pane in the writer all my attributes from the Oracle database are listed but as CHAR 200 (and they are not all of them supposed to be CHAR):Why can't the reader and the writer work out the correct attribute configuration?

Can I pause or cancel a WorkspaceRunner from FMEObjects

I have some very long running Workspaces being run from C++ using FMEObjects. Is there anyway that I can allow the user to pause or stop them from code, perhaps when I receive log messages from them? If not, can I request that there is some mechanism added to the interface so I can. Currently on 2013SP2, moving to 2017.1 shortly.Chris

FeatureReader won't accept my Attributes to expose input

I have an Excel parameter file with tabular information indicating which files/feature classes/tables to read, which queries to use, which fields to expose, etc. I figured the FeatureReader would be a good option to use for grinding through my various datasets. I've managed to get most of what I need to work, but I am seriously struggling with the Attributes to expose. I first thought I could simply use an attribute from my parameter file as input, but it seems the FeatureReader only accepts User Parameters for this option. I therefore created a separate workspace for the FeatureReader, calling it from my main workspace through a WorkspaceRunner, with Attributes to expose as an input parameter. But...no joy. While it now seemingly accepts input from my parameter file attribute, it doesn't do anything with it. I have tried various settings for the user parameter (text, attribute, attribute list, ...). I have created a user parameter straight from the FeatureReader dialog (it se

Check if set of attributes exist or not

Hi,I want to check if set of attributes(not the values in attributes) exist in feature type or not?I also want to get the name of attributes to generate HTML Report which are Present or not present in Featuretypes.Case: I have multiple EXCEL filesFirst file with column name (A,B,C,D,F) Second file with column name (A,B,D,E) I want to check in which file which columns are missing out of Set {A,B,C,D,E,F,G}I want to retrieve the column names as well to generate HTML Report also.Please help on this topic, Thanks in advance.

Python Script will not run as Startup Script but runs in IDLE

Hi All,I have a python script that runs successfully in IDLE, but when I copy and paste the same script into the startup python script box in my workbench the script fails.Below is the script: # Import modules import arcpy import arcgisscripting import arceditor arcpy.env.overwriteOutput = True arcpy.env.workspace = "C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\www_gis.GIS_ADMIN.WastewaterDataset"# Local variables: www_gis_GIS_ADMIN_RMoN_San_GravityMain = "C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\\\www_gis.GIS_ADMIN.WastewaterDataset\\\\www_gis.GIS_ADMIN.RMoN_San_GravityMain" RMoN_San_GravityMain_Route_Output = "H:\\\\O.10_Operating_Projects\\\\Linear_Referencing\\\\Reference\\\\Linear Referencing Shannon Working\\\\Linear_Referencing_Working.gdb\\\\RMoN_San_GravityMain_Route_sde_connection" # Process: Create Routes ar

Anonymous

How do you set role policies in FME Server 2017? I don't see this link. How do I give a particular group access to certain features in FME Server 2017, such as the web user interface, notifications, repositories, etc?

7 years ago

thomask

asked in Authoring

Adding transformers from FME store fails

Dear FME community, when I try to connect to the FME store, it always fails to load the transformers. I can see what transformers are available, but there is no way to add them. I get's the following message for example (see also the attachment): "Could not download 'PythonEmailer'- A problem was encountered while trying to download from FME store." In the network settings menue I have set the option to "Use system proxy setting" and I also have writing permissions in my FME installation folder. Is there anything what I can do to load the transformers from store? Kind regards Thomas

5717

7 years ago

fmelizardContributor

asked in Authoring

My firewall is blocking FME Hub content when I am using FME Workbench. What can I do?

My company uses a firewall and I cannot download content from FME Hub when I am using FME Workbench! With the help of my IT Department, I have traced this issue to a couple IP addresses that were blocked: ec2-52-0-251-21.compute-1.amazonaws.com ec2-54-208-208-236.compute-1.amazonaws.com ec2-54-243-241-253.compute-1.amazonaws.com ec2-54-165-124-56.compute-1.amazonaws.com ec2-54-87-96-236.compute-1.amazonaws.com ec2-54-243-173-199.compute-1.amazonaws.comAre there any other IP addresses I should be aware of?

470

7 years ago

asked in Authoring

Can you do an UPDATE fme_db_operation using a field of type GUID as the Update Key?

I am trying to use a GUID field to update records in an ArcSDE Writer. It seems to work perfectly when using an integer field for the Update Key, but when I use a field with type=guid the update does not go through.

Save progress on long translation, is it possible?

Hi All,I'm very new to FME, so I apologize if this is a silly question.Is it possible to re-run only part of a translation?I have a series of transformers (clippers and surface modelers) which make up my translation, the whole thing takes 6 hours to run. I let it run over night and when I checked the output file this morning I realized I messed up something in the last transformer.I changed the parameter on the last transformer and it should be good now. Is it possible to just run the last transformer or should I re-run the whole thing and wait 6 hrs. I see the numbers of features on the connections between transformers, so I was hoping they're stored somewhere on the memory and don't have to be recalculated.

7 years ago

osarhan

asked in Authoring

Speeding up a workspace runner

Hi folks,This is my first post here so apologies if this is a basic question. I have a quick one about a workspace runner operation I am using. I have a project that makes sense and is working but I'm looking at trying to make it more efficient.It takes 2 files, workspace runner passes it file A, the workspace runs and matches variables in A to another static file, file B. then outputs the resulting file in File C. This all makes sense. It works beautifully.However it would be nice if I could read file B once as oppose to every time the work space runner fires off a process. It's a static file and quite big, and I have about 17,000+ file As to process, loading in File B for each of these is a massive drain on time. Is it possible to 'preload' a file for a workspace runner? I've looked everywhere for an answer but not seen anything that leads to an answer.

280

7 years ago

mathieu_ambrosyContributor

asked in Authoring

User parameter : difference beetween "Text (multiline)" and "Text (multiline) or Number" ?

Hi,I don't get the difference beetween these 2 user parameters (FME 2017.1) :Text (multiline)Text (multiline) or Number"Text (multiline) or Number" don't have a configuration button to specify numbers limits (like the Number parameter), so what's the point ?Regards, Mathieu.

7 years ago

navneetsahni100

asked in Authoring

how to use multiple versions of fme workbench for create the batch file ?

7 years ago

oscardInfluencer

asked in Authoring

ATOM feed for INSPIRE - OpenSearch description?

Good morning!I'm trying to implement an ATOM feed with FME Server 2017 that fulfills the INSPIRE requirements.I've been following this tutorial for the first steps: https://knowledge.safe.com/articles/1340/create-inspire-atom-download-service.htmlWith that tutorial, the following XML is created as feed:?xml version="1.0" encoding="UTF-8"?><feed xmlns:gml="http://www.opengis.net/gml" xmlns:georss="http://www.georss.org/georss" xmlns="http://www.w3.org/2005/Atom"> <generator version="2015.0" uri="http://h-0106"/> <id>http://myweb/Catastro</id> <link rel="self" href="http://myweb/Catastro" type="application/atom+xml"/> <rights>data.gov.uk</rights> <subtitle>Smoke control areas declared under the Clean Air Acts</subtitle> <title>INSPIRE ATOM Feed: Smoke Control Areas</title> <updated>2015-02-23T16:15Z</updated> <entry> <author> <name>Brent Council</name> </author> <categor

360

7 years ago

lifalin2016Contributor

asked in Authoring

Workspace log file is remembered !?

Hi,I recently needed to run the same workspace (command line) with two different target setups, but I wanted to see separate log files for each run. Simplified example:fme.exe myworkspace.fme --p1 ABC --p2 DEFfme.exe myworkspace.fme --p1 XYZ --p2 KLMSo I had FME create a workspace parameter (--LOG_FILE) for this value. This value is normally blank, prompting FME to use the workspace file path with "log" extension.I.e. my setup had the first run without a value, and the second run with a value for the log file..However, I found out, that the value given in the second run are somehow reused in the first run at a later time !?!Is this a correct observation, that FME somehow caches the last parameter values given to the workspace, and reuses these whenever the same workspace is run at a later time (and no other values are provided) ??I got my two runs to work only when both set the "LOG_FILE" parameter.Cheers.

7 years ago

lorraine_s

asked in Authoring

Auto updating Reader CSV

HiI have a workbench that takes a csv file and creates 10 csv files , 1 for each site - it does this using AttributeFilter. This works great but the csv reader gives the last 8 months of data with each month as a column. So the first version we ran had Nov to Jun. This latest month is Jan to Aug. So every time we run this the attributes change and I had to manually update this last time. Is there a way of automatically picking up new attributes from the reader and adding them to the writer (and removing any no long needed) please?I'd ideally like to schedule this with server but I can't unless this is automatic. Thanks

run second part of workspace only if updatedetector from 1st part finds changes?

Hi,Workspace attached. The first part is the CAD_Parcels bookmark. The second part is the CAD_Properties bookmark. I only want to run CAD_Properties bookmark contents if there are any features in the Update, Insert or Delete ports from the CAD_Parcels bookmark.I assume tester and workspacerunner may be in order. I have to turn this into a FME Server job submitter also.

Custom coordinate system for EPSG:3275

Hi, for my first time I need to define a Custom Coordinatesystem - since EPSG:3275 is not defined in FME.I have made the following entry under \Documents\FME\CoordinateSystems:COORDINATE_SYSTEM_DEF WGS84.SCAR-SU01-05 \ DESC_NM "WGS84 /SCAR IMW SU01-05" \ DT_NAME WGS84 \ EL_NAME WGS84 \MAP_SCL 1 \ORG_LAT -80.23861111111111 \ORG_LNG -165 \PROJ PSTERO \SCL_RED 1 \UNIT METER \X_OFF 0 \Y_OFF 0 I do:- Creator, create point with X -160 and Y -82 - Set CoordinateSystem to "LL-WGS84" - Reporject to "WGS84.SCAR-SU01-05" (my defined system) gives an error :Reprojector(TeeFactory): Reprojector: Reproject: Could not reproject the g

Multiple CAD files to multiple File Geodatabase (*.dwg --> *.gdb)

Hi, Query regarding how to perform the following task:Need to process the translation from multiple CAD files with dynamic schema to multiple file Geodatabase.(*.dwg --> *.gdb)for e.gabc.dwg --> abc.gdbdef.dwg --> def.gdbghi.dwg --> ghi.gdbprobably fanout is the process but need guidance how can i do it in best and easy way.Thanks in advance.

Many of our ArcSDE connections are OS Authentication and not username/password. How can I connect to the SDE instance with ArcSDEQuerier? It seems that the ESRI Geodatabase reader/writer uses a connection file but the Querier doesn't.

110

7 years ago

jatoxaContributor

asked in Authoring

Subtract list values from eachother based on index.

Hi, For some reason I have a problem wrapping my head around this and I know it might be easier to solve with a script. I have a list containing different numeric values and each value has an index. How would I go about to subtract one value with the next based on the index? For example; If index = 5 then subtract value5 from value4 If index = 4 then subtract value4 from value3 If index = 3 then subtract value3 from value2........ etc. There could be any number of values in a list so I need to somehow loop through all the values. Thanks!

Need an idea for a new useful custom transformer or format!

So... until my new job starts in October, I have some time to kill! I'd love to build a useful custom transformer or format and share it on FME Hub, but the problem is: I'm out of ideas...Do you have an idea for a transformer/format that would really be helpful to the community? So not something that only applies to your unique situation, but can be used by everyone? Post it below and who knows... it might appear on FME Hub the next coming weeks! Your name will be mentioned of course :)

Adding transformer to Workspace using single click in FME 2017.1

Hi,I have just upgraded to FME 2017.1 and want to be able to add transformers using a single left click - like I could using FME 2016 - however it looks like it is defaulting to double click. Is this a setting that can be changed?I try to minimize the amount of double clicks because of RSI.

7 years ago

casper

asked in Authoring

Testing on a group of rows

Hi everyone! I'm new to FME (using 2016) and have a question that keeps bothering me.I have an excel sheet with inspection results from a different company, these are based on different parts of an object. Each row is a different part of the object, with a column with specific inspection results. If any of the parts of the object has a value in the inspection column, I need the entire object to be copied to an output sheet. If none of the parts of an object has a value, the entire object needs to go to a different output sheet.The input looks like this (simplified).And the result should look like this:The objects with any row that contains a value in InspectionResultThe objects with without a row that contains a value in InspectionResultIt seems so easy, it looks like testing on a group but I can't figure out a solution. I tried selecting (tester) only the rows with a value, make a list of unique value of objectnumbers (list builder) and merge them again to the original table (

1650

7 years ago

Page 80 / 122

Badge winners

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

Show all badges

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