# Loading data via .CSV files
> :::note
The information in this guide applies to the **SAP Purchase-to-Pay Connector for AppOne** and **SAP Order-to-Cash Connector for AppOne**.
:::
:::note
The information in this guide applies to the **SAP Purchase-to-Pay Connector for AppOne** and **SAP Order-to-Cash Connector for AppOne**.
:::
## Introduction
When you want to use the SAP Connector with data loaded via `.csv` files you must configure this in the SAP Connector.
To access the `csv` files from the SAP Connector you must upload the files in the **Superadmin Server data** tab.
## Configure the SAP Connector for .csv input
In order to load data correctly you must specify the following settings in the SAP Connector.
SAP Setting
Description
CSV Data path
Data path in the Server Data that points to the place where the .csv files are stored. For example O2C/ if all files can be found in the folder named O2C .
CSV Suffix
By default the input files are read in by looking at the name of the table and possibly a suffix up to 2 digits. This suffix can be changed in the settings if this does not match the names of the input files. Note: this is an optional setting.
CSV File settings
File settings: by default the file settings are a comma as delimiter and double quotes for quatations. This can be changed if needed in the settings. Note: this is an optional setting.
Follow these steps to set the enter the settings for the SAP Connection in the SAP Connector.
| Step | Action |
| --- | --- |
| 1 | Make sure the input type is set to use `.csv` files. See [Loading Data](https://docs.uipath.com/process-mining/standalone/2021.10/user-guide/sap-loading-data#loading-data-in-the-sap-connector-for-appone). |
| 2 | Open the SAP Connector in your development environment. |
| 3 | Go to the **Data** tab and select the **Connector_settings** table. |
| 4 | Edit the expressions in the **CSV Settings** folder to enter the correct values. See the illustration below. |
:::note
The provided settings are used by the `CSV Connection string` expression.
:::
## Requirements for CSV input files
* There must be a separate `.csv` file for each input table.
* The name of the `.csv` file must be the same as the name of the table. For example, for sales orders, there must be a `VBAK.csv` file and a `VBAP.csv` file.
* The name of the columns must be the same as the name of the technical field names in SAP. For example, for sales organization in the `VBAK` table, there must be a VKORG column.
* The delimiter in the `.csv` files must be a comma ','.
* The quotation of the `.csv` files must be double quotes: "" (escape quotes by using a double quote i.e. "").
* Date values in the `.csv` files must be in the format `YYYYMMDD`.
* Time values in the `.csv` files must be in the format `hhmmss`.
### Multifile
You can use multiple `.csv` files for a table. In this case, the name of the file starts with the name of the table of which it contains data followed by a suffix up to 2 digits. For example, the data from the `VBAK` can be stored in multiple `.csv` files with names `VBAK1.csv`, `VBAK2.csv`, etc. So for `VBAK`, the O2C Connector loads the input files `VBAK1.csv` up to `VBAK99.csv`.
## Troubleshooting
### Warning: "Empty column names in…"
The warning message "Empty column names in…" is displayed when the SAP Connector cannot correctly read the columns from the `.csv` files. Make sure to use correct quotes in your `.csv` file, which must be double quotes: "".
### Missing values
When there are values missing, make sure to perform a **Full scan**. Possibly some values return as errors due to wrong formatting in the input. See the illustration below for an example scan output.
