Transformers

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 again (using a LineBuilder) since there are now both these 3D points and vertices on the original lines which are

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 server filecopy_source_dataset = folder on first file server filecopy_dest_dataset = folder on second file server filecopy_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? It all seems to work, but it feels like I have not configured it correct

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> </tr> with empty space but that didn't change anything. How can I completely remove these rows from the table? Example photo:

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 etc Tried 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? Thanks B edit. 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 you Mathieu.

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 or url reference to one? Thanks for considering my request!

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.

I'm starting to create 3D modeling with FME and I can't find the way to create flat 3D surfaces from 2D geometry. With the Bufferer everything is rounded. How can I create a cube from a point? Or a building from a squared polygon? For example, how can I create this building from a 2D polygon? Thanks

I try to create an Erdas Imagine (.img) with Mapnikrasterizer in RGB24. In this transformer, I set a transparent background, but when I open it in Google Earth, there is no more transparency. Background is all black. What can I do to keep my transparent backgroung?

Hi, I have a workspace that snaps my "From-To"-line to the end-point, which is working fine. However, I have some adresses which I want to route to the nearest object. So therefore I would want to start the line from the nearest position possible in the network, not from end-point (because the distances can vary very much between them). I´ve tried the "LineDivider" to create more lines and therefore get more end-points, which works, but seems to be a little bit over-worked. Is it possible to snap the "From-To"-line to a vertex of the network (instead of the end-point) in any other way, run the "ShortestPathFinder" and get a result? (I´ve tried the "AnchoredSnapper" with "Vertex snapping", but that only generates a "NoPath").It seems odd only to be able to find the shortest path from end-point to end-point.

Hi there, I have a text file containing 1 line with a length of ca. 40 billion characters. I need to parse the line into seperate lines, each 256 characters long. I have tried multiple configurations looping with the AttributeSplitter (to parse the lines into a list and write it ) in conjunction with the StringReplacer (to erase the characters parsed) but I keep hitting resources limitations, mainly memory. I am running it on a 64bit OS machine with 16Gb RAM, but apparently that is not enough. Has anybody done something similar and can share some insights on how to keep the memory eating capacity of FME down to the minimum? Is there a better way to parse the file, than standard FME transformers? Any help is appreciated. Itay