Creating and organizing workspaces. How to use Workbench.
Recently active
Hi,I have a situation where I have two file geodatabases. They contain subsets of data from the same spatial areas and have a structured coding (see example image below).As the layers can be large I wan't to process them in a workbench one pair at a time. But there are many pairs, so I would want to batch this. I know of a method to do this using PATH reader and WorkspaceRunner, when the inputs are Shape files. But with the PATH reader you can't map in to FileGDB layers. I do not want to convert to Shape, as I would loose the complex attribute names.Any suggestions how I could send each pair at a time to a WorkspaceRunner in batch? Attached is the logic how it would work with Shape-files.Thanks for any ideas!
Example: MagikSF> vl.collections[:l!foreign_facility].at(45281100).lg_scale_annos $ a sw:db_set MagikSF> print(!) $ db_set: l!for_facility_lg_scale_anno226:(gis_id(1160218,959604322,45281108)) l!for_facility_lg_scale_anno226:(gis_id(1160218,959604322,45281110)) MagikSF> foreign_facility is joined with other large scale anno collection and in smallworld it is returning as ds_set. while exporting that, it is going as char and taking "db_set" as value in text format which is not correct .how to export this particular field.
Hi,Is it possible to set the attributes in the Feature information window so that the colors in the color will be displayed in the same color as igds_color without using the workbench? (Fme Viewer set fme_color like igds_color when input dataset) Is it possible to make a filter on attributes in the Feature information window so that we see only certain attributes in feature information windows?
Hello,I have a set of node data. Some of those nodes will have an empty attribute. I am trying to populate them (call it "config") based on previous or next feature. The condition is should be somewhere along these lines: If Feature[-1] exists AND Feature [+1] does not exist, then Config = feature[-1].ConfigAdversely, Feature[-1] does not exist AND Feature [+1] exists, then Config = feature[+1].ConfigIf both exists, then Config = feature[-1].Config. I am trying to write out the conditional statement and have adjacent feature checked. The conditions only allow for checking if an attribute is null, missing or has an empty string. I don't seem to have any option for the existence of a Feature itself. Any one have any idea how I can go about that? Thanks!
Hi, I have geometry in one Oracle table and attribute information in another which I am merging using feature merger. This works fine, the problem I then have is that I need to write to shapefile and it truncates fields to 254. In one particular field there are 100+ attributes that are over 2000 characters in length. I know I can use substring extractor to extract various lengths but does anyone know how I could ‘automatically’ create x number of attributes (each less than 254 characters) so that I would have 10 attributes of 254 length etc. that would make up 2,540 characters? Thanks
What method do use to parse the Filename (multiple) parameter in python? I currently use source = FME_MacroValues['Param1']if source.startswith('"'): from shlex import split fileList = split(source[1:-1])else: fileList=[source] but it feels clunky. The assumption is that if it's a single file, it is not wrapped in quotes, but if it's multiple files it is: ""file1" "file2" "file3""
Hi,When I use FeatureReader and read the data, I'm receiving features with attribute names ending with (encoded: utf-16) and (32 bit integer). When I use the normal reader, I'm receiving the attributes as-iseg: id (32 bit integer) and ATTR1 (encoded: utf-16)Could any one tell me how to get the attributes as-is because I have to use the same attributes in featurewriter and write the data with Automatic attribute definition There are 1295 feature classes which is not possible to define the attributes for each feature type...Pratap
When I installed FME I think I checked Yes, when asked if I want to report usage statistics Anonymously to Safe Software. But I don't want to report this anymore. How can I turn it off?
I have a vector dataset containing buildings and a raster dataset containing elevation data.I am looking for a way to find the mean and maximum value of the roof of each building.So far I have converted the raster dataset to points, extracted the raster value to an attribute and clipped it with the building polygons. The StatisticsCalculator can help me finding the mean and max value in each building, but before doing that, I would like to remove the outliers.So the question is: how can I remove the top and bottom 5% of the values in a list?
Trend Micro Office Scan quarantined my 2016 FME desktop and in the log it comes up with unauthorized file encryption. I have been able to reinstall FME to a new location but eventually is get caught again.Has any other users experienced the same issue?
Hi, it would be great if we could get some "official" input from Safe on this issue:https://knowledge.safe.com/questions/53449/running-python-in-fme.html
Hi guys,I am trying to setup a workbench to download data from various feature servers. the reader's format is Esri ArcGIS Server Feature Service and i use feature writer to write the data.I've been having this below error notice once a while, but it's normally gone after i re-run it after a while. Python Exception <HTTPError>: 502 Server Error: BAD_GATEWAY for url- Is there a way I can setup in my workbench to let it keep running after one of the readers has this error? - Can I let the workbench re-run that reader after receiving this error?Thanks
Hi,I base my production runs on FME mapping files, which I create from Workbench workspaces by using "Save As". This way I can mess a little with a the workspace without throwing my Is it possible to add this 5-click procedure as a nifty custom "macro" in the Workbench GUI toolbar ?I.e. save workspace as mapping file with the same name and in same folder, prompting for overwrite if required.Cheers.
Hi,Our IT department now wishes to have all connections to the central admin database (MS/SQL) identify themselves properly. I.e. not as e.g. ".Net SqlClient Data Provider" etc.FME does identify itself as "FME(R) 2016.1.0.1" in this case, but it would be nice, if one could overwrite the connection default "Application Name", e.g. with a custom workspace related name.Is this possible ?Cheers
My PYTHONPATH system variable is set to the following and python.exe and pythonw.exe are both in the D:\\apps\\Python\\ArcGIS10.5 folder. This script works fine in the Python window in ArcMAP.D:\\apps\\Python\\ArcGIS10.5; D:\\apps\\ArcGIS\\Desktop10.5\\bin
Hi, I'm using the TweetStreamer to monitor a few key words, when I hit these key words, I'd like to retweet the tweet, and follow the user who created it. I can't see an obvious way around this at the moment, so am looking for suggestions!
I am trying to chain together multiple workbenches so that when one workbench finishes making changes to my data, that changed data will be passed on to the next workbench. I am using a WorkspaceRunner at the end of the first workbench to begin the next workbench. I have been trying to find information on how to read the data from that WorkspaceRunner into the next workbench, but have been unable to find any clear information about how to do this.What reader should I use or steps do I need to make to accomplish this?
Hi!I am trying to download a set of data from my Oracle database. I have created a simple workspace with a Creator, a FeatureReader and a FeatureWriter - connected in that order.I the reader I connect to my database and select a table. The writer I configure to export to an ESRI Shape file completing only the dataset and the shapefile name.When I look at the "User attributes" pane in the writer all my attributes from the Oracle database are listed but as CHAR 200 (and they are not all of them supposed to be CHAR):Why can't the reader and the writer work out the correct attribute configuration?
I have some very long running Workspaces being run from C++ using FMEObjects. Is there anyway that I can allow the user to pause or stop them from code, perhaps when I receive log messages from them? If not, can I request that there is some mechanism added to the interface so I can. Currently on 2013SP2, moving to 2017.1 shortly.Chris
I have an Excel parameter file with tabular information indicating which files/feature classes/tables to read, which queries to use, which fields to expose, etc. I figured the FeatureReader would be a good option to use for grinding through my various datasets. I've managed to get most of what I need to work, but I am seriously struggling with the Attributes to expose. I first thought I could simply use an attribute from my parameter file as input, but it seems the FeatureReader only accepts User Parameters for this option. I therefore created a separate workspace for the FeatureReader, calling it from my main workspace through a WorkspaceRunner, with Attributes to expose as an input parameter. But...no joy. While it now seemingly accepts input from my parameter file attribute, it doesn't do anything with it. I have tried various settings for the user parameter (text, attribute, attribute list, ...). I have created a user parameter straight from the FeatureReader dialog (it se
Hi,I want to check if set of attributes(not the values in attributes) exist in feature type or not?I also want to get the name of attributes to generate HTML Report which are Present or not present in Featuretypes.Case: I have multiple EXCEL filesFirst file with column name (A,B,C,D,F) Second file with column name (A,B,D,E) I want to check in which file which columns are missing out of Set {A,B,C,D,E,F,G}I want to retrieve the column names as well to generate HTML Report also.Please help on this topic, Thanks in advance.
Hi All,I have a python script that runs successfully in IDLE, but when I copy and paste the same script into the startup python script box in my workbench the script fails.Below is the script: # Import modules import arcpy import arcgisscripting import arceditor arcpy.env.overwriteOutput = True arcpy.env.workspace = "C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\www_gis.GIS_ADMIN.WastewaterDataset"# Local variables: www_gis_GIS_ADMIN_RMoN_San_GravityMain = "C:\\Users\\GRAUP\\AppData\\Roaming\\ESRI\\Desktop10.3\\ArcCatalog\\Connection to NRGISSQLS03 WWW_GIS USER.sde\\\\www_gis.GIS_ADMIN.WastewaterDataset\\\\www_gis.GIS_ADMIN.RMoN_San_GravityMain" RMoN_San_GravityMain_Route_Output = "H:\\\\O.10_Operating_Projects\\\\Linear_Referencing\\\\Reference\\\\Linear Referencing Shannon Working\\\\Linear_Referencing_Working.gdb\\\\RMoN_San_GravityMain_Route_sde_connection" # Process: Create Routes ar
How do you set role policies in FME Server 2017? I don't see this link. How do I give a particular group access to certain features in FME Server 2017, such as the web user interface, notifications, repositories, etc?
Dear FME community, when I try to connect to the FME store, it always fails to load the transformers. I can see what transformers are available, but there is no way to add them. I get's the following message for example (see also the attachment): "Could not download 'PythonEmailer'- A problem was encountered while trying to download from FME store." In the network settings menue I have set the option to "Use system proxy setting" and I also have writing permissions in my FME installation folder. Is there anything what I can do to load the transformers from store? Kind regards Thomas