Multitech MTCBA-G-UF1 Specifications download pdf (Page 18)

Chapter 6. Message Database

6. Message Database

6.1. Introduction

The Message Database contains incoming and outgoing SMS- and e-mail messages. The location of

the messages is indicated by a DSN connection string, defined in the Options of the software. To

see the location of the database:

 Start the Manager application;

 Open the Configuration Folder and select Options;

 Click on the icon next to Message Database.

By default, the Message Database is located in the

<INSTALL-DIR>\Msg\ directory and is called

Messages.mdb. It is an MS Access database (MS Access 2000 compatible). You can migrate to an

MS SQL database at any time (see also 6.4: ‘Migrating to MS SQL’).

6.2. Message Database - Tables and Fields

The Message Database contains 4 tables:



Messages – all incoming and outgoing messages;



Directions – definitions of incoming and outgoing values for an individual message;



Status – definitions of status values for an individual message;



Type - definitions of type values for an individual message;

Table:

Messages

The 'Messages' table contains the following fields:

Property Type Description

ID Auto

Number

Record primary key. This value is automatically

generated when a new record is inserted.

Direction Number Message direction: Incoming or outgoing.

Values are defined in the 'Directions' table.

Type Number Message type: SMS or e-mail.

Values are defined in the 'Type' table.

Status Number Message type: SMS or e-mail.

Values are defined in the 'Status' table.

ChannelID Number For incoming messages:

Channel which received the message;

For outgoing, scheduled messages:

Preferred channel. If you set this value to 0, the

first available channel will pickup the message.

For outgoing, sent/failed messages:

The channel which picked up the message to deliver

it to the recipient.

MessageReference Number Message reference – if any - assigned by the

provider. Only assigned by SMS channels. SMS

providers provide a message reference; it is used by

the provider later on to acknowledge the message.

1 2 ... 13 14 15 16 17 18 19 20 21 22 23 ... 39 40

Comments to this Manuals

No comments

Multitech MTCBA-G-UF1 Specifications Page 18

Comments to this Manuals

Related products and manuals for Networking Multitech MTCBA-G-UF1