KBA KB0393656
FAQ
Symptom
- Error: New Supplier Creation Option not given
- What are some data entry guidelines for working with comma-separated values (CSV) files?
- How do I see leading zeros within my file?
Resolution
When entering data in CSV files, follow these best practices:
- Save the sample CSV files to your local file system.
- Edit the CSV files using a text editor, such as vi, emacs, Microsoft Notepad, or Notepad++.
- Do not use Microsoft Excel to edit CSV files. Excel represents carriage returns and other special characters incorrectly, and the file format does not properly import to your site. It can be used as read-only.
- Do not choose Universal Character Set Transformation Format—8 (UTF-8) encoding when saving CSV files in Notepad. This causes Notepad to save a byte-order mark (BOM) at the beginning of the file, and the file cannot be imported to your site.
- Use the encoding UTF-8 in the first row of the CSV file with no extra commas.
See Also
How do I create a CSV file for manual import?
Keywords
recommended CSV form, data import, data export data, import/export, import tasks, file format, file formatting, encoding special characters, utf, utf8
Personas
Admin, Buyer, Supplier
Components
BNS-ARI-CP-CORE-IEX, BNS-ARI-SS-IEX
Core Procurement > Core Administration > Core Administration Import/Export, Strategic Sourcing > Strategic Sourcing Import/Export