Mapping Columns

Mapping Columns

Import files do not need to have headings with specific names, and the columns of data do not need to be in a specific order.

column_headers.png

During the import however, you will need to map the columns in your spreadsheet to Alps columns so that the application can use the data.

map_columns.PNG

Each box represents a column of data in your spreadsheet, so to map your columns, click the Map button on each, and select the appropriate Alps column from the dropdown.

Column_Mapping_Gif.gif

Some columns will need to be skipped, and some may be recognised automatically. In the example below I have mapped the columns in green, and I can map or skip my column in blue that I am editing.

mapped.PNG

Yellow boxes indicate data that needs to be mapped or skipped.

skipped.PNG

Once you have imported your data, you can click Save for Later at any time and return to your import later.

    • Related Articles

    • Managing Custom Columns

      In Connect Data, we have now added a section underneath the Connect Data Settings that will allow you to edit and delete custom columns that you have imported via the student data import wizard.  For guidance on importing custom columns, please click ...
    • Adding custom columns

      Adding custom columns to your Student Information allows your colleagues to filter by categories that you define. As standard, Alps allows the import of Disadvantage, Ethnicity and Gender columns, with categories that we define and that are ...
    • Subject mapping

      Within any import containing subjects, you will have to map your subject names to Alps subjects. Subject mapping is required within any grades import, teaching data or personalised targets import. Once you have mapped your subjects however, your ...
    • Setting up your Year Group

      The Cohorts page gives an overview of the data currently in the system. Until you have imported your basic student data using the + Year Group wizard, you will not be able to add prior attainment, and you will only be able to add teaching sets and ...
    • Changing subject mappings

      Using the Overwrite & replace option, it is possible to update a subject mapping. Using Overwrite & replace will also remove the incorrect subject. Alternatively, you can change subjects one-by-one for individual students. Editing subjects for ...