Skip to main content
Mitratech Success Center

Client Support Center

Need help? Click a product group below to select your application and get access to knowledge articles, webinars, training content, and release notes or to contact our support team.

Authorized users - log in to create a ticket, view tickets status and check your success plan details.

 

CSV Import in GCD

The following article outlines how users can leverage Excel file for bulk data entry. Each column name is detailed so that users can construct their CSV file accurately.

CSV (comma-separated-value) files may be imported to GCD for bulk data entry. Most data-oriented systems can produce (export) CSV files from other formats. Microsoft Excel® is often used to generate CSV files for importing to GCD. See the Excel documentation for details on generating a CSV file from a spreadsheet.

To import a file, click Tools, .csv Import in GCD. You will be prompted to browse to a file from your local file system and to specify the data type.

Each CSV file imported must conform to the following requirements:

  •     The separator must be a comma.
  •     Each value must be surrounded by double quotes
  •     Each file must contain only one of the following types of data:

            Lookup Values
            Contacts
            Folders
            Actions (Tasks)
            Events
            Folder-Contact Relationships

  •     Each column in the file must have a column header listed below under the appropriate data type. You may omit columns, but the presence of additional columns will cause the import to fail. Column names      are not case-sensitive.
  •     Each date column must be formatted in mm/dd/yyyy format unless otherwise specified.
  •     The size of a single CSV file may not exceed 10mb.

Importing Documents

Regarding Documents: Users are requested to contact GCD Support to import document records by CSV import. Only document metadata can be imported via CSV import. If the underlying document files are to be stored on GCD's servers, the files must be delivered separately. Contact GCD Support for information.

The following column names are supported for Document metadata:

  •     filename [Note: if the filename is a URL, it must begin with "http:" or "https:"]
  •     filetype
  •     documentname [Descriptive (friendly) name]
  •     createddate
  •     changeddate
  •     orig folder id [Used to link to "original id" field of imported folders; see below]
  •     notes
  •     expiration
  •     value [monetary value]
  •     valuenote [text]
  •     term

Importing Contacts

The following column names are supported for Contacts:

  •     name
  •     first name
  •     last name
  •     middle name
  •     company
  •     type
  •     suffix
  •     title
  •     original id
  •     notes
  •     business phone
  •     business street
  •     business city
  •     business state
  •     business postal code
  •     business country
  •     home phone
  •     home street
  •     home city
  •     home state
  •     home postal code
  •     home country
  •     fax
  •     mobile
  •     e-mail address

Importing Actions (Tasks)

The following column names are supported for Actions:

  •     subject
  •     start date
  •     due date
  •     private 
  •     Note: This is a TRUE/FALSE column.
  •     date completed
  •     status
  •     notes

Importing Folders

The following column names are supported for Folders:

  •     name
  •     status
  •     note
  •     delegate

    Note: Although GCD supports delegating a folder to more than one user, the CSV import only supports one delegate. The delegate name must match the name on the user's contact record (e.g., "Smith, John"). If you have more than one user with the same name, the first name found will be the delegate.

  •     original id
  •     createddate
  •     tags
  •     type_cd
  •     jurisdiction
  •     filenumber
  •     createdby
  •     open date
  •     contacts

    Note: In order to import contacts to a folder, the contacts must be imported in a Contacts CSV prior to the folder import. The value of the "contacts" field in the Folder import must be a pipe-delimited list of contact names that exactly match the names previously imported (e.g., "Smith, John|Brown, Mary|ABC Company"). Alternatively, you may exclude this column and use a Folder-Contact Relationships import file (below).

  • Was this article helpful?