Transformers

 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.

I just noticed the question numbers in the url and it looks like we're only a few hundred away from the 100,000th question. Maybe Safe can reward that question and the correct answer(s) with a special badge or something? @nataliewlock

Hi all,I am currently trying to explore within FME where I can get information of an account expiring beyond its 90 day period or close to expiring based on the AccountDate Field I have below.I have managed to use datetimeconvertor and then used attribute manager to create 30,7, expired and expired30 days columns. I have also attempted to use the tester with following parameter @DateTimeAdd(@Value(Date ) ,P90D) but this has still not given me the result i was after.What i am trying to get FME to do is to populate the 30 days, 7 days, expired and expired30days columns with either a Y or N based on the account age which is a range of 90 days.

Hi,I would like to insert a table into a pdf. Indeed, I extract datas from a Excel table. I have used PDFpageFormater. However, it seems that only picture are allowed to appear in the pdf. Which transformers that I have to use to get what I want ? Thanks for your help

Hello, I have created using TIN Generator a TIN Surface. The output geometry originally is IFME Mesh. I want to create a solid for AutoCAD Civil 3D. I have tried everything I can think of (incl. setting Geometry Coercer to brep solid) but the result is this:It still appears as a polyface mesh in AutoCAD and in FME the outer surface remains a mesh. Any ideas? Thank you. George

I have download B4 and B8 band from S3 and create NDVI image but unable to convert in CSV

I have being trying to get the TesseractCaller to work, to get text out of images into GIS. The TesseractCaller always outputs in the <Rejected> port. I found this Forum "https://knowledge.safe.com/questions/81922/the-tesseractcaller-only-returns-75-of-the-image-a.html " where TesseractCaller was working, so I downloaded the FME Workbench and the pdf from that forum and tried to run it on my end to see an output, but nothing. For the couple of runs I was using Tesseract version 5, I installed version 4 but it also fails. I'm trying to get text of an image into GIS, if not easily to GIS, Excel will work. I have attached the log file I am getting after running the attached Workbench. @dmitribagh - i have made this forum following the conversation in the other forum . @danilo_fme - saw that you had help someone in another forum related to this topic. 

I draw 3D polyline at AutoCADand save it dwg&dxf import at FME WorkbenchI wanna convert 3D polyline to 3d Polygon.3D polyline is all topologically conneted.This is CAD VIEW.(FIle attached so you can download it) Actually it's Drawing related to road construction.This layer name 'Side gutter'I wanna display at CesiumJS with photogrammetry modelLike ThisI tried many complex combination of transform(e.g 'Chopper', "AreaBuilder', 'LineCombiner', 'Linecloser', 'GeometryCoercer') but there was no result that i want.The result was Some surface(polygon) is not make.In spite of 3D polyline is topologically connected  

Hi. I have a workspace that uses custom python module inside a python caller. I'm trying to run the workspace via FME server. I've set my python compatibility to 3.5+ and uploaded the python module that i'm using to the servers engine\\plugins\\python\\python35 folder according to the FME instructions here:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Importing_Custom_Python_Modules_FMEServer.htm However, the workspace yet can't locate the module and i'm still getting the error "no module xx found"What i'm doing wrong? Where should i copy the module? I can't use pip install, because the server machine does not have internet access. I've managed to work this around somehow before, but now the server has been updated and the module is gone. So what actually is the correct path to the python that FME server is using? Is there a way to check it out?

Hi people,  I'm hoping someone from Safe can provide some insight into how the volume calculator works. I've been tasked with calculating the volumes of a few things which may potentially contain solids with invalid geometries (not closed etc). I was thinking that the VolumeCalculator would need a proper closed solid in order to calculate the volume, however, to my delight, I found that it worked on invalid solids as well.  My question though, is how does it figure out the volume. I've attached an example where I have removed a couple of surfaces from a box and then Coerced it back into a solid.  The VolumeCalculator returns a volume of 0.6667 m3 when two sides of the cube are removed.  Any inside knowledge on this would be great. @mark2atsafe @danatsafe?  

Hi,I am the new in services (the fme http caller/the postman request etc.)I have a workbench which is included an xml writer. When I send a call from the postman, I am getting the result of the job status information like below;RESPONCE{ "timeRequested": "2019-05-20T10:39:19+03:00", "requesterResultPort": 51487, "numFeaturesOutput": 325, "requesterHost": "177.11.19.5", "timeStarted": "2019-05-20T10:39:19+03:00", "id": 9233, "timeFinished": "2019-05-20T10:39:54+03:00", "priority": -1, "statusMessage": "Translation Successful", "status": "SUCCESS"} the orijinal xml result below But I want to see as like below in the postman screen or in any explorer crome etc.I mean that once it finished, I don't want to download the result, I want to see as xml directly on window looks as below    

Does anyone know if their is a tramsfromer in FME like Symmetrical Difference that exists in ArcGIS. If no transformer exists is it possible to use a combination of them to acheive the same results?  Thanks,  Vince