Thanks AJ & Paul, This was a question of mine that I had on the side.
Concerning the customer authentication for the online portion I would personally stay away from using e-mail address for authentication purposes due some accounts not having them on file until later. The site I am working on now is sending out paper invoicest to customers who's only information we have on hand (initially) is full name and address. The only true constants for accounts are most likely going to be the there name and the arbitrary account number CitrusDB create's for them, and I'd prefer to keep it that manner for the login. I guess what would be the nicest option is for the administrator to be able to configure what is used for the login on the online customer protion of the site. But I have no idea what would go into setting up a function like this. Personally login via account number is the best in my eyes. Quoting Paul Yasi <[EMAIL PROTECTED]>: > 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
