Advertisement:

Author Topic: Howto Download member data?  (Read 494 times)

Offline paulkinzelman

  • Semi-Newbie
  • *
  • Posts: 11
Howto Download member data?
« on: August 20, 2019, 04:08:00 PM »
Sorry for the initial dumb question, but how do I tell which version of SMF I'm running to make sure I'm posting in the correct form? I couldn't find out how to do this in the FAQ. It's the 'belenmesa.smfforfree4.com' one.

As admin, is it possible to download all the member data in one big honkin' CSV file or something?
I didn't see that in the FAQ either or the manual.

TIA!

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,298
Re: Howto Download member data?
« Reply #1 on: August 20, 2019, 04:18:59 PM »
SMF version should be in the copyright in footer, it's been removed.  Depending on how much admin access you're allowed, version is also in Admin -> Support and Credits.  You can export smf_members table from database as csv if you have access (quite sure you don't).  smfforfree is only suitable if you require rudimentary forum features, many admin functions are blocked, and you don't have access to forum files or database.  If you want to run and manage a serious forum, you need to go with paid hosting.  As with anything else, you get what you pay for.


Offline Gary

  • Sorceress's Knight
  • Customizer
  • SMF Super Hero
  • *
  • Posts: 18,128
  • Gender: Male
  • So this is the luck of the draw...
    • Gazmanafc on Facebook
    • garygadsdon on LinkedIn
    • @Gazmanafc on Twitter
    • The Bongo Comics Fan Forum
Re: Howto Download member data?
« Reply #2 on: August 20, 2019, 04:22:34 PM »
Removal of the version number is fine, we don't stop people from doing that and still get support. 

However - OP, since you're using SMF For Free, we can't provide you with support, it's not a service that's owned by Simple Machines. Though like Sir Osis of Liver said, you're bound to have much of your functionality restricted and most certainly you're not going to have access to phpMyAdmin to export the smf_members table as needed.
Gary M. Gadsdon
Do NOT PM me unless I say so

War of the Simpsons
Bongo Comics Fan Forum
Youtube Let's Plays

^ YT is changing monetisation policy, help reach 1000 sub threshold.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,621
    • StoryBB/StoryBB on GitHub
Re: Howto Download member data?
« Reply #3 on: August 20, 2019, 04:51:34 PM »
I'd also ask why - SMF out of the box comes with a way to send everyone a newsletter (which is the usual reason for doing it) but SMF For Free is super limited so...
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,557
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Howto Download member data?
« Reply #4 on: August 20, 2019, 06:12:38 PM »
Yeah, i used to allow people to do newsletters. i still do as a paid addon but had to remove the option to enter user emails. I had spammers/phish people figure that out. Also had similar issue with mybb hosting that I run too
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline paulkinzelman

  • Semi-Newbie
  • *
  • Posts: 11
Re: Howto Download member data?
« Reply #5 on: August 24, 2019, 04:46:11 PM »
Thanks for the ideas!

I couldn't find the version from Admin->Support and Credits, doesn't seem to have the version number there. Seems like it should be easy to find no matter what version I'm running.

What I really want is to search the members by name, and the name doesn't appear in the searchable list. All I can search for is by email.

The forum really isn't active anymore, so I'd like to grab the database.

To what subscription would I need to upgrade to be able to download a CSV of the membership database?

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,557
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Howto Download member data?
« Reply #6 on: August 24, 2019, 05:02:46 PM »
You would have to contact them to order a database export.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,298
Re: Howto Download member data?
« Reply #7 on: August 24, 2019, 05:15:38 PM »
You are using a crippled version of SMF, things are missing.  It's not a matter of upgrading, your host is restricting your access and which features you can use.  IIRC. smfforfree will sell you a db dump, but it will be incomplete, a dozen or so tables will be missing.  Members table should be there, you'll have to ask them.

Offline paulkinzelman

  • Semi-Newbie
  • *
  • Posts: 11
Re: Howto Download member data?
« Reply #8 on: August 24, 2019, 06:00:05 PM »
Sorry, I don't understand the relationship between simplemachines.org and smfforfree4.com
Whom would I contact for a member database extraction?

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,621
    • StoryBB/StoryBB on GitHub
Re: Howto Download member data?
« Reply #9 on: August 24, 2019, 06:06:45 PM »
simplemachines.org makes the software and gives it away to anyone to run on their own servers. simplemachines.org only runs the forum on simplemachines.org.

smfforfree.com is a service that runs the software, albeit modified. To get a database extraction contact smfforfree.com.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.