Transformers

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-b527-4ad8508f3ea5","type":"MissingMethodException","requestIndex":0},"name":"JSONRPCError","errors":[{"message":"The method \\\\u0022Get\\\\u0022 could not be found. Verify the method name and ensure all method parameters are included.","name":"MissingMethodException"}]},"jsonrpc":"2.0","requestIndex":0} If I had rules in place for these

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 Polygon Output 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 directory with a simple script at the end of a workbench thank 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, Country The 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, Country Is there any way I can partially define the schema whilst leaving the rest dynamic? Thank you Oliver

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 decimal degrees. The seconds values may have a precision of anywhere from 2-7 with a scale of 0-5. I know I could probably handle this in a more cumbersome way with testers/testfilters and substring

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?

I have the following data; a road network for a city, a number for routes through the city and a point file for each junction where a manoeuvre is required. What I want to identify are the start and end road segments for each manoeuvre along the routes and in the direction the route is. For example, if the route makes a "right turn" I want to identify the road element before the turn and the road element after the turn is made. This order should be in the digitisation direction of the route. I then want to use the information to tag the road elements as "from" and "to" and grouped by the junction ID. At the moment I have been able to select the road elements that make up the manoeuvre but I am struggling to sort them into the correct order of sequence (i.e. in the direction of the route). Any ideas on how I can achieve my desired results?

Hello, i use and like the new ExcelStyler Transformer. Is it possible to define the cell size/wide? When I generate a table all cells have the same size an it looks like this, cause the text seems to be cut: I dont want that the text fit in the cell but that the cell grows with the text. Please can you give me a tip how this problem can be solved? Thanks, David

Hi All, Workbench, Inspector etc. do not open after I entered the R path in the path location option. It did work neatly (the path and all are valid, though not using the default plug-in path), until I shut down the application. When trying to (re)start it gets as far as the splash screen for loading GUI. Then it just pops away. Event Viewer says: Faulting application name: fmeworkbench.exe, version: 2018.7.34.18301, time stamp: 0x5ad2626a Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000 Exception code: 0xc0000005 Fault offset: 0x0000000000000000 Faulting process id: 0xce0 Faulting application path: D:\\PROG\\FME\\fmeworkbench.exe Faulting module path: unknown Faulting package full name: Faulting package-relative application ID: Does anyone know how to solve this? Can I somehow reset the location (mind you I can't open the workbench, using certain user profiles) Can I access the settings file to do so?

I know a way in arcmap using toolbox Conversion Tool under that i am using "feature class to geodatabase" to remove those values by unchecking the m and z values. But, for larger data set, arc map is crashing. Is their any transformer in FME, where we can remove those values in shape files?

Hi, hopefully a quick one but it isn't clear to me. I have mapped an S3 bucked to a resources folder in FME Cloud - https://xxxxxx.fmecloud.com/fmeserver/#/resources/browse/rasters How do I reference to this folder in a workspace, I cannot use FME_SHAREDRESOURCE_TEMP or FME_SHAREDRESOURCE_DATA What FME Server Parameter should I use? Many Thanks Oliver

Test to see if "viewable by original poster" means viewable by poster of the parent question, or poster of of the answer/comment we are replying to.