Authoring

The problem is after opening a new workbench, It takes long time to establish connection to fme server. It hangs at 'Waiting'.Then I try to use CurrPorts to see what is going on in the background.I discovered that 5 connection requests were generated after opening a new workbench.And workbench seems to make iterative connections to 54.192.131.X | server-54-192-131-X.ams50.r.cloudfront.net | 443Workbench refuse to send connection request to fme server until the above connection is closed.Any Ideas?/Xin

Hey folks, I'm trying to accomplish a fairly simple thing, which is to create a workspace that can read, transform, and write different Spatialite files with different attributes. I'm pretty certain that I've been able to do this earlier with other formats, but I can't get it to work with this format. The problem is that when I add a Spatialite reader, selecting "Single merged feature type", the attritbutes from this file are read and added to the feature type. Then, if I change the file source to another Spatialite with a different set of attributes, i get the message SPATIALITE reader: Feature type 'natural' does not contain an attribute matching the schema attribute 'landuse', skipping attribute 'landuse'SPATIALITE reader: Feature type 'natural' does not contain an attribute matching the schema attribute 'leisure', skipping attribute 'leisure'SPATIALITE reader: Feature type 'natural' does not contain an attribute matching the schema a

Hello,does anybody know how to extract attribute values from DGN from Intergraph´s FRAMME software? I only found possibility in FME Reader (pic below), where I can match Linkage extraction of FRAMME. Is anybody there, who met the same problem please?Thank so much!Lubo

Hi, I want to read only one Attribute(FGDB_ID) from a File Geodatabase with Python.The geometry is not required. The readout of the File Geodatebase works well, but no features are generated. The Attributes will be printed only in the log window, but no Features will be generated.How can I create features from the individual values?import fmeobjectsimport arcpy# Template Classclass FeatureCreator(object):    def __init__(self):        # Name der FC        fc = "\\\\path\\gdb.gdb\\GK_ANNO"        # Ergebnisliste        FGDB_ID = []        # ArcPy-Suchcursor erstellen und auf die entsprechende Spalte der FC        # ansetzen.        cursor = arcpy.SearchCursor(fc, "", "", "FGDB_ID")        # Spalte zeilenweise auslesen...        for row in cursor:        # ... und FGDB_ID an Ergebnisliste anhängen.            FGDB_ID.append(row.FGDB_ID)

Looking for suggestions on how to parameterize my workbench so I can finish my translation by sending the zipped dataset created by a featurewriter. Should I email with an emailer/terminator or just use the python shutdown script to send the email? Is there any difference?

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

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 trun

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 idea

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

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?