Why didn't my KBART load? I’m using an Excel file.
Symptom
-
Collection history shows invalid records after attempting to upload KBART.
Applies to
- WorldShare Collection Manager
Resolution
While Excel is useful in many ways, it often changes the integrity of the data.
Some examples of how Excel changes data include:
- rounds/truncates decimal points
- changes extremely long digits integers to scientific notation
- removes leading zeros from digit strings
- changes date formats
- changes encoding on special characters
- changes strings like "01-01" to "1-Jan"
If you choose to use Excel, we recommend that you copy data from a second text editor application into a new text-formatted MS Excel workbook. Please see instructions below.
- Open a new blank workbook in Excel.
- Select all cells in this workbook.
- Format these cells as "text".
- Open your KBART file in a separate Text Editor application (e.g. Notepad++, TextEdit).
- In the text editor, select and copy all the data from your KBART file.
- Paste the data into the blank Excel workbook from step 1.
- Make any needed adjustments to the KBART file (remove titles, change coverage, etc.).
- Important: check that you have a a unique numerical value for the oclc_entry_id field of each title.
- Save file in appropriate encoding level (e.g. UTF-8, UTF-16).
- Upload the KBART file in WorldShare Collection Manager within the Titles accordion.
Additional information
For additional information about KBART files, please see KBART values and formatting.
See Create a knowledgebase collection for more detail on creating or updating a collection with a KBART file
Why is my KBART file deemed invalid when uploading it to a new collection?