1. Home
  2. DotActiv - Database Integration
  3. Working With CSV And Staging Tables

Working With CSV And Staging Tables

In this article, we will cover how to work with CSV and Staging Tables. It will provide you with a general guideline on how to prep your CSV and data, and ensure all the relevant columns are populated before importing it into the database.

Applicable Products: DotActiv Lite, DotActiv Pro, DotActiv Enterprise

Working With A CSV

DotActiv follows a simple process when reviewing your data prior to importing it into the database.

Download the Excel Document with the correct format here.

Make sure that you have populated all your Key Fields and that there are no blank columns or duplicate entries. For example, Store; Product; and Period combinations should be unique.

Ensure your period is in the correct format: yyyy-mm-dd

Double-check that your ProductID and/or Barcode field are in text format as seen below.

Save your file as CSV. It is now prepped and ready for you to import it into the database.

Working With Staging Tables

The same principle applies when working with staging tables. Prepping your CSV or excel sheet is vital to making data transfer that much easier.

Please read the articles under Step 5 of the database integration process article here.

Working with your data and making sure that it is in the correct format, is a vital step in the importing process. Ensuring that your data is prepped correctly can resolve so many potential issues.

DotActiv has a saying; Clean data in, means clean data out.

Updated on November 14, 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