Why is my KBART file deemed invalid when uploading it to a collection?
Symptom
When uploading a KBART file, you may see an error message that says "Unable to generate upload," or you may see one or more invalid titles.
Applies to
- WorldShare Collection Manager
Answer
This can happen when all details in your file are not correct or exact, as required by Collection Manager.
- All columns must be in the correct order as set out in the KBART template when creating a new KBART file for uploading into a new collection
- The correct Collection Name and the Collection ID should be detailed in your KBART file for the new collection you are creating
- The Collection ID in your file must match that in the collection you created in order for the titles to upload to your collection properly.
- You must add the local collection details, not the global collection details.
- Details in your file must match that in the collection you created, in order for the titles to upload to your collection properly
- The invalid record usually indicates an issue with the data in that record. If the record contains any diacritics or missing information, you would likely see that.
- If the file includes diacritics, you will need to save it as Unicode Text (.txt) instead of Text (Tab delimited) (.txt).
- Use the correct date format for columns containing date information.
- Include a unique numerical value for each title in the oclc_entry_id column. This can be any numerical value. For example, you could enter 1, 2, 3, etc.
- The coverage_depth field is listed as full text for all titles. It should be fulltext, without a space.
- The uploaded KBART must be a .txt file, not an Excel or CSV file.
- If editing the KBART in Excel, be wary of any formatting changes Excel may make to your file. In particular, conversion in Excel may alter date formats, remove leading zeroes from strings, change long integers (such as ISBNs or OCNs) to scientific notation.
- Formatting the cells as "Text" and editing the values that way is helpful in seeing exactly what is actually contained in the file.
If these details are not correct, you will see in the History that zero records were uploaded and Total Invalid Records will match the number you were uploading.
Edit your file for any changes required and then upload the file again. If you are still having issues with your file having invalid records please contact OCLC Support and attach your KBART file for review.
Page ID
13879