About Activity Imports
Importing activities into Novi allows you to add historical notes to the Timeline tab of your members' records. Learn more about Timeline Activities.
When Activity Imports Occur
The Activity import is done after your Members' import is complete. Once we've imported the data we'll reach out to you to approve that they are correct.
Please note that we will assist you throughout the import process, but you are responsible for exporting the data from your current system.
Setting Up Your Activity Import File
Activity data is imported from one spreadsheet. Keep in mind when setting up your data that data import is very literal. When the system reads your data, things MUST match up. For an activity import, this pertains to the member's name in the spreadsheet so the activity will be added to the correct member record in Novi.
See the information below for formatting and requirement guidelines.
Row Number
Label row numbers from 1 and beyond.
Member ID
*Required. This is the ID of the member which should match exactly to the "Import ID" from your Members Import Spreadsheet. This is usually the member's name but could be a number.
Date
*Required. This should be formatted as MM/DD/YYYY. This is the date of the Note/Activity. If you do not have this information in your data, enter a generic date (e.g. January 1 of the current year).
Activity Type
*Required. What this should be entered as. Must be one of the following: Note, Task, Meeting, Call, Email, Membership, Ecommerce, Events, Credit, Parent Change
Custom Activity Type: For activities that are not covered by the predefined options mentioned above, you can track them using a custom activity type. Once you create the custom activity type, you can import notes under that specific type.
Credit
If credit was earned, enter the number of credits here. Leave blank if not applicable.
If different in some cases, you can import:
Credits Possible
Enter the number of credits the member can earn.
Credits Awarded
Enter the number of credits the member actually earned by participating in a course/activity.
Credit Type
This must be set up in Novi before the activity import and the entry on the spreadsheet should match the Credit Type that exists in Novi.
Subject
*Required. 200 character max. This is a text field that represents the title/label of the activity and can be anything you want. Some examples include Phone Call, Email, Site Visit, Membership, Credit, Sponsorship, etc. If you do not have this data you can enter something generic (e.g. Historical Note).
Notes
This is an optional text field where you can enter additional information about the activity.