Authoring

Hello,I was testing some stuff on the latest version of FME Desktop (2017.1) with the twitter transformer but all the results where redirected to the "error" port. I automatically checked ou the log file to find the following error comment in red: Tweeter_Tweeter(TwitterFactory): Due to a change in the Twitter API, all Twitter transformers are non-functional. Updated transformers will be released with FME 2017.1.1Well with all the frequent changes in the API's I believe we have no choice but to wait for 2017.1.1 .CheersLyes 

Hello,I have some data in Shape File format that when read into FME the field type changes from Double to an encoded attribute. See the below screen shots from both Arc Catalog and FME's reader transformer. Below is the printout from the log file. So my end goal is to use the "getAttributeType()" type method to perform some data renaming using the attribute type. So is there something I'm missing with the Shape File Reader or Shape File specification in FME?If I import the data into a File Geodatabase it works fine where FME will maintain the field types.Attribute(encoded: fme-system): `Length__fe' has value `10'Attribute(encoded: fme-system): `Width__fee' has value `3FME Build information below:FME Database Edition FME 2017.1.0.0 Build 17488 - WIN32.Any help or information as to why FME does this would be very helpful!

I converted FME server DB from default to Oracle in FME server 2017.0.1.1. Due to a notification bug in this version, I am upgrading to the latest 2017.1. I am wondering if I still need to do the restore from the backup. I would think I just need to back up the config files, particularly fmeCommonConfig.txt, uninstall 2017.0.1.1, install 2017.1, change Database connection in fmeCommonConfig.txt, restart the server/core/db, everything will just magically work fine. Is this correct?

Hi there,I'm a bit helpless after trying the hole day. Well, what is my problem. Let me try to describe it.I have a huge amount of adresses, consisting of postcode, town, district, street, hous no, coordinates etc. I concatenated all to a adress-string. Saved in a Geodatabase.Now I'm trying to geocode some adresses, by comparing with the adress-strings in the database. This is not the problem, i can do this but it takes a long long time. Now, my idea was to send every single adress with the workspacerunner to a new workbench, where I filter the Reader (my adress database) by using the Where clause to a district. Result of this should be, that fme only have to compare the adresses of a district and not all adresses. I can't compare for 1000 adresses with my database this takes too long.Well, nice idea, but I can't use a user paramater in the Where clause in my Reader, is this correct?. I tried it by transfering the district from the adress via the workspacerunner and use

Hi FME'ersI am pulling together a dataset containing the nearest three of each POI to an address from a list of addresses. E.g nearest three schools, nearest three recycle centres etc.I have used the NeighborFinder with the address feature type (Base) and the Schools feature type (Candidate). All works well but as I said, I need to find the nearest three of different feature types. Is there a way of passing multiple feature types into the candidate port of a single NeighborFinder or do I have to use a new NeighborFinder for each POI feature types? Thanks,David

Hi There,  I am using the UpdateDetector to update an ArcGIS Online feature service that is part of our open data catalogue. My workbench is fairly simple and just reads a dataset out of SDE runs it through some transformers to reproject it and then rename/drop some fields. It writes this dataset to a staging file geodatabase as an archive. Using this archive as the 'Original' input in the UpdateDetector and the features from SDE as the 'Revised', everything gets sent throught the 'Updated' port despite no changes occuring. I poked around with the parameters and found if I removed the geometry matching condition things got sent through the 'Unchanged' port as I would have expected.  Would anyone be able to enlighten me as to why this is happening?  Warren

Hi,I'm trying get a workbench to load 1000000+ features from a WFS version 1.1.0 with a download restriction of 10.000 features. Currently version 2.0.0 is not supported by this service.I would like to know if it's possible to download those features in a similar way 'pagination' does for version 2.0.0. I understand this is not suppported in version 1.1.0. I have tried to set parameters 'Max Features', 'Start Index' and 'Count' within my WFS reader with no luck. Same features are downloaded every single time.Is there an alternative way to achieve this ?**EditWhat am now trying to do is to achieve this with HttpCaller + a custom 'Loop' transformer.However I'm stuck trying to configure this looper...

Hi, I have a query please. The scenario is this - employees working for a national company are based at different offices. Each employee has a card number, which is unique to them. Every time an employee uses their card to enter an office by swiping their card, it is registered...and likewise when they leave the office too. And so the table I have includes (for each employee) has a field for "Card Number" and also a field called "Event" which records whether an employee has "Swiped In" or "Swiped Out."The question I have is this - I want to be able to compare, for each employee, the number of times they have "Swiped In" and "Swiped Out" You would expect if an employee has swiped in say 10 times, there would also be 10 occurrences of swiping out. However, a casual glance at the data does not always suggest this....I can see for example that sometimes employees have swiped in more times than they have swiped out.Therefore, is th

I am unable to send the json output to WebMethods (Using Software AG - Nirvana). Placed the below jar files into the location - <FME Server Installed loaction>\\Server\\lib\\jms1. nClient.jar2. nAdminAPI.jar3. nAdminXMLAPI.jar4. nJMS.jarSubscriptions details provided - (Protocol, Topic to Subscribe, Provider URL, Connection Factory) but when providing provider type, after clicking on OK, it disappears. Validation says successful.Now when I am running my Job successfully from FME Server, WebMethods is not able to receive any data from FME.Please help me if I am missing any configuration.

Hi, I have a desktopversion 2016 and 2017 withe shared public database connections I want to connect to 3 oracle databases in different schema's because there are three separate citties. (i.e. DBConn1, DBConn2, DBConn3) The tables are however identical so I made one procedure in a custom transformer.In the custum transformer multiple SQL Excecuters will select the needed items from different tables.I like to use a workspacerunner to start the custum transformer.How can I validate the separate Dataset (DB Conn1 to 3) in order to run my custum transformer for the three citties?I have published parameters (DBConn1, DBConn2, DBConn3) but I did not managed it to enclose these parameters in the SQLExcecuter parameter (DATABASE/DATASET).Also I did not manage to sent the parameter value from the workspacerunner to the custom transformer.The procedure has to run automatically for all 3 citties so I can't use a manual input as Parameter with Choise.Do you have any suggestions to solve th

Is it possible to use a negative list index in the AttributeCreator? If not possible, why not? Any technical reason or just not implemented? Should I create an Idea for it?Workaround is to use the ListIndexer, and AttributeRenamer but this is not really intuitive nor quick. Unlike most things in FME.

We have a service published on FME Server that uses an OAuth Web Connection (to Salesforce). The Web Connection is published to FME Server, and has been "authorized for use" from the FME Server Admin UI. Our service works fine for a few hours - presumably the lifetime of the authorization token. But then it starts failing with "unauthorized" errors, which are immediately resolved if someone logs into the FME Server Web interface and again Authorizes the web connection.It's as though the token refresh process never runs.Is there any way to troubleshoot this on FME Server (e.g. some sort of debug/verbose logging on the fmeoauth service)?

I understand that under the Tools menu there is an "Edit Header" option – but this is done per workspace. Is there any way to set a default Workspace Header so I can always have my favourite settings on each new workspace I author?

Hi guys,I have data which look like this:|ID|Number||1|1||1|3||2|1||3|1||3|2||3|3|I need to group them by ID and pick up only rows with highest Number value. To get such data:|ID|Number||1|3||2|1||3|3|Any idea how to accomplish this?Thanks

Hello, I have a folder of photos with filenames that contain pointid's (e.g. 123456_photo1.jpg). Each point may have more than one photo associated with it. So there may be many photos containing the same point id in their name. I'd like to create a list of photos per point and assign the list to a field and write to geojson.I tried using the tester and feature merger but I can't seem to get it to work. I basically want for every point id, check if the filename contains the point id, add photo file name to list, then assign list to field called 'photos'.Thanks!

I've added 7 individual Feature Types to my Workspace and want to expose fme_basename and mapinfo_type for each of them. Is there a quick way of doing this that will save me from having to edit the properties of each Feature Type one by one?

Hi there...  I a list containing adress inforation. The lenght of the list varies from featur to feature so I need a flexible solution... The list looks like this:  _list{0}.name = "Company 1" _list{0}.zip = "ZIP-Code 1" _list{0}.city = "City 1" _list{1}.name = "Company 2" _list{1}.zip = "ZIP-Code 2" _list{1}.city = "City 2" _list{2}.name = "Company 3" _list{2}.zip = "ZIP-Code 3" _list{2}.city = "City 3" : _list{n}.name = "Company n" _list{n}.zip = "ZIP-Code n" _list{n}.city = "City n"As you see...the list is of dynamic length... The task is now, to write some of the list elements into attributes:_list{0}.name => name1 _list{0}.city => city1 _list{1}.name => name2 _list{1}.city => city2 _list{2}.name => name3 _list{2}.city => city3 : _list{n}.name => name_n _list{n}.city => city_nSo I need to create a dynamic number of attributes. I tried the a

Dear Support,I am currently trying to execute a workspace and I have problem with the following error:Unable to create worker; parallelism level may be too high for the translation requestedTransformer 'pointFetcher': Unable to create worker; parallelism level may be too high for the translation requestedFor a set of 15000 polygons, I try in parallel and in a custom transformer to read pointclouds in a external database and then compute statistics for those pointclouds. Still within the custom transformer and in parallel, the input polygon is written with its statistics as attributes. By doing so in parallel and in a custom transformer, I am not overwhelming my RAM. In fact, as soon as the statistics are computed, the variables containing the pointcloud and the statistics for a polygon are erased from the RAM.When launching this process in a minimal parallel processing mode (4 parallel subprocess) and for 1000 polygons, I do not encounter any problem.When I launch the workspace

Hello,I manage an FME Desktop 2016.1.3.2 environment running out of Citrix XenApp 7.6.300 as a Published Application.We are having issues with anything that uses Parallel Processing, We have managed to get it working (no idea why it started working) and it was working well for some months, then recently it has just stopped with out any real reason. No changes have been made to the environment.Some things I have found.When running a workspace that has Parallel Processing turned on (any level) via the Citrix Published FME it fails at the stage"Storing feature(s) to FME feature store file E:\\MultiProcessor_11245\\inspector.ffs"Then we get an error box that "FME EXE has stopped working" "Close the Program"Run the same workspace but turn off Parallel Processing - works fineIf I manually RDP into the XenApp Server as the same account and run the exact same workspace with all the same settings, including Parallel Processing... it works every time. To me it seems

Hello,I have a simple dynamic workflow with Shapefile reader and Oracle writer (something like that) where I had a counter to add an ID in a new column "OBJECTID". This works well but my new column is added at the end of the schema. Is there a way to put this as first column?Thank you!Maxime

Hi, I have dataflow where I filter my data by an attribute. This results in 100+ output ports. After that I will perform the exact same transformation for every output port and write the data in a separate file. (Yes, I do need to filter first.) Of course, I can create a custom transformer for my transformation that follows (see screenshot) but I'm wondering if there's a way so I don't need to add the transformer and a writer to my workspace 100 times?Any suggestions?I'm using fme desktop 2016

Hi Friends,two questions :1. We can type the attribute names in this text field, but we cannot pass it like variable or text string(list). How can i pass this published parameter to "Attributes to remove" field to the writer dialog box? 2. If i write to shape and it crosses 2gb size fme gives error. how vcan i split the shape file if it crosses 2gb? (like fme splits v7 dgn file size in V7 writer)Explanation :My fmw has Dynamic reader and writers. I am reading from oracle spatial (every time input tablename changes, user types in table name through published parameter) and writing to any 4 formats.(shp, tab,dgn and acad) here my fmw is dynamic. there are some attribute names that i dont want to write to destination. user types in these attribute names(space delimited). through published parameters. Every time this list changes and different attribute names comes in. In the Dynamic properties, there is a provision called "Attributes to remove". Now I have two ques

Hi,In FME Desktop I can add a Header to know the time spent on each transformers.FME_PROFILE_RESULT_CSV "filepath".How can I do this on a FME Server?

I published a simple workspace to the FME server's Job Submitter service with the Job Completion notification posted to JOBSUBMITTER_ASYNC_JOB_SUCCESS/FAILURE topics. Then I published a second simple workspace (Creator and Logger just for testing) and add it to the subscription to the same topics. I would expect when I run the 1st workspace and at the end of it, the 2nd workspace should be run. But it did not. I can see the 1st workspace was run in the Topic Monitoring, but didn't see the 2nd job to follow up. Did I miss anything? I also tried using a new topic, instead of the out of box JOBSUBMITTER_ASYNC_JOB_SUCCESS/FAILURE topic, but no luck.

Hi,I'm using FME to check the log files of previous runs, testing for errors.I'm now getting notifications of errors in a set of log files, that has been generated by running a workspace via "WorkspaceRunner". The error is bogus, however, so it messes up my overview by cluttering it with false positives.The dependent workspace is called with two parameters: the path of the (xml) file to check, and a path to the desired log file. This log file path contains a dash, so I get this error:BADNEWS: String value `WorkspaceRunner_DanDas: Running FME Workspace xxxxx.fmw with command line:' contains invalid characters and could not be converted into an integer (stfutil.cpp:802)A typical log file name may be: CONTROL ARWOS XML - TV-Inspektioner.logHow can I avoid having FME attempt to do a bogus subtraction in my string value ??Cheers