Re: [Emerald] changing clients to different MBR

Kurt Schafer ( (no email) )
Mon, 26 Aug 2002 14:39:14 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C24D0E.59AA2940
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Have you tried running a query on the SubAccounts table to change the =
CustomerID of the subaccount to the CustomerID of the new MBR ?

=3D K

----- Original Message -----=20
From: Marti Preuss=20
To: emerald@iea-software.com=20
Sent: Monday, August 26, 2002 1:29 PM
Subject: RE: [Emerald] changing clients to different MBR

If you need to keep the history, simply remove the username and =
password from the current MBR, then add it to the new MBR.

mp
-----Original Message-----
From: Robin Galyan [mailto:robin@nxs.net]
Sent: Monday, August 26, 2002 11:26 AM
To: emerald@iea-software.com
Subject: [Emerald] changing clients to different MBR

OK, so how do we move a customer to a different MBR?

Ie: He leaves company A and goes to Company B, wants to keep his =
dialup etc... =20

Do we have to delete him from one then add him to the other? =
Looses history.. or what?

------=_NextPart_000_0008_01C24D0E.59AA2940
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

Have you tried running a query on the =SubAccounts=20table to change the CustomerID of the subaccount to the CustomerID of =the new=20MBR ?
 
=3D K
 
----- Original Message -----
From:=20 Marti =Preuss=20
To: emerald@iea-software.com =
Sent: Monday, August 26, 2002 =1:29=20 PM
Subject: RE: [Emerald] changing =clients=20 to different MBR

If=20 you need to keep the history, simply remove the username and password =from the=20 current MBR, then add it to the new MBR.
 
mp
-----Original Message-----
From: Robin Galyan=20 [mailto:robin@nxs.net]
Sent: Monday, August 26, 2002 11:26 = AM
To: emerald@iea-software.com
=Subject:=20 [Emerald] changing clients to different MBR

OK, so =how do we move a=20 customer to a different MBR?
 
Ie: He leaves company A and goes to =Company B,=20 wants to keep his dialup etc...  
 
Do we have to delete him from one =then add him=20 to the other?   Looses history.. or what?
 
------=_NextPart_000_0008_01C24D0E.59AA2940--