CreatePS.PL:V1.1.
Freeware but copyrighted (c)1999 - Joe@Brignola.org

The following file was exported from an excel spreadsheet.  We have enclosed the spreadsheet because formatting in excel is easier then this file.  We will explain each field here and if you use a different program, just import this sample file.  Some modifications to PERLSHOP.cgi is still necessary.  This file and conversion perl script does NOT incorporate all PERLSHOP.cgi options but for most people, this should work just fine.  If you have a database with your data in it, just export it to CSV and then import it into a spreadsheet.

We will put the comments within the code and ALL comment lines below will start with # so you know which lines to eliminate.

Any modifications to this code and program is allowed and please forward us a copy so we can modify this master copy.

email: Joe@brignola.org

All fields can be of any length that is acceptable to PERLSHOP.cgi.

COMPANY NAME,00FFFF,PAGE,5,Hit the ORDER button to order any 	item,00FFFF,3,5,30,,,,,

#Company Name, Color for Company name, fileprefix for all outputted files, the last page number, the explanation of what to do, Color for the explanation, Table border width, Table cell padding, Table cell spacing, future enhancements

PAGE,ITEM-ID,ITEM-NAME,DESC,ITEM-PRICE,PRICE,ITEM-WEIGHT,ITEM-TAXTYPE,ITEM-OPTION1,ITEM-OPTION2,ITEM-OPTION3,QTY,ADD'T'L DESC,ORDERcolor
# These are the titles that show up in the table.  At this time, we are only using some of the data.
00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF,00FFFF
# These are the color for each column defined in prior line.  In same order as titles.  This is the HEX code for color.
1,12345,Widget 1,This Widget is called x1,$1.50 ,$1.50 ,0,NONE,Image for W#1,,,1,,
# This is the database records. The data is in the same order as the titles.  Data does NOT have to be present for option fields NOT being used.  This version does NOT have the image column working yet.
1,12346,Widget 2,This Widget is called x2,$2.23 ,$2.23 ,0,NONE,Image for W#2,,,1,,
2,12347,Widget 3,This Widget is called x3,$2.96 ,$2.96 ,0,NONE,Image for W#3,,,1,,
2,12348,Widget 4,This Widget is called x4,$3.69 ,$3.69 ,0,NONE,Image for W#4,,,1,,
2,12349,Widget 5,This Widget is called x5,$4.42 ,$4.42 ,0,NONE,Image for W#5,,,1,,
2,12350,Widget 6,This Widget is called x6,$5.15 ,$5.15 ,0,NONE,Image for W#6,,,1,,
3,12351,Widget 7,This Widget is called x7,$5.88 ,$5.88 ,0,NONE,Image for W#7,,,1,,
3,12352,Widget 8,This Widget is called x8,$6.61 ,$6.61 ,0,NONE,Image for W#8,,,1,,
3,12353,Widget 9,This Widget is called x9,$7.34 ,$7.34 ,0,NONE,Image for W#9,,,1,,
3,12354,Widget 10,This Widget is called x10,$8.07 ,$8.07 ,0,NONE,Image for W#10,,,1,,
3,12355,Widget 11,This Widget is called x11,$8.80 ,$8.80 ,0,NONE,Image for W#11,,,1,,
4,12356,Widget 12,This Widget is called x12,$9.53 ,$9.53 ,0,NONE,Image for W#12,,,1,,
4,12357,Widget 13,This Widget is called x13,$10.26 ,$10.26 ,0,NONE,Image for W#13,,,1,,
4,12358,Widget 14,This Widget is called x14,$10.99 ,$10.99 ,0,NONE,Image for W#14,,,1
4,12359,Widget 15,This Widget is called x15,$11.72 ,$11.72 ,8,NONE,Image for W#15,,,1
5,12360,Widget 16,This Widget is called x16,$12.45 ,$12.45 ,0,NONE,Image for W#16,,,1
5,12361,Widget 17,This Widget is called x17,$13.18 ,$13.18 ,0,NONE,Image for W#17,,,1
5,12362,Widget 18,This Widget is called x18,$13.91 ,$13.91 ,0,NONE,Image for W#18,,,1
5,12363,Widget 19,This Widget is called x19,$14.64 ,$14.64 ,0,NONE,Image for W#19,,,1
5,12364,Widget 20,This Widget is called x20,$15.37 ,$15.37 ,0,NONE,Image for W#20,,,1
#End of data, now define TOC page#0.
toc,,,,,,,,,,,
#must be here as is to denote the start the TOC.
toc,For Home,,1,,,,,,,,
#We have two levels of TOC.  The first field after 'toc' is for top level and the next field is for the second level. All must have the page# to link to.
toc,,For Kitchen,2,,,,,,,,
toc,,For Bathroom,3,,,,,,,,
toc,For Auto,,4,,,,,,,,
toc,For Biz,,5,,,,,,,,
#
# Comments below:

There are two fields that must be changed in createPS.PL.  The location of the files and the input file name.

Example, if your fileprefixname is 'PAGE'.  Your files will be named PAGE0.htm, PAGE1.htm...PAGE999.htm depending on how many pages you describe.  'PAGE0.htm' is reserved for the TOC.