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

Problem with custom coordinate system: "inverse calculation failed to converge" and some changes to MyCoordSysDef.fme are ignored by FME

FME version: 2016.1.3.2 (20170214 - Build 16717 - WIN64)Hi, i am trying to create a custom coordinate system (custom ellipsoid, custom datum, custom transformation and custom crs).The CRS i am trying to create is the EPSG:26331 (as parametrized by EPSG).Looking at the Coordinate System Gallery, there is a crs with name equal to EPSG:26331 (i will call this FME EPSG:26331)..But there is two points that i want to modify:Ellipsoid ParametersDatum Parameters.Ellipsoid Parameters:Searching into EPSG Registry (http://epsg-registry.org), the ellipsoid used by EPSG:26331 is EPSG:7012 - Clarke 1880 (RGS). This ellipsoid has:semi-major axis (E_RAD): 6378249.145 meterinverse flattening (inv_f): 293.465.using P_RAD = E_RAD [1-(1/inv_f)] = 6356514.8695497755In FME, this same ellipsoid has:semi-major axis (E_RAD): 6378249.1449999996 metersemi-minor axis (P_RAD): 6356514.8700000001.using the same formula above, we get inv_f = 293.4650060791153. A little different from what is in EPSG. (this was one o

Remove empty attributes in Data Inspector

Is there a way to have the data inspector not show attributes that are empty? When looking at AIXM 5.1 data, the tables is filled with empty attributes and makes it hard to 'inspect; your data

7 years ago

dilipsebastian

asked in Authoring

How to set username& password prompts for Database Connections in FME workflow ?

TOMTOM POI writer failing

I'm trying to convert some data into the TOMTOM POI format, but I keep getting errors and the output file is created but not populated. A simplified version of the workspace that generates the same error is here: The translation log contains this:TOMTOM_POI writer: Creating layer 'waypoints' with geometry type 'wkb_unknown'TOMTOM_POI writer: dataset C:\\Users\\myname\\AppData\\Local\\Temp\\_14244_1 does not support layer creation option OVERWRITETOMTOM_POI writer: Cannot create GPX layer waypoints with unknown geometry typeTOMTOM_POI writer: Unable to create feature type 'waypoints'. Ensure the dataset is valid, that the user has all required permissions and that the feature type name is valid for the formatTOMTOM_POI Writer: In Feature Type 'waypoints', 'fme_table_handling' has invalid value 'CREATE_IF_MISSING'. Possible values include: 'CREATE_IF_MISSING', 'DROP_CREATE', 'USE_EXISTING'A fatal error has occur

How do I loop over list elements for in python caller?

I have an aggregator transformer (to aggregate incoming features because I want a single feature to enter the subsequent Emailer transformer). I'm trying to use the python code (in PythonCaller transformer) to extract info about each of the aggregated features for output to the email. I'm using "for x in range (0, feature.getAttribute('Count')-1)" to try to loop over the lists but the workspace isn't accepting x.

640

7 years ago

mathieu_ambrosyContributor

asked in Authoring

FMEServerJobSubmitter and process order

Hello,With : - FME Server 2017 - Only 1 engine - A workspace with 1 FMEServerJobSubmitterCould you confirm that the child job launched by FMEServerJobSubmitter is always executed before any new job ?(ie someone asks for a new job before FMEServerJobSubmitter launches the child job)Regards.

Run FME transformer after processing of a writer

Hi, In my workbench, I am writing a file which i want to send as attachment in an email notification from the same workbench. How can i control my FMEServerEmailGenerator to work if only the file is written?Note: I am using Fanout process in writer.

Feature Read/Write count in FME Server response

Hi,Can i get the Number of features read by FME workbench as like NumFeaturesOutput in response variable while running it as Jobsubmitter or Data Download Service?

Capturing Errors in FME Server Log files

Can someone please explain how I can capture the Errors in the log file created by FME Server using Python. From what I have read I am still not sure if the python has to go in the startup, shutdown or PythonCaller transformer to capture any errors while it is running. I am also not a python developer so would appreciate a full working script or an example Workspace if possible? I am using FME 2016.

998

7 years ago

frantschContributor

asked in Authoring

Regular Expression for parsing multiple filenames from text

With FME 2015 Desktop, I use the StringSearcher do parse an attribute containing the below text:-rw-rw---- 1 20712 110 1102 Dec 15 09:08 VPDZ22.201712150908.zip-rw-rw---- 1 20712 110 1103 Dec 15 09:18 VPDZ22.201712150918.zip-rw-rw---- 1 20712 110 1102 Dec 15 09:29 VPDZ22.201712150929.zip-rw-rw---- 1 20712 110 1145 Dec 15 09:38 VPDZ22.201712150938.zip-rw-rw---- 1 20712 110 1238 Dec 15 09:48 VPDZ22.201712150948.zipHereby I want to obtain a list with all names of the zip-files within this text.Therefore I try Regular Expressions such as e.g.(VPDZ22.[0-9]{12}.zip|asc)+I expect to obtain a list with 5 objects containing the 5 different zip-filenames. However, I always obtain a list containing only one single object, which is the first of the wanted zip-filenames:VPDZ22.201712150908.zipHow am I to design the Regular Expression for this to work correctly?

How can i still get attribute values if one of two user parameters is left empty?

I created 3 published parameters but if one is left blank the attribute has no values. If just one or two of the three parameters is filled in the blank one has to display its standard values. How can I realize this?Update*: Before running the model the user need to fill in the parameters. Users can choose to fill in zipcodes or municipalities. If one of these parameters is left blank, the table in the dataviewer of the blank parameter has no data. If no parameters are given it won't show any data and I want all the data to be displayed when no parameters are given. The model is really simple since I created my reader with a more complicated model. I just want to give the users the possibility to get the access to the data based on location. I hope that my question is more clear now.

180

7 years ago

lazarlubomirContributor

asked in Authoring

How to divide number to sequenced list?

Hello everyone,I try to solve problem with numbers and values. In my project, I manage SQL select count via SQL Executor, so the result of query could be for example number 5. But what I need in second step, I have to create list with minimal value 0 and maximum value (result of query) 5. So list will contain following values 0,1,2,3,4 and 5.Any tips please?Thank You so much!Lubo

7 years ago

lazarlubomirContributor

asked in Authoring

How to change filename extension via FME?

Hello,please, I have one problem to solve. Is it possible to change filename extension in FME? E.g. I need to change filename "Analysis.doc" to "Analysis.docx" automatically in workspace. Probably some Python script is suitable there... Unfortunately, I´m not Python expert.Could anybody help me please?Thak You so much!Lubo

Folks,This is a bit of an odd one. I have a massive and complex workspace and was trying to debug an issue with a missing output feature.I was "circuit tracing" for the want of a better term and visually everything "looked" OK. However once I got to the final step to check the connection of a transformer output port to the writer I found the port wasn't actually connected to anything.My only defense was the massive number of transformers and connectors terminating at the same location.So after being a bit embarrassed (it was in front of a client), I was wondering if there are any smarts or techniques that can be used to detect transformers where none of the outputs are connected to anything.A red cog is shown when a transformer isn't fully configured. If there was something that could be used to find unconnected or accidentally disconnected transformers it would be very helpful.Any thoughts appreciated.

7 years ago

gonzikcz

asked in Authoring

Multiple CSV with different structure to SHP (dynamic way)

HelloI have 150 CSV files. I would like to convert them to equivalent SHP files. I don't want to do it one by one of course hence I chose dynamic workflow. This should be just a mirror translation (with geometry creation from WKT along the way). But I can't get this to work. In the writer I tick the Dynamic Properties with Schema Sources set to "*.csv [CSV2]" but this doesn't create any shapefiles complaining: 'Features with no schema defined'When I untick the Dynamic Properties the shapefiles are created but only with the geometry, no attributes. Here's the workbench. The CSV filename is the name of the feature. Bunch of attribute renaming and removing. Creating geometries. Reader:Writer (I tried geometry defined by schema as well but same result):Am I missing something? Thanks!

7 years ago

thaonguyen

asked in Authoring

Can I schedule to run a batch file (FME Desktop) from a SQL Server Agent job on another server?

Find which email attachment is excel file

When the workspace gets an email from the server, the attachment comes in as an array/list."email_publisher_attachment{1}"How do I search within the attachment list to find which is an excel file, then use that as the source attribute for the feature reader?

7 years ago

oscardInfluencer

asked in Authoring

Aggregation nightmare

Good morning!I've been given a sample of data to create aggregates from them (I have attached that data)The only attribute of the features is type. I have to build aggregates using features of the same "type".For example, these lines and point must be an aggregate:Or these lines and polygon:I've been messing around with the transformer NeighborhoodAggregator, but I'm incapable of adding the proper settings to make it work for all the types. Looking at the data, I'm not really sure if it is even possible to make it work for all of them.I've been trying with spatial relationships, but I can't make it work either.I'm out of ideas. I'm starting to think that I will have to treat every type on its own. In the data sample there are only 4 or 5 types, but in the real deal there will be more than 60.I need to create the aggregates, because in the database the aggregate will be stored as a point feature.I'm in need of another point of view, so thank

350

7 years ago

pushpaContributor

asked in Authoring

??Python interpreter could not be loaded

.Hi there,Could someone help me to identify why only one of our team members get this error?This user cannot Read or Write ESRI GeoDatabases A Python interpreter could not be loadedProgram Terminating Translation FAILED.thanks

670

7 years ago

verdoodtdriesContributor

asked in Authoring

Can I detect un-/connected input ports of a transformer ?

Hello FME-Community, I'm trying to find a workaround for the non-existing feature type TransformerInputPorts at the FME Workspace Reader.I would like to know whether it is possible to detect which input ports of a transformer are connected with other FME transformers within my workspace.The FME Workspace reader has among others feature types TransformerOutputPorts, Transformers and Connections.I tried to combine the information from these feature types, but without the desired resultsHow can I detect which input ports are (un-)connected for a specific transformer in my workspace ?

7 years ago

asked in Authoring

Filter comparing attribute by list from Excel table

Is it possible to filter data by attribute, comparing it with list (for example Excel table classificator). Features must be filtering depending on is attribute has a match in list or not.

Hello fellow FME users,I was wondering if there is a way to use the equivalent of a logic gate in FME. What I mean by that is a transformer that only passes data if the conditions have been met. An AND gate for example only passes the data if all inputs van been met for example: I have a main data flow with a specific branch that only gets triggered if a condition is true. I test this by using a creator and tester to test if a published parameter has a specific value. I would like for the passed feature to act as a trigger to trigger a branch.I've added a picture for clarificationAn OR gate is not needed because lots of transformers act like that. So is there something that works like this, or maybe a Python solution? I can't program Python though.Thank you in advance!Michiel

I need to import shape data into MS SQL spatial database from various file geodatabases. My workspace will be published on the FME server where .net service will call it.The structure of the fgdb is always the same shape_length, shape area and AO number.The feature class name is different in each fgdb. Is there a ways I can have global user parameter to read any feature class name from fgdb???The other choice I would have is to receive the feature class name from the API service and pass as user param but I am not sure if this would work. Any suggestion??@hcode@takashi

Add Web Connection without GUI

Hi!I have an Ubuntu 16.04 VM on Amazon EC2 and installed FME there. Due to compatibility issues, it is not possible for me to get a GUI when establishing a remote connection the the VM. I developed some FME workspaces on another computer and want to run them on the Ubuntu VM. As one of the workspaces uses an ArcGIS Online Reader, I need to add a web connection to the FME installation.However, I haven't found a way to accomplish that without a GUI so far. Is it possible to add the web connection thorugh the command line? Or Can I add the web connection in FME installation from another computer (with GUI) and copy a specfic config file to the other installation?Thanks in advance for any suggestions!Greetings, André

Limiting impact upon data source

Hi,I have a production server that is mission critical and I cannot impact performance. Unfortunately there is no mirroring or a secondary server I can access and it's hitting the production server or nothing. In reading from this server, I cannot impact that servers performance in any manner...fortunately I can schedule this in the evening when it's load is minimal, however I cannot impact the performance of this server for that minimal load.Does FME have any methods of 'running in the background' where it reads from the server only when it's resources are free (or minimally used)? Or diffrent wording...Is there any method I can use to ensure FME doesn't impact production performance while extracting data from a production server?MSSQL 2008 (source) to a Oracle 12c DW if that makes any difference for this question.Thanks!

7 years ago

Page 75 / 122

Badge winners

shivambkhas earned the badge Expert (Grey)
kameswhwarjenahas earned the badge Teacher (Grey)
kameswhwarjenahas earned the badge Student (Grey)
shivambkhas earned the badge Teacher (Grey)
shivambkhas earned the badge Student (Grey)

Show all badges

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