Data Tool Invalid - Error Reading category/product data

Posted By shulemj Thu 30 Jun 2016
Rated 5 stars based on 1 vote.
Add to Favorites1
Author Message
shulemj
 Posted Thu 30 Jun 2016
Supreme Being

Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)

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
Supreme Being

Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)

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
Supreme Being

Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)

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
Supreme Being

Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)

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
Supreme Being

Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)

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
Supreme Being

Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)

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
Supreme Being

Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)

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
Supreme Being

Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)

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 Marked As Answer
 Posted Thu 30 Jun 2016
Supreme Being

Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)Supreme Being - (117,002 reputation)

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
Supreme Being

Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)Supreme Being - (57,121 reputation)

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.

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top