Differences between revisions 15 and 16
⇤ ← Revision 15 as of 2010-05-27 00:16:40 →
Size: 5104
Editor: 71-87-243-6
Comment:
← Revision 16 as of 2010-06-07 23:30:31 → ⇥
Size: 3668
Editor: scot-camtasia
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
== 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.
 1. '''Squares''': Allows you to:
  a. Create new squares,
  a. Add a log page to the current square
  a. 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.)
 1. 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.
 1. Square Information! This is your place to be! You will now notice a bunch of new tabs:
  a. Square Tabs are on the right,
  a. Elements of the square that you might edit:
   1. Earth Loci
   1. Architectureal Loci
   1. Installation Loci
   1. Daily Logs
  a. 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).
  a. Lets Create one of each! (talk about the need of being precise)

== Software installs ==
Line 33: Line 5:
=== Single System Install === == Single System Install ==
Line 49: Line 21:
=== Server Install === == Server Install ==

Installing the Alpha Release of Archaeology Note Book

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 by running the scripts:

    1. 00_CLR_INTEGRATION_ON.sql (Turns on CLR integration so that you can install SQL extensions)

    2. 00_ConAggregate.sql (This installs ConcatAggr.dll as an extension to SQL Server)

    3. 00_CREATE_ALL_v3.sql (This creates the tables, views etc.)

  4. On the server follow the directions here

Client setup

It is imperative to install an operating system that can connect to a windows domain (no starter editions). We are using Windows 7 Enterprise on netbooks.

  1. Join the computer to the domain.

  2. Add the group SquareSupervisors (or whatever group you put the users in) as administrators of the local computer. This isn't strictly necessary, but it makes the install process a bit easier.

  3. Do all installs as the user from here on out. Make sure that the user you will use is in the SquareSupervisors group.

  4. Make sure that \\[server]\Photos and \\[server]\Drawings are available off line.
  5. Install SQL Server Express
    1. Install Database Engine Services, SQL Server Replication, Management tools, SQL Client Connectivity SDK, MS Sync Framework
    2. Install in mixed mode so that you can use the SA account.
    3. Install the service packs (if necessary).

    4. Add the group SquareSupervisors (or whatever group you put the users in) as administrators of the SQL server.

    5. Make sure the SQL Browser service is running.

  6. Follow the client install directions here.

  7. Run setup.exe and test the application

ArchaeologyProject/InstallingAlpha (last edited 2010-06-07 23:30:31 by scot-camtasia)