Help

Exporting Data from HSTOnline


Introduction

You can use the Export option in the Agenda - List View, Lesson Plan, or Library Action buttons to create a .CSV file of displayed items. You can then use the data in the file in whatever way you need.

All of the items in the view will be included in the .CSV file that is created. There is no need to select specific items. Use the search and filter capabilities of the Agenda - List View, Library or Lesson Plan page to limit the display, or leave everything set to 'all' to choose every possible item for inclusion. See the individual Help Pages for those areas to learn more about the filtering options available.


What is a .CSV file?

CSV is a common, relatively simple file format that is widely supported by consumer, business, and scientific applications. Among its most common uses is moving tabular data between programs that natively operate on incompatible (often proprietary and/or undocumented) formats. This works because so many programs support some variation of CSV at least as an alternative import/export format. For example, a user may need to transfer information from a database program that stores data in a proprietary format (that's us - HSTOnline), to a spreadsheet that uses a completely different format. The database program (that's HSTOnline again) most likely can export its data as "CSV"; the exported CSV file can then be imported by the spreadsheet program.
(Source: Comma-separated values: Wikipedia, the Free Encyclopedia).

Creating an Export File

agenda
Agenda - List View Action Menu

  1. Go to the Agenda - List View, Lesson Plan, or Library page.
  2. Set the filters to display the items you want to copy to an exported file.
  3. Click or touch the Action button and choose Export.
  4. When the file is ready, your browser will prompt you to open or save the file. The program used to open the file will depend on your computer settings for CSV files. Typically, they are opened in a spreadsheet program.
    • Data from all possible columns will be included in the exported file.
    • Data appears in the export file exactly as it does in the grid you are viewing: numbers in Links, Supplies, and Skills fields; asterisks in the Dir (*) and Notes (*) fields, the first 150 characters in the Directions (Preview) and Notes (Preview) fields.
  5. Use the features of your spreadsheet or other program to adjust column widths, sort data, and make whatever other changes you wish.
lp
Lesson Plan Action Menu
library
Library Action Menu
Back to top

Sample Exported Files

For this Agenda Report, the view was limited to show just items for Student: Sammie that fall on dates 5/13/2012-5/15/2013.

ar
Agenda Export Report

The Lesson Plan report below was set to display all the items in the Lesson Plan with no limitations set.

lpr
Lesson Plan Export Report

This Library report was set to display all the items entered.

libr
Library Export Report
Back to top

Contact Us  Terms of Use  Privacy Policy  © 2016 Homeschool Solutions, LLC