Import problem with iproducer, contributor error

Question

Level 1

5 points

Import problem with iproducer, contributor error

I am having a great deal of problems using itunes iproducers file import system.

I downloaded the example file, and have done my best to descipher exactly how to fill in the fields correctly (there is any decent documentations that I was able to find in regards to this).

I am currently getting and error that "Row 2 has a different number of contributor roles (1) than contribtuors (2)

I have tried to fix it but darned if I can figure it out, I have tried: John Smith in the name, with Author as role, and it throws the error. HELP!

I also have a question about the field marked "price tier" what does that refer to? I have it set as 1 since I do not know what else to put there.

I could manually enter the data yes, but I am attempting to upload 300+ ebooks, so getting the file import to work would be extremely helpful!

Thank you,

Amy

iBook, Mac OS X (10.6.1), estarbooks.com

Posted on Aug 13, 2011 1:46 AM

Reply

Answer 1

Best reply

Joe-AUK

Level 1

10 points

Sep 1, 2011 5:42 AM in response to estarbooks

I am having the exact same problem. I have followed the guideline as closely as I can.

[EDIT]

I've fixed this!

iTP is actually spitting out the wrong error message. I tied to parse the example spreadsheet, and it gave the error that the ISBN13 column had a wrong identifier ("97313E+12" for example), which is how Excel displays ISBNs. Select the column with your ISBNs in, and format the cells to "Number, 0 decimal places".

Parses like a charm.

Reply

Answer 2

estarbooks Author

Level 1

5 points

Sep 1, 2011 6:57 AM in response to Joe-AUK

Thank you! I could not figure it out and you were the first one to actually answer!

The ISBN problem was fixed, qhich then caused the author error to go away. Then I ran into a minor snag that the "Product Price" needed to be changed to "Product List Price". And it throws a Pricing error if there is a problem withthe date for some reason. Once I fixed the date to 2011 from 2015 it worked.

After all that it finally works!

Though you still have to manually add in the epub file and cover, but it is still faster than entering it by hand!

Thanks!

Amy

Reply

Answer 3

bnoof2

Level 1

0 points

Jun 5, 2012 1:26 PM in response to estarbooks

Ah! I have wasted so much time trying to get past that error. Why isn't there a list somewhere of standard errors and an explanation of how to fix them? Now I'm getting an error that says "Column 'ISBN' not found in row 2."

Reply

Answer 4

estarbooks Author

Level 1

5 points

Jun 5, 2012 2:23 PM in response to bnoof2

Did you make sure that it is displaying the ISBN as a full number? By going into the "Format Cells" option and selecting number and getting rid of any decimals.

Amy

Reply

Answer 5

bnoof2

Level 1

0 points

Jun 5, 2012 2:29 PM in response to estarbooks

Yes. Thanks for the suggestion. Turns out that the template I downloaded from iTunes Connect had labeled the column "ISBN-13" and I had to rename it "ISBN." The problem was with Apple's template, not my content.

Reply