Integrate Mavis DB With Smart Views

1. Feature Overview

Admins can create Mavis Smart View tabs to display data stored in Mavis DB.
They can also configure permissions, to enable users to add, update and delete data from the Mavis Smart Views tabs.

For example, you can empower users to manage data on your inventories, properties, courses, etc., or, you can display any data that helps your users in their everyday operations.

If you’re new to the Smart Views feature, see LeadSquared Smart Views, and Smart Views for Admins.

2. Example Use Cases

• Grants users role-based access to add, update or delete data from Mavis DB tables.
• Give inventory teams CRUD access to manage inventory tables in Mavis DB.
• Sales managers and sales users can view/update inventory while making sales – e.g., available/blocked/booked properties within a date range, availability of doctors/rooms, inventory of courses, books, etc.

3. Prerequisites

• You must be an administrator user.
• You must have Mavis DB enabled on your account. For more details, contact your Account Manager or support@leadsquared.com.

4. Create a Mavis Smart View Tab

1. Navigate to My Profile>Settings>Leads>Views>Smart Views.
2. Click .

1. Enter a name for the Smart View, then click Create Tabs.
2. Choose Type as Mavis and enter a Name and Description.
3. Click the Select Condition link.
   1. Select the database.
   2. Select the table name within the database.
   3. Add filter conditions to filter the data from the table. For example, you can filter the ‘State’ field to display results within a particular state:
      • Column Name – StateName| Operator – Equals | Value – Karnataka
      • For more information on filter conditions, see filter conditions.
   4. Click Add to add more filter conditions. You can add up to 20 filter conditions by default. To increase this limit, reach out to your account manager or support@leadsquared.com.
      • For multiple filter conditions, select whether you want All Criteria (and) or Any Criteria (or) to apply.
   5. Click Save.
4. Verify the filter conditions, then click Save.

To create more tabs:

1. Click the icon.
2. Click Add New Tab.

5. Configure Tab Permissions

Admins can configure the following permissions on the Mavis Smart View tab –

• Read Data (enabled by default)
• Add Row
• Update Row(s)
  • Single Row Update
  • Bulk Update
• Delete Rows
• Export Data
• Import via CSV
  • Create New Record(s)
  • Update record(s)
  • Upsert record(s)

To configure permissions –

1. Click the Configure link.
2. On the Configure Actions Menu pop-up, enable the slider alongside the permissions you want to grant.
3. Click Save.

6. Assign Smart Views to Teams

Now that the Mavis Smart View tabs are created, assign them to your teams – Assign a Smart Views tab to a team.

7. Using Mavis Smart Views Tabs

Users logging in (based on the team) will now be able to work on the Mavis Smart Views tabs, based on the team assignment configured in the previous step.

7.1 Column Customization

To configure the columns you want to see on the grid:

1. Under Actions, click Select Columns.
2. Select the columns you want to view.
3. Click Show Selected.

7.2 Manage Filters

Users can add further filters to the existing filter conditions set by the admin:

1. Click the icon.
2. Add the new filter conditions.
3. Click Save.

The options to Add Row, Update Row, Delete Rows, Import Rows and Export Data will appear under the Actions menu, based on the permissions configured for the tab by the admin.

7.3 Add Row

1. Hover your cursor over the Actions menu.
2. Click Add Row.
3. Enter the row details, then click Add.

7.4 Update Single Row

To update a single row in the table –

1. Select the row you want to update.
2. Hover your cursor over the Actions menu.
3. Click Update Row.
4. Enter the row details, then click Update.

7.5 Update Multiple Rows

To update multiple rows in the table –

1. Select the rows you want to update.
   • To update all the rows present on the current view, on the column header, click .
2. Hover your cursor over the Actions menu, and click Bulk Update.
3. On the Bulk Update pop-up, on the Select Column & Enter Value tab, from the Column to be updated dropdown, select the column you want to update.
   • If you’ve selected all the rows on the current page to be updated, alongside Bulk update with new value for the…, you’ll have the option to update rows only on the current page, or update all the rows across the entire table.
   • The Bulk update with new value for the selected … row(s) will show up if you’ve manually selected only a few rows to be updated on the current page.
4. In the New Value box, enter the new value of the selected column.
5. Once you’re done, click Next.
6. On the Confirmation tab, verify if all the details are correct, and click Update. You’ll get a confirmation message stating that the update is successful.

If you’ve applied Filters, you’ll only be able to update rows selected based on the filters applied.

7.6 Delete Rows

1. Select the rows you want to delete.
2. Hover your cursor over the Actions menu.
3. Click Delete Rows.
4. On the Delete Rows pop-up, click Delete.

7.7 Export Data

1. Hover your cursor over the Actions menu.
2. On the Export Data pop-up, if you want to –
   • Export only specific columns, click Export Selected columns, and select the columns you want to export.
   • Export all columns, click Export All columns.
3. Click Export.

7.8 Import Rows

To import data into your Mavis tab in Smart Views –

1. First, you’ll have to upload the CSV source file.
2. Map the columns in the CSV file to the corresponding column within the table.
3. Then, validate the CSV file. The validations that might show up are Validation Success and Validation Failed.
4. Once the status is Validation Success or Validation Failed (Partially), click the Import button.

7.8.1 Create New Record(s)

To import and create new records in your Mavis table –

Source

1. Navigate to the Smart Views screen, and on the right of your screen, hover your cursor over the Actions menu, and click Import Rows.
2. On the Import via CSV screen, Select Import Behaviour –
   • Create new record(s) only – Data present in the CSV file will get created as new records in the table. Existing rows in the Mavis table will not get updated.
3. Then, click Download Sample. The sample file is generated dynamically and it contains the schema names of all the columns created in the Table Schema.
4. On the sample CSV file, enter relevant data in the correct data type under each column, and save the file.
   • If you are not using the sample CSV file, and are instead creating new a CSV file/uploading an existing CSV file to update the table, specify the header names (column names) in the first row, and add data across the subsequent rows.
5. Click Upload, and add the relevant CSV file.
   • Alternatively, you can drag-and-drop the CSV file.
6. Once you’re done, click Next.

Column Mapping

Once you’ve imported the CSV file, you will have to map it against the corresponding column within the table.

• If the column names in the CSV file are the same as the column names in the table column, then the columns are automatically mapped.
• Else, from the CSV Column Name dropdowns, you must map the columns to the correct Column Name in Mavis.
• For Mandatory Fields, map the Column Name in Mavis on the left to the corresponding CSV Column Name on the right.
  • All columns that are marked Unique or Non-Nullable are considered mandatory columns.
  • Once you’re done, click Save.
  • If there are no mandatory columns in the table, the Mandatory Fields option will be disabled, and you’ll not be able to expand or view it.
• Once you’ve mapped and saved the mandatory columns, for Non-Mandatory Fields, map the remaining non-mandatory CSV Column Name on the left to the corresponding Column Name in Mavis on the right. Note that the order of column mapping is reversed in this step (the CSV Column Name is on the left).
  • All fields marked Is Nullable are considered as non-mandatory columns.
  • The mandatory Mavis columns mapped in the previous step will not show up in the list of options in this step.
  • This step is optional. If you choose to skip it, click Save and continue with the other steps.
  • If there are no non-mandatory columns in the table, the Non-Mandatory Fields option will be disabled, and you’ll not be able to expand or view it.
  • If all the columns under CSV Column Name are mapped, the Non-Mandatory Fields option will be disabled, and you’ll not be able to expand or view it.
• If DateTime columns are present in the Table Schema –
  • From the Date/Time format in CSV section, select the same Date/Time/DateTime formats given in CSV File.
  • If table schema contains either of Date/DateTime/Time columns, or its combinations, but not all three columns, then in Date/Time format in CSV section, you can choose only those available column formats. Other formats will be disabled.
  • Below are the default formats –
    • Date – yyyy-MM-dd
    • DateTime – yyyy-MM-dd HH:mm:ss
    • Time – HH:mm:ss
• If there are no Date/Time/DateTime fields in the table schema, then this section will remain greyed out and inaccessible.
• Once you’re done, click Next.

Validation

The data in the CSV file will be validated on this screen.

If Validation Success –

If all the row(s) have been successfully validated, you’ll get the Validation Success message. You can choose to continue the CSV file import process by clicking Next.

If Validation Failed –

If one or all the rows have not been successfully validated, you’ll get the Validation Failed message. There are two types of Validation Failed messages you might receive –

• Partially Failed – This means the validation for only a few rows in the CSV file failed, while the remaining rows’ validation was successful.

• Completely Failed – This means the validation for all the rows in the CSV file failed.

To rectify a failed validation –

1. You’ll get the following details about the rows that were validated –
   • Total Rows
   • Success Rows
   • Failed Rows
2. Here, you can view the rows that failed during validation.
   • If you want to ignore the Failed Rows error and proceed with only uploading the Success Rows in the file import process, you can do so by clicking Next.
3. To download the failure report, click Failure Report.
4. In the Failure Report file, you’ll see two new system-generated columns have been added – “__LSQValidationMessage” and “__LSQValidationStatus”
5. The “__LSQValidationMessage” column will state the reason as to why the validation was unsuccessful for that particular row.
6. The “__LSQValidationStatus” will display the validation status (“Success” or “Failed”) for that particular row.
7. Once you’ve rectified the error in the original CSV file, save the file, and re-upload it from the Source screen.
8. If all the rows have been successfully validated, you’ll get the Validation Success message. You can choose to continue the CSV file import process by clicking Next.

Summary

All CSV files that are imported are usually queued within our servers. It may take a few minutes for these files to be successfully imported.

In the Summary screen, you’ll get a message stating, “You have successfully imported the file.” This means your file is currently queued for import, and it will be completed within a few minutes. Once the import is successful, the user who performed the import action will receive an email confirmation about the same.

You can bulk update multiple rows across multiple columns by uploading a CSV file.

To bulk update rows through CSV –

1. Navigate to the Smart Views screen, and on the right of your screen, hover your cursor over the Actions menu, and click Import Rows.
2. On the Import via CSV screen, Select Import Behaviour –
   • Update existing row(s) only – Based on the Search Key defined, existing rows found in the CSV file will get updated in the corresponding table rows. For rows that don’t exist in both the CSV file as well as the table, no new records will be created in the table.
3. Click Next to proceed to the column mapping tab.
4. Map the fields in your CSV file to the fields in your Mavis table, then click Save.
5. Select the unique column to define as the search key and click Save.
6. Click Next to proceed to the validation tab. If there’s at least one successfully validated row, you can click next to complete the import. Otherwise, you can fix the errors and re-upload the file. For more details, see Import Rows -Validation.
7. In the Summary screen, you’ll get a message stating, “You have successfully imported the file.” This means your file is currently queued for import, and it will be completed within a few minutes. Once the import is successful, the user who performed the import action will receive an email confirmation about the same.

This option allows you to update existing rows as well as add new rows to the table through the same CSV file upload action.

Note:

• The Upsert Record(s) option will be visible only after you enable the Import via CSV – Upsert Record(s) setting.
• The CSV file must have at least two columns – one unique column must be set as the Search Key and the other containing the data to be updated.
  • Only 1 unique column can be defined as the Search Key. Column mapping is mandatory for this column.
• To use the system field mv_RowId as the Search Key, it must be present in the uploaded CSV file (mv_RowId can be obtained when exporting data).
• If your table doesn’t contain a unique column, then the mv_RowId is used to identify if an existing row needs to be updated, or if a new record has to be created in the table.
• The mv_RowId column name is case-sensitive. Ensure the syntax and case is correct.
• Column mapping is not required for the mv_RowId.
• Column mapping is required only for the columns where you want to import data.

To upsert rows through the CSV –

1. Navigate to the Smart Views screen, and on the right of your screen, hover your cursor over the Actions menu, and click Import Rows.
2. On the Import via CSV screen, Select Import Behaviour –
   • Upsert (Create new record(s) & update existing) – Based on the Search Key defined, existing rows found in the CSV file will get updated in the corresponding table rows. If the Search Key is empty or if it’s not found, new records will get created in the table.
3. Click Next to proceed to the column mapping tab.
4. Map the fields in your CSV file to the fields in your Mavis table, then click Save.
5. Select the unique column to define as the search key and click Save.
6. Click Next to proceed to the validation tab. If there’s at least one successfully validated row, you can click next to complete the import. Otherwise, you can fix the errors and re-upload the file. For more details, see Import Rows -Validation.
7. In the Summary screen, you’ll get a message stating, “You have successfully imported the file.” This means your file is currently queued for import, and it will be completed within a few minutes. Once the import is successful, the user who performed the import action will receive an email confirmation about the same.

Any Questions?

Did you find this article helpful? Please let us know any feedback you may have in the comments section below. We’d love to hear from you and help you out!