+
= Old PHP Code Base =
 +
* [[Tables]]
 +
* [[Code]]
 +
 +
= Misc Info =
 +
* [[Order Form Key]]
 +
 
= Previews Parsing =
 
= Previews Parsing =
 
== Purpose ==
 
== Purpose ==
 
To take the previews order form and parse its contents into database tables
 
To take the previews order form and parse its contents into database tables
 +
 +
=== The Previews Web Site ===
 +
 +
Diamond updates the current months order form the Wednesday of the 3RD week of the month (from my old notes. was a URL, but looks like this page has been edited and this info is no longer on the page).
 +
 +
The home page is located at [http://previewsworld.com previewsworld.com]
 +
 +
They now have a [https://previewsworld.com/Article/211310-Digital-PREVIEWS-Catalogs digital version] of previews which you can view on the web site or on a mobile app. Each issue is $3.99
 +
 +
=== Customer Order Form (COF) ===
 +
 +
The Customer Order Form (COF) can be downloaded in Text or PDF format from the [https://www.previewsworld.com/Catalog/CustomerOrderForms Archive] page. The have issues as far back as Jan 2012 on the archive page itself. However, it is posible to request the COFs between JAN 2010 and DEC 2011, by manually entering the URL.
 +
 +
The the URL for each COF follows the format below:
 +
 +
    https://www.previewsworld.com/Catalog/CustomerOrderForm/<format>/<MONYY>
 +
 +
where <format> is either PDF or TXT
 +
 +
and <MONYY> is the 3 letter month abbreviation and the 2 digit year.
 +
 +
Looks like there may be an alternative URL for direct access as far back as FEB09 -- where is JAN09 ?!
 +
 +
    http://www.previewsworld.com/support/previews_docs/orderforms/<MONYY>_COF.txt
 +
 +
==== Current Trends ====
 +
 +
The current trend is
 +
* LATIN-1 (or US-ASCII) encoding of the text
 +
* No blank lines before the FILE-HEADER line
 +
* No leading or trailing white space for the FILE-HEADER line
 +
* The month is spelled out
 +
* VOL. used as the abbreviation for Volume Number
 +
* Issue Number not left padded with Zeros
 +
* Two (2) blank lines after the FILE-HEADER line and before the PAGE line
 +
* No leading space for the PAGE line
 +
* No tailing 5 TAB characters for first PAGE line
 +
 +
==== Text Encoding ====
 +
 +
Nearly all texted format COFs are encoded with the [https://en.wikipedia.org/wiki/ASCII US-ASCII] (56*) encoding or [https://en.wikipedia.org/wiki/ISO/IEC_8859-1 LATIN-1, also known as ISO-8859-1] (43*) encoding with the following exceptions (* as of 2018/11 with 107 total issues from 2010/01 to 2018/11):
 +
* [https://en.wikipedia.org/wiki/Windows-1252 Windows 1252] (6*): FEB15, NOV14, AUG14, FEB14, DEC12, MAY12
 +
* UTF-8 with BOM (1*): DEC15
 +
* UTF-16 \[LE] (1*): JUN17
 +
 +
Note:
 +
* See differences between US-ASCII, LATIN-1 and WINDOWS-1256 Encodings below
 +
 +
==== File Layout General ====
 +
 +
The layout (with some exceptions) generally consists of a FILE-HEADER Line on the first line of the file, followed by some number of blank lines, followed by a PAGE line. As of 2018/11, with 119 issues from 2009/01 to 2018/11:
 +
* The majority (64) have 2 blank lines between the FILE-HEADER line and the first PAGE line (see item 2 below for AUG13; see item 3 below for NOV14)
 +
* 37 have 1 blank line (see item 2 below for JAN2013, DEC12; see item 4 below for MAR10)
 +
* 16 have 3 blank lines
 +
* 1 has 1 blank line
 +
* 1 did not have any FILE-HEADER line (see item 1 below for AUG17)
 +
 +
exceptions:
 +
* AUG17 - no FILE-HEADER line
 +
* AUG13, JAN13, DEC12 - OTHER line types after the header line but before the first PAGE line
 +
* NOV14 - PAGE line with with PAGE specified as 'AG' instead of 'PAGE'
 +
* MAR10 - 1 BLANK line before the HEADER line
 +
 +
===== FILE-HEADER Line Format =====
 +
 +
FILE-HEADER line format
 +
* Constant: 'PREVIEWS' starting in column 1
 +
* Followed by 1 space character
 +
* Followed by either the Month Name or Month Abbreviation (3 characters)
 +
* Followed by 1 space
 +
* Constant: either 'VOL' (with or without a trailing period) or 'V'
 +
* Followed by 1 space if VOL or VOL. or no spaces if V
 +
* Followed by the Volume Number: a 2 digit number that is equal to the issue year minus 1990 (yr - 1990 = vol_nbr)
 +
* Followed by 1 space
 +
* Followed by a pound sign '#'
 +
* Followed by the Issue Number (no intervening spaces): a 1 or 2 digit number, for issues in 2009, with values less than 10, are left padded with a zero (see notes below)
 +
* No trailing spaces
 +
 +
notes:
 +
* JUL14 - wrong issue number of 6 given, it should have been 7
 +
* JAN10 - wrong Month abbreviation of DEC given, it should have been JAN
 +
* AUG10 - wrong Month Name of JULY given, it should have been AUGUST
 +
* JAN12 - wrong Month Name of DECEMBER given, it should have been JANUARY
 +
* JAN13 - wrong Month Name of DECEMBER given, it should have been JANUARY
 +
 +
===== PAGE Line Format =====
 +
 +
PAGE line format
 +
* Constant: 'PAGE' starting in column 1
 +
* Followed by 1 space character
 +
* Followed by the Page Number (not left padded with zeroes)
 +
* Followed by either no trailing white space (first PAGE line of the file) or 5 trailing TAB characters (all other PAGE lines in the file) (see notes below)
 +
 +
notes:
 +
* JAN13 - this issue has non blank lines between the FILE-HEADER line and the PAGE line, which looks to be the reason why its first PAGE line has 5 trailing TAB characters. So its probably correct to assume that this issue is missing the first PAGE line.
 +
* JUL13 - the first PAGE line for this issue contains 5 trailing TAB characters.
 +
* NOV14 - PAGE line with with PAGE specified as 'AG' instead of 'PAGE'
 +
 +
==== File Locations ====
 +
 +
I have down loaded some of the text format COFs and have them located here
 +
[https://github.com/gskluzacek/previews/tree/master/old_code/Preview%20Parsing/previews%20parsing/originals/Archive%202 JAN 2009 thru APR 2013]
 +
 +
I also downloaded some of the PDF format COFs which are located here:
 +
[https://github.com/gskluzacek/previews/tree/master/old_code/Preview%20Parsing/previews%20parsing/pdf JAN 2009 thru DEC 2010, SEP 2011, JAN 2012 thru OCT 2012 and JAN 2013 thru APR 2013]
 +
 +
I also have a full compliment (both PDF and TEXT format from JAN09 to NOV18) of files on my local 5K iMac in the following directory:
 +
/Users/gregskluzacek/Documents/Development/Python/PreviewsParsing/downloads
 +
 +
== Data Analysis ==
 +
 +
the following provides a summary of the FILE HEADER line and first PAGE line of each file
 +
 +
{| class="wikitable"
 +
|-
 +
! Month !! Year !! File Orig !! File New !! Encoding !! Blanks Before !! Blanks After !! Month Abbr !! 'VOL. ', 'VOL ', 'V' !! Iss Nbr Padded !! Page Hdr / Other
 +
|-
 +
| 2018 || 11 || NOV18_COF.txt || cof_2018_11.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 10 || OCT18_COF.txt || cof_2018_10.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 09 || SEP18_COF.txt || cof_2018_09.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 08 || AUG18_COF.txt || cof_2018_08.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 07 || JUL18_COF.txt || cof_2018_07.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 06 || JUN18_COF.txt || cof_2018_06.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 05 || MAY18_COF.txt || cof_2018_05.txt || LATIN-1 || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 04 || APR18_COF.txt || cof_2018_04.txt || LATIN-1 || 0 || 4 || name || VOL. (space) || no || 4 blank lines after FILE HEADER line
 +
|-
 +
| 2018 || 03 || MAR18_COF.txt || cof_2018_03.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 02 || FEB18_COF.txt || cof_2018_02.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2018 || 01 || JAN18_COF.txt || cof_2018_01.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 12 || DEC17_COF.txt || cof_2017_12.txt || LATIN-1 || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 11 || NOV17_COF.txt || cof_2017_11.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 10 || OCT17_COF.txt || cof_2017_10.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 09 || SEP17_COF.txt || cof_2017_09.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 08 || AUG17_COF.txt || cof_2017_08.txt || US-ASCII || no file header line || no file header line || no file header line || no file header line || no file header line || no file header line
 +
|-
 +
| 2017 || 07 || JUL17_COF.txt || cof_2017_07.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 06 || JUN17_COF.txt || cof_2017_06.txt || UTF-16-LE || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 05 || MAY17_COF.txt || cof_2017_05.txt || LATIN-1 || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 04 || APR17_COF.txt || cof_2017_04.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 03 || MAR17_COF.txt || cof_2017_03.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 02 || FEB17_COF.txt || cof_2017_02.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2017 || 01 || JAN17_COF.txt || cof_2017_01.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 12 || DEC16_COF.txt || cof_2016_12.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 11 || NOV16_COF.txt || cof_2016_11.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 10 || OCT16_COF.txt || cof_2016_10.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 09 || SEP16_COF.txt || cof_2016_09.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 08 || AUG16_COF.txt || cof_2016_08.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 07 || JUL16_COF.txt || cof_2016_07.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 06 || JUN16_COF.txt || cof_2016_06.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 05 || MAY16_COF.txt || cof_2016_05.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 04 || APR16_COF.txt || cof_2016_04.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 03 || MAR16_COF.txt || cof_2016_03.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 02 || FEB16_COF.txt || cof_2016_02.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2016 || 01 || JAN16_COF.txt || cof_2016_01.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 12 || DEC15_COF.txt || cof_2015_12.txt || UTF-8-SIG || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 11 || NOV15_COF.txt || cof_2015_11.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 10 || OCT15_COF.txt || cof_2015_10.txt || LATIN-1 || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 09 || SEP15_COF.txt || cof_2015_09.txt || LATIN-1 || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 08 || AUG15_COF.txt || cof_2015_08.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 07 || JUL15_COF.txt || cof_2015_07.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 06 || JUN15_COF.txt || cof_2015_06.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 05 || MAY15_COF.txt || cof_2015_05.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 04 || APR15_COF.txt || cof_2015_04.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 03 || MAR15_COF.txt || cof_2015_03.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 02 || FEB15_COF.txt || cof_2015_02.txt || WINOWS-1252 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2015 || 01 || JAN15_COF.txt || cof_2015_01.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2014 || 12 || DEC14_COF.txt || cof_2014_12.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2014 || 11 || NOV14_COF.txt || cof_2014_11.txt || WINOWS-1252 || 0 || 2 || name || VOL. (space) || no || PAGE mis-specified as AG
 +
|-
 +
| 2014 || 10 || OCT14_COF.txt || cof_2014_10.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2014 || 09 || SEP14_COF.txt || cof_2014_09.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2014 || 08 || AUG14_COF.txt || cof_2014_08.txt || WINOWS-1252 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2014 || 07 || JUL14_COF.txt || cof_2014_07.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no || incorrect issue number of 6, should be 7
 +
|-
 +
| 2014 || 06 || JUN14_COF.txt || cof_2014_06.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2014 || 05 || MAY14_COF.txt || cof_2014_05.txt || LATIN-1 || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2014 || 04 || APR14_COF.txt || cof_2014_04.txt || LATIN-1 || 0 || 2 || abr || VOL. (space) || no ||
 +
|-
 +
| 2014 || 03 || MAR14_COF.txt || cof_2014_03.txt || US-ASCII || 0 || 2 || abr || VOL. (space) || no ||
 +
|-
 +
| 2014 || 02 || FEB14_COF.txt || cof_2014_02.txt || WINOWS-1252 || 0 || 1 || abr || VOL. (space) || no ||
 +
|-
 +
| 2014 || 01 || JAN14_COF.txt || cof_2014_01.txt || US-ASCII || 0 || 2 || abr || VOL. (space) || no ||
 +
|-
 +
| 2013 || 12 || DEC13_COF.txt || cof_2013_12.txt || LATIN-1 || 0 || 2 || abr || VOL. (space) || no ||
 +
|-
 +
| 2013 || 11 || NOV13_COF.txt || cof_2013_11.txt || US-ASCII || 0 || 2 || abr || VOL. (space) || no ||
 +
|-
 +
| 2013 || 10 || OCT13_COF.txt || cof_2013_10.txt || US-ASCII || 0 || 1 || abr || VOL. (space) || no ||
 +
|-
 +
| 2013 || 09 || SEP13_COF.txt || cof_2013_09.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2013 || 08 || AUG13_COF.txt || cof_2013_08.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no || 1 non blank line before PAGE line
 +
|-
 +
| 2013 || 07 || JUL13_COF.txt || cof_2013_07.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no || first PAGE line has 5 trailing TAB characters
 +
|-
 +
| 2013 || 06 || JUN13_COF.txt || cof_2013_06.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2013 || 05 || MAY13_COF.txt || cof_2013_05.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2013 || 04 || APR13_COF.txt || cof_2013_04.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2013 || 03 || MAR13_COF.txt || cof_2013_03.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2013 || 02 || FEB13_COF.txt || cof_2013_02.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2013 || 01 || JAN13_COF.txt || cof_2013_01.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no || 2 non blank lines before PAGE line; incorrect month of DECEMBER, should be JANUARY; first PAGE line has 5 trailing TAB characters
 +
|-
 +
| 2012 || 12 || DEC12_COF.txt || cof_2012_12.txt || WINOWS-1252 || 0 || 1 || name || VOL. (space) || no || 25 non blank lines before PAGE line
 +
|-
 +
| 2012 || 11 || NOV12_COF.txt || cof_2012_11.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 10 || OCT12_COF.txt || cof_2012_10.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 09 || SEP12_COF.txt || cof_2012_09.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 08 || AUG12_COF.txt || cof_2012_08.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 07 || JUL12_COF.txt || cof_2012_07.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 06 || JUN12_COF.txt || cof_2012_06.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 05 || MAY12_COF.txt || cof_2012_05.txt || WINOWS-1252 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 04 || APR12_COF.txt || cof_2012_04.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 03 || MAR12_COF.txt || cof_2012_03.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 02 || FEB12_COF.txt || cof_2012_02.txt || LATIN-1 || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2012 || 01 || JAN12_COF.txt || cof_2012_01.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no || incorrect month of DECEMBER, should be JANUARY
 +
|-
 +
| 2011 || 12 || DEC11_COF.txt || cof_2011_12.txt || LATIN-1 || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 11 || NOV11_COF.txt || cof_2011_11.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 10 || OCT11_COF.txt || cof_2011_10.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 09 || SEP11_COF.txt || cof_2011_09.txt || US-ASCII || 0 || 3 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 08 || AUG11_COF.txt || cof_2011_08.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 07 || JUL11_COF.txt || cof_2011_07.txt || LATIN-1 || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 06 || JUN11_COF.txt || cof_2011_06.txt || US-ASCII || 0 || 2 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 05 || MAY11_COF.txt || cof_2011_05.txt || US-ASCII || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 04 || APR11_COF.txt || cof_2011_04.txt || LATIN-1 || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 03 || MAR11_COF.txt || cof_2011_03.txt || LATIN-1 || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 02 || FEB11_COF.txt || cof_2011_02.txt || LATIN-1 || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2011 || 01 || JAN11_COF.txt || cof_2011_01.txt || LATIN-1 || 0 || 1 || name || VOL. (space) || no ||
 +
|-
 +
| 2010 || 12 || DEC10_COF.txt || cof_2010_12.txt || LATIN-1 || 0 || 1 || name || V (no space) || no ||
 +
|-
 +
| 2010 || 11 || NOV10_COF.txt || cof_2010_11.txt || LATIN-1 || 0 || 2 || name || V (no space) || no ||
 +
|-
 +
| 2010 || 10 || OCT10_COF.txt || cof_2010_10.txt || US-ASCII || 0 || 1 || name || V (no space) || no ||
 +
|-
 +
| 2010 || 09 || SEP10_COF.txt || cof_2010_09.txt || LATIN-1 || 0 || 2 || name || V (no space) || no ||
 +
|-
 +
| 2010 || 08 || AUG10_COF.txt || cof_2010_08.txt || US-ASCII || 0 || 2 || name || V (no space) || no || incorrect month of JULY, should be AUGUST
 +
|-
 +
| 2010 || 07 || JUL10_COF.txt || cof_2010_07.txt || LATIN-1 || 0 || 2 || name || V (no space) || no ||
 +
|-
 +
| 2010 || 06 || JUN10_COF.txt || cof_2010_06.txt || US-ASCII || 0 || 2 || name || V (no space) || no ||
 +
|-
 +
| 2010 || 05 || MAY10_COF.txt || cof_2010_05.txt || US-ASCII || 0 || 2 || name || V (no space) || no ||
 +
|-
 +
| 2010 || 04 || APR10_COF.txt || cof_2010_04.txt || LATIN-1 || 0 || 1 || abr || V (no space) || no ||
 +
|-
 +
| 2010 || 03 || MAR10_COF.txt || cof_2010_03.txt || US-ASCII || 1 || 1 || abr || V (no space) || no || 1 blank line before FILE HEADER line
 +
|-
 +
| 2010 || 02 || FEB10_COF.txt || cof_2010_02.txt || LATIN-1 || 0 || 1 || abr || V (no space) || no ||
 +
|-
 +
| 2010 || 01 || JAN10_COF.txt || cof_2010_01.txt || LATIN-1 || 0 || 1 || abr || V (no space) || no || incorrect month abbr of DEC, should be JAN
 +
|-
 +
| 2009 || 12 || DEC09_COF.txt || cof_2009_12.txt || unknown || 0 || 1 || abr || VOL (space no period) || no ||
 +
|-
 +
| 2009 || 11 || NOV09_COF.txt || cof_2009_11.txt || unknown || 0 || 2 || abr || VOL (space no period) || no ||
 +
|-
 +
| 2009 || 10 || OCT09_COF.txt || cof_2009_10.txt || unknown || 0 || 1 || abr || VOL (space no period) || no ||
 +
|-
 +
| 2009 || 09 || SEP09_COF.txt || cof_2009_09.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|-
 +
| 2009 || 08 || AUG09_COF.txt || cof_2009_08.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|-
 +
| 2009 || 07 || JUL09_COF.txt || cof_2009_07.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|-
 +
| 2009 || 06 || JUN09_COF.txt || cof_2009_06.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|-
 +
| 2009 || 05 || MAY09_COF.txt || cof_2009_05.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|-
 +
| 2009 || 04 || APR09_COF.txt || cof_2009_04.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|-
 +
| 2009 || 03 || MAR09_COF.txt || cof_2009_03.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|-
 +
| 2009 || 02 || FEB09_COF.txt || cof_2009_02.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|-
 +
| 2009 || 01 || JAN09_COF.txt || cof_2009_01.txt || unknown || 0 || 1 || abr || VOL (space no period) || yes ||
 +
|}
 +
 
== High Level Functions ==
 
== High Level Functions ==
 
=== File Loader ===
 
=== File Loader ===
Exception encountered, of type "Error"