Installing the Alpha Release of Archaeology Note Book

Talking Points

  1. ShootingPointsWithTotalStationTips

Features (Demo)

Menus:

  1. File: currently only has exit, but in the future we plane to include data backup functionality in addition to the synchronization abilities the application already has.

  2. Squares: Allows you to:

    1. Create new squares,
    2. Add a log page to the current square
    3. Add a locus to the current square. DON'T ADD ANY YET...

Tabs: We also have tabs that relate to the Site, Field and the Squares.

  1. Site Information is pretty sparse! Undoubtedly we'll add more as we have need. We do not save multiple sites in a database. So this is not saved in the Database (and for most of use, we don't really concern ourselves with it.)
  2. Field information: D (according to Madaba plains this is a single letter designation). We don't have multiple fields this summer so we won't be changing this either.
  3. Square Information! This is your place to be! You will now notice a bunch of new tabs:
    1. Square Tabs are on the right,
    2. Elements of the square that you might edit:
      1. Earth Loci
      2. Architectureal Loci
      3. Installation Loci
      4. Daily Logs
    3. Notice the current square (S31), Under Earth has a Locus Tab list on the left that includes a Locus named 1000 (also must be an integer).
    4. Lets Create one of each! (talk about the need of being precise)

Software installs

You can install the software in two scenarios. First as a single install for your own personal use. Second you can install this for use with a server.

Single System Install

If you would like to install this for testing, please contact Dr. Anderson at scot@southern.edu to obtain binarys.

  1. You must install Sql Server 2008. This is available on the CD we distributed at the training.

  2. Run the InstallSQL.bat first This will silently install SQL Server in the right location.

  3. Run the setup.exe. This will install the Archaeology Note Book application.

  4. After the setup completes you will have a Sql Scripts directory on your desktop. These must be run in SQL Management Studio in the following order:

    1. 00_CLR_INTEGRATION_ON.sql

    2. 00_ConAggregate.sql

    3. 00_CREATE_ALL_v3.sql

In future versions we will make this into one install process. You do not need 00_DESTROY_ALL.sql, but it is included in case you need or desire to wipe out the tables and views and start with a fresh database.

Once that is completed, you can start the application from your start menu.

Server Install

This scenario uses a server that clients can synchronize the photos and database records to.

Server setup

We used a virtual machine just in case we needed to move the server to another physical machine plus it makes an easy backup point.

  1. Install windows server on a virtual machine:
    1. Install windows server
    2. Install Virtual Box guest additions or VMware tools if you are using a virtual machine.
    3. Install a windows domain (let the install put in the DNS server as well).

    4. Create two shares on the server, one for photos and one for drawings. Note the two share paths for later.

  2. Install SQL Server on the windows server. Make sure to install all components having to do with replication as later we will setup the clients to subscribe to this database.
  3. Install the database:
    1. First you need to create the database using the scripts