Exporting Global Address List Data

From support-works
Jump to navigation Jump to search

You may find that you have a need to export the Global Address List data from Supportworks.

This information is stored in the sw_messagestore database in the table system_gal. It's possible to use Interactive SQL to extract the data to a text file, but this may then need to be formatted before it can be imported into other programs like MS Excel.

The following command in Interactive SQL will create the text file call "gal.txt" in the root of C:

use sw_messagestore; 
tee c:/gal.txt;
select * from system_gal;

An alternative would be to use a tool like HeidiSQL or similar which has options to export data in different formats.