Issue with import of CSV for membership pro

HI there, we have Membership pro for Joomla.
Joomla Version: 3.6.5
Membership pro version: 2.8.0
We are having issues with a recent CSV import.
This import worked fine and users were created.
However, we then noticed that we forgot to insert their usernames in the username column.
What I really want to do is re-edit the original CSV and populate the username column and re-import, but as you may know, that will result in duplicate users being created.
So we are happy to edit each user (from the csv import) in the back-end manually to fix this up.

So the first issue is: We cannot add a username to the user. How do we assign the username to the user once its been imported?

Second issue, they are stuck in the "Pending" stage, is there a reason why its not put into "Active" status instead?

I look forward to your reply.
Thanks,
Jason

Honestly, I don't understand how users can be created during the import without username? Users should only be created if both username and password are provided

Could you please give me screenshot of an user account created? What is used for username?

Tuan

It is possible with our setup. We imported without usernames. Here is a screenshot side by side with on the left is the user we imported without a username, and on the right is a normal user with a username.

See screenshot: snag.gy/ljPeMQ.jpg

hi can i get a quick response on this? keen to get this issue sorted. thanks, jason

Hi Jason

I could not say for version 2.8.0 as I don't remember exactly how the export is handled in latest version. However, If you are using latest version (2.9.0) - should work with 2.8.0, too, the easier way to solve this issue is:

1. Go to Membership Pro -> Subscriptions, export subscription records. Please check and make sure the id column is included in the export

2. Edit the data in that file, re-enter username column

3. Import it back again. The system won't create duplicate records as there is id column with id of existing subscription record in the file now

It should work as expected.

For the status of the record, you need to set value for published column to 1 (not 0) and it should be active

Regards,

Tuan

Hi Tuan, when you say:

1. Go to Membership Pro -> Subscriptions, export subscription records. Please check and make sure the id column is included in the export

I assume you mean this, see the following screenshot:

snag.gy/iAkX5D.jpg

And it doesnt allow me to select what columns in the export, just exports the list straight to CSV.

But I exported the file anyways.

I then updated the username column.

However, the status column does not exist in the export file?

The status is published column. Do you see that column exported? 1 mean active, 0 mean Pending
Tuan

hi ok, I done that.

I imported the list and it worked.

It updated the existing users.

Thanks for that.

However, the original import that we did, without the populating the username column. We had the password column filled in.

How do we update the passwords for these users? For the csv export did not have a password column.

We don't have an option to update password. The password will only be used if users don't have account on your site before

So you can add password column manually to the file to import. However, as I said, it will only affect users who doesn't have an account on your site before yet. For existing users, password won't be updated

The reason the password is not exported because in Joomla, the password is encrypted, and there is no way to get original password back (after user account created)

Tuan

We don't have an option to update password. The password will only be used if users don't have account on your site before

So you can add password column manually to the file to import. However, as I said, it will only affect users who doesn't have an account on your site before yet. For existing users, password won't be updated

The reason the password is not exported because in Joomla, the password is encrypted, and there is no way to get original password back (after user account created)

Tuan