Transformers

How to extract the attribute from the Json file , with the content I trauied all Json transformer but did give me what I am looking for Json content[{"code":"EPSG:4326"},{"x":"41.86306379123165","y":"19.05070466974152"},{"x":"41.86136208513543","y":"19.048743553071773"},{"x":"41.8575815484205","y":"19.05212744890353"},{"x":"41.86306379123165","y":"19.05070466974152"}]we want this

The FME integration with ArcGis/ArcMap is used only read and write different formats or it´s possible to use FME transformers in ArcMap?Thank´s

Dear FME community.I've to extract geometries from ORACLE SDO GEOMETRY for insert them into Postgis DataBase.The geometries in Postgis must be with type 'MULTILINESTRING' but my ORACLE SDO GEOMETRY are in 'LINESTRING'.I try this solutions :In postgis : to make a trigger for transform geometries before integration with postgis function ST_Multi but that don't work.In FME : to use GeometryCoercer but all geometries are untouched In FME : to use GeometryRefiner without successIn ORACLE : to transform the source geometry but that doesn't worksAny idea ?

Hi All, the blue line is going from Polygon A to B. It passes several polygons on its way (most of them are magenta).With the SpatialRelator, it is fairly easy to get a list of these polygons. However, I should be able to sort this list in the order of the polygons the line passes. Anyone done this before?I replaced the rectangles with their Centre Point and created a network between these points. The ShortestPathFinder does not allow to force passing in each point. It just takes the shortest route in that case.best regards, Jelle

Dear FME Users,  Have you ever used Dissolver transformer? Did it serve the purpose?  Our Geometry Team is working on Dissolver Performance Improvement project. They have lots of brilliant ideas - while I do not understand all the details, the team is so excited I have no doubts Dissolver is up to remarkable improvement.   The Team would like to hear from the users. If you have a workflow that involves Dissolver and are not satisfied with the performance, please let us know. If you have a dataset Dissolver is struggling to dissolve, please share the dataset with us - we would like to make sure we test all the edge cases. If you have a dataset Dissolver is very efficient with, please don't hesitate to mention it as well - we want the updated Dissolver to be as fast as the current version or faster while processing your dataset.  Please add a comment below, share your dataset through

Hi all,  I'm very new to regular expressions but need to use one to extract coordinates from a single field into their individual elements. The number of characters varies for each feature, so I can't use a substring extractor. Essentially I want a regex to extract the first coordinate in the brackets, and the second as their own attributes.  Some examples:   POINT (1764887.456903827 5905612.28425431) POINT (1749937.56 5913840.62)  Where I want separate attributes: X: 1764887.456903827 Y: 5905612.28425431 Many thanks, Kieran

I am a new user trying to split out TRUE FALSE values contained in column Web with the TestFilter, but can't seem to hit on the correct Test Condition. Each time I Run Translation everything goes through to Unfiltered. It would appear that the TestFilter isn't recognising Alpha characters.When I change alpha TRUE to numeric 1 then the TestFilter works fine. This doesn't help when I have Alpha Numeric values such as 06HaaR.I would value assistance in this regard please.Cheers

I am trying to calculate areas in a sloped terrain. I am approaching the scripts with DEM and AreaCalculator Transformer with Type: Sloped Area. If I converted the DEM to polygons using RasterCellCorcer using 3D Forcer Transformer to have the z on the polygons, they still horizontal, thu I got the same area as the plane area. Any ideas how to calculate sloped areas with a DEM?

DWG file include different layers, each layer include different information which I am not familier with, please advise how to convert DWG file to several SHP (each shp is one layer from DWG)?

Hi all,I'm using FME to connect to this SDK with a httpcaller transformer. However, if I want to retrieve the ExceptionEvent (where rules are broken), i need to include additional information in my GET.This is my current get: https://my42.geotab.com/apiv1/Get?ExceptionEventSearch={"database":"xxx","userName":"pwiles@stars.ca","password":"xxx"}I get a error when trying to use this GET. The error that is returned is the following:_response_body (encoded: UTF-8): {"error":{"message":"The method \\\\u0022Get\\\\u0022 could not be found. Verify the method name and ensure all method parameters are included.","code":-32601,"data":{"id":"11773710-4ab7-4507-

Hello,I have 2 polygons overlapped. I'd like to split polygons into two A, B. Have tried with DonutBuilder and DonutHoleExtractor transformers, but it still looks overlapped Please advise how to split the polygons. Original PolygonOutput Polygon after using DonutBuilder / DonutHoleExtractor:In Fig-1, the polygons are overlapped.In Fig-2, here the polygon is highlighted when we click on it.Tagging @takashi, @david_r, @DaveAtSafe

I inherited FME and basically just kept using what previously worked. We've now upgraded to 2017 and I'm finding many of the older components don't work after upgrading. Our previous reader was GEODATABASE_MDB and our previous writer was ORACLE8I. It appears there's not new equivalents for these. What is the best approach to finding the "new" equivalent of old readers/writers, as searching the web seems to produce very little.

Hi!I have a XML file with opening hours of corresponding days of a week.Sometimes I don`t have the opening hour of a certain day; but I still have the title of the day in the xml file. As shown here, I have empty FRIDAY and SATURDAY elements. What I need is to remove the OperatingTime element totally, if dayOfweek does not have any value. As it is shown here, the elements for FRIDAY and SATURDAY removed.As I have many records like this, I believe Pyhtoncaller or InlineQuery would fix it quickly but I couldnt manage to do it. Could you help me with that?Thanks!

Hi, I am transforming microstation files (DGN V7) from an local (ADN1953) coordinate system to microstation files (dgn V7) another local coordinate system (AGN2005). The arc features are not going over.

Hello There we are looking to query the count of all the table from ESRI web feature service URL any idea how we could do that, the syntax we should use, we want only the table name and total feature in each one thanks

is there a transformer to convert coordinate unit from meter to DD or the opposite Thanks

Hi,I have a road network as the base, I have a start and end co-ordinate and for the shortest path to be determined using the underlying road network, I am using the following transformers, VertexCreator, AttributeCreator, PointConnector and ShortestPathFinder.This appears to be doing what I need quite well.The problem is where there are multiple start or end points, or if there are other complex networks in the middle of the created line, the option of doing the above but creating a line with multiple start and end points and using multiple PointConnector transformers. Is there a more simpler method in doing this?Many thanks

Hi,I search for a simple way to do this:- copy a file named "test.xlsx" as "test2.xlsx" in the same directory and- copy the file "test2.xlsx" obtained as "test2 - 20180725.xlsx" in the same directorywith a simple script at the end of a workbenchthank you

Hi,I am picking up some JSON from a feature reader and outputting to Excel. It works fine but I would like to order the Excel output so that some header fields are always returned first, e,g, ID, Name, CountryThe trouble is that this JSON is dynamic and sometimes doesnt include the attribute 'Country' if it hasn't been populated. This means when the JSON gets brought in and the first record doesnt contain country then it would look structure like so:ID, NAME, FieldA, CountryIs there any way I can partially define the schema whilst leaving the rest dynamic?Thank youOliver

Hello,I have to export a bunch of point and line feature classes with their feature-linked annotation from SDE to a file geodatabase and then also zip the file geodatabase.The annotation bit is taking a long time and log file reports a large number of warnings. Any ideas what's the most efficient way to do this?

I have an UpdateDetector, but instead of hard-coding the "attributes to match" via the GUI, I would like to pass them in via a user parameter, which is ultimately populated from a spreadsheet via Python. (In fact, because I am using generic outputs for the FeatureReaders, I don't get the GUI option to add attributes.)Unfortunately, it appears I can only pass in a single value this way. If I pass in any more, as a space-delimited list for example, the UpdateDetector appears to just ignore the values passed in and reports all rows as Unchanged.Is there any way of supplying multiple attributes to match using the approach I'm using?I have attached a screenshot of my workspace, which uploads a file gdb data source, saves it to a table and then just compares that table with an existing table.

I am needing to set up a user parameter that will list text values. For Example, PR01 EZ01 BR01The Idea here is to be able to use this list with an SQL Creator as such:In FME -- Select * from <table> where Sys_Code IN ($(sys_code))Or Oracle SQL -- Select * from <table> where Sys_Code IN ('PR01','EZ01','BR01')Any help is appriciated.

Hi,I have this data below which I would like to transform into a single record per row.key. How do I do it?Ideal output would be 2 records with field.name converted to columns.Cheers

I found some help in an earlier post in regards to this (https://knowledge.safe.com/questions/46672/change-degree-minute-seconds-hemisphere-to-decimal.html), but the format of my DMS lat longs is different (I have spaces between the DMS values and my lat/long DMS values are separated). I tried to edit the regex from that post to no avail while trying to extrapolate my latitude DMS values...(\\d+\\.?\\d*)|([NSEW])(\\d+\\.? \\d*)|([NSEW])(\\d+\\.? \\d*)|([NS])However, my matched parts comes through with just the degrees value and are missing the minutes & seconds values. I will admit that I don't know enough regex!Here's the details... I have latitude and longitude values stored in separate columns in DMS format (e.g., 27° 54' 32.32124" N or 38° 24' 16" N), and I need to convert them to

I have a point (base) and a list of lines (candidates). a nearest line is found using NeighborFinder. it seems that the result from "matched" port does not have geometry of matched lines (the candidates). Any suggestions?