Authoring

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. Setting the value to 'no&#39

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,

Currently I am using FME 2015 and a project I have completed reads a xml and writes the data it sends to a database and then sends a email saying weather it worked or did not work. I am using two workbenches with a workplace runner because I have to know if it wrote or did not write to the database table. I know using FME 2015 i either had to use the workplace runner or a python shutdown script. But in FME 2016 the feature writer has a output. I was wondering if I could somehow use that to my advantage and use that output features in someway to pass the data along so i did not have to use a workplace runner and two transformers or a python shutdown script to know if it wrote to the database or not and then send a email based on success or failure. This is being done in FME desktop not FME server so I cannot take advantage of the server emailing ability.

I am trying to set formatting for a feature type to change into a microstation dgn file, but I can not figure it out. Please help!

I am using the following python code (from takashi) to run a workbench (Python 2.7 & FME 2013):  >import fmeobjects >wr = fmeobjects.FMEWorkspaceRunner() >wr.run('C:/blab/blabla.fmw')  It works fine but now i would like to get more infos about what was going on, like logfile message, numer of feature written and exit status... is it possible?? If yes, where can i find examples and docu? The local fmeobjects api docu do not mention FMEWorkspaceRunner etc...  I now i can get it to work and access all those infos via an embedded shut down python script, but i would like to do it the other way... 

Hi all,  I've recently built a workbench file/workspace to facilitate a conversion of data. It works on the files I've been given.  I'm using the 2013 version, and have included some Chopper transformers in the work flow. The client - it now appears - is still running a 2011 version, and running it on WinXP too.  The client's FME Workbench issues an error about "Chopper" being for a newer version when opening the workbench file, and fails to produce any output data.  What are our and the client's options to remedy this unfortunate situation ? The client cannot upgrade unfortunately, as his department is currently under  decommisioning.

Hi, i have been following the raster tutorial and working on clipping. The tutorial notes that i should be able to add a transformer by clicking in the white space but this only seems to allow me to add a constant.   Is someone able to help me understand what im doing wrong.  Thank you  Carolyn

Hello,i would like to do an attribute test on a certain criteria using the tester. Since the criteria varies (geb8_32368_5745_2_TILE_1, geb8_32368_5745_TILE_2, etc.) , i would like to publish this criteria and then create a batchfile with individual command lines per criteria.I have created a new published Parameter. Then i have tried to connect this Parameter to my testclause but i does not work.

Hi.  I'm not an expert user of FME Desktop and am wondering if you can help solve this problem.  I am trying to use basic statistics to separate my data.  Here are the details:  Start with a set of polygon features with attributes.  Choose one numerical attribute. Calculate the standard deviation.  Next, decide the range of acceptable values (i.e. values up to 2 standard deviations from the mean).  Compare the attribute of each feature against the standard deviation.  If the attribute for that feature is outside the range of standard devitations then direct it to a different path/port.  The features that fall inside the range are directed into a different path / port  Can someone help coach me on what transformers I need to do this?  I appreciate the help.

Hello all,I have a Folder with subfolders:How can i get the names subfolder with python? Thanks in Advance,

I am brand new to FME Inspector 2015.1 and for some reason the Feature Information window would not "go away" every time I clicked on a Feature. I thought I had it disabled in the Window Menu but for some reason it wasn't. I want to see REAL data about a layer, not vertices and colors and whatnot. How hard is this?

Hi,  I have a massive amount of points within a country (++15Million) which represents addresses. [1massive csv file with lat/lon] and I also have a huge amount of Polygons Area (++30k) which covers a number of  area location.  [multiple .tab files]  I need to get the number of points inside each polygon area  What would be the most optimised way to achieve this?  I am thinking of using a workspacerunner approach towards selecting 1-by-1 each polygon area mapping it out on the 15++million points however It would take a very long time to achieve this.   Is there a quick spatial approach on filtering to minimize the reading of the number of points, say it will only read within a certain area and not throught the 15million points?  thanks in advance  kind regards, Jubert   

We have FME ESRI Desktop edition, no FME Server, and want to start versioning our files so we can go back and see how an older version of a translation is configured.  Other than manually doing a save as in Workbench and renaming files, does anyone use a tool for versioning their translation files?  We have SubVersion in house, but are in the process of seeing if this will work for FME files.  We used Visual Source Safe in the past and Team Foundation Server, but both were clunky and we don't own them anymore.  I'm open to suggestions!  Thanks.