3 irev database operations, 1 uploading, 2 exporting – Rice Lake iRite IDE User Manual
Page 92: 3 importing, Uploading, Exporting, Importing
88
920i
Programming Reference
6.3
iRev Database Operations
You can use
iRev
and the
920i Interchange
®
database utility software (PN 72809) to edit, save, and restore
databases for the
920i
. This section describes procedures for maintaining
920i
databases using
iRev
, including:
•
Upload: Copies the database from the
920i
to
iRev
•
Download: Copies the database from
iRev
to the
920i
•
Import: Copies the contents of a database file stored on the PC into
iRev
•
Export: Copies the contents of a database file opened in
iRev
to a file on the PC
•
Clear All: Clears the contents of a database on the
920i
.
Note
An existing
920i
database must be cleared
before downloading a database of the same
name.
•
Editing: Databases can be displayed and edited using the
iRev
Data Editor
6.3.1
Uploading
To upload a database from the indicator (for viewing, editing, or backup), do the following:
1. Make a serial connection between the PC and the
920i
2. Start
iRev
3. Connect to the indicator by clicking on the
Connect
button on the right side of the top toolbar
4. Click the
Database
bar on the left side of the
iRev
window
5. Click the
Data Editor
icon.
6. Select the database you want to upload, then click the
Upload
button on top right of the toolbar.
7. A status message box will confirm that
iRev
is
Uploading Data
. When the upload is done, the message will
change to
Upload Complete. Please export your data to a delimited file for backup
. Click
OK
.
You can now view, edit, or export the contents of the
920i
database. Note that changing the database in
iRev
alone
does not change the database stored in the
920i
; you must then clear the existing
920i
database and replace it by
downloading the edited database (see Section 6.3.5 on page 89).
6.3.2
Exporting
For display, printing, or backup, you can save a database opened in
iRev
to a text file by using the Export
function.
1. With an open database uploaded to or created in
iRev
, click
Export
on the top toolbar.
2. A dialog box is shown to select which separator (delimiter) should be used to separate the database
fields. For example, if you pick tab-delimiting for a customer database, it might look like the following:
ElliotRobert1234555-8686
If you select semi-colon delimiting instead, the same entry will appear as shown below:
Elliot;Robert;1234;555-8686.
3. After you select the delimiter, click
Begin
. You are prompted to choose where to store the text file. Save
it in the same folder as your other program files.
4. When complete, a message box confirms
Export Successful
. You can now use the exported file for viewing
or printing the database, or for later import to
iRev
for download to the
920i
.
6.3.3
Importing
Import works the same way as export but brings a previously exported text file into
iRev
. The imported database
can then be downloaded to the
920i
.
1. Start the
iRev
Data Editor and select the table you into which you want to import data.
2. Click
Import
on the top toolbar.
3. A dialog box is shown to select the file to import. Double click on the file you want to import.
4. The
Data Import Wizard
box is shown that displays the first couple of rows of data in your file. Notice that
the field names are shown as the first row. This is not something you want to import into your database