Transformers

Need a outputOutput from JoinerMy linked xcel file

Hi, I have observed that the pixel values of sentinelhub data and S3 bucket data are different. I have tested by downloading same date tiles from sentinel hub and FME S3 Bucket. Do anyone know why the values are different? or which data to use is preferable like is the error is in sentinel hub or S3 bucket or FME extraction.

Hello,I'm trying to figure out a way how to do a data profile, similiar to skim in R.Something like this:But idealy without having to use the Python, or R caller...The statistics calculator does count, min, max, etc, that helps. But I need unique, missing and nulls as well.Is there a simple way how to do this in FME? 

Hi, We have a workspace that runs fine on our FME Server testing environment yet crashes on our user acceptance environment. It crashes on version incompatibility, like described in the article at https://knowledge.safe.com/articles/363/workspace-fails-on-fme-server-fme-version-incompat.html. Granted, we use FME Server build 17650/win64/2017.1.1.0 and FME Desktop build 17652/win64/2017.1.1.1. that would be a cause for not running a workspace due to compatibility issues.However, this baffles me: FME Server version is the same, workspace is the same, what else could cause this behaviour? I narrowed it down to the workspace below, which is basically a SpatialRelator comparing two box-like area's. Our testing environment runs it just fine, and concludes in the log:2019-10-09 12:23:30|   0.3|  0.0|INFORM|Loaded module 'SpatialRelationshipFactory' from file 'D:\Prog\FME\FMEServer\Server\fme\plugins/SpatialRelationshipFactory.dll'2019-10-09 12:23:30|   0.3|  0.0|INFORM|FME API version of modu

I have downloaded a date range images of sentinel 2, performed clipping (polygon) and calculated NDVI. Then I have converted raster to point and extracted each pixel values parallely extracted coordinates from coordinate extracter. So in attribute table I have date for each pixel, NDVI value of each pixel , latitude and longitude of each pixel. But I need attribute table structure as Latitude, Longitude and each day Ndvi values. So each date of image generated should create a column and writes NDVI values for same lat longs.

Hello,I want to find a regex with python caller.  The text_line is like Híd neve: Líra utca -  gyalogos híd. And I want to get only: Líra utca -  gyalogos hídI was able to do it with StringSearcher, where the expression for the regex was like : (?<=Híd neve: )\w.* Now I am tring it within python, but it doesn't give back value (it should be like: Líra utca - Ördög-árok feletti gyalogos híd)Could you help me, where is the mistake?class FeatureProcessor(object):    def __init__(self):        self.comp_re = re.compile("(?<=Híd neve: )\w.*")        #pass    def input(self,feature):        text_line = feature.getAttribute('text_line_data')        matches = self.comp_re.findall(text_line)        if matches:            feature.setAttribute('PyTrackExtents', matches[0])        self.pyoutput(feature)

This is very country-specific as Interlis is only used in Switzerland, and FME relies on a plugin (Eisenhut) to read/write Interlis-Data.I have done a lot in Interlis1 (ASCII), which always worked like a charm. No I am on my first Interlis2 (XML) project, which also worked fine just to this problem.FeatureTypes and their attributes in Interlis are set by an Interlis Model (*.ili). In this model there is also set which "attribute" is used to store the geometry per featuretype. So, e.g. a line in interlis stores its geometry in the attribute "Lage" (which stands for "position" translated in English)For the Labels, I now have two Classes "InfrastrukturHaltung_Text" and "InfrastrukturKnoten_Text". For this Label-Classes the defined attribute for geometry is "Textpos" (stands for "textposition").  My problem now is, that after importing these two featuretypes, FME always writes them without the geometry attribute. There i

Hello!I am learning to use PythonCaller. I want to write an attribute into a new attribute. My code is running without fail, but it doesn't write the value (data) into the new attribute (item_no).Where is my mistake? class FeatureProcessor(object):    def __init__(self):        pass    def input(self,feature):        #for n in range(10):        new_feature = feature.clone()        data = feature.getAttribute('Data')        new_feature.setAttribute('item_no', data)        self.pyoutput(new_feature)    def close(self):        pass

Hi everyone,This is what I have currently: And this is what I want: Thanks for helping in advance!

My agency flew high resolution drone aerial imagery and need to blur certain areas of the image, for example certain members of the public have asked that their backyards be blurred for privacy reasons. My rasters are very large GeoTiffs.If it were only a few locations I would simply use GIMP/photoshop, however its looking to be a significant number of locations that need to be blurred. I have created polygon features around the regions that are to be blurred, I am assuming that FME can blur the raster areas contained within the polygons without me having to clip those areas out, blur them, and then mosaic them back over the original image? Clipping & re-mosaicing would take a long time since the images I'm working with are >100GB.Searching the documentation references to the RasterConvolver however I don't see how I can apply that only to the areas within the polygons.Is there a good method to achieve my goals with FME or should I stick to GIMP/Photoshop??

Hi. I'm working on a workbench for migration of some data from one datamodel (MS Access) to another (MS SQL Server). One of the original tables contains information about contracts and contains the following fields:contractid - companyid - signedDate - expirationDate - revisedid - revisedDateWhen one of the contracts (A) has expired and has been revised, a new contract (B) has been added to the table and the field revisedid in the former row (A) is updated to contain the contractid to the latter one (B).My problem is how to add this in the new datamodel. The corresponding table in the new datamodel has a identity field as primary key (ConsessionID), and the table does not contain any reference to the old contractid. I've added a featurewriter-transformer to write the new row, and I need to update the rows with the new contractid for revised contracts. What's the best way to accomplish this? My first (and best?) guess is to use a featurereader after the featurewriter, to get

 Hi, I have a procedure I want to call from an oracle database-- In Oracle SQL this would be executed as follows (variables for address_heading and address id must be declared): execute clar.clar.get_address_model_building(38660795, address_headings, address); Im using the sql executor but cant seem to get it to run successfully. It should return a value like thisBN 1T 1L C* DAVIS COURT, MAIN STREET, HEADFORD, CO. GALWAY I have tried various iterations but just keep getting did not succeed; error was `ORA-00900: invalid SQL statement' Any advice on what I need to pass in to run the procedure and return a result? Thanks

I have got line objects, and a rasterdataset with elevation data.I try to get both minimum and maximum elevation values as an attribute to the lines, but just can't find out how.Does anyone know how to do this? 

Hi,I have a number of points on a road network in CSV format with Lats and Longs as well as a shape file of the surrounding road network. I want to break up the sections of road network between my points so I can assign a value to sections of road based on traffic flows. I am currently using PointOnLineOverlayer but it is rejecting all features. Is this the correct transformer to be using?Thanks, Matt

What transformers do I need to generate a report from a number or features like these?LAYERVALUECHECK_CLASSATTRIBUTEVALUEID1ID2SitesOut of domainSite_typeHistorical45SS023SitesOut of domainSite_typeNature cons60SS017Info_pointsOut of domainFacilityMMC22IP06Info_pointsNot a numberNum_visitsAbout 1015IP08StopsToo longVisibilityNot so good25ST041SitesOt of domainSite_typeHistorical31SS001SitesToo longIn_siteEmma (except Mondays)21SS015SitesOut of domainCertificCHECK62SS030 I need to generate a tree report showing for every LAYER every different VALUECHECK_CLASS, and for every VALUECHECK_CLASS every different ATTRIBUTE. And then show a table or anything similar with VALUES checked and the feature IDs (sorted if possible).Something like this:Sites1. Out of domainSite_typeValuesGlobal IdLayer IdHistorical31 45SS001 SS023Natural cons60ss017Values Global Id Layer IdValuesGlobal IdLayer IdCHECK 62 SS030 2. Too longIn_siteValuesGlobal IdLayer IdEmma (except Mondays)21SS015 Info_points 1. Out of

BonjourEst il possible de realiser le contournement des surfaces comme montrer ci dessous avec FME ? Merci d'avance.

Hi! I am new to the JSON format and even newer on how to tackle it in FME!I beleive my question is quite basic but i havnt figured it out with the tutorials etc I have found. So, on to the problem!I would like to fragment a json into its separate parts (see code and the desired output down below)Here are two tests Ive made but havnt had much success.  My hope is to get something like this in excel as a proof of concept from the code provided down below.Any help is appreciated!/David Source jsoncode:{  "id": 182,  "structureId": "cb52a3db-1260-454a-b3d9-08693f27b2db",  "title": "FME TEST",  "description": "",  "coClassVersionId": 7,  "structureItems": [{  "itemId": 3187,  "classDetails": {  "id": 295727,  "categoryId": 152,  "title": "Bro",  "identifier": "CAA",  "categoryIdent

Hi All,One of our customers was upgrading their Acceptance and Production servers (VM's) with ArcGIS Pro / FME 2014 DataInteroperability 32-bits and ran into a strange problem. Both machines were equal configured with the same software .Resources: New Acceptance server 4 GB and 2 Cores New Production server 12 GB and 4 Cores, because more is betterand running a workspace with a FeatureMerger (merging 2 x 1 mln+ features together) and several joiners on the new Acceptance machine was performing just like the old (A & P) environment, merging the features within 3 minutes. However, on the new Production the Featuremerger slowed down to 0.0x% features merged and was optimizing memory all the time so it could run all over the weekend without ending.Installed a separate FME Desktop to exclude possible influence of ArcGIS and DataInterop, but without result.Because the 'hardware' resources were the only differences, I suggested to downgrade the Production server to the same co

Good Morning!I'm having trouble generating a stream that converts data of type MDSYS.SDO_GEOMETRY (oracle spatial) to SDE.ST_GEOMETRY (arcgis).If it is possible, is there any procedure or manual to perform this activity?Thanks in advance for your cooperation Explo:

How to extract sentinel images for every 5 days interval and should get the latest image in overlapping regions.

I want to save the coordinates for all the parcels in the map. I have taken a parcel data in Auto cad dwg format and applied an area builder to it.

Hello there we are reading an XML URL , in order to extract the features and values,we used the XML fragmenter, the problem is we need to enter the attribute to expose into the transformer setting , is there a way we could dynamically read them, because there large number and also avoid any typo problem.  

The datasets are updates and should have the same ID. I don't know how to ensure that the polygons are the same or different for the exact same ID. Is there a way to set the ID as the method of checking the polygon? I think I'm missing something simple.

Hello,I need to migrate an FME script with PythonCaller, from FME 2016.1.3.2 to FME 2017.1.1.2, but there are differences.The PythonCaller write to a TXT file, but the problem is not when it is writing : i tried with a print "test" : it works fine with FME 2016 and it doesn't work with FME 2016.367 features passed into the PythonCaller : The features with the problem are with fme_feature_type "schema" : Is there a difference between 2016 and 2017 in PythonCallers ? The Python Interpreter is the same (2.7). Here is the Python Script (I simplified the script with only elements causing problems)  :  # -*- coding:utf-8 -*-import fmeimport fmeobjectsimport osimport unicodedatafrom datetime import datefrom datetime import datetime# Template Function interface:def processFeature(feature):    pass# Template Class Interface:class FeatureProcessor(object):    def __init__(self):                self.countfeatures = 0        self.err_structure = ""                    def input(self,feature):      

Hi In my windows 2016 data center sever, installed FME Desktop 2019 (Build 19246-win 64) edition. It connected to another flexnet floating license server [FlexNet Licensing (v11.16.2.1 build 245043 x64_n6)] which has valid licenses . I can do nslookup of license server with aliasm works good.  On opening FME work bench, it crashes immediately (screen disappears without any message) on loading transfer stage. This is brand new installation. Any clues. Checked all .dat files,but could not find cause for this behaviour.