- Release notes
- Getting started
- Installation
- Configuration
- Integrations
- Authentication
- Working with Apps and Discovery Accelerators
- AppOne menus and dashboards
- AppOne setup
- TemplateOne 1.0.0 menus and dashboards
- TemplateOne 1.0.0 setup
- TemplateOne menus and fashboards
- TemplateOne 2021.4.0 setup
- Purchase to Pay Discovery Accelerator menus and dashboards
- Purchase to Pay Discovery Accelerator Setup
- Order to Cash Discovery Accelerator menus and dashboards
- Order to Cash Discovery Accelerator Setup
- Basic Connector for AppOne
- SAP Connectors
- Introduction to SAP Connector
- SAP input
- Checking the data in the SAP Connector
- Adding process specific tags to the SAP Connector for AppOne
- Adding process specific Due dates to the SAP Connector for AppOne
- Adding automation estimates to the SAP Connector for AppOne
- Adding attributes to the SAP Connector for AppOne
- Adding activities to the SAP Connector for AppOne
- Adding entities to the SAP Connector for AppOne
- SAP Order to Cash Connector for AppOne
- SAP Purchase to Pay Connector for AppOne
- SAP Connector for Purchase to Pay Discovery Accelerator
- SAP Connector for Order-to-Cash Discovery Accelerator
- Superadmin
- Dashboards and charts
- Tables and table items
- Application integrity
- How to ....
- Working with SQL connectors
- Introduction to SQL connectors
- Setting up a SQL connector
- CData Sync extractions
- Running a SQL connector
- Editing transformations
- Releasing a SQL Connector
- Scheduling data extraction
- Structure of transformations
- Using SQL connectors for released apps
- Generating a cache with scripts
- Setting up a local test environment
- Separate development and production environments
- Useful resources
Loading data
.csv file, but it is also possible to read in other file types.
Your input data file can have different attributes or different attribute names. However, there are some attributes mandatory for using AppOne, which means that the data must be available in your input data file for a correct working of AppOne. The mandatory attributes are:
- Activity
- Case ID
- Event end
It is possible that this data is available otherwise in your input file. For example, Event end can be calculated by combining a date attribute and a time attribute containing event end data.
Optional attributes can be used to get more detailed views in AppOne.
In the tables in the Basic Connector, the attributes are grouped by mandatory and optional attributes.
Follow these steps to upload an input data file to the UiPath Process Mining server.
|
Step |
Action |
|---|---|
|
1 |
Go to the Superadmin Server Data tab. |
|
2 |
Right click in the files panel and select New folder…. |
|
3 |
Enter a name for the folder, for example Connector data, and click on OK. |
|
4 |
Right click on the new folder and select Upload file…. |
|
5 |
Drag the input data file onto the Upload File dialog and click on OK to upload the data file to the server. |
The data file is uploaded to the server.
Follow these steps to load data into the Basic Connector.
|
Step |
Action |
|---|---|
|
1 |
Open the Basic Connector as a developer. Note: Since there is no data associated with this application an error message is displayed. Click on OK to close the message.
|
|
2 |
Go to the Data tab. |
|
3 |
Double click on the
Cases_events_input table.
|
|
4 |
Change the
filename setting to filename=Connector data\)\)[yourdatafile].csv, for example CaseandEvent.csv.
|
|
5 |
Click on OK to load the data. |
.csv data file into the Basic Connector, the attributes that are identified as correctly defined are automatically mapped to the corresponding attribute in the Basic Connector.
However, also new attributes can be detected. These attributes must be mapped to the proper attributes in the Basic Connector to make the data available for use in AppOne.
