3 irev database operations, 1 uploading, 2 exporting – Rice Lake iRite IDE User Manual

Page 92: 3 importing, Uploading, Exporting, Importing

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

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

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

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

This manual is related to the following products:

920i iRite Programming Reference