This sections encompasses the commonly encountered error while creating book ToC using CSV file.
Different values in CSV for Topics
Topic Parts: Level 1 Textbook Unit and subsequent levels data is not found in the framework
Reason
Solution
The value entered in the Mapped Topics column in the CSV file does not map to the framework due to a typo error.
For example: Head, Parts of Body, Human Body, Respiratory System, Organ Systems not found in the framework
1. Remove the values from the Mapped Topics column or enter the correct values in that column
2. Check the spelling of the entries
Note: The values are case sensitive
QR Code Errors
Error
Description
Duplicate QR Codes
CSV file contains more than one entry for Q1X9D5. Correct the duplicate entries and try again
Reason
Solution
You have used the same QR code in two different Textbook Units in the same textbook.
Ensure to use different QR codes for different TOCs in the textbook.
Duplicate Textbook Node
Error
Description
Duplicate Textbook node found
Duplicate Textbook node found. Check and upload again. Row number 5.
Reason
Solution
Check the row (Row number mentioned in the error message +1). The values entered in this line/row is duplicate, check all the lines before this row number for a similar entry
Check rows for any duplicate entry and remove them and re-upload the CSV
Missing QR Codes
Error
Description
Missing QR Codes
Fill in missing QR codes or remove QR code where not required.
Reason
Solution
For ToCs that are highlighted in red, the QR Code Required field is set to Yes. However, the code is not entered.
Either enter a valid QR code for or set the QR Code Required field to No
Required Columns Missing
Mandatory fields in the CSV file are not entered. The mandatory fields are: [Textbook Name, Level 1 Textbook Unit]
Reason
Solution
When you upload the CSV file to update the textbook, either the Textbook Name or the Level 1 of the Textbook Unit column is empty.
Verify the textbook name in the CSV, correct the name and re-upload
Column Mismatch
Error
Description
Textbook Name mismatch current Text Name
Textbook Name given in the file doesn’t match current TextName
Reason
Solution
This happens while uploading the CSV file, to update the textbook. The TEXTBOOK name given while creating the textbook and the Textbook Name given in the CSV are different/not matching
Verify the textbook name in the CSV file, correct the name and re-upload
CSV Update error. Do_xxxx is not valid
Error
Description
CSV Update error
Textbook Name given in the file doesn’t match current TextName
Reason
Solution
In the Linked Content column in the CSV, you have used URL which is not VALID /supported any more.
In the Linked Content column in the CSV, use only the do_id of the content(eg. do_3127766564139909121441)
QR Code Missing
Error
Description
QR Code missing
QR Code missing. Are you sure you want to submit for review without QR code?
Reason
Solution
You have not added a QR code at the TEXTBOOK level (NOT at the TEXTBOOK UNIT level)
Click on Edit Details and add QR Code in the QR Code field
Conflicting values for QR Code Required? and QR Code
Error
Description
Conflicting values in QR code field and value
Conflicting values for QR Code Required? (No) and QR Code (F6T3A4)
Reason
Solution
While uploading the CSV, in the column QR Code Required you have mentioned No, but in QR Code field you have entered a QR Code
If you are setting value in QR Code Required column to No, then do NOT enter any value in the QR Code Column
Invalid textbook Unit
Error
Description
Invalid Text book ID
Invalid textbook unit ID null for textbook.
Reason
Solution
While uploading the CSV, the identifier column in one or more of the rows is empty. While updating (not while CREATING) the textbook by uploading the CSV, the identifier column should NOT BE empty while updating textbook by uploading the CSV.
After downloading the CSV of a textbook, DO NOT REMOVE any value in the identifier column for ToC