• EN

Authoring

Creating and organizing workspaces. How to use Workbench.

  • 2,852 Posts
  • 11,923 Replies

2852 Posts

R
ramoninovacao
asked in Authoring

FME 2013 SP2

Hi dears,  when will be released the final version of FME 2013 SP?  Thanks in advance.  Kind Reagards.  Ramon Rocha.

3
fmelizard
Contributor
10 years ago
J
jryan
asked in Authoring

Dynamic Paramater Choices at runtime

Has anyone been able to link (not import) via SQL a choice/alias list to a published parameter to dynamically update the list based on the linked table at runtime.  I.e. the goal is not have to continually import / update choices each time the workbench is executed.   

3
takashi
Contributor
11 years ago
P
paul21
asked in Authoring

Manual for FME Workbench 2011

My company has just upgraded to FME Workbench 2011 from 2007. Can someone tell me where to find the manual for FME Workbench 2011?

3
A
11 years ago
J
jimp
asked in Authoring

Parsing attribute values

I have a workspace that compares a PATH HIERARCHY data set attribute of video file names to a GeoMedia Feature data set attribute of sewer segment names and does a feature merger on the two datasets when there is a match.  Sewers are usually videod from upstream to downstream and the video files are named according to the direction in which the camera was travelling.  My workspace gets quite a few matches BUT...there are occasions where the videos are named from downstream to upstream which causes my feature merger to send that video name to the incomplete branch.  I would like to parse the video name attribute and use the result to create a new attribute that is the reverse.  So 'MH07-121 to MH07-122' would become 'MH07-122 to MH07-121' in the new attribute.   Could someone please suggest an approach that would accomplish this for me?   Thanks.

3
takashi
Contributor
11 years ago
J
justinv
asked in Authoring

Sort only part of an attribute in a list

Hello everyone,  Is there a way to sort a list using only a part of the attributes in a list--specifically a number?  What I need to do is re-order attributes according to an ID number from lowest to highest. Here is what the attributes look like:  34N27W_100700      34N28W_700700        35N27W_100100     35N28W_700100  These need to be placed in fields according to the order of the last six numbers only.  35N27W_100100      34N27W_100700         35N28W_700100    34N28W_700700  If I create a list out of these attributes, I can only sort alphabetically, which produces the wrong order.   I have tried separating the numbers into a list that I can sort but then the rest of the ID gets lost and I'm having trouble matching it up again. Does anyone have any ideas about how I can make this happen?  Thanks! 

2
J
11 years ago
owen
owen
asked in Authoring

data download with excel template

Hello,  I have a workspace that updates an existing excel template.  When publishing it to a data download service, it writes the excel file, but doesnt use the file specified in the writer.  I know this is because the data download writes to a temp location, not the writer output folder - is there anyway to force it to use a template?  Owen

2
owen
11 years ago
J
jryan
asked in Authoring

Executing a secondary workbench file from shutdown script

i am looking to trigger a second workbench file after completing the writing of a primary one.   Does anyone have examples for calling an fmw file from a shutdown script?    This is a workaround to be able to trigger a SQL script upon completion of writing to a Postgres/PostGIS table.     

3
J
11 years ago
J
joan_in_danvill
asked in Authoring

merging areas by a common attribute

I have several areas that have common boundaries and a common attribute.  I would like to dissolve the lines that touch to make one larger area.  I tried the amalgamator, but that didn't work, I have also tried the aggregator, but that isn't working either.  The data is an access workspace for a geomedia layer.  Any suggestions would be helpful.  Thank you.

4
takashi
Contributor
11 years ago
nic_ran
Contributor
nic_ranContributor
asked in Authoring

Importing published parameter configuration value order

Hi,  I'm importing configuration values for a "Choice or Text" published parameter. The imported values are coming from a database and the list is fairly long.    I'd like the imported values to be sorted alphabetically but can't figure out a way to do it automatically. I tried adding an "order by" statement to the where clause, e.g. 1=1 order by column_name but it had no effect.    I know that I could manually edit the .fmw file with a text editor but my list of imported values is long and will likely need to be updated on a fairly regular basis.    Anyone have any thoughts on this?    thanks,  Nic

11
nic_ran
Contributor
11 years ago
J
joaarmst
asked in Authoring

Exporting ArcGIS Metadata using a List

Hi Everyone,  I just had a question regarding exporting ArcGIS Metadata using a List. We recently found this wonderful article on how to pass a list of layers to a FME Reader (http://fmepedia.safe.com/articles/How_To/Pass-a-List-of-Tables-or-Layers-to-an-FME-Reader-using-Python-Scripted-Parameters) and it works amazing, the trouble is that the metadata is not brought along with it.  The location where you normally would set metadata to come accross is where this python script needs to go.  Any help would be greatly appreciated  Thanks!   

2
mark2atsafe
Safer
11 years ago
D
dewright_ca
asked in Authoring

FME Write to Excel with Custom Template

I am creating a extract process and I am needing to populate a existing template from Excel with data. The main issue is the template has 4 header rows, so I need to start writing data on Row 5.  Has anyone had sucess in working with custom formats for Excel like this?

8
fmelizard
Contributor
11 years ago
M
matthewbrucker
asked in Authoring

Variable Reader/dynamic Schema

Hey FME'rs  I'm struggling a little bit with using trying to build in a variable reader schema. I've built the workbench where it prompts the user for the source shape file. I received a sample of the schema but there is a good chance of a different shapefile schema being input.   I have tried working with the knowledge base but I'm coming up short. The output is a known schema I've created after the analysis.   Does anyone have any ideas?

4
fmelizard
Contributor
11 years ago
N
nik2711
asked in Authoring

Need to set user parameter at shutdown for next run

Hi,  I want to call same workbench again based on some feature at shutdown. I achieved this through a python shutdown script but the problem is i also want to set the user parameter for the next run. I tried but each time the workbench runs again, i takes the default value of parameter. Is there any way to set the parameter at shutdown so that next time when workbench runs it picks the value i set ? Any help would be appreciated. Thanks in advance. 

6
takashi
Contributor
11 years ago
A
andypc
asked in Authoring

Parameter in reader URL for an XML feed

The subject sort of says it all. I'm trying to setup a workbench process anyone in our team can run, or that I can work out how to automate.  Basically I'm retreiving data from an XML feed that takes 2 querystring variables, one has to be the current date in the format (dd/mm/YY), the other I can make static as the number of days history of events to be retrieved.  I would be grateful if anyone can advise hoe I can do this in Workbench, or if there's a method for doing it in Python (bearing in mind I'm a newbie @ Python).   Thanks.

6
fmelizard
Contributor
11 years ago
francis_m
Contributor
francis_mContributor
asked in Authoring

FME Quick Translator - prompt

Hi FME user,  I created a workbench FMW (script) in FME Desktop. The purpose of this script is to translate Oracle data to KMZ.  The tool is then delivered to my client in the FME format (FME Desktop, Save the file as: FME instead of fmw). This file is then used with FME Quick Translator.  My client asked if it was possible to change the name of the prompt window FME Quick Translator.  The pop-up window with the user settings is called fmequicktranslator and I wonder if it is possible to change the name to something else?  an idea?  

3
takashi
Contributor
11 years ago
philippeb
philippeb
asked in Authoring

Save AttributeCreator parameter

I don't think that it is possible right now but with the new AttributeCreator adding the TestFilter and StringConcatenator, It would be cool that we can save our conditional values for an attribute or all of them. I have made a list of filters and concatenate strings into it, but if I would like to reuse it into an other workbench or just to be sure that all the work I have done into this transformer is saved (I have made an invalid test into the AC and all my work was gone after running my workbench! Hopefully i had the undo button!), I would like to have a file that I could select to load all my parameters rapidly. That was my suggestion of the day. Thank you.

2
philippeb
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Authoring

Should Attributes in Parameters be pointers?

I want to ask the community about "expected behaviour" of something.    I use AttributeCreator to create Failed_Reason - it contains a value "1" (number one).    So at this point @Value(Failed_Reason) = 1.    This goes into a customTransformer. The customTransformer has a PublicParameter which points to Failed_Reason as an attribute using the "Attribute" type.    Here's where things get confusing.    Inside the customTransformer, if I use the ParameterFetcher, to return $(Parameter) I get "Failed_Reason" as a text string! Not 1.    I get the same result if I pull it directly into a StringConcatenator for instance.  So $(Parameter) = "Failed_Reason" (utf-8)    On the other hand, if I put the parameter into a 2DPointReplacer, it works.    But it gets worse!  If I place an empty "attributeKeeper" before the 2DPointReplacer (so all attributes are now removed), it stops working. Why? Well, because the attributeKeeper is remov

5
takashi
Contributor
11 years ago
fmelizard
Contributor
fmelizardContributor
asked in Authoring

Output grouping

I have three writers (CSV, Shape, MITAB) that I want to output to the same directory.  However, I want that directory to be specified within the workspace at runtime based on the fme_basename of the input.  So for example: Inputs:   random_dataset_1.csv   random_dataset_2.xls  Outputs:   c:\\outputs\\random_dataset_1\\bad_data.shp   c:\\outputs\\random_dataset_1\\bad_data.TAB   c:\\outputs\\random_dataset_1\\bad_data.csv    c:\\outputs\\random_dataset_2\\bad_data.shp   c:\\outputs\\random_dataset_2\\bad_data.TAB   c:\\outputs\\random_dataset_2\\bad_data.csv  How can I do this? There isn't a "parameterWriter". I think I saw someone about using special fme_ attributes, but I can't recall what nor find them. Thanks.

5
fmelizard
Contributor
11 years ago
V
vdey
asked in Authoring

Batch Deploy in FME 2013

Hi,  I am new to FME. I am trying to do a batch processing to convert shapefiles to JSOn files. All my shape files are in current directory, e.g., C:\\Users\\username\\Documents\\Projects I am trying to convert each of them into a separate json file in a folder C:\\Users\\username\\Documents\\Projects\\JSON I used dataset fanout after selecting all the shapefiles as input but it is returning only json file corresponding to the first shapefile. I also used file->batch deploy by selecting the source folder with *.shp as wild card  and destination as above and deselected retain basename. But it is also giving only the output from first file.  Please help me out where I am wrong or if you need information.  Thanks, Vivek

3
V
11 years ago
S
stevenc
asked in Authoring

Legacy Data Processing

Hello,  I am new to FME and I have been trying to run a process that was created by someone else. Most of the process works but when the the last process runs I get this error "An error occurred while attempting to stop an edit session. The error number from ArcObjects is: '-2147024809'. The error message from ArcObjects is: {ArcGIS product not specified. You must first bind to an ArcGIS version prior to using any ArcGIS components.} Some error has occurred during shutdown of the writer, see previous error Some error has occurred during shutdown of the writer, see previous error A fatal error has occurred."  I have tried to look this error up on google and several other sources but my inexperience with FME and it's processes have me stummped at where to look. I am very familiar with ESRI and geoprocessing and looking at our databases things seem correct. I am processing to a File Geodatabase off of a versioned SDE GDB. Is there anyone who could point me in t

3
mark2atsafe
Safer
11 years ago
M
magdalena_n
asked in Authoring

hidden attributes

Hi,  if I to a reader add a Schemamapper where I add a couple of attributes, and after the Schemamapper I add another transformer,  why aren't the attributes shown after my Schemamapping? Is there any way to visualize them beneath the next transformer's symbol?  When adding a visualizer to the Schemamapper it's possible to see the attributes. So they exists but don't want to  be seen in the attribute list in the desktop under the next transformer. Weird.

2
davideagle
Contributor
11 years ago
reservoirdog
Contributor
reservoirdogContributor
asked in Authoring

deployed Batch runs very slow as scheduled task

Hello community!    I have 7 Batches (created via Batch deploy), that read spatial data from an oracle 10 database into SQLite. The biggest user takes, when batch is started manually, about 18 minutes. When this batch is started using windows scheduler, it takes up to 3 hours! Same for all the others.   I'm using FME 2013 SP1 Oracle Edition on Windows Server 2012.  neither the oracle server nor the fme server is under heavy load. (1-5% cpu).  scheduled task are started as same user which starts manually the batches.  (admin, highest privileges). Is there an option to tell each task its priority?  is there a problem when batchfiles and tclfiles are located on desktop?  (workspace are located in user\\documents\\my fme workspaces)    would be thankful for any advice.  best regards, chris.

6
reservoirdog
Contributor
11 years ago
jhawks
Contributor
jhawksContributor
asked in Authoring

FME Server 2013 Web form question

Why is the "Show Developer information" code/form so different (and worse) than the form on the configure page. The configure page has check boxes for layers and a drop down menu for formats, but the show developer code has none of that. Can we get the code for configure form (which does't show up in view source).

1
mark2atsafe
Safer
11 years ago
H
hrinne
asked in Authoring

Error in child process '0', exited with code '1'

Hi! Im processeing a massive amount of data and the script always crashes at the same place:  2013-04-22 21:06:03|12759.7|  4.8|INFORM|0>   PolygonDissolveFactory: Processing 1000 polygon(s) in tile 2566 of 3531 in round 1 Error in child process '0', exited with code '1'  It occurs when dissolving with parallel processing.  Any idea what it might be? crappy geometries or something related to the parallel processes? /Henrik

4
mark2atsafe
Safer
11 years ago
J
jryan
asked in Authoring

Custom Transformer Parameter not being set

I am using FME 2011 and having a problem passing through a calculated expression to a published parameter in a custom transformer.   Here is what i am doing (which is not working).  in my main workspace i have 2 published parameters that are used to compute a new value (i.e. param1*param2).    I use the parameter fetcher to grab the 2 parameters, and then the expression builder to compute the new attribute.    I then set this to a published parameter in a customer tranformer.  In this custom transformer, this parameter is linked directly to one of the parameters in the Generalizer tranformer.  When i run i get an immediate crash saying that the Generalizer cannot covert a null string.   When i look at in the inspector, i see my new computed value set to @value(newexpressionattribute) when it shoudl have an integer that was computed (i.e. param1*param2).  I am sure it is something simple.  Any help would be appreciated.

1
takashi
Contributor
11 years ago

Badge winners

  • English Speaker
    sam.delorehas earned the badge English Speaker
  • Teacher (Grey)
    sam.delorehas earned the badge Teacher (Grey)
  • Webinar Watcher (Grey)
    d.torreshas earned the badge Webinar Watcher (Grey)
  • English Speaker
    d.torreshas earned the badge English Speaker
  • Teacher (Grey)
    kyp4810has earned the badge Teacher (Grey)
Show all badges
28,867
Posts
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.