<HTML>
<FONT COLOR=0000ff><FONT FACE="Arial"><FONT SIZE="2" POINTSIZE="10">Wonderful analysis Matthew. It will occupy a lot of my time figuring it out in the future.<BR>
<BR>
In the meantime. When I had to transfer a CSV file of one of my address books to someone else, <BR>
<BR>
(1) I backed up ADDR.DB and BOOKS.DB (they are in a TOOLS folder in the root directory, not the PMMAIL folder)<BR>
<BR>
(2) deleted all address books except the one I wanted to copy (I closed everything and rebooted, just for safety)<BR>
<BR>
(3) created a CSV file of that one address book<BR>
<BR>
(4) restored the backed up copies of ADDR.DB and BOOKS.DB <BR>
<BR>
That worked okay, although I would not want to do it all the time.<BR>
<BR>
Sure wish PMMAIL was still being supported.<BR>
<BR>
Rip Edmundson<BR>
DeltaHawk Engines, Inc.<BR>
Racine, Wisconsin USA<BR>
<BR>
<FONT COLOR=000000 DEFAULT="COLOR"><FONT FACE="MS Shell Dlg" DEFAULT="FACE"><FONT SIZE="1" POINTSIZE="8" DEFAULT="SIZE"><BR>
<BR>
On Mon, 01 Dec 2008 17:21:15 -0800, Matthew Nicoll wrote:<BR>
<BR>
On Mon, 01 Dec 2008 23:56:52 +0100, Ben Stover wrote:<BR>
<BR>
<BR>
>As I noticed PMMail exports all address book entries into ONE csv file.<BR>
>I have multiple address books but the assignments of email addresses to address books are lost during export.<BR>
>When I re-import them then ALL addresses are put into one (=defualt) address book.<BR>
<BR>
>Is there a trick to keep the email address in seperate address books as in the origin installation?<BR>
<BR>
>Ben<BR>
<BR>
On Mon, 01 Dec 2008 23:56:52 +0100, Ben Stover wrote:<BR>
<BR>
<BR>
>As I noticed PMMail exports all address book entries into ONE csv file.<BR>
>I have multiple address books but the assignments of email addresses to address books are lost during export.<BR>
>When I re-import them then ALL addresses are put into one (=defualt) address book.<BR>
<BR>
>Is there a trick to keep the email address in seperate address books as in the origin installation?<BR>
<BR>
>Ben<BR>
<BR>
<BR>
Hello Ben,<BR>
<BR>
I gave up trying to use the address export function.<BR>
I work with the PMMAIL address book files directly.<BR>
<BR>
The addresses are stored in SOUTHSDE\TOOLS\ADDR.DB.<BR>
<BR>
This file is similar to a CSV file, except that the field separators<BR>
are ASCII 222, and empty (null) fields contain an ASCII 225.<BR>
<BR>
The address book number is in field 24 (there are 26 fields in total).<BR>
<BR>
The address books themselves are defined in BOOKS.DB, <BR>
where the book name is the first field, and the book number is field 4.<BR>
<BR>
You can look at these files in a text editor such as Textpad.<BR>
You could use Textpad to convert an addr.db file into a CSV file.<BR>
(A Tab-Separated Value file would be better, if you have commas in any<BR>
of your address book fields.)<BR>
<BR>
To convert the an addr.db file into a CSV file:<BR>
-Make a copy of your addr.db file, and work on the copy (in case of accidents).<BR>
-Open the file in textpad (other text editors will be similar)<BR>
-Highlight one of the many funny-looking p's , and press Ctrl-C<BR>
-Press Ctrl-H to open the search & replace dialog<BR>
-Insert (Ctrl-V) into the search field<BR>
-put a comma (or a tab) into the replace field.<BR>
-click Replace All.<BR>
<BR>
You could repeat the last 5 steps to change all the accented a's into blanks.<BR>
<BR>
I wrote myself a little Fortran program which I use to convert a list of<BR>
email addresses & names into an addr.db-like file which I can append to<BR>
my addr.db file, thus loading an external list of email addresses into<BR>
my PMMAIL address book.<BR>
<BR>
Let me know if you need help with a particular address job.<BR>
<BR>
<BR>
Matthew Nicoll<BR>
<FONT COLOR=0000ff><U>menicoll@telus.net<FONT COLOR=000000 DEFAULT="COLOR"></U><BR>
phone: 250-337-8491, business & fax: 250-337-8441<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
</HTML>
<HTML>
<LEFT>
<FONT FACE="MS Shell Dlg" COLOR="#000001" SIZE="1" POINTSIZE="8" DEFAULT="ALL">
</HTML>