1. atrus
  2. RO CSVI
  3. Sunday, 08 March 2015
  4.  Subscribe via email
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.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Roland,

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)
  1. more than a month ago
  2. RO CSVI
  3. # 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.
Attachments (1)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Chris,

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
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!