> For the complete documentation index, see [llms.txt](https://scribo.gitbook.io/literatu-admin/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://scribo.gitbook.io/literatu-admin/importing-allwell-data.md).

# Allwell data

### Preparing for your initial Allwell upload

The Explorer and Ledger combines results for current & previous years to show longitudinal progress for students and the school as a whole. This is why we need a few years of Allwell reporting data to get schools started. &#x20;

As a rule of thumb, we need as many years of history as the school wishes to see in growth. As a minimum we suggest 4 years, however we can import data as far back as 2013.  &#x20;

Obviously, we need data for all tested cohorts and domains.&#x20;

### Exporting the Alphanumeric and Skills Profile reports&#x20;

Login to your Allwell reporting system and export the following files, which are used by the Literatu importer. Please don't rename or edit the files in any way: &#x20;

* **Alphanumeric Report** as a CSV file.&#x20;
* All maths and reading **Skills Profile Student Summary With Questions** reports. If they are generated in '.xlsx' format, please save in '.xls' format.  Please do not edit the contents or headings in the files themselves.&#x20;

Samples of these can be downloaded below.&#x20;

{% file src="/files/-MTnYiXOGvwnKxX1YaVP" %}
Alphanumeric Report Sample
{% endfile %}

{% file src="/files/-MTnYqaMcghIWpfYVEpy" %}
Skills Profile Student Summary With Questions Sample
{% endfile %}

Please contact the test provider if you need instructions or assistance with the export.&#x20;

### &#x20;Importing Allwell Data

To load new Allwell tests, follow the steps below:

\
1\. Open your browser and go to [www.literatu.com](http://www.literatu.com)

2\. Login with your Community Administrator account, and go to [https://www.literatu.com/pat/#/import](https://app.salesforceiq.com/r?target=5eccc553c9e77c0075f540af\&t=AFwhZf3AmkkgDe9s_-R5V_zJT2sFBLofZrtWxZXNV8ScO5Q3JiCUbwsCqo5dKfTvn8TONJf67npDMA9F-OxexktE56EMd3aHSh79-v9HMUjVs7jUpSaE97LcVOwXsocQu2K1BAvfWrJI\&url=https%3A%2F%2Fwww.literatu.com%2Fpat%2F%23%2Fimport)&#x20;

3\. Select **Allwell** from the dropdown menu&#x20;

![](https://681421800-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MQQGsjkQYY0g5yk0IFZ%2F-MTnWY1V6SX3CMceiQrx%2F-MTnZP_ll0qIRElK_XfU%2Fimage.png?alt=media\&token=ee9337a2-8e96-455a-a3cb-ce289a581e0d)

4, Drag and drop or use Browse to upload the Alphanumeric report **first**. Once this is uploaded, upload the Maths and/or Reading Skill Profiles, in XLS format. &#x20;

5\. The files will be uploaded and validated. You will the validated list of files in the import queue, where:

**File** is the name of the file being imported

**Test** is the short name of the test as it will appear in the Diagnostic Explorer dropdown.&#x20;

**Domain** is the test domain, which is defaulted from the import file. You should not need to change this

**Cycle Year** is the year in which the test was completed, which is defaulted from the import file. You should not need to change this.

**Year** is the grade/cohort level of the students in the test. If one Group Report contains more than one year, you will see a row of detail for each year.&#x20;

**Progress** and **Status,** which refer to the upload and validation status of each file. If you do not see a green tick in each row, there was an issue uploading and validating the file. Please check that the file is in the correct format. If you can not find the issue, please email the file to <support@literatu.com>.&#x20;

**Actions.** Click the eye icon to preview the file contents. Click the red bin to delete the file from the import queue.&#x20;

Please ensure all of the information is correct and make any edits required. &#x20;

\
6\. When you are ready to upload your data, click '**Continue to import**'.‌

7\. The next step of the import is name matching; ie matching the students in the Allwell Reports to students accounts in Literatu.‌

Because Allwell data rarely contains an email address or SIS ID, Literatu matches students by name. We automatically match students where we can. Any students we cannot reliably match appear in a validation screen where you can select the correct student from a dropdown.‌

If a student does not have a literatu account, their data will be imported in a limited way. They will appear in the Zone of Proximal Development report only. When their Literatu account is loaded and their names are matched, the data will appear in all Diagnostic Explorer reports, in Insights dashboard and in Ledger (if licensed).‌

8\. Click 'Import all files above' to complete the import. A progress bar will track the import and you will see a confirmation message when the import is complete.‌
