[Plugin: Subscribe2] subscriber category

@jbyungrokim,

Subscribe2 does not use category name, but ids. The name and slug can be changed whereas the id cannot (unless it is deleted).

For each user there is a usermeta field called s2_subscribed that contains a csv string of the subscribe user ids. There is also another field for each category that is s2_cat<id> = id. So for category id 1 there is a field called s2_cat1 and the value is 1.

okay.. then let’s say I have a category called “trial”.

what field values do I need to assign “trial” category to a user “John Doe”??

Also, could you tell me the field name for Role?? I need to put “Administrator” under one field.. but import-users-from-csv plugin doesn’t quite say the field name for “Role.”

Thanks.

@jbyungrokim,

I can’t tell you what the ids of your own categories are – they are in your database.

I have no idea about this other plugin or how it works so I can’t tell you what you need to put for each heading. I guess that Role would be Administrator but I really don’t know as it’s not my plugin you are talking about now. Perhaps you should open another thread about the import plugin to get help on it.

Also, could you tell me the field name for Role?? I need to put “Administrator” under one field.. but import-users-from-csv plugin doesn’t quite say the field name for “Role.”

The field name is ‘role’, and you should put ‘administrator’ in lowercase.

so do I need to specify s2_subscribed when importing new administrator users??

but I have problem. I wouldn’t know user ID until I import them all. so what do I specify for s2_subscribed column??

I had below values:

user_login;user_email;user_pass;first_name;last_name;role;s2_cat1
zombiela;[email protected];111111;John;Kim;administrator;4

s2_cat1 value of 4 belong to the category, “test_category”.

import was successfuly, but test_category option box was not checked.

what should I do in order to assign the category each of these users will subscribe to through this import process??

I have assigned s2_cat1 to the value of the category ID, but it still doesn’t check it.

@jbyungrokim,

If you want these new administrator users to be subscribed to any categories in Subscribe2 then yes, you need to specify a s2_subscribed value when importing.

I would have thought the import plugin takes care of adding the meta values under a newly created user ID.

how would i know s2_subscribed value when the users are just being added??

any idea?

@jbyungrokim,

s2_subscribed is a comma separated list of the subscribed category IDs that you want the user subscribed to.

The s2_cat values should have the same number in the key and value, so:
s2_cat1 = 1
s2_cat2 = 2

s2_subscribed s2_cat4
——————————
4 4

I had above values, and imported a user. But when I check back, not only category ID 4, but all categories were checked in option box.

So I deleted the user manually, but after this manually delete, import plugin is not working anymore.

I guess, I have to delete s2_subscribed and s2_cat4 also, but i don’t know where to go to delete these two manually.

Can you tell me where in MySQL table should I go to delete above two manually.

Also, why all categories are checked in option box when I did as you told me to do??

@jbyungrokim,

Those values are stored in the usermeta table.

I have no idea why all categories are checked, you are playing around directly with the WordPress tables and their values. This can be pretty risky and lead to duplicated keys and values, orphan values and corrupt databases.

Make sure you are backing up and being very careful

i think my process will get done a lot easier if I import data manually to usermeta table directly..

do you think I can add s2_subscribed and s2_cat(id) values directly to usermeta table alone.. and get the job done??

csv based column by column mass import does not work out.. first of all, s2_cat(id) set up require many .. many columns for every single category i have..

so it will be a lot easier if i import manually and directly to wordpress usermeta table..

but my only concern is.. is there any other table involved beside usermeta table in assigning categories each user subscribe to??

I just added a post with an image.

eMail got delivered, but the email didn’t show the image on the original post.

How can I make the image show up in the email got delivered???

how do i update the code so that new subscribers added subscribe to all categories??