Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
How do I export member data?
Avatar
audrey boss
Member
Free Members
sp_UserOfflineSmall Offline
Nov 3, 2013 - 5:59 pm

Hi, I want to export the data in the Users>Member Information file. How do i go about doing that? Thanks.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 3, 2013 - 6:36 pm

I would use phpmyadmin which usually comes with most server hosting options. E.g., via cPanel.

This will allow you to export table data in a variety of formats like csv, xml, json etc.,

andy-signature.png
YELLOW
SWORDFISH
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Nov 4, 2013 - 3:36 pm

not sure what you mean by file users>member information???   not really a file, but perhaps db...

do you want users information?  wp or sp or both?

the three db tables you are probably interested in our wp_users, wp_usermeta and wp_sfmembers...  and use phpmyadmin like Andy says...  if you just want wp, there are plugins for that but it wont grab the sp member add on info...

Avatar
audrey boss
Member
Free Members
sp_UserOfflineSmall Offline
Nov 6, 2013 - 3:33 am

thank you both.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 6, 2013 - 4:31 am

Shout if you need advice about which data items are in which table...

andy-signature.png
YELLOW
SWORDFISH
Avatar
audrey boss
Member
Free Members
sp_UserOfflineSmall Offline
Nov 11, 2013 - 6:15 am

Thanks Yellow. Sadly I am not a tecchie so have no idea where to start. I have already posted about this before as I think anyone running a forum (for a commercial purpose) wants/needs to be able to extract data easily in order to analyze participation figures etc...I understand that all this info is buried somewhere in the database but am at a loss as to how to get it out in a format that make sense to me and I can work with. I understand I can do it from myPHPadmin but it's all new to me. Will have to sit down and study...

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Nov 11, 2013 - 10:04 am

Well - the first task -I would recommend - is to identify (a) the data items you want to export and (b) in what format you want the data. The 'how' really has to follow on from that...

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626