Authoring

Hi,  we are trying to connect to FME Server 2014 programmatically via .NET. We are using the sample code provided by the FME Server Documentation, but get following error:   {"QSIncompleteResponse:Incomplete FME Server response. Expected  [SUCCESS|ERROR]+message. Received: "}  The Server is running and the connection via web is successful. We have tried the code with enabled security and disabled security but both ways were unsuccessful. Our Code is attached:  Any Ideas what we are doing wrong?  Thanks in advance!

I’ve made a user parameter attributelist, that I use in a NullattributeMapper. Then I want to use a tester wich tests only the attributes that I defined in my parameter. How should I use my published parameter in a Tester? (FME 2015). I would like to know since I want to convert these transformers to a custom transformer.   This way didn't work for me:     Thanks, 

I am trying to use the RunWorkspace script that was posted on here in the knowledge base, so a workspace could be run from a python script. I keep getting an error on the line that initializes the FMEWorkspaceRunner object: runner = fmeobjects.FMEWorkspaceRunner(). The error is: fmeobjects.FMEException: FMEException: 896902:. I couldn't find any information on what that error means specifically. What could be wrong?                  

Is it possible to enable/disable a transformer or a connection in a workspace using a published parameter?

I have a routine that writes data into rows in Excel through a workspace runner but once the routine is finished I want FME to open the spreadsheet.   I have looked at both python and TCL but can't get anything to work without runtime errors.   Does anyone have any scripts I would use to simply open an xlsx in a shutdown script.  

create a list of drawings where a certain text string is found

Hi,  I'm reading in some data via the FeatureReader transformer and I would like to write it out dynamically, but when I try to setup the dynamic proprties I get a pop-up message No reader or schema reader found.  Please add a reader or schema reader to workspace that can be used as a schema source.  I can't add a reader or schema reader because the data does not exist prior to the workspace being run.  Any ideas?

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 (using Feature(-1) etc) but if im dealing with a million points, that will make 11 millions points. Is there any way of dealing with a previous attribute in a similar way?  all help mu

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?