Canon 3323B001 Administrator's Guide - Page 33

Using a database as the source of field values, Con Data Source

Page 33 highlights

eCopy Connector for Quick Connect Administrator's Guide | 29 Using a database as the source of field values You can create a file name field or an index field that uses a database as the source of field values. Users at the device can then select from a list of available values for that field. If the database administrator modifies, in a database, values that are associated with a Quick Connect field, users will have access to the changed values. You do not need to make any changes to the field in the Administration console. To use a database as the source of field values: 1 In the console tree, select Quick Connect > Properties > File Name or Index File. 2 Click New. The Field Editor or Index Field Editor window opens (see page 19). 3 In the Name field, enter a name for the new field. 4 In the Type field, select Database as the type. 5 Configure the database. If you have previously configured a data source, the Select Recent Data Source window opens. ■ To use an existing data source, select it and then click OK. ■ If you do not want to use an existing data source, click New. The Configure Data Source window opens. Follow the instructions for configuring a new data source (see page 31). If you have not previously configured a data source, the Configure Data Source window opens. Follow the instructions for configuring a new data source. After selecting or configuring a data source, the Data Field Selector window opens. 6 On the Choose Field tab, select a table, select a column in the table, and then select the default file name or index value from the list of available values. The user at the device can accept the default value for the field or select a value from the list.

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42

eCopy Connector for Quick Connect Administrator’s Guide
|
29
Using a database as the source of field values
You can create a file name field or an index field that uses a database as the
source of field values. Users at the device can then select from a list of
available values for that field.
If the database administrator modifies, in a database, values that are
associated with a Quick Connect field, users will have access to the
changed values. You do not need to make any changes to the field in the
Administration console.
To use a database as the source of field values:
1
In the console tree, select
Quick Connect
>
Properties
>
File
Name
or
Index File
.
2
Click
New
.
The
Field Editor
or
Index Field Editor
window opens (see
page 19).
3
In the
Name
field, enter a name for the new field.
4
In the
Type
field, select
Database
as the type.
5
Configure the database.
If you have previously configured a data source, the
Select Recent
Data Source
window opens.
To use an existing data source, select it and then click
OK
.
If you do not want to use an existing data source, click
New
.
The
Configure Data Source
window opens.
Follow the
instructions for configuring a new data source (see page 31).
If you have not previously configured a data source, the
Configure Data Source
window opens.
Follow the instructions
for configuring a new data source.
After selecting or configuring a data source, the
Data Field
Selector
window opens.
6
On the
Choose Field
tab, select a table, select a column in the
table, and then select the default file name or index value from the
list of available values. The user at the device can accept the default
value for the field or select a value from the list.