Transformers

The aim is to use the current transformers that FME has to offer. Any help with this is much appreciated. Thanks,Sam

Hi All,I created a SchemaMapper lookup table in PostgreSQL and used it to map schemas in two scenarios.When I used ESRI SDE feature class as a reader and PostgreSQL as a writer the SchemaMapper mapped all and no problemWhen I used SQLExecutor reading from Microsoft SQL Server database that creates a query from four tables and writing to a Single PostgreSQL table, the SchemaMapper outputs the results as unmapped. I have used AttributeExposer transformer and it still didn't change. please see the screen shot below:Can anyone please help me fix the issue or let me know if I'm missing anything?Thank you in advance

Hello to the community!I'm new to the FME and I'm quite impressed with what it can do and also with the very helpful tips and solutions which I read in this forum! As a newbee, I'm struggling to get the result which I want, but for most of the experts here, it's probably quite simple: I'm working with polygons which represent the chart coverages of Electrionic Navigational Charts. They are categorized into "usages" with usage 6 having the largest scale (inside harbours) and usage 1 having the smallest scale (covering entire oceans). The set of polygons is currently overlapping each other and my goal is to have a non-overlapping set of polygons - perfectly touching each other's boundaries - which give me the best chart usage at any given point. I have already created a workflow where I dissolved usages 2 to 6 and then used the Clipper to clip usage 1 with this. Similarly, I dissolved usage 3 to 6 and clipped usage

I used the Directory and File Pathnames reader to go through folders and select all shapefiles. Then trying to use GeometryExtractor and GeometryFilter to filter line shapefiles but GeometryExtractor output has no geometry. Then I'm using the GeometryReplacer to replace the geometry but again the output has no geometry and the GeometryFilter cannot filter lines.I'm very new to FME so please go easy!Thanks in advance.

I would like to use the PIL module to resize an image stored in a blob (geodatabase attachment table) but I cannot create the Image object from the string representation in the pythonCaller This is what I have tried so far:import fme, fmeobjectsfrom PIL import Imagefrom io import StringIO def processFeature(feature):  string_io = StringIO(feature.getAttribute("data"))  img = Image.open(string_io) #here I have the following error: Python Exception <OSError>: cannot identify image file <_io.StringIO object at 0x0000000007CE4438>   img = img.resize((1000, int(round((width / float(img.size[0])) * img.size[1]))), Image.ANTIALIAS) I have the following error Python Exception <OSError>: cannot identify image file <_io.StringIO object at 0x0000000007CE4438>   

Hello Community, I am trying to extract values of attributes in a table that is in a HTML page.Actually the table is updated every 20 minutes or so on this URL:  https://www.hydrodaten.admin.ch/fr/2174.html The table looks like this:I have tried to use a HTML Table reader but unfortunately the attributes names contain also a date / time and they are changing all the time, so if I extract it at regular intervals, it doesnt work anymore as the field name will have changed in between:  Then I have tried the Http Caller + HTML Extractor but I can't figure out which CSS Sel

hello everyone, I'am trying to load a mosaic raster into aan ArcSDE Geodatabase. I made a simple workspace (build 20825) white a GEODATABASE_FILE_RASTER_DATASET reader and GEODATABASE_SDE_RASTER_DATASET writer.   These are my settings of the writer:When I publish this workspace to FME server (same build 20825) and run I get the following error:   73 2021-6-11 07:57:48 | A default z-value of '0' will be used for all 3D features where z-values are not provided74 2021-6-11 07:57:48 | Geodatabase Writer: Not simplifying geometries being written to the Geodatabase75 2021-6-11 07:57:48 | Transactions are being used by the Geodatabase Writer76 2021-6-11 07:57:51 | Fa

Hi!In a project, I want to plot the bounding points of an area onto a map. To do that I am mainly using the Featurereader to grab the map from a WMS using said bounding points (as a polygon). In order to do this to grab the map, I need to change the coordinate system. Thats why I'm using a Reprojector to convert from the national coordinate system SWEREF991800 to EPSG:4326, which is the proper one for the WMS.The operation kind of works, I manage to grab the map including my bounding points, and I can confirm it is the correct area. However, the reprojected points and the WSM appear scaled in the X-axis, instead of being almost a square. Please see the attached pictures. Why am I seeing this, is it a Reprojection problem?

Hi - I'm trying to run a SQL query on a MS SQL Server database using a SQL Executor in an FME Desktop workbench. The SQL query executes successfully in SQL Server Management Studio but fails in workbench. I'd be grateful for any advice on this. The SQL Executor returns the following error: Provider error `(-2147467259) Unknown token received from SQL Server' The query is quite long so I wouldn't expect anyone to try and identify the exact problem but would be grateful for any ideas on where to start looking and an explanation of what the error basically means (i.e. what is an unknown token?). Thanks for any advice you can offer. 

Hi, I have a json string, which I have flattened to a bunch of attributes (about 30), all have values 0 or 1. I'd like to query each attribute and output the list of attributes which have value 1 only. All of the attributes may be 0 for some records.Any suggestions what's the best way to achieve this. I could use a stringConcatenator, and find whether 1 exists, but it wouldn't give me list of attributes

Hi,I've a polygon/square ( 4 corners). The leftside should be extended to 2 metres to the left/east. I tried offsetter, but it moves thecomplete polygon. I only need 2 points/coordinates).Is this somehow possible?

I'll start simple and add detail as necessary. I am working with the workspace runner. I have a table that I want to select unique values on and export as separate point feature classes (a simple iteration).I have four unique values on 200,000 ish records.I have set up a workspace runner and plugged it into a unique attribute logger that creates the four values I want to use to make feature classes.It is being so finnicky I don't know where to start. Usually, it will create the first feature class, but with not nearly enough records - and not make the other three. The log file usually will say a lock caused a crash.However, it works perfectly sometimes and I can't figure out why. At noon I thought I was in business, after a good run. By 5:00, I was stumped. I set 'wait for job to complete' to 'yes' and it seems like it made all four feature classes four times - way too many records and it took forever.Is there a w

I need help with ideas on how to extract areas where the width >=1.1m within a polygon. I have attached a file (file geodatabase) here for anyone who wants to give it a shot. It is a long and skinny polygon reflecting sidewalks with curb and gutter all connected together in reality.I have a solution working okay for a small number of such polygons. But it is not working efficiently enough for a large number of records. I have a total of more than 20,000 records to be processed.Please share your thoughts.Thanks!

Hi. I want to transform data from Oracle spatial to PostGIS. There are over 100 classes to transform. That's why I go with the option "generate workspace". For the writer I choose a PostGIS connection. In the Parameters I have to click the option "lower case attributs name". The same I need for the table name. If the table name is in uppercase letter, I'm not able to open the PostGIS database anymore. If I manualy set it in lower case letter, it works. But there are over 100 writers. Is there a posiblitity to set that generaly? To choose the function "import feature tye" is no option. In this case there is a lower case table name, but reader and writer attributes doesn't finde eache other.

I have a SQL statement that contains a regexp_contains.  It works fine in BigQuery SQL Editor, but FME chokes on it before it even executes it in BiqQuery.  Even if I comment out the statement it still throws the same error unless I remove it completely.regexp_contains(table1.col1, '^[[:digit:]]+$')Do I have to escape this somehow? Error :Using Java Reader Interface Version 2.0 (Oct 31, 2000) with module GOOGLEBIGQUERY to read dataGoogle BigQuery: Using billing project xxxjava.lang.IllegalArgumentException: Illegal group reference

Hi,I am able to use iCloud as data provider in the FME AR app, but when I try to open the same file in Google Drive the file is greyed out.Does anyone else have the same problem? Read More ( vietnamese languae ) : thay pin iphone 11 and more sửa iPhone hcm

I am new for FME actually. I have FME case C657637 generated. but is any support to open the case? it is about dissolving line segments.

I want to filter out duplicate points from two point feature classes, however, every SpatialFilter configuration I have tried returns the duplicate points as failing all predicate test. Am I missing a configuration step?

Hello,Every time a run workbench I get this error near the end. Postgres doesn't print any errors in the logs. AttributeManager_2_OUTPUT Feature Counter -1 17 (TeeFactory): Cloned 60483 input feature(s) into 60483 output feature(s)Error executing SQL command ('COMMIT'): 'Error connecting to database'POSTGIS writer: A fatal error has occurred. Check the logfile above for detailsFeatureWriter_2 (WriterFactory): POSTGIS writer: A fatal error has occurred. Check the logfile above for details Any idea of what is going wrong?

I have very little python knowledge so I have real trouble understanding the documentation FME provides:http://docs.safe.com/fme/html/fmepython/api/fmeobjects/_rastertools/fmeobjects.FMERasterTools.calculateSlope.html?highlight=rastertools#fmeobjects.FMERasterTools.calculateSlope I have a PythonCaller that calculates the slope of a Raster. At the end I want to itterate over the cells to calculate the desired height, but for now I want to understand how to use Python to manipulate a raster. class FeatureProcessor(object):    def input(self,feature):            raster = feature.getGeometry()            rst = fmeobjects.FMERasterTools()            settings = {'kFME_CalculateSlope_interpolate

I am trying to do a translation of multiple pdf files (11 in this case), and I want them as jpg files, as simple pictures. My attemp was to import all the folder that contains the pdfs, and to pass them through a dynamic jpg writer, but I am getting an error from the jpg writer that says that "This format cannot support more than 3 bands". I dont know if I am configuring something wrong in the writer, please give me an advice. Thank you

I have a dirty stormwater network for a large region, which contains many network loops/cycles and non-directional features. The network is made up of Stormwater PipesStomrwater ConnectionsStormwater Channels/WatercoursesRivers/Large StreamsI would like to estimate the primary flow through the network with the following assumptionsFlow direction will be down hillAt network junctions, flow direction will be prioritized by edge typeRiversWatercourses/ChannelsPipesLarger PipesSmaller PipesI have made some progress using the Network Flow Orientor and Stream Priority Calculator (Im setting flow direction by finding the sink/source with the lowest elevation per network group). Prior to the Stream Priority Tool, I am assigning weights to edge features based on edge type, and using this as the forward and reverse weight.  

Hello everybody, I have a layer of points and I wanted to calculate the azimuth of each point, suddenly I thought to make a pythoncaller to call the API of QGis in order to use the Azimuth function, I'm a little stuck on this integration if you have any proposal, I will be recognizable.

Hi Everyone I have been trying to read pdfs and save to jpeg. The issue seems that I can only write 3 Bands to the Jpeg Writer(R,G,B). Once I remove the Alpha8 Channel, the background turns black. I have tried multiple ways of fixing it, but to no avail, I am stuck right now. I found this excellent Article on the forum, but I still seem to have the issue with the Colour Values, can someone please help out? Is there an elegant way of fixing this? I can succesfully export png, but can't crack this Jpeg Writer! Any help or advice will greatly appreciated. Fred  

Hi. I'm trying to read a pdf of a 2D CAD drawing. The file opens ok in Microsoft Edge browser but when I use the Adobe Geospatial PDF reader it is only reading a fraction of the elements in the file - a few text elements.  I've tried playing around with the reader parameters but cant figure out why its not reading the whole file. Any idea what i'm doing wrong?