01. Importing Companies

Prev Next

COBBLESTONE SOFTWARE

Contract Insight — User Guide

01. Importing Companies

03. Admin User Manual › Vendor/Customer Management › 01. Importing Companies

Note: Each procedure in this guide begins at the Contract Insight homepage, so any section can be followed on its own. Custom fields are configurable, so the exact field list on a contract category record may vary between environments.

1. Overview

Bringing many company records in at once is handled by Administration → Data Import, described in the application as importing records from CSV using mapping templates — the same generic import tool used for other record types, applied to the Vendors/Customers area to bulk-create or update company records from a spreadsheet.

 

2. Key Elements

  • Administration → Data Import imports records from CSV using mapping templates
  • A mapping template ties spreadsheet columns to company fields
  • The same tool covers other record types, not only companies

 

3. Choosing a Template and Mapping Fields

From Administration > Data Import, each row in the Templates list is a saved mapping for one target table (Insert/update or Update-only mode). Selecting Map Fields on a template opens its field list: tick each field present in your spreadsheet, set the CSV column header it corresponds to, and mark any field used as a condition (to find the record to update) or a lookup (a display value resolved to its ID). A counter at the top tracks how many of the table’s fields are currently mapped.

4. Uploading a File to Run an Import

Once a template is mapped, Go to Run Import opens the upload step: Download Blank CSV gets a spreadsheet pre-filled with that template’s column headers, and Choose File selects the file to process once you’re ready. Records currently under Legal Hold are protected: a row belonging to a record on hold is skipped rather than updated. Uploading and running an import inserts or updates real company records, so a filled-in file is worth a careful review against the field mapping before it’s processed.

5. Quick Reference Summary

Task

How to Complete It

Open the import tool

Administration > Data Import.

Create a new template

Add Template: name it, pick a target table, and optionally check Update-only.

Map spreadsheet columns to fields

Map Fields on a template, then tick and configure each field.

Get a starter spreadsheet

Download Blank CSV on the Run Import screen for that template.

Run an import

Choose File on the Run Import screen, then process it.

Protect a record from being changed by an import

Place it on Legal Hold first — its rows are skipped during import.

See past imports

Past Imports, from a template’s Run Import screen.