Transformers

Hi, I'm new to the FME world, and have a question that probably has a super obvious answer to anyone with experience with FME. SQL is rather new to me too. I've got an SQLCreator with the following SQL Script running in it, against an Oracle Spatial Object database.I know I need to enter something in the 'attributes to expose box', but I can't for the life of me work out what it needs to be.FME_SQL_DELIMITER /DECLARE GLASSHOUSEAR number;BEGIN    select count (*) INTO GLASSHOUSEAR from GLASSHOUSE_AR;END;/DECLARE RAILWAYSTATIONPT number;BEGIN    select count (*) INTO RAILWAYSTATIONPT from RAILWAYSTATION_PT;END;/DECLARE MARINEWATERAR number;BEGIN    select count (*) INTO MARINEWATERAR from MARINEWATER_AR;END;/ When I use the following in the SQL script, all I need in the 'attribute to expose' is 'count(*)' and it throws the count out as expected.select count (*) from RAILWAYSTATION_PT; Could someone point me in the right direction so that I can get the SQL creator to output the correct th

Hi,I know that FME has WebMapTiler as one of transformer utilities and it's good for creating image tiles in 2d web map applications.However, as 3d web gis is evolving and as there is more possibilities to build nice 3d web gis applications using libraries like CesiumJS and similair, i wonder if there is any plan in near future to enable tiling of 3d datasets using FME. For example, that you have 3d mesh and you want to create quantized-mesh tiles using some FME Transformer ?  I know it's probably not so easy to implement at the moment but I would like to know if it's something that is on TODO list or not?  Thank you and kind regardsIvan

I am hoping someone can point out if FME has a "Save a Copy" feature for manually saving a back up copy of a workbench. I searched here in the community and elsewhere and found references to backup functions for FME Server Workspaces, but nothing specific to the desktop workbench. Perhaps this function is called something else in FME speak so here's a description of my workflow:When developing a workbench I periodically save a back-up, currently when I do this I go File > "Save As" and save the file with a sequential suffix like [filename]_ii.fmw then a while later I'll save another copy as [filename]_iii.fmw and later [filename]_iiii.fmw. Sometimes I'll tag a date on the end. As the project nears completion and its down to the final tweaks I find that I'm working out of a "master" .fmw that is simply [filename].fmw and when I save a back up I use "Save As", add the sequential suffix, then do "Save As" again and s

Hi.What is the optimal way to merge several pictures from different WMS servers on top of each other ?All pictures are transparent PNGs except the bottom layer, which is JPEG.All pictures have the exact same size and map view.I'm using ImageFetcher to get the WMS images.Cheers.

I have a point file with road names but no suburb and I have a suburbs polygon shp how do I populate a suburb field in the roadnames shp from the suburbs shp ?

Hi all, I have a set attributes and some of them consist of day time.And I would like to catch those that have such information. Examples:- BUS LANE 6-9A EXC SAT-SUN-HOL - MON-FRI 8A-8P SAT - SHUTTLE BUS ONLY 6A-8P MON-FRCan I catch those with StringSearcher? How should be the reqular experission for that? Thanks in advance. Best, Nilüfer

I am currently mapping a MVDxml and I am not able to create multiple values for an attribute.This is what I want to map:<ConceptRoot uuid="e4b5239f-16dd-4813-a632-71911712a26d" name="IfcWall" status="proposal" applicableRootEntity="IfcWall"> <Applicability uuid="00000000-0000-0000-0000-000000000000" status="sample"> <Template ref="ad664563-049e-45d1-8379-1553f9172d33" /> <TemplateRules operator="and" /> </Applicability> <Concept uuid="6082a8f9-f04c-44c6-a4ce-61bf4a12dbbb" name="Property Sets for Objects" status="sample" override="false"><Template ref="f74255a6-0c0e-4f31-84ad-24981db62461" /><TemplateRules operator="and"><TemplateRule Parameters="PsetName[Value]='Pset_WallCommon'" /><TemplateRule Parameters="PsetName[Value]='Pset_ConcreteElementGeneral'" /&g

Hi all,I'm trying to clean latlongs using RegEx in the AttributeManager but I'm getting below error. AttributeManager_2: Expected signature @ReplaceRegEx(UTF8,UTF8,UTF8,[BOOL]) but received ReplaceRegEx("latitude" content="52.132932,("latitude" content=)+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `AttributeManager_OUTPUT'Attribute(encoded: UTF-8): `LAT' has value `"latitude" content="52.132932'Attribute(string) : `fme_feature_type' has value `Creator'Attribute(string) : `fme_geometry' has value `fme_undefined'Attribute(string) : `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENull===========================================================================AttributeManager_2 (AttrSetFactory): An error occurred while evaluating the above expression. If the failed expression is arithmetic, check to ensure there is

Hi,I have some XML formatted in the below way:<?xml version="1.0" encoding="UTF-16"?><apple colour="red" shape="round">  <attribute type="price" value="1"></attribute>  <attribute type="source" value="supermarket"></attribute>  <attribute type="bought" value="01/01/2019"></attribute></apple><apple colour="green" shape="round">  <attribute type="price" value="0.75"></attribute>  <attribute type="source" value="market"></attribute>  <attribute type="bought" value="02/01/2019"></attribute></apple>I need to get this into a flattened format, with one row per apple in this case, e.g: colourshapepricesourceboughtredround1supermarket01/01/2019greenround0.75market02/01/2019 I've played around with the xml flattener and xfMaps, but can't quite get my head around how to access the data when the values are contained within the tags themselves.Any help would be appreciated!

Hi guys,  As question says, I have a set of circles which I have to convert to either hexagon or octagon. Tried googling resault and didn't find any help.   Any ideas?

I have an (ecw) image with areas of black that I want to turn null.These pixels have values of 0,1,2,3,4,5How can I set the Parameter of NoData Value to a range of values from 0 to 5?

Hi I am using FME 2018.1 desktop and server and trying to publish a workspace.Today, this comes up with User is not AuthorisedThe specified user credentials were not authorized to perform this action. Ensure with your server administrator that your user credentials are authorized to perform this action. I can login with same credentials to FME Server web user interface. Also I have been able to publish to FME server before today. I am using the admin credentials to publish (which has fmeadmin, fmesuperuser access)Any suggestion what could have changed and how to investigate this issue?

Hello everyone,I have center line data and I have created two offseted lines by using OffsetCurveGenerator. How can i cleaned the lines after the intersection of the two lines? By using Topologoy Builder, I have splitted them so those are individual lines. But I could not find way to delete them.Blue lines represents the lines that I would like to remove.

Hi, is it possible to hide the systemcaller cmd line when using it inside a workspace being run from workspace runner. At the moment my screen looks like this and it is a touch annoying!Thank you   

I have two tables, one which hold records of planning cases that need to be monitored (Table A) and another which is the master list of all planning cases (Table B). In Table B, there is a string field called 'Proposal' which contains a description that may include the reference number of one of the cases in Table A (there may in fact be many records that relate to a case in the Table A).I would like select all of the records in Table B that contain the case reference from Table A in the Proposal field. I don't think I can use the feature merger as the information in Table B is contained within a Proposal field and is not in a field itself. I thought about trying to extract the case number from the Proposal field but, whilst it is normally at the end of the string, this is not always the case. It is also not a standard length.Can anyone think of a different transformer I could use to achieve this?

Hi FME ninjas,I'm using the HTTPCaller to call a website containing multiple URLs in its HTML. I'm trying to extract all the URLs that have below format, based on these I'd like to create and attribute (URL) that shows all unique urls as features. What I have: What I want:  Does this make any sense ;-) ?  Thanks,Eduard

I created a workbench which reads an ECW (which I call current imagery). I then read GeoTIFFs (which I call new imagery), mosaic the rasters together and then write to a new ECW, which becomes the new current imagery ECW.I've noticed contrast changes in locations which are not being overwritten each time I've added new imagery and recreated the ECW.What could be happening here?The below image is a location which hasn't been overwritten by new imagery. I've run the new workbench 4 times now and you can see its getting darker each time.  More notes: I have done some further analysis.By using the PointOnRasterValueExtractor I was able to get the RGB band values at a location before the mosaic and after the mosaic.Before the mosaic: 82,92,82 After the mosaic: 93,100,94I also used the RasterBandMinMaxExtractor.Before the mosaic the min max was R: 0,251 - G 0,253 - B 0,251 After the mosaic the min max became R: 0,254 - G 0,253 - B 0,254 I expected the min max to change, I jus

Many years ago, the swedish National Land Survey issued topographical maps on CD-rom, using a self invented raster format known as RIK. Lately, these maps have been published as Open data. But this resurrected format is not known to FME.There is open source code to read this format, and it is supported in GDAL. Thus, it can be read and displayed in Qgis but not (as far as I have found) read with FME. What would it take to create a custom reader in FME using information in the links below? Apparently, the 'custom reader' ability in FME desktop needs a supported format to begin with.https://sourceforge.net/projects/trikpanel/https://github.com/OSGeo/gdal/tree/ab9e80368ef662712c963191fd86fde2c5b75600/gdal/frmts/rik

I have two tables.One is a dataset of points, each point has a unique IDThe other is a (attribute only) dataset of pairs, each record refers to two points, via their unique IDHow do I construct a feature dataset of lines? Each line consisting of two points. To re-phrase, how do I add line geometry to the dataset of pairs, using the appropriate points from the point dataset, based on the unique ID of the from and to points?

Hi FME Community,I'm trying to create an arc from two Points and a radius:The radius can be concave or convex depending on the radius sign (negative or positive)Anyone got any ideas how that can be done using FME?Thanks in advance

Hello,  I'm trying to replace my overdose of RegEx StringReplacers with a single AttributeManager that should contains multiple RegEx functions.  I've set up a short test:The first part of the test works fine: change: "world" to "WORLD" The second part doesn't seem to execute: change the "99" to "100"I'm now wondering: Can the AttributeManager conditional value hold multiple RegEx functions or just one? Thanks, Ed   

Since upgrading to FME 2018, I've noticed my available hard drive space has decreased considerably. Poking around in my Local/Temp folder, I see there is a folder called FMETable that contains over 35GB of files.Diving deeper, there are gigantic files in there related to the FeatureJoiner:So my question: Is this supposed to be happening? Do I need to manually clean this stuff up on regular intervals?

I am trying to read in some pdfs, unfortunately when the pdf reader fails to open the pdf (if say it is corrupt) the workbench stops:2019-03-07 15:40:24| 391.6| 0.0|FATAL |PDF Reader: Failed to open document '\\xxxx.pdf' because the file is not in PDF format, or because it is corruptedI have set the workbench to ignore failed readers and continue transaction is setup under the Rejected feature handling. Is there any way I can keep it running?Thank youOliver  

Hi, I am reading text from a pdf using the PDF reader and in the text I see xEF, xBF, xBE - what are these and how do I remove them.Thank you

Hi all,I'm trying to download all zip files from the URL below, keep a copy of the zip in one local folder, and a copy of the extracted csv in another local folder. http://www.nemweb.com.au/REPORTS/CURRENT/Daily_Reports/Using the workspace attached , I can successfully download and extract a single zip file and csv content.I believe there may be a list of all zip files available from the URL hidden somewhere in the response, but how would I go about extracting all available zip files and storing the resulting csv ?Thanks