Export Angle to CSV

To export an Angle to CSV

Click Add new datastore.
Select Export Angle to CSV.
Click OK.
The Create datastore window appears.
Enter the Datastore name.
Select the Save To location. This can be a local folder, AWS S3, a network drive, or SharePoint. Depending on your choice, you are presented with different settings:
1. If you select Local Folder or Network Drive Location:
  Output Folder: Your input depends on the output location type.
  Local Folder: Enter the output folder for the export file. Note that the specified location must be a full file path on the Application Server. Make sure to choose a secure location.
  The expected format is <drive letter>:\<output folder>
  UNC Path: Enter the UNC (Universal Naming Convention) path of your network drive.
  The expected format is \\<machine name>\<share name>\<output folder>
  Username: Optionally, enter the account name of the network drive user.
  Password: Optionally, enter the password of the network drive user.
2. If you select AWS S3:
  S3 Region: Enter the S3 region where your S3 bucket is located.
  S3 Bucket: Enter the name of the S3 bucket where the data will be stored.
  Upload Folder: Specify the upload folder name. Your file will be uploaded to this folder. If it does not exist yet, the folder will be created in the specified S3 bucket.
  AWS Access Key: Enter the Access Key ID of the user.
  AWS Secret Key: Enter the Secret Access Key of the user.
3. If you select SharePoint:
  SharePoint Site Url: Enter the home page URL of your SharePoint site.
  The expected format is https://<companyname>.sharepoint.com/sites/<sitename>
  Site Subfolder: Enter the subfolder name. Your file will be uploaded to this subfolder, which is created under the Shared documents folder on SharePoint.
  Username: Enter the username of the SharePoint user. This user should be excluded from multi-factor authentication and should have Add,View, and Edit permissions on the SharePoint site.
  Password: Enter the password of the SharePoint user.
Click Test connection to test if the location is available.
Note
Note that you can choose to leave the following settings empty and instead enter their specifications in Automation tasks when you schedule the execution.
Insert model timestamp - Specify in which column the model timestamp should be inserted. Use '1' to select the first column, '2' to select the second column, and so forth. Select 'None' if no model timestamp column is required.
Header format - Select a format for the column headers:
- No header - When No header is selected, no column header is shown, only raw data.
- Id - When Id is selected, the IDs of the fields will be used as column headers. This option is most useful when the output file is used for further automatic processing, like in databases or CSV.
- Short name - When the Short name is selected, it is shown in the column header.
- Long name - When the Long name is selected, it is shown in the column header.
Set format - Select a format for the set elements:
- Id - When Id is selected, the IDs of the set elements will be exported. This option is most useful when the output is used for further automatic processing, like in databases or CSV.
- Display - When Display is selected, the set elements in the export will be formatted as defined in the Angle Display. This means, 'short', 'short (long)' or 'long' column names will be used. This option is most useful when the output is used for direct interpretation, like in Excel or HTML format.
Max rows to export - When exporting data only the specified number of rows will be exported. If the result contains more rows, remaining rows will be skipped. Use value -1 to export all rows.
File name - Name of the file to write the Angle data to. Macros can be used to include the Angle name, Display name and/or timestamp.
Append result - Append result to output table. When checked, the data will be appended to the existing table or file. If the file/table does not yet exist, it will be created. When unchecked, a new file or table will be created on every run. When the file/table already exists, it will be overwritten. Note that when append is disabled, the table will be recreated for every run. Macros can be used to include the Angle name, Display name and/or timestamp.
Decimal separator - Specify the character to be used as decimal separator.
Number of decimals - Specify the number of decimals.
Time format - Specify how the time is displayed.
Time separator - Specify the character to be used as time separator.
Date format - Specify how the date is displayed.
Date separator - Specify the character to be used as date separator.
Yes/No values - Specify what text should replace a Yes/No value e.g. Y/N, True/False etc.
Enquote - Specify which of the columns should be enquoted: All/Only strings/None.
Enquote headers - Specify if the column headers should be enquoted.
Field separator - Specify the character to be used as field separator.
Line separator - Specify the character to be used as line separator CRLF/CR/LF.
Enquote character - Specify the character to be used as enquote character.
Click Save.

Angles for SAP IT Management Console

Export Angle to CSV

Note

Search results