==================================================
-- Elizabeth Gallas	May 7-9, 2004

This file: D0_sb_dbcode/doc/notes_050507.txt
This file contains my notes on May 2005
to update the database for the latest masthead.

This is not a script !
Do not do what I did here from start to finish !
Look at the end to see how and where to run reader.py 
successfully for this case.

Had some hickups this time:
- One institution University of Nijmegen
  changed their name to Radboud University Nijmegen
  I will continue to use the same acronym NIJMEGEN

  In order to figure this out, I had to re-import the
  data to int a number of times with emails to spokes 
  and others to clarify.

- the http://d0db-dev.fnal.gov:8514/sb_data-int/ code
  said it was looking at int, but it was really looking
  at dev based on ORACLE_SID.
  Change the logic in getsid.

  I did not commit any code changes to cvs and still
  have multiple versions of the code in various places.
  There are also multiple versions of reader.py in cvs,
  so beware of that !  See notes what I did where below.

In addition, there is one new institution.
University of Science and Technology of China, 
Hefei, People's Republic of China
HEFEI

--------------------------------------------------------------
-- Export the data from dev.
-- The export file serves as a backup.

-- on d0ora1 in my account:
cd movedata/sbdb/
xemacs sbdb_exp_and_imp.sh &

setup oracle
setenv TWO_TASK d0ofdev1
setenv ORACLE_SID d0ofdev1
echo $ORACLE_SID
echo $TWO_TASK
exp speakerdb file=sbdb_expdev.dmp log=sbdb_expdev.log

-- Import the dev data integration
-- The integration instance is used for testing reader.py
--     before it is run on the d0ofdev1 instance.

setenv TWO_TASK d0ofint1
setenv ORACLE_SID d0ofint1
echo $ORACLE_SID
echo $TWO_TASK

sqlplus speakerdb@d0ofint1
@dropsbdb_for_import.sql
exit

imp speakerdb file=sbdb_expdev.dmp fromuser=speakerdb touser=speakerdb log=sbdb_impint.log ignore=y
--------------------------------------------------------------
-- where is the current official D0_sb_dbcode cgi running from ?
cd /fnal/ups/prd/webapache/d0db-dev/
dir cgi-bin/*sb*
lrwxrwxrwx 1 products Aug 18 2003 cgi-bin/D0_sb_dbcode -> /fnal/ups/prd/D0_sb_dbcode/devel/cgi/

d0ora1/fnal/ups/prd/D0_sb_dbcode/devel/cgi% dir
total 202
drwxrwxr-x   2 gallas   products     512 Jul 10  2001 CVS/
-rw-rw-rw-   1 gallas   products     538 Mar 23  2000 HEADER.html
-rw-rw-rw-   1 gallas   products     538 Mar 23  2000 README.html
-rwxrwxrwx   1 gallas   products    1877 Sep 13  2001 spdb_entry.py*
-rw-rw-rw-   1 gallas   e740       58330 Dec 10  2002 spdb_entry_def.py
-rw-rw-r--   1 gallas   e740        3019 Mar 14  2003 spdb_incommon.py
-rwxrwxrwx   1 gallas   products    1371 Sep 13  2001 spdb_index.py*
-rwxrwxrwx   1 gallas   e740       23094 Dec 10  2002 spdb_index_def.py*
-rwxrwxrwx   1 gallas   products     910 Sep 13  2001 spdb_report.py*
-rwxrwxrwx   1 gallas   e740        9259 May  6  2004 spdb_report_def.py*

-- copy this code to my cgi-int area so I can look at d0ofint1 data:
> cp spdb_*.py ~/sb_data1/cgi-int/

-- now run it on the web:
http://d0db-dev.fnal.gov:8514/sb_data-int/

-- I had to modify this code.  See notes below.

--------------------------------------------------------------
-- extract the masthead file from the web:
http://www-d0.fnal.gov/~madaras/authorlist/run2/master_list_r2.txt

-- save as a file called masthead.txt 

--bad!-- 
--bad!-- cd d0ora1~/cvsarea/D0_sb_dbcode/src
--bad!-- reader.py
--bad! This version was old !
--bad!% dir reader.py ~/cvsarea/D0_sb_dbcode/src/reader.py
--bad!-rwxr-xr-x   1 gallas  11452 Oct 18  2002 /home/gallas/cvsarea/D0_sb_dbcode/src/reader.py*
--bad!-rwxr-xr-x   1 gallas  18446 Oct 21  2004 reader.py*

-- Good thing I only ran in d0ofint1 and looked at the 
-- results using http://d0db-dev.fnal.gov:8514/sb_data-int/
-- (the new institutions were not there and the expected
-- log file did not appear.

-- this area contains all the latest code in cvs:
cd ~/cvsarea/D0_sb_database/NULL/v0_2
cvs -n update
-- this shows that this area is up to date with cvs

-- I have no idea why the program is in the data directory
cd data

-- put the lastest masthead file from the web here
-- call it masthead.txt

-- run the masthead reader program on d0ofint1
setup python_dcoracle
reader.py

DATABASE = d0ofint1
USERNAME = gallas
password entered
Database connection established to d0ofint1

new institution 
Radboud University Nijmegen/NIKHEF, Nijmegen, The Netherlands
Nijmegen
University of Science and Technology of China, Hefei, People's Republic of China
HEFEI

-- a log file reader_slog_2005-05-08.log is created
-- where I can see the insert statements for the new inst

INSERT INTO mastinst (ainst,ninst,status)  VALUES (','Radboud University Nijmegen/NIKHEF, Nijmeg
en, The Netherlands','a')
UPDATE mastinst SET status = 'r' WHERE ninst ='University of Nijmegen/NIKHEF, Nijmegen, The Netherlands'
INSERT INTO mastinst (ainst,ninst,status)  VALUES ('HEFEI','University of Science and Technology of Chin
a, Hefei, People''s Republic of China','a')

-- look on the web for the new institutions:
-- http://d0db-dev.fnal.gov:8514/sb_data-int/

-- If everything looks okay, do the same reader.py on d0ofdev1

reader.py

DATABASE = d0ofdev1
USERNAME = gallas
password entered
Database connection established to d0ofint1

Writing session log file to filename = reader_slog_2005-05-09.log

-- check the log file into cvs:
cvs -n update
cvs add reader_slog_2005-05-09.log
cvs commit -m "update the database for the latest masthead -- here is the log file"

-- now check in this file
-- why is it in the database package 
-- rather than D0_sb_dbcode ?  I don't know


d0ora1~/movedata/sbdb% sqlplus gallas@d0ofint1

 select SYNONYM_NAME,TABLE_OWNER,TABLE_NAME from  all_synonyms where synonym_name like '%MAST%'

 desc mastinst 

 select ainst from mastinst order by CREATE_DATE;


AINST
---------------
SMU
MISSISSIPPI
RADBOUD
HEFEI

92 rows selected.

-- The new ones are there, but the web interface is not finding them !
-- To fix this,
--     I modify the code in ~/sb_data1/cgi-int/ to point to the integration
--     (it was defaulting to the d0ofdev1 instance).
-- If the global DATABASE is not '', then set the instance to it,
--     otherwise use the ORACLE_SID.

-- I should check this code change (above) into cvs, but the multiple
-- versions are confusing me.
-- Also, I should change the cvs packages removing the old version of reader.py.

-- I found out (by writing email to spokes) that RADBOUD is not new, 
--     it is just a renamed institution.
-- Only now does this make sense.
-- I don't know why the older institution name Nijmegen was not set to
--     r = retired by reader.py, but now it does not matter.

-- Import the data into d0ofint1 again,
-- run the reader.py program again on d0ofint1,
-- now the institutions look right on d0ofint1.

-- Run reader.py on d0ofdev1.

-- Send email to Mike Strauss and others.

-- I need to write a description of the SB database application for
    outsiders (Atlas and CMS, who are currently asking about it).

-- I also need to write a description of the SB database application
    internal to D0 developers.-- Elizabeth Gallas	Oct 21,2004

This file contains my notes on Oct 2004 trying to
figure out why I have so many versions of SB code
and front pages and notes on how to run the programs
for updating the database for the latest masthead.

The location of this file is in
D0_sb_dbcode/doc/notes_041021.txt
This note covers both packages D0_sb_dbcode and D0_sb_database

--------------------------------------------------------------
The Speakers Bureau Database (D0_sb_database):

~/cvsarea/D0_sb_database/NULL/v0_2/ on Oct 21, 2004 was consistent
with d0cvs on that date except that 
data/reader.py and the associated log file 
data/reader_slog_2003-11-23.log needed to be updated, 
probably from the last time I modified and ran reader.py on d0mino
(I run the masthead reader on d0mino because it has access to
the masthead file placed locally in a file called masthead.txt).

Running the Masthead reader.py program-----------------------------

This time I did all this on d0ora1

cd ~/cvsarea/D0_sb_database/NULL/v0_2/data/
I went to the web and extracted a file dated 9/28/04
http://www-d0.fnal.gov/~madaras/authorlist/run2/master_list_r2.txt
into the file called masthead.txt.

using the procedure on d0ora1 in ~/movedata/sbdb/sbdb_exp_and_imp.sh
- export speakerdb data from d0ofdev1 
  (files named  sbdb_expdev_2004_Oct_21.dmp and  sbdb_expdev.dmp)
- delete the tables from d0ofint1
- import the tables into d0ofint1

Print all institutions from the SB database using the web interface at
http://d0db-dev.fnal.gov/D0_sb_dbcode/
for reference so I can look at changes.

Run the reader.py program on d0ofint1 (test it there first).
Changes to the INSTIT contents of existing ainst: 
STRASBOURG
CANADA
New INSTITutions are:
SMU - Southern Methodist U, Dallas, USA and
MISSISSIPPI - U of Mississippi, USA
The program generated a log file called reader_slog_2004-10-21.log

Now run the same program on the develpment instance.
Check the file reader_slog_2004-10-21.log
into cvs under the data/ directory.

Clean up the production instance -------------------------------------

We are not in production yet, so I don't want anyone looking at the
old data that I put there while testing in 2003 or use the code that
Lauri put there in May 2004.

- delete the tables from d0ofprd1 until I am ready to go to production
following the file in ~/movedata/sbdb/sbdb_exp_and_imp.sh
(from the develpment machine d0ora1).
The table, triggers, constraints, sequences are now gone 
except for the synonyms, which I can't delete as of Oct 21,2004.

- log onto the production machine (d0ora2) and delete the crap that
Lauri put there (it should never be run).
cd /fnal/ups/prd/D0_sb_dbcode/
newgrp products
mkdir invalid_lcc_040513
mv v_cvs_head/ invalid_lcc_040513/v_cvs_head/
I should just delete it all.  It is a version that should not be 
executed.  Deleted the whole directory structure Oct 27, 2004.


Update the web interface front pages on d0mino/d0world -------------------

Nick Hadley has given me k5 access to the d0conf account.
kinit -f
ssh d0conf@d0mino
-- ksh d0conf
cd public_html/d0_private/

INDEX.HTML files:====================
-- replace the index.html file with the file from 
-- http://d0db-dev.fnal.gov/D0_sb_dbcode/index.html

-- move the old files (does not include section to query for list of
   talks by an individual, but includes groups and subgroups) to 
     index_old_wgroups.html and
     index_old_wgroups_whod0-gallas.html

SPDB_ENTRY.HTML files:===============
-- delete duplicate entry front pages
   rm spdb_entry-dev.html (identical to spdb_entry.html)
   Leave spdb_entry-gallas.html pointing to my develpment area.

SPDB_REPORT.HTML files:==============
This used to be the special front page for SB members, but the
same queries are now available from the index.html file, so 
I probably can delete them all.
-- rm spdb_report.html.ORIG -- this file was pointing to production
-- rm spdb_report-dev.html  -- this file was identical to spdb_report.html
-- rm spdb_report-roco.html -- was pointing to Maria Roco's area (8518)
-- rm spdb_report-gallas.html -- this was pointing to EG's area
-- rm spdb_report.html -- all functions here are done in index.html
so delete them all.

-- Remove them from cvs.
cvs rm spdb_report-dev.html
cvs rm spdb_report-gallas.html
cvs rm spdb_report-roco.html
cvs rm spdb_report.html

-- Remove them from all cuts of D0_sb_dbcode on d0ofdev1 (there they
-- are identical to the index.html file there):
dir */*/*report*.html
-rw-rw-rw-   1 gallas   products    5624 Oct 21 21:07 devel/www/spdb_report.html
-rw-rw-rw-   1 gallas   products    5385 Sep 13  2001 v0_0/www/spdb_report.html
-rw-rw-r--   1 gallas   e740        5385 Mar 14  2003 v0_0_021114/www/spdb_report.html
rm */*/*report*.html

-- To enter the SB entry interface, the user must get through 
-- a D0 private area.
cd /fnal/ups/prd/D0_sb_dbcode/devel/www/
xemacs spdb_entry.html
to simply have a link to 
http://www-d0.fnal.gov/~d0conf/d0_private/spdb_entry.html

WHOD02.html:=========================
Keep this front page.  Clicking on submit connects to the cgi and
then to the generated front page.  some features work, though the 
whod0 data in the SB Oracle tables are not up to date.

Update the web interface code on dev  -------------------------------------

-- figure out which version is 'current':
cd /fnal/ups/prd/webapache/d0db-dev/html
dir D0_sb_dbcode
lrwxrwxrwx 1 products products 36 Sep 8 2003 D0_sb_dbcode -> /fnal/ups/prd/D0_sb_dbcode/devel/www/

xemacs the front pages: index.html and spdb_report.html
file to check the 'list speakers' box and extend the
end date to 2014
and make sure the files are owned by the products group:
chown -R gallas:products /fnal/ups/prd/D0_sb_dbcode/devel/www/

??? to do:
- look at the v0_0 and v0_0_021114 subdirectories
  and try to figure out why they are there.

- compare the devel current version to cvs and to my 
  development areas

- check the changes into cvs.

The PYTHON code -------------------------------------------------------------------
cd /fnal/ups/prd/D0_sb_dbcode/devel/cgi/

-- replace hardcoded database value with ORACLE_SID (revert to previous code)
spdb_entry_def.py and
spdb_index_def.py.

-- Remove the *report*.py modules
????

==================================================
-- Elizabeth Gallas	July 5, 2005

The location of this file is in D0_sb_dbcode/doc/notes_050705.txt

Nick Hadley requests a query returning
speakers who have not given a talk in 18 months.
I have not decided if I will just send them an SQL
query or if I will put it on the front page.

There are many versions of the cgi:
d0ora1/fnal/ups/prd/D0_sb_dbcode/devel/ - CURRENT
        this version is current,
	spdb_report_def.py - hardcoded ORACLE_SID to d0ofdev1
	spdb_entry.py - latest version -- sends user to d0_private
		      page to enter username
        spdb_incommon.py - latest method for talks and proceedings
			 - contains function parse_string_to_list

d0ora1/fnal/ups/prd/D0_sb_dbcode/v0_0/ - OLD
	spdb_report_def.py - uses environment variable for ORACLE_SID
	index.html - old -- does not have conflink checked as default
	spdb_entry.py - old -- asks user for user name

d0ora1/fnal/ups/prd/D0_sb_dbcode/v0_0_021114/ - EVEN OLDER
	spdb_incommon.py - old method for talks and proceedings
	spdb_report_def.py - uses environment variable for ORACLE_SID
	index.html - old -- does not have conflink checked as default
	spdb_entry.py - old -- asks user for user name

~gallas/sb_data/ - dated Mar 15, 2000 - REALLY OLD
-----------------------------------------------------------------------------------

==================================================
-- Elizabeth Gallas	March 6, 2006
-- 
-- The location of this file is in D0_sb_dbcode/doc/notes_060306.txt
-- 
-- I need to update the SB database for the latest masthead. Here are the steps.
-----------------------------------------------------------------------------------
-- on d0ora1 (unless noted otherwise):

-- Export the development instance
cd movedata/sbdb/
setup oracle
setenv TWO_TASK d0ofdev1
setenv ORACLE_SID d0ofdev1
echo $ORACLE_SID
echo $TWO_TASK

-- I always make one dated file 
exp speakerdb file=sbdb_expdev_`date | tr -s ' ' ' ' | cut -d' ' -f6`_`date | tr -s ' ' ' ' | cut -d' ' -f2,3 | tr ' ' '_'`.dmp log=sbdb_expdev_`date | tr -s ' ' ' ' | cut -d' ' -f6`_`date | tr -s ' ' ' ' | cut -d' ' -f2,3 | tr ' ' '_'`.log
exp speakerdb file=sbdb_expdev.dmp log=sbdb_expdev.log

-- Import to integration instance (drop the tables, then import)

setenv TWO_TASK d0ofint1
setenv ORACLE_SID d0ofint1
echo $ORACLE_SID
echo $TWO_TASK

sqlplus speakerdb@d0ofint1 @dropsbdb_for_import.sql
exit

imp speakerdb file=sbdb_expdev.dmp fromuser=speakerdb touser=speakerdb log=sbdb_impprd.log ignore=y

----------------------------------------------------------
-- Run the masthead reading program against the integration instance

-- go to where I run the program
cd d0ora1~/cvsarea/D0_sb_database/data/

-- make the masthead source file (check the last file into cvs)
xemacs masthead.txt &
-- put the contents of the lastest masthead into this file from
http://www-d0.fnal.gov/author/authorlist/run2/master_list_r2.txt

setup python_dcoracle
reader.py

d0ofint1
gallas
pw

There are now 3 Oklahoma institutions:
Langston University, Langston, Oklahoma         (existing LANGSTONU)
University of Oklahoma, Norman, Oklahoma        (existing UOKLAHOMA)
Oklahoma State University, Stillwater, Oklahoma (new OSU)

Physik Institut der Universit{\"a}t Z{\"u}rich, Z{\"u}rich,
Switzerland (new ZURICH)
State University of New York, Buffalo, New York (new SUNYbuffalo)

SungKyunKwan University, Suwon, Korea (SungKyunKwan)

INSERT INTO mastinst (ainst,ninst,status)  VALUES ('OSU','Oklahoma State University, Stillwater, Oklahoma 74078, USA','a')
INSERT INTO mastinst (ainst,ninst,status)  VALUES ('ZURICH','Physik Institut der Universit{\"a}t Z{\"u}rich, Z{\"u}rich, Switzerland','a')
INSERT INTO mastinst (ainst,ninst,status)  VALUES ('SUNYBUFFALO','State University of New York, Buffalo, New York 14260, USA','a')
INSERT INTO mastinst (ainst,ninst,status)  VALUES ('SUNGKYUNKWAN','SungKyunKwan University, Suwon, Korea','a')

-- now look at the web interfaces to see the new data:
http://d0db-dev.fnal.gov:8514/sb_data-int/

----------------------------------------------------------
-- Run the masthead reading program against the development instance
-- following the same procedure as above except for d0ofdev1.

-- add the log file to cvs
cvs add reader_slog_2006-03-06.log 
cvs commit -m "4 new institutions have been added to the database with the latest masthead."

-- Tomorrow, this log file will be viewable:
http://www-d0.fnal.gov/d0dist/dist/packages/D0_sb_database/devel/data/reader_slog_2006-03-06.log

-- Look on the web to make sure the new insts are there
http://d0db-dev.fnal.gov/D0_sb_dbcode/

-- Send an email to the Speakers Bureau
----------------------------------------------------------
----------------------------------------------------------


-----------------------------------------------------------------------------------

==================================================
-- Elizabeth Gallas	May 24,25, 2006
-- 
-- The location of this file is in D0_sb_dbcode/doc/notes_060524.txt
-- 
-- I need to update the SB database for the latest masthead
-- while I am certifying Oracle 10g.
-- I also need to get this operation running off d0ora1.
-- Here are the steps.
-----------------------------------------------------------------------------------
-- on clued0, and d0mino03 the latest version of Oracle is v8_1_7,
-- so I have to do the export/import on d0ora1:

setup oracle v9_2_0
echo $ORACLE_HOME

-- export from development:

setenv TWO_TASK d0ofdev1
setenv ORACLE_SID d0ofdev1
echo $ORACLE_SID
echo $TWO_TASK

exp speakerdb \
file=sbdb_expdev_`date | tr -s ' ' ' ' | cut -d' ' -f6`_`date | tr -s ' ' ' ' | cut -d' ' -f2,3 | tr ' ' '_'`.dmp \
log=sbdb_expdev_`date | tr -s ' ' ' ' | cut -d' ' -f6`_`date | tr -s ' ' ' ' | cut -d' ' -f2,3 | tr ' ' '_'`.log

exp speakerdb   file=sbdb_expdev.dmp log=sbdb_expdev.log

-- import to integration

setenv TWO_TASK d0ofint1
setenv ORACLE_SID d0ofint1
echo $ORACLE_SID
echo $TWO_TASK
imp speakerdb file=sbdb_expdev.dmp fromuser=speakerdb touser=speakerdb log=sbdb_impint.log ignore=y

-- I have checked the procedure for export/import into
-- cvs under /D0_sb_dbcode/movedata

-------------------------------------------
-- now I am trying to run the rest on eggs-clued0:

-- print out a list of institutions from the integration instance:
http://d0db-dev.fnal.gov:8514/sb_data-int/
(Choose to List Masthead Institutions ALL, Click on submit button)


kinit -f

cd /work/eggs-clued0/gallas/cvsarea/
setup d0cvs
cvs co D0_sb_database

cd D0_sb_database/
cd data
chmod 755 reader.py 

-- put the contents of the lastest masthead into a local file masthead.txt
-- http://www-d0.fnal.gov/author/authorlist/run2/master_list_r2.txt

-- run the program on d0ofint1
./reader.py

Enter the database instance:  d0ofint1
DATABASE = d0ofint1
Enter your D0 database username:  gallas
USERNAME = gallas
Enter your D0 database password:  

17. ADD NEW or CHANGE CURRENT DB INSTITUTION NAME: IPHC, IN2P3-CNRS, Universit\'e Louis Pasteur Strasbourg, and Universit\'e de Haute Alsace, France
Enter a unique institution acronym (<15 chars):  Strasbourg

51. ADD NEW or CHANGE CURRENT DB INSTITUTION NAME: Purdue University Calumet, Hammond, Indiana 46323, USA
Enter a unique institution acronym (<15 chars):  Purdueu_calumet

Here is a list of the database institution insert/updates:
UPDATE mastinst SET ninst='IPHC, IN2P3-CNRS, Universit\''e Louis Pasteur Strasbourg, and Universit\''e de Haute Alsace, France', status='a' WHERE ainst ='STRASBOURG'
UPDATE mastinst SET status = 'r' WHERE ninst ='IReS, IN2P3-CNRS, Universit\''e Louis Pasteur Strasbourg, and Universit\''e de Haute Alsace, France'
INSERT INTO mastinst (ainst,ninst,status)  VALUES ('PURDUEU_CALUMET','Purdue University Calumet, Hammond, Indiana 46323, USA','a')
Do you want to commit these updates (y/n): y

*** Updates committed ***
*** Finished updating institutions.  Now work on People ***
...
many people changed, see the log file
...
Do you want to commit these updates (y/n): y
*** Updates committed ***
Writing session log file to filename = reader_slog_2006-05-25.log

-- Reload the web page to check that updates are seen:
http://d0db-dev.fnal.gov:8514/sb_data-int/cgi/spdb_index.py?ientry=10

------------------------------------------------

-- now run in development:

./reader.py

Strasbourg
Purdueu_calumet
y
y

-- add the log file to cvs
cvs add reader_slog_2006-05-25.log

==================================================
-- 16-Sep-2006
-- Elizabeth Gallas followed the notes in About_reading_masthead.txt
-- Here are the notes of today:
--
-- I could not run the export/import on eggs-clued0 or d0mino,
-- perhaps because the version of oracle there says 8.1.7.0.1 
-- and we are using Oracle 10 in the offline databases.
--
-- I therefore ran the export/import on d0ora1
--
-- When running reader.py,
-- It lists only one update statement to change Beijing status changed
-- to 'r' (which means retired).
-- I remember the only collaborator from Beijing was Mrs Mau 
-- who recently was approved to be put on FNAL authorlist.
--
-- I said 'y' to commit this update.
--
-- It read the people without errors. I 'y' to commit these changes.
-- It made log file reader_slog_2006-09-16.log
-- I look at the UPDATES and INSERT in the log.
-- I see some changes in the log (CHRISTOFEK_L now at Brown, 
-- AGUILO_E now has both 'am' status (authorlist and masthead).
-- Looks okay to me.
--
-- Reload the institutions web page.
-- I see Beijing is now 'r' (retired)
--
-- Looks okay.  Next step is to repeat on d0ofdev1:
--	 http://d0db-dev.fnal.gov/D0_sb_dbcode/
--	 list of institutions shows Beijing is initially 'a' (authorlist)
./reader.py

Enter the database instance:  d0ofdev1
DATABASE = d0ofdev1
Enter your D0 database username:  gallas
USERNAME = gallas
Enter your D0 database password:  
password entered

Database connection established to d0ofdev1

-- I get same results.
-- Commit the changes on d0ofdev1

-- rename the masthead file with the current date:
mv masthead.txt masthead_060916.txt

-- Add the new files to the package, including this file:
cvs add reader_slog_2006-09-16.log 
cvs add reader_notes_060916.txt
cvs add masthead_060916.txt

cvs commit -m "Update the Speakers Bureau Database for the latest masthead file."

==================================================
Alan Jonckheere         July 14-16, 2008

	Changed the documentation (About_reading_masthead.txt) to reflect the
	fact that the primary db is and has been for a while the d0ofprd1 db.

	Changed/fixed the output/input file names.

	A few other minor cleanups.

==================================================
Alan Jonckheere		July 25, 2008
	new update, first of the ones that will be done with each new author
	list.

	Concatenated all of the reader_notes*.txt files into this Change.log
	to make use of cvs. Will be changing all of the files with dates in
	their names to a fixed filename. That will be committed to cvs and then
	rtagged to give the date.

==================================================