Exporting Chat

TV Chat service has support for exporting the chat to external data storage.

TV Chat service performs export operation each time a new item becomes visible, or a visible item becomes not visible.

The contents of this topic:

Exporting to file

When the change in the visible content of the chat occurs, SMS Studio updates the file to reflect the changes.

Depending on the Delete not visible items option, there are two different methods used for exporting:

When the Delete not visible items option is turned on, the file is overwritten with all currently visible items.
When the Delete not visible items option is turned off, only the item which is currently becoming visible is appended to the end of the file.

Note that the external application, which reads the file, will not be able to access the file at the times the file is updated.

Exporting to database

When the change in the visible content of the chat occurs, SMS Studio updates the table in the database to reflect the changes.

The table used for exporting should have the following fields:

ID - The auto-incremented integer value that is used as the unique ID of the record in the table.
MsgID - The unique integer value, assigned and used by SMS Studio.
MsgText - The text of the chat item.

The new record is inserted into the table each time the new item is becoming visible.

If the Delete not visible items option is turned on, then the chat item which is becoming invisible is deleted from the table.

TV Chat Setup dialog - Export tab

Type lets you select the method for exporting chat. Type may have the following values:
None - Do not export chat.
ODBC Data Source - Export chat to a database through ODBC interface.
Text file - Export chat to a text file.
Delete not visible items lets you specify whether the items that become invisible should be deleted from the data storage.

Data Source lets you specify the name of the Data Source to be used for exporting.
User name specifies the user name for connecting to the Data Source.
Password specifies the password for connection to the Data Source.
Table name lets you specify the name of the table the service will use to export the chat.

File name lets you select the file to which the chat will be exported. Use selection button ( ... ) to browse for a file.