Authoring

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. 

I cannot launch FME Workbench...I get a strange Time Debugger error message. Does anyone at SAFE know how I can resolve this?  

Hello FME users,I hope somebody can help me with this situation:I have a workspace that reads a list of feature ID's.For each feature I want to run the F020 workspace (connecting to a database and creating a file).To create 4 parallel processes, I split up the list and pass an ID to each of the 4 WorkspaceRunners (each using their own database connection).The WorkspaceRunners are set to wait, but that results in all processes being run in sequence.If I change the setting to "Wait = No", the file is not created in time for the next step in the process.Any idea how I can run the 4 F020 WorkspaceRunners in parallel, but run the FileExistenceChecker for each process after the F020 has created its output file?All suggestions are appreciated. 

I have a pipeline route and make an areaonarea overlay with a buffer to analyze how many buildings are in this buffer beneath both sides of the route to classify this segment (for example 1 mile long and 220 yards on both sides....thats clear so farbut i want a loop to shift the buffer (for example 200meters along the route) to get a new classification...so first overlay for example from 0 to 1000meters on the route...next from 200 to 1200meters and so on...how can i build this looping? (or do i need a looping?)simple for you i thinkCheeers Franco

I have a workbench that uses a python shutdown script using the "ESRI ArcGIS Pro 2.1/2.2/2.3(Python 3.6)" python compatibility. It works fine on desktop but when published to FME server (2019) I get the following error: ArcObjects could not be initialized. ArcGIS required for the specified Python Compatibility 'Esri ArcGIS Pro 2.1/2.2/2.3 (Python 3.6+)'. I have read the following: https://knowledge.safe.com/questions/73555/the-arcgis-python-36-interpreter-could-not-be-foun.html but I am unsure that this applies to my case as I we are running FME Server 2019.0.The same versions of FME and ArcGIS Pro are installed on both my desktop and on the machine running FME Server.What else am I missing to get this to work on FME Server?

Hello, Does anyone knows how to run a Where clause for the sptialbiz plugin reader in fme desktop.I have tried normal sql statement but it doesn't work. Regards,Saman Aziz. 

Hi all, The image you can see the attribute table of my datasets. I would like to change the attribute position based on a logic like thisIf the position of an object is UNDEFINED, I would like to find an object that has same _id value and then if the object with same _id's position is RIGHT, assign the position value as LEFT. For example, the object with _id_rule 14 has position as UNDEFINED, so i would like the find the other object that has _id 11 (it is common in both object). In my case, It would be the object with _id_rule 10. Then I would like the check the position value of the object with _id_rule 10. If it is RIGHT, I would like to change UNDEFINED value to LEFT for the object with _id_rule 14I have tried to use combination of tester & sampler but could not figure out so far. Any idea? Thanks in advance.

Good afternoon, I'm trying to add FME Server Job Id to a report in Excel, but it doesn't seem to be populating. I have $(FME_Job_ID) assigned to the correct field. When I look at it in desktop, It is not set. I don't think I need to set it as I'm not in FME Server. Does the Job Id automatically get placed in the $(FME_JOB_ID) parameter? Or do I need to place something in it? Thanks,David

Hi All, I have been "gifted" 500gb of contours (as 20,000 20meg shapefile tiles) and have been asked to create a single dataset (merge and dissolve/union for loading into a ESRI database.) I have read many of the FME articles on BIG data processing and Lightspeed Batch Processing...So its a shapefile to FileGDB transform essentially. I always like a challenge so i have had a think on how to achieve this...Use Fme to process the data in batches, ie merge and union the first 500 shapefiles into fme FFS format , then the next 500 etc, then merge the FFS into larger and large FFS'S then write it all out eventually to FGDB. Pros - process it locally, easy to setup and let run. Cons-not sure if merging then dissolving over and over again is more efficient than doing it all at once or will be sloooow?  Use FME to create 20,000 GeoJson csv's for upload to google BigQuery and use ST_UNION_AGG function on the data using Googles infrastructure

I managed to get my first FMEAR model of a campus with 3D buildings and roads on FMEAR app for Android. I was wondering what those different coloured meshes indicate, when trying to project the AR model on a surface?It will be nice, if there was some more documentation on the FMEAR in addition to what is available. ThanksSRG

Hi, I would like to delete some files in the temporary resources folder using the FMEServerResourceConnectorTrying to populate the object id:Object IDThe Object ID of a file or folder on FME Server to delete. If valid credentials have been provided as a web connection, you may browse to a location.With:$(FME_SHAREDRESOURCE_TEMP)/mapper/downloads/$(UUID)/data/xxx/@Value(filename_field).datHowever it doesnt delete the file, not reporting anything.Any idea what I am doing wrong here?Thank youOliver