Authoring

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.

I have a bit of a convoluted workbench at the moment where I take in an AutoCAD level as a Reader which contains some blocks (stop & yield signs). I pass this through an AreaBuilder which makes it's way to a centerpoint replacer. The output is a Point feature within a Sequel DB. I'm trying to maintain the rotation of the signs so I can associate a bmp symbol to the point and have the proper rotation. (so the stop signs read the correct way).The AreaBuilder appears to be dropping the exposed attributes from the reader, in particular the 'autocad_original_rotation' and 'fme_rotation'? which I essentially want to feed to the Writer using the Rotator transformer...

Hello there!I use BulkAttributeRenamer to add a Prefix to all Attributes of two tables I need to merge as they both have the same attribute name.Often when I load a FME Workbench the BulkAttributeRenamer transformer is broken. It does save all the options, but simply doesn't work. The output features show no prefix and the following FeatureMerger does not work, as the attribute names don't fit. Does somebody know how to fix this problem?

I'm using a PDFPageFormatter. From the output, I'm using a writer to create my pdf file.I want to use this pdf file to merge it with another, thanks to my python script. I know I can write my python script in WorkspaceParameters/Advanced/ShutdownPythonScript.But I don't feel it's a clean method.I'd like to directly connect the output of the PDFPageFormatter into a PythonCaller and use the pdf file as an attribute for the PythonCaller.Does anybody have a knowing process to handle that? 

Hello, probably this is something easy to achieve but I'm still new to FME. I'm reading a set of points from a DWG file. These are definition points from a dimension feature. Each dimension object has 3 definition points, but there is no dimension ID. All that I have is a set of points listed consecutively; the first 3 points belong to one feature, the next 3 points belong to another feature and so on. I want to group all points using a count or split rule but so far I can't find a way to implement it. Here is an example of what I want to accomplish. Count   fme_feature_type1  Dimension |2  Dimension      |--> Group 1 3 Dimension |4 Dimension | 5 Dimension |--> Group 2 6 Dimension |Thanks 

I want to send an email at the completion of a workspace. If 300 features pass through to it, will the Emailer try to send 300 emails? If so, how can I just send one email?

I used a writer with the following code (working OK):FeaturesWritten = str(FME_FeaturesWritten) fcno = FME_FeaturesWritten.get(fc)But i have changed it to a feature Writer (not working anymore): result is Nonewhat should the code be to get the number of features written?_total_features_written is the attribute in summary