pergamonmu:bison:readers_fixed
Differences
This shows you the differences between two versions of the page.
|
pergamonmu:bison:readers_fixed [2018/07/06 17:05] admin created |
pergamonmu:bison:readers_fixed [2018/07/06 19:04] (current) admin |
||
|---|---|---|---|
| Line 10: | Line 10: | ||
| ===== Data Processor Layout ===== | ===== Data Processor Layout ===== | ||
| - | There are three options that you need to select to tell BISON how to interpret the general layout of the file. The **[Internal Delimiter]** is only required if you have several pieces of data within the same field, separated by a known character (e.g. 'Red; Green; Blue'). This is usually only required for Catalogue Items however, and rarely for readers. | + | {{:pergamonmu:bison:readers_08.png?direct&200 |}}There are three options that you need to select to tell BISON how to interpret the general layout of the file. The **[Internal Delimiter]** is only required if you have several pieces of data within the same field, separated by a known character (e.g. 'Red; Green; Blue'). This is usually only required for Catalogue Items however, and rarely for readers. |
| More importantly, there is the **[Line Separator]** which is the equivalent to the [Row Separator] on the Delimited page. Setting this option will tell BISON how to break up the lines of the files into separate records - this may vary according to where the file came from, especially is a different operating system. | More importantly, there is the **[Line Separator]** which is the equivalent to the [Row Separator] on the Delimited page. Setting this option will tell BISON how to break up the lines of the files into separate records - this may vary according to where the file came from, especially is a different operating system. | ||
| Line 20: | Line 20: | ||
| ===== Step 1 - Selecting a Preset ===== | ===== Step 1 - Selecting a Preset ===== | ||
| - | If you know that the data file being imported is a standard file that follows one of the presets (or indeed, you have done this already, and have saved a preset from your earlier work), simply select this from the list and proceed to **[Step 3]**, below. | + | {{ :pergamonmu:bison:readers_04.png?direct&200|}}If you know that the data file being imported is a standard file that follows one of the presets (or indeed, you have done this already, and have saved a preset from your earlier work), simply select this from the list and proceed to **[Step 3]**, below. |
| Even if you know the preset for this file, it may be prudent to view the file prior to importing, just to ensure that all of the records are importing as expected. | Even if you know the preset for this file, it may be prudent to view the file prior to importing, just to ensure that all of the records are importing as expected. | ||
| Line 37: | Line 37: | ||
| ==== Select to Ignore Prefixes ==== | ==== Select to Ignore Prefixes ==== | ||
| - | Especially in Fixed-Width files that were intended for printing, there will be lines that are totally unimportant and just contain decoration and general layout. We can tell BISON to ignore these lines by entering a few **unique** characters representing those lines. If we need to 'ignore' multiple lines, enter each ignore prefix separated by a semi-colon. | + | {{:pergamonmu:bison:readers_09.png?direct&200 |}}Especially in Fixed-Width files that were intended for printing, there will be lines that are totally unimportant and just contain decoration and general layout. We can tell BISON to ignore these lines by entering a few **unique** characters representing those lines. If we need to 'ignore' multiple lines, enter each ignore prefix separated by a semi-colon. |
| For example, a report intended for a dot-matrix printer may use a line like **+----------+** to break up sections. To ignore this line, we could probably just enter **+;** as most other lines would not begin with this character, or **+-;** to make it more unique as a normal data line would probably have a space after the plus-symbol before the start of a field. | For example, a report intended for a dot-matrix printer may use a line like **+----------+** to break up sections. To ignore this line, we could probably just enter **+;** as most other lines would not begin with this character, or **+-;** to make it more unique as a normal data line would probably have a space after the plus-symbol before the start of a field. | ||
| Line 57: | Line 57: | ||
| ===== Step 2 - Defining Columns ===== | ===== Step 2 - Defining Columns ===== | ||
| - | Once we have broken down the file into lines correctly, and told BISON how to ignore lines that we do not want, we need to split each individual line into the separate fields. Unfortunately, unlike a delimited file, these field widths may all be different and it will need to some human intervention to configure them. | + | {{ :pergamonmu:bison:readers_10.png?direct&200|}}Once we have broken down the file into lines correctly, and told BISON how to ignore lines that we do not want, we need to split each individual line into the separate fields. Unfortunately, unlike a delimited file, these field widths may all be different and it will need to some human intervention to configure them. |
| At the start, only a single column start-point is defined - as a result, each line is regarded as one long column (another name for 'field' of data). In order to split this single column up, we need to perform the following recursive procedure until we have all of the columns defined. | At the start, only a single column start-point is defined - as a result, each line is regarded as one long column (another name for 'field' of data). In order to split this single column up, we need to perform the following recursive procedure until we have all of the columns defined. | ||
| Line 81: | Line 81: | ||
| ==== 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 (e.g. **AdNo** from SIMS is **AltHID** in Pergamon). As a result, and only after we know how the fields are laid out, 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 (e.g. **AdNo** from SIMS is **AltHID** in Pergamon). As a result, and only after we know how the fields are laid out, 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>**. |
| - | To map a column, click the **<none>** value with your mouse to display a list of possible Pergamon fields to receive this data. Select a field, then progress through each column in turn until each field has a destination selected. If you do not want to import a particular column, just leave the selection as **<none>** and BISON will ignore that column of data. | + | To map a column, click the **<none>** value with your mouse to display a list of possible Pergamon fields to receive this data. Select a field, then progress through each column in turn until each field has a destination selected. If you do not want to import a particular column, just leave the selection as **<none>** and BISON will ignore that column of data. |
| - | Remember that if you have isolated vertical line page-decoration into separate columns, ensure that you leave these columns assigned to **<none>** so that they are not imported! | + | Remember that if you have isolated vertical line page-decoration into separate columns, ensure that you leave these columns assigned to **<none>** so that they are not imported! |
| If you have selected a preset, all of this mapping will be done for you. | If you have selected a preset, all of this mapping will be done for you. | ||
| Line 101: | Line 101: | ||
| ==== 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 107: | Line 107: | ||
| ==== 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>**. |
| ==== Abort ==== | ==== Abort ==== | ||
| Line 119: | Line 119: | ||
| ==== Next >> ==== | ==== Next >> ==== | ||
| - | The **[Next >>]** button uses the current configuration and any changes that have been made to the database to process the data in the spreadsheet, saving each record into BISON's import buffer. | + | The **[Next >>]** button uses the current configuration and any changes that have been made to the database to process the data in the spreadsheet, saving each record into BISON's import buffer. |
| While not actual 'live' yet, the data is loaded into BISON ready for the next step in the import. | While not actual 'live' yet, the data is loaded into BISON ready for the next step in the import. | ||
pergamonmu/bison/readers_fixed.1530896717.txt.gz ยท Last modified: 2018/07/06 17:05 by admin
Page Tools
