Authoring

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 = &#39

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?