# TemplateOne 1.0.0

> **Release date: 29 April 2022**

**Release date: 29 April 2022**

This page provides more information about **TemplateOne 1.0.0**.

## New features

### TemplateOne packages

There are two available **TemplateOne** packages.

* `TemplateOne-EventLog-1.0.0.mvtag`;
* `TemplateOne-Cases-EventLog-1.0.0.mvtag`.

If your data for cases and events is available in one input file, you use **TemplateOne-EventLog-1.0.0.mvtag**. If your data for cases and events is split up into two different input files, you use **TemplateOne-Cases-EventLog-1.0.0.mvtag**. See [Getting Started with TemplateOne](https://docs.uipath.com/process-mining/standalone/2021.10/user-guide/getting-started-with-templateone-1-0-0#getting-started-with-templateone).

### Basic SQL Connector

The **TemplateOne** release includes a *Basic SQL connector*.

:::important
This is the first release of a Process Mining app that includes a SQL connector. This also requires a Microsoft SQL Server database. The license for Microsoft SQL Server is **not** included in the UiPath Process Mining license, and needs to be acquired separately.
:::

To use **TemplateOne** with the *Basic SQL connector*, your input data needs to meet a defined format. Some fields are mandatory for using **TemplateOne**, which means that the data must be available in your input data file for a correct working of **TemplateOne**. The mandatory fields are:

* **activity**
* **case_id**
* **event_end**

Other fields are optional and can be used to get more detailed views in **TemplateOne**.

Additionally, custom case and event fields for both case and event properties are available for **TemplateOne**.

* 30 fields of type *text*;
* 10 fields of type *double*;
* 10 fields of type *datetime*.

See [Input tables of TemplateOne 1.0.0](https://docs.uipath.com/process-mining/standalone/2021.10/user-guide/input-tables-of-templateone-1-0-0#input-tables-of-templateone-100).

### Configuring the database connection

A `TemplateOne.setting.csv`configuration file is now available to set up the database connection string. See [Steps to roll-out TemplateOne 1.0.0](https://docs.uipath.com/process-mining/standalone/2021.10/user-guide/steps-to-roll-out-templateone-1-0-0#steps-to-roll-out-templateone-100): Step 4 Configure the database connection for **TemplateOne**.

## Improvements

* `Actual date` and `Expected date` are now available as end-user filters.
* The `Manual event processing time` end-user filter is replaced with the `Event processing time` end-user filter.
* The `Manual event cost` end-user filter is replaced with the `Event cost` end-user filter.