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.

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.
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.