Raw data exports

Raw data exports

Data may be exported to CSV (Comma Separated Value) format, suitable for import into Open Office, MS Excel or other spreadsheet application.

Reader data

The following fields are included in the reader data export:

Field	Info
reader_id	System assigned reader ID.
first_name	First name.
last_name	Last name.
phone	Phone number.
library_desc	Library description.
age_desc	Age description.
city_desc	City description.
zipcode_desc	Zipcode description.
email	E-mail address.
barcode	The reader's library barcode.
grade_desc	Grade description.
school_desc	School description.
date_added	Date the registration was added.
date_updated	Date the registration was updated.
date_validated	Date the registration was validated.
reg_ip	The IP address of the computer where the registration was entered.

Completed level (record) data

The following fields are included in the completed level (record) data export:

Field	Info
reader_id	System assigned reader ID.
first_name	First name.
last_name	Last name.
phone	Phone number.
level_desc	Completed level description.
date_completed	Date the level was completed.
library_desc	Library description.
age_desc	Age description.
city_desc	City description.
zipcode_desc	Zipcode description.
email	E-mail address.
barcode	The reader's library barcode.
grade_desc	Grade description.
school_desc	School description.
date_added	Date the registration was added.
date_updated	Date the registration was updated.
date_validated	Date the registration was validated.
reg_ip	The IP address of the computer where the registration was entered.

NOTE: Readers will have a separate record for each level completed. In other words, a reader completing levels 1-5 will have 5 records.

The data is exported in CSV (comma separated values) format, which can be easily imported into MS Excel, Open Office and other spreadsheet programs. Once imported, you can delete unused fields, change the field order, extract e-mail addresses, create graphs & charts, etc. You can then use the data to create quick lists/counts of specific records. For example: “How many readers who are 10 years old & attended Coyote Ridge school completed level 2?” For MS Excel (2000 & 2003) & Open Office (2.x):

From the menu bar, select Data → Filter → AutoFilter.
Click the age_desc drop-down & select “10”.
Click the school_desc drop-down & select “Coyote Ridge”.
Click the level_desc drop-down & select “Level 2”.
Only matching records are shown.
A count of matching records is shown in the lower-left corner (MS Excel only).

Raw data exports

Reader data

Completed level (record) data

How to use exported data