Authoring

Hi all,I created a little test in order to compare the performance of python and FME.  For this test I created a CSV-file containing information of 1 000 000 people (ID, SEX). The goal was to count the number of men and women in this list. I created a very basic Workspace with a reader, StatisticsCalculator and Logger in order to answer this question. The Workbench completes in 45 seconds.When I do the same using only pythoncode, the result is print in 2 seconds.Why is there such a big time difference between those two?I know that the startup time of FME has to be taken into account (less than 3 seconds) and the reader converts the input to the FFS-format which will take some time. But I am sure that when I would change the pythoncode so that the features are written to an SQLite database, it wouldn't take 45 seconds to complete.Can someone clarify this for me?Thanks!  (the CSV contains only 500 000 in ste

Hi!We are using FME Server 2015.1.1 and are now facing a problem with the keywords {workspace} and {repository}, in our case these both keywords are missing in our Job submitter success email. Other keywords like {jobsuccess_topic}, {timeStarted} or {timeFinished} are working fine...any ideas?Thomas

Can FME Server be configured to multiple jobs run on a single engine?

I have an attribute creator running to replace missing values with "NA" in a dataset. I noticed however that if the attribute had parenthesis (e.g. "Actual Values (oct-dec)") would replace every value with "NA" regardless of whether it was missing. Removing the "(oct-dec)" from the attribute name, however, returned the desired result. Can anyone else confirm this or had this experience?

Hi all,I'm looking into running a workspace which is located in a read only folder. If I try to run the workbench I get the notification 'Cannot run workspace 'location' from it's current location because the containing folder is ready-only. Try saving to a new location and continue'. The reason why I would want to do this is about policies ofcourse.I've gone through the basic options in FME workbench itself but cannot find anything related to this. I'm wondering if it's even possible?best regards

Hi all,I am trying to use the module matplotlib inside FME itself so I can create histograms and store them on my hard drive. I installed matplotlib in my standard Python 2.7 - 64 bit interpreter (the one that is used when you type 'python' in the command prompt) and I use this interpreter in pycharm (C:\\Python27\\python.exe) where everything works smoothly.Now I would like to use this interpreter inside FME but I cannot get it working. I checked the internet thoroughly and tried already a lot. I didn't try to install matplotlib in the FME python interpreter since I use different versions of FME.I tried using the following dlls:C:\\Windows\\system32\\python27.dll (but this is 32-bit so it shouldn't work I guess...)C:\\Windows\\SysWOW64\\python27.dll (but this generates an error)

Hey All,So i'm running a pretty intensive FME workflow consisting of multiple workspaces, some memory intensive and some which i didn't think were too bad:Workspace 1: clip large dataset A by large dataset B;Workspace 2: take large dataset from postgres rename some attributes and push back into postgres.My problem is...the memory intensive workspace (workspace 1) ran successfully, but the workspace 2 terminate unexpectedly with the following error:WARN  |The system is running low on memory. FME is at risk of being terminated by the OS. Please read the FME Help section 'Adjusting Memory Resources' for workarounds.I'm running 64bit FME2015 on a linux box with 32 cores and 64G of ramSo to get the above error is odd. I though 64bit versions of FME managed the memory usage?I though that as FME should be managing the memory...that as the workspaces are run sequentially one after the other, that the possibly the memor

Would someone be able to recommend the best method to batch geocode addresses using a local geocoder in an FME workspace? Ideally I want to read addresses stored in sql server table, use HTTPCaller to call the service and output returned coordinates plus address and uid to another sql server table. Is it possible to do it this way?

I am trying to send an email using the PythonEmailer.This works fine if I use the smtp.gmail.com server.But I can not get it to work with the smtp.office365.com server TLS and port 587).Has anybody got that working.Any help is appreciated.This is the error message I am getting:Python Exception <SMTPException>: SMTP AUTH extension not supported by server.Error encountered while calling function `email'f_8(PythonFactory): PythonFactory failed to process feature

I have a lot of shapefiles with the classification in the name of the shapefile and not as an attribute. How can I create an attribute containing the name of the shapefile?

I've been asked to see if its possible to maintain values in a coded domain on an ESRI Geodatabase. I would need to insert, update, and delete code/description combination records in the domain. I've found this article: https://knowledge.safe.com/articles/886/working-wi...but it's referring to updating a table that uses a domain, not the actual domain.I know FME can call a python script like this from within FME...arcpy.AddCodedValueToDomain_management(in_workspace="H:/MyDocs/geodbs/inspections/Inspections.gdb",domain_name="Structure_No",code="ABC-123",code_description="STRUCTURE 123")But can FME do it directly?Thanks, Sarah

I am just trying to read from an MS SQL Server non-spatial database, but the reader is not available in my list. I am fairly new to FME and cannot find the reader described in the documentation as "MSSQL_ADO". I have "MSSQL" but it doesn't allow me to enter parameters. What am I missing?

I use RadiateLineGenerator, Intersector and AreaBuilder to produce a sector diagram. I have problems getting the values into the sectors. By building list in AreaBuilder all the attributes from the intersector is preserved in the list. The problem is that I dont know which of the list elements to use. AreaBulider generates a format attribute named direction (along with fme_gemetry and fme_type). If I test on the value of direction ('same' or 'opposite') I can find the correct element in the list. How can i retrive then vaule of a format attribute?

HiI am new to FME. Coming from ESRI background and FME terminology is new to me.I have 30 or so workbenches - some of them are called something_controller and other of them are called something_runer They see to be just regular WBs - doing some stuff to data. I don't see any relationship between a controller WB and a runner WB, e.g. controller calling the runner in any way. Being new I am not sure if this is at all possible.So do the naming suggest any relationship between WBs or this is just a term in the naming?Thanks

Hihow can I create an empty txt-file with the python startup script?That file has to be into the same directory, where the data in the workflow will writen to. So I will need the "DestDataset_SHAPE" as the directory and "LTYP.mif" as the filename.Thanks very much for your support.

I have a couple of named connections set up in FME Workbench and they're currently stored in the default location (wherever that may be). How would I go about migrating those to a shared set of named connections on a network drive?At first I was able to right-click on a named connection, choose export, save it as a .xml file, then specify a named connection file in the Default Paths tool (which creates an empty one) and import the .xml file there, but after a restart of FME Workbench that right-click option has disappeared. Happens on both FME 2015.1.2 and 2016.

The clause 'FACTORY_NAME AttributeCreator ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV' within 'FACTORY_DEF * AttrSetFactory FACTORY_NAME AttributeCreator ATTRSET_CREATE_DIRECTIVES _PROPAGATE_MISSING_FDIV INPUT FEATURE_TYPE StringConcatenator_2_OUTPUT ATTR Nom_dossier Pentes_des_pistes OUTPUT OUTPUT FEATURE_TYPE AttributeCreator_OUTPUT' is incorrect.  It must look like: FACTORY_NAME <name>  This error just appeared. It's the first time I see this and I don't understand it at all.  It appeared with a script I've been using for a long time without any problems ; until now.  Please can someone tell me what this is about, it's urgent ! Thanks

I have a Shapefile with 9000 records and one of the attribute columns contain strings (numbers and letters). Column width is set to 4 characters I need to find all records with last character is a "letter" and delete that letter.ie: ST4WS4WAbove records I would like to delete "W" from the recordsCould someone help me to do this using FME?thanks

Hi all,I ran into the following problem:i have a workbench which has a workspacerunner, which calls several child workspaces. Each childWS will created a file: <xxx(number).dwg> . The duration for each childWS is different (some take seconds, some 15min). Behind the workspacerunner there is a featureholder followed by a custom transformer which is the combination of a decelerator (timing every 30sec) and a FileExistancechecker in a loop. In the end all dwg's are grabbed and thrown into one big file.My issue now is that i would like to speed things up. Now i have about 70 child WS so right now i'm waiting about 35min for all things to go through the decelerator. (i wish to increase the amount of child WS, setting the timing to a value less then 30sec is not good because <xxxF(number).dwg> are then missed to be thrown into the big file in the end.Setting the workspacerunner to wait for job to complete makes me miss the multicore speed. S

I am converting Ordnance Survey mastermap in gml format (which comes in chunks) to .dwg format for use in AutoCAD with the added twist of creating a separate .dwg file for every OS 1:1250 grid. To achieve this I am reading in an grid file and then using fanout by attribute (the OS grid e.g. SE0007NE). I would like to produce a series of folders named after the OS chunk with the corresponding .dwg files inside. When I use batch deploy and select 'retain source dataset basename in destination path' a folder is created for the first record but it is empty and all the .dwg file fall outside it. I have see other posts on here which suggesting using fme_basename for the fanout, but I'd like to retain my original fanout (OS grid). Is there a way of fanning out by basename directory and another attribute?Any advice will be much appreciated. Thanks :)

Hi. I have a table with an attribute with string values such as "39.1234". I'm trying to extract the integer of this to a new attribute using Python. So something like this import fme import fmeobjects def processFeature2(feature):  vStartMiles = feature.getAttribute('Start_Mileage')  vStartMiles2 = int(vStartMiles)  feature.setAttribute("Start_Miles", vStartMiles2) However, this code gives the following error and i've tried various other options without success. Any ideas how to to extract the integer from a string with Python? Thanks

Hi,I am not sure if its possible but yeah. I have a workbench with only 2 WorkspaceRunner transformers where both the workbenches uses HTTPCaller and fetch the data from web.The input which the first workbench takes is using the different URL all the time and every URL gives a different output (I have a list of URLs). The second workbench runs normal using 'wait for job to complete'.Can I use the batch processing mode on one transformer only or is there any other solution for that.

I have a large table with 80 columns and 10 million records already in a postgres database. Most of the data is really numbers there are some NAs where an external process encountered blanks in the dataset. I want to convert the data table to numeric format and to do that I need to get rid of the NA values, any suggestions on the transformer and whether I need to apply this to all fields one at time? I was thinking of using the Attribute Calculator.

So this is very basic question...I'm a super newbie :)I have a GDB that has right-of-way lengths (called CurrentROW) and I wanted to merge the features that had similar lengths. First I kept the attributes that I wanted and then fanned them out into a new shapefile. Now I want to take the similar shapefiles and merge them into one. The picture might help...I have three shapefiles that all have the same attribute information but were named different. I just want one shapefile that has all three in it.How do I do this?

Hi, I was wondering if it is possible to trigger an FME workspace to run automatically if there has been an edit to a Reader feature?I thought maybe the FMEServerNotifier transformer but don't think it is the right method..Thanks,