Importing data

List Upload Error Messages

If you encounter any of the following error messages while trying to upload a list into CONNECT, follow the instructions below.


1.  "The file you have selected has duplicate header names. Please correct this issue and try again."

 


2.  "The file you have selected has columns without headers. Please correct this issue and try again."

 

This error message indicates that you have selected a file that has columns with blank headers. This can happen in two situations (or a combination of both).

  1. The file you are trying to upload has columns with data but at least one of the columns is missing a header (see example on left).
  2. The file you are trying to upload has "ghost" columns. These are columns that have no values in any of the rows (including the header) but are represented in the file by commas. 
  3. Follow the instructions below to fix this issue.

 

2.1.  Identifying files with "Ghost" columns

 

 


2.2.  Fixing files with "Ghost" columns

 

To fix the issue of "ghost" columns, you first want to open your file in Microsoft Excel. In Excel, you will not be able to see the columns. 

 

The best way to get rid of them is to highlight a lot of extra columns to the right of your data.

  1. Highlight the columns by clicking one of the letter headers at the top, holding down your click and dragging across until you've highlighted enough columns. The more you highlight, you the more likely you are to catch all of the ghost columns.
  2. Right click on any of column letters as the top and select "Delete". Save your file and exit Excel. 
  3. To confirm you have successfully deleted the "ghost" columns, re-open your file in notepad and the extra commas should be gone.

How to Add an Additional Person

There are situations where you might need to add one more person to your DataMart, either a customer or maybe you have a new team member you would like to add as a stakeholder. Here's how.


1.  To begin, click on the People tab located in the Target screen

 

Screenshot-2023-10-27-153122.png

 


2.  Next, click on the "Add Person" button

 

Screenshot-2023-10-30-151057.png

 


3.  Select the Subscription(s) you would like to add the record to

 

Screenshot-2023-10-30-151318.png

 


4.  Select the permission level of the record you are adding

 

Screenshot-2023-10-30-151336.png

 


5.  OPTIONAL: Select the record type of the record you are adding

For a definition on Record Types, click here.

 

Screenshot-2023-10-30-152113.png

 


6.  Fill out the Field Information of the Record you are Adding

OudScreenshot-2023-10-30-151406.png

 

Note: Only the Identifier field is mandatory in this process. It will be flagged with a green indicator.

 


7.  Click the "Save" button, once finished

 

Screenshot-2023-10-30-1514356.png

 

How to Upload Records as Stakeholders, Test Accounts and Seeds

Throughout CONNECT, you will see references to three different records types: Stakeholders, Test Accounts and Seeds. 

In this article, the process for uploading these records and the recommended uses for each are discussed.


1.  Begin uploading the list of records you would like to assign as one of the record types

 

 

 


2.  During the list upload process, click on "Additional options" to reveal the record type options

 

Screenshot-2023-10-30-153016.png

 


3.  Test Accounts

 


4.  Stakeholders

 


5.  Seed Lists

 

How to set up a FTP Import

FTP Imports provide a simple solution to automating your data imports. This can be effective for pushing data from your CRM system or another tool that collects contacts into CONNECT. Follow the tutorial below to set-up your first FTP Import. 

Note: In order to access the FTP Import's sub folder and begin dropping files, you will need your CONNECT FTP credentials which were provided when you were on boarded. If you need help retrieving these credentials, please submit a support ticket or email support.

Tutorial

Please note: To better view the tutorial, click the full screen icon Qx1Screenshot-2023-10-26-141632.png.

 

 

How to edit a FTP Import task

Using segments is not only a great way to target specific groups of contacts but it's also a great way to retrieve data from CONNECT for use outside of the application. This tutorial will help walk you through how to export a segment using our Exports feature.

Tutorial

Please note: To try out the feature, click the full screen icon Qx1Screenshot-2023-10-26-141632.png in the tutorial.