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.
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.