CSV File on Application Server
Run Mode: BACKGROUND AND DIALOG Aggregation: SUPPORTED Iteration: SUPPORTED Duplicate Check: NOT SUPPORTED
Metadata retrieval: SUPPORTED Extraction Strategy: INDUVIDUAL SELECTION AND KEY BASED SELECTION Special Permissions: NONE
This source type was introduced with Solution Manager 7.2. You use it for data stored in comma separated files (CSV).
Parameters
The following data is required:
| Parameters | Description |
|---|---|
| Host name | Specify the name of the application server |
| File Path | Specify the path on the SAP Solution Manager application server under which the CSV file containing the data to be compared is saved. |
| File Name | Specify the name of the CSV file. In no file name but only a path name is supplied, all files in the given path are processed. Moreover, the file name allows wild-cards *, +, $TODAY and $YESTERDAY. In case multiple files are selected, data from all these files is processed together. |
| Created from, Created to | Enter a time from when and a time until when files are considered. The following key words are possible for entering the times:
|
| Header Line | Specify if the CSV files has a header line |
| Field Seperator | Specify the field seperator of the CSV file |
Metadata
Enter any table name and the field names from the header line or any field names in case of no header line. There is no value help for table and field names, but you have to enter them manually.
CSV files supported
The source type supports different kinds of CSV files:
- CSV files with or without header lines: The header line is not compared but determines the order how the fields are mapped.
- CSV files with different field separators: A comma is used as default field separator, but it is possible to enter different field separators.
CSV files in different formats: The source type checks automatically if the file is in UTF-8 format. In UTF-8 format, a possible byte order mark (BOM) is skipped and not included in the comparison. In a non-Unicode system, the file is read without being converted. In a Unicode system, if the file is not in UTF-8 format, the characters of the file are handled in accordance with the non-Unicode code page that would be assigned at read time in a non-Unicode system, in accordance with the entry in the database table TCP0C of the current text entvironment.