Difference between revisions of "AccessConversion"

From GombeMIWiki
Jump to: navigation, search
(New page)
 
(→‎The Process: Search path is not really necessary to run prepare_data().)
 
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
  +
== The Process ==
  +
 
Initially you will want to work in the <code>gombemi_raw</code> database to convert the data with minimal data integrity rules. Later you can work in <code>gombemi_test</code> to convert with data integrity rules in place and finally in <code>gombemi</code> to do the final conversion.
  
Initially you will want to work in the <code>gombemi_raw</code> database to convert the data with minimal data integrity rules. Later you can work in <code>gombemi_test</code> to convert with data integrity rules in place and finally in <code>gombemi</code> to do the final conversion.
   
Line 5: Line 7:
 
* Import all the support (lookup) tables
  
* Import all the support (lookup) tables
 
* Import the <code>BIOGRAPHY_DATA</code> table
  
* Import the <code>BIOGRAPHY_DATA</code> table
  +
* (If necessary) upload the Cross_reference_forprogram.xlxs spreadsheet into the <code>conversion</code> schema.
  +
** Export it from Excel as csv
  +
** Upload into the cross_reference_forprogram table.
  +
* (If necessary) upload the page_followtype.xls spreadsheet into the <code>conversion</code> schema. The page_followtype spreadsheet must have the following column names, all in lower case: date, mom, page, temptype
  +
** Export it from Excel as csv
  +
** Upload into the page_followtype table.
 
* Export the following tables from Access as csv files:
  
* Export the following tables from Access as csv files:
 
** follow
  
** follow
  +
** follow_page
 
** follow_1_minute
  
** follow_1_minute
 
** follow_1_minute_infant
  
** follow_1_minute_infant
Line 12: Line 21:
 
** follow_1_minute_sibling
  
** follow_1_minute_sibling
 
** follow_5_minute
  
** follow_5_minute
−
** follow_5_minute_group
  
  +
** follow_5_minute_left_group
  +
** follow_5_minute_right_group
 
* Delete all rows from the following tables in the <code>conversion</code> schema (if necessary), in the following order:
  
* Delete all rows from the following tables in the <code>conversion</code> schema (if necessary), in the following order:
−
** follow_5_minute_group
  
  +
** follow_5_minute_left_group
  +
** follow_5_minute_right_group
 
** follow_5_minute
  
** follow_5_minute
 
** follow_1_minute_sibling
  
** follow_1_minute_sibling
Line 20: Line 31:
 
** follow_1_minute_infant
  
** follow_1_minute_infant
 
** follow_1_minute
  
** follow_1_minute
−
** follow_1_minute
  
  +
** follow_page
  +
** follow
 
* Import the Access csv files into their corresponding tables in the <code>conversion</code> schema. Import in order of creation as listed above.
  
* Import the Access csv files into their corresponding tables in the <code>conversion</code> schema. Import in order of creation as listed above.
−
* Prepare the Access data for conversion by running <code>prepare_data()</code> as follows: <br/><code>select prepare_data();</code>
 +
* Prepare the Access data for conversion by running <code>prepare_data()</code> as follows:
  +
** Either
  +
*** Be sure that <code>prepared_data</code> shows up as part of your search path.
  +
*** Type (paste/etc.) the following into your SQL window and execute it:<br/><code>select prepare_data();</code>
  +
** Or
  +
*** Type (paste/etc.) the following into your SQL window and execute it:<br/><code>select prepared_data.prepare_data();</code>
 
* Use convert_access() to convert a desired time period, the dates are inclusive. Repeat as necessary with different time periods. If you get an error the database is unchanged. <br/> <code>select convert_access('1990-01-01', '1990-12-31');</code>
  
* Use convert_access() to convert a desired time period, the dates are inclusive. Repeat as necessary with different time periods. If you get an error the database is unchanged. <br/> <code>select convert_access('1990-01-01', '1990-12-31');</code>
−
* Fix errors in the data and repeat.
 +
* Fix errors in the data and repeat until done.
  +
* When finished query the following tables in the <code>prepared_data</code> schema looking in the column named <code>done</code> for rows with a value of <code>FALSE</code>. These rows were not converted. Figure out why and try again:
  +
** follow
  +
** follow_page
  +
** follow_1_minute
  +
** follow_1_minute_infant
  +
** follow_1_minute_mother
  +
** follow_1_minute_sibling
  +
** follow_5_minute
  +
** follow_5_minute_group
  +
<br/><br/>Queries will look like: <code>select * from follow where done = 'false';</code>
  +
  +
== Obtaining Multiple Errors ==
  +
  +
The <code>convert_access()</code> program stops as soon as it finds an error,
  +
in which case the data in the database remains untouched. If there are many errors in the data it can be tedious converting many days with a single invocation of <code>convert_access()</code>, fixing a single error, and repeating. The solution is to run the program many times, and, regardless of error or lack thereof, discard all changes to the database so that the process can be repeated as many times as desired.
  +
  +
The following example code can be cut and paste to find up to an error per day within entire year's worth of data. Cutting and pasting the example, together with a little search and replace, and attention to leap year, can adapt it to any year or to multiple years.
  +
  +
=== The sqlbyline program ===
  +
Use the sqlbyline to execute the SQL. It was written to support the conversion process. Although it's features are limited it serves to report multiple conversion errors when asked to perform multiple conversions. It executes SQL one line at a time. If no file is supplied it will execute the SQL pasted into its textarea.
  +
  +
* [https://gombemi.ccas.gwu.edu/programs/sqlbyline/ sqlbyline] -- Execute lines of sql
  +
  +
=== A year's worth of example conversion sql ===
  +
<pre>
  +
begin;
  +
select prepared_data.convert_access('1996-01-01', '1996-01-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-02', '1996-01-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-03', '1996-01-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-04', '1996-01-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-05', '1996-01-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-06', '1996-01-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-07', '1996-01-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-08', '1996-01-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-09', '1996-01-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-10', '1996-01-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-11', '1996-01-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-12', '1996-01-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-13', '1996-01-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-14', '1996-01-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-15', '1996-01-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-16', '1996-01-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-17', '1996-01-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-18', '1996-01-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-19', '1996-01-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-20', '1996-01-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-21', '1996-01-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-22', '1996-01-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-23', '1996-01-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-24', '1996-01-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-25', '1996-01-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-26', '1996-01-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-27', '1996-01-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-28', '1996-01-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-29', '1996-01-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-30', '1996-01-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-01-31', '1996-01-31');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-01', '1996-02-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-02', '1996-02-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-03', '1996-02-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-04', '1996-02-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-05', '1996-02-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-06', '1996-02-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-07', '1996-02-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-08', '1996-02-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-09', '1996-02-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-10', '1996-02-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-11', '1996-02-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-12', '1996-02-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-13', '1996-02-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-14', '1996-02-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-15', '1996-02-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-16', '1996-02-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-17', '1996-02-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-18', '1996-02-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-19', '1996-02-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-20', '1996-02-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-21', '1996-02-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-22', '1996-02-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-23', '1996-02-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-24', '1996-02-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-25', '1996-02-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-26', '1996-02-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-27', '1996-02-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-28', '1996-02-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-02-29', '1996-02-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-01', '1996-03-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-02', '1996-03-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-03', '1996-03-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-04', '1996-03-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-05', '1996-03-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-06', '1996-03-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-07', '1996-03-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-08', '1996-03-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-09', '1996-03-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-10', '1996-03-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-11', '1996-03-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-12', '1996-03-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-13', '1996-03-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-14', '1996-03-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-15', '1996-03-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-16', '1996-03-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-17', '1996-03-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-18', '1996-03-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-19', '1996-03-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-20', '1996-03-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-21', '1996-03-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-22', '1996-03-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-23', '1996-03-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-24', '1996-03-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-25', '1996-03-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-26', '1996-03-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-27', '1996-03-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-28', '1996-03-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-29', '1996-03-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-30', '1996-03-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-03-31', '1996-03-31');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-01', '1996-04-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-02', '1996-04-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-03', '1996-04-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-04', '1996-04-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-05', '1996-04-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-06', '1996-04-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-07', '1996-04-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-08', '1996-04-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-09', '1996-04-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-10', '1996-04-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-11', '1996-04-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-12', '1996-04-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-13', '1996-04-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-14', '1996-04-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-15', '1996-04-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-16', '1996-04-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-17', '1996-04-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-18', '1996-04-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-19', '1996-04-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-20', '1996-04-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-21', '1996-04-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-22', '1996-04-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-23', '1996-04-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-24', '1996-04-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-25', '1996-04-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-26', '1996-04-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-27', '1996-04-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-28', '1996-04-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-29', '1996-04-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-04-30', '1996-04-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-01', '1996-05-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-02', '1996-05-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-03', '1996-05-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-04', '1996-05-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-05', '1996-05-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-06', '1996-05-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-07', '1996-05-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-08', '1996-05-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-09', '1996-05-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-10', '1996-05-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-11', '1996-05-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-12', '1996-05-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-13', '1996-05-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-14', '1996-05-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-15', '1996-05-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-16', '1996-05-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-17', '1996-05-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-18', '1996-05-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-19', '1996-05-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-20', '1996-05-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-21', '1996-05-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-22', '1996-05-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-23', '1996-05-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-24', '1996-05-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-25', '1996-05-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-26', '1996-05-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-27', '1996-05-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-28', '1996-05-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-29', '1996-05-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-30', '1996-05-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-05-31', '1996-05-31');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-01', '1996-06-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-02', '1996-06-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-03', '1996-06-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-04', '1996-06-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-05', '1996-06-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-06', '1996-06-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-07', '1996-06-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-08', '1996-06-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-09', '1996-06-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-10', '1996-06-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-11', '1996-06-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-12', '1996-06-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-13', '1996-06-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-14', '1996-06-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-15', '1996-06-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-16', '1996-06-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-17', '1996-06-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-18', '1996-06-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-19', '1996-06-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-20', '1996-06-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-21', '1996-06-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-22', '1996-06-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-23', '1996-06-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-24', '1996-06-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-25', '1996-06-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-26', '1996-06-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-27', '1996-06-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-28', '1996-06-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-29', '1996-06-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-06-30', '1996-06-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-01', '1996-07-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-02', '1996-07-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-03', '1996-07-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-04', '1996-07-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-05', '1996-07-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-06', '1996-07-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-07', '1996-07-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-08', '1996-07-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-09', '1996-07-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-10', '1996-07-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-11', '1996-07-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-12', '1996-07-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-13', '1996-07-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-14', '1996-07-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-15', '1996-07-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-16', '1996-07-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-17', '1996-07-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-18', '1996-07-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-19', '1996-07-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-20', '1996-07-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-21', '1996-07-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-22', '1996-07-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-23', '1996-07-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-24', '1996-07-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-25', '1996-07-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-26', '1996-07-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-27', '1996-07-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-28', '1996-07-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-29', '1996-07-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-30', '1996-07-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-07-31', '1996-07-31');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-01', '1996-08-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-02', '1996-08-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-03', '1996-08-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-04', '1996-08-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-05', '1996-08-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-06', '1996-08-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-07', '1996-08-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-08', '1996-08-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-09', '1996-08-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-10', '1996-08-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-11', '1996-08-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-12', '1996-08-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-13', '1996-08-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-14', '1996-08-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-15', '1996-08-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-16', '1996-08-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-17', '1996-08-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-18', '1996-08-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-19', '1996-08-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-20', '1996-08-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-21', '1996-08-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-22', '1996-08-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-23', '1996-08-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-24', '1996-08-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-25', '1996-08-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-26', '1996-08-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-27', '1996-08-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-28', '1996-08-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-29', '1996-08-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-30', '1996-08-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-08-31', '1996-08-31');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-01', '1996-09-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-02', '1996-09-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-03', '1996-09-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-04', '1996-09-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-05', '1996-09-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-06', '1996-09-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-07', '1996-09-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-08', '1996-09-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-09', '1996-09-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-10', '1996-09-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-11', '1996-09-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-12', '1996-09-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-13', '1996-09-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-14', '1996-09-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-15', '1996-09-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-16', '1996-09-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-17', '1996-09-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-18', '1996-09-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-19', '1996-09-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-20', '1996-09-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-21', '1996-09-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-22', '1996-09-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-23', '1996-09-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-24', '1996-09-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-25', '1996-09-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-26', '1996-09-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-27', '1996-09-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-28', '1996-09-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-29', '1996-09-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-09-30', '1996-09-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-01', '1996-10-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-02', '1996-10-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-03', '1996-10-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-04', '1996-10-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-05', '1996-10-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-06', '1996-10-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-07', '1996-10-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-08', '1996-10-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-09', '1996-10-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-10', '1996-10-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-11', '1996-10-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-12', '1996-10-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-13', '1996-10-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-14', '1996-10-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-15', '1996-10-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-16', '1996-10-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-17', '1996-10-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-18', '1996-10-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-19', '1996-10-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-20', '1996-10-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-21', '1996-10-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-22', '1996-10-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-23', '1996-10-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-24', '1996-10-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-25', '1996-10-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-26', '1996-10-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-27', '1996-10-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-28', '1996-10-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-29', '1996-10-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-30', '1996-10-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-10-31', '1996-10-31');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-01', '1996-11-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-02', '1996-11-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-03', '1996-11-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-04', '1996-11-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-05', '1996-11-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-06', '1996-11-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-07', '1996-11-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-08', '1996-11-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-09', '1996-11-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-10', '1996-11-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-11', '1996-11-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-12', '1996-11-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-13', '1996-11-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-14', '1996-11-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-15', '1996-11-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-16', '1996-11-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-17', '1996-11-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-18', '1996-11-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-19', '1996-11-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-20', '1996-11-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-21', '1996-11-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-22', '1996-11-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-23', '1996-11-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-24', '1996-11-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-25', '1996-11-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-26', '1996-11-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-27', '1996-11-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-28', '1996-11-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-29', '1996-11-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-11-30', '1996-11-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-01', '1996-12-01');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-02', '1996-12-02');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-03', '1996-12-03');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-04', '1996-12-04');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-05', '1996-12-05');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-06', '1996-12-06');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-07', '1996-12-07');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-08', '1996-12-08');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-09', '1996-12-09');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-10', '1996-12-10');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-11', '1996-12-11');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-12', '1996-12-12');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-13', '1996-12-13');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-14', '1996-12-14');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-15', '1996-12-15');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-16', '1996-12-16');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-17', '1996-12-17');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-18', '1996-12-18');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-19', '1996-12-19');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-20', '1996-12-20');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-21', '1996-12-21');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-22', '1996-12-22');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-23', '1996-12-23');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-24', '1996-12-24');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-25', '1996-12-25');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-26', '1996-12-26');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-27', '1996-12-27');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-28', '1996-12-28');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-29', '1996-12-29');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-30', '1996-12-30');
  +
rollback;
  +
begin;
  +
select prepared_data.convert_access('1996-12-31', '1996-12-31');
  +
rollback;
  +
</pre>

Latest revision as of 21:29, 10 April 2013

The Process

Initially you will want to work in the gombemi_raw database to convert the data with minimal data integrity rules. Later you can work in gombemi_test to convert with data integrity rules in place and finally in gombemi to do the final conversion.

The general outline is as follows:

  • Import all the support (lookup) tables
  • Import the BIOGRAPHY_DATA table
  • (If necessary) upload the Cross_reference_forprogram.xlxs spreadsheet into the conversion schema.
    • Export it from Excel as csv
    • Upload into the cross_reference_forprogram table.
  • (If necessary) upload the page_followtype.xls spreadsheet into the conversion schema. The page_followtype spreadsheet must have the following column names, all in lower case: date, mom, page, temptype
    • Export it from Excel as csv
    • Upload into the page_followtype table.
  • Export the following tables from Access as csv files:
    • follow
    • follow_page
    • follow_1_minute
    • follow_1_minute_infant
    • follow_1_minute_mother
    • follow_1_minute_sibling
    • follow_5_minute
    • follow_5_minute_left_group
    • follow_5_minute_right_group
  • Delete all rows from the following tables in the conversion schema (if necessary), in the following order:
    • follow_5_minute_left_group
    • follow_5_minute_right_group
    • follow_5_minute
    • follow_1_minute_sibling
    • follow_1_minute_mother
    • follow_1_minute_infant
    • follow_1_minute
    • follow_page
    • follow
  • Import the Access csv files into their corresponding tables in the conversion schema. Import in order of creation as listed above.
  • Prepare the Access data for conversion by running prepare_data() as follows:
    • Either
      • Be sure that prepared_data shows up as part of your search path.
      • Type (paste/etc.) the following into your SQL window and execute it:
        select prepare_data();
    • Or
      • Type (paste/etc.) the following into your SQL window and execute it:
        select prepared_data.prepare_data();
  • Use convert_access() to convert a desired time period, the dates are inclusive. Repeat as necessary with different time periods. If you get an error the database is unchanged.
    select convert_access('1990-01-01', '1990-12-31');
  • Fix errors in the data and repeat until done.
  • When finished query the following tables in the prepared_data schema looking in the column named done for rows with a value of FALSE. These rows were not converted. Figure out why and try again:
    • follow
    • follow_page
    • follow_1_minute
    • follow_1_minute_infant
    • follow_1_minute_mother
    • follow_1_minute_sibling
    • follow_5_minute
    • follow_5_minute_group



Queries will look like: select * from follow where done = 'false';

Obtaining Multiple Errors

The convert_access() program stops as soon as it finds an error, in which case the data in the database remains untouched. If there are many errors in the data it can be tedious converting many days with a single invocation of convert_access(), fixing a single error, and repeating. The solution is to run the program many times, and, regardless of error or lack thereof, discard all changes to the database so that the process can be repeated as many times as desired.

The following example code can be cut and paste to find up to an error per day within entire year's worth of data. Cutting and pasting the example, together with a little search and replace, and attention to leap year, can adapt it to any year or to multiple years.

The sqlbyline program

Use the sqlbyline to execute the SQL. It was written to support the conversion process. Although it's features are limited it serves to report multiple conversion errors when asked to perform multiple conversions. It executes SQL one line at a time. If no file is supplied it will execute the SQL pasted into its textarea.

A year's worth of example conversion sql

begin;
select prepared_data.convert_access('1996-01-01', '1996-01-01');
rollback;
begin;
select prepared_data.convert_access('1996-01-02', '1996-01-02');
rollback;
begin;
select prepared_data.convert_access('1996-01-03', '1996-01-03');
rollback;
begin;
select prepared_data.convert_access('1996-01-04', '1996-01-04');
rollback;
begin;
select prepared_data.convert_access('1996-01-05', '1996-01-05');
rollback;
begin;
select prepared_data.convert_access('1996-01-06', '1996-01-06');
rollback;
begin;
select prepared_data.convert_access('1996-01-07', '1996-01-07');
rollback;
begin;
select prepared_data.convert_access('1996-01-08', '1996-01-08');
rollback;
begin;
select prepared_data.convert_access('1996-01-09', '1996-01-09');
rollback;
begin;
select prepared_data.convert_access('1996-01-10', '1996-01-10');
rollback;
begin;
select prepared_data.convert_access('1996-01-11', '1996-01-11');
rollback;
begin;
select prepared_data.convert_access('1996-01-12', '1996-01-12');
rollback;
begin;
select prepared_data.convert_access('1996-01-13', '1996-01-13');
rollback;
begin;
select prepared_data.convert_access('1996-01-14', '1996-01-14');
rollback;
begin;
select prepared_data.convert_access('1996-01-15', '1996-01-15');
rollback;
begin;
select prepared_data.convert_access('1996-01-16', '1996-01-16');
rollback;
begin;
select prepared_data.convert_access('1996-01-17', '1996-01-17');
rollback;
begin;
select prepared_data.convert_access('1996-01-18', '1996-01-18');
rollback;
begin;
select prepared_data.convert_access('1996-01-19', '1996-01-19');
rollback;
begin;
select prepared_data.convert_access('1996-01-20', '1996-01-20');
rollback;
begin;
select prepared_data.convert_access('1996-01-21', '1996-01-21');
rollback;
begin;
select prepared_data.convert_access('1996-01-22', '1996-01-22');
rollback;
begin;
select prepared_data.convert_access('1996-01-23', '1996-01-23');
rollback;
begin;
select prepared_data.convert_access('1996-01-24', '1996-01-24');
rollback;
begin;
select prepared_data.convert_access('1996-01-25', '1996-01-25');
rollback;
begin;
select prepared_data.convert_access('1996-01-26', '1996-01-26');
rollback;
begin;
select prepared_data.convert_access('1996-01-27', '1996-01-27');
rollback;
begin;
select prepared_data.convert_access('1996-01-28', '1996-01-28');
rollback;
begin;
select prepared_data.convert_access('1996-01-29', '1996-01-29');
rollback;
begin;
select prepared_data.convert_access('1996-01-30', '1996-01-30');
rollback;
begin;
select prepared_data.convert_access('1996-01-31', '1996-01-31');
rollback;
begin;
select prepared_data.convert_access('1996-02-01', '1996-02-01');
rollback;
begin;
select prepared_data.convert_access('1996-02-02', '1996-02-02');
rollback;
begin;
select prepared_data.convert_access('1996-02-03', '1996-02-03');
rollback;
begin;
select prepared_data.convert_access('1996-02-04', '1996-02-04');
rollback;
begin;
select prepared_data.convert_access('1996-02-05', '1996-02-05');
rollback;
begin;
select prepared_data.convert_access('1996-02-06', '1996-02-06');
rollback;
begin;
select prepared_data.convert_access('1996-02-07', '1996-02-07');
rollback;
begin;
select prepared_data.convert_access('1996-02-08', '1996-02-08');
rollback;
begin;
select prepared_data.convert_access('1996-02-09', '1996-02-09');
rollback;
begin;
select prepared_data.convert_access('1996-02-10', '1996-02-10');
rollback;
begin;
select prepared_data.convert_access('1996-02-11', '1996-02-11');
rollback;
begin;
select prepared_data.convert_access('1996-02-12', '1996-02-12');
rollback;
begin;
select prepared_data.convert_access('1996-02-13', '1996-02-13');
rollback;
begin;
select prepared_data.convert_access('1996-02-14', '1996-02-14');
rollback;
begin;
select prepared_data.convert_access('1996-02-15', '1996-02-15');
rollback;
begin;
select prepared_data.convert_access('1996-02-16', '1996-02-16');
rollback;
begin;
select prepared_data.convert_access('1996-02-17', '1996-02-17');
rollback;
begin;
select prepared_data.convert_access('1996-02-18', '1996-02-18');
rollback;
begin;
select prepared_data.convert_access('1996-02-19', '1996-02-19');
rollback;
begin;
select prepared_data.convert_access('1996-02-20', '1996-02-20');
rollback;
begin;
select prepared_data.convert_access('1996-02-21', '1996-02-21');
rollback;
begin;
select prepared_data.convert_access('1996-02-22', '1996-02-22');
rollback;
begin;
select prepared_data.convert_access('1996-02-23', '1996-02-23');
rollback;
begin;
select prepared_data.convert_access('1996-02-24', '1996-02-24');
rollback;
begin;
select prepared_data.convert_access('1996-02-25', '1996-02-25');
rollback;
begin;
select prepared_data.convert_access('1996-02-26', '1996-02-26');
rollback;
begin;
select prepared_data.convert_access('1996-02-27', '1996-02-27');
rollback;
begin;
select prepared_data.convert_access('1996-02-28', '1996-02-28');
rollback;
begin;
select prepared_data.convert_access('1996-02-29', '1996-02-29');
rollback;
begin;
select prepared_data.convert_access('1996-03-01', '1996-03-01');
rollback;
begin;
select prepared_data.convert_access('1996-03-02', '1996-03-02');
rollback;
begin;
select prepared_data.convert_access('1996-03-03', '1996-03-03');
rollback;
begin;
select prepared_data.convert_access('1996-03-04', '1996-03-04');
rollback;
begin;
select prepared_data.convert_access('1996-03-05', '1996-03-05');
rollback;
begin;
select prepared_data.convert_access('1996-03-06', '1996-03-06');
rollback;
begin;
select prepared_data.convert_access('1996-03-07', '1996-03-07');
rollback;
begin;
select prepared_data.convert_access('1996-03-08', '1996-03-08');
rollback;
begin;
select prepared_data.convert_access('1996-03-09', '1996-03-09');
rollback;
begin;
select prepared_data.convert_access('1996-03-10', '1996-03-10');
rollback;
begin;
select prepared_data.convert_access('1996-03-11', '1996-03-11');
rollback;
begin;
select prepared_data.convert_access('1996-03-12', '1996-03-12');
rollback;
begin;
select prepared_data.convert_access('1996-03-13', '1996-03-13');
rollback;
begin;
select prepared_data.convert_access('1996-03-14', '1996-03-14');
rollback;
begin;
select prepared_data.convert_access('1996-03-15', '1996-03-15');
rollback;
begin;
select prepared_data.convert_access('1996-03-16', '1996-03-16');
rollback;
begin;
select prepared_data.convert_access('1996-03-17', '1996-03-17');
rollback;
begin;
select prepared_data.convert_access('1996-03-18', '1996-03-18');
rollback;
begin;
select prepared_data.convert_access('1996-03-19', '1996-03-19');
rollback;
begin;
select prepared_data.convert_access('1996-03-20', '1996-03-20');
rollback;
begin;
select prepared_data.convert_access('1996-03-21', '1996-03-21');
rollback;
begin;
select prepared_data.convert_access('1996-03-22', '1996-03-22');
rollback;
begin;
select prepared_data.convert_access('1996-03-23', '1996-03-23');
rollback;
begin;
select prepared_data.convert_access('1996-03-24', '1996-03-24');
rollback;
begin;
select prepared_data.convert_access('1996-03-25', '1996-03-25');
rollback;
begin;
select prepared_data.convert_access('1996-03-26', '1996-03-26');
rollback;
begin;
select prepared_data.convert_access('1996-03-27', '1996-03-27');
rollback;
begin;
select prepared_data.convert_access('1996-03-28', '1996-03-28');
rollback;
begin;
select prepared_data.convert_access('1996-03-29', '1996-03-29');
rollback;
begin;
select prepared_data.convert_access('1996-03-30', '1996-03-30');
rollback;
begin;
select prepared_data.convert_access('1996-03-31', '1996-03-31');
rollback;
begin;
select prepared_data.convert_access('1996-04-01', '1996-04-01');
rollback;
begin;
select prepared_data.convert_access('1996-04-02', '1996-04-02');
rollback;
begin;
select prepared_data.convert_access('1996-04-03', '1996-04-03');
rollback;
begin;
select prepared_data.convert_access('1996-04-04', '1996-04-04');
rollback;
begin;
select prepared_data.convert_access('1996-04-05', '1996-04-05');
rollback;
begin;
select prepared_data.convert_access('1996-04-06', '1996-04-06');
rollback;
begin;
select prepared_data.convert_access('1996-04-07', '1996-04-07');
rollback;
begin;
select prepared_data.convert_access('1996-04-08', '1996-04-08');
rollback;
begin;
select prepared_data.convert_access('1996-04-09', '1996-04-09');
rollback;
begin;
select prepared_data.convert_access('1996-04-10', '1996-04-10');
rollback;
begin;
select prepared_data.convert_access('1996-04-11', '1996-04-11');
rollback;
begin;
select prepared_data.convert_access('1996-04-12', '1996-04-12');
rollback;
begin;
select prepared_data.convert_access('1996-04-13', '1996-04-13');
rollback;
begin;
select prepared_data.convert_access('1996-04-14', '1996-04-14');
rollback;
begin;
select prepared_data.convert_access('1996-04-15', '1996-04-15');
rollback;
begin;
select prepared_data.convert_access('1996-04-16', '1996-04-16');
rollback;
begin;
select prepared_data.convert_access('1996-04-17', '1996-04-17');
rollback;
begin;
select prepared_data.convert_access('1996-04-18', '1996-04-18');
rollback;
begin;
select prepared_data.convert_access('1996-04-19', '1996-04-19');
rollback;
begin;
select prepared_data.convert_access('1996-04-20', '1996-04-20');
rollback;
begin;
select prepared_data.convert_access('1996-04-21', '1996-04-21');
rollback;
begin;
select prepared_data.convert_access('1996-04-22', '1996-04-22');
rollback;
begin;
select prepared_data.convert_access('1996-04-23', '1996-04-23');
rollback;
begin;
select prepared_data.convert_access('1996-04-24', '1996-04-24');
rollback;
begin;
select prepared_data.convert_access('1996-04-25', '1996-04-25');
rollback;
begin;
select prepared_data.convert_access('1996-04-26', '1996-04-26');
rollback;
begin;
select prepared_data.convert_access('1996-04-27', '1996-04-27');
rollback;
begin;
select prepared_data.convert_access('1996-04-28', '1996-04-28');
rollback;
begin;
select prepared_data.convert_access('1996-04-29', '1996-04-29');
rollback;
begin;
select prepared_data.convert_access('1996-04-30', '1996-04-30');
rollback;
begin;
select prepared_data.convert_access('1996-05-01', '1996-05-01');
rollback;
begin;
select prepared_data.convert_access('1996-05-02', '1996-05-02');
rollback;
begin;
select prepared_data.convert_access('1996-05-03', '1996-05-03');
rollback;
begin;
select prepared_data.convert_access('1996-05-04', '1996-05-04');
rollback;
begin;
select prepared_data.convert_access('1996-05-05', '1996-05-05');
rollback;
begin;
select prepared_data.convert_access('1996-05-06', '1996-05-06');
rollback;
begin;
select prepared_data.convert_access('1996-05-07', '1996-05-07');
rollback;
begin;
select prepared_data.convert_access('1996-05-08', '1996-05-08');
rollback;
begin;
select prepared_data.convert_access('1996-05-09', '1996-05-09');
rollback;
begin;
select prepared_data.convert_access('1996-05-10', '1996-05-10');
rollback;
begin;
select prepared_data.convert_access('1996-05-11', '1996-05-11');
rollback;
begin;
select prepared_data.convert_access('1996-05-12', '1996-05-12');
rollback;
begin;
select prepared_data.convert_access('1996-05-13', '1996-05-13');
rollback;
begin;
select prepared_data.convert_access('1996-05-14', '1996-05-14');
rollback;
begin;
select prepared_data.convert_access('1996-05-15', '1996-05-15');
rollback;
begin;
select prepared_data.convert_access('1996-05-16', '1996-05-16');
rollback;
begin;
select prepared_data.convert_access('1996-05-17', '1996-05-17');
rollback;
begin;
select prepared_data.convert_access('1996-05-18', '1996-05-18');
rollback;
begin;
select prepared_data.convert_access('1996-05-19', '1996-05-19');
rollback;
begin;
select prepared_data.convert_access('1996-05-20', '1996-05-20');
rollback;
begin;
select prepared_data.convert_access('1996-05-21', '1996-05-21');
rollback;
begin;
select prepared_data.convert_access('1996-05-22', '1996-05-22');
rollback;
begin;
select prepared_data.convert_access('1996-05-23', '1996-05-23');
rollback;
begin;
select prepared_data.convert_access('1996-05-24', '1996-05-24');
rollback;
begin;
select prepared_data.convert_access('1996-05-25', '1996-05-25');
rollback;
begin;
select prepared_data.convert_access('1996-05-26', '1996-05-26');
rollback;
begin;
select prepared_data.convert_access('1996-05-27', '1996-05-27');
rollback;
begin;
select prepared_data.convert_access('1996-05-28', '1996-05-28');
rollback;
begin;
select prepared_data.convert_access('1996-05-29', '1996-05-29');
rollback;
begin;
select prepared_data.convert_access('1996-05-30', '1996-05-30');
rollback;
begin;
select prepared_data.convert_access('1996-05-31', '1996-05-31');
rollback;
begin;
select prepared_data.convert_access('1996-06-01', '1996-06-01');
rollback;
begin;
select prepared_data.convert_access('1996-06-02', '1996-06-02');
rollback;
begin;
select prepared_data.convert_access('1996-06-03', '1996-06-03');
rollback;
begin;
select prepared_data.convert_access('1996-06-04', '1996-06-04');
rollback;
begin;
select prepared_data.convert_access('1996-06-05', '1996-06-05');
rollback;
begin;
select prepared_data.convert_access('1996-06-06', '1996-06-06');
rollback;
begin;
select prepared_data.convert_access('1996-06-07', '1996-06-07');
rollback;
begin;
select prepared_data.convert_access('1996-06-08', '1996-06-08');
rollback;
begin;
select prepared_data.convert_access('1996-06-09', '1996-06-09');
rollback;
begin;
select prepared_data.convert_access('1996-06-10', '1996-06-10');
rollback;
begin;
select prepared_data.convert_access('1996-06-11', '1996-06-11');
rollback;
begin;
select prepared_data.convert_access('1996-06-12', '1996-06-12');
rollback;
begin;
select prepared_data.convert_access('1996-06-13', '1996-06-13');
rollback;
begin;
select prepared_data.convert_access('1996-06-14', '1996-06-14');
rollback;
begin;
select prepared_data.convert_access('1996-06-15', '1996-06-15');
rollback;
begin;
select prepared_data.convert_access('1996-06-16', '1996-06-16');
rollback;
begin;
select prepared_data.convert_access('1996-06-17', '1996-06-17');
rollback;
begin;
select prepared_data.convert_access('1996-06-18', '1996-06-18');
rollback;
begin;
select prepared_data.convert_access('1996-06-19', '1996-06-19');
rollback;
begin;
select prepared_data.convert_access('1996-06-20', '1996-06-20');
rollback;
begin;
select prepared_data.convert_access('1996-06-21', '1996-06-21');
rollback;
begin;
select prepared_data.convert_access('1996-06-22', '1996-06-22');
rollback;
begin;
select prepared_data.convert_access('1996-06-23', '1996-06-23');
rollback;
begin;
select prepared_data.convert_access('1996-06-24', '1996-06-24');
rollback;
begin;
select prepared_data.convert_access('1996-06-25', '1996-06-25');
rollback;
begin;
select prepared_data.convert_access('1996-06-26', '1996-06-26');
rollback;
begin;
select prepared_data.convert_access('1996-06-27', '1996-06-27');
rollback;
begin;
select prepared_data.convert_access('1996-06-28', '1996-06-28');
rollback;
begin;
select prepared_data.convert_access('1996-06-29', '1996-06-29');
rollback;
begin;
select prepared_data.convert_access('1996-06-30', '1996-06-30');
rollback;
begin;
select prepared_data.convert_access('1996-07-01', '1996-07-01');
rollback;
begin;
select prepared_data.convert_access('1996-07-02', '1996-07-02');
rollback;
begin;
select prepared_data.convert_access('1996-07-03', '1996-07-03');
rollback;
begin;
select prepared_data.convert_access('1996-07-04', '1996-07-04');
rollback;
begin;
select prepared_data.convert_access('1996-07-05', '1996-07-05');
rollback;
begin;
select prepared_data.convert_access('1996-07-06', '1996-07-06');
rollback;
begin;
select prepared_data.convert_access('1996-07-07', '1996-07-07');
rollback;
begin;
select prepared_data.convert_access('1996-07-08', '1996-07-08');
rollback;
begin;
select prepared_data.convert_access('1996-07-09', '1996-07-09');
rollback;
begin;
select prepared_data.convert_access('1996-07-10', '1996-07-10');
rollback;
begin;
select prepared_data.convert_access('1996-07-11', '1996-07-11');
rollback;
begin;
select prepared_data.convert_access('1996-07-12', '1996-07-12');
rollback;
begin;
select prepared_data.convert_access('1996-07-13', '1996-07-13');
rollback;
begin;
select prepared_data.convert_access('1996-07-14', '1996-07-14');
rollback;
begin;
select prepared_data.convert_access('1996-07-15', '1996-07-15');
rollback;
begin;
select prepared_data.convert_access('1996-07-16', '1996-07-16');
rollback;
begin;
select prepared_data.convert_access('1996-07-17', '1996-07-17');
rollback;
begin;
select prepared_data.convert_access('1996-07-18', '1996-07-18');
rollback;
begin;
select prepared_data.convert_access('1996-07-19', '1996-07-19');
rollback;
begin;
select prepared_data.convert_access('1996-07-20', '1996-07-20');
rollback;
begin;
select prepared_data.convert_access('1996-07-21', '1996-07-21');
rollback;
begin;
select prepared_data.convert_access('1996-07-22', '1996-07-22');
rollback;
begin;
select prepared_data.convert_access('1996-07-23', '1996-07-23');
rollback;
begin;
select prepared_data.convert_access('1996-07-24', '1996-07-24');
rollback;
begin;
select prepared_data.convert_access('1996-07-25', '1996-07-25');
rollback;
begin;
select prepared_data.convert_access('1996-07-26', '1996-07-26');
rollback;
begin;
select prepared_data.convert_access('1996-07-27', '1996-07-27');
rollback;
begin;
select prepared_data.convert_access('1996-07-28', '1996-07-28');
rollback;
begin;
select prepared_data.convert_access('1996-07-29', '1996-07-29');
rollback;
begin;
select prepared_data.convert_access('1996-07-30', '1996-07-30');
rollback;
begin;
select prepared_data.convert_access('1996-07-31', '1996-07-31');
rollback;
begin;
select prepared_data.convert_access('1996-08-01', '1996-08-01');
rollback;
begin;
select prepared_data.convert_access('1996-08-02', '1996-08-02');
rollback;
begin;
select prepared_data.convert_access('1996-08-03', '1996-08-03');
rollback;
begin;
select prepared_data.convert_access('1996-08-04', '1996-08-04');
rollback;
begin;
select prepared_data.convert_access('1996-08-05', '1996-08-05');
rollback;
begin;
select prepared_data.convert_access('1996-08-06', '1996-08-06');
rollback;
begin;
select prepared_data.convert_access('1996-08-07', '1996-08-07');
rollback;
begin;
select prepared_data.convert_access('1996-08-08', '1996-08-08');
rollback;
begin;
select prepared_data.convert_access('1996-08-09', '1996-08-09');
rollback;
begin;
select prepared_data.convert_access('1996-08-10', '1996-08-10');
rollback;
begin;
select prepared_data.convert_access('1996-08-11', '1996-08-11');
rollback;
begin;
select prepared_data.convert_access('1996-08-12', '1996-08-12');
rollback;
begin;
select prepared_data.convert_access('1996-08-13', '1996-08-13');
rollback;
begin;
select prepared_data.convert_access('1996-08-14', '1996-08-14');
rollback;
begin;
select prepared_data.convert_access('1996-08-15', '1996-08-15');
rollback;
begin;
select prepared_data.convert_access('1996-08-16', '1996-08-16');
rollback;
begin;
select prepared_data.convert_access('1996-08-17', '1996-08-17');
rollback;
begin;
select prepared_data.convert_access('1996-08-18', '1996-08-18');
rollback;
begin;
select prepared_data.convert_access('1996-08-19', '1996-08-19');
rollback;
begin;
select prepared_data.convert_access('1996-08-20', '1996-08-20');
rollback;
begin;
select prepared_data.convert_access('1996-08-21', '1996-08-21');
rollback;
begin;
select prepared_data.convert_access('1996-08-22', '1996-08-22');
rollback;
begin;
select prepared_data.convert_access('1996-08-23', '1996-08-23');
rollback;
begin;
select prepared_data.convert_access('1996-08-24', '1996-08-24');
rollback;
begin;
select prepared_data.convert_access('1996-08-25', '1996-08-25');
rollback;
begin;
select prepared_data.convert_access('1996-08-26', '1996-08-26');
rollback;
begin;
select prepared_data.convert_access('1996-08-27', '1996-08-27');
rollback;
begin;
select prepared_data.convert_access('1996-08-28', '1996-08-28');
rollback;
begin;
select prepared_data.convert_access('1996-08-29', '1996-08-29');
rollback;
begin;
select prepared_data.convert_access('1996-08-30', '1996-08-30');
rollback;
begin;
select prepared_data.convert_access('1996-08-31', '1996-08-31');
rollback;
begin;
select prepared_data.convert_access('1996-09-01', '1996-09-01');
rollback;
begin;
select prepared_data.convert_access('1996-09-02', '1996-09-02');
rollback;
begin;
select prepared_data.convert_access('1996-09-03', '1996-09-03');
rollback;
begin;
select prepared_data.convert_access('1996-09-04', '1996-09-04');
rollback;
begin;
select prepared_data.convert_access('1996-09-05', '1996-09-05');
rollback;
begin;
select prepared_data.convert_access('1996-09-06', '1996-09-06');
rollback;
begin;
select prepared_data.convert_access('1996-09-07', '1996-09-07');
rollback;
begin;
select prepared_data.convert_access('1996-09-08', '1996-09-08');
rollback;
begin;
select prepared_data.convert_access('1996-09-09', '1996-09-09');
rollback;
begin;
select prepared_data.convert_access('1996-09-10', '1996-09-10');
rollback;
begin;
select prepared_data.convert_access('1996-09-11', '1996-09-11');
rollback;
begin;
select prepared_data.convert_access('1996-09-12', '1996-09-12');
rollback;
begin;
select prepared_data.convert_access('1996-09-13', '1996-09-13');
rollback;
begin;
select prepared_data.convert_access('1996-09-14', '1996-09-14');
rollback;
begin;
select prepared_data.convert_access('1996-09-15', '1996-09-15');
rollback;
begin;
select prepared_data.convert_access('1996-09-16', '1996-09-16');
rollback;
begin;
select prepared_data.convert_access('1996-09-17', '1996-09-17');
rollback;
begin;
select prepared_data.convert_access('1996-09-18', '1996-09-18');
rollback;
begin;
select prepared_data.convert_access('1996-09-19', '1996-09-19');
rollback;
begin;
select prepared_data.convert_access('1996-09-20', '1996-09-20');
rollback;
begin;
select prepared_data.convert_access('1996-09-21', '1996-09-21');
rollback;
begin;
select prepared_data.convert_access('1996-09-22', '1996-09-22');
rollback;
begin;
select prepared_data.convert_access('1996-09-23', '1996-09-23');
rollback;
begin;
select prepared_data.convert_access('1996-09-24', '1996-09-24');
rollback;
begin;
select prepared_data.convert_access('1996-09-25', '1996-09-25');
rollback;
begin;
select prepared_data.convert_access('1996-09-26', '1996-09-26');
rollback;
begin;
select prepared_data.convert_access('1996-09-27', '1996-09-27');
rollback;
begin;
select prepared_data.convert_access('1996-09-28', '1996-09-28');
rollback;
begin;
select prepared_data.convert_access('1996-09-29', '1996-09-29');
rollback;
begin;
select prepared_data.convert_access('1996-09-30', '1996-09-30');
rollback;
begin;
select prepared_data.convert_access('1996-10-01', '1996-10-01');
rollback;
begin;
select prepared_data.convert_access('1996-10-02', '1996-10-02');
rollback;
begin;
select prepared_data.convert_access('1996-10-03', '1996-10-03');
rollback;
begin;
select prepared_data.convert_access('1996-10-04', '1996-10-04');
rollback;
begin;
select prepared_data.convert_access('1996-10-05', '1996-10-05');
rollback;
begin;
select prepared_data.convert_access('1996-10-06', '1996-10-06');
rollback;
begin;
select prepared_data.convert_access('1996-10-07', '1996-10-07');
rollback;
begin;
select prepared_data.convert_access('1996-10-08', '1996-10-08');
rollback;
begin;
select prepared_data.convert_access('1996-10-09', '1996-10-09');
rollback;
begin;
select prepared_data.convert_access('1996-10-10', '1996-10-10');
rollback;
begin;
select prepared_data.convert_access('1996-10-11', '1996-10-11');
rollback;
begin;
select prepared_data.convert_access('1996-10-12', '1996-10-12');
rollback;
begin;
select prepared_data.convert_access('1996-10-13', '1996-10-13');
rollback;
begin;
select prepared_data.convert_access('1996-10-14', '1996-10-14');
rollback;
begin;
select prepared_data.convert_access('1996-10-15', '1996-10-15');
rollback;
begin;
select prepared_data.convert_access('1996-10-16', '1996-10-16');
rollback;
begin;
select prepared_data.convert_access('1996-10-17', '1996-10-17');
rollback;
begin;
select prepared_data.convert_access('1996-10-18', '1996-10-18');
rollback;
begin;
select prepared_data.convert_access('1996-10-19', '1996-10-19');
rollback;
begin;
select prepared_data.convert_access('1996-10-20', '1996-10-20');
rollback;
begin;
select prepared_data.convert_access('1996-10-21', '1996-10-21');
rollback;
begin;
select prepared_data.convert_access('1996-10-22', '1996-10-22');
rollback;
begin;
select prepared_data.convert_access('1996-10-23', '1996-10-23');
rollback;
begin;
select prepared_data.convert_access('1996-10-24', '1996-10-24');
rollback;
begin;
select prepared_data.convert_access('1996-10-25', '1996-10-25');
rollback;
begin;
select prepared_data.convert_access('1996-10-26', '1996-10-26');
rollback;
begin;
select prepared_data.convert_access('1996-10-27', '1996-10-27');
rollback;
begin;
select prepared_data.convert_access('1996-10-28', '1996-10-28');
rollback;
begin;
select prepared_data.convert_access('1996-10-29', '1996-10-29');
rollback;
begin;
select prepared_data.convert_access('1996-10-30', '1996-10-30');
rollback;
begin;
select prepared_data.convert_access('1996-10-31', '1996-10-31');
rollback;
begin;
select prepared_data.convert_access('1996-11-01', '1996-11-01');
rollback;
begin;
select prepared_data.convert_access('1996-11-02', '1996-11-02');
rollback;
begin;
select prepared_data.convert_access('1996-11-03', '1996-11-03');
rollback;
begin;
select prepared_data.convert_access('1996-11-04', '1996-11-04');
rollback;
begin;
select prepared_data.convert_access('1996-11-05', '1996-11-05');
rollback;
begin;
select prepared_data.convert_access('1996-11-06', '1996-11-06');
rollback;
begin;
select prepared_data.convert_access('1996-11-07', '1996-11-07');
rollback;
begin;
select prepared_data.convert_access('1996-11-08', '1996-11-08');
rollback;
begin;
select prepared_data.convert_access('1996-11-09', '1996-11-09');
rollback;
begin;
select prepared_data.convert_access('1996-11-10', '1996-11-10');
rollback;
begin;
select prepared_data.convert_access('1996-11-11', '1996-11-11');
rollback;
begin;
select prepared_data.convert_access('1996-11-12', '1996-11-12');
rollback;
begin;
select prepared_data.convert_access('1996-11-13', '1996-11-13');
rollback;
begin;
select prepared_data.convert_access('1996-11-14', '1996-11-14');
rollback;
begin;
select prepared_data.convert_access('1996-11-15', '1996-11-15');
rollback;
begin;
select prepared_data.convert_access('1996-11-16', '1996-11-16');
rollback;
begin;
select prepared_data.convert_access('1996-11-17', '1996-11-17');
rollback;
begin;
select prepared_data.convert_access('1996-11-18', '1996-11-18');
rollback;
begin;
select prepared_data.convert_access('1996-11-19', '1996-11-19');
rollback;
begin;
select prepared_data.convert_access('1996-11-20', '1996-11-20');
rollback;
begin;
select prepared_data.convert_access('1996-11-21', '1996-11-21');
rollback;
begin;
select prepared_data.convert_access('1996-11-22', '1996-11-22');
rollback;
begin;
select prepared_data.convert_access('1996-11-23', '1996-11-23');
rollback;
begin;
select prepared_data.convert_access('1996-11-24', '1996-11-24');
rollback;
begin;
select prepared_data.convert_access('1996-11-25', '1996-11-25');
rollback;
begin;
select prepared_data.convert_access('1996-11-26', '1996-11-26');
rollback;
begin;
select prepared_data.convert_access('1996-11-27', '1996-11-27');
rollback;
begin;
select prepared_data.convert_access('1996-11-28', '1996-11-28');
rollback;
begin;
select prepared_data.convert_access('1996-11-29', '1996-11-29');
rollback;
begin;
select prepared_data.convert_access('1996-11-30', '1996-11-30');
rollback;
begin;
select prepared_data.convert_access('1996-12-01', '1996-12-01');
rollback;
begin;
select prepared_data.convert_access('1996-12-02', '1996-12-02');
rollback;
begin;
select prepared_data.convert_access('1996-12-03', '1996-12-03');
rollback;
begin;
select prepared_data.convert_access('1996-12-04', '1996-12-04');
rollback;
begin;
select prepared_data.convert_access('1996-12-05', '1996-12-05');
rollback;
begin;
select prepared_data.convert_access('1996-12-06', '1996-12-06');
rollback;
begin;
select prepared_data.convert_access('1996-12-07', '1996-12-07');
rollback;
begin;
select prepared_data.convert_access('1996-12-08', '1996-12-08');
rollback;
begin;
select prepared_data.convert_access('1996-12-09', '1996-12-09');
rollback;
begin;
select prepared_data.convert_access('1996-12-10', '1996-12-10');
rollback;
begin;
select prepared_data.convert_access('1996-12-11', '1996-12-11');
rollback;
begin;
select prepared_data.convert_access('1996-12-12', '1996-12-12');
rollback;
begin;
select prepared_data.convert_access('1996-12-13', '1996-12-13');
rollback;
begin;
select prepared_data.convert_access('1996-12-14', '1996-12-14');
rollback;
begin;
select prepared_data.convert_access('1996-12-15', '1996-12-15');
rollback;
begin;
select prepared_data.convert_access('1996-12-16', '1996-12-16');
rollback;
begin;
select prepared_data.convert_access('1996-12-17', '1996-12-17');
rollback;
begin;
select prepared_data.convert_access('1996-12-18', '1996-12-18');
rollback;
begin;
select prepared_data.convert_access('1996-12-19', '1996-12-19');
rollback;
begin;
select prepared_data.convert_access('1996-12-20', '1996-12-20');
rollback;
begin;
select prepared_data.convert_access('1996-12-21', '1996-12-21');
rollback;
begin;
select prepared_data.convert_access('1996-12-22', '1996-12-22');
rollback;
begin;
select prepared_data.convert_access('1996-12-23', '1996-12-23');
rollback;
begin;
select prepared_data.convert_access('1996-12-24', '1996-12-24');
rollback;
begin;
select prepared_data.convert_access('1996-12-25', '1996-12-25');
rollback;
begin;
select prepared_data.convert_access('1996-12-26', '1996-12-26');
rollback;
begin;
select prepared_data.convert_access('1996-12-27', '1996-12-27');
rollback;
begin;
select prepared_data.convert_access('1996-12-28', '1996-12-28');
rollback;
begin;
select prepared_data.convert_access('1996-12-29', '1996-12-29');
rollback;
begin;
select prepared_data.convert_access('1996-12-30', '1996-12-30');
rollback;
begin;
select prepared_data.convert_access('1996-12-31', '1996-12-31');
rollback;
Retrieved from "https://gombemi.ccas.gwu.edu/gombemiwiki/index.php?title=AccessConversion&oldid=62"