SWAD: Scottish Wetlands Archaeological Database

ArcView Download Help Pages

The downloading of data from SWAD and SPA Database into ArcView was tested on ESRI® ArcView GIS 3.2. If you have any problems please contact Anthony Newton, your computing support or ESRI. For instructions on using ArcMap click here. These instructions assume a basic knowledge about ArcView. Note that if you have a choice we recommend that you use ArcMap, as it is far simpler to import text files and use the hyperlink tool than in ArcView.

Instructions on importing sites into ArcView GIS

Downloading data from SWAD and SPA Database:
  1. First search either the SWAD or SPA Database. This should produce a list of sites, at the base of which will be an option to download a file that can be imported into either ArcMap or ArcView.
  2. Choose the ArcView option and click on the download file button. After a short pause a dialogue box will appear asking whether you wish save a file called arcviewfile.txt to disk. Click on the OK button and save the file to an appropriate folder. You can rename the file to whatever you want, but keep the .txt suffix. (Note that file you have downloaded contains a list of files with XY coordinates as Ordnance Survey northings and eastings.
Importing arcviewfile.txt into ArcView:
  1. Open a new or existing Project in ArcView.
  2. If a new Project, load a map of Scotland or the part of Scotland you are interested in (for help on this see ArcView help files or manual).
  3. The map of Scotland should now be displayed in the View1 window.
  4. Highlight Tables in the Table of Contents window and click on Add button. An Add Table dialogue box will appear. Change the List of Files of Type to Delimited Text (*.txt) and select the appropriate file to load. Click OK.
  5. A new window will appear displaying the contents of the file. Close this.
  6. Click on the View1 window containing the map fo Scotland.
  7. Click on View on the menu at the top of the page and select Add Event Theme.
  8. Choose the file you have just downloaded and select the X field to be Eastings and the Y field to be Northings. Click OK.
  9. A new Theme (the file you have imported) will appear in the legend in the View window. Click on the new theme so that a tick appears. The sites in the downloaded file will appear on the map.
Loading a script into ArcView so that Hot Links can be used:
  1. In order to use the Hot Link feature in ArcView a script needs to be loaded. This tells ArcView to launch your default web browser when you click on a point. This script needs to be loaded into each new ArcView project.
  2. Click on Scripts in the Table of Contents window and then click on New.
  3. A new window called Script1 will appear.
  4. Copy the following text (from theVal to the second end) and paste it into the Script1 window. You will need to replace the red and bold text with the location of your web browser. In the example below, Internet Explorer is launched, but this could be Mozilla, Opera or whatever.
    theVal = SELF
      ' see if the value of the field is not null
      'trim "/" off the end of hyperlinks
      number i = theVal.Count
      theValTrim = theVal.Left(i-1)
    if (not (theVal.IsNull)) then
      ' if the file listed in the field exists, then run browser
      if (File.Exists(theVal.AsFileName)) then
        ' use the path to the video player executable
        System.Execute("C:\Program Files\Internet Explorer\iexplore.exe" ++theValTrim)
        ' if the file doesn’t exist, tell the user
        MsgBox.Warning("File "+theVal+" not found.","Hot Link")
  5. Once you have completed the script, click on Script in the menu at the top of the page and click on Compile.
  6. Close the script window.
  7. You can rename the script if you like by highlighting the script in the Table of Contents window and pressing "Control + R" or going to Properties on the top me.
Link the theme (imported file) to the script:
  1. Click on the theme (the file you imported) in the legend in View1.
  2. Click on Theme menu at the top of the page and select properties. A new wndow will appear.
  3. For Field select Url, for Preferred Action choose Link to User Script and for Script click on the button to the right of the text box. Choose script1 or whatever the script is called and click OK. Click OK again to close the window.
Select a point a query SWAD or SPA Database:
  1. Click on the Hot Link button Hot Link button on the tool bar at the top of the page.
  2. Your cursor will change to a jagged line.
  3. Click with the lefthand mouse button on the site on the map you want more information. Your browser should be automatically launched and the results of your search displayed.


This project is funded by Historic Scotland
Institute of Geography, The University of Edinburgh AOC Archaeology Group Historic Scotland