Paul, can this be done to a working system with current users? Where the next account would be the new #s? or would it have to be done before use. Also.. Your example context didnt work for me.. What exaclty do I have to type and how on mySQL.
Thanks ----- Original Message ----- From: "Paul Yasi" <[EMAIL PROTECTED]> To: "For users of CitrusDB discussion" <citrusdb-users@lists.sourceforge.net> Sent: Monday, September 24, 2007 2:24 PM Subject: Re: [Citrusdb-users] (no subject) > You can actually start the customer account numbers at any number you > want, maybe this should be a higher number by default. > > If you want to alter the customer table, you can run this SQL command > to start the number at 10000 for example: > > ALTER TABLE `customer` AUTO_INCREMENT = 10000 > > It may also be a better idea to use something like the customer email > address as their account manager login instead of their account > number... this is something to think about for future versions. > > > > Paul > > On 9/23/07, AJ Becker <[EMAIL PROTECTED]> wrote: >> only reason i wanted to do this was for users to be able to log into >> there >> accounts. Im not fond of low 2-3 digit account numbers to start.. makes >> it >> look like you have no customer base. plus its another number they have to >> remember to get to there account. >> >> ----- Original Message ----- >> From: "Paul Yasi" <[EMAIL PROTECTED]> >> To: "For users of CitrusDB discussion" >> <citrusdb-users@lists.sourceforge.net> >> Sent: Sunday, September 23, 2007 9:41 AM >> Subject: Re: [Citrusdb-users] (no subject) >> >> >> > It is not possible for citrus to change a customer's account number. >> > Keeping the account number the same all the time is very important >> > since it connects the customer with all their information. I would >> > not use a phone number as their customer number, the customer may move >> > and get a new phone number, or in a super rare case that number may be >> > assigned to someone else. >> > >> > You can still search by their phone number, and upon a match it will >> > take you right to that record. >> > >> > Paul >> > >> > On 9/23/07, AJ Becker <[EMAIL PROTECTED]> wrote: >> >> >> >> >> >> is it possible to change a customers "customer number" ? Would like to >> >> use >> >> there phone number as their customer number. >> >> ------------------------------------------------------------------------- >> >> This SF.net email is sponsored by: Microsoft >> >> Defy all challenges. Microsoft(R) Visual Studio 2005. >> >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> >> _______________________________________________ >> >> Citrusdb-users mailing list >> >> Citrusdb-users@lists.sourceforge.net >> >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users >> >> >> >> >> > >> > >> > -- >> > The CitrusDB Project | http://www.citrusdb.org >> > Open Source Customer Care & Billing System >> > >> > ------------------------------------------------------------------------- >> > This SF.net email is sponsored by: Microsoft >> > Defy all challenges. Microsoft(R) Visual Studio 2005. >> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> > _______________________________________________ >> > Citrusdb-users mailing list >> > Citrusdb-users@lists.sourceforge.net >> > https://lists.sourceforge.net/lists/listinfo/citrusdb-users >> >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2005. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> Citrusdb-users mailing list >> Citrusdb-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/citrusdb-users >> > > > -- > The CitrusDB Project | http://www.citrusdb.org > Open Source Customer Care & Billing System > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Citrusdb-users mailing list > Citrusdb-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/citrusdb-users ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users