What are some data entry guidelines for working with CSV files?
What are some data entry guidelines for working with comma-separated values (CSV) files?
When entering data in CSV files, follow these general guidelines:
- 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.
- 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.
- Do not use an Apple Mac OS computer to create CSV files. CSV files created using an Apple computer use a new line indicator of CR (carriage return) instead of the indicator used on Microsoft Windows (CRLF) or Unix (LF). Ariba solutions do not support CSV files that use the CR new line indicator.
SAP Ariba Buying and Invoicing
SAP Ariba Buying
SAP Ariba Catalog
SAP Ariba Contracts
SAP Ariba Invoice Management
SAP Ariba Services Procurement
SAP Ariba SIPM
SAP Ariba Sourcing
SAP Business Network