Transformers

When my script comes to "Updating access token for 'zzzzz'" it stops. No errors or anything. When trying to make an new Onedrive Connection it just shows the OneDrive login briefly and stops. Has anyone experienced this?

Hi everyone.I want to find the difference between two tables. The first is a FGDB feature class. The second one is a XLSX files. I need to find if some value XLSX is absent in FGDB. I need to compare 4 different field, but not all fields.Thank for your help

Hi everyone, I want to update the metadata on ArcGIS Online. Is this possible?This was previously asked a few years ago but I cannot find anything more recent https://community.safe.com/s/question/0D54Q000080hFh4SAE/writing-metadata-to-arcgis-online Thanks  

Hello,     Our AV policy is set so that any unknown executable file is blocked unless it is trusted. There are two options for a file to get into this state:   1) The file is signed by a recognized Certification Authority  2) It has been analyzed by the AV itself (and it has to be executed prior to analysis)     This means that after every update we have to experience continuous blocks -as every dll is analyzed independently- until the whole program becomes functional.     As a good security practice that any mature software company should perform, could you please sign your code?    Thank you in advanced,

Previously for simplification purposes on reports, I would use the Total Count feature and define the attribute name as TOTAL for the number of objects with an id field. Now it dumps my counts to a field called id.total_count which I then have to run through an attributerenamer to change the attribute name to TOTAL which adds more transformation, clutters the workspace further, and uses more memory. Why was this function removed? Was it really such a big issue to be able to define the name of the output attribute?

Hi FME Community, I've been sent a spreadsheet with a series of rent entries. The name of the property, the dates and rent are the fields which are important. For each entry, which is a single line per rent payment, there may be an increase in the amount. This can be after 1 line, or 20. Basically, I need to only keep the entries which show an increase in rent amounts. Trying to find these entries and automate them seemed simple at first - but has stumped me. If anyone has any ideas, I'll be very grateful.Thank you

I have a problem with FeatureWriter on v2020.1 32bit I have no problem with direct connexion but i want use Summury result of FeatureWriter to continue insert or update on table and associated file.  this is the part logError connecting to PostgreSQL database(host='', port='', dbname='connexion validé', user='', password='***'): 'fe_sendauth: no password supplied I use a connection so I don't undersand why host, port and user is emptyI have test my connection and all are ok  

I have a 10-year-long dataset that needs to be split by year. The complication in my case is that I need each output year to start from December of the preceding year, i.e. the output filter for year 2019 has to be from 01/12/2018 00:00 to 01/01/2020 00:00. I can't seem to get this to work with AttributeRangeFilter. Cheers.

When running long jobs, the ability to provide an email address for sending a download URL to is very convenient. Unfortunately, this only seems to be provided with 'normal' jobs and not within a FME Server App.I did some searching and encountered this Idea (click). Of course I voted for this, but that will not help me out on the short term.I looked into modification of the notification message (e.g. using FMEServerNotifier transformer), but this does not appear to be possible. I would really like to stay away from solutions like chaining workspaces in Automations or using the emailer Transformer. Better would be to use the already available functionality for notifications.Anyone some ideas about fixing this?

Hi everyone , i need to write a gml . i have a set of xsd files and an example file (wkpb_voorbeeld.gml) how do i write a gml file like the example (the only thing i need to write in the gml is the poslist (geometry)

I need to write records to 3 different databases and then delete the source records from the source database. What is the best way of making sure the records are not deleted from the source before all the writes have completed?

I am trying to build an integration between a few of our vendors, and one of them requires us to connect to a Tibco JMS queue. I'm not a java guy, and have been trying to find some information to help get this going, but has anyone set up this connection before that could help me?  Thanks!

I was wondering if it would be possible to extract the text information about a pipe, the pipe is represented by a linestring, with the text being in close versinity to the line. And if it's possible, also extract the letter representing a manhole or point to which a line can connect.The red letters "A" represent manholes, the yellow line represents a pipe. Both the letters representing points and the lines have z values. The white text under the yellow line in the center, represents the name of the pipe type (KL200), and the text values in the start and the end of the line represents the elevation of the pipe. The value with the large font text (56186 and 56185) is the ID of the manholes. I have a structure in which I would like the data to fit but the whole, extract text information and apply it to the attribute of the nearest line or point is where my limited experience with FME holds me back. I have no idea if what I'm asking is even possible, but I think it might

Has anyone had success with using the Feature Reader to read JSON from an HTTPS call? I am trying to read a JSON string from an API into FME for processing. It works great when I use the "JSON Reader" (standalone reader). But I need to do some processing steps before it so trying to do the same thing using the Feature Reader transformer (reading JSON). I am having no success with the Feature Reader for reading any JSON strings. Every time I get the same error: Received HTTP response header: 'HTTP/1.1 401 Unauthorized'Configuration is the same in both the JSON reader and the Feature Reader transformer, including username/passwords, its using Basic authentication. Any tips would be appreciated.

Hi, I have a problem with the TESTER-Transformer. I test from two different sources: I make the following TestClause:The left attributes contains a string: C:\\Data\\DownloadAV\\AV_INTERLIS_DATEN\\ENTZIPPED_DATA\\http_download_1603358280779_10932\\Amtliche_Vermessung_-_Datenmodell_Schweiz_-DM01AVCH\\213-bruetten-gds.itf and the right a value of 213:The Clause is looking for the value 213 in the other string. It should be correct, but it never find it. If I make the compare in the following way, it works:Could anyone help me?thanks a lot 

Is it possible to create an FME Server App with a geocoder - so when users use the Geometry Picker tool they can search location and go to a location before start creating the geometry.Example with the default geometry example is Vancouver, BC.If you want to go to Toronto, ON is there a quicker way than zooming and panning? 

The files are in (5) different folders that i'm reading the data from. I'm writing the final mosaic out locally and as a single file at full resolution. These images cover a large area and the final product will be hosted on a web server. Any suggestions on best way to process this out than putting it all thru rastermosicker? My original flow is snipped below.

I am trying to de-cluter a set of points features and am not really getting the results I want. In the image below the points are the the input features and the pink areas shows the buffer to what was output after transformation. The upper left corner looks ok, but in the lower right the overall "shape" of the cluster has changed to much to my liking. Is there a way to prioritize the removal of features that are deep within the cluster versus those that are along the "borders"?I included a screen grab of the custom tranformer i created for this, it removes the features with the most overlaps step by step until everything is solitary. Any ideas on how to preserve more of the cluster shape while removing all "overlaps"?   

There is a single bug I am not able to solve since well over two days. This bug arises when working with Point clouds and Raster overlays. Below is Picture 1 showing a point cloud of the buildings of an area. Picture 2 is the same area of focus after setting a PointCloudOnRasterComponentSetter. The Transformer resets all of the z points and replaces them with the value on the Raster file. When I disallow overwrite, the z values are not altered at all.   1. Building Point cloud2. Point cloud with raster overlayI was wondering if there was a method for the Point cloud to add the raster cell values to the z component instead of rewriting them. Any help would be greatly appreciated.   

I have an attribute rounder which is rounding a figure to 2 decimal places with Round-off Direction set to nearest but when using 0.145 as an input is returning 0.14  1.145 as an input returns 1.15  Any ideas why, am I missing something?  FME 2014 SP2 (20140623 - Build 14339 - WIN32)

Hi,I have a png raster with RGBA bands, and I need to transform this raster into a single band grayscale (UInt32). By convention, we have set the leftmost bit in the Alpha channel to 1. This bit is to be ignored when computing the result (a "31 bit integer"), which should fit in the UInt32 type (isn't it?). In the rasterexpressionevaluator, I use the following formula: @if(A[3]<128,0,((A[3] -128)*256*256*256 + A[0]*256*256 + A[1]*256 + A[2])) However, when I try to use bitwise operators, only the value of the blue band (a[2]) is included in the result.  ((A[3] & 127) << 24) | (A[0] << 16) | (A[1] << 8) | A[2]) I used a simpler form for testing purposes (A[1] << 8), but this always evaluates to 0. I can't figure out how to use the bitwise operators, any help would be appreciated.   

I have a collection of points and for each point a heading is recorded. What I want to do is create lines for a specified distance (say 20 meters) in the direction of the heading recorded for each point. The start point will be the X/Y of the point.Does anyone have any ideas on how to get started with this?

I want to transform a raster with radar rain data. It is open data from the Dutch meteorological society, originally in a h5 format. Tackled all that I still have problems getting the projection right. I would like get it to wgs84/EPSG4326 or another one more commonly used. The projection is described as follows +proj=stere +x_0=0 +y_0=0 +lat_0=90 +lon_0=0 +lat_ts=60 +a=6378.388 +b=6356.906. FME doesn't recognise the string and I have tried to donwload additional ones from the website. Does anyone know how to solve this? The corner points are given in the picture.Thanks in advance!​

I have a point cloud that needs to be transformed from one projection to another, using specific 7 parameters. I've tried Reprojector and EsriReprojector but none of them allowed the usage of specific parameters. I'm new to FME so sorry in advance, thanks

Hi,I am quite new to XML and I would like to generate xml structured file using FME.For input I have a simple csv file with 3 columns:LOCALITATE (tanslation: Locality), STRADA (translation: Street) and NR (Translation: Number).Desired structure should be something like: <localitati> <localitate>Buftea</localitate> <strada>Parului</strada> <nr>1</nr> <nr>2</nr> <nr>3</nr> <strada>Independentei</strada> <nr>4</nr> <nr>5</nr> <nr>6</nr>...... <localitate>Mogosoaia</localitate> <strada>Printipala</strada> <nr>11</nr> <nr>12</nr>