Creating and organizing workspaces. How to use Workbench.
Recently active
Are there any tools that can be used to document the contents of a workspace?
I would like my script to keep only one attribute designated by the user in a shape in which it will be renamed. I created the workspace below. the attribute "ATTRIBUTE" persists in keeping the value 0 while the selected attribute contains 5, 12, 8, 45 .... Where can my mistake be? Thank you
Is there a transformer that is a cross between an AttributeKeeper/Remover and a Tester? Meaning that I need to dynamically split my data not on attribute values but on the attribute field names, so all of the fields with the suffix '_alias' are routed one direction and all other fields are routed another.Any thoughts on how I can achieve this?
Hi all, I have a geojson file, where I would like to concatenate the some key value pair to one as array. I have tried ListConcatenator however it simple concatenate without creating array. You can see the below my attempt and desired result. Thanks in advance. Output of ListConcatenator{ "type" : "Feature", "geometry" : { "type" : "LineString", "coordinates" : [ [ 4.3458008766, 50.8345288033 ], [ 4.346331954, 50.8348774905 ], [ 4.3474423885, 50.8357197041 ] ] }, "properties" : { "osm_id" : "", "osm_way_id" : "30010739", "_amenity{0}.amenity" : "hospital", "_amenity{1}.amenity" : "pharmacy", "_amenity{2}.amenity" : "drinking_water", "_amenity{3}.amenity" : "pub", "_concatenated" : "hospital,waste_basket,pharmacy,drinking_water,pub"
I am trying to create a custom tool to help me do QA better and faster.I have no problem detecting columns with null, empty ... etc but I really struggle to do so with <missing> values in PythonCaller.Thanks for your help in advance.
Hi, I'd like to set up a notification that watches over some web address.When the changes of content occurs, it should notify me via e-mail or something. How can I do that?
Is it possible to use a % symbol in a choice type parameter?e.g. if i wanted the parameter options to be %y%m%d or %d/%m/%Y
I have an IFC conversion to citygml, in which I created spaces in revit and I converted them using the Citygml Room feature. I want to have the information about the volume of these spaces in the final Citygml Room attribute table after the conversion. the volume information is stored in the BaseQuantities.GroosVolume attribute Of IfcSpace.
I have a list which I exploded using the listExploder. The output contains an attribute _element_index. I want to create an attribute with a name composed of the value of _element_index concatenated with another string. When I try to write the name of this new attribute in an AttributeCreator, it seems like the @Value(_element_index) doesn't work as no new attribute is created (the new attribute name doesn't appear as an option in the AttributeExposer).
When reading features from REVIT Reader reader, some attributes like BASEQUANTITIES.GrossFloorArea were not being populated (missing). When reading this IFC in FmeDatainspector, they are not missing.
I'm using AreaGapAndOverlapCleaner to fill in holes created within or on the edge of polygons in a dataset of 1.7 million polygons. This takes some time (12 hours for the whole Workspace although there are other transformers in there). I have wondered about using Group By in AreaGapAndOverlapCleaner but I don't know whether this would mean that gaps between polygons in different groups would be cleaned or not.For example, polygon 1 is in group A and polygon 2 is in group B. If there's a gap between these polygons, and I'm using Group By in AreaGapAndOverlapCleaner, will the gap be filled in?This is on my to do list of experiments but if anyone knows the answer straight away, please let me know :-)BTW "AreaGapAndOverlapCleaner" is not available as a topic to tag this post with...
Hello,I would like to pass date/time user parameter (Date Ranges) to a SQL-Non Spatial reader where clause. I have tried the following with no success.[wo_complete_dt]>= {ts $(DateRangeStart)} AND [wo_complete_dt]< {ts $(DateRangeEnd)}[wo_complete_dt]>= {ts ‘$(DateRangeStart)’} AND [wo_complete_dt]< {ts ‘$(DateRangeEnd)’}[wo_complete_dt]>= '$(DateRangeStart)' AND [wo_complete_dt]<'$(DateRangeEnd)'[wo_complete_dt]>= $(DateRangeStart) AND [wo_complete_dt]< $(DateRangeEnd)However, if I change the user parameter to a text type or input the dates directly into the Where clause as shown here it does work. [wo_complete_dt]>={ts '2019-06-09 00:00:00'} AND [wo_complete_dt]<{ts '2019-06-16 00:00:00'} Can someone please guide me?Using FME Desktop 2019. Thanks in advance,Keith
Hi, I have a workspace which looks at all files in a location (using a "Directory and File Pathnames" reader), picks the file that I want (using a tester), reads the attributes with a feature reader and writes it to a database. This works fine when I run this workbench in desktop. When I publish the workspace to FME server it requires the user to fill in the Source Dataset. This workbench is triggered by another one, so it fails at this step. Is there a way to use an attribute as the default source dataset on FME Server?Thanks in advance
I want to merge features by attribute that contains string from target attribute. FeatureMerger does job done but only in case where attribute(req) = attribute(sup). In my case i want to expression to loke like this attribute(req) CONTAINS attribute(sup).
I have a gdb featurewriter that passes through to a shp featurewriter. For attributes with names at the 10 character limit, the shp writer is using their _alias field to populate instead of the correct one.Example: ASSETCLASS field is being filled with 'Asset Class', instead of 'Rail'.Is there a way around this besides adding in and attribute removed for each of the Feature Types?
Hi, I am new to FME and i need to build a model that does the following thing: 1. Select all Address Points that are inside an Area Polygon type= OSA by a given Id. 2. Filter out all addresses that are Allocation Status = No Build.3. Output should be the sum of the "Location Id" field of all addresses points that are "No Build" per polygons id..I need to create out put in excel format.
I'm looking for a way to execute a workbench from a python script. I came across a sample py code from the fme knowledge center and I tried it (see py code below). It first gave me a win 32 error. My python is 32 bit. So, I downloaded python 64 bit, but still can't access the fmeobjects. see error message below. The fmeobjects does exist in the path below. What am I missing? How to execute a fme workbench from python? ........error message running the py script..... import fmeobjectsImportError: DLL load failed: The specified procedure could not be found. .......... py code...........import syssys.path.append(r"C:\\Program Files\\FME\\fmeobjects\\python27")import fmeobjects# initiate FMEWorkspaceRunner Classrunner = fmeobjects.FMEWorkspaceRunner()# Full path to Workspace, example comes from the FME 2014 Training Full Datasetworkspace = 'C:\\Program Files\\FME\\fme.exe" C:\\...myworkbench.fmw'# Set workspace parameters by creating a dictionary of n
Good day, I created a custom transformer (*.fmx file) that is used across different workbenches and users. To use the custom transformer I specify the location on FME Options - Default Paths - Shared FME folders. This custom transformer is saved in two different locations with teh same name depending on what database and some other variables we are using. Where can I specify the one I want to use in a script? Is there any parameter in a workbench I can set to point to the correct shared fme folder for this specific workbench? The shared fme folder I want to use is depending on the script I am running. Thank you.
Hi, would it be possible to use FME Workbench in a SAAS scenario? I am aware of the FME Cloud solution which is great, yet I would like to "rent" FME Workbench to develop workspaces (for publishing them to FME Cloud..." or just run any translation. Or would I have to create a Docker container and use that? In that case it's good to know that I have a customer that does not use the Docker/AWS cloud environments. Thanx for any comments.
I'm very new to FME.... I have an attibute with one single value, and other attributes with multiple values. I want my writter to name my file based on that single value, however when I select this attribute to be my file name, it creates two files (one file with no name containing all other attributes, and the other file named correctly but not containing any data)
Is it possible to run batch deploy mode on FME Server?
Is there a way to make your workbench settings independently from workspace to worskpace ? It looks like settings are 'user based' and not 'workspace instance based' ... When you set for example Python3 or enable Feature Caching in one workscpace than all open workspaces on same machine will inherit the same settings. Is this true ? or im missing something ... Windows , FME 2018Jorge
I have a set of lists _option1{0}=A _option1{1}=B _option1{1}=C _option2{0} = X _option2{0} = Y _option2{0} = Z and valuesfeature 1 _list{0} = A3 _list{1} = 7B2 feature 2 _list{0} = 4X feature 3 _list{0} = C2 _list{1} = 3Z I need to identify only those features that whose list elements contain items from both _option1{} and _option2{} . In the above example, that would be feature 3. The data list values are not an exact match to the values in the option lists, just contain them. There can be any number of elements in the data list. The options are the same for every feature.
Hi, the workbench just shuts down when I click on a transformer. Anyone else experiencing this?Thanks
Hello I have five raster images from one point, which differ only in the recording direction. From these images I would like to create an overview image from their center parts. For this reason I cut out a subset from the middle of all five images. These 5 small pictures I would like to put together now by via RasterMosaicker in one picture. If I try this on a single example, it works perfectly.However, I can't do it if all the shots are to be applied over the entire project. Specifically, I don't manage to hand over the selection of the five related images to the RasterMosaicker. The five recordings can be selected using the same substring in the file name. So my question is, how can I select the corresponding files in FME from a large number of files?Thanks a lot.