How to award points to all users

Hi.

Right now there is no way to do this without some custom code. The myCRED Points editor only works with one user at a time.

I am adding an update to the Points Importer though to allow you to import points balances via CSV files. Right now this is a bit buggy and will replace your users current balances but I plan on adding an option to instead of replacing, adding to the users balance. You could then adjust all users balances via a CSV file where all users are listed with the amount their balance should have.

Sounds good, I will wait for the update that will allow me to add points via CSV file import. Thanks!

Hey

I Just updated mycred to version 1.4.4. Can you kindly mention the steps that I need to take to import balances for all existing users? I mean how can I create a CSV containing all users’ balances and how to import it?

I would suggest you go to myCRED > Settings and under “Management” export your current users balances to see how myCRED does it.

You basically need 3 columns (in the following order):

mycred_user – this column identifies the user. It can either be their ID, email or username.
mycred_amount – the next column holds the amount.
mycred_log – optional third column for a log entry to be added as well for each user.

You can use these CSV files then under Tools > Import > myCRED Balance Import.

The order of the columns is very important! Identification always first, then amount then optional log entry. Only use the log entry column is you want a log entry. Do not use empty columns.

I exported the current user balances and the exported csv correctly showed the points for 147 users (who got points either automatically or I assigned to them manually) out of the total 823 users.

I edited the csv and added all the user ids for the missing users and gave them a default value of 20.

Upon importing the CSV (with either of the options selected in management dropdown) I got this message:

Import complete – A total of 0 balances were successfully imported. 823 was skipped.

I left the delimiter empty. Why are the balances for all users getting skipped?

The delimiter should contain a comma sign. ( no spaces nothing else just a single comma sign )

It still is giving the same message.

The CSV content is like this:

mycred_user,mycred_amount
377,20
1286,20
943,20
4015,20
1325,20
272,20
438,20
3981,20
2150,20
3974,20
593,20
..
..
and so on

In the delimiter, I did enter ‘,’ but same message is coming.

I will try and see if I can replicate this issue and fix it.

Hey!

Good news! I finally figured out what was the issue!
I have updated the current version of 1.4.4 so if you download a fresh copy it should include a fix but I will also push though 1.4.5 later today because I found a few more bugs with regards of Import / Export balances and custom point types.

This means that once you update, old point type exports will not work unless they have the new column mycred_ctype, which defines the point type to be imported.

So the new column order will be:

mycred_user,
mycred_amount,
mycred_ctype,
mycred_log (still optional).

I have also updated the documentation if you need further information on import / export files.

Thanks, worked perfectly ??