1. Home
  2. DotActiv - Data
  3. How To Update The Database

How To Update The Database

This article will provide you with a step-by-step process on how you can update the database.

Applicable Products: DotActiv Pro, DotActiv Enterprise

If there is information in the display structure that has not been populated or information you would like to edit, you can do this by updating the database.

There are two ways to update the database.

You can either update on DotActiv directly or by update it by importing a CSV to the database.

Updating through DotActiv

Open DotActiv and navigate to the ‘Data’ tab. Click on SQL in the ‘Show’ section and choose the Environment that you would like to update: Markets or Products. 

Next, select the relevant view, right-click on it and click on ‘View Data/Images’.

This will open a data view grid.

Here, you can now use the drop-down section in the relevant column to filter to the product detail you would like to update.

Updating Through DotActiv - Data view grid

Type in the changes you want to make. Once a change has been made it will be highlighted in red.

In the ‘Data’ tab under the ‘Tools’ section, click on ‘Update Database’.

This will open an update database window, showing you all pending changes.

Click on ‘Update Database’ once you have confirmed that all pending changes are correct.

Updating Through DotActiv - Confirm Pending Charges


Please note that before importing any data to the database, you ensure it is correct. Adding any information to the database that was not previously there can compromise the integrity of the data.

Updating Using A CSV

It is important to be sure that the CSV you want to use to update the database is clean. Make sure there are no duplicates, no missing information in the columns and that all spelling is correct.

How To Update Using A CSV

After opening DotActiv, click through to the ‘Data’ tab, then on ‘Select’ in the ‘Data Transfer’ section. Once there, click on ‘CSV to Database’.

Doing so will open the ‘Import’ window. Click on ‘Open file’ and navigate to the CSV. Click on ‘Open’.

This opens a ‘File Settings’ window. This is an overview of what is in your CSV. Confirm whether this is the correct file and then click ‘OK’.

File Settings Window

In the top section of the ‘Import to Database’ window, you can see the available fields in the CSV.

Available Fields in CSV

You’ll need to map these fields to the DotActiv fields at the bottom.

You can do that by using the ‘AutoMap’ function. 

Please note that the naming convention used in the CSV must match the Column name in DotActiv for the AutoMap function to be accurate.

To do that, click on each field and then click on the ‘AutoMap’ function as seen in the GIF below.

Automap Function

Please check that the correct fields have been mapped. If a field has been mapped twice, click on the incorrect mapped field double left click on your mouse to remove it.

You can also manually map your fields to the DotActiv fields, by dragging and dropping them onto the correct DotActiv fields as illustrated below.

Manually Mapping Fields in DotActiv

After you have mapped all the relevant fields, you are now ready to import. 

To do this, click on the ‘Import’ function.

Import Function - Using a CSV

This opens the ‘Import Summary’ window.

Import Summary Window

It is important to note that when you are updating the database you should always select ‘Update Only’.

Import Summary - Update Only

Then click ‘OK’.

Once the update has been completed a window will appear verifying that the import is complete.

Updated on September 19, 2019

Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support