Difference between revisions of "AccessConversion"

Revision as of 16:39, 20 March 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.
  • Export it from Excel as csv
  • Upload into the cross_reference_forprogram table.
• Export the following tables from Access as csv files:
  • follow
  • 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_1_minute
• 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:
  • 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();
• 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_1_minute
  • follow_1_minute_infant
  • follow_1_minute_mother
  • follow_1_minute_sibling
  • follow_5_minute
  • follow_5_minute_group

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.

• sqlbyline -- Execute lines of sql

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;