Creating and organizing workspaces. How to use Workbench.
Recently active
Is it possible to make data anonymous before it is read in the workbench.I have found the attributecompressor but theoretically I can read the privacy data before it is compressed.
Is it possible to merge all feature types with all attributes using FeatureReader? <General> port is not an option, 'cause it gives geometry only without attribute information.
I have two features source and MasterData i need to select in MasterData only 10 meters radius data from source. Based on Geometry and exclude attributes condition.
Hi,I am using the WKT reader for text files containing each one WKT polygon.I want to write them to shapefiles, using their basename as fanout.But all files are getting the same value for fme_basename.
I need to loop the table cells without repeating as you see in the Image:Thank youJohn
I have a number of features which have an attribute named ID and a list attribute named TRIPS{} like this:ID TIPS{} 1 TIPS{0}.trip = B TIPS{1}.trip = E TIPS{2}.trip = D TIPS{3}.trip = C 2 TIPS{0}.trip = E TIPS{1}.trip = C TIPS{2}.trip = D 3 TIPS{0}.trip = A TIPS{1}.trip = C TIPS{2}.trip = D TIPS{3}.trip = E 4 TIPS{0}.trip = B TIPS{1}.trip = A For my purpose some features are redundant as all their trip values are already in other features, so for every feature I want to check if all trip values are in any other feature trips, and if so, delete the feature.In my sample list, feature ID=2 should be deleted as trips C, D and E are also in features ID=1 and ID=3. The resulting features should be:ID TIPS{} 1 TIPS{0}.trip = B TIPS{1}.trip = E TIPS{2}.trip = D TIPS{3}.trip = C 3 TIPS{0}.trip = A TIPS{1}.trip = C TIPS{2}.trip = D TIPS{3}.trip = E 4 TIPS{0}.trip = B TIPS{1}.trip = A I tried the following: explode the list, aggregate features concatenating 'trip' attribute with commas,
Hello All, Is it possible to perform any sort of web crawling via FME? I have a button the website which downloads documents for me. I wish to automate it by some sort of crawling from FME which reaches the site and downloads the data.Kindly help.
Hello,I have an excel as a reader and i would like to add a writer for shape as output. In this, I am adding some attributes to which I need some values, which can be selected via a dropdown in shapefile. Is there any way of adding dropdown values in FME which will be reflected in shapefile as dropdown attributes?Thanks in advance.
Hello FME community,I have points CSV file (POI). Each point includes Category, Name and Homepage attributes as shown in following screenshot: The problem is that, for each Category of points within specific distance I need to create one point in center (center of group) and append the information of original points. The result should be similar to the following screenshot to display it on a website: My idea is to Buffer the points with required distance, followed by Dissolver (Group By: Category) and CenterPointReplacer.I am stuck on exactly how I would append all information of original points to the new created point to achieve the desired result. For Example the 3 museums should be presented by one point that includes the information of 3 museums.I attached the workbench for more clarification.Does anyone have any ideas or other potential solutions to perform that with FME Desktop? Regards,Afia.@mark2atsafe @egomm @david_r @jlutherthomas @jdh @takashi @redgeographics @danilo_fme
Good day, I am trying to start a job on FME Server which works fine copy pasting the URL in a browser, in a Javascript application.URL is like the following (some text replaced): URL = "https://inspire-rather-wet-from-sweat.fmecloud.com/fmejobsubmitter/Tools/BetterWetfromSweat.fmw?SourceDataset_ARCGISFEATURES=https%3A%2F%2Fgisservices.noord-holland.nl%2Fagsp%2Frest%2Fservices%2FHosted%2Fbu_helsinki_knooppunten%2FFeatureServer&SourceDataset_ARCGISFEATURES_3=https%3A%2F%2Fgisservices.noord-holland.nl%2Fagsp%2Frest%2Fservices%2FHosted%2Fbu_helsinki_routes_snapped%2FFeatureServer&DestDataset_ARCGISPORTALFEATURES=https%3A%2F%2Fmaps.noord-holland.nl%2Fkaartenportaal&opt_showresult=false&opt_servicemode=sync&token=1234567890"When I use this URL with in javascript, using the following snippet, I get a CORS error in Firefox and Chrome: function startFmeServerJob(job_url) { var xhr = new XMLHttpRequest(); var job_url = "https://inspire-rather-wet-from-sweat.
Hi,Using FME it´s possible visit the website, fill form values (with specifical values) and return the resuts?Look below:What the sequence or transformers can help me?Thank´s
Hi all, I have a workspace that i want to develop to automate/batch process. The basic idea of the workspace is to take a specific grid tile with an ID, perform an upstream trace, calculate associated statistics, and then outputs spatial elements and an associated statistics spreadsheet.What i want to be able to do is feed the workspace a list of grid IDs, and the workspace run to completion for EACH grid. This is required as each grid has to be considered independently from the others, even though their upstream traces may overlap.I assume this can be achieved with a combination of dataset fanouts and workspace runners, but i cant figure out how to feed spreadsheet rows one at a time. Thank you!
I am trying to read some Ordnance Survey data (Vector Map District) in SHP format, this is delivered as a separate ZIP file for every tile, for example; SH, SJ & SN. Each file contains a number of feature types that 'should' be the same but, for example, if there are no 'glasshouses' in the SN area then that feature type will not be included in the SN file. A secondary issue is that whilst each zip file contains similar feature types they are named uniquely, for example, the Buildings feature type will be named SH_Buildings, SJ_Buildings and SN_Buildings respectively.Whilst the feature types are unlikely to change very often I would prefer to create a dynamic workspace that can handle changes should they occur.My initial attempt has been to use the Merge Feature Type option in the reader to bring all the feature types into a single type. Unfortunately this does not retain the original feature type description which I would like to use in a filter further along in th
The scenario is : An httpCaller inside a costum with parellism active to send requests in parallel.Im trying to find if there is a way to have a featureWriter or any other writing solution inside a parallel costum so that it writes the results/ httpCaller responses as they get processed by each parallel child fmeworker.As far as i understand FME queues all results of each child fmeworker into an internal buffer and when all its done it outputs results out of the costum to proceed on the pipeline.Happens that, sometimes parallism crashes with ERROR like below not beeing able to keep track of what was done previously .I tried to wrap a featureWriter inside the parallel costum transf hopping that it would write the results in realtime during the parallel process into a database, but it looks like it stills writing only at the end of all child processes end sucessfully. im using FME 2018.1 Build 18547 - WIN64 2019-10-03 10:46:58| 960.1| 28.3|ERROR |Error in child process '0', exited with
I would like to use a user parameter to create the name of a PostGIS table. I have created the parameter (named Vn_PostGIS), and I have added it to the writer - in my example the table name is added to the writer as:table_$(Vn_PostGIS)_polysI can run the workspace within FME GUI and add the parameter name in the Translation Parameter Values dialog, and it works fine. If however I run it from a windows batch file, it ignores the parameter value in the table name, and tries to create a table named table__polys I am passing the parameter in the batch file using --VnPostGIS vn2. I also pass the filename of the file to be read, and that works fine. I can see from the log file that FME has taken the value of the parameter on the line "FME Configuration: Command line arguments are". It states that the value is the same as I have in my bat file. However when it gets to checking for the exisitence of the table, it fails as it drops the value of my parameter, so the table name is wron
Geodatabase Error (-2147219884): The Field already exists.FileGDB Writer: Could not create feature class 'IMPORT_FIELDS'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Geodatabase Error (-2147418113): Unexpected operation.FileGDB Writer: Could not disable Load Only Mode for feature type 'IMPORT_FIELDS'Geodatabase Error (-2147418113): Unexpected operation.FileGDB Writer: Could not free Write Lock for feature type 'IMPORT_FIELDS' error occur while running thanks in advance
I am looking for a way to change the server to which my SQLCreators and FeatureWriters are pointed to based on a parameter. I am not seeing a clear way to do this in FME. It is my understanding that in FME, we can use Python to dynamically set parameters or update transformers. What is the preferred way to do this? Can I update the Server property of a Database connection? Or should I change the connection property of the writers and creators?
Hello SAFE Gurus,This is just an observation but there is an annoying difference in Chrome in FME Server when compared to IE.The checkboxes in chrome, once checked move up. Above is the Chrome snapshot, below the IE
Hi,can someone help me with the Python expression, please...I need to get a summary of "sum A" and "Sum B" wenn I write: "sum A"+"sum B" I get an result: "sum Asum B" theese "sum A" and "sum B" must be written as a string, because I get this sum from calculating a few fields.
Hi, I'm trying to optionally switch off the Spatial checkbox in a Writer by linking to a User Parameter. There is no drop list to enable me to control the Spatial box. I've tried unsetting the Spatial Column and setting Create Spatial Index to No (both of which I can link to Parameters), but then my non-spatial data doesn't get written out.Any clues?Chris BB
Hi,after saving in the History panel (Workspace Parameters Description), the columns are resorted and the row content moved up. (Version: FME 2019.1)Befor saving:After saving:Can you help me please? Thanks.Marleen
Hello, I have a problem with my FME script.My goal is to create a custom transformer that does the same thing as AttributeValueMapper but by using a dynamic list off matching value.Why ? Because I have a file witch contain data that I need to clean :File "data"field_test_1 field_2 field_test_2 xxx Good morning ab xxx Hello ac xxx Salut ab zzz Bonjour ab yyy Konishiwa ac To do this, I have a file which contain all my matching values like this :File "code_list"code value CODE_A_01 value xxx CODE_A_02 value yyy CODE_A_03 value zzz CODE_B_01 value ab CODE_B_02 value ac CODE_C_01 value xxx My goal is to replace value in "field_test_1" and "field_test_2" from the file "data" by codes listed in the file "code list".Little things to keed in mind : codes need to be filtered as values from differents fields can be the same but not corresponding to the same code (has you can see lines 1 and 6 from file "code_list"). First tr
Hi all,We are running a license server (v11.15) with 10 floating licenses ESRI Edition.The number of users using FME Desktop are growing fast, even faster then the budget :-)Among the users there are different profiles.So we want to set up a pool of licenses per AD user group. For example:- primarly we want to create a pool of floating licenses professional edition that only members of specific Active Directory group can use- beside that we want to create a pool of floating licenses ESRI edition preserved for members of an other active directory group Is this possible? If yes, what's the configuration? Thanks for sharing the knowledge,Kind regards,Francis
I have an FME workspace "A" using a CAT reader that works well.I have another workspace calling it with a WorkspaceRunner, which goes through a bunch of files using a "Directory and File pathnames" reader.In the workspaceRunner Parameters of workspace "A" and can't select "attribute value" from the "Directory and File pathnames" reader :/I changed my workspace "A" for a plain text reader and now I can select "attribute value -> path_filename". There seems to be a bug with the CAT reader inside a WorkspaceRunner :/Am I doing something wrong?
I'm trying to read the data from an Oracle Locator database into FME. When reading data through both the Oracle Spatial Object reader and the Oracle Non-Spatial reader everything goes fine.However, with the Oracle Spatial Relational reader, I get the following errors when trying to get the table list (see image 1): The log file says the following (see image 2) Am I getting this error because I "only" have the Oracle Locator database, and not a full Oracle Spatial database? Or is the error due to missing parameter settings? To be clear, I'm using the same database connection.