Community Discussions and Support
Pmail & Egroupware Addressbook Integration

Depending on what access rights you have to the MySql database you can simply do the following at the DOS Command Prompt:

1. Type Mysql.  You should get a prompt back stating "MySql>"

2: Type in SELECT * FROM databasename.tablename INTO OUTFILE 'C:/TEMP/afilename.TXT;  In Windows, the Databasename is the directory, and Tablename is the name assigned by your software to the address book table. Hopefully something useful.  If you have the right table, you should find the OUTFILE created in C:/TEMP. Otherwise you probably have some access rights issue that your Admin might help with.

3. Type in QUIT

The file created in 2. above can now be opened and edited in Microsoft Excel to get column names matching the names required by Pegasus Mail (see Helpfile) and unwanted columns deleted.

File can then be saved as afilename.CSV  All being well you can then import afilename.CSV into Pegasus Mail

HTH

Martin

 

 

 

<p>Depending on what access rights you have to the MySql database you can simply do the following at the DOS Command Prompt:</p><p>1. Type Mysql.  You should get a prompt back stating "MySql>" </p><p>2: Type in SELECT * FROM databasename.tablename INTO OUTFILE 'C:/TEMP/afilename.TXT;  In Windows, the Databasename is the directory, and Tablename is the name assigned by your software to the address book table. Hopefully something useful.  If you have the right table, you should find the OUTFILE created in C:/TEMP. Otherwise you probably have some access rights issue that your Admin might help with. </p><p>3. Type in QUIT</p><p>The file created in 2. above can now be opened and edited in Microsoft Excel to get column names matching the names required by Pegasus Mail (see Helpfile) and unwanted columns deleted.</p><p>File can then be saved as afilename.CSV  All being well you can then import afilename.CSV into Pegasus Mail</p><p>HTH</p><p>Martin </p><p> </p><p> </p><p> </p>

Hi,

Has anyone managed to get Pmail to use Egroupware's (www.egroupware.org) addressbook?

Egroupware uses a Mysql db to store data.

I believe it is also possible to use a syncml client to access the EG's addressbook.

Regards

Basheer

 

 

<p>Hi,</p><p>Has anyone managed to get Pmail to use Egroupware's (www.egroupware.org) addressbook?</p><p>Egroupware uses a Mysql db to store data.</p><p>I believe it is also possible to use a syncml client to access the EG's addressbook. </p><p>Regards</p><p>Basheer </p><p> </p><p> </p>
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
With selected deselect posts show selected posts
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft