Transformers

Cloner, duplication issues after 10,000 rowsMy issue is, my 'source' dataset (6,600 rows) needs to clone each single row 54 times, example - Row '2' is cloned 54 times so the 'output' has 54 identical rows of '2' (to then later be transposed..etc..); I have noticed once the completed 'Output' dataset reaches 10,000 rows it starts again from the top (row 2 of source again), so row 2 has 54 correct clones and then it repeats again at 10,002, 20,002, 30,002 etc......  The issue: Original row 2 repeated again at row 10,002    Simplified set-up:

Hi,I have 2 shapefiles. One file contains road names and another contains locality name. In Road name file the names contain Locality names as well. is there any way I could identify if the names of the locality file. is available in road name file Please note that the words may not be exact. Here the reference file is locality and the target is road file. Any help is well appreciated. Thanks in advance

Input: Several .Las and one SHP file with several segments. Objective: trim the .LAS using the shp segments. Could exist more than one segment covered by the same .LAS. Buffer 0 and square.Output: .Las trimed by the shp file segment and with the SHP file segment attribute name

I am trying to label a grid I have created, the Y axis should be the elevation and the X axis is the station along the centerline.I have the above grid writing to model space in AutoCAD, I think I can get the labels on the X axis but the Y is proving more difficult here is what I am trying to do. See below.

Hi! I've been struggling with this task for a while now and need some help. I have a set of 2D lines (sewage lines if anyone is interested), with a "_lineID" attribute. I also have set of known 3D points on those lines. Some are on end nodes, some are on a vertex. These points also have the corresponding "_lineID" attribute.  Now I want to use these known points to get the lines into 3D, interpolating any line vertices in between which doesn't have a known height. However, I'm having problems with this.I've tried to implement a NeighborFinder with a Group By: _lineID to help where there are points located in the same XY position, only differing in height (see attached screen shot below - the yellow dot is actually four points in the point file, each with a different "_lineID").  This is followed up by a 3DForcer. This part works fine, but I can't manage to re-build the lines

I'm trying to create a multipage PDF with one map for each "delområde" (=part of area) in a city on every page (along with text information later as well). My problem is that both map extents and text do not fit in correct in the frames. I want my map extent to fill out the whole frame as defined in PDFPageFormatter. This is probably an easy task but this is the first time I'm working with pdf's in FME so I feel like I'm missing out on something. As far as for the text, I just want them to be centered in the frame "Delområde". The text is created with TextAdder from the same data as the map extent, which means it still has the geometry and therefore I guess that they are spatially distribuated across the page according to their geometry. Thanks for any help!!

I have a workbench that writes three mapinfo tables to a folder on one file server which I then want to filecopy the mapinfo tables to a folder on a different file server.I think I've got it to work, but I wanted to confirm.I use three FeatureWriters to write the mapinfo tables to a folder on the first file server. Then all three FeatureWriters go to a single FileCopy transformer.The parameters for the FileCopy are;Destination File Copy Folder = folder on first file serverfilecopy_source_dataset = folder on first file serverfilecopy_dest_dataset = folder on second file serverfilecopy_dest_filename = <blank>Is this correct?I have the address of the first file server in twice, once for the Destination File Copy Folder and again for filecopy_dest_dataset. Do I really have to enter this twice?filecopy_dest_filename is blank, which means I get a red arrow. But it runs anyway. Should I really leave this blank?

Hello. I have a b/w raster with only one band but in each band there are 255 palettes with a RGB combine each one. Is it possible extract each combine like a RGB combine value?Thanks a lot.This is the example of the issue.

Hi guys,Is it possible to extract a list of PDF document path and filenames from an O365 Sharepoint folder as you would with a normal network drive?? FILE/PATH Transformer Eg, Date, name, File Location, etc....I can't seem to get this to work with a copy of the share URL for the folder. Maybe there's another way. Thank you.Tim

I have a set of lines which need to be combined. For that I use the LineCombiner. Some of the resulting lines are self-intersecting. That causes problems later in my workspace. A GeometryValidator can correct self-intersections, but is there a way to prevent self-intersections from occurring?In the attached file are some lines which result in self-intersections.

Hi all.This is occuring on FME Workbench 2019.1.I'm using an HTMLReportGenerator to create a table that should have 10 rows. However, I get the 10 expected rows, plus many more that simply say "None." (see attached photo). The 10 features come from a SQLExecutor and I've checked the output with an inspector and have confirmed that there are only 10 rows. The HTMLReportGenerator output isn't very telling, but here's a snippet of where the "None" values begin:             <tr>               <td>Point Loma</td>               <td>108</td>            </tr>            <tr>               <td>None</td>               <td>None</td>            </tr>I've tried replacing all instances of<tr>               <td>None</td>               <td>None</td>            &lt

Hate to be vague with my question. It's quite possible the solution lies outside of FME, too.I have inherited a large workspace with multiple SQL Creators that use ODBC connections. There is a database name listed, and under 'Parameters' there are credentials. There is a SQL statement. Neither tables nor dataset sound familiar.So I have no idea what this actually connects to. There is no way for me to find that through FME, is there? I'm thinking this was either setup through DSN but I haven't located a file, or another way. Any insights would be helpful.

Have data in a non-spatial SQL database stored in a field titled "WKTPolygon" with geometry structured as shown below:MULTIPOLYGON (((257187.77487182617 252016.49029541016, 257197.35565185547 252041.80303955078, 257216.97064208984, etc etcTried all the suggestions from google searching and Geometry Replacer creates lots of individual vertex points for the polygon geometry, but not actual polygons, and all the others error on the first record. Cheers. M

Hi,I am trying to copy a selection of dwg's from one folder to another. I am using the filecopy writer to achieve this. I am having a problem however, with the original dwg's the units are set to metric, but when I copy them to the new destination using filecopy they switch to imperial. I can't see any settings to change this, would anyone know how to keep these as metric?ThanksBedit. I have uploaded the workspace also. Thanks for the help.. 

Hello,I want to resize an image. Per example 1000*1000 pixels to 200*200 pixels.I tried RasterResampler, but I only get a degradation of the image, with the same size.Is there a way to do that?This is not my family : legacy from Google Images. In M$Paint I would use this.

I have just updated some older workspaces that use dissolver transformes. Hoping for a performance boost, I upgraded all dissolvers to the current version (within FME 2019.1.3). For some reason, this has lead to the workspaces crashing. The error message being displayed is "Insufficient memory available". I am trying to dissolve a dataset of ~8.000 features read from a shapefile which should yield ~100 features after dissolving. Looking at the windows task manager I can see the fme process using all my physical memory (16GB). The swap file generated by windows is about 16gb as well. Before upgrading the transformers, this workspace used to run without any issues in FME 2018.X.Since the features are ordered, I have also tried using group by mode "process when group changes" but the result ist the same.Do you have any ideas on how to work around this?

Is this behavior correct?  I receive the data but looks to be a certain length tweet will show some info then truncate the rest into a url to the tweet? e.g - Library. There will be… https://t.co/DvNRaQifFE

I have a dwg file (AutoCad) with apparently no coordinates system. It looks like it is using a sort of arbitrary coordinates.I am looking for a way to Aling that drawing on a CanQ-M8 coordinates system.I know that I will probably need to offset the coordinates, rotate the map and maybe strech or shrink the drawing to make it fit.Is there any tools to do it ?Attached is the dwg drawing that I want to align on the base map (also attached)I only need the layer 41 of the dwg map.Thank youMathieu. 

Hi,I tried to convert kml into dwg, but the schema of attributes is empty.How can I get all the attributes from KML into the dwg?  thanks

Howdy,I am reading with an AutoCAD .dwg and I need FME to generate a bounding polygon around annotation text as the text it appears in Inspector.I used the BoundingBoxReplacer to generate a polygon for the extents of the text, however as you can see in the screen capture below the bounding box output is significantly smaller than the text as the text appears in the Inspector.  Can someone please help me understand how FME is deciding the size/extents of the bounding box? What do I need to do get a bounding box output that matches up with the actual text extents?? Please see the attached data if needed: Thank you! 

Hi,I try to use the Rcaller in FME to perform zonal statistics. My input is a shapefile and a Geotiff, however i read that the Rcaller reads it as a dataframe when imported into R. I tried to convert it in the Rcaller back to a shapefile and raster (with rasterFromXYZ('dataframe) and SpatialPointsDataFrame() ), but i got a error that the X and Y coordinates are missing and I cannot figure out how to include them?In R would normaly perform a zonal statistics in the following way:setwd('location\\files) library(raster)  library(rgdal) shape <- readOGR(dsn = "Shapefile.shp") DEM <- raster("Elevation")#extract raster cell count (sum) within each polygon area  ex <- extract(DEM, shape, fun=sum, na.rm=TRUE, df=TRUE) My FME canvas looks at following:Can somebody help me with an example o

I have a csv file that is stored in a secure location that I cannot save locally for processing. I am accessing the file through the FTP caller and downloading it as an attribute. When I view what is returned the entire contents of the csv file are returned in a single cell of the resulting table. How do I parse the cell to turn it back into rows and columns of data? The processing of the data must be handled in memory with the data never being stored at rest without encryption. Thanks!

Hi there,I'm trying to get grid locations from a polygon fgdb feature class attribute for the start and end of a fgdb line feature class. The attribute I need to put into the line data is a GRID ID (shown below). I've created two different scripts that seem to work, although all the writers have null values in both GRID_ID columns. I've attached a screenshot of the data in arc, and my workspace. In the second attempt of the workspace, the clipper doesn't output any features inside it.   

Currently trying to add a distance field in my shp file that will state the distance from 1 polyline to its closest neighbor polyline in the same shp file and after running the neighbourfinder as seen below (for candidate only) There were matched and also unmatched data. There were also addition fields seen below  which stated the closest distance for the matched data however when I exported this data to a writer it did not include these additional fields. I'm unsure if this is the correct methodology to obtain the results I desire.

So i have a vessel dataset of points that has a position time and mmsi field that i want to create a line for each mmsi using the time field.