Skip to main content
Liaison

Working with Contact Exports

By exporting Contacts in Admissions, you can extract applicant contact information in Spreadsheet or JSON formats. See Working with Applicant Exports to learn how to export Contacts.

Generating Contact Exports

If your institution has already configured at least one export template, you can use these templates to generate an on-demand export file. To do this:

  1. Go to the Contacts view.
  2. Filter to isolate your desired contacts, and select them using the checkboxes on the left. Use the checkbox at the top of the grid to select all the displayed applicants, or use individual checkboxes to select contacts one-by-one.
    select-all-contacts-export.png
    The filtered applicants are paginated, so using the Select All checkbox only selects the displayed applicants. To select the rest of the applicants that match your filters, click Select all X.
  3. Select Export from the menu, and choose which Export type you'd like to generate. You can generate the file(s) in the default Tabular format, default JSON format, or one of your previously configured export formats.
    select-contact-export-type.png
  4. Next, select where you want the export to be sent. Click Generate near Download Directly to download the file directly to your device. To have the file sent to another destination, click the corresponding Generate button. The destinations listed here are those configured in the Export Destinations area of the Settings menu.
    destination-options-for-export.png
  5. The file now begins to generate. You can wait for confirmation that the export is finished, or you can dismiss the progress window and use the Downloads button to return to your previous exports.
    export-file-ready.png
    downloads-button-update.png
  6. From the Downloads page, click the desired export, and download your file.

Configuring Contact Export Templates

To generate customized export files, you’ll first need to configure export templates. To create an export template:

  1. Go to the Import/Export section of the Settings menu and click Exports.
    settings-menu-exports.png
  2. Review the existing exports, or click Create Export to begin creating a new export file.
    exports-page.png
  3. Navigate to the Contact export area and choose an export type. Available export types are:
  • JSON: Short for JavaScript Object Notation, this is a lightweight, data-interchange format using human-readable text. It is commonly used for transmitting data in web-applications.
  • Tabular/Spreadsheet:This format offers files in .csv, .tsv, or .txt file types.

contact-export-selection.png

  1. Continue configuring the export using the instructions below, based on which export type you’ve selected.

Configuring JSON Contact Exports

To configure a JSON export:

  1. After clicking Create Export on the Exports page, select JSON.
  2. Name the export file.
    contact-json-export-settings.png
  3. If desired, you can enable the Customize File Name option, allowing you to create a file name template with variable text. Note that this is an advanced feature that requires knowledge of the database field names.
    contact-json-export-more-settings.png
    The variable text options available here include:
    • minute
    • hour
    • date
    • year
    • month
    • dayOfMonth
    • totalRecordCount
    • exportName
    • fileRecordCount
    • fileNumber
    • fileCount

Note that variables should be surrounded by double curly brackets. These variable fields are populated with the appropriate value when the export file is created.

  1. If desired, you can enable the Batching option, causing the software to group several records together in the same .zip file.
  2. In the Output area, select what you’d like to include in the file. Setting this option to Everything creates an export with all available fields included. Setting this to Selected Fields allows you to click to select fields on the left to include in the export. You can also drag them into the desired order. Setting the Output option to Custom allows you to enter JavaScript code to transform your desired data.
    selecting-export-fields.png
  3. Click the plus sign near any section to add all of its fields. Selected fields appear with a checkmark.
    add-all-fields-export.png
  4. If desired, click the translation table icon or field expression icon to further customize your export.
    choose-a-table-icon.png
  5. In the Schedule area, if desired, click the plus sign to configure a schedule.
  6. When you’re done configuring the export, click Create Export.

Configuring Tabular / Spreadsheet Contact Exports

To configure a tabular or spreadsheet export:

  1. After clicking Create Export on the Exports page, select Tabular / Spreadsheet.
  2. Name the export file, and select from the Comma Delimited, Tab Delimited, or Fixed Width style types.
  3. If desired, you can enable the Customize File Name option, allowing you to create a file name template with variable text. Note that this is an advanced feature requiring knowledge of database field names. The variable text options available here include:
    • minute
    • hour
    • date
    • year
    • month
    • dayOfMonth
    • totalRecordCount
    • exportName
    • fileRecordCount
    • fileNumber
    • fileCount

Note that variables should be surrounded by double curly brackets. These variable fields are populated with the appropriate value when the export file is created.

  1. If desired, you can enable the Batching option, causing the software to group several records together in the same .zip file.
  2. In the Columns area, you can add fields to include in your export. To add fields, find them on the Available Fields panel and click to add them. You can also drag-and-drop them into your desired order.
    contacts-export-column-selector.png
  3. Click the plus sign near any section to add all of its fields. Selected fields appear with a checkmark.
    add-all-fields-export.png
  4. If you've created Translation Tables, you can click Choose a table icon to apply one of your tables. This allows you to convert the data output from this field into your preferred format.
    choose-a-table-icon.png
  5. If desired, use the field expression icon to customize your export.
  6. In the Schedule area, if desired, click the plus sign to configure a schedule.
  7. When you’re done configuring the export, click Create Export.
  • Was this article helpful?