Exporting Data and the Display

• exporting the datafile to another program
• exporting the calendar's display to another program

• Administrator:
  1. Log into the configuration form
  2. Click the "Update A Calendar" button
  3. Click the "Edit Configuration" button next to the particular calendar whose data is to be exported
  4. Click the "Export Data" button


• Webmaster:
  1. Log into the configuration form
  2. Click the "Export Data" button

Exporting Data

When exporting data, all applications (with the exception of the plain text editor) will receive the information in tab-delimited format. The plain text editor (Notepad, Wordpad, etc) will receive the datafile in pipe "|" delimited format.

DO NOT MAKE CHANGES AND THEN OVERWRITE THE EXISTING DATAFILE UNLESS YOU KNOW WHAT YOU ARE DOING!

Follow the steps listed below for the particular application the calendar's raw data is to be exported to:

• Microsoft Excel:
  1. Select the year of data to export
  2. Click the "Microsoft Excel" button


• Microsoft Word:
  1. Select the year of data to export
  2. Click the "Microsoft Word" button


• Text Editor:
  1. Select the year of data to export
  2. Click the "Text Editor" button


• Microsoft Access:
  1. Select the year of data to export
  2. Click the "Microsoft Excel" button
  3. Save the Excel spreadsheet as an Excel ".xls" file
  4. Launch Microsoft Access
  5. Select the option to create a new database
  6. Select "File | Get External Data | Import" as shown below:
     
     
  
  
  7. From the "Files of Type" drop-down menu, select "Excel .xls" files:
     
     
  
  
  8. Select the file saved in step 3
  9. Click the "Import" button
  10. Check the box "First row contains column headings" as shown below:
      
      
  
  
  11. Click the "Next" button
  12. Continue with the import steps selecting the options that suit your needs best
  
  The data should import into a new MS Access Table named after the calendar the data came from.
  

Exporting Display

This allows the user to take the HTML output and feed it into another application for editing. Different applications will obviously display the output differently and may not always be what you expect!

Note that images and other fancy items may not transfer properly, especially if partial URLs are used (ex: "/images/gfx1.gif") as opposed to full URLs (ex: http://whatever.com/images/gfx1.gif). This is entirely dependent on the end application and is beyond my control. To resolve this issue, it is suggested to turn off the configuration item Use Images before selecting to export the display.

• Microsoft Word
  1. Select the month to view
  2. Select the year to view
  3. Click the "Microsoft Word" button
  
  An example display is shown below. Compare with the Microsoft Power Point export.
  
  Note that some images don't appear, which illustrates the diffence between using "partial" and "full" URLs:
  
  
  
  


• Microsoft Power Point
  1. Select the month to view
  2. Select the year to view
  3. Click the "Microsoft Power Point" button
  
  An example display is shown below. Compare with the Microsoft Word export.
  
  Note that some images don't appear, which illustrates the diffence between using "partial" and "full" URLs: