Transformers

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 Selector I should use to extract the values of the table. Here is the HTML part of the webpage that contains the information I am looking for: <div class="horizontal-scroll-wrapper"> <table class="table table-bordered table-narrow">  <thead>  <tr>   <th width="30%" scope="col">Mesures</th>    <th class="text-center" scope="col&q

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 | Failed to write raster data tile when writing to raster dataset 'GEO_OWNER.AHN3_TEST_FEMSERACC'. The error number from ArcObjects is: '-2147155566'77 2021-6-11 07:57:51 | Storing feature(s) to FME feature store file `D:\Applic\Safe Software\FME Server\resources\logs\engine\current\jobs\0\job_172_log.ffs'78 2021-6-11 07:57:51 | +++++

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 way to control locking? I don't know why i

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_interpolateNodata' : 'No'}            raster_new = rst.calculateSlope(1,raster,settings)            feature.setGeometry(raster_new)This works, except that it still interpolates Nodata. So how should I write down the settings dict to tell the function not to interpolate and use the Horn method?     

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.  This method seems to prioritize streams and channels over pipes, however I'm not sure how I can prioritize larger pipes over smaller pipes. I have tried sorting pipes o

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?  

I'm reading archived tables with the GEODATABASE_SDE format, i.e. with connection file. I'm trying to access the special archive views for this occassion. The ones that SDE creates automatically which has the "_EVW" postfix. Though I cant see them in the list of available geometry tables. I'm connecting as the schema owner with a FeatureReader. How does this work? Does FME figure that out automatically? For example if I read features from table "SAMPLES", the question actually directs to SAMPLES_EVW view? Or does it work any other way. I did some tests and created a logger which helped me out with the number of features read.  For one of the tables I got the logger saying that it "Cloned 841467 input feature(s)" When counting the records in the database I got the numbers:Table: 840 225EVW-view: 840 227 Three different numbers is what made me write this question. So how does this actually work?    

Hi. I am using GeometryValidator for some buildings as multisolids. All of them has been created together, but after the GeometryValidator, some of them come out from Failed part. I need all the 3D buildings. Can I repair them before the GeometryValidator?I set the set of issues to Detect to Surfaces and Solids. Thanks 

I have saved MVT tiles locally like this, c:/3006/0(zoom level)/0(Tilecol)/0(Tilerow).mvtInformation about the tileset below.<TileMatrixSetLink><TileMatrixSet>3006</TileMatrixSet></TileMatrixSetLink> <TileMatrix><ows:Identifier>10</ows:Identifier><ScaleDenominator>14285.71428571428623399697</ScaleDenominator><TopLeftCorner>8500000.000000 -1200000.000000</TopLeftCorner><TileWidth>256</TileWidth><TileHeight>256</TileHeight><MatrixWidth>4096</MatrixWidth><MatrixHeight>4096</MatrixHeight> When I RUN the Workspace I get this translation log (see link) and no GeoJSON file is to be seen. What do I do wrong? https://docs.google.com/document/d/1u-BgtK6lU4SUKFFPjG-lv4Gs2VYHLc7AIOXo-Is_QB8/edit?usp=sharing 

Hello,I am trying to POST an XML using the HTTP Caller, but get a 415 error.I have an API tool for the application that I am trying interact with, and manage to POST the XML with success.I have seen other posts that suggest it is the header of the XML / Content Type option which is incorrect, but I have tried all the options I can think of. Any help would be appreciated. I have pasted the XML I am using below, and attached the test  workbench I'm using. Note that I have deleted credentials / sensitive information.Cheers<?xml version="1.0" encoding="utf-8" standalone="yes"?><Mail> <TotalAttachmentCount>0</TotalAttachmentCount> <Confidential>false</Confidential> <RichMailText>false</RichMailText> <MailSubject>TEST2</MailSubject> <ToUserId>1476934057</ToUserId> <MailTypeId>2154</MailTypeId> <MailFormFields> <MailFormField identifier="DesignPackage_singleSelect">N/A - Not Applicable</MailFor