1. soura123
  2. RO CSVI
  3. Friday, 24 April 2015
  4.  Subscribe via email
i m tryinf from csvi i have ine cell virtuemart_oder_id and a cell with the delivery date and i m trying to import to update all delivery dates to each order but when i import a get a failure message Cannot process user, no user ID found
i use the order import temp...
and on my import temp i have only virtuemart_order_id and delivery date i cand understand the error... im doind sth wrong?
Accepted Answer Pending Moderation
The order import requires a number of fields to make sure the order is complete. In your case you are not really doing an order import but rather an order update. That is not possible with the order import.

You can use the custom table import. You can read in the Custom tables import and export tutorial how to set it up.

You will be OK because you use the primary key virtuemart_order_id.
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
ok great feature (i didnt know)
but i enable the virtuemart_orders table i update the available fields i go to csvi custom import i create my temp
i proccess it i get message of success and Success Custom field added
but in the order and db delivery date it is not imported ..
any ideas?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
No ideas but post the debug log and let's see what is in there.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
this is the log
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,

The log shows me empty inserts, can you also post the file you imported?
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
that is strange... this is the file
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
well i rename the columns of csvi from order_id to virtuemart_order_id and Tacking to delivery_date (as thr columns on the db table) and it worked....
answer is always in a mysterious path...
anyway...i have 15 lines on the csv when i go to vm order i see that it update every order of the csv file... but in the view debug log i see always that it procesed 5 lines..
is this normal?
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
I am a little confused, you said you want to import the delivery date but in reality the file has a tracking code. You must use the exact table names in your CSV file if you are using the file as configuration. If you use the template fields, the field names in the CSV file are not used.

So that explains why it wouldn't work.

Yes, it is normal to see only 5 lines, you can set the number of debug lines in the settings of CSVI.
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
ok great...
yes i user the delivery_date to import tracking code for my records... ok this thread is solved
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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