- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,044 Posts
12,606 Replies

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

3044 Posts

kalbertContributor

ODBC 3.x reader -- SYBASE connection ?

I have connection details to connect a Sybase DB an I try to figure out how to connect using the ODBC 3.x reader. I have no knowledge about ODBC. so my question is, what do I have to type in the Database field of the ODBC 3.x Parameter window. I have a username and pwd, and my connection details are similar to the following Default DB: db_prod Server Name: MONUM99 DBMS: Sybase ASE Any hint is appreciated

10 years ago

chrisgreen

asked in Authoring

Dynamic Schema - Writing Error

Hi, Iam attempting to write data using dynaminc schema in a workspace, it fails with the following warning: Unexpected execution path. Please contact Safe Software A fatal error has occurred. Check the logfile above for details ... Last line repeated 2 times ... I am writing to ESRI geodatabase feature classes. When i disable the writers and run the workspace, everything works as it should do. I have used dynamic schema before succesfully and have tried many different variations of parameter setting but to no avail. Any help much appreciated! Thanks, Chris.

I have a workspace that uses the TwitterStatusFetcher to search one of our Corporate twitter accounts for Winter Gritting notices. This transformer has suddenly stopped working as of Jan 15th. Is this anything to do with Twitter restricting access to SSL/TLS traffic? Using FME 2013 at the moment but will upgrade to 2014 in the coming days.

I need to merge two files (excel). I want to retain the common fields, but I want to remove duplicates, but also flag the data sources. So for Example I have: Readers File A Name, Postcode, DOB Bob, NG1 1AA, 01/01/1970 File B Name, Postcode, DOB John, SW1 1AA, 01/01/1980 Writers File C Name, Postcode, DOB, FileAFlag, FileBFlag Bob, NG1 1AA, 01/01/1970, Yes, No John, SW1 1AA, 01/01/1980, No, Yes I can merge the File A and B , simply by using 2 AttributeCreators and 1 AttributeKeeper and a Writer. ------------------------------------------ The problem starts where I have duplicate entries and want to merge the data. See below: Readers File A Name, Postcode, DOB Bob, NG1 1AA, 01/01/1970 File B Name, Postcode, DOB Bob, NG1 1AA, 01/01/1970 Writers File C Name, Postcode, DOB, FileAFlag, FileBFlag Bob, NG1 1AA, 01/01/1970, Yes, Yes ------------------------------------------- Anyone know which transformers I need to use for this situation? Thanks, S.

Hello, I have an xml file such as : <Content> <a n="test1">value1</a> <a n="test2">value2</a> <a n="test3">value3</a> ... </Content> i am trying to read this content with an xfmap script ( through an XMLFeatureMapper) I want to create a Feature by "a" element with : - an attribute named "name" -> the value of the attribute "n" - an attribute named "value" -> the value of the element "a" I was hoping to make this like : <?xml version="1.0"?> <xfMap> <feature-map multi-feature-construction="true"> <mapping match="a"> <feature-type> <literal expr="Content"/> </feature-type> </mapping> </feature-map> <feature-content-map> <mapping match="a"> <attributes> <attribute>

290

10 years ago

ebygommSupporter

asked in Authoring

Fanout on attribute after generic reader

I have a workspace that reads a table and then outputs a map per polygon feature using a fanout on the writer. This relies on there being an attribute called Name with unique values within the source table. I'm trying to make this a bit more robust and catering for situations where an attribute called Name might not exist (e.g. it's actually NAME or name) I can use a Schema_mapper to rename NAME and name to Name but this doesn't cater for the situations where the unique field is called _name or even ID :-) What I'd really like to be able to do is get the user to type the field name to be used to fanout when selecting the source input but I can't figure out if this is possible. Any ideas?

Closest neighbor with matching attribute

How would I find the nearest neighbor feature that has the same ID attribute as the base feature? Ex: All line features (candidate) have a unique ID. All point features (base) have a matching ID to the line features, but are not necessarily in close proximity to each other. In the output, the points should have a relationship with the line of the same ID. Thanks

Hi, Any alternates for Select by Attributes ??

Rename Feature Type Names based on a list

I have a list of counties in Georgia with their corresponding FIPS code (13xxx) where 13 is the state fips for Georgia. Each county FGDB has a a parcel and point feature class and they are named by State Code (GA), FIPS code (xxx) followed by undescore and either point or parcel as suffix. I'm consolidating all feature types from each county FGDB into one state FGDB. All the features on the reader will pass through a FeatureTypeFilter transformer so that each feature type will be copied into the new FGDB. However, instead of the original name (GAxxx_point or GAxxx_parcel), I'd like to use the county name followed by the parcel or point suffix and some other prefix. Without renaming each feature type in the writer, I'd like to use my county/FIPS code list to name each feature type dynamically. Any suggestions?

10 years ago

gioContributor

asked in Authoring

conditional attribute setter and valuemapper unwanted evaluations?

Hi all, a good comming year of course. I have a question concerning conditional attributing. In this case it concerns the attributesetter. I have a dem raster to wich i added a pallete. I do a conditional setting to change the colors (kind of a colorrange) adn create a new colormap. test if _matched_parts{0} between 0,10 outputvalue @Value(_bandnr{0}) 73,255,255 elseif etc.etc. This results in a error. If i do this same in an attributevaluemapper i get the same error. When i do the test in a testfilter and connect a attributecreator with the same tests and outputs it works. ( i do have to remove the evaluation in the attributesetter, else it will try to evaluate "@Value(_bandnr{0}) 73,255,255" wich is a simple concatenation.) This is not desirable because i get a lot of transformers. Am i correct to assume that the valuemapper and conditionalsetter try to evaluate "@Value(_bandnr{0}) 73,255,255"? How do i prevent this? Oh, and before you go all wild Takashi, i

Saved Workspace opens but is Blank

I run FME Server and created a workspace yesterday to process OS AddressBase csv files. I kicked the process off yesterday and left it running when I went home. This morning when I came in my PC had rebooted (and lost the connection to the Server). I logged back on to the Server and started FME. I opened my Address workspace to see how it had got on - the workspace was blank - no transformers, no readers, no nuffink. The folder where my Workspace was saved contains 3 files ... (a) the Workspace fmw which still has everything in it (if you open in Notepad), (b) the log from yesterday which showed the process ran OK and finished after an hour. (c) a recover file which contains <?xml version="1.0" encoding="windows-1252" ?> <RECOVERY_FILE HWND="65876" COMPUTER_NAME="GISBUILD" USER_NAME="mitcheli$"> <UNDO_STATE FILE="C:\\Users\\MITCHE~1\\AppData\\Local\\Temp\\2\\wb_recovery_1387380016793_5468"/> </RECO

Hi there, I have a set of large CSVs (without a Header for attrib names) with a variety of different record types distinguished by the value of the first column ... so I would expect to use a TestFilter to split into their separate feature types - Type A, Type B, and so on. Once I've isolated these different feature types I want to rename the attributes (by default they'll be Col0, Col1, etc.). The attrib schemas are different for different feature types. I have a set of header files, each a single line, one per feature type ... which contain the attribute names. - Col0 in the TypeA-Header file contains the new name of Col0 for TypeA features from the big CSVs. Is there a transformer I can use ... rename the attribs of this feature type using the values of the attribs in this line of this file - one column at a time? I know I could use the SchemaMapper but that'd involved editing my header files. Just wondered if there were summat to save a bit of faff. IanM

fme and arcpy - calling arcpy functions, where?

I tr to execute the following arcpy function from a fme workbench: arcpy.CalculatePolygonMainAngle_cartography("FeatureLayer", "poly_angle") from the PythonCaller transformer to calculate a polygons main angle. What I can't really understand (as my python skills are absolute nonexisting) is how to wrap than inside the template function interface. I have tried to integrate the arcpy- function like this: --- import fmeobjects import arcpy def angleFeature(feature): ang = arcpy.CalculatePolygonMainAngle_cartography("FeatureLayer", "angle") feature.setAttribute("angle", ang) -- but when trying to run the workbench I get the following error ERROR 000732: Input Features: Dataset FeatureLayer does not exist or is not supported so Im stuck with the problem that the function cant find my source (wich is a Geodatabase_SDE reader. It also feels that once I get the features into the function, CalculatePolygonMainAngle will write

Published Parameter as Shapefile name - incorrect attributes attached

Hi I have a project that converts a GML file into 6 individual shapefiles. I have mapped all the attributes from the GML file to different names in the shapefile in order to comply with the 10 character limit e.g - featurecode > featcode versiondate > date Now I want to name the shapefile dynamically from a publish parameter so I used the attribute creator to create a new attribute called "feature_name" with the value: $(name)_TopographicArea and this outputs a shapefile with the correct name. so far so good...... The problem is the shapefile now contains multiple additional attributes that I didn't select or want in the resulting shapefile. How do i retain the schema mappings that I made? Any ideas? Mike

11 years ago

jelleContributor

asked in Authoring

conditional execution of densifying

Hi FME'ers, I have some base features, and candidate features from another data set, sent through the SpatialRelator (Equal, Within). For the base features that failed these spatial relations, I do a Densification. Together with a densification of the candidate features, I send the features through the anchored snapper, with which I can improve my results with a second SpatialRelator. However, sometimes the first SpatialRelator has no features in the failed port (all the objects have been found). In this case, I don't want to carry out the Densification because there won't be any candidate feature for the AnchoredSnapper. This extra processing time is not necessary. How can I start the densification ONLY if there are features in the Failed Output port of the SpatialRelator? I tried to solve this with a variable, but it didn't work out. Or should I try harder? The only use case I found, was http://fmepedia.safe.com/articles/How_To/Get-the-Start-Count-for-the-Counte

11 years ago

dallasbarr

asked in Authoring

Help on my spatial allocation script

Hi all A short introduction to my script so far: I have two readers a. NewsArticle (s stands for source) ID-S | Text | Country_S | Sector_S 1. ... ... ... 30 ... b. Shapefiles of all different sectors ID-dB | Sector_dB | Country_dB | 1. .... ... .... 30000 ..... The mail goal is to assign the different Newsarticles to the correct sector (in order to map the news). I am doing this by an inlinequery that Takashi suggested. This query's output are all the articles that are both matched by country as by sector. (lets say 14 out of the 30 articles). I would now like to use the rest of the articles (that have not been assigned to a specific sector) to be linked at the country level. I have a shapefile of all the countries. I have come up so far with a query that links all the articles to a country, but I only need the ones that are not yet linked to a sector. Is

11 years ago

fmelizardContributor

asked in Authoring

List but not a list

Hi guys, I am reading an XML that contains list elements that do not start with 0 and therefore are not recognized by FME. Well they are and then again they are not , I can count the number of elements but I cant explode it> which is what I want. Any ideas on how to tackle this? Itay

11 years ago

mattyn

asked in Authoring

Template Variables are always _underfined_

Hi Everyone, I have looked through all of the community information and knowledge base for some help on this but can't find anything to help with the issue. I am trying to use templating in email notifications and I can't get the client specific keywords to be anything but _undefined_. I would like to include the directory of the transformation results in an email to certain users when a job fails. That way they can see in the log where the issue is. Thanks in advance :)

11 years ago

dallasbarr

asked in Authoring

Add country attribute by searching for words

Hello, I am fairly new to using FME but I wanted to solve a problem using this software. I have a spreadsheet with all kinds of different newsarticles wich I would like to spatially assign (automatically) to a specific country. In the newsarticles, a country name is often mentioned. I was thinking if there was a way to use some kinf of search transformer which could search for country names (in the articles) and also add a new attribute value (the country name it was assigned to). I have two readers, the spreadsheet and a shp file of all the countries. It would prove usefull to read all the different search options (all the countries) from the shp file. Any suggestions? thx in advance

11 years ago

pittopitto

asked in Authoring

Published Parameters for Joiners

Hi everyone, I have concatenated joiners on my workbench and I am trying to create new user published parameters because the paths are being changed depending on the date of update. The problem is: The published parameter of the first joiner is created successfully, I move to the second joiner and create the second published parameter. When I click 'OK' the newly published parameter overwrites the first one. What am I doing wrong? Thanks in advance Gianluca

11 years ago

farfarContributor

asked in Authoring

Concatenate list values

Hi all, Generalty i use ListConcatenator to concatenate ALL list items. I need to concatenate list items without the first item. Is there a specific transformer that can i use? Thanks an advance. FarFar

farfarContributor

Hi All, I look for lists comparaison. For example : i have 2 lists list1 that contains (1,2,3 values) and list2 that contains (2,3,4,5). The result is 2 lists ListOut1 and ListOut2 that contain the differences : ListOut1 will contains all list2 values that don't exist in list1 => ListOut1 values : 4,5 ListOut2 will contains all list1 values that don't exist in list2=> ListOut2 values : 1. I dont find tranfermer that can helps me. I look for python script but i need help. Thanks an advance. FarFar

geolocation in FME Workbench

Is there a way to geolocate a layer that is in a non-earth coordinate system? I can get three points to define the geolocation. I presume that this should be sufficient? Regards, Chris Mugdan

FME workbench on Windows Scheduler

Hi, I have a workbench that I want to run on windows task Scheduler. What windows scheduler did was just opens up the workbench but it actually didn'tt run. I have workbench that downloads the data and save in my local geodatabase? I wanted to schedule a task so that it downloads the data everymonth?

640

11 years ago

fmelizardContributor

asked in Authoring

GeoMedia/Oracle Format Attributes

I am using FME 2012 SP4 to exposed a number of GeoMedia Format attributes on our text features coming from an Oracle DB i.e. geomedia_text_string, When I run the WB the attribute name changes to oracle_element{0}.geomedia_text_string which looks like a list to me. I have tried to use list manipulators to get to the text string but a list is not exposed. Any thoughts on how to get to these format attributes so that I can export them? Cheers

11 years ago

Page 114 / 122

Badge winners

kenortey8has earned the badge Teacher (Grey)
edwardhas earned the badge Integrate Data with the FME Platform Training
kailinatsafehas earned the badge Enchanted by Attributes
gazmanhas earned the badge Welcome Back
miguelhacarhas earned the badge Spanish Speaker

Show all badges

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