Hi all,
          I using Qmail Toaster v 1.0, and horde
toaster as a email client.which was install around 2
year back. Now I have new latest server of Qmail
Toaster version 1.2 , which is install as per the
instuction given on http://www.qmailtoaster.com/
         My query is how do i migrate the address book
of horde to squirrelmail to all domains user.
        I have seen that both Horde and squirrelmail
using csv file,which having differnet format.So user
can't export & import the address book.

       For that i tried to accoumplish this work by
custom shell script.
       But My script is working for only one user at a
time, and i have to do this task per user manually.
The csv format of both the Toaster and squirrelmail  i
mention below. For this i install the plugin of
"abook_import_export" for Squirrelmail.

Squirrelmail csv format :--
=======================

"nickname","name","First Name","Last Name","E-mail
Address","label"
"mahesh","mahesh
wadekar","mahesh","wadekar","[EMAIL PROTECTED]","linux
admin"

Horde Toaster csv format :--
========================
[EMAIL PROTECTED] ~] cat /root/Desktop/turba.csv

"name","email","homeAddress","workAddress","homePhone","workPhone","cellPhone","fax","title","company","notes","lastname"
"jayeshyahoo","[EMAIL PROTECTED]","nerul
seawood","USA","654321","6549878","98657454","985698745","linux
engg","redhat","Engg","jayeshyahoo"


    Since in above format the strings are not same, so
i selected the string which i want and tried to match
it  according to Squirrelmail csv format as followes
:--

awk -F"," '{ print $1 }' /root/Desktop/turba.csv  >>
/root/one
awk -F"," '{ print $1 }' /root/Desktop/turba.csv  >>
/root/twoo
awk -F"," '{ print $1 }' /root/Desktop/turba.csv  >>
/root/three
awk -F"," '{ print $12 }' /root/Desktop/turba.csv  >>
/root/twelve
awk -F"," '{ print $2 }' /root/Desktop/turba.csv  >>
/root/two
awk -F"," '{ print $9 }' /root/Desktop/turba.csv  >>
/root/nine

[EMAIL PROTECTED] ~]# paste -d, one twoo three twelve two 
nine
"nickname","name","First Name","Last Name","E-mail
Address","label"
"jayeshyahoo","jayeshyahoo","jayeshyahoo","jayeshyahoo"
"[EMAIL PROTECTED]","linux engg"


          
           Is there any better way to do this task at
one shot or per domain wise.??
           where is the location of address book file
in both version ?

Thnaks & Regards
Mahesh


---------------------------------------------------------------------
     QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to