Data Upload

Supported Data Sources

Resseract Lite features a pluggable architecture, allowing easy integration of various data sources for data retrieval. These sources can be categorized as either static or dynamic.

Static data sources are those whose data remains constant. In such cases, the data is fetched and stored within the database. Examples of static data sources include CSV files, Excel files, etc.

Dynamic data sources, on the other hand, are characterized by data that changes over time. Resseract Lite fetches data from these sources at runtime. Examples of dynamic data sources encompass SQL databases, RESTful web services, etc.

As of the current date, Resseract Lite supports the following data sources. However, we are actively working on incorporating additional data sources. If you have a specific data source in mind that you'd like us to support, please submit a ticket [here](https://github.com/abistarun/resseract-lite/issues).

CSV (Comma Seperated Values) Files

Resseract supports ability to upload CSV files. Process to upload these files are given below.

1. Have a CSV file ready or download a sample from here
2. In the menu on the left, select Upload Data under Data
3. Under source select CSV and click Next
4. Upload the downloaded file and click Next
5. Type a data key which will a identifier for the data
6. Resseract Lite will automatically populate data types for columns within the data. You can review them and change as per your need and click Next
7. Data should be uploaded successfully

Adding Custom Columns

Resseract Lite supports the ability to add custom columns using expressions. For details of the expression, please refer to the Expression Language section.

For example, assume your data has a column called Marks for students, and you need to add a column called Status with values Pass or Fail. To do this, you can add a column called Status with an expression like if([Marks] > 35, "Pass", "Fail").

Another example is suppose your data includes marks for different subjects of students, such as Maths Marks and Science Marks, and you want to add a column called Total Marks. You can achieve this by adding a column named Total Marks with the expression [Maths Marks] + [Science Marks].

Steps:

1. In the menu on the left, select Manage Data under Data
2. Against the mentioned data key, click on Add Column
3. Type the column name and expression as required and click on Add
4. This column can now be used in different widgets / charts

Data Summary

You can view data summary of the data uploaded to understand the data better.

Steps:

1. In the menu on the left, select Manage Data under Data
2. Against the mentioned Data Key, click on Data Summary
3. View Data Summary and Column Statistics

Delete Data

To delete data uploaded, please follow the following steps.

Steps:

1. In the menu on the left, select Manage Data under Data
2. Against the mentioned Data Key, click on Delete
3. Click on Confirm. You data will now be deleted