How To Prep Your CSV

In this article, we will cover how to work with CSV’s. It will provide you with a general guideline on how to prep your CSV to 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.

Updated on March 12, 2020

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