Authoring

Hello kind people I have a workspace which brings in two datasets, each of which holds a property reference number and a name. What I need to do is compare the similarity of the names held in each dataset for each property. Both datasets have multiple (but different numbers of) names per property i.e.DATASET 1:1, BOB1, ANNA2, TEDDATASET 2:1, BOBBY1, TINA1, IAN2, TIM2, BOBWhat I want to do is use FuzzyStringComparer to evaluate each record in dataset 1 against all other records in dataset 2 which share the same property reference number.So in the example above, the highest value FuzzyStringComparer would return would be for property 1 (BOB v BOBBY).Can anyone offer any suggestions on how best to approach this?Thanks in advance, Riley

I have a PythonCaller with an input function as usual. In this function, I have a list to update.myList = [toto, tata] if cond1:  myList.remove(toto) logger1  myList.append(momo) logger2 if cond2: myList.remove(tata) logger3 myList.append(mama) logger4So, I want to obtain at last, myList = [momo, mama] But, if I check the loggers :  logger1 : [tata] (all right) logger2 : [tata, momo] (still all right) logger3 : [toto] (as if the list reseted) logger4 : [toto, mama] (so not quite good)I think the problem come from the fact that I have two objects coming in the FME project. Is that right?How can I save the first change?Am I missing something? 

Hi I have a question which I think is simple to answer but I'm struggling and in a rush...I have a folder with 1000+ excel files all named the same except for a 3 digit code at the end of the filename string, before the extension. I then have two data layers of file for each code. I need to extract the two excel workbooks that have matching 3 digit codes into one workbook, with each of the two data layers going into a separate worksheet.eg. example filesLondon_123_Cars_ABCLondon_123_Buses_ABCLondon_123_Cars_DEFin this example I need the two files which end in ABC (3 digit code) to merge into one excel file with a sheet containing the 'Cars' data and a sheet containing the 'Buses' data.i've tried exploders and lists but struggling so any help? the more detail the better, thanks in advance

Hi,I have an FME server job submitter workbench. A creator submits the jobs, then goes to a job waiter and logfile retriever.In order to not tie up an engine with the submitting bench due to the job waiter, in 2016 I write job metadata to a spread sheet using a feature writer and then output to another job submitter that has the job waiter inside that set to run last.If that job submitter detects any failures, it will attempt to rerun that bench once more (and only once more).I want to be able to write more metadata to the same spreadsheet, and have the bench that runs a second attempt at failures, dynamically run what the spreadsheet says to be run again. What we do now is copy the original Submitter bench, and then use a manually defined attribute filter to match workbench names from the spreadsheet to do the second run.Anyone have any ideas on how I can achieve this? Thinking HTTP caller with some of the system server parameters exposed from the original Submitter on server. But som

Hi,I have just tried to use the snippet supplied by Safe to run a Workbench from python and i get the following error TypeError: descriptor 'runWithParameters' requires a 'fmeobjects.FMEWorkspaceRunner' object but received a 'str'This is my code so far up to the point where these is the error:#initiate FMEWorkspaceRunner Class  runner = fmeobjects.FMEWorkspaceRunner  #Full path to Workbench workspace = r'C:\\Avoidance_Areas\\shape2acad2016.fmw'  #Set workspace parameters by creating a dictionary of name value pairs parameters = {} parameters['SourceDataset_SHAPE'] = Avoidance_Area_shp parameters['DestDataset_ACAD'] = r'C:\\Avoidance_Areas\\Avoidance_Areas.dxf'   # Use Try so we can get FME Exception try:  # Run Workspace with parameters set in above dictionary  runner.runWithParameters(workspace, parameters)Can anyone tell me why its having this issue as im following the supplied code template.

What information can a shutdown script access? Can I see where the data was written?

I'm trying to create a series of attributes based on values of other attributes (I have some FieldName/FieldAttribute combos that I want to turn into attributes on the feature). When I create an attribute called @Value(FieldName), anything I output to the Data Inspector won't show. It just shows ? row(s) and doesn't load anything. Is this a bug or am I missing something?

First let me say that I'm extremely new to fme environment.I have a shape file that have lines with or without elevation. My problem is that i need to separate these 2D lines, and to set the elevation base on 1 attributes in the feature and also export the other 2D lines that has the very same attribute null.These 2 types of lines need to be exported separately.In one export i need to export all 3D features (including the original 3D and the one that i created with the attribute value) and in the other one only the feature that has no elevation

How do I ensure that my workspaces still work in a newer version of FME?

I have a project wich produced a parameter I need in the shutdown python script. The problem is I cannot use it. Maybe I can but I don't know the protocole.A solution would be to "send" the attribute into a published parameter and then use the published parameter into the python script.But I dn't know how to do the "send" in this scenario.Any ideas?FYI : the attribute become a published parameter in a following workspace. Maybe I can catch it from there.

Hi,I have a vector layer with polygon parcels classified by type. The class for each polygon is stored in an attribute, and there are 20+ classes. I want to extract parcels based on class and process them as separate features. The picture below shows what I want to do. The custom transformer and the dwgstyler apply the same transformation to all parcels, no matter the class. So, I guess a loop can do the job instead of manually separating each parcel type and apply the transformers as in the picture. I could use a ListExploder, except that this transformer destroys the geometries. What would be a more efficient way to perform the workflow below?

Hi. I have to create workspace in FME2015 and I need to fill specified Published Parameter with Environment Variable. How can I do that? Via startup script or something else?

Hello FME User`s,I have a problem with my Script python. I have two values attribute tamanho: 256,757. I break this inside Python script and generate a list values.I need to generate two attributes for theses attributes tamanho: inicial{} and final {}. For the firts register is OK: inicial{0} and final{0}But when execute inside this script to second register is wrong.The results right it will be to second register:inicial{1} = final{0} + 1final{1} = inicial{1} + attribute lenght this list ( int(listaTamanhoTrecho[controle] )) Attached my template.

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 attribute 'amenity', skipping attribute 'amenity'S

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)        #pprint(FGDB_ID)        for id in FGDB_ID:            print(id)        pass    def close(self):        feature = fmeobjects.FMEFeature()        se

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?