Creating and organizing workspaces. How to use Workbench.
Recently active
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
I have an attribute with integer value called number of folders x for a single feature, and I would like to create X number of features. so I can create c number of sub-folders using filecopy.
Hello Everybody, We have two FME server installed. None of them we cannot accesible from outside server. I need to make it web accesible. Please guide me. Because I want to got the data download or to run a workspace using the generated URL from outside. Thanks
I am trying to connect to our carto database, but are getting HTTP error 404, and also connection refused 443.How do you connect to a Carto Database?I am using out url address: com-luim.geografia.com.au and API key
I frequently use batch scripts to run series of workbenches in cmd.exe. I would really like to see the contents of the 'transaction window' or log file displayed in the cmd.exe window. I know I can look at the logs, but that is an extra step and not as useful.Normally what displays is something like this, which doesn't explain what is happening in the transactions window or log file. I really want to display this stuff in real time (not after the transaction complete): Have I missed something, or is it not possible. Thanks in advance for your help