Harris Archive Project, detailed review

April 28, 2015 eComm Town Hall


Not Migrating

  • Data that is tied to records
  • Email Preference Data
  • Email Marketing activity
    • Queries, Lists
    • Email Content
    • Images
    • Reports
  • Event Registration activity
    • Registration Lists
    • Reports
    • Images

To ensure CU remains compliant with federal CAN SPAM legislation, email preference data will be migrated from Harris Connect to Salesforce. However, all other data and content (such as queries, content, images, reports, etc.) that are tied to Harris Connect's tools will NOT be migrated.

We encourage you to start thinking about this process so you are prepared for a smooth transition from Harris Connect to Salesforce. If you would like to archive emails and/or forms that you've built, please refer to the how-to guides below.

We're here to help. Please reach out to your eComm specialist if you have questions or need additional support.


Email Marketing

Any lists that have been created or uploaded in Harris Connect will not automatically migrate to the new Salesforce platform.

If the ‘List Type’(see image) reads ‘Advanced Query Builder’ or ‘Standard Query Builder’, that list will need to be recreated in Salesforce. In order to make this transition as seamless as possible, you will need to take a screenshot of the query for your records.

Lists that need to be archived include ‘List Type’(see image) of ‘Uploaded Email List’ or ‘Uploaded ID List’. These will need to saved locally and imported into your Salesforce account.

Create & Manage Lists

Detailed Instructions for Exporting 'Uploaded ID List' and 'Uploaded Email List'

  1. Log in to your Harris Connect account (contact your eComm specialist if you need credentials)
  2. Navigate to 'Email Marketing' >> 'Create & Manage Lists' tab
  3. Once you have identified the lists that you and your department need to archive, click ‘Display’ in the ‘List Count’ column for the list you wish to archive. *NOTE: Depending on the size of your list, this could take up to 2 minutes to display
  4. A popup will appear. Click inside any cell, then select all by using the keyboard shortcut CTRl + A
  5. Paste this information into an excel spreadsheet
  6. Save as a.CSV file with a relevant naming convention.

It is your responsibility to ensure your graphics and content are archived locally in order to be uploaded into Salesforce. This includes any files uploaded in ‘file manager’ or created in ‘Create & Manage Content’.

[infobox title="Detailed Instructions"]

  1. Within the ‘Create & Manage Content tab, you can click ‘Edit’ to edit an email.
    Create and Manage Content, Edit
  2. Once the email appears for editing you can click on ‘Open file manager’.
    Open File Manager
  3. From the Folders section, find the folder(s) where you have uploaded your images. This will open your ‘Community Services’ Broadcast Email File Library. Within this library you can navigate to the location of where you have uploaded your images.
    File Manager, Folders
  4. Once you find the correct folder, click on the folder and the files in that folder will appear below in the ‘Files’ section. You can scroll down to the ‘Files’ section to find your files (images, documents).
    File Manager, Files
  5. By clicking on the Filename of the file you want to export, it will open another window with an image of your file. As you can see in the image below if you right click on the image it will allow you to “Save Image As”. I recommend creating a folder on your C: drive (or network drive if you prefer) label ‘Harris Images’ and saving them there. When saving images, I recommend you title
    them in such a way that they describe the image and the size. (Please see Image naming convention appendix attached).
    File Manager, Save Image As

You will need to complete this exercise for all the images you are wanting to have available to load into the new system.

[col width="1-4"]There are two components of 'Address & Assemble' that will automatically be transferred from Harris to Salesforce. This includes 'From' as well as 'From Email'(both outlined in red). If you need to retain any other piece of information from 'Address & Assemble' you will need to keep a screenshot on your desktop.
Address & Assemble
None of the information housed in 'Send & Schedule' will be transferred to Salesforce. If this is information you or your department needs to archive, you will need to take a screenshot and save it locally.
There is an easy way to obtain analytics on all of your emails. Such information includes: List count, success of delivery, opens based on device, clicks, unsubscribes, and bounces. A sample report is provided below.

Email Comparison Report

Detailed Instructions

  1. Navigate to ‘Email Marketing’
  2. In the ‘Reports’ tab, click on the ‘Email Comparison Reports’ subtab.
  3. In order to run a complete historical report, you will need to clear the default ‘Date Sent’ and hit ‘Apply filter’. Every email that has been sent from this account will appear.
  4. Click ‘Check all’ then hit the ‘Compare selected emails’ button. Depending on the number of emails you have to compare, this might take up to 5 mins.
  5. Once the report is ran, you can ‘Download this report’ and save locally.

Forms Management

Detailed Instructions

  1. Log in to your Harris Events account.
  2. Under the Reporting tab on the top silver navigation, hover over Form Reports, then select Event Registration Reports.
    Event Registration Reports
  3. Delete the date in the Event Start Date fields, then click the Apply Filter button. If you have archived events, make sure to click the Archived box in the grey Archive Status area as well.
    Event Start Date fields
  4. Once the filter completes, click the Printer Friendly Version link at the top of the events list. This will allow you to print/save a PDF of all the events (Available and/or Archived) within your Harris Events account.
    Printer Friendly Version
    Printer Friendly Version
  5. Also in the Event Registration Reports tab, you will find the “View event item reports” under the title of each event. This will give you a quick snapshot of the event in terms of number of attendees, total money received, etc.
    View event item reports
    Event snapshot
  6.  Within each event title is also the “View detailed reports” option. This allows you to download a .csv file of all event components from the form. It will give you a spreadsheet of attendee names, etc. (whatever the form designated). Make sure to select the date range when the form was active so you get accurate information on your downloaded spreadsheet.
    View detailed reports
    View detailed reports, date range

NOTE: If you need an archive of the actual form, you will need to go to that form’s url and take a screen shot of the form itself. You may also click on the event title, then click the Web View button at the top to see the form in an internet provider’s window.

Event registration, web view