Lightning Source Update

1. Overview and Context

This procedure updates the Lightning_source table in the SQL Database.

Lightning Source reports have bee discontinued. Their new reports can no longer be exported.

2. Triggers

The execution of this procedure is usually triggered by

• Metrics

3. Steps to Be Performed

3.1 Download

The books from the Uitgeverij imprint are hosted through Lightning Source. Reports can be downloaded from the Reports>Print Sales menu item.

Lightning Source delivers XLS files.

3.2 Clean

• Open in LibreOffice, switch off "space" as a possible delimiter
• Append 1 column to the left, add date in YYYY-MM-01 format
• Delete table header

3.3 Upload

• Upload into phpMyAdmin table "Lightning_source"
• select Import tab;
• select file
• click "Go."

4. Additional Information

5. Document Control