Plugin Author
myCred
(@designbymerovingi)
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?
Plugin Author
myCred
(@designbymerovingi)
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?
Plugin Author
myCred
(@designbymerovingi)
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.
Plugin Author
myCred
(@designbymerovingi)
I will try and see if I can replicate this issue and fix it.
Plugin Author
myCred
(@designbymerovingi)
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 🙂
