What Is CSV Import Locking?

Our support team may enable CSV import locking on your workspace. This mode is designed to ensure that all uploaded CSVs conform to previously uploaded (mapped) ones. This avoids all types of data mistakes and problems described below.

Suppose that you have a CSV file called "example.csv" like this:

On import, you mapped fields, for example like this:

Later, you imported another CSV file called "something else.csv", whose "Total" field has been renamed to "Amount". 

When you import, you will get a warning like this:

If a CSV import locking is enabled, we will prevent you from finishing the import because your schema changed. This avoids all types of data mistakes and problems.

For example, formulas may reference fields by name. If your field names change constantly, formulas must be updated constantly as well. 

Also, logic may rely on the file name to know which type of data it is. For example, if the file name has "Deals" in its name, then some logic may assume that it contains deals. If the file name has "Invoices" in its name, then some logic may assume that it contains invoices.

 

The CSV file lock ensures you do not run into those types of issues, and forces you to use consistent CSV names and schemas. As a result, formulas don't need to be updated to account for an ever-changing schema (or ever-changing file naming conventions).

Should you need to add a field or change mappings, please consider contacting support for assistance. We can help you find the best way to update your schema.

• Related Articles

• How Can I Import Sales Cookie Data Into Google Sheets?

  Sales Cookie offer a rich entity schema and APIs. Some solutions such as Power BI, Tableau, or Excel natively understand structured data. They also offer native support for JSON Web APIs such as OData. However, Google Sheets does not offer the same ...

• Why Are Transaction Dates Important When Importing Transaction Data?

  Let's say you upload a CSV file with records like this: As you can see, there is no date column. So, if you wanted to calculate January commissions, we would not know if those sales would apply since there is no effective date column we can use. In ...

• Understanding Dates and Time Zones

  Storing Vs. Displaying Dates All dates are stored in UTC format with millisecond accuracy. However, dates are automatically converted to your time zone when displayed to you. For example, a stored UTC date of 2022-01-01T00:00:00 may be displayed as ...

• Which Advanced Options Are Available?

  Sales Cookie offers many advanced capabilities via its web interface - including draws, splits, overrides, etc. However, some additional (even more) advanced options can also be set on incentive plans using a text-based representation. Advanced ...

• Getting Started With Sales Cookie - Admins

  About This Guide This guide is designed to help you get started as a Sales Cookie administrator. We assume that we've already configured one or more incentive plans for you. Looking for a starter guide for your payees instead? Click here. This guide ...