Transformers

HI there,I have access to an API that returns flow data. The data is structured with a serial id (unique to each logger), ID (sequential, but only to each logger) and the data value (float).The API would run every 12 hours and just would return the last 12 hours of data with overlaps. The API creators have suggested that by fetching the max ID for each serial number in the existing data I should be able to return the data from the api that doesn't already exist. There is no provision in the API to pass these values as a parameter so will be using FME to achieve this.I could output the data from the api into a holding table and use a FeatureJoiner to the existing data so insert the new rows, but the static table will grow exponentially and I can see this becoming a huge problem in time.Is there a way to grab the max ID for each serial number from the static table, fire this against the holding table and grab only the new values which are greater than the max(ID) for each serial no

i have a road network of 4 areas and it is categorized as external and internal road, The features has an attribute as number of lanes so i want a HTML or Excel file based on the total sum of lengths each lane has. Thanks in Advance

I have a py script. It takes in 3 parameter,Input file gdbFeatureClass nameOutput file gdbWhat it does, is to copy the contends of the featureclass to the outputfile gdb and I would like to convert it to FME Can some help me with this conversion? Please remember it may be configured for any filegdb and any featureclass name so a static linking won't work. My initial findings is the use of "Generic" option of FeatureReader

Each .DWG file has to haev the same file name as the source .LAS that it is converted from. what is the best way to set this up so it converts all of them one at a time without too much user input?

Despite the fact that the nad83 and wgs84 datums are supposedly identical, there are several ways to get from one to the other and they result in different placement. ESRI recommends this transformation: WGS_1984_(ITRF00)_To_NAD_1983FME appears to use this one: nad_1983_to_wgs_1984_1 I am using AttributeReprojector on a dataset with several coordinate systems. Is it possible to indicate a specific geographic transformation for nad83 to wgs84 when using this? Thank you, Randy McGregor

Hello everyone I got a little lost in this problem, I have three columns segment, direction.I would like to obtain another order column which will be incremented in the event that we have a change either on the segments or on the direction, I tried to give you an example which explains the situation, thank you in advance

Folks, we are trying to call an Oracle Stored Procedure using SQLExecutor that send the student information and it return student_id back to FmE to be used in subsequenct translations. any idea how to do it in FME. store procedure nameintsertStudent(name,address,class) return student_id.Apprciate your help!    

Hello. I would like to know How can I use FME to transform KML to CAD with 3D shape.The first image below is my KML file in Google Earth which I use 3DForcer to generate the height of buildings.I also want to see them in AutoCAD, so I transform this KML file to DWG without any transformers.Only the reader and the writer.I refered this question:https://community.safe.com/s/question/0D54Q000080hgkVSAQ/converting-kml-to-dwg-stretches-the-original-shapeBut the result seems that there's no height line in CADI want CAD shows just what I saw in the Google Earth, How can I do that ?

I am reading an Oracle spatial table and writing the content to an ArcGIS Online feature layer (hosted). There are no transformers in between. The shape_area in the ArcGIS Online feature layer is larger than the actual area the object has in Oracle. there is a factor of 2.61 between them.There seems to be a new area calculation taking place in the writer writing to the ArcGIS Online feature layer that does not seem to be right.How can I prevent that? Greetings, Hans

I've got two data sets with some commonality in length data, one coming from KMZ (S1) and one a csv with no spatial data (S2). I would like to merge the datasets. S1 stores lengths as stationing with start and stop (St. 0, End 100)S2 stores lengths as stationing but more granular (St 0, End 25 etc) My first thought is to try and split stationing from S1 to match S2 then merge the geometry to S2 since that has the data I want to keep but I'm wondering if there is a way to do this I haven't come across yet. Any Ideas?

I want to find the biggest possible box inside an area, like the opposite of a bounding box. It should also be oriented.

I am looking for a sumproduct like function in excel that i can use on data i have in FME. What i am really after is a weighted average of certain groups of data. I have the products solved for in separate fields but i can't sum within their groups.

i would like to use OSM Openstreemap , i have downloaded BPF for a city from Geofabrik Download server ,is that the correct extension or which extension should i download ?  could someone provide me with an example for OSM Workspace ?and what shoud i do ? i would like to show output geographical map for polygon as Google maps . FME 2018Thanks in advance

I am trying to split an attribute using a regular expression as there may be differences within the attribute. For Example the attribute may be as AA9A or B7BHowever some of the attributes are formatted as CC7 or DD6 I therefore do not want to remove the last character from these, all I need to extract is AA9 or B7. Is there a way with a regular expression to search for a character, potential character and then a digit?Or is there a better way to achieve what i am trying to do??Thanks in advanceAndy  

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 2 with it - and so forth. Doing it thi

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 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?