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

jorge_vidinhaContributor

asked in Authoring

Expose Table name parameter - reader Postgis

How can one expose table name parameter at a Postgis reader so that workspace runner can make use of ?Thanks.Jorge

440

8 years ago

fmelizardContributor

asked in Authoring

How to write multiline attributes into KML description?

If I formulate an attribute value with new line character, it appears in Data inspector as I expected. But when I write it out to KML, and open in Google Earth, there is no new line. How can I write multiple lines of attributes in KML description balloon?

Difference between two versions of same Workspace using Workspace Reader

Has anyone done any work using the Workspace Reader to compare two versions of a Workspace to identify differences? Ideas, sugegstions, comments (Workspaces!) all welcome before I try myself.Thanks!

8 years ago

linhgg2

asked in Authoring

Merge and match list attributes

I have a XML that i want to take out 2 values, name and title. i have done it here;Now I have these attributes but now i dont know how i do to match layer title and layer name. I would just want 2 attributes one for name and one for titleI have worked on this for a while and Icant get any closer to the result i want.Attach the workspace.

Problem with Batch Deploy after FME_TEMP cleaned

A few days ago we cleaned our FME_TEMP env variable directory as we had ~80GB files sitting there. I am now unable to use the Batch Deploy option and get the following in the log;Starting translation...couldn't open "{E:/Local Processing/FME_Temp/FME_1480515564385_17256}": no such file or directory while executingopen $superBatchFileName "w" invoked from withinset superBatchFile [open $superBatchFileName "w"] (file "C:/Users/william.allen/AppData/Local/Temp/5/fme-batch-deploy-f14892.tcl" line 14)Purging temporary files does not make a difference - nor does creating a blank file/folder.Do I have to change the Temp directory? Any idea how to avoid this - and keep the Temp folder size down?

8 years ago

gisgeekContributor

asked in Authoring

Merging atttributes

I have a lake dataset which I have aggregated and dissolved which has almost given me the right results. However as you will see from the results I have Lake Okataina and Lake Okataina/Te Moana i kataina a Te Rangitakaroro. Lake Okataina is larger than Lake Okataina/Te Moana ... however once I aggregated and dissolved I get Lake Okataina. How do I merge the LakeName so that I keep the whole name and not just Lake Okataina. I've tried tweaking a few of the dissolver parameters but this doesn't seem to have given me the result I want.Cheers,Sarah

Feature Type Feature Class Name and associated writer attributes in FME Desktop 2016.1

Hi there,I'm using FME Desktop & Server 2016.1 with Esri ArcDesktop 10.3.1. The workbench is reading oracle spatial data and writing it into Esri File geodatabases.In the Shutdown Python Script, I would like to find all the objects in the workbench to determine which are Feature Types, get there Feature Class/Table name and associated writer's destination path & file name.Once I have this information, I can use Esri's arcpy module (I have already worked out how to import this) to create indexes, etc. on the feature classes.Thanks

8 years ago

notmynameParticipant

asked in Authoring

Batch Deploy Read Uniquely Named Excel Sheets

Hello,I have hundreds of excel books to read one sheet of (they each have only one sheet) then write the data to a database table. I thought this would be simple using batch deploy, I then realized the excel sheet names are different and in the basic way I set up my batch deploy it expects a specific excel sheet name. Is there any way for FME to simply read any excel sheet in an excel book at run time? All the excel sheets have the same column structure.To be clear:Excel book= A xlsx fileExcel Sheet= A tab of a excel file Thanks

View Log for sub workspace

I am trying to see where there might be a log of what occurred in a sub workspace called by workspaceRunner.I have FME server running workspace (A) and as part of that process workspace (B) is called.The only detail I can see is that workspace (B) was called successfully, however I would like to see the type of detail showing in the job log for workspace (A)The Log simply says90 INFORM 0.0 0.4 Today at 12:27:00 WorkspaceRunner_2: {C:/Program Files/FMEServer/Server/fme/fme} {//Workspace/datagovau - AFS_LIC_.fmw} 2>@1 91 INFORM 0.0 0.4 Today at 13:24:46 WorkspaceRunner_2: Successfully ran workspace \\\\Workspace\\datagovau - AFS_LIC_.fmw

FeatureReader doesn't output a schema object from a file geodatabase feature class

I've got a shape file and a GDB feature class derived from that. 2 featureReaders with the same settings pointing at the 2 datasets, the shape file reader outputs a schema feature the GDB reader does not.Anyone know what's going on here? FME Desktop 2016.0

How to prevent single quotes turning my parameter into a string when using a workspace runner?

I have run the below query successfully on a spatial database in a standalone workspace:st_intersects(st_setsrid(st_geomfromtext('$(poly)'), 27700), geom)The poly parameter brings in the relevant wkt.When I run this query with the paramater passed through a master workspace it treats '$poly' as a string rather than a parameter. If i remove the single quotes the wkt comes through as expected, however the single quotes are part of the spatial query so the sql fails.Has anyone got any advice on how to get around this problem?Many Thanks,

750

8 years ago

lifalin2016Contributor

asked in Authoring

Embedded custom transformer - attribute assignments

Hi,I've always been struggling to wrap my head around how embedded custom transformers actually stitch into the general workflow. So this might very well be a no-brainer.If I want a transformer to have two dataflow (two input clauses), one with points/node and another with lines, and want the custom transformer to take certain point/node "names" to transfer to the line features into pre-existing attributes on it, how is this achieved ?I have "exposed" the three attributes (with seems common across all inputs !?), but I'm unsure whether the assigned values within the custom transformer ever make it out of it.Please enlighten me of the proper how-to :-)CheersLars I.

When FME runs out of memory, will the shutdown script (Python/TCL) still be executed?

Had a hard time trying to let FME run out of memory, so I thought it would be faster to just ask around. My guess is no, right? Since it usually says "Warning: not all FMESessions that were created were destroyed before shutdown. This may cause instability" in the log...

140

8 years ago

fmelizardContributor

asked in Authoring

Does FME Server use VB6/ASP/Web-plugins?

Does FME Server use any of VB6/ASP/Web-plugins?

8 years ago

jneujens

asked in Authoring

Use internal FME attributes

Hi,I am transforming a AutoCAD .DWG file containing lines, polygons, points and texts to a spatialite database. The translation is relatively easy, but i would like to output some internal fme attributes on top of the autocad attributes. With internal attributes, i mean the typical 'fme_color', 'fme_basename' or 'fme_feature_type' attributes that are visible inside FME Workbench and Inspector, but disappear when writing to a spatialite sl3 file. I also tried using an attribute exposer and creating new attributes that get the value of each internal attribute. None of these worked out. Does anyone have a suggestion how I can still use these internal attributes?

100

8 years ago

arthyContributor

asked in Authoring

checking linkage with a database and updating a database

Hi all,I have a dgn file (let's say old_dgn) which is linked to an oracle database (let's say table_dgn).Because some centroids are missing, I created a new dgn file (let's say new_dgn) that contains all the existing features of the old file and also the new centroides.Now I would like to write a workspace that will:(1) detect the centroids without linkage with the oracle table table_dgn(2) create the linkage in case some centroids were found in step (1). This means update also the oracle table table_dgn.The oracle table table_dgn has a column mslink which corresponds to mslink1 of the file new_dgn.Any suggestions?

8 years ago

fmelizardContributor

asked in Authoring

How do I specify a specific installation or version of FME to use in my batch file?

How do I specify a specific installation or version of FME to use in my batch file? This Knowledge Center article explains the syntax and use-cases, but 'fme' always gives me a version of FME I don't want! https://knowledge.safe.com/articles/1384/fme-batch-processing-methods-1.html

8 years ago

ifitch

asked in Authoring

Find and paste coded value to an attribute

I have an address point with street name and street type fields likeName TypeMain streetPlesantavenueand so on. Also i have table with street coded values likeCodeNameType2345Main street4588PlesantavenueWhat i need to do is for each addreess point find name and type from second table and paste code value to the point attribute. What is the best way for this?

8 years ago

fmelizardContributor

asked in Authoring

Control order of processing/transformers in one workspace

Is there a way to control the processing order so that the first part of processing, which creates a backup file, completes before the second part of processing starts. I don't want the second part to start processing on the file before the backup of that file can be created.

Re-use python script in multiple workspaces

Hi,I am trying to re-use a python script (saved as .py file), so that i do not have to edit all my workspaces that contain this script in a private parameter.I tried to follow the steps in https://knowledge.safe.com/articles/976/how-can-i-modularize-my-python-code.htmlwhereby I included a couple of codes within the python startup script something like below:when I try referring the SetReader module in a private parameter, I get an error that says 'ImportError: No module named SetReader'Can I please get some help regarding re-using python scripts ?Thanks very muchimport sys sys.path.append(r'\\fmeserver\Functions') import SetReader

8 years ago

geodavid76

asked in Authoring

elasticsearch writer and missing geometry field

Hi,Im doing some test with elasticsearch and FME writer. I have a very simple workbench that reads (with directory reader) a folder with geojson files, read them with feature reader and dinamically writes to elasticsearch using the elasticsearch writer. The wb works pretty much ok on looping and sending all the jsons to elastic (on different types inside the same index), however it seems that the geometry field is lost when I write it to ES (although present in the geojson"features" : [ { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ -0.8275947, 38.05902 ] }, "properties" : { "uwwCode" : "ES10030240001000E", "uwwName" : "BENEJUZAR", "uwwNUTS" : "ES521", "fme_basename" : "EDAR_Q2011", "SHAPE_GEOMETRY"

How to bring initial Reader back into LOOP?

Basically, I am adding a 50m buffer to a facility point (first reader) then using a spatial filter to see where population points (second reader) fall within that buffer With those population points I caluclate the sum for overall population in the buffer and then run through a tester to see if it is greater than a value. If it fails it loops back to Expression Evaluator and adds 50m to the buffer. However it is looping the future population points originally selected within the buffer and creating new buffers for ALL OF THEM. NOT what I want.I created a Custom Transformer from Expression Evaluator through to Tester, then added a LOOP from the tester fail back to Expression Evaluator. The is the ONLY point I want to build a buffer around. It does not pass through after the first LOOP. What I would like to do is when the test fails, add another 50m to the buffer each time to that facility until the test passes. This is difficult when it only goes through the analysis once.Curren

110

8 years ago

asked in Authoring

How to extract metadata information from geodatabse using FME

880

8 years ago

harishContributor

asked in Authoring

Transformer for adding unique string attributes

I have to add unique attributes for fields like Tender Number, Project Number etc to all the feature in the database. The whole database having more than 100 features. Which transformer can help me the best. Now I am using AttributeManager, which for different sessions and different Tender set database i have to change the entire attributes in the AttributeManager.

8 years ago

bazooka

asked in Authoring

Add attribute value as prefix

Hi,I am trying add attribute value as prefix to joined attributes, but I have not succeeded. @bo had quite similar problem Add parameter as prefix... I have created attributes at main.Then I expose those attributes at custom transformerBut I cant get prefix when I add JoinerGoal is to have 1_REGISTRATIONDATE, 1_FORMERPARCELLOCUNITID and 2_REGISTRATIONDATE, 2_FORMERPARCELLOCUNITID on the second round and so on.

940

8 years ago

Page 91 / 122

Badge winners

scarterhas earned the badge Teacher (Silver)
reyhas earned the badge Welcome Back
alc33has earned the badge Welcome Back
rishavsharmahas earned the badge FME Form Basic Training
emiliodepalmahas earned the badge Student (Grey)

Show all badges

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