Difference between revisions of "AccessConversion"

From GombeMIWiki
Jump to: navigation, search
(Mention master spreadsheet)
(Describe how to get lots of errors)
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 30: Line 32:
 
* 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.
  +
  +
== 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.
  +
  +
<pre>
  +
begin; select convert_access('1996-01-01', '1996-01-01'); rollback;
  +
begin; select convert_access('1996-01-02', '1996-01-02'); rollback;
  +
begin; select convert_access('1996-01-03', '1996-01-03'); rollback;
  +
begin; select convert_access('1996-01-04', '1996-01-04'); rollback;
  +
begin; select convert_access('1996-01-05', '1996-01-05'); rollback;
  +
begin; select convert_access('1996-01-06', '1996-01-06'); rollback;
  +
begin; select convert_access('1996-01-07', '1996-01-07'); rollback;
  +
begin; select convert_access('1996-01-08', '1996-01-08'); rollback;
  +
begin; select convert_access('1996-01-09', '1996-01-09'); rollback;
  +
begin; select convert_access('1996-01-10', '1996-01-10'); rollback;
  +
begin; select convert_access('1996-01-11', '1996-01-11'); rollback;
  +
begin; select convert_access('1996-01-12', '1996-01-12'); rollback;
  +
begin; select convert_access('1996-01-13', '1996-01-13'); rollback;
  +
begin; select convert_access('1996-01-14', '1996-01-14'); rollback;
  +
begin; select convert_access('1996-01-15', '1996-01-15'); rollback;
  +
begin; select convert_access('1996-01-16', '1996-01-16'); rollback;
  +
begin; select convert_access('1996-01-17', '1996-01-17'); rollback;
  +
begin; select convert_access('1996-01-18', '1996-01-18'); rollback;
  +
begin; select convert_access('1996-01-19', '1996-01-19'); rollback;
  +
begin; select convert_access('1996-01-20', '1996-01-20'); rollback;
  +
begin; select convert_access('1996-01-21', '1996-01-21'); rollback;
  +
begin; select convert_access('1996-01-22', '1996-01-22'); rollback;
  +
begin; select convert_access('1996-01-23', '1996-01-23'); rollback;
  +
begin; select convert_access('1996-01-24', '1996-01-24'); rollback;
  +
begin; select convert_access('1996-01-25', '1996-01-25'); rollback;
  +
begin; select convert_access('1996-01-26', '1996-01-26'); rollback;
  +
begin; select convert_access('1996-01-27', '1996-01-27'); rollback;
  +
begin; select convert_access('1996-01-28', '1996-01-28'); rollback;
  +
begin; select convert_access('1996-01-29', '1996-01-29'); rollback;
  +
begin; select convert_access('1996-01-30', '1996-01-30'); rollback;
  +
begin; select convert_access('1996-01-31', '1996-01-31'); rollback;
  +
begin; select convert_access('1996-02-01', '1996-02-01'); rollback;
  +
begin; select convert_access('1996-02-02', '1996-02-02'); rollback;
  +
begin; select convert_access('1996-02-03', '1996-02-03'); rollback;
  +
begin; select convert_access('1996-02-04', '1996-02-04'); rollback;
  +
begin; select convert_access('1996-02-05', '1996-02-05'); rollback;
  +
begin; select convert_access('1996-02-06', '1996-02-06'); rollback;
  +
begin; select convert_access('1996-02-07', '1996-02-07'); rollback;
  +
begin; select convert_access('1996-02-08', '1996-02-08'); rollback;
  +
begin; select convert_access('1996-02-09', '1996-02-09'); rollback;
  +
begin; select convert_access('1996-02-10', '1996-02-10'); rollback;
  +
begin; select convert_access('1996-02-11', '1996-02-11'); rollback;
  +
begin; select convert_access('1996-02-12', '1996-02-12'); rollback;
  +
begin; select convert_access('1996-02-13', '1996-02-13'); rollback;
  +
begin; select convert_access('1996-02-14', '1996-02-14'); rollback;
  +
begin; select convert_access('1996-02-15', '1996-02-15'); rollback;
  +
begin; select convert_access('1996-02-16', '1996-02-16'); rollback;
  +
begin; select convert_access('1996-02-17', '1996-02-17'); rollback;
  +
begin; select convert_access('1996-02-18', '1996-02-18'); rollback;
  +
begin; select convert_access('1996-02-19', '1996-02-19'); rollback;
  +
begin; select convert_access('1996-02-20', '1996-02-20'); rollback;
  +
begin; select convert_access('1996-02-21', '1996-02-21'); rollback;
  +
begin; select convert_access('1996-02-22', '1996-02-22'); rollback;
  +
begin; select convert_access('1996-02-23', '1996-02-23'); rollback;
  +
begin; select convert_access('1996-02-24', '1996-02-24'); rollback;
  +
begin; select convert_access('1996-02-25', '1996-02-25'); rollback;
  +
begin; select convert_access('1996-02-26', '1996-02-26'); rollback;
  +
begin; select convert_access('1996-02-27', '1996-02-27'); rollback;
  +
begin; select convert_access('1996-02-28', '1996-02-28'); rollback;
  +
begin; select convert_access('1996-02-29', '1996-02-29'); rollback;
  +
begin; select convert_access('1996-03-01', '1996-03-01'); rollback;
  +
begin; select convert_access('1996-03-02', '1996-03-02'); rollback;
  +
begin; select convert_access('1996-03-03', '1996-03-03'); rollback;
  +
begin; select convert_access('1996-03-04', '1996-03-04'); rollback;
  +
begin; select convert_access('1996-03-05', '1996-03-05'); rollback;
  +
begin; select convert_access('1996-03-06', '1996-03-06'); rollback;
  +
begin; select convert_access('1996-03-07', '1996-03-07'); rollback;
  +
begin; select convert_access('1996-03-08', '1996-03-08'); rollback;
  +
begin; select convert_access('1996-03-09', '1996-03-09'); rollback;
  +
begin; select convert_access('1996-03-10', '1996-03-10'); rollback;
  +
begin; select convert_access('1996-03-11', '1996-03-11'); rollback;
  +
begin; select convert_access('1996-03-12', '1996-03-12'); rollback;
  +
begin; select convert_access('1996-03-13', '1996-03-13'); rollback;
  +
begin; select convert_access('1996-03-14', '1996-03-14'); rollback;
  +
begin; select convert_access('1996-03-15', '1996-03-15'); rollback;
  +
begin; select convert_access('1996-03-16', '1996-03-16'); rollback;
  +
begin; select convert_access('1996-03-17', '1996-03-17'); rollback;
  +
begin; select convert_access('1996-03-18', '1996-03-18'); rollback;
  +
begin; select convert_access('1996-03-19', '1996-03-19'); rollback;
  +
begin; select convert_access('1996-03-20', '1996-03-20'); rollback;
  +
begin; select convert_access('1996-03-21', '1996-03-21'); rollback;
  +
begin; select convert_access('1996-03-22', '1996-03-22'); rollback;
  +
begin; select convert_access('1996-03-23', '1996-03-23'); rollback;
  +
begin; select convert_access('1996-03-24', '1996-03-24'); rollback;
  +
begin; select convert_access('1996-03-25', '1996-03-25'); rollback;
  +
begin; select convert_access('1996-03-26', '1996-03-26'); rollback;
  +
begin; select convert_access('1996-03-27', '1996-03-27'); rollback;
  +
begin; select convert_access('1996-03-28', '1996-03-28'); rollback;
  +
begin; select convert_access('1996-03-29', '1996-03-29'); rollback;
  +
begin; select convert_access('1996-03-30', '1996-03-30'); rollback;
  +
begin; select convert_access('1996-03-31', '1996-03-31'); rollback;
  +
begin; select convert_access('1996-04-01', '1996-04-01'); rollback;
  +
begin; select convert_access('1996-04-02', '1996-04-02'); rollback;
  +
begin; select convert_access('1996-04-03', '1996-04-03'); rollback;
  +
begin; select convert_access('1996-04-04', '1996-04-04'); rollback;
  +
begin; select convert_access('1996-04-05', '1996-04-05'); rollback;
  +
begin; select convert_access('1996-04-06', '1996-04-06'); rollback;
  +
begin; select convert_access('1996-04-07', '1996-04-07'); rollback;
  +
begin; select convert_access('1996-04-08', '1996-04-08'); rollback;
  +
begin; select convert_access('1996-04-09', '1996-04-09'); rollback;
  +
begin; select convert_access('1996-04-10', '1996-04-10'); rollback;
  +
begin; select convert_access('1996-04-11', '1996-04-11'); rollback;
  +
begin; select convert_access('1996-04-12', '1996-04-12'); rollback;
  +
begin; select convert_access('1996-04-13', '1996-04-13'); rollback;
  +
begin; select convert_access('1996-04-14', '1996-04-14'); rollback;
  +
begin; select convert_access('1996-04-15', '1996-04-15'); rollback;
  +
begin; select convert_access('1996-04-16', '1996-04-16'); rollback;
  +
begin; select convert_access('1996-04-17', '1996-04-17'); rollback;
  +
begin; select convert_access('1996-04-18', '1996-04-18'); rollback;
  +
begin; select convert_access('1996-04-19', '1996-04-19'); rollback;
  +
begin; select convert_access('1996-04-20', '1996-04-20'); rollback;
  +
begin; select convert_access('1996-04-21', '1996-04-21'); rollback;
  +
begin; select convert_access('1996-04-22', '1996-04-22'); rollback;
  +
begin; select convert_access('1996-04-23', '1996-04-23'); rollback;
  +
begin; select convert_access('1996-04-24', '1996-04-24'); rollback;
  +
begin; select convert_access('1996-04-25', '1996-04-25'); rollback;
  +
begin; select convert_access('1996-04-26', '1996-04-26'); rollback;
  +
begin; select convert_access('1996-04-27', '1996-04-27'); rollback;
  +
begin; select convert_access('1996-04-28', '1996-04-28'); rollback;
  +
begin; select convert_access('1996-04-29', '1996-04-29'); rollback;
  +
begin; select convert_access('1996-04-30', '1996-04-30'); rollback;
  +
begin; select convert_access('1996-05-01', '1996-05-01'); rollback;
  +
begin; select convert_access('1996-05-02', '1996-05-02'); rollback;
  +
begin; select convert_access('1996-05-03', '1996-05-03'); rollback;
  +
begin; select convert_access('1996-05-04', '1996-05-04'); rollback;
  +
begin; select convert_access('1996-05-05', '1996-05-05'); rollback;
  +
begin; select convert_access('1996-05-06', '1996-05-06'); rollback;
  +
begin; select convert_access('1996-05-07', '1996-05-07'); rollback;
  +
begin; select convert_access('1996-05-08', '1996-05-08'); rollback;
  +
begin; select convert_access('1996-05-09', '1996-05-09'); rollback;
  +
begin; select convert_access('1996-05-10', '1996-05-10'); rollback;
  +
begin; select convert_access('1996-05-11', '1996-05-11'); rollback;
  +
begin; select convert_access('1996-05-12', '1996-05-12'); rollback;
  +
begin; select convert_access('1996-05-13', '1996-05-13'); rollback;
  +
begin; select convert_access('1996-05-14', '1996-05-14'); rollback;
  +
begin; select convert_access('1996-05-15', '1996-05-15'); rollback;
  +
begin; select convert_access('1996-05-16', '1996-05-16'); rollback;
  +
begin; select convert_access('1996-05-17', '1996-05-17'); rollback;
  +
begin; select convert_access('1996-05-18', '1996-05-18'); rollback;
  +
begin; select convert_access('1996-05-19', '1996-05-19'); rollback;
  +
begin; select convert_access('1996-05-20', '1996-05-20'); rollback;
  +
begin; select convert_access('1996-05-21', '1996-05-21'); rollback;
  +
begin; select convert_access('1996-05-22', '1996-05-22'); rollback;
  +
begin; select convert_access('1996-05-23', '1996-05-23'); rollback;
  +
begin; select convert_access('1996-05-24', '1996-05-24'); rollback;
  +
begin; select convert_access('1996-05-25', '1996-05-25'); rollback;
  +
begin; select convert_access('1996-05-26', '1996-05-26'); rollback;
  +
begin; select convert_access('1996-05-27', '1996-05-27'); rollback;
  +
begin; select convert_access('1996-05-28', '1996-05-28'); rollback;
  +
begin; select convert_access('1996-05-29', '1996-05-29'); rollback;
  +
begin; select convert_access('1996-05-30', '1996-05-30'); rollback;
  +
begin; select convert_access('1996-05-31', '1996-05-31'); rollback;
  +
begin; select convert_access('1996-06-01', '1996-06-01'); rollback;
  +
begin; select convert_access('1996-06-02', '1996-06-02'); rollback;
  +
begin; select convert_access('1996-06-03', '1996-06-03'); rollback;
  +
begin; select convert_access('1996-06-04', '1996-06-04'); rollback;
  +
begin; select convert_access('1996-06-05', '1996-06-05'); rollback;
  +
begin; select convert_access('1996-06-06', '1996-06-06'); rollback;
  +
begin; select convert_access('1996-06-07', '1996-06-07'); rollback;
  +
begin; select convert_access('1996-06-08', '1996-06-08'); rollback;
  +
begin; select convert_access('1996-06-09', '1996-06-09'); rollback;
  +
begin; select convert_access('1996-06-10', '1996-06-10'); rollback;
  +
begin; select convert_access('1996-06-11', '1996-06-11'); rollback;
  +
begin; select convert_access('1996-06-12', '1996-06-12'); rollback;
  +
begin; select convert_access('1996-06-13', '1996-06-13'); rollback;
  +
begin; select convert_access('1996-06-14', '1996-06-14'); rollback;
  +
begin; select convert_access('1996-06-15', '1996-06-15'); rollback;
  +
begin; select convert_access('1996-06-16', '1996-06-16'); rollback;
  +
begin; select convert_access('1996-06-17', '1996-06-17'); rollback;
  +
begin; select convert_access('1996-06-18', '1996-06-18'); rollback;
  +
begin; select convert_access('1996-06-19', '1996-06-19'); rollback;
  +
begin; select convert_access('1996-06-20', '1996-06-20'); rollback;
  +
begin; select convert_access('1996-06-21', '1996-06-21'); rollback;
  +
begin; select convert_access('1996-06-22', '1996-06-22'); rollback;
  +
begin; select convert_access('1996-06-23', '1996-06-23'); rollback;
  +
begin; select convert_access('1996-06-24', '1996-06-24'); rollback;
  +
begin; select convert_access('1996-06-25', '1996-06-25'); rollback;
  +
begin; select convert_access('1996-06-26', '1996-06-26'); rollback;
  +
begin; select convert_access('1996-06-27', '1996-06-27'); rollback;
  +
begin; select convert_access('1996-06-28', '1996-06-28'); rollback;
  +
begin; select convert_access('1996-06-29', '1996-06-29'); rollback;
  +
begin; select convert_access('1996-06-30', '1996-06-30'); rollback;
  +
begin; select convert_access('1996-07-01', '1996-07-01'); rollback;
  +
begin; select convert_access('1996-07-02', '1996-07-02'); rollback;
  +
begin; select convert_access('1996-07-03', '1996-07-03'); rollback;
  +
begin; select convert_access('1996-07-04', '1996-07-04'); rollback;
  +
begin; select convert_access('1996-07-05', '1996-07-05'); rollback;
  +
begin; select convert_access('1996-07-06', '1996-07-06'); rollback;
  +
begin; select convert_access('1996-07-07', '1996-07-07'); rollback;
  +
begin; select convert_access('1996-07-08', '1996-07-08'); rollback;
  +
begin; select convert_access('1996-07-09', '1996-07-09'); rollback;
  +
begin; select convert_access('1996-07-10', '1996-07-10'); rollback;
  +
begin; select convert_access('1996-07-11', '1996-07-11'); rollback;
  +
begin; select convert_access('1996-07-12', '1996-07-12'); rollback;
  +
begin; select convert_access('1996-07-13', '1996-07-13'); rollback;
  +
begin; select convert_access('1996-07-14', '1996-07-14'); rollback;
  +
begin; select convert_access('1996-07-15', '1996-07-15'); rollback;
  +
begin; select convert_access('1996-07-16', '1996-07-16'); rollback;
  +
begin; select convert_access('1996-07-17', '1996-07-17'); rollback;
  +
begin; select convert_access('1996-07-18', '1996-07-18'); rollback;
  +
begin; select convert_access('1996-07-19', '1996-07-19'); rollback;
  +
begin; select convert_access('1996-07-20', '1996-07-20'); rollback;
  +
begin; select convert_access('1996-07-21', '1996-07-21'); rollback;
  +
begin; select convert_access('1996-07-22', '1996-07-22'); rollback;
  +
begin; select convert_access('1996-07-23', '1996-07-23'); rollback;
  +
begin; select convert_access('1996-07-24', '1996-07-24'); rollback;
  +
begin; select convert_access('1996-07-25', '1996-07-25'); rollback;
  +
begin; select convert_access('1996-07-26', '1996-07-26'); rollback;
  +
begin; select convert_access('1996-07-27', '1996-07-27'); rollback;
  +
begin; select convert_access('1996-07-28', '1996-07-28'); rollback;
  +
begin; select convert_access('1996-07-29', '1996-07-29'); rollback;
  +
begin; select convert_access('1996-07-30', '1996-07-30'); rollback;
  +
begin; select convert_access('1996-07-31', '1996-07-31'); rollback;
  +
begin; select convert_access('1996-08-01', '1996-08-01'); rollback;
  +
begin; select convert_access('1996-08-02', '1996-08-02'); rollback;
  +
begin; select convert_access('1996-08-03', '1996-08-03'); rollback;
  +
begin; select convert_access('1996-08-04', '1996-08-04'); rollback;
  +
begin; select convert_access('1996-08-05', '1996-08-05'); rollback;
  +
begin; select convert_access('1996-08-06', '1996-08-06'); rollback;
  +
begin; select convert_access('1996-08-07', '1996-08-07'); rollback;
  +
begin; select convert_access('1996-08-08', '1996-08-08'); rollback;
  +
begin; select convert_access('1996-08-09', '1996-08-09'); rollback;
  +
begin; select convert_access('1996-08-10', '1996-08-10'); rollback;
  +
begin; select convert_access('1996-08-11', '1996-08-11'); rollback;
  +
begin; select convert_access('1996-08-12', '1996-08-12'); rollback;
  +
begin; select convert_access('1996-08-13', '1996-08-13'); rollback;
  +
begin; select convert_access('1996-08-14', '1996-08-14'); rollback;
  +
begin; select convert_access('1996-08-15', '1996-08-15'); rollback;
  +
begin; select convert_access('1996-08-16', '1996-08-16'); rollback;
  +
begin; select convert_access('1996-08-17', '1996-08-17'); rollback;
  +
begin; select convert_access('1996-08-18', '1996-08-18'); rollback;
  +
begin; select convert_access('1996-08-19', '1996-08-19'); rollback;
  +
begin; select convert_access('1996-08-20', '1996-08-20'); rollback;
  +
begin; select convert_access('1996-08-21', '1996-08-21'); rollback;
  +
begin; select convert_access('1996-08-22', '1996-08-22'); rollback;
  +
begin; select convert_access('1996-08-23', '1996-08-23'); rollback;
  +
begin; select convert_access('1996-08-24', '1996-08-24'); rollback;
  +
begin; select convert_access('1996-08-25', '1996-08-25'); rollback;
  +
begin; select convert_access('1996-08-26', '1996-08-26'); rollback;
  +
begin; select convert_access('1996-08-27', '1996-08-27'); rollback;
  +
begin; select convert_access('1996-08-28', '1996-08-28'); rollback;
  +
begin; select convert_access('1996-08-29', '1996-08-29'); rollback;
  +
begin; select convert_access('1996-08-30', '1996-08-30'); rollback;
  +
begin; select convert_access('1996-08-31', '1996-08-31'); rollback;
  +
begin; select convert_access('1996-09-01', '1996-09-01'); rollback;
  +
begin; select convert_access('1996-09-02', '1996-09-02'); rollback;
  +
begin; select convert_access('1996-09-03', '1996-09-03'); rollback;
  +
begin; select convert_access('1996-09-04', '1996-09-04'); rollback;
  +
begin; select convert_access('1996-09-05', '1996-09-05'); rollback;
  +
begin; select convert_access('1996-09-06', '1996-09-06'); rollback;
  +
begin; select convert_access('1996-09-07', '1996-09-07'); rollback;
  +
begin; select convert_access('1996-09-08', '1996-09-08'); rollback;
  +
begin; select convert_access('1996-09-09', '1996-09-09'); rollback;
  +
begin; select convert_access('1996-09-10', '1996-09-10'); rollback;
  +
begin; select convert_access('1996-09-11', '1996-09-11'); rollback;
  +
begin; select convert_access('1996-09-12', '1996-09-12'); rollback;
  +
begin; select convert_access('1996-09-13', '1996-09-13'); rollback;
  +
begin; select convert_access('1996-09-14', '1996-09-14'); rollback;
  +
begin; select convert_access('1996-09-15', '1996-09-15'); rollback;
  +
begin; select convert_access('1996-09-16', '1996-09-16'); rollback;
  +
begin; select convert_access('1996-09-17', '1996-09-17'); rollback;
  +
begin; select convert_access('1996-09-18', '1996-09-18'); rollback;
  +
begin; select convert_access('1996-09-19', '1996-09-19'); rollback;
  +
begin; select convert_access('1996-09-20', '1996-09-20'); rollback;
  +
begin; select convert_access('1996-09-21', '1996-09-21'); rollback;
  +
begin; select convert_access('1996-09-22', '1996-09-22'); rollback;
  +
begin; select convert_access('1996-09-23', '1996-09-23'); rollback;
  +
begin; select convert_access('1996-09-24', '1996-09-24'); rollback;
  +
begin; select convert_access('1996-09-25', '1996-09-25'); rollback;
  +
begin; select convert_access('1996-09-26', '1996-09-26'); rollback;
  +
begin; select convert_access('1996-09-27', '1996-09-27'); rollback;
  +
begin; select convert_access('1996-09-28', '1996-09-28'); rollback;
  +
begin; select convert_access('1996-09-29', '1996-09-29'); rollback;
  +
begin; select convert_access('1996-09-30', '1996-09-30'); rollback;
  +
begin; select convert_access('1996-10-01', '1996-10-01'); rollback;
  +
begin; select convert_access('1996-10-02', '1996-10-02'); rollback;
  +
begin; select convert_access('1996-10-03', '1996-10-03'); rollback;
  +
begin; select convert_access('1996-10-04', '1996-10-04'); rollback;
  +
begin; select convert_access('1996-10-05', '1996-10-05'); rollback;
  +
begin; select convert_access('1996-10-06', '1996-10-06'); rollback;
  +
begin; select convert_access('1996-10-07', '1996-10-07'); rollback;
  +
begin; select convert_access('1996-10-08', '1996-10-08'); rollback;
  +
begin; select convert_access('1996-10-09', '1996-10-09'); rollback;
  +
begin; select convert_access('1996-10-10', '1996-10-10'); rollback;
  +
begin; select convert_access('1996-10-11', '1996-10-11'); rollback;
  +
begin; select convert_access('1996-10-12', '1996-10-12'); rollback;
  +
begin; select convert_access('1996-10-13', '1996-10-13'); rollback;
  +
begin; select convert_access('1996-10-14', '1996-10-14'); rollback;
  +
begin; select convert_access('1996-10-15', '1996-10-15'); rollback;
  +
begin; select convert_access('1996-10-16', '1996-10-16'); rollback;
  +
begin; select convert_access('1996-10-17', '1996-10-17'); rollback;
  +
begin; select convert_access('1996-10-18', '1996-10-18'); rollback;
  +
begin; select convert_access('1996-10-19', '1996-10-19'); rollback;
  +
begin; select convert_access('1996-10-20', '1996-10-20'); rollback;
  +
begin; select convert_access('1996-10-21', '1996-10-21'); rollback;
  +
begin; select convert_access('1996-10-22', '1996-10-22'); rollback;
  +
begin; select convert_access('1996-10-23', '1996-10-23'); rollback;
  +
begin; select convert_access('1996-10-24', '1996-10-24'); rollback;
  +
begin; select convert_access('1996-10-25', '1996-10-25'); rollback;
  +
begin; select convert_access('1996-10-26', '1996-10-26'); rollback;
  +
begin; select convert_access('1996-10-27', '1996-10-27'); rollback;
  +
begin; select convert_access('1996-10-28', '1996-10-28'); rollback;
  +
begin; select convert_access('1996-10-29', '1996-10-29'); rollback;
  +
begin; select convert_access('1996-10-30', '1996-10-30'); rollback;
  +
begin; select convert_access('1996-10-31', '1996-10-31'); rollback;
  +
begin; select convert_access('1996-11-01', '1996-11-01'); rollback;
  +
begin; select convert_access('1996-11-02', '1996-11-02'); rollback;
  +
begin; select convert_access('1996-11-03', '1996-11-03'); rollback;
  +
begin; select convert_access('1996-11-04', '1996-11-04'); rollback;
  +
begin; select convert_access('1996-11-05', '1996-11-05'); rollback;
  +
begin; select convert_access('1996-11-06', '1996-11-06'); rollback;
  +
begin; select convert_access('1996-11-07', '1996-11-07'); rollback;
  +
begin; select convert_access('1996-11-08', '1996-11-08'); rollback;
  +
begin; select convert_access('1996-11-09', '1996-11-09'); rollback;
  +
begin; select convert_access('1996-11-10', '1996-11-10'); rollback;
  +
begin; select convert_access('1996-11-11', '1996-11-11'); rollback;
  +
begin; select convert_access('1996-11-12', '1996-11-12'); rollback;
  +
begin; select convert_access('1996-11-13', '1996-11-13'); rollback;
  +
begin; select convert_access('1996-11-14', '1996-11-14'); rollback;
  +
begin; select convert_access('1996-11-15', '1996-11-15'); rollback;
  +
begin; select convert_access('1996-11-16', '1996-11-16'); rollback;
  +
begin; select convert_access('1996-11-17', '1996-11-17'); rollback;
  +
begin; select convert_access('1996-11-18', '1996-11-18'); rollback;
  +
begin; select convert_access('1996-11-19', '1996-11-19'); rollback;
  +
begin; select convert_access('1996-11-20', '1996-11-20'); rollback;
  +
begin; select convert_access('1996-11-21', '1996-11-21'); rollback;
  +
begin; select convert_access('1996-11-22', '1996-11-22'); rollback;
  +
begin; select convert_access('1996-11-23', '1996-11-23'); rollback;
  +
begin; select convert_access('1996-11-24', '1996-11-24'); rollback;
  +
begin; select convert_access('1996-11-25', '1996-11-25'); rollback;
  +
begin; select convert_access('1996-11-26', '1996-11-26'); rollback;
  +
begin; select convert_access('1996-11-27', '1996-11-27'); rollback;
  +
begin; select convert_access('1996-11-28', '1996-11-28'); rollback;
  +
begin; select convert_access('1996-11-29', '1996-11-29'); rollback;
  +
begin; select convert_access('1996-11-30', '1996-11-30'); rollback;
  +
begin; select convert_access('1996-12-01', '1996-12-01'); rollback;
  +
begin; select convert_access('1996-12-02', '1996-12-02'); rollback;
  +
begin; select convert_access('1996-12-03', '1996-12-03'); rollback;
  +
begin; select convert_access('1996-12-04', '1996-12-04'); rollback;
  +
begin; select convert_access('1996-12-05', '1996-12-05'); rollback;
  +
begin; select convert_access('1996-12-06', '1996-12-06'); rollback;
  +
begin; select convert_access('1996-12-07', '1996-12-07'); rollback;
  +
begin; select convert_access('1996-12-08', '1996-12-08'); rollback;
  +
begin; select convert_access('1996-12-09', '1996-12-09'); rollback;
  +
begin; select convert_access('1996-12-10', '1996-12-10'); rollback;
  +
begin; select convert_access('1996-12-11', '1996-12-11'); rollback;
  +
begin; select convert_access('1996-12-12', '1996-12-12'); rollback;
  +
begin; select convert_access('1996-12-13', '1996-12-13'); rollback;
  +
begin; select convert_access('1996-12-14', '1996-12-14'); rollback;
  +
begin; select convert_access('1996-12-15', '1996-12-15'); rollback;
  +
begin; select convert_access('1996-12-16', '1996-12-16'); rollback;
  +
begin; select convert_access('1996-12-17', '1996-12-17'); rollback;
  +
begin; select convert_access('1996-12-18', '1996-12-18'); rollback;
  +
begin; select convert_access('1996-12-19', '1996-12-19'); rollback;
  +
begin; select convert_access('1996-12-20', '1996-12-20'); rollback;
  +
begin; select convert_access('1996-12-21', '1996-12-21'); rollback;
  +
begin; select convert_access('1996-12-22', '1996-12-22'); rollback;
  +
begin; select convert_access('1996-12-23', '1996-12-23'); rollback;
  +
begin; select convert_access('1996-12-24', '1996-12-24'); rollback;
  +
begin; select convert_access('1996-12-25', '1996-12-25'); rollback;
  +
begin; select convert_access('1996-12-26', '1996-12-26'); rollback;
  +
begin; select convert_access('1996-12-27', '1996-12-27'); rollback;
  +
begin; select convert_access('1996-12-28', '1996-12-28'); rollback;
  +
begin; select convert_access('1996-12-29', '1996-12-29'); rollback;
  +
begin; select convert_access('1996-12-30', '1996-12-30'); rollback;
  +
begin; select convert_access('1996-12-31', '1996-12-31'); rollback;
  +
</pre>

Revision as of 21:26, 7 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.
    • Change the "# pages" column heading to "pages".
    • Change the "Group comp problem?" column heading to "Group comp problem".
    • 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_group
  • Delete all rows from the following tables in the conversion schema (if necessary), in the following order:
    • follow_5_minute_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:
    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.

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. 

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