Categories
View Replies (7)

Resolved Import User Country / State

  1. amelcher
    amelcher
  2. RO CSVI
  3. Tuesday, 15 November 2016
  4.  Subscribe via email
I usually am pretty good at figuring this stuff out, but I am working on exporting/importing my vm database from an old 1.5 site to my new 3.6.4 site and can't seem to figure out how to successfully import the user country's and states. I am sure this is super simple, but I exported the countries and states in 2 digit names and am trying to import them into the country ans state fields but they are not importing. For instance:

Field: country: I am using CAN (Canada)
Field State: AB (Alberta)

Any help would be greatly appreciated.


Adam
0
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Adam,
The field names of country and state are different in older version of VirtueMart to the new version. All you need to do is map your fields for country and state to new database names which are country_3_code and state_2_code. That should do for your import. Let me know if it helps.
Kind regards,

Tharuna

=========================
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
amelcher
amelcher
Accepted Answer Pending Moderation
I am still having issues with this. Here is my debug log file attached. Thanks for your help on this.


Adam
Attachments (1)
com_csvi.log.144.txt
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Adam,
I see the issue now from debug log. You are using letter code for country and state but CSVI is looking for names for country and state fields. Can you try having your fields like below and see it works?

Field: country: Canada
Field State: Alberta
Kind regards,

Tharuna

=========================
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
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The problem seems to be looking at the latest debug log, that you are not using the fields suggested by Tharuna earlier. The debug log shows you are using the fields country and state instead of the country_3_code and state_2_code.
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. # 4
amelcher
amelcher
Accepted Answer Pending Moderation
That did it! Thanks for your help :)

Adam
  1. more than a month ago
  2. RO CSVI
  3. # 5
amelcher
amelcher
Accepted Answer Pending Moderation
Roland,

I tried using the country_3_code and state_2_code as column headers in previous attempts but the only thing that has worked was changing the abbreviations into full names for both the states and countries. I would of been easier to use the abbreviated codes but I couldn't get them working...

Adam
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Adam,

Without a debug log we can't help you as we can't see what is happening. However if it is all done, then great.
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. # 7
  • Page :
  • 1


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