In Vega you can import data for various purposes; contacts, payments or attributes for example.
This is a powerful tool and great functionality but certain processes need to be followed for this to be successful. Each template has set mandatory fields and a required format of data.
Below is a list of all available imports and a snapshot of the requirements with a link to the full detail for each template.
|Template Name||Import Type||Required fields|
|Import Template Contacts||Excel - People||Join Date, Active Flag, OK to Contact|
|Import Template Addresses||Excel - Addresses||
(VegaID, ScoperID or First Name, Last Name and Email), Address Type, Prefered
|Import Template Attributes||Excel - Attributes
(VegaID, ScoperID or First Name, Last Name and Email), Attribute Type, Attribute
|Import Template Lists||Excel - Lists||
(VegaID, ScoperID or First Name, Last Name and Email), List Name
|Import Template Notes||Excel - Notes||
(VegaID, ScoperID or First Name, Last Name and Email), Note Date, Note Type, Actual Note
|Import Template Payments||Excel - Payments||
(VegaID, ScoperID or First Name and Last Name), Batch code, Amount, Campaign, Category, Payment Type, Payment Date
|Import Template Recurring||Excel - Recurring Payments||
(VegaID, ScoperID or First Name, Last Name and Email), Pay Type, Donation Amount, Campaign, Distribution, Frequency, Start Date
|Import Template Relationships||Excel - Relationships||
(VegaID, ScoperID or First Name, Last Name and Email), Relationship Type, (Match VegaID or Match First Name, match Last Name and Match Email)
|Import Template Telecoms||Excel - Telecoms||
(VegaID, ScoperID or First Name, Last Name and Email), Telecom Type, Telecom Value, Active Flag
|Import Template Update Telecom||Excel - Update Telecoms||
VegaID, Telecom Value, TelecomID
To import data, go to Admin > Data Import:
You can download the various import templates from here if you have not completed this already. See the articles on the required fields and format for each type of import.
Once your template is finalised and you are ready to import the data, select the required import type and give it a name.
Click Get started to open the upload file screen. Browse for your file and click 'Upload File'. Please note this may take a few minutes to upload, only click the button once.
When the file is uploaded you will see a snapshot of the data, up to 100 rows depending on the size of your file. This is only a preview and the whole file will be imported.
If you are satisfied that this data looks correct you can either 'Import Data Now' or 'Import Data Using Import Service'. Select 'Import Data Using Import Service' if you would like to do something else while running the import in the background. Select 'Import Data Now' to wait until the import is completed.
If your import is greater than 1000 rows then it will only allow you to select 'Import Data Using Import Service'.
The data import may take a few minutes, please be patient and only click the button once.
Click Report summary to see the number of import changes that have been made. This report will show you if not all rows have been imported so you need to check the numbers match your expected import number based on your file.
Every data import is assigned an attribute under the type Data Import, the attribute name will be the name of your import. Using the Vega preset query "All Contacts By Attribute (All)" is an easy way to find all contacts from your recent import and confirm all have been imported as expected.
Please sign in to leave a comment.