Overview:
The user receives an error when attempting to create Documents, Versions, and Roles using the Vault Loader. The input file is generated using the Vault Loader as part of an Extract job.
Root Cause:
The input file (in .csv format) is loaded into Microsoft Excel. The formatting of the input file is altered when it is opened in Excel.
Solution:
The solution is to do one of the following:
- Open the extracted input file in Microsoft Excel, make any necessary changes, and save it as a CSV (Comma delimited) (.csv) file. This file must be encoded in the UTF-8 format.
- Open the extracted input file in Notepad or Notepad++, make any necessary changes, and save the file so that the formatting is not altered.
Related Documentation:
- Vault Loader Documentation: Vault Loader: Create & Update Documents
- Vault API Documentation: Bulk Input Files