|The Export to ASCII functionality allows the Maptek Vulcan user to export points from objects. The user can even export in CSV format.|
A question came up today about the File > Export > ASCII > Design Strings option in Maptek Vulcan. This is a useful option that you don’t know you want until you need it. The problem is that when you actually do need it, you’ve never heard about it. Hopefully, this post will help some people to know how to export to a CSV file from Vulcan before crisis strikes.
The scenario that I encountered today was simple: points had been imported into Vulcan from a CSV file (well collar locations), converted from mine coordinates to UTM and now the point coordinates needed to be added back to the original CSV file as the converted UTM coordinates. If there had been just a few points it would have been no big deal to simply type in the coordinate data to the CSV file in Microsoft Excel. For a larger number of points we want a function that will export data in a manner similar to how we imported the data.
The first bit of confusion when exporting points to CSV format is that everyone wants to use the 'CSV (Database)' File Format. This seems like the logical choice. We are attempting to export data from the design database to CSV format. Why isn’t this the best solution? In Vulcan nomenclature, the import and export CSV options refer to Isis databases i.e. drillhole/composite databases. If you want to export CAD data, use the ASCII export option.
Select File > Export from the Vulcan menu. In the Export panel select ASCII as the file format and Design Strings as the File Type.
|Use the 'ASCII' File Format to export CAD points from Vulcan objects.|
In the ‘Export to ASCII’ panel (the first of two panels with the same name) select the CSV radio button and type in a name for the new CSV file that we will be creating. Click ‘OK.’
|The first 'Export to ASCII' panel allows the user to specify a CSV file type and the name of the resulting file.|
The ‘Export to ASCII’ panel (why Vulcan has two panels with the exact same name is beyond me) has four sections to fill out:
- Description: This section is purely informational, it lists the file name and extension for the export results.
- File format: Specify the separating character. Typically a comma, although sometimes we use a ‘tab’ character if importing into an .xls or .xlsx file type. Use the characters '\T' to specify tab. Check the box ‘Write a file header.’ This will add a header line in the export file. If this box is not checked, the resulting CSV file will not have any information on which column is which.
- Object header: Vulcan has the capability to add a line of header for the points in each object being exported. It has been my experience that if I am exporting more than one object at a time, Export > ASCII is not the way to do it. The CSV file for multiple objects gets really confusing really quickly. Don’t do it.
- Object points: This is the meat of the panel. Select the fields you want to populate in the CSV export. X, Y and Z fields are specified by default. I like to use Point Name instead of Point Number so that the points are more easily identifiable.
|The second 'Export to ASCII' panel specifies which fields will be populated in the resulting export file.|
Click ‘OK’ and select the data to export. Click ‘OK’ when Envisage tells you how many points have been exported and again when it tells you that the file has been successfully created. Click ‘Cancel’ to exit the Export panel and take a look at the file you have created.
In this format you can easily copy and paste the translated well coordinates to the original CSV file.