Transformers

Are there video tutorials on the FME AR transformer?

I have multiple layers of client regional data from which I would like to extract data for a specified study area which will be defined using a polygon in mapinfo tab format. I have tried to use an AreaOnAreaOverlayer to capture the data within the boundary however I am struggling to make this work. Any suggestions?

Hi,I have a FME workspace which is intended to converting data from any format/schema into a defined standard personal gdb format which we have defined internally. I would like to create a published parameter exposing attributes of the source dataset (eventually picked upfront by the user in a separate published parameter) and allowing the user to choose the appropriate attribute which needs to be used by the workspace (example: "Pick street name field"). Schemas and attribute names are not known in advance and I would prefer avoiding using the SchemaMapper plus asking users to update a separate schema file upfront every time new source material needs to be processed. Does FME provide a solution for fetching attribute names at runtime (a published parameter could probably call another FME worskpace or script retrieving those names and returning them into a drop-down in the prompt window)?Thank you for your suggestions!Olivier

I need to read an Adobe FrameMaker file to extract data and export to other formats. Please let me know if there are any readers, as I did not find the current FME list

I have a problem with parsing JSON which is the result of an HTTP call to get what I need. (See json files attached.)If I download the .json file and simply put it in a JSON reader with a query,filter for type:"Update Feature Attributes" and explode some of the lists, it gives me what I need:My problem is that I have loads of transactions to go through the same way, so I'd need to use an HTTPCaller. I've managed to get that far that with a JSONExtractor I can get "type", "ID" for example, but struggling to break down lists "attributesAfterChange" and "changedAttributesNames" - ListExploder doesn't recognise them as lists for some reason. Any ideas what should I do to get the list values/break down the arrays? Maybe it's very simple but I just cannot find a solution right now. NB: the attributes in these lists vary and not exclusive to what's in the attached json files, so somewhat making it a bit more complex...Any h

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