Hi Roland,
Doing some tests with VM3 user import; more specifically:
Using CSVI 5.20 to export users from J2.5/VM2.5 and CSVI 6 to import to J3/VM3. In general, the process is smooth, no probs, only noticed issues with 2 fields:
1. Country is not being imported in VM3 (tried country_name,virtuemart_country_id, country_2_code)
2. Is there any way to export passwords from J2.5/VM2.5 and import to J3/VM3? (Because CSVI only exports the encrypted passwords). Or we need to reset them for all users?
Thanks in advance!
Chris
Accepted Answer
Pending Moderation
Hello Chris,
1. You need to use the field country with the full country name.
2. CSVI can only export encrypted passwords, would be kinda bad if we could decrypt them
You need to use the password_crypt field to import an encrypted password.
1. You need to use the field country with the full country name.
2. CSVI can only export encrypted passwords, would be kinda bad if we could decrypt them

Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Roland,
Great, that was it
Tried that also, but the country is not updated. See attached csv file and log
You need to use the password_crypt field to import an encrypted password.
Great, that was it

You need to use the field country with the full country name.
Tried that also, but the country is not updated. See attached csv file and log
Attachments (2)
Accepted Answer
Pending Moderation
Hello Chris,
Found the culprit, if you load the attached patch file you should be able to import the country. One thing I noticed in your file is that there is no address_type_name set. This means you can't identify the addresses you have. I would suggest to give them at least a name.
Found the culprit, if you load the attached patch file you should be able to import the country. One thing I noticed in your file is that there is no address_type_name set. This means you can't identify the addresses you have. I would suggest to give them at least a name.
Attachments (1)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi Roland,
Confirm it is working now
Thanks for the address_type_name tip, that's correct.
Not of a big importance but because i noted; CSVI could try to also fill the following fields when importing users (they are filled automatically when creating new users manually)
Table _virtuemart_vmusers
virtuemart_paymentmethod_id -> 0
virtuemart_shipmentmethod_id -> 0
Table _users -> params {"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":""}
Rgrds,
Chris
Confirm it is working now

Thanks for the address_type_name tip, that's correct.
Not of a big importance but because i noted; CSVI could try to also fill the following fields when importing users (they are filled automatically when creating new users manually)
Table _virtuemart_vmusers
virtuemart_paymentmethod_id -> 0
virtuemart_shipmentmethod_id -> 0
Table _users -> params {"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":""}
Rgrds,
Chris
Accepted Answer
Pending Moderation
Hello Chris,
A good suggestion, I have added these changes for the next release.
A good suggestion, I have added these changes for the next release.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »