pergamonmu:bison:readers_xlsx
Differences
This shows you the differences between two versions of the page.
|
pergamonmu:bison:readers_xlsx [2018/07/06 16:58] admin created |
pergamonmu:bison:readers_xlsx [2018/07/06 18:56] (current) admin |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| As this import is from an Excel XLSX file, the internal format of the file is already known and a sample of the available data is displayed for you to edit. | As this import is from an Excel XLSX file, the internal format of the file is already known and a sample of the available data is displayed for you to edit. | ||
| - | -- add image -- | ||
| - | |||
| ===== Data Processor Layout ===== | ===== Data Processor Layout ===== | ||
| - | + | {{:pergamonmu:bison:readers_03.png?direct&200 |}}The top of the window contains a number of configuration options - these are not required for an XLSX import however, as the file format is already known. | |
| - | The top of the window contains a number of configuration options - these are not required for an XLSX import however, as the file format is already known. | + | |
| Below this is a display sample of the file being imported, along with a band showing how the fields within this file will be mapped to Pergamon fields within the database. As you change configuration options, the appearance of this sample data area will change dynamically to show how your changes are taking effect. | Below this is a display sample of the file being imported, along with a band showing how the fields within this file will be mapped to Pergamon fields within the database. As you change configuration options, the appearance of this sample data area will change dynamically to show how your changes are taking effect. | ||
| Line 20: | Line 17: | ||
| ==== Mapping Data to Pergamon Fields ==== | ==== Mapping Data to Pergamon Fields ==== | ||
| - | It is extremely rare for the headings of data in your import file to match the actual fields in Pergamon. As a result, we need to 'map' each field to tell BISON where to put the data. | + | {{ :pergamonmu:bison:readers_05.png?direct&200|}}It is extremely rare for the headings of data in your import file to match the actual fields in Pergamon. As a result, we need to 'map' each field to tell BISON where to put the data. |
| Above the sample data can be found the 'Mapping Strip' containing each of the column names and what the column is mapped to - at the start, these will all read **<none>**. | Above the sample data can be found the 'Mapping Strip' containing each of the column names and what the column is mapped to - at the start, these will all read **<none>**. | ||
| Line 34: | Line 31: | ||
| ==== Edit Mode ==== | ==== Edit Mode ==== | ||
| - | The **[Edit Mode]** button allows us to edit the data that is displayed in the on-screen spreadsheet and should therefore only be done as the final action before loading the data. **All** of the data is loaded into the spreadsheet, and individual cells can be edited by clicking the field with the mouse. | + | {{:pergamonmu:bison:readers_06.png?direct&200 |}}The **[Edit Mode]** button allows us to edit the data that is displayed in the on-screen spreadsheet and should therefore only be done as the final action before loading the data. **All** of the data is loaded into the spreadsheet, and individual cells can be edited by clicking the field with the mouse. |
| This utility is provided only to make minor changes to data which is clearly incorrect or might cause problems with the import - it changes the data **only** within the on-screen spreadsheet (not the file) and the changes are therefore not permanent. They will only remain if the data is processed and loaded into the Pergamon database. | This utility is provided only to make minor changes to data which is clearly incorrect or might cause problems with the import - it changes the data **only** within the on-screen spreadsheet (not the file) and the changes are therefore not permanent. They will only remain if the data is processed and loaded into the Pergamon database. | ||
| Line 40: | Line 37: | ||
| ==== View Final ==== | ==== View Final ==== | ||
| - | Use the **View Final** button to view a selected record in the form that it will be eventually saved into the Pergamon database, with any processing and changes applied. | + | {{ :pergamonmu:bison:readers_07.png?direct&200|}}Use the **View Final** button to view a selected record in the form that it will be eventually saved into the Pergamon database, with any processing and changes applied. |
| Note that some values displayed may be listed in an abstract fashion such as **<to be calculated at point of saving>**. | Note that some values displayed may be listed in an abstract fashion such as **<to be calculated at point of saving>**. | ||
pergamonmu/bison/readers_xlsx.1530896333.txt.gz · Last modified: 2018/07/06 16:58 by admin
Page Tools
