^{DBImport 1.0}

Category / Domain:	DB
SCOL Voy@ger Compatibility:	V 3.5 or above
Update:	05/2001

Function

This module allows the import of a product table, references and any other information from the data base in order for site visitors to access this information.

It should be noted that only one person can perform data base import on the site.

General notes on the use of this module

§ The data base used with this module must be correctly parametered through ODBC in the Windows control panel.

§ This module must be used in conjunction with the DBRequest module.

§ When an information balloon appears following a mouse movement, it takes over and an element previously selected in a list, for example, will not be highlighted anymore.

§ It is important to correctly click on elements otherwise they will not be considered. Selecting an element using the keyboard is not possible.

§ The import operation is not limited in the number of lines that can be processed.

§ WARNING! The server is highly solicited when importing, especially if several thousand lines are imported.

Configuration

Figure 1: DBImport Module Interface

�	Source data base	Indicates Source data base. Then click on Connection button to activate link with base. Once base is selected, choose a table in that base. Fields, SQL types, and field size appears
	To use this module/plugin, you must enter, in SCOL resources (usmress.ini file), the login and password giving access to the data base used: § Either from the SCOL Voy@ger interface: - Right click on the blue SCOL icon in the task bar located in the lower right hand side of the screen. - Go to Advanced menu, then Resource Editor to edit usmress.ini file. § Or directly by editing the usmress.ini file located in the “scol/” directory. Then type in the following two lines: odbc.odbcAlias.login odbc.odbcAlias.password while specifying the ODBC alias, access login and corresponding password. Example: odbc.ecomdb.login Admin odbc.ecomdb.password Admin Note: odbcAlias must not include the following 3 characters: ". * ?".
‚	Destination data base	Indicates Destination data base (ACTIV Shop). Then click on Connection button to activate link with base. Once base is selected, choose a table in that base. Fields, SQL types, and field size appears. To insert a source data base field in the destinations data base, select the field by clicking on it, then select a destination field in the destination data base, then click on Spill attribute content...in attribute... (if no field is selected, the button will display Select source table and destination table.
ƒ	Choice of attribute	Area authorizing duplication or not for each attribute in the data base and destination. Select desired attribute(s), then click on Duplicate? button to authorize/forbid duplication. It is possible to delete them by selecting them (mouse click), then clicking on the Delete button.
„	Line insertion mode	There are two ways of inserting a line in the data base: Through the SGDB that automatically manages the insertion (except for MySQL type data bases). Through a table that describes overall data base identifiers (metatable). In this case, it is necessary to define where the metatable is located (Meta pull-down menu) and with which table identifier it must be used (Max ID pull-down menu).

Implementation

Action	Function
module.event à DBimport.start	Starts module at customer site.
module.event à DBimport.startImport	Initiates data base import.
module.event à DBimport.destroy	Destroys customer section in module.

Event	Function
DBimport.out à module.action	Module destroyed at customer site triggers an action.
DBimport.querySQL à module.action	An SQL request triggers an action.
DBimport.entering à module.action	Creation of a customer instance triggers an action.
DBimport.ImportStartedà module.action	Beginning data base import triggers an action.
DBimport.ImportEnd à module.action	Ending data base import triggers an action.
DBimport.shownà module.action	Display of module customer interface triggers an action.
DBimport.hidden à module.action	Disappearance (blanking) of module customer interface triggers an action.
DBimport.In à module.action	Creation of module customer section triggers an action.

Area	Function	Interface	Assignment
None