blog documentation FAQ followers forum marketplace services youtube

How can I export only the"member's" area of the database ?

The Jamroom Network » Forum » Using Jamroom » Page » How can I export only the"member's" area of the database ?
izhmel
@izhmel
11 years ago
1,354 posts
How can I export only the"member's" area of the database ?, I don't want to export the "artist profile , I intend to re import the artist profiles


--
The Scientist
dubmusic.com
Thanks for any assistance.
updated by @izhmel: 05/20/14 07:08:10AM
paul
@paul
11 years ago
4,335 posts
Do you mean all the members' items (audio, video etc.)?
All datastore items include the profile and user IDs that they belong to. If you exported them, then re-import profiles and they end up with different IDs, their items won't tie correctly.


--
Paul Asher - JR Developer and System Import Specialist
izhmel
@izhmel
11 years ago
1,354 posts
I have a artist and a member quota , I want only the members that sign up to be exported ..... and use the mp3 importer to re import the artist


--
The Scientist
dubmusic.com
Thanks for any assistance.
paul
@paul
11 years ago
4,335 posts
izhmel:
I have a artist and a member quota , I want only the members that sign up to be exported ..... and use the mp3 importer to re import the artist

I think I'm understanding you, but please confirm.
You want to keep 'signed up' members (and their media?) and deleted everything else, then import a load of MP3s and have the importer create artist profiles from their tags?


--
Paul Asher - JR Developer and System Import Specialist
izhmel
@izhmel
11 years ago
1,354 posts
yes


--
The Scientist
dubmusic.com
Thanks for any assistance.
paul
@paul
11 years ago
4,335 posts
Two options -

1. Create a simple custom function to delete all profiles except the members in the signup quota, something like -

    $signup_quota = 2; // Or whatever your signup quota is
    $_s = array(
        "search" => array(
            "_profile_id > 1",
            "profile_quota_id != {$x}" 
        ),
        "exclude_quota_keys" =>true,
        "exclude_user_keys" =>
    );
    $_rt = jrCore_db_search_items('jrProfile',$_s);
    if (isset($_rt['_items']) && is_array($_rt['_items'])) {
        foreach ($_rt['_items'] as $rt) {
            jrProfile_delete_profile($rt['_profile_id']);
        }
    }

Then import your MP3s

2. I've recently merged all profiles and users from one site to another so have a custom module to do it. It ONLY does profiles, users, and their images and not any of their media or items. I could send it to you but bear in mind that while it worked for me, its not supported and its your problem if anything goes wrong. Do backups first.
It would also need a very simple (one line) tweak so that it only moves the 'signed up' profiles and users.
So, if you went this way, you'd need to create a target JR5 site, moved the signed up members over to it, import your MP3s to it, delete the original site, then move the new site into its place.

hth
Pa


--
Paul Asher - JR Developer and System Import Specialist
izhmel
@izhmel
11 years ago
1,354 posts
Thanks please send it . is there away to use this forum to send files or u need an email address ?


--
The Scientist
dubmusic.com
Thanks for any assistance.
updated by @izhmel: 04/18/14 08:01:14AM
paul
@paul
11 years ago
4,335 posts
Email me at paul [at] motagator [dot] net.


--
Paul Asher - JR Developer and System Import Specialist

Tags