OK, here's the perl script that will extract the
addresses from the html
code and print out a CSV list of names and addresses.
First, go to the Address Book web page within the
IMail web client, and
then save the page as addrbook.html. Then run this
script I've called
imailaddr.pl
---------------------
#!/usr/bin/perl
undef $/;
$_=<>;
print "Name,E-mail\r\n";
while (m#<option value="[0-9]+">"([^"]*)"
<([^&]*)>\s*</option>#)
{
$_=$';
print "\"$1\",\"$2\"\r\n";
}
---------------------
Run it like this from the command line (i have perl
installed under
cygwin on my windows system)
imailaddr.pl < addrbook.html > addrbook.csv
The resulting addrbook.csv file can be used as is to
import the
addresses into either MS Outlook or Outlook Express.
Good luck!
--
Mike van der Velden email [EMAIL PROTECTED]
System Administrator cell 604-868-1562
Kinetic Consulting Group, Ltd.
Port Moody, BC. Canada
"Like almost everyone, I receive a lot of spam every
day, much of
it offering to help me get out of debt or get rich
quick. It's
ridiculous."
-- Bill Gates, the world's richest
man.
[EMAIL PROTECTED] wrote:
> of course! thanks for the idea. It won't take
but a few lines of
> perl (sorry, I'm revealing my UNIX roots) to fix
up the saved html
> code and convert the addresses to .csv for easy
importing
> into Outllok. Wonderful.
>
> If I need to write such a script, I'll post to the
list. Thanks!
>
> --
> Mike van der Velden email
[EMAIL PROTECTED]
> System Administrator cell 604-868-1562
> Kinetic Consulting Group, Ltd.
> Port Moody, BC. Canada
>
> "Like almost everyone, I receive a lot of spam
every day, much of it offering to help me get out of
debt or get rich quick. It's ridiculous."
> -- Bill Gates, the world's richest man.
>
>
> ----- Original Message -----
> From: Kevin Bilbee <[EMAIL PROTECTED]>
> Date: Friday, July 11, 2003 5:17 pm
> Subject: RE: [IMail Forum] Exporting addressbook
from IMail
>
>
>>Or you could grab the address book form the html
code on the web
>>interface. Go to edit Address Book, view source,
do a find for
>>"lstAddr", it is a few lines below, then cut and
paste the html
>>code with the info you want. It will take a little
clean up but
>>if the ISP will mot send the txt files this is
another option.
>>
>>
>>Kevin Bilbee
>>
>>
>>>-----Original Message-----
>>>From: [EMAIL PROTECTED]
>>>[mailto:[EMAIL PROTECTED]
Behalf Of
>>>[EMAIL PROTECTED]
>>>Sent: Friday, July 11, 2003 4:55 PM
>>>To: [EMAIL PROTECTED]
>>>Subject: [IMail Forum] Exporting addressbook
from IMail
>>>
>>>
>>>The company where friend of mine works has their
corporate email
>>>outsourced to a third-party vendor. That vendor
hosts my
>>>friend's company's corporate email using IMail
7.12, and all
>>>access to their email is either through the web
interface, or
>>>though POP using MS Outlook or Outlook Express.
>>>
>>>Several users have entered "quite a few"
contacts into their
>>>IMail address books using the web interface.
Now they would like
>>>to export their address book entries from IMail,
and import them
>>>into MS Outlook. As has been documented several
times in this
>>>forum there is no way to import or export the
address book to or
>>>from IMail. An email request to the tech
support of the IMail
>>>hosting vendor revealed that they too knew of no
way to do this,
>>>but they would continue to look for such a utility.
>>>
>>>I know that each user's addressbook is stored in
a simple text
>>>file, aliases.txt, in each user's home
directory. So, the only
>>>way I can think of to do what they want is by
brute force:
>>>
>>>1. Gather a list of all users that want their
address book exported
>>>2. Send this list of users to the mail hosting
vendor, and ask
>>>them to provide the aliases.txt file for each of
the users listed.
>>>3. For each user, manually import the names and
addresses into
>>>Outlook.
>>>
>>>Steps 1 and 3 are easy, if not repetitive, since
it would only be
>>>for about a dozen users. It would be onerous
for hundreds of users.
>>>
>>>Step 2 seems to rely on the goodwill of the mail
hosting vendor.
>>>I am not sure if they will cooperate and provide
the information.
>>>But, assuming that they do, is this really the
best way to do
>>>the address export and import?
>>>
>>>Do you have any other tricks and or tips?
Thanks in advance.
>>>
>>>--
>>>Mike van der Velden email [EMAIL PROTECTED]
>>>System Administrator cell 604-868-1562
>>>Kinetic Consulting Group, Ltd.
>>>Port Moody, BC. Canada
>>>
>>>"Like almost everyone, I receive a lot of spam
every day, much of
>>>it offering to help me get out of debt or get
rich quick. It's
>>>ridiculous."
>>> -- Bill Gates, the world's
richest man.
To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html
List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
