Transformers

I'm testing a workflow that permit to rollback all the changes made in a workbench execution. There is a possibility to rollback some operations from start to end including the truncate operation?I have a workflow that read data from a source and write in another one. Writers are set to truncate. If the write process has an error and the workbanch has a failure the truncate process is commited. I'm not able to rollback before the truncate step. Anyone has an idea?A possibility is to have a staging area and if the workbench is completed without problems a second workflow start with the real update from staging area to the work area.

I have a PDF file which consist of few pages (2-3). When I run the translation see attached , the results are 2-3 sepatated files. I need to have them as an JPEG but as 1 file. I have no page numbers to set an attribute pdf_page_number. Have a houndreds of those files. Some of them have only 1 page but some a few pages. So I need something what will also recognize what has more than 1 page.

Dear all, I having problems with writing an - character in a fieldname. If i chance it to - then FME will automaticaly change it to _ (underscore) do have have a idea?I use the writer Spatialite. FME 2017.1. If i manualy change it to - then FME changes it to _....

BonjourJe cherche une solution pour mesurer la longueur d'un solidej'explique je cherche a identifier des lignes qui coupent des solides pour cela je transforme les lignes en solide avec un bufferer et les passent dans un clipper ensuite je voudrais mesurer la longueur des lignes qui sont dedans et hors du clipperil me faudrait la meme fonction qu'un centerline replacer qu'on utilise pour une surfaceHello I am looking for a solution to measure the length of a solid I explain I am trying to identify lines that cut solids for that I turn the lines into solid with a buffer and pass them in a clipper then I would like to measure the length of the lines that are in and out of the clipper I would need the same function as a centerline replace that is used for a surface

Hello,I am building a 3D from a shape solid by extruding in Z dimension based on a value. I then add an image texture on the front face and finish with a .obj writer.The shape consists of 31 features, each greater containing the previous ones, and with quite complex shapes (numerous vertex).I manage to produce a visualisable 3D object with texture (I can also visualise it in GLC player) but when I try to upload it on a printer website (such as Sculpteo), further processing cannot be done because the object is not valid, with lots of singuliar edges, and I don't understand why.What tools can I use in FME to clean the object without changing its layout? I can send the input shapefile, the image used for the texture (though I'm pretty confident this is not the problem) and the workbench if needed. I can also send some screenshots of the diagnosis generated by the printer website.Thanks a lot!Jean 

Hi all,I'm trying to create a Mesh out of Esri Shape polylines. I have shape files from a public transport network and need them as a 3d model (FBX). The single lines do not have the same z-values, they are changing. You can find my workbench in the attachments. Unfortunately the ascii grid file is too big to upload here. My workbench "works", i'm getting an FBX but i loose the z-values at the bufferer, so my Model is extruded but all lines are on the same altitude. After some research i found the 3DBufferer (Now Hub3DBufferer) but FME stopps the translation after around 1h with the following messages:Extruder_Rejector(TestFactory): Extruder_<REJECTED> Feature Counter -1 2147680263: Failed to seek to beginning of `%0' -- perhaps there is not enough disk spaceFailed to seek to beginning of `C:\\Users\\Clement\\AppData\\Local\\Temp\\no-conn-ffs-1512660184987_17620.ffs' -- perhaps there is not enough disk spaceI have 120GB of disk space, so i'm not sure

Hi,I've found how to get the latest file from a directory and get the file name. I now need to pass this file name to a JSON reader. I'm having difficulties in doing this. I realize that the FTP Watcher in Server would be my best bet, but unfortunately we don't have FME Server available. I will be using another program to download the json files from the FTP server. Then using PATH with Sorter and Sampler to get the latest file. I've tried to use the Feature Reader setting it to JSON with the pathfilename , but must not have the proper items set up as of yet as it rejects what I've entered. This data is ultimately to merged with a feature dataset to map specific points based on one column that is unique between the two.

Hi,I have a workspace that uses the custom FeatureCounter followed by a TestFilter. If too many features for my conversion I port to a Terminator transformer. Following termination I want to delete the input file as part of a Python Shutdown script. The path including filename are in a Published Parameter. Example: [source_file]: c:\\folder\\file.extI've looked at lots of info but my attempts produce errors or the file doesn't get deleted, or both.Can someone with good experience with this provide details on all lines needed in the shutdown script (and if needed, any Python needed in the body of the workspace)?Thanks!

@takashi I have a dataset like this:DateValue01/01/2018201/01/2018001/05/2018301/12/2018102/01/2018302/02/20184I want to create an attribute for Daily Average Value in Each Month, and store the daily average (sum of values within each month ÷ number of days in that month).The denominator is where I'm having trouble. Any suggestions on the best way to find the number of days within a given month?

HiFor different reasons I am trying to use FME Server to run a batchfile scheduled.The batchfile's task is to run a specified Powershell-script that converts a spreadsheet to PDF using MS Excel.(Yes, if FME would have had a proper plain PDF-writer I would have used this.). Both powershell-script at batchfile are working flawlessly when used manually.I've created a workspace with a systemcaller to run the batch-file. When I start this workspace, it runs the batchfile and it does what it is supposed to do, and fme logs what is happening.From the fme-log:SystemCaller: Executing `C:\Scripts\RunPowershellScript.bat'Z:\Some\network\address>>ECHO *********************************************************Z:\Some\network\address>>ECHO ** run powershellscript to convert spreadsheet to pdf. ** ** run powershellscript to convert spreadsheet to pdf. **Z:\Some\network\address>>ECHO *********************************************************Z:\Some\network\address>PowerShell -NoProf

Is there a way to get a list of exposed attributes/schema from a SQLExecutor into an attribute value or as a list? I know I can write out a record with a featurewriter and sue a schema reader to get at it, but that is a convoluted way to go. I guessing ti can be done with python, but my python skills are limited

Hi All, I want to count the number of houses that intersect (gas)lines, in order to do some quality checking.most gas pipes only intersect one house. Any pipe with multiple intersects is suspect. The gas pipes are of limited length (typ. 30 meters). However I need to do this for > 1 mln pipes aganinst > 3 mln houses. That crashes my pc due to lack of memory.I'm looking for a way to process this in chunks, by dividing the country in some grid, make the gridsquares slightly overlapping (say 50 meters) and then intersect only the houses and gaspipes in the squares. No need to check a pipe against houses in another city...How can I achieve this localized processing (using e.g. line on area overlayer) ? I tried clipper with a hand made "grid" that divides the country in 5 chunks, but I'm forced to process these slabs of land manually, by running the workbench 5 times and combine the output after running the jobs.I feel this must have been delt with more elegantly and

Hi FME community.I have a simple task to change Japanese field names in a shapefile to English field names. So I was using SchemaMapper to do this task. I created a simple csv file which has two columns, old_name and new_name. Then, I used this csv file in the ShemaMapper. I save the resulted layer as a shapefile. But the shapefile I crated had the exactly same field names as original one. All Japanese field names...I realized that when I inspect the output with the Inspector, I can see that SchemaMapper actually changed attribute names. Please see an image below.However, it did't reflect these changes when I save this result as a shapefile. Can someone tell me what I am doing wrong??Thank you in advance.Hiroo

The featurereader is not giving the expected result when we use the spatial filter optionas you can see the polygon ( initiator) overlap with the shapefile, but as you can see the there is no output is there any setting we need to fixThanksresult

I'm trying to write a link in the Word-file, that I'm creating with MSWordStyler-transformers and the Microsoft Word writer.I'm using markdown, but it isn't written af a link - just as plain text.I'm writing this in the Text-field in the MSWordStyler with Content Type set to Paragraph:[Klik her:](http://www.ph.rm.dk/Omraader/sundhedsberedskab/arrangementer-begivenheder-og-events/)

Dear FME community.I've to generate a complex line with a points listing. Complew why ? Because the line is a composite of lines and curves. The information of the geometric type is in point's attributes like that :I only tried with the LineBuilder but I don't know how to do with the curves objects.Thank you for your help.

I want to redefine raster band values, based on another raster band value.More specific: If raster band 3 has a value "0", raster bands 0, 1 and 2 should have a value "nodata".How can this be done most efficiently?

How would I go about creating a curve where two lines intersect? I am basically just trying to smooth the intersection and create the red part.See picture below:

I have raw road geometry need to create network geometry need to refine and delete extra vertices and make smoother geometry to make can anyone help I have used generalizer but could not able to do so can anyone help me out?

Hye, I'm trying to create a 3D terrain model (export format : .obj/.fbx/.3ds or any other textured mesh format) from imagery raster (France, IGN) and elevation raster (France, IGN).Inputs formats are : 1. For imageryMultiple *.jp2 files with *.tab files associated (same file name) A sample of .tab file : !table!version 300!charset WindowsLatin1Definition TableFile "01-2015-0830-6540-LA93-5M00-E100.jp2"Type "RASTER"(830000.00,6540000.00) (0,0) Label "Pt 1",(840000.00,6540000.00) (2000,0) Label "Pt 2",(840000.00,6530000.00) (2000,2000) Label "Pt 3",(830000.00,6530000.00) (0,2000) Label "Pt 4"CoordSys Earth Projection 2003, 33, 7, 3, 46.5, 44, 49.00000000001, 700000, 6600000, -792421, 5278231, 3520778, 9741029Units "m"2. For elevationMultiple *.asc files with *.asc.aux.xml files associated (same file name) An extract of *.asc file :ncols        1000nrows        1000xllcorner    74962.500000000000yllcorner    6750037.500000000000cellsize     75.000000000000NODATA_value  -99999.00 -99999.00

I am trying to create depth zones (polygons) from a set of depth curves (polylines). I would like to create one polygon that covers the area between the 0m and 3m curves, one that covers the area between 3m and 6m, and so on. There are also shallows and deeps that need to be taken into consideration. What would be the best practise to do this? I have experimented with Testfilter » Areabuilder » Disolver » Clipper. But that quickly gets very convoluted... I am guessing that I could use one of the donut transformers to manage the shallows and deeps?

I'm using the following flow and getting two different results:The flow uses a cutting line and gives back the original (un)cut results. The polygon for this example is:POLYGON((145055.748 479705.959,145059.802 479704.301,145060.003 479704.791,145061.669 479704.11,145061.468 479703.619,145079.166 479696.383,145084.101 479708.452,145066.422 479715.682,145066.222 479715.191,145064.556 479715.872,145064.756 479716.363,145047.05 479723.604,145046.285 479721.734,145043.203 479722.994,145042.471 479721.338,145039.139 479722.701,145038.458 479721.035,145035.116 479722.401,145034.481 479720.846,145014.358 479729.074,145012.216 479723.836,145013.891 479723.15,145012.653 479720.124,145008.46 479721.838,145002.488 479719.333,144994.651 479700.17,144989.025 479702.474,144968.486 479652.247,144971.54 479650.998,145020.56 479630.952,145021.696 479633.729,145039.976 479626.254,145038.841 479623.477,145046.477 479620.354,145072.687 479684.501,145050.657 479693.509,145052.257 479697.422,145055.748 4797

When creating a label with the Labeller or LabelPointReplacer, a labelpoint is made at the asked position. However, the label itself is always placed on the right above position from the labelpoint.I need the label to be placed on the left above position from the labelpoint (thus having the point at the end of the labeltext instead of the beginning), in order to garentee a good label fit in the end result. How would this be possible?

The new DatetimeConverter works well for the gtfs stop times which are stored as only a time string field. But it rejects (naturally) any times greater or equal to 24:00:00. The gtfs convention is to roll over midnight for bus routes that do not finish before midnight. How might that be handled?I am trying to calculate the total time of a route using Arrival_Time - Departure_Time. I cannot just replace the 24 with 00 because I have to add up two intervals. I can see a clumsy three part conversion. There are 1.4M records so elegance and speed would be welcome.

Hi,Does anyone know how to get rid of/remove the KML warning when you add a overlay to the KML?KML: Raster feature has no fme_basename attribute; destination filename will be based on the feature idThanks!