# MailSteward™

Contents: Home Settings Archive Email Search Email Indexing for faster searches Browse Email Schedule Archive Tags Set Rules for Tagging Back Up Your Database Export... Import mbox files... Check for Duplicate Email Database Statistics Report... Merge Database... Compact Database System Requirements Links: MailSteward Request a feature Submit a Bug SQLite MailTags | Export a Tab or Comma Delimited Text File, a MailSteward Database File, an Mbox File, an SQL File, or a list of email addresses: Any list of stored or retrieved email can be exported to a tab or comma delimited text file, or to a new MailSteward database file, or to an "mbox" format file that can then be imported into most email clients, or to an SQL file that can be imported into a MySQL database. Or a list of all the From, To, or both email addresses can be exported. Just click on the Export drop-down button and select the desired export format. A tab or comma delimited text file can then be imported into FileMaker or Bento or other database and spreadsheet applications. A MailSteward database file can then be accessed by MailSteward by specifying it in the MailSteward Settings. An mbox file can then be imported back into OS X Mail or Microsoft Entourage or other email clients, or MailSteward itself. An SQL file can be imported into MySQL. If the tab or comma delimited text file option is chosen, attachments and tags are not exported. Only the plain text portion of the email is exported. If the MailSteward database file option or the SQL option is chosen, then everything will be exported, including any attachments and tags and copies of the email raw source. In the case of the mbox format, everything will be exported except for the mailbox and tags. The standard mbox email format does not include the concepts of tags or mailboxes. Binary attachments are stored in the original binary format in MailSteward. The SQL generated by MailSteward will also cause the binary attachments to be stored in MySQL as binary blobs. Here are the SQL statements used to create the MySQL database and the email and attachments and origemail and tags tables: CREATE DATABASE IF NOT EXISTS [database name]; USE [database name]; CREATE TABLE IF NOT EXISTS email (id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT,from_fld VARCHAR(255) NOT NULL DEFAULT '',to_fld MEDIUMTEXT NOT NULL,subj_fld MEDIUMTEXT NOT NULL,date_fld datetime NOT NULL,mailbox varchar(127) NOT NULL DEFAULT '',mailto varchar(127) NOT NULL DEFAULT '',body_fld LONGTEXT NOT NULL,numAttach INTEGER NOT NULL DEFAULT 0,attachNames mediumtext NOT NULL,attachText mediumtext NOT NULL,headings MEDIUMTEXT NOT NULL,INDEX dateIndex (date_fld)); CREATE TABLE IF NOT EXISTS attachments (id INT NOT NULL,type_fld varchar(127) NOT NULL DEFAULT '',filename_fld varchar(127) NOT NULL DEFAULT '',encode_fld INT default 0,attach_fld LONGBLOB NOT NULL,INDEX idIndex (id)); CREATE TABLE IF NOT EXISTS origemail (id INTEGER PRIMARY KEY,orig_fld LONGBLOB NOT NULL); CREATE TABLE IF NOT EXISTS tags (id INTEGER PRIMARY KEY,cat_fld varchar(127) NOT NULL DEFAULT '',key_fld varchar(127) NOT NULL DEFAULT '',priority_fld INT DEFAULT 0,notes_fld mediumtext NOT NULL);

TM & Copyright © 2004-2010 pubblog.com. All rights reserved.