Creating and organizing workspaces. How to use Workbench.
Recently active
Hi, I cant find a way to expose format attributes on multiple inputfeatures. I got a load of inputfeatures for wich i wish to expose ie 'fme_feature_type' There is no provision for this??? 1 by 1 is like..a lot of tedious clicking. It would be nice if there would be. (i am still on 2012 version btw)
I have 2 ESRI Shape polygon datasets, which should be combined and exchange attributes. The first shows boundaries of some hundred property units, the second shows some thousand mapped features inside. The task is to summarize the area values of all mapped features included in each property unit and add the result to a new property unit shapefile. INSIDEPOINT_REPLACER for the mapped features and POINT_ON_AREA_OVERLAYER / FEATURE_MERGER followed by AGGREGATOR works well one-to-one basis as long as I have no overlapping property units. Now I need a good idea to do the same with overlapping property units, mean to collect the mapped features more than one time. Thanks for any ideas / help.
Hi, I have a doubt about FME. I have a reader that reads a .mdb Geomedia , and a Writer to put the .mdb data into an Oracle Database. The problem is: I have to create in the writer manually , all the attributes that I want to see in the oracle. I would like to know if there is a way to make this dynamicly. Without going into the writer and typing all the information. I want the same attributes from the reader in the writer without typing the information. Is there some way?
Hello, I would like to have a parameter that is set from data that is sent to it from a webpage. When you create a parameter the prompt asks for a prompt. I am not sure what to set here. I need to have the pararmenter look at the data sent from the web page and set that so a creator can use it to set parameters. I am fairly new to FME also so any help would be great thanks.
FMEpedia article - "Extracting a schema subset for dynamic schemas" was very helpful when I challenged this question: Dynamic schema partial merge from 2 data sources However, the article doesn't seem to be enough in the current FME, I hope the article will be updated. In the meantime, I'll share two things I got from my experiences with you. 1. Python script The script in the article doesn't work in FME 2013 SP3, because it uses old "pyfme" module. I tested the method described in the article with this script: ----- # Example for "Extracting a schema subset for dynamic schemas" import fmeobjects def keep_defs(feature): att_name_list = feature.getAttribute('attribute{}.name') att_ntype_list = feature.getAttribute('attribute{}.native_data_type') att_ftype_list = feature.getAttribute('attribute{}.fme_data_type') to_keep_values = feature.getAttribute('
Sorry - this might be simplistic, but I'm trying to run fme from a command line providing a file with a workbench and a parameter specifying the search envelope to use when reading features. My command file named cnp.cmd and contains this: C:\\\\Projects\\\\FMEWorkbenchOutput\\\\test.fmw \\\\ --GEODATABASE_FILE_SEARCH_ENVELOPE 102991123 -5143701 103346900 -51186100 when I execute fme with: fme COMMAND_LINE cmp.cmd it executes the workbench (which exports data from an ArcGIS file geodatabase to an AutoCAD drawing) but it does not recognize the search envelope. Any suggestions would be greatly appreciated. Thanks, Ed
Hi guys - I am still having an issue with my Dynamic Schema workbench working correctly with polygons. I have finally worked out it is not the workbench itself that has the problem, but my custom-built transformer. The transformer is a reprojection transformer and when dealing with polygons it actually GeometryCoercer's the polygons into lines to do the projection, then converts them back to polygons. I believe that this is why when I run my Dynamic Schema workbench on a shapefile polygon, it comes up with the "Features with no schema defined" error. My question is - is there a way to get the Dynamic Schema function to work, without altering the transformer?? How do I get FME to remember the schema of the polygons before they went through the transformer?? Thankyou
I an reading a feature table having 3 string columns say a,b,c and column X from another feature. Columns a,b,c holds string value(nullable). X has value like "Concat(Concat(a,b),c)". I need to derive final string without running sqlexecutor. Please let me know how to solve this. Thanks. Subrat
Hi Guys I currently have a Dynamic Schema workbench with a custom-built reprojection transformer along with the following transformers that are allowing me to rename the output files and place them in a new relative folder structure: FilenamePartExtractor, StringReplacer and StringConcatenator. The workbench works correctly on my first lot of files which are quite small in size, but when it comes up against files that are 100MB to 700MB in size, it says "ResourceManager: Optimizing Memory Usage" and stalls, and eventually crashes with a "Fatal Error" and other messages relating to memory. I have tried writing to a different network drive from the input files, and have also purged my temporary files, but neither has helped. My custom-built reprojection transformer is very complex and I am guessing that this may be causing the memory problem on the large files, but am wondering if using Dynamic Schema also affects memory. If so, does anyone have any a
Hi I have a workspace with Dynamic Schemas which I ran on 5 datasets all which have the same schema. However, when I tried to run the same workspace on a new set of data which have different schema, it would not work because the Feature Type was still set to one of the previous files. I cannot work out how to change the Feature Type, or disable it so that it allows for all feature types - otherwise this is defeating the purpose of using Dynamic Schema! Thanks
Hi I am using Dynamic Schema to translate a large number of shapefiles from one coordinate system to another, but keeping the same schema. I am able to do this successfully however I cannot work out how to suffix each translated shapefile so as to differentiate the translated files from the non-translated files. I have tried setting the Fanout Parameter to Yes, but it only suffixes the folder with the translated files, not the actual shapefiles themselves. Does anyone know how to do this? Thankyou
I'm using an xml reader to read multiple xml files into fme, each xml file is translated as one feature with a number of attributes. In some of these files there are multiple instances of the same element and these appear to be formulated as a list when inspecting (e.g. displayed as date{0} and date{1}. However if I try and do anything with this list, e.g. explode/concatenate, I just get a no list attributes available message. I suspect this is something to do with the fact that the attribute is not always a list element as if i read just one file that I know to have multiple instances of the same element I can manipulate lists no problem but I've got no idea how to resolve this.
When I add an ESRI SDE reader, I have to provide a bunch of connection parameters and tell it which features I want on my canvas. Later, when I right click on a reader feature on my canvas and click "Update..." to pick up recent schema changes, I have to re-enter all the connection parameters and re-pick the feature to update. How come FME does not pick up the connection parameters from the reader (I can see them listed in the Navigator pane) and assume that the feature I want to update is the one I right-clicked on? Am I missing something basic? The same thing happens if I try to use the "Update Feature Types" from the reader menu. I have to re-populate all my connection parameters. I am using FME 2013 SP1. Thanks for any light you can shed on this! Stuart
Hi, I want to know FME standard terminologies about list attribute. For example, there are some types of list attribute or its expression, how should I call the type name when I need to distinguish them? _list{} <-- called "simple list", "non-structured list"? _list{}.name <-- "structured list"? _list{}.sub{} <-- "multidimentional list", "nested list"? etc. If you know related documentations, please let me know URL. Thanks in advance. Takashi
Oracle/FME family: I have a gazillion tables with SDO_GEOMETRY fields in a single Oracle instance. Most of those tables have a complex join to other tables to get interesting information to control the display. I have a handful of workspaces to extract this data to FFS, mainly focused on the specific geometry type, that is: Point, Labels, Lines, Polygon. Having just read about hadoop, map/reduce, and all that functional architecture, I got it in my head that I needed to map each geometry table to its function i.e. geometry workspace and let FME Server go wild on them. What I decided to do is launch a workspace for each table and send in the join criteria as parameters for use in an SQLCreator. So I end up submitting 250+ jobs, each running 1 of 6 workspaces to process a single table. All processed by 8 engines. Well, you can imagine what Oracle does in response to this. It basically locks up. My question is, what is the right way to scale? I haven't tried a sing
How can I set a list attribute in Python? I can access the list by something like: for i in range(0, numberFeatures): subscript = "lstGrouped(%s).STRATA_UNIT_AREA" % i oneStrataUnitArea = int(feature.getAttribute(subscript)) ...but when I try to set the attribute, FME makes a new list: for i in range(0, numberFeatures): feature.setAttribute("lstGrouped(" + str(i) + ").STRATA_UNIT_AREA",str(oneStrataUnitArea)) I can make a new list and expose it on the canvas, but FME does not treat it as a real list. That is, I can't explode a list that I made in Python. Thanks
Hi, does anybody know if it is possible to erase the contents of a Feature class without deleting the feature all together? I'm trying to eleminate having to open GeoMedia and physically select all the features and click delete, this is very combersome. I want to load the feature in FME and clear the contents so I can re-load/append the new up-to-date version.
Hello, I would like to know if there is a way to give a published parameter a default value from an attribute? Thanks, Gabriel
I'm relatively new to FME and love it so far but need a little guidance. I'm developing workspaces using a custom reader that reads an object oriented file. I never know what features I'm going to receive in the file and want to add some error handling in the begining of the process by testing to see if any features exist - if not, terminate. I've tried adding a counter and a terminator to the reader but no features exist so I never get a number from the counter. The workbench continues running since I have other readers (that do have features). How do I terminate the workspace if a certain reader doesn't contain any features?
Hi all I have a workspace where I'm using information from one set of features (municipalities) to define other datasets to read (f.i. road fences). Each feature has an attribute with the name of the dataset that should be read for this specific feature. For instance: For the feature with municipality number 501, I want to read corresponding features from the dataset K:\\.....\\0501\\...\\VSI20501.GDD, and for the feature with municipality number 522, I want to read corresponding features from the dataset K:\\.....\\0522\\...\\VSI20522.GDD. I have been using a sub workspace and WorkspaceRunner to solve this earlier, sending the path for each dataset as a parameter for the sub workspace. But now I would like to have it all in one workspace, and figured the FeatureReader would be a good sollution. However, it is not possible to set the dataset to read in the FeatureReader from an incoming (INITIATOR) attribute. Could it be possible to set the dataset using a Python script or some
I knew how to do this, now I can't find it. How to publish features types to read, so that they'll be availble in a public fme server workbench?
Hi, I create a fmw that : 1. create a directoy with the same name of zip file, 2. move the zip file to this directory. this fmw works fine withe if the name of file is note a numeric (like : toto.shp.zip, => OK but with another file that has only numeric name : 1.shp.zip => KO). With FME Desktop it works fine for both cases. If i run it with FME SERVER, there is an error : 54 WARN 0.2 1.3 2013-08-20 10:49:50 Python Exception : [Errno 2] No such file or directory: '\\\\\\\\1.shp.zip' 55 ERROR 0 1.3 2013-08-20 10:49:50 Error encountered while calling function `processFeature' No more details for this error. Any help? Thanks an advance. Farfar
Hi, I have a model that contains a files that has information about multiple projects. I would like to pass a parameter to allow the user to select on or multiple projects from a list. Any thoughts? guidance? advice? Thank you
I have a public web interface that is inteneded to allow users to extract shapefile data from Oracle SDE via GP key in. I have published parameters and created the interface but I dont know what transformers to use in the workbench to allow the GP clipping. Something about attribute filer I suspect. http://fmeserver.ncd.noaa.gov/encdirect_extract_approach.html
Hi In FME workbench, How can I export a list of the writer feature type user attributes' name, type and width , in other words, I need to have a csv file with the schema of the writer feature type. Thanks, Sami