|
shulemj
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
Can someone tell me what I'm doing wrong?
Log:
| Data File Update | Info | ======= Data Update Started on 6/29/2016 11:19:15 PM... ======== | | Data File Update | Info | Import Option: ADD IMPORTED DATA TO EXISTING DATA AND IGNORE DUPLICATES | | Data File Update | Info | Processing file... | | Data File Update | Info | Processing data sheet... | | Data File Update | Error | line skipped V_CodeNumber 2 - Error Reading category/product data! Skipping... - Record #1 | | Data File Update | Error | line skipped V_CodeNumber 2 - Error Reading category/product data! Skipping... - Record #2 | | Data File Update | Error | line skipped V_CodeNumber 2 - Error Reading category/product data! Skipping... - Record #3 | | Data File Update | Info | Processed 0 line records | | Data File Update | Error | 3 lines skipped | | Data File Update | Info | ======= Summary ======= | | Data File Update | Info | 0 new categories | | Data File Update | Info | 0 new products | | Data File Update | Info | 0 new versions | | Data File Update | Info | 0 new attributes | | Data File Update | Info | 0 existing categories updated | | Data File Update | Info | 0 existing products updated | | Data File Update | Info | 0 existing versions updated | | Data File Update | Info | 0 attribute values added/updated | | Data File Update | Info | ======= Data Update finished on 6/29/2016 11:19:15 PM. Total Elapsed Time: 0 mins. ====== |
|
|
|
|
|
Tiggywiggler
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Can you please post a copy of the data you are trying to import please? It looks like it is only three lines so it should be easy enough.
If you are trying to import product data, are you sure that the categories that they are attached to actually exist?
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
|
|
|
shulemj
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
Here's the file. All categories exist.
test 1.xls
(2 views,
32.00 KB)
|
|
|
|
|
Tiggywiggler
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
I don't have access to the data tool source code, however, I get the same error and I have seen that if I delete the values in column V_CodeNumber I get a different fault:
line skipped V_CodeNumber 0 - Error Reading V_CodeNumber! Skipping... - Record #1
If I type rubbish data into that column such as 1, 2, 3. Then I get the same fault you are getting again.
I am sure that the fault is with this column, but without being able to read the code I am not sure what is causing it.
Can you tell me how you exported your data in the first place to get this Excel document please?
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
|
|
|
shulemj
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
I manually created the excel file to test the functionally before I create a full feed.
The reason you get the error V_CodeNumber 0 - Error Reading V_CodeNumber! is because it's missing the required SKU.
BTW, I'm running DataTool v2.904, which seems to be the most recent.
|
|
|
|
|
Tiggywiggler
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
I understand missing the required SKU, what I don't understand is that no matter what SKU you put in there it always throws an error. I'm not sure if you have to put an existing SKU in there (wouldn't make sense for importing new products).
Sorry mate, I am not any help to you.
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|
|
|
|
|
shulemj
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
Wait a minute, isn't this a feature to upload new products? Maybe this is the issue. I uploaded products that are not yet in the DB.
|
|
|
|
|
Tiggywiggler
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Okay, I think I have cracked it mate.
You know in the spreadsheet is starts with Cat 5 on the far left and then decreases down through Cat 4, 3, 2 to Cat 1? Well Cat 5 is the top of the tree, not Cat 1 as you would think.
So this means you need to take everything you have under Cat 5 and put it under Cat 1.
Try that and let me know how you get on.
I have added a copy of your file updated (I changed the SKU numbers and removed the category which was 'v' and blanked it too, just because I was messing around and that's where I got to).
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
test 1.xls
(0 views,
32.50 KB)
|
|
|
|
Tiggywiggler
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Okay, I think I have cracked it mate.
You know in the spreadsheet is starts with Cat 5 on the far left and then decreases down through Cat 4, 3, 2 to Cat 1? Well Cat 5 is the top of the tree, not Cat 1 as you would think.
So this means you need to take everything you have under Cat 1 and put it under Cat 5.
Try that and let me know how you get on.
I have added a copy of your file updated (I changed the SKU numbers and removed the category which was 'v' and blanked it too, just because I was messing around and that's where I got to).
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
test 1.xls
(0 views,
32.50 KB)
Thu 30 Jun 2016 by
Tiggywiggler
|
|
|
|
|
shulemj
|
Posted Thu 30 Jun 2016
|
|
Group: Forum Members
Last Active: Thu 11 Jul 2019
Posts: 115,
Visits: 565
|
You're definitely on to something, as moving CAT1 to CAT5 (and CAT2 to CAT4) allowed the upload with no error.
Two fails though:
1. I didn't know that bey leaving the Cat5_Desc1 field blank, it actually deleted whatever description that category had. I wish there's some sort of documentation for the excel format.
2. The products were only added under the Cat5_Name1, but not under Cat4_Name1. It was ignored, with no error in the log.
|
|
|
|