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.

Tip: If you have re-labeled any of the fields, the CSV output will contain the default field name. This will be fixed in a future release

Reader data

The following fields are included in the reader data export:

Field Info
reader_id System assigned reader ID.
last_name Last name.
first_name First name.
phone Phone number.
completed_levels Count of completed levels.
library_desc Library description.
age_desc Age description.
bdate Birthdate (free-form text).
gender_desc Gender 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.
reg_form The form used for initial registration (self or staff).
staff_notes Notes to/from staff about the reader.
guardian_first_name Guardian's first name.
guardian_last_name Guardian's last name.
guardian_phone Guardian's phone.
guardian_email Guardian's e-mail address.
guardian_barcode Guardian's library barcode.
consent Consent checkbox (0 or 1).
public_checkbox Public checkbox (0 or 1).
public_dropdown_desc Public drop-down description.
public_textbox Public text box.
staff_checkbox Staff checkbox (0 or 1).
staff_dropdown_desc Staff drop-down description.
staff_textbox Staff text box.

Completed level (record) data

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

Field Info
reader_id System assigned reader ID.
last_name Last name.
first_name First name.
phone Phone number.
level_desc Completed level description.
level_detail Which prize was given / task completed / etc for the level.
date_completed Date the level was completed.
library_desc Library description.
age_desc Age description.
bdate Birthdate (free-form text).
gender_desc Gender 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.
reg_form The form used for initial registration (self or staff).
staff_notes Notes to/from staff about the reader.
guardian_first_name Guardian's first name.
guardian_last_name Guardian's last name.
guardian_phone Guardian's phone.
guardian_email Guardian's e-mail address.
guardian_barcode Guardian's library barcode.
consent Consent checkbox (0 or 1).
public_checkbox Public checkbox (0 or 1).
public_dropdown_desc Public drop-down description.
public_textbox Public text box.
staff_checkbox Staff checkbox (0 or 1).
staff_dropdown_desc Staff drop-down description.
staff_textbox Staff text box.

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

How to use exported data

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).
 
info/raw_data_exports.txt (4229 views) · Last modified: 2019/02/04 20:30 by esisler