A little help importing email please
Alabama Hot Pocket
for 2 days and I can't seem to get it to work properly. I'm
instructing agent to import the mbox file (i.e. Inbox) and it seems to
work. The problem is my inbox file has 243 messages in it, and Agent
is only able to import 72. Am I doing something wrong? I've tried
compacting the messages in thunderbird with no change. Is this a
problem with Agent or possibly a Thunderbird problem?
FWIW I've tried on Agent 3.3 and Agent 4.2 same results each time. Any
suggestions or help would be appreciated, TIA
AHP
Ralph Fox
Alabama Hot Pocket wrote:
> X-Newsreader: Forte Agent 3.3/32.846
> I've been attempting to import my mail from Thunderbird into Agent now
> for 2 days and I can't seem to get it to work properly. I'm
> instructing agent to import the mbox file (i.e. Inbox) and it seems to
> work. The problem is my inbox file has 243 messages in it, and Agent
> is only able to import 72. Am I doing something wrong? I've tried
> compacting the messages in thunderbird with no change. Is this a
> problem with Agent or possibly a Thunderbird problem?
Most likely, some of the "From " separator lines in Thunderbird's mbox
file are slightly different to the format which Agent requires.
Agent requires the "From " separator line to be in one of these formats
From <something> <dow> <mon> <day> <hour>:<minute>:<second> <year>
From <something> <dow> <mon> <day> <hour>:<minute>:<second> <timezone> <year>
If the date is in a different format, then Agent does not recognize it as a "From "
separator line.
> FWIW I've tried on Agent 3.3 and Agent 4.2 same results each time. Any
> suggestions or help would be appreciated, TIA
See
Help -> Index -> Importing, messages -> Import Message File Format
Except that Agent does not require the <user>@<domain> part to have an '@' in it.
--
Cheers,
Ralph
Alabama Hot Pocket
That seems to be the problem, the messages after that date are not in
the correct format. Fortunately thunderbird is able to acccess them
and read them, but I would like to ditch thunderbird if at all
possible. Do you know of a tool or something I could try in order to
fix the problem? Thanks
Ralph Fox
The following 'awk' script will convert the Thunderbird mbox file into
a format which is more compatible with Agent.
Instructions
============
1. Copy the text between the ~~~~~~~~ wavy lines below, and save it
as a file named "mbox_moz_2_agent.awk" with a .awk extension.
2. To run the script "mbox_moz_2_agent.awk" you will need a copy
of awk.exe or gawk.exe.
You can download gawk.exe from http://sourceforge.net/projects/unxutils/
Click on the Download link to go to the download page.
Then download the zip file UnxUtils.zip, extract the file gawk.exe
from the zip file, and put gawk.exe in the same directory
as mbox_moz_2_agent.awk.
3. Make a copy of the Thunderbird mbox file (the file with no extension)
and put the copy in the same directory as mbox_moz_2_agent.awk and
gawk.exe.
Let's assume the file name is "File1"
4. Open a Command Prompt window, go to this directory, and
enter the command
gawk -f mbox_moz_2_agent.awk File1 >file2.mbox
You will now have a new file file2.mbox which can be imported
into Agent with all of the messages.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
#!awk -f
#
# ---------------------------------------------------------------
# mbox_moz_2_agent.awk -- Convert Moz mbox files to Agent
#
# DESCRIPTION
#
# Converts a mbox file created by Mozilla Thunderbird or Seamonkey
# into a format that is more compatible with importing into Forte
# Agent.
#
# SYNOPSIS
#
# awk -f mbox_moz_2_agent.awk INPUT_FILE >OUTPUT_FILE
#
# EXAMPLE
#
# awk -f mbox_moz_2_agent.awk Inbox >importme.mbox
#
# WARNING
#
# Do not use this script on mbox files exported from Agent.
# This script is for use on mbox files created by Mozilla
# Thunderbird or Seamonkey.
#
# VERSION
# mbox_moz_2_agent.awk, 18 August 2007, by Ralph Fox
#
# ---------------------------------------------------------------
BEGIN {
prev_line_blank = 1 ;
}
{
if ( $0 ~ /^From / )
{
# always a From_ separater line in Moz/Tbird/SM
if ( ($0 " ") ~ /^From [^[:space:]]+ (Sun|Mon|Tue|Wed|Thu|Fri|Sat) (Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec) (0?[1-9]|[12][0-9]|3[01]) ([01]?[0-9]|2[0-4]):[0-5]?[0-9]:[0-5]?[0-9] (((+|-)[0-9][0-9][0-9][0-9]|[A-Z]+) )?(19|20)[0-9][0-9] / )
{
# Agent compatible From_ line
# From sss Www Mmm dd HH:MM:SS YYYY
# From sss Www Mmm dd HH:MM:SS timezone YYYY
if ( ! prev_line_blank ) { print "" ; } # not essential
print $0 ;
prev_line_blank = 0 ;
}
else
if ( ($0 " ") ~ /^From [^[:space:]]+ (Sun|Mon|Tue|Wed|Thu|Fri|Sat),? (0?[1-9]|[12][0-9]|3[01]) (Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec) (19|20)[0-9][0-9] ([01]?[0-9]|2[0-4]):[0-5]?[0-9]:[0-5]?[0-9] / )
{
# Another format sometimes found in Thunderbird
# From sss Www, dd Mmm YYYY HH:MM:SS
if ( ! prev_line_blank ) { print "" ; } # not essential
print $1 " " $2 " " substr($3,1,3) " " $5 " " $4 " " $7 " " $6 ;
prev_line_blank = 0 ;
}
else
{
s = ( "From ???@??? " strftime("%a %b %d %H:%M:%S %Y", systime()) ) ;
if ( s !~ /^From [^[:space:]]+ (Sun|Mon|Tue|Wed|Thu|Fri|Sat) (Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec) (0?[1-9]|[12][0-9]|3[01]) ([01]?[0-9]|2[0-4]):[0-5]?[0-9]:[0-5]?[0-9] (19|20)[0-9][0-9]$/ )
{
# in case the users awk has used localized versions of %a and %b
s = "From ???@??? Wed Jan 13 03:14:07 GMT 2038"
}
if ( ! prev_line_blank ) { print "" ; } # not essential
print s ;
prev_line_blank = 0 ;
}
}
else
{
print $0 ;
prev_line_blank = ( $0 == "" ? 1 : 0 ) ;
}
}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
Cheers,
Ralph
Alabama Hot Pocket
>The following 'awk' script will convert the Thunderbird mbox file into
>a format which is more compatible with Agent.
>
>
Worked perfectly I really appreciate that, I was beginning to pull my
hair out. :)
Ralph Fox
Alabama Hot Pocket wrote:
> Worked perfectly I really appreciate that, I was beginning to pull my
> hair out. :)
You're welcome.