workshopsinfo.csv

The file workshopsinfo.csv holds all information related to the workshops for the year. This file must be copied to the web server about the beginning of each year; it can be updated as more workshops are added. The information is in the form of a spreadsheet that has been saved in .csv (comma separated value) form.  Each row of the spreadsheet has 8 values (columns).  Each row represents one workshop/presentation/instruction session (herein referred to as just workshops). The rows must list the workshops in chronological order; however, the first row is for column labels.  The following describes the contents of each column - the titles used are the labels to be used in row #1.  It is VERY important that all cells used in the spreadsheet have a Text format and that NO commas are used in any cell.

Col 1:   Canceled
A single letter - Y to indicate "Yes" the workshop is canceled; N to indicate the workshop is not canceled and will actually happen.

Col 2:  Date
This specifies the day on which the workshop will occur. There is no specifically required form; however, day and month are usually enough. 

Col 3:  Time
The time is usually a range, as in 10:00 - Noon There is no specifically required form. If a workshop is repeated on the same day, two ranges may be specified. If a workshop spans two days, each day should have its own entry in the spreadsheet.

Col 4:  Location
This specifies the park or camp or facility or town where the workshop will take place. There is no specifically required form.

Col 5:  Activity
This is a description of the nature of the workshop, presenttion or lesson. If necessary, you may include a link to additional information; however, you must do this using proper HTML syntax. For example, <a href="trainingpreview.htm">details</a>  This creates a link that looks like details which when clicked on goes to the file trainingpreview.htm

Col 6:  Audience
This lists who is expected to attend. For those workshops that are open to the public, that fact should be shown in bold, by entering something like <b>Open to the Public</b>

Col 7:  Presenter
This specifies who will be conducting the workshop. If it is a team effort, multiple names should be listed.

Col 8:  !
Column 8 must contain an exclamation point and nothing else.

A word of warning about putting certain HTML in any of the columns.  I have found that when Excel converts my spreadsheet to .csv form, it handles anything in double quotes badly.  For example, above is an example of how to make a link for column 9; it contains double quotes around the file name - a requirement for the HTML.  In the .csv file, the text is changed to the following:
 "<a href=""trainingpreview.htm"">details</a>"
  During uploading, these extra double quotes in this situation are removed; however, in general you should avoid using double quotes unless they are syntactically required.

Return to WPOC Welcome Page    or   Exclusive Member Pages    or   General Management Actions