- Forums
- Community Discussions
- Community Builder
- Export CB users database (xxx_comprofiler) to Excel including email address
Export CB users database (xxx_comprofiler) to Excel including email address
- nettop
- ONLINE
-
Senior Member
- Posts: 65
- Thanks: 3
- Karma: 0
10 years 2 months ago #241736
by nettop
Export CB users database (xxx_comprofiler) to Excel including email address was created by nettop
There are a couple of different ways I can export my CB 1.9.1 database, either via SQL to Excel or via the export function in phpMyAdmin. The problem is that, although I am able to export almost all fields, I am unable to export the email address to an excel file...someone once told me that since it's a system file, I can't get it via export.
My client would like a spreadsheet of all users, including custom fields AND of course, email address. How can I get the email address field to download? Thanks for your help, Tim
My client would like a spreadsheet of all users, including custom fields AND of course, email address. How can I get the email address field to download? Thanks for your help, Tim
Please Log in to join the conversation.
nant
Team Member- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
10 years 2 months ago #241740
by nant
Do a join on comprofiler and users table and export the result.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic Export CB users database (xxx_comprofiler) to Excel including email address
nettop wrote: There are a couple of different ways I can export my CB 1.9.1 database, either via SQL to Excel or via the export function in phpMyAdmin. The problem is that, although I am able to export almost all fields, I am unable to export the email address to an excel file...someone once told me that since it's a system file, I can't get it via export.
My client would like a spreadsheet of all users, including custom fields AND of course, email address. How can I get the email address field to download? Thanks for your help, Tim
Do a join on comprofiler and users table and export the result.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
Moderators: beat, nant, krileon
- Forums
- Community Discussions
- Community Builder
- Export CB users database (xxx_comprofiler) to Excel including email address
Time to create page: 0.455 seconds
-
You are here:
- Home
- Forums
- Community Discussions
- Community Builder
- Export CB users database (xxx_comprofiler) to Excel including email address