Support Forums

bowers01 + · 06-10-2010, 08:25 AM

4.10

Hi,
For the upgrade to 4.1 i am making users use their email address as the user name.
This is fine for the new users but i dont want to have to manually change the 50 already registed users. Is there a way to do it in phpmyadmin or would it work out faster to just do it manually?
Regards,
Nick

seymourjames + · 06-10-2010, 01:04 PM

For 50, I would just do it manually and not waste time trying to figure it out or you could open the database in an editor and do a copy and paste and the reload up the database. That may be a little quicker.

Mike-N-Tosh + · 06-10-2010, 07:32 PM

I would export the users table into an excel file format (phpMyAdmin supports this). Then in excel, just copy and paste the email addresses to the usernames save and import back into the table. A 5 to 10 minute job.

bowers01 + · 06-10-2010, 10:59 PM

Thanks guys, shal see how i go.
Regards,
Nick

06-10-2010, 08:25 AM	#1
bowers01 + Genius At Work Join Date: May 2008 Location: Geelong, Victoria, Australia Posts: 1,089 Rep Power: 37	Email -> Username phpMyAdmin 4.10 Hi, For the upgrade to 4.1 i am making users use their email address as the user name. This is fine for the new users but i dont want to have to manually change the 50 already registed users. Is there a way to do it in phpmyadmin or would it work out faster to just do it manually? Regards, Nick __________________ Nick Bowers 68c v4.1.10 Developer Custom Template

06-10-2010, 01:04 PM	#2
seymourjames + All Hands On Deck Join Date: Mar 2008 Posts: 3,527 Rep Power: 89	For 50, I would just do it manually and not waste time trying to figure it out or you could open the database in an editor and do a copy and paste and the reload up the database. That may be a little quicker. __________________ "The fool doth think he is wise, but the wise man knows himself to be a fool.". TemplateCodes.com for 68C

06-10-2010, 07:32 PM	#3
Mike-N-Tosh + Developer & Moderator Join Date: Jan 2007 Location: Pennsylvania, USA Posts: 2,427 Rep Power: 75	I would export the users table into an excel file format (phpMyAdmin supports this). Then in excel, just copy and paste the email addresses to the usernames save and import back into the table. A 5 to 10 minute job. __________________ Mike-N-Tosh IndianaPC.org - A community website (v3.1.10 Developer - heavily modified & used as the CMS) Sandbox [localhost(v3.1.10, v4.0.9, 4.1.10,4.2,5.0)] for development and customization Visit My blog: reviews, tips, tricks, tutorials and my store with Templates, Mods & Docs Web Hosting \| Web Design & Development \| 68 Classifieds Customizations I am not a 68C employee, just a user and try to help out

06-10-2010, 10:59 PM	#4
bowers01 + Genius At Work Join Date: May 2008 Location: Geelong, Victoria, Australia Posts: 1,089 Rep Power: 37	Thanks guys, shal see how i go. Regards, Nick __________________ Nick Bowers 68c v4.1.10 Developer Custom Template

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
V4.1.x Rating module - username-email	damiun	Modules / Plugins / Modifications	0	09-15-2009 01:04 PM
Using phpMyAdmin in cPanel	mark	Technical Support	4	08-28-2009 11:08 AM
no username?	outthere	Technical Support	0	11-08-2007 09:41 PM

Support Forums

Email -> Username phpMyAdmin