Transformers

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 \\\\

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 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/t

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: 0x5ad2626aFaulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000Exception code: 0xc0000005Fault offset: 0x0000000000000000Faulting process id: 0xce0Faulting application path: D:\\PROG\\FME\\fmeworkbench.exeFaulting module path: unknownFaulting 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/rastersHow 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 ThanksOliver

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.

I'm looking to extract text from a specific area of a PDF. The box contains IDs and I would like those written to a simple Excel file. My source data is a PDF with roughly 100 pages, and the area I want scanned is in the same location on each page. I believe the best tool to use for this would be the new Adobe Geospatial PDF reader but I am unsure how to proceed from there.

I have a workflow where I am trying to write out a MapInfo file dynamically. When using a normal Writer the file writes out correctly as per the schema I have told the writer to reference. The attributes are written out in the order as prescribed in the schema. Within the Writer, in the "User Attributes" tab the Dynamic option is selected and there are no attributes listed here (as they are supplied from the schema of the Workspace Resource I have added). This works and makes sense:However, I would like to use a FeatureWriter instead of the standard Writer as I need the translation to continue on, as I use the Emailer to confirm that the workspace has completed successfully. In the FeatureWriter I have the same options as I would use in the Writer selected, and the FeatureWriter is referencing the same Schema Source::In the "User Attributes" tab the Dynamic option is selected but the Attributes still appear and the attributes write out in the order they go into