Transformers

Hello,I am trying to create a Pivot chart using FME.I have attached a spreadsheet which shows my raw data and the pivot chart which excel can easily produce. You'll see that I have a Date, Area and Exports column. I essentially want to group the dates into month/year format and then use the Area numbers as headers with the number of exports summed for each month and area. It is also important that where no data exists, the chart produced shows this with zero values.How should I go about doing this?Tom

Hi All,I have polygon layer for road feature which is generated from the raster layer . each polygon is form by multiple road polygons Now i would like split each polygon to it's sub component i.e. individual roads layer.can somebody help me with this ?

Hi, I have a workspace which needs to read files from a network share directory. I am trying to run this workspace via fme server, which fails as it cannot access the network path.I gather that I have to run FME Engine service under a different account. I have followed the steps inhttp://docs.safe.com/fme/html/FME_Server_Documentation/Content/ReferenceManual/Directory-Account-Permissions.htmI have an express installation of fme server 2018, all on the same machine.So far I have done the following:1) Change the service account to a non admin domain account. Grant logon as service to this account2) Grant full access to fme server install directory C:\\Program Files\\FMEServer and fme server share directory C:\\ProgramData\\Safe Software\\FME Server3) Grant my domain account read access to the network pathUnfortunately the above still doesn't work. FME Server complains of being unable to read the files in the network dir specified.Any ideas ?

Why would feature attributes be missing when using a reader? On inspection features such as fme_basename or fme_dataset are present in table but with a value 'missing'??

Hi FME ninjas,I'm struggling trying to transform XML data to tabular data. Attached is an example XML. I'm looking at records that have multiple opening hours per day of the week. (in the example dayNumber="2" is Monday)Opening and closing time are in "timeBegin" / "timeEnd" I'm trying to aggregate / merge these into one row.What I'd like to have:stationCode Monday1_open Monday1_close Monday2_open Monday2_close RNSC01 0700 1200 1400 1800 Thanks, Ed

Hi I am trying to write to dwg dynamically. I have 5 different features River, Pond, Canal, Canal Lock and Canal Harbour. I want to merge the 3 canal features (Canal, Canal Lock and Canal Harbour) into Canal and then write dynamically so I get a single DWG file with River, Pond and Canal, but of course I get the Canal Lock and Canal Harbour now under the alias of Canal. Is this possible, hope it makes sense?ThanksB

Hi all,I have FME 2018.1.0.2 and .NET Framework 4.5.1Raising an exception only when I check label with symbol

Hi, I've been passed a csv file with Polyline data in a single column where the XY are not paired, just next to each other with the same delimiter used between all the points. I don't know how to separate them and pair them so I can create a shape file of the line. an example of the polyline column is like this...532792.000#182214.000#532800.155#182168.565The rows range between two to several points. Any advice on how to achieve this would be greatly appreciated.

Hi,I have a dataset with an attribute containing a JSON file for every feature. The dataset also has an attribute called frequency. I'd like to add the key frequency to the JSON file, with the value in the frequency attribute. I tried using the JSONUpdater transformer:Update Type: Insert into Object JSON path: json Object/Array index: frequency Value Type: Plain Text Value: [the value of the frequency attribute]The resulting JSON file has a key frequency with a string of length 0 as a value.I also tried:Update Type: Insert into Object JSON path: json Object/Array index: frequency Value Type: JSON/XQuery Value: fme:get-attribute("frequency")This time the result was a key frequency with a value of null. How do I resolve this?

Hi, I want to remove vertices from polygons that are located on straight or almost straight lines. I used the Generalizer transformer but non of the algorithms removed such vertices, even with higher tolerances that distort the original shapes. Is there another way to do this?

In the past I've always used a Group By with the line combiner to join lines that share a common value. Now there appears to be a parameter called Combine On Attribute - how does this differ from the Group By option?

Hi, i am cliping 7.000.000 fetaures and after 5.000.000 milions of read fetaures it stucks - program starts to make some low level intersections. I woul like to perform 30 independent dwg files from shapes with 7 milion of features. I do it with tester transformer. In ARGIS modelbuilder i used to do this with Feature iterator - are there any similar options?Program runs very slow for 2 days and it is unable to perform cliped outputs. I think there is a memory issue, can you help me? i have 32gb ram availible and new i7 processor. FME softeware is 32 bit.

Hello,I have created WB to fetching data from API call following is the work flow 1. Input is Road geometry create buffer around then dissolve based on spatial connectivity create group. 2. created group will be the input for API POST Method andintersection data with API call will be output in GeoJSON file the convert in to Geometry (Line)3. Converted geometry will has more analysis to be done.Above expanded process created in FME but when process running I am facing issue eating memory more than 130 GB.So I wanted to optimize process based on created group we are creating for input for API POST call I need to process 1st group till the end to end (2 & 3 point ) then pick up the 2nd group and so on…. Can anyone tell how can get it done?

I need to create a groundlevel polygon from a las file, including the height. No classification is added to the pointcloud.It doesn't need to be precise; otherwise there would be generate to many polygons. A generalisation would be perfect. For example I get a polygon where the height is between 17 and 17.50 meter; and another polygon where the height is between 17.50 and 18 meterI tried serveral thing with surfacemodeller, surfacebuilder, creating buffers around the points. But I can't get my hands around this issue. Hope someone as experience with such an analysis

I have set of records as below,LinkIDoccurenceNAME123455ZXC2123457ABC1567893XYZ1567892SDF2567895YTR3I need the record with maximum count based on occurence attribute. For example, from the above table, I need to extract only the below records.Output,LinkIDoccurenceNAME123457ABC1567895YTR3Could anyone give me some suggestions please.

Hello,  I have a multiple PDFs that contain image in them self. Image is combination of vectors and some more data that is added later in Acrobat Reader. Beside the image there is the annotation and I would need to crop the image, to remove annotation and after that to mosaic these multiple PDFs.  Is that possible to finish in FME? I've tried RasterMosaicer but it is not working. Also, I have tried Clipper and ImageRasterizer but the result is bad in way that layers from PDF are not good. It disrupts the order of layers and I don't know how to keep it because it is one of the most important things. This is how it look in PDF and here is how it looks after Clipper and Image Rasterizer.I have tried to expose the attribute fme_fill_colour but it doesn't change anything. Hope that I will get some hints. Thank You in advance!  Dejan

Dear all, At this moment i'm trying to convert a CityGML (MultiSurface) to a WKT.  Unfortunately I get Multilinestring instead of MultiPolygon. What am I doing wrong?This is my workbench

Hello,I was recently working with LineOnLine Overlayer transformer and I encountered some problems. I have two line datasets and I would like to find the lines in one dataset that overlap with lines in the other dataset, but also get the lines that do not overlap. I was able to output the overlapping lines, but I couldn't find a way to also keep the lines that do not overlap. Is there a possibility to get the lines that do not overlap with LineOnLineOverlayer, or do I have to use a buffer and the LineOnAreaOverlayer?Thanks in advance :)Kathrin

This one is possibly either already done somewhere or a bit difficult, or I'm just missing something.I have road lines that are not linearly referenced with measurements, and a separate feature class of reference points containing measurements. The reference points (RPs) lie generally within a few cm of the line and at regular distances along it, so they can be quite reliably related spatially. I want to use the RPs to assign measures to those known locations along the line, then interpolate other measures on the line between and also before/after the RPs (potentially down to each metre) to create what is effectively a measured route along the whole road line. The measure or z value interpolator looks a good option once I have some measures on the line and have then created additional vertices using the IterativeSnipper/LineCombiner (thanks Takashi from another thread).The aim overall is to then cut this line between specified measures to indicate planned maintenance. Note I do

Hello all,I am processing a dataset of rainfall values. For each feature, I have 365 values in a list. I am using BulkAttributeRenamer to convert the list values to 365 attribute columns. The result is badly ordered. I was expecting the new columns to be ordered numerically, but they are scrambled up. It will take me a very long time to correct the order by hand.

Hi,i am changing the text value of ESRI annotations in a GEODATBASE (edit session) by updating the attribute geodb_string_text. This works fine for referenced annoation without overrides.  If I want to update inline annotation with format tags in textstring I can't change the value in geodb_text_string. As result nothing happens. Is this possible with FME and which attributes I have to consider?  Version: FME 2016.1 Thanks Stefan

I am working on a CAD to ESRI Shape tool that is being hosted on FME Server. The user only needs to upload the CAD files and a spreadsheet for categorization and the output is the ESRI shapes. I have everything working except the requirement for defining the coordinate system. A lot of my work is done in Colorado where the elevation dictates a custom projection for every project. I usually have an ESRI prj file for the project but the CAD files do not have a projection defined within them. This custom projection is needed in order to properly create the shape files. Is there anyway to load the ESRI prj file into the process on the Server? The online tool will be used by people who can load a prj file and they understand GIS files, but they only have a rudimentary understanding of projections so I am trying to keep this as simple as possible.

So I have two IFC building models of the same building. One of the models is the actual building the other is the glass shell of the building. When I read the models they get different coordinate system. Now I want to combine them into one model for  visualization. To combine the I tried using the reprojector transformer but I couldn't find the other system. How can I reproject between the systems?Parameters BellowCS_NAME: IFC_COORDSYS_0 CS_NAME: IFC_COORDSYS_1DT_NAME: WGS84 DT_NAME: WGS84ORG_LAT: 42.41486358638889 ORG_LAT: 48.856666564722225ORG_LNG: -71.25807189916667 ORG_LNG: 2.3509871958333335PROJ: AZMED PROJ: AZMEDQUAD: 1 QUAD: 1UNIT: MILLIMETER UNIT: METERX_OFF: 0.0 X_OFF: 0.0Y_OFF: 0.0 Y_OFF: 0.0I have a hard time wrapping my head around how to manipulate the Dynamic coordinate system _AZMED_Also the BIM-modle is in 3D of course.

Hi,I cannot find "Natural neighbour" as a interpolation method in any raster transformers in FME. I have FME Home Edition, ver: FME(R) 2018.1.0.3 (20180926 - Build 18552 - WIN64).The function is in the arcgis program, see more here Natural neighbourI have tried RasterDEMGenerator transformer in FME with "Auto", "Planar" and "Constant" as interpolation methods and with "Surface Tolerance" = 0 but the result is not as good as with QGIS or ArcGis. Will there be a future support for "Natural Neighbour" as a interpolation method in raster transformers in FME? I attache a raster done in QGIS from LIDAR point cloud and Grid 1 x 1 meter and the same done in FME so you can compare the difference.Best regards,Jonas

Hi all.How do I get the leading zero using this in a attribute creator?[format "#%06X" [expr {int(rand() * 0xFFFFFF)}]] (a random uppercase hex creator to create random hex colors in range )I get this "# D7A01" when it occurs. The location for the "0" is now a space.btw. Stringreplace is of no use, the value can then not be parsed anymore. (I tried of course.)