Export Users Database for Excel

jerett - February 6, 2008 - 21:33

Is there currently a module setup where you can export the user list into a format that will work with Excel? I am have been search and can't seem to find what I need. Is it possible this function is included and I just didn't find it?

Thank you in advance for your help on this.

PS: If you list a module, could you explain the process on exporting with the module if it is complicated? Thanks!

If you have access to

hagrin - February 6, 2008 - 22:29

If you have access to phpmyadmin on your webhost, you can simply choose the "Export" option and select the user tables you need and export to the desired file type.

_______________________________________________________________________________
http://www.hagrin.com - Just my little slice of the Interweb

True. It is just the person

jerett - February 6, 2008 - 22:34

True. It is just the person this is for is not savvy enough to do that. Maybe I can have a simple code done up where you can login and perform the dump etc. None-the-less - is there not a mod out there?

Have a look at the Database Administration module

ghankstef - February 6, 2008 - 23:11

http://drupal.org/handbook/modules/dba
http://drupal.org/project/dba

not sure if it does csv export but it might

@ghankstef - Wow, didn't

hagrin - February 8, 2008 - 17:22

@ghankstef -

Wow, didn't know about this module - this is perfect for my clients that don't know how mySQL that well.

_______________________________________________________________________________
http://www.hagrin.com - Just my little slice of the Interweb

"there's a module for that!"

luco - August 13, 2009 - 15:35

actually, there's two - one for each task.

exporting:
http://drupal.org/project/profile_csv

impoting:
http://drupal.org/project/user_import

haven't tested them thoroughly yet, though.

_________________________

EN: visit my portfolio at www.luco.net.br/en
PT-BR: visite meu portfolio em www.luco.com.br

how to import a user list from Drupal 5 website to a Drupal 6 we

wwwoliondorcom - December 2, 2009 - 19:07

how to import a user list from Drupal 5 website to a Drupal 6 website

Hello,

Do you know how to import a user list from Drupal 5 website to a Drupal 6 website ?

Thanks

 
 

Drupal is a registered trademark of Dries Buytaert.