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

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

• How Can I Credit Multiple Users For One Transaction?

  You may want to issue commissions to multiple users over the same sales transaction. This may be necessary when multiple users contribute to a sale, or because you have a multi-level commission structure (ex: override commissions). There are two ways ...

• Commission Software Checklist

  Don't be fooled by slick demos. Can other providers really handle your data and your commission structure? Ask the right questions. Choosing Commission Software At Sales Cookie, we want you to make an informed decision. The reality is that many of ...