Creating and organizing workspaces. How to use Workbench.
Recently active
I would like to run a workspace using python and the code I have is simple, but it's not working. Is there something wrong with my python code or could it be something else?import subprocessargs = [r"C:\Program Files\FME\fme.exe", "C:\ProgramData\Geocortex\Workflow\FMEScripts\testEmailer.fmw"]subprocess.Popen(args)
I noticed after upgrading to FME 2019.1 (19608) a strange behaviour. When importing Oracle FeatureTypes, FME automatically adds "fme_geomattr(index).oracleXXXX" attributes. I haven't found any setting in preferences for this, and don't know why it is doing this. - same occasion, in attribute view. Why isn't it possible to properly change the width of the columns? That's something which buggers me a long time in many builds....- in 2019.1 I cannot scroll the log-window anymore. Also clicking in the logwindow didn't help. no problems in 2019.2 which I am testing on another server. Thx for any advice, also have a great weekend everybody,best regards from switzerland, Chris.
Hi folks, New to FME and am struggling with working out how to set multiple feature values based on a multiple criteria lookupMy source looks like the followingsystem_iddescriptionpurposeST1ST21Scout HallCC 2Town HallT 3Council OfficeWS My translation table looks like the followingSelectionTypeRAMM.fieldRAMM.DescriptionT1BUILDUSEramm.ud_buildings.purposeMUSHERCULTBUILDUSEramm.ud_buildings.purposeHBHERCULTBUILDUSEramm.ud_buildings.purposeCCCOMMUNITBUILDUSEramm.ud_buildings.purposeTPUBLICBUILDUSEramm.ud_buildings.purposeWSMUNICIPLBUILDTYPEramm.ud_buildings.purposeMUSMISCBUILDTYPEramm.ud_buildings.purposeHBMISCBUILDTYPEramm.ud_buildings.purposeCCCOMYHALLBUILDTYPEramm.ud_buildings.purposeTPBTOILETBUILDTYPEramm.ud_buildings.purposeWSDEPSTOREBUILDTYPEramm.ud_buildings.purposeFESMISCBUILDTYPEramm.ud_buildings.purposeCCSCHANGERMBUILDTYPEramm.ud_buildings.purposeRCCOMYHALL I want to update ST1 using the SelectionType BUILDUSE and ST2 based on BUILDTYPE based on the purpose in the source to
Howdy, Since the FeatureReader was introduced I've been getting good use out of it, but it exposes the feature types as separate outputs. In my workflows I prefer to keep a single processing path and would appreciate the option to have a "Single Merged Feature Type".. If this is currently possible I can't figure out how it's done. If it isn't could I suggest it as a product enhancement please? Cheers, Richo.
I am using serveral AttributeValidator Transformers in FME Desktop 2019.1.2 and noticed that one of them is removing a record. I have a total of 48,328 records that I am trying to validate. However, the total output of Passed + Failed ports adds up to 48,327. The 3 AttributeValidators that I used upstream passed all records thru. Screenshot of Workbench:AttributeValidator Settings: It appears that only the 4th AttributeValidator in the workbench does this. Is there a limit to the number of AttributeValidators that a single workbench can contain. I need to use multiple AttributeValidators as I have to perform 6 unique validation test. Has anyone seen this behavior? If so, what is the fix/work-around? Or is there better way to validate data without using the AttributeValidator?Thanks,Mark
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