Authoring

Hello, I am passing comma separated list of table names to workbench. It's working fine. Just want to make sure is there any limit on number of characters in parameter. Currently I am passing about 5 table names as a parameter(about 40 characters). So just want to make sure if I need to pass say 100 table names will it support those many characters. Also I am publishing this workbench to FME server.  Cheers

Hi,  I cant achieve to to parse correctly json elements and attributes correctly. The json received is like this:    {   "elements": [ {   "type": "way",   "id": 98815885,   "nodes": [     3325506694,     3325506698,     3325506701,     3325506705,   ], }, {   "type": "way",   "id": 98815895,   "nodes": [     1142949510,     1142941660,     1142983536,   ] } ] }  I am using the JSONFlattener, then the AttributesExposer (with elements{}, elements{},nodes{}, elements{}.id and elements{}.type) and finally the listExploder on elements{}.  The number of parsed feature is correct but there is no data inside the nodes attributes of each features. It's like if elements{}.nodes was empty for each feature.

I have multiple FCs in multiple FGDBs which I need to run through NeighbourFinder to generate distance/proximity info and then write into a single Excel writer feature type. These FCs have certain attributes I want to carry over into the writer but they are all named slightly differently. I would like some suggestions on the best way to carry this out please so it is easy to swap different combinations of Attribute in and out.

Hi,  I have 2 shapefiles with two columns, one is an ID, the other is a description. I need to merge these two datasets into one shapefile whereby if a feature has the same ID but a different description these can get pulled out so I can change them. Sounds simple but for some reason I am really struggling.  Any advice would be very much appreciated,  Thanks!

I would like to achieve the following:  Create a workspace that can be used to read a large number of tables, create geometries with the vertexcreator and write them to a database after changing attribute names based on regular expressions. Attributes differ from table to table and should be preserved.  I can probably achieve this by writing the schema to a feel and rereading that using the workspace runner. However, I feel like I am missing something really obvious. Isn't there a way to use a dynamic writer and derive the schema from a transformer rather than a reader?  Jakob 

With FME moving toward the ability to continuously run on FME Server and FME Cloud, I am wondering if there is a way to incorporate python libraries (ie NLTK, GeoPY, etc) for real-time web mapping.  For example, I would like the ability to strip the body text of an XML feed and send it to the NLTK library for semantic learning and strip it of geo location data. From there. I would send it to the GeoPy library for geocoding.   I am a bit out of my element here and I know that with the python caller I can incorporate simply python scripts, but I would like the ability to call entire libraries from GitHub.  Has anyone had any luck with or experience in this regard?

Hi!  I have a list attribute such this one:  ['a', 'b', 'c', 'a', 'b']  I would like to have the number of different values present in that list.  In python I would do:  list=['a', 'b', 'c', 'a', 'b'] len(set(list)) >>> 3 Is it possible to get that count with some fme transformer? 

Hi,  Is there a way to set an Oracle Table as a Published Parameter?  When I try, the only thing I can seem to set is the hostname, not the actual table name..  Thanks,

Hi,  I want to create a published parameter that prompts on run-time, the user to open multiple files.  I have tried to set the Type to "Filename (Existing)" and the configuration as in the image below.  But this only allows the user to select one file at a time, rather than multiple files.  Is there a way to create the parameter so the "Advanced Browser" option can be enabled?  Thanks,  

Hello,   i have a many 1000s of point features with some time series data. Each point has a CODE attribute column for 2000 to 2010 inclusive (CODE01, CODE 02, CODE03 .... CODE10). These code attributes can be one of 10 entries (1,2,4,8,16,32,64,128, 256 or empty).  I need to look over the attributes in year order for a given feature and ascertain how many times the code value has changed in those 11 given years.   EG;   so you can see Feature 1 would have a new attribute recording 0 changes, feature 2 would have 2 changes (to 64 and back to 32), feature 3 would have 7 changes and feature 4 would have 5 changes (missing does count as a change).  I thought perhaps i should transpose the data? have each feature exploded into 11 features, one for each year, and then use the Multiple Feature Attribute Support (u

Hi,  It seems impossible to have the same name for different writer feature type even if they are not connected to the same writer and not written into the same directory. That seems impossible if the writer are of the same type ex: MapInfo TAB.  Does it means that I have to create a path attribute and use it as a fanout inside a unique writer? Any other solution then this one?  Thank you!

Dear FME community,  with the AttributeFilter I can successfully route features to different output ports, depending on the value of an attribute. Is there a way to add output ports for the format attribute fme_basename as well? I have some Excel files read from a directory, but if I activate the sign on "Show format attributes", it doesn't show any format attributes. Is there a trick on how to add the filename of the Excel files as an transformer port?  Kind regards Thomas   

I would like to know if it is possible use conditional value for the requestor and supplier in a FeatureMerger in order to achieve something like this:  IF Requestor's Attribute_A = 'some_value'     JOIN Requestor's Attribute_A WITH Supplier's Attribute_A ELSE     JOIN Requestor's Attribute_B WITH Supplier'S Attribute_B  I have made many tryes, but it seems we cannot change the Supplier join attribute in function of the Requestor's attribute value.

Morning all, I'm trying to translate data for web mapping, but the amount of reading means that this is taking a long time to do.  I was wondering if there is a way to set up a work bench so it itterates through a directory reading and then writting a gz file before moving on to the next one? 

Hi, I have a csv containing >250,000 features and around 50 attributes, which I want to sum based on a common property (e.g. a suffix/preffix in the atribute name). I've done this before on smaller datasets, by using AttributeExploder to transpose the attributes; adding the common feature I want to base the sum on using AttributeValueMapper; aggregating them  and pivoting the output. However, I think with this many attributes it will be quite memory hungry, is there an alternative approach I could take - possibly using SchemaMapper or something? Thanks, Ed

I would like to run the same workspace (like loop perhaps?) many times depending on the values (numbers) in the list or depending on the value comprised in each file if easier. I.e. one by one value as input to workspace and data for this values as output. This workspace will be published to the Fme Server and used by users having no experience of FME. Currently this idea is realized with Python, but I will be happier to avoid Python and have full focus to FME only. Any suggestions?

Hi all. I am trying to read a polyline feature using the FeatureReader. Since there are a lot of features I try to limit the features to be read by the third tab "Spatial Interaction" in FeatureReader configuration but somehow I do not find what I am looking for: Setting the option to "Select only features that intersect with the INITIATOR feature's bounding box" I only get the features that intersect the initiator missing the ones that are within the initiators boundingbox. Setting the third option with the given interactions I somehow miss the option to combine the interactions - I can only choose one. In my case I would like to combine Intersects and Contains for example. My workaround at the moment is to load all features, clip them and test the "outside" features for _clipped=yes. Is there a better way? Thank you in advance!

Hi Everyone,   I'm trying to translate an table in one Oracle database to another Oracle database. From production to development for this case. The problem is that FME will not write a RAW Oracle datatype.   This appears to be intended functionality since the message I get from the FME log is "Oracle Reader: Skipping column '<column_name>' of Oracle Spatial layer '<schema.table>', which is reporting a data type of 'RAW' "  Can anyone give me some insight into wether this is intended functionality or if it is buggy?

I am using the free FDO provider in AutoCAD Civil 3D and connecting to a XML document (sample listed below) but when the XML is read in and flattened the OS_TOPO_TOID element is converted to a number rather than remaining a string; how can I get the XML reader to keep the OS_TOPO_TOID as a string?   <Row>   <OS_TOPO_TOID>0001000012320820</OS_TOPO_TOID>   <OS_TOPO_VERSION>4</OS_TOPO_VERSION>   <BHA_ProcessDate>2014-02-12</BHA_ProcessDate>   <TileRef>SX99SW</TileRef>   <AbsHMin>69.4</AbsHMin>   <AbsH2>73.7</AbsH2>   <AbsHMax>73.9</AbsHMax>   <RelH2>4.3</RelH2>   <RelHMax>4.5</RelHMax>   <BHA_Conf>99</BHA_Conf>  </Row>

Hello!  I have what I assume is a basic question that I have not been able to find an answer to in the knowlegdebase. When I select a number of files in a reader and use "Single Merged Feature Type", which attributes are shown in the "User attributes" pane? The files I have selected have some common attributes and some unique, but only a small number of them seems to be shown here. How does FME decide which attributes are shown here, and does the small list reflect which attributes are output? My limited experience with FME suggests that all attributes are also present in the output file, but I would rather be completely certain. Thanks for any answer!

Is it possible to use an main.fme workspace in WorkspaceRunner Transformer ?  Thanks to explanations of Takashi Memorandum [1] I have an FME workspace that calls another using this transformer. [1] http://fme-memorandum-takashi.blogspot.com.es/2013/09/workspacerunner-examples.html  So, this works perfect:    But, If I use main.fme instead of main.fmw the process fails. Thanks, A.   

I need to run a parallel flow to import 8 million points in a database versioned .  I have a flow Import_Points.fmw with two parameters (source and version). It is possible execute simultaneous .bat (point_1.bat, point_2.bat,...) to the flow Import_Points.fmw?  See image please.

Hi,  I have a directory containing a number of files, but I only want to read in specific files into the workbench.  I concatenated a list of the filenames into a single attribute with each filename separated by a colon (eg: filename1:filename2:filename3).  Then I input this into the FeatureReader as the Initiator.  In the FeatureReader I used the Advanced Browser to select the desired directory and the desired file extension.  Then for "Query the feature types specified in the attribute below", I selected my Initiator attribute that contained the colon separated list of filenames.  However, this does not work, and all I get output from the FeatureReader transformer is the filenames attribute from the "Initiator" output stream.  The files I want, are are not read into the workbench.    Any ideas on what I'm doing wrong?  I have looked through other posts and is it anything to do with the fact that the Initiator an

Hello,  I have a complex workbench on FME Desktop 2014 that transforms a input file Geodatabase to a GML compliant with an user define schema. This workbench is working and now I would like to use it with input files in gml format (obtained from file Geodatabase, so both have the same structure).  One solution is to create a copy of the working workbench and modifying only the input conexions, but if is possible I would like to maintain only one workspace.   My idea is to create two workspaces: one with the main ETL tool and other with the transformer that selects each format (gdb or gml). I don't know how to develop that format chooice. Could you give me any advice about how to solve this problem ?  Thanks in advance. Ari

Hi,  I added new attributes to my writer and I'd like to make a list to a new attribute. Is it possible?  Thanks