Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Pro

 AfterLogic Forum : AfterLogic WebMail Pro
Subject Topic: Populating database with users Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
GuyB
Newbie
Newbie
Avatar

Joined: 02 October 2008
Location: United Kingdom
Online Status: Offline
Posts: 8
Posted: 02 October 2008 at 5:14am | IP Logged Quote GuyB

Hi I'm importing some users from our HR system into the mailbee database.

I can populate the [awm_accounts] table with the user data from my HR database.

To establish working user accounts do I need to do anything with [acal_users_data] table ?
Do I need to populate the [a_users] table?
What about [awm_settings] table ?

Initially I would like to switch off any password encryption so the passwords are stored in plain text. Can this be done? I'd like to simply copy the clear text passwords across with a sql query.

Do you have any stored procs that might help?
Or even a utility to help tranfer the users?

Many thanks - Guy
Back to Top View GuyB's Profile Search for other posts by GuyB
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 02 October 2008 at 5:41am | IP Logged Quote Igor

Quote:
Hi I'm importing some users from our HR system into the mailbee database.

We do not recommend managing WebMail database manually. Instead, you should use MailBee integration API:

Integration API for WebMail Pro PHP

Integration API for WebMail Pro .NET

You may use CreateUser or CreateUserFromAccount method in your case.

Quote:
Initially I would like to switch off any password encryption so the passwords are stored in plain text. Can this be done?

This is not supported yet.

Regards,
Igor
Back to Top View Igor's Profile Search for other posts by Igor
 
GuyB
Newbie
Newbie
Avatar

Joined: 02 October 2008
Location: United Kingdom
Online Status: Offline
Posts: 8
Posted: 02 October 2008 at 8:02am | IP Logged Quote GuyB

Many thanks for your prompt response, i'll have a look at the Integration API you suggest, that does sound very helpful.

Cheers - Guy
Back to Top View GuyB's Profile Search for other posts by GuyB
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide