Authoring

Hello,I have a workspace that reads data from an API using the HTTP Caller. The API contains Wildfire data and I added query parameters to pull data for a single fire. I set up the workspace to dump the data into a Google Sheet. I'd like to push this to FME Server and have it add a new row and put the "updated" data in that new row. In other words I'd like each successful run of the workspace to result in writing a new row to the Google Sheet.I've played around with all of the default options in the Google Sheet writer but cannot seem to figure out which (if any) of them will create the results I'm looking for. Does anyone out there have any experience with something like this?Thanks in advance for any advice you might have.Cheers,Ben Butler

I have workspaces published in FME Server and have created a web form where users can upload zipped-up file geodatabases which get processed and loaded into a master database. Now some users want to automate that process using Python so they don't have to use the web form but can have a Python script that can be set to run automatically once a month and upload the data. I have seen bits and pieces of code and functionality which are tantalizingly close to what I want to do but not quite. Has anyone out there ever done this?

I have a Shutdown Python Script wich run a system terminal command. In this command I have to write the name of different pdf files. My problem is that the names are written directly in the command. I prefer to write the name of a variable wich refers to a file name. Is that possible in the shutdown Python script?I also find the transformer SystemCaller. Maybe it's a better idea. But, my script have to be run à the very end of the project.Do you have any advice please?

I am trying to find a 500 different words in a body of text that's held in a description variable using something like testfilter "contains" but don't want to write out all of the 500 words and just want to do some sort of quick join but having the flexibility of it finding the text anywhere in the description (I can do it manually by adding an entry for each word, e.g. one table holds the descriptions such as "today it will be sunny with showers" and in another table I have my 500 flags in this example "Sunny" and want to create a new variable in the table which has the description value so "Sunny" is in the new value

I have a python shutdown script that works fine in FME Desktop but when I try to run it in FME Server it fails. The logs aren't showing me anything useful.I think the error may be due to my file path that I am trying to access. If I am trying to access a file via Python on the server, shouldn't I be using: r"//servername/directory/filename.cfg"?Or should I try something else?Thanks, Mark

Hi all, We're batch processing a lot of sqlplus commands and FME Workspaces (with parameters). However, the FME Workspaces only say "failed" or "success" and I would like them to talk more ;-)Like reporting "1034 records written" Is there a way to send a message from the workspace to the terminal / dos prompt?It doesn't have to be a customized message per se, it could also be a relevant portion of the log (only the part where it displays the amount of records read/written?).Best wishes, Annet

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