Transformers

Hello,I have inserted an Excel spreadsheet in SQL Server with total rows = 6.357. I want to update the existing table with an updated version of the same spreadsheet (i.e. 2 row values have changed; else remains the same). My workflow is:Readers: (I) new excel spreadsheet and (ii) connection to the existing table in db. I then use the UpdateDetector transformer and the output is: Unchanged: 6.356 and Inserted: 1 and Deleted: 1.This one is the one I modified in excel, so it is the right one. My modification however, was to add a prefix in two of the column values of one row.Thus, I would expect to find the change in the UPDATE. Could you please enlighten me why this happens?What I wish to achieve is, update the db with all the changes of the spreadsheet in any time. Do you think it is feasible, without having to specify a column value on the where clause?I want to automate the process of updating the db based on an updated spreadsheet using FME Server. This means, I do not want to be th

I'm getting the error when reading from GDB 9.3 with FME 2008. Any ideas how to fix this?

Hello,I would like to add elevation values on arc without changing its structure.Before, I have this arcAnd after I would like the arc to have this where the highlighted values should be the elevation valuesSO far my idea to do that is to usearc =feature.getGeometry()                    feat.setStartPoint(fmeobjects.FMEPoint(feat.getStartPoint().getXYZ()[0], feat.getStartPoint().getXYZ()[1], elevation_start))                      feat.EndStartPoint(fmeobjects.FMEPoint(feat.getEndtPoint().getXYZ()[0], feat.getEndPoint().getXYZ()[1], elevation_end]))  but it is not working.Any hints?

I have a citygml file and it contains 2 coordinate reference systems. One of them is 2 dimensional and the other is 1 dimensional for height. I want to remove the coordinate reference system just used for the height. Currently I can only remove coordinate systems for both using coordinate system remover.

In incomming data to AttributeFilter has the table about 80 cells, after filtering has table only about 50 cells. What happend that 30 cells dissapear?

Hello,I have been trying to determine why the Geocoder transformer (using OpenStreetMap source) keeps stalling after ~500 features have been processed. Does anyone know if there is a limit that can be processed?Thanks

Hello Everyone, I am looking to convert 2D Lines to 3D Features. I am not looking though to add Height value, what I want to do is take a line and based on an attribute value (diameter: 250mm for example) create a 3D cylindrical version of it. Then I will add elevation values using the 3D Forcer, that I am aware of. I have taken a look at 3D Forcer/Interpolator, SurfaceDraper, etc. but I do not believe they do the trick. Could you please point me to a direction? Thank you for your time. Kind regards, George Floros

I am creating some anonymized data for testing purposes and need to create a fake Land Registry Title Number (found in the UK). These are references such as CU556644 or LAN33445. I can generate the random numbers for it but I need to generate random letters in either combination of 2 or 3 letters or both. Has anyone come across a way of doing this?Thanks 

Greetings for the day, I am new with the coding world. I am using Python and IfcOpenShell to work on IFC files. I want to use a command ifc.open but it is not working. I am using Python 2.7. Please help me with this issue. Thank you

 Hi, I'm trying to read in a CSV file that has no header information. Additionally the data is spread around several columns rather than in a single line. Looks like the first row is junk.The second is the site name.The third is the site number.Fourth is pressure informationFifth is the date and start time of the data6 onwards is the dataHow do I first create a schema that FME uses before it tries to open the file? I attach a file as an example.Thank you.

Hello,I have multiple segments line for which I would like to add a measure on the starting/ending of each segment. In other words, I would like to create a "fake" LRS  where the measure will be computed from some attributes of the feature.I thinking of using python with this logic def addMeasure(feature                coord = feature.getAllCoordinates()    n=len(coord)    mfr=feature.getAttribute('MEASURE_TO')    mto=feature.getAttribute('MEASURE_FROM')             if mfr!=None and str(mfr)!='':        setMeasure(coord[0], mfr)                setMeasure(coord[n-1], mfr    feature.addCoordinates(coord)where setMeasure should be a python version of the measureSetter Transformer.How should I proceed?

Hi all   I am using FME to convert a ESRI File GDB containing building polygons to AutoCAD DWG. Really simple styling and the resulting file looks fine except for one thing - when opening the DWG it opens at THE SAME location as the template file. The template file is overidding the new data. This is not great if I have data in say Manchester and the template file is in London.   This is a process I need to batch repeat for multiple locations are the UK - but the resulting DWG will always startup in the London location despite there being no data there. I have not had this problem before with a similar task.   (1) Is there a format setting I can utilise to tell the DWG to zoom to data extent on startup?   (2) The only styling information I am taking from the Template file is "Visual style - Realistic with no isolines" (creating 3D Polygons) is it possible to set this in FME without the need for a template file.   This is a really simple issue that I can't seem to fix and

Something I encountered recently: When I send multiple features into a FeatureReader, I only get one SchemaFeature. I expected one SchemaFeature per initiator feature.As I needed a SchemaFeature per Initiator, I merged them using a FeatureMerger after the FeatureReader. But I keep wondering if this is how it is supposed to work?Thanks!

When the FeatureReader outputs a SchemaFeature, the attribute handling differs from Features. For example, I use the Prefix Initiatior option a lot, but it does not work for SchemaFeatures.Is this how it should work? Thanks.

Hello,How can I replace a line with its corresponding points with a python caller?I tried the following code but it is not working.import fmeimport fmeobjectsclass pointCreate(object):    def __init__(self):        pass            def input(self,feature):        if feature.hasGeometry():            coord = feature.getAllCoordinates()            cpt = len(coord)            #coordSys = feature.getCoordSys()                        for cpt in range(0,len(coord)):                feature.setAttribute('X_e', coord[cpt][0])                feature.setAttribute('Y_e', coord[cpt][1])                feature.setGeometry(fmeobjects.FMEPoint([float(coord[cpt][0]), float(coord[cpt][1])]))                #feature.setCoordSys(coordSys)                self.pyoutput(feature)                     def close(self):        pass  Any ideas,Thanks  

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?