How do I upload a KBART file into a collection with both English and Chinese or Thai characters in it?

Applies to
Answer

However, the columns below must have data in them for the file to be valid.

They are as follows: 

NOTE:  oclc_entry_id  must be filled in, even if you just label each row with a number eg. 1,2,3,4,5, etc...

If your file has both English and Chinese Characters in the data of the KBART file then do the following:  
  1. Highlight the rows and columns A- Z  that you want to upload including the header row.
  2. The file needs to be saved as a Unicode.txt file.
  3. Select  Collection Actions  > Upload Titles to This Collection and select the following :
    • Scope: Update changes only
    • Upload type: KBART
    • File encoding: UTF-16LE (Unicode Text/Excel)
    • File: Choose file  unicode.txt file 
    • Upload 

You will then need to wait for the process to complete. You can refresh the page after a few minutes if a small file & then check History  > Summary  > to see if your file has uploaded correctly. You will see under the Summary: Total Records Processed xx, Total Records Loaded xx, Total Invalid Records xx  Total Duplicate Records xx

Additional information

Upload your file 

Why is my KBART file deemed invalid when uploading it to a new collection?

KBART Values

Table of ACTION values

Page ID

31179