Transformers

I have an Excel Sheet where I need to find Arabic Words and separate them.For example, I have data like this://olyservice/GIS-TANSIQ01/Storage/46-????? ????? ???? -????? ??????/???? ????? ??????? ??????????????? ???????? ????????.rar//olyservice/GIS-TANSIQ01/Storage/111-????? ?????? ??????? -/Layers.zip //olyservice/GIS-TANSIQ01/Storage/100-????? ????? ???? -/????? ????? ???????? ??????? ?????????? ???? ????? ???? - ????????.rarI'm looking for:1st column: ????? ????? ????2nd column: ????? ??????3rd column: RARIf there is no ????? and ????? words, the columns should be blank.Is there any transformtion and formula which i can to get the information ??

What I want is to detect (new) buildings from a aerial photo. I have a 7.5 cm resolution aerial photo. Furthermore, I already have a large dataset with polygons of buidings (around 150.000 buildings). Can I use this dataset to create an annotation file for the positive samples to use in the RasterObjectDetector?  And can I also create negative samples by taken regions from the aerial photo where no buildings are located?

I have Google Spread sheet for project Managemnet .. what I am trying to do is end of week i get the Value from one specfic column and add on week Number Im attching the week FLow where you get the idea what extacly im looking for  i just need get percentage from Sheets  

normal reader is used not feature reader because i need to reproject data first . result writing 1000 record takes around one minute . also resources of server are almost taken by fme engine

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: Hope someone can help? regards, Richard

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 again (using a LineBuilder) since there are now both these 3D

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?It all seems to work, but it feels like I have not configured it correctl

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