Transformers

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,

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 suggest

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)  : 

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 fo

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 mo

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

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

"FindRegEx(str, regExp, [startIdx], [caseSensitive], [-1])... If -1 is specified, FindRegEx() returns the index in str starting at startIdx from the end of str going backwards." I cannot make the backwards search work. Did I do anything wrong? Tried with Desktop 2019 and 2018. It worked in the past as I remember. 

Hi all!  I wonder if there is a way to write a multi-page PDF which can accommodate a 3D model? In practice I can write two separate multi-paged .pdf files (3D and geospatial), however when I try to write all data in one 3D .pdf 2D data with text and images etc. dissapear or get integrated into the 3D show box.  I can achieve page merging outside FME, but would rather have all in one workflow.  Are there any successful practices out there? Thanks for sharing your solutions or helping to resolve mine!  Cheers!

Bonjour . Quelles transformers prendre projeter des points sur une ligne la plus proche et ensuite les relier au point d origine. Merci pour votre aide

Hi everybody.I would like to merge all possibilities of 2 tables in once like that :It is possible ?Thank you very much.

Hello Friends, Since I am learning new transformations and new to FME tool. Could someone please guide me how to load a data from one table to another ( 100% dump)? which transformation to use? I use SQL executor when I wrote Select * from table1 and mapped result output to Writer. Is there any other way? Thank you in advance!