Transformers

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

"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!

ArcGIS Intersect gets the exact result I need, but this task needs to be performed in FME. I haven't been able to find the exact output result. With Spatial Filter it did not duplicate the results if the same line fell within two or more buffers, it would only grab it once. Below is an illustration of what I would like to achieve. Also, of course, I would want this to produce an excel report on which buffers intersected which lines

HiI have generated a Convex Hull table for a address table, grouping by postcode in the address table.I want to print individual maps for each of these postcode areas based on whether they would be betteroff in Portrait or Landscape Orientation.Can someone advise how i obtain the Bounding Box Ratio for each of the Hulls?I've added the Bounds Extractor transformer into my workspace, but that doesn't seem to give me the ratio.Is there a way of updating a new column (to indicate which orientation is best) using a calculation within FME?Thanks for any assistance Simon Hume 

I have two feature classes one is point data another one line data that is Road and I need to select only which points are placed in between DC road.Refer Below Image for more clarity Please suggest...

Hi All,I've got a situation where I am dynamically feature reading in any number of feature types, and exporting via the generic port. I then have a list of all possible feature types and the schema mapping required. Am I right in assuming the SchemaMapper requires attributes to be exposed to be "mapped"? I'm looking for a solution where the SchemaMapper can see the dynamic unexposed attributes and map them.

In case you missed it, Craig, the leader of our sales team, decided to launch himself off the side of a hi-rise building last week. Don't worry he was all strapped in and it was for a great cause.So I thought this picture is a great opportunity to have a caption competition here. You know, what FME-related thought might Craig have been thinking as he prepared himself for his descent?Perhaps, "I sure hope these guys used a StringLengthCalculator"?!There's no prize for guessing what Craig was really thinking, but then there are no prizes for your captions either, except for maybe some reputation points and the admiration of the FME community. So post your suggestions below. Keep it clean, please! And if you want to see more, then we have a video of the event on Safe Software's LinkedIn page.Mark

Hello, I have a BLOB field, it is supposedly multiple points that form a polyline, but I cannot export the blob into a usable geometry. I have tried GeometryReplacer and GeometryExtractor but I have not been able to get usable results. I attached an excel file with the BLOBs

I have 2 dates and an interval.I need at least to generate a list of dates between given ones with a certain interval (step).As a maximum I need to combine list of dates with list of items.Please refer to the picture below.

Hello Community,I am having some challenges writing multiple records into a valid json output. What I have is working using a text writer but it is missing the comma "," between the individual records. I was about to explore building a list and change my json template or do i need an aggregate? I seem to be confusing myself with this small detail.Below is an example of my current output into a text writer. I pretty much followed the Json Writer article (https://knowledge.safe.com/articles/44294/json-writing-with-jsontemplater.html ) which was a huge help but the difference here is I am fanning the output by date so multiple records will be written I just cannot figure out how to make the json valid.20190711.jsonI believe just need a comma to separate these 2 records to make it validAny help would be appreciated!!ThanksRonnie

Hello,Is there a possibility to change the start/end point of closed curve? I created closed curves using the LineCombiner (for merging line segments to 1 closed track with the same start and end point). Now I have a shapefile with starting points of tracks, and I want the closed curves to start/end in their starting point instead of the random start/end that is created whith the LineCombiner. Anyone an idea how to do this?