Technologies Humanware Inc. APBT320 Manuel D’Utilisation
BrailleNote Apex QT User Guide
18-410
18.1.5
Importing Data into a Database.
Importing information into a database is a valuable KeyBase feature that allows you to input
records from files rather than entering them by hand.
records from files rather than entering them by hand.
Comma Separated Values (CSV) is the file type used for importing into a database. It is a file type
that is widely supported by many database and spreadsheet applications, including but not limited
to, Access, Excel, and Lotus Notes. To ensure that .csv files are successfully imported, check that
the first line of the .csv file contains the field names and that these are named the same as the field
names in KeyBase. This is often given as an option when you export data from another application
in order to import the data into KeyBase.
that is widely supported by many database and spreadsheet applications, including but not limited
to, Access, Excel, and Lotus Notes. To ensure that .csv files are successfully imported, check that
the first line of the .csv file contains the field names and that these are named the same as the field
names in KeyBase. This is often given as an option when you export data from another application
in order to import the data into KeyBase.
To begin the process of importing data, either press I or access the KeyBase menu or cycle through
the items using SPACE until you find
"Import Data" and then press ENTER to select it. KeySoft
will prompt
"Source folder name? Press ENTER for (default)", where "default" is the last
folder used. Select the drive and folder containing the .csv file you wish to import. The prompt
"Import data from which CSV file?" will be displayed. Type the name of the .csv file you wish
to import and press ENTER. Alternatively, you can select it from the list of files by pressing
SPACE repeatedly, followed by ENTER when the file is displayed. KeySoft will prompt:
"Does line 1 (field 1, field 2, field 3) contain field names?". If you type Y, KeyBase will
exclude line 1 of the .csv file when importing, because it contains field names rather than data. If
you type N, line 1 will be included.
"Import data from which CSV file?" will be displayed. Type the name of the .csv file you wish
to import and press ENTER. Alternatively, you can select it from the list of files by pressing
SPACE repeatedly, followed by ENTER when the file is displayed. KeySoft will prompt:
"Does line 1 (field 1, field 2, field 3) contain field names?". If you type Y, KeyBase will
exclude line 1 of the .csv file when importing, because it contains field names rather than data. If
you type N, line 1 will be included.
Note: To help you determine whether or not the first line contains field names, KeySoft will display
up to 30 characters of line 1.
up to 30 characters of line 1.
The field mapping of .csv files to the field names in the KeyBase database now begins. Field names
in the .csv file (if field names are present) are compared with those in the database. Once the
matching is complete, the results are displayed as one of the possible outcomes that follow:
in the .csv file (if field names are present) are compared with those in the database. Once the
matching is complete, the results are displayed as one of the possible outcomes that follow:
"All fields match. Review field mapping list?"
"One field doesn't match. Review field mapping list?"
"(A specified number) fields do not match. Review field mapping list?"
"No fields match. Review field mapping list?"
Your response to the result will be either Yes or No. If you type Y, the Field Mapping List will be
displayed. The Field Mapping List contains one item for each field in the .csv file. This will show
you what .csv field maps to which database field. For example, in the case of a membership list,
"(Last name) maps to (last name)". If the .csv file does not contain field titles, an example of a
prompt could be
displayed. The Field Mapping List contains one item for each field in the .csv file. This will show
you what .csv field maps to which database field. For example, in the case of a membership list,
"(Last name) maps to (last name)". If the .csv file does not contain field titles, an example of a
prompt could be
"(Jones) maps to nothing".
To change the mapping of a particular field, press ENTER. You will then be presented with a list of
the fields in the database. Once you have selected a field, KeySoft will once again prompt
"(item) maps to (KeyBase field)" and the new mapping displayed. For example,
"Jones maps to last name".
the fields in the database. Once you have selected a field, KeySoft will once again prompt
"(item) maps to (KeyBase field)" and the new mapping displayed. For example,
"Jones maps to last name".