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/
