Authoring

Hi, I have a list of dates in a list called _inputlist, I then need to run these sequentially through a loop and test each entry to see whether it is in the past, is today or in the future. This much is easy enough as I can create a custom transformer, use the DateDifferenceCalculator to calculate the number of days between the date value of the list item and the value of a TimeStamper and then test for values => 0.The next part is the one I am having trouble with. I would like to store those dates that pass the tester into another list (called _outputlist) but I'm not sure how to assign the values to this list.As an example, this is how I would like it to work;_list{0} = _outputlist{0} _list{1} = (failed tester, discard value) _list{2} = _outputlist{1} _list{3} = (failed tester, discard value) _list{4} = _outputlist{2} _list{5} = (failed tester, discard value)I suppose I want something that will allow me to set @Value(_outputlist{@Value(_outputcounter)}) = @Value(_list{@Value

I would like to group all the features going to the writer and create a report on what is written to an excel document. I would like to have it similar to the log file format. Total Features WrittenManhole 3 features writtenPower_Pole 8 features writtenetc..I'm working with the list builder, just not getting much progress. I believe I need to group by feature type and expose the feature type?Thanks for any help on this.

I use WorkspaceRunner in master workspace to run some specific tiling operation by slave workspace. Nothing special. Slave workspaces are done about several seconds each. Workbench run only one fme.exe process no matter what is set in WorkspaceRunner transformer. Any idea what can be the reason?

In an excel file, I have 6 checkboxes. In my process, all the value are put in a single list called Method_ID. I have to manage each half in two different way. So I have to put 3 in a second list, and the other 3 in a third list. Because the following process needs a list for the input.If I use a ListBuilder to make the second list, I can't make the third in another ListBuilder as you can see : Do I have to use the ListBuilders in parallele? The problem is that I'll have to manage the amount of object later.Thanks for your help.

Hello,I would like to use a workspace runner. I have a reader with several features and I want to take one feature and run my workspace, then take another one, run the workspace...Is it possible?

I would like to know is there a possibility FME can control how many features workspace reads before translate data. I have a gz file that contain 100k features but I only need to extract 1 x feature from the gz file.

I'm processing LIDAR data against NYC BBLs(a unique number for each lot). The BBLs are in a shapefile and I'm checking intersections between the elevation points and the BBLs. After I've intersected the points and added in the BBL to which they belong. I want to output a file for each distinct BBL that has the points inside it. Could anyone provide guidance?

Hi there  I would like to use the WorkspaceRunner to start one Workbench several times through a published input-parameter (e.g. the database-connection details of a Oracle DB), e.g. for merging data from several political entities into one superior entity.  Therefore you have a Workbench that processes the input data and writes it to a table of a DB, a text file that contains the input parameters of the DB for the writer of the mentioned Workbench and a second Workbench consisting of a WorkspaceRunner. This WorkspaceRunner reads one line of input parameter after another and starts the workbench each time with the respective input.  This would not be a problem itself. The difficulty is that before/at each start of the Workbench containing the WorkspaceRunner, the table should get truncated once so that only the new set of data is contained. If you activate the 'Truncate Table First' format parameter of the writer, the table will be truncated at each run of the Workspace. So you

Hello: I read features into a Feature Writer to write into an Macro Enabled Excel document (Sheet 1) and use Feature Reader to read from Sheet 3 from the same Macro Enabled Excel document (where I write into an Excel document a single feature that meets a set of specified conditions). From my observations, it appears as though the Feature Reader goes back and reads the Excel document from before it was changed (from the Feature Writer) irrespective the number of times I run the model. May I ask if anyone attempted anything comparable to what I have in the workflow shown below? If so, did you experience comparable difficulties? How did you resolve these difficulties?

Im using an aggregator to merge some features and some of the fields are integers but I wish to concatenate them like strings, i.e 12,24,106When I attempt this in the aggregator it has an error as the attribute it is writing the concatenated value back to is number format.How can I change the type of these attributes to string before they enter the aggregator?Seems I can find plenty about converting string to int but not much the other way around.Thanks for the help

Quite an odd error here. We have one workbench that calls 3 others through the FMEServerJobSubmitter transformer. We are using Named Database Connections as they are shared through the 4 workbenches.When using one Named Database Connection, we'll call it My_Conn, it works in the 1st Workbench, then the second, but when it is called in the 3rd workbench, there's an error in the workbench, and through going through the logs, it shows as this:  2016-05-27 15:50:45| 0.3| 0.0|INFORM|Opening POSTGRES reader for dataset 'MY_CONN' 2016-05-27 15:50:45| 0.3| 0.0|ERROR |Error connecting to PostgreSQL database(host='', port='', dbname='MY_CONN', user='', password='***'): 'could not connect to server: No such file or directorySo it is effectively saying the Named Connection is actually the dbname in the connection. It isn't, and this has worked previously in the previous workbench Any ideas?

Dear all,I have a (parent) workflow that uses an Excel file as input. The file contains string values which are used to query an API on the internet. Every record contains a different querystring. The actual calls are made by a workspace which is used as a workspacerunner (see the first image). In that workspace I have exposed returned fields as attributes (see the second image). The problem I am having is that I expext a number of attributes coming out of the workspacerunner, but I only get two, which are the input attributes of the workspacerunner. How do I make the workspacerunner spit out the right attributes?

Is there a way to expose format attributes with values only?

To whom this may concern:With the current workbench I'm trying to execute, I'm trying to sort through the attributes before following through with a loop (e.g. ). With looping (as shown in the screenshot), however, I receive an error message which reads as follows: "ERROR |Transformer/Factory PolynomialFunction_Sorter_2 is blocking and cannot be used in a loop, but was found between 'Loop to PolynomialFunction_Polynomial_Function_Loop1468337910 Input Splitter' and 'PolynomialFunction_Polynomial_Function_Loop1468337910 Input Splitter'". May I ask if there are any ways with which I could sort the values (working with an Excel worksheet as the reader and am looking to write to another Excel worksheet) in a loop without receiving the error message?Best Regards,JE6THOMA

The number of DGN feature types read by the featurereader transformer varies by project and I want to use the fme_basename attribute in a tester after they have been filtered by either the attributeFilter ot FeatureTypeFilter. There is no standard for the fme_basename on each project. Any suggestions?

Is there a way from the rest API to check what jobs are currently running? I have my users submitting jobs to run asynchronously and I would like to make sure that job isn't already running before they try and submit. Is there a way to see when a job was last run?

Hello,I'm trying to split a value in an attribute into a list of values:e.g. Attribute colour has value "red; blue" and I want to split the value by ";" to a list "colour_list{}.colour"Any ideas? Thanks, Moni

Hello,I have several workspaces on the Server which I call from a parent workspace (also on the server) using FMEServerJobSubmitter transformers, to chain them together. Each workspace works fine when run on its own, but the parent workspace does not run successfully. However, the parent workspace works fine when run from the desktop (still calling the workspaces from the server). Is there any possible reasons for this?

I need to validate all attributes of a dataset. This can be done using a single AttributeValidator, but that gives me the following problems:- It gives multiple errors on missing mandatory attributes (first error would be something like 'attribute fails check for <attribute> is not null', the second error could be something like 'attribute fails check for Maximum Length =12'). If a mandatory attribute is missing I only want the first error message as I know all other checks will fail.- It gives unwanted errors for optional attributes without value. I only want to check the value if there is a value.I have solved this by making parallel paths in which each path checks one attribute. For optional attributes there is first a Tester which tests if the attribute has a value and next there is the AttributeValidator. For mandatory attributes the path consists of two AttributeValidators: the first checks on 'Not Null' and the seconds checks on 'minimum length&

I have a project in which I expose a attribute. This attribute is used several times in my project. So, I just draw the same amount of line between the output of the attribute creation and the many input I have.So, the result is a project with a spider web, not really userfriendly to work with.Is there a transformer to "export" an attribute into a published parameter?This involved that the published parameters is initialized to NULL. Is that possible?

One of our customers wants to read an Oracle database through Cosmos of IBM. Does have somebody experience with this?

Hello,I am trying to identify line features with vertices that are very close together (such as 10cm), so that these lines can be simplified. I would need to identify the individual line features with these vertices, and find a way to delete such unnecessary vertices, if possible. Is there a way to do this?

Hello,I'm reading a SHP file, splitting it into tiles and I want to write each tile into a separate XML using my own XML template (XML Templater -> XML Formatter -> AttributeFileWriter). Is some kind of fanout possible on AttributeFileWriter?Thanks for help, Moni

Hi,I've tried to wrap some specific functionality in a custom tranformer in Workbench, and have defined a parameter (in the custom transformer) to be the name of the new attribute containing the output I'm calculating.I'm creating the value into a temp local attribute (for a reason, I'm deleting it at the end), but cannot apparently rename or copy this temp attribute to an attribute with the configured name ?Cheers Lars

I have some data that need to be filter first and then calculate Values count of WO, Average of Age, and % of age.1. I need to filter out work order that are CM, PM, CAP and MM. I have done that using Test Filter,2. I need to then filter our CM's with HOLD status. I have column that is HOLD and has different status. I need to calculate CM's that are not on hold and CM's that are on hold.3. Then I need to Count the work order, Average of age and % of AGE for all work types.I am not sure what transformers i need to use the filter. I need your help.