Authoring

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,

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.

Hi I would like to calculate the coordinates of the centroid polygon feature class without changing the geometry type to point. Is this ,Hi is it possible to only get the coordinates of the centroid of a polygon, without altering the polygon. I have tried CentrepointReplacer this replaces the polygon with point feature?

I know there is a File/Directory Reader but I don't want to read the whole directory of files.I'm trying to find a transformer that I could use in the work flow that exposes file properties ie date created, date modified. Reading a polygon with an attribute "ABC123.PDF" and test with a FME Store FileExistenceChecker filter. If exists get the modified date of "ABC123.PDF" and push in an attribute.This should be possible with a PythonCaller or TCL but is there a Transformer I missed before I try to write one.

I have to filter out data based on a lot of values. Lets say, 50 values out of a 1000. I am using AttributeFilter for that and it works great, BUT it takes a lot of time and is extremely inconvenient to enter every attribute value and connect it. I could manage to copy many values from Excel, and when pasting them in I get something called 'multi-line' and I could connect only that one. It would be great if that would work. However, it doesnt. Plus judging from documentation Im not sure its designed for this purpose, but its not clear.Can somebody advice me something, please. Or explain the purpose of multi-line within AttributeFilter. Thanks a lot! P.S. I work with CityGML data.

I'm working on a large project which involves 100's of FME workspaces. Each time we have a project release we would like to be able to "tag" our workspaces with a build number (not the FME build number, a project build number). We would also like to be able to check if the current version of a workspace deployed in FME Server is at the current build.FME itself is not designed for any of this but I am playing around with the idea of a hack that could be useful: write an FME Workspace to iterate through a directory full of existing FME workspaces and update the "Legal" (or any other) workspace property to add the current project build number.Does anyone know if it's possible to use FME to edit workspaces in this manner?I do realize that kind of job is what source code version control systems are for and we are already using GIT to manage our source code repository. This idea really relates more to FME Server and being able to discov

In the FME ,we have included python startup script. When we run it in FME 2014 version, it showing an error like : name 'dbCursor' is not defined.Could you please temme what would be the reason?

Hi, How to protect a custom transformer with a password ?Thx