How Can We Help?

< Back
You are here:
Print
Table of Contents

Purpose

This article is to be updated with statistics gathered the importation of Media lists and Other lists. This is to provide an audit trail of the imports to support any troubleshooting that may be required later. Add your import at the top (directly after this section) and copy the most recent as a template for your new import (so that the formatting and content is in place and all you have to do is overwrite the numbers and tables).

MSA Media

Imported by: Rob on 16-Dec-2019 as requested by Phillip Money

External ID Stub: MSA

File Name: Orgs.csv (with 143 rows)

Total Rows 143 Total number of rows in the imported data.
Total Contacts 143 Total number of contact records created or modified during the import.
Import to Groups : 143 contacts added to this existing group.

File Name: Individuals.csv (with 102 rows)

Total Rows 102 Total number of rows in the imported data.
Total Contacts 204 Total number of contact records created or modified during the import.
Import to Groups : 127 contacts added to this existing group. 77 contacts NOT added (already in this group).

File Name: Relationships.csv (with 99 rows) via API Import

Total Rows 99 Total rows (participant records) in uploaded file.
Records Imported 99 Rows imported successfully.

Victoria Media from Newgate Comms

Imported by: Kavya on 05-Feb-2019 as requested by Rob

External ID Stub: VicMediaNewgateComms

File Name: Organisations.csv

Total before – Organisations: 2268

Total Rows 57 Total number of rows in the imported data.
Total Contacts 57 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 47 contacts are tagged with this tag. 10 contacts NOT tagged (already tagged to this tag).

Total After – Organisations: 2314

File Name: Individuals.csv

Total Individuals before – 6650

Total Rows 81 Total number of rows in the imported data.
Total Contacts 162 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 74 contacts are tagged with this tag. 88 contacts NOT tagged (already tagged to this tag).

Total After – Individuals: 6724

Probus Clubs

Imported by: Dinusha on 21-Jan-2019 as requested by Rob

External ID Stub: ProbusClubs

Tag: Probus Clubs

File Name: Organisations.csv

Total before – Organisations: 1623

Total Rows 50 Total number of rows in the imported data.
Total Contacts 50 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 50 contacts are tagged with this tag.

Total After – Organisations: 1673

Life Activity Clubs

Imported by: Dinusha on 21-Jan-2019 as requested by Rob

External ID Stub: LIFE ACTIVITY CLUBS

Tag: Life Activity Club

File Name: Organisations.csv

Total before- Organisations: 1603

Total Rows 20 Total number of rows in the imported data.
Total Contacts 20 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 20 contacts are tagged with this tag.

Total after: Organisations: 1623

File Name – Individuals.csv

Total before – Individuals: 5916

Total Rows 4 Total number of rows in the imported data.
Total Contacts 8 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 4 contacts are tagged with this tag. 4 contacts NOT tagged (already tagged to this tag).
Total After – Individuals: 5920
File Name: Relationships.csv
Total Rows 3 Total rows (participant records) in uploaded file.
Records Imported 3 Rows imported successfully.

Special Interest

Imported by: Dinusha on 15-Jan-2019 as requested by Rob

External ID stub: SpecialInterestMedia

Tag: Special Interest Media

File Name: Organisations.csv

Total before- Organisations:1321

Total Rows 73 Total number of rows in the imported data.
Total Contacts 73 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 71 contacts are tagged with this tag. 2 contacts NOT tagged (already tagged to this tag).

Total After – organisations: 1392 

File Name: Individuals.csv

Total before: 5827

Total Rows 14 Total number of rows in the imported data.
Total Contacts 28 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 14 contacts are tagged with this tag. 14 contacts NOT tagged (already tagged to this tag).

Total After – Individuals: 5841

File Name: Relationships.csv

Total Rows 4 Total rows (participant records) in uploaded file.
Records Imported 4 Rows imported successfully.

Television

Imported by: Dinusha on 14-Jan-2019 as requested by Rob

External ID stub: Media2018 TELEVISION

Tag: Television

File Name: Organisations.csv

Total before-organisation:1172

Total Rows 32 Total number of rows in the imported data.
Total Contacts 32 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 30 contacts are tagged with this tag. 2 contacts NOT tagged (already tagged to this tag).

Total after- Organisations: 1202

File Name: Individuals.csv

Total before: Individuals:5793

Total Rows 23 Total number of rows in the imported data.
Total Contacts 46 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 23 contacts are tagged with this tag. 23 contacts NOT tagged (already tagged to this tag).
Total after- Individuals: 5816
File Name: Relationships.csv
Total Rows 5 Total rows (participant records) in uploaded file.
Records Imported 5 Rows imported successfully.

Online

Imported by: Dinusha on 14-Jan-2019 as requested by Rob

External ID stub: Media2018 ONLINEMEDIA

Tag: Online

File Name: Organisations.csv

Total before- Organisations:1146

Total Rows 27 Total number of rows in the imported data.
Total Contacts 27 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 26 contacts are tagged with this tag. One contact NOT tagged (already tagged to this tag).

Total after- organisations:1172

File Name: individuals.csv

Total before: Individuals:5780

Total Rows 13 Total number of rows in the imported data.
Total Contacts 26 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 13 contacts are tagged with this tag. 13 contacts NOT tagged (already tagged to this tag).

Total after-individuals:5793

File name: relationships.csv

Total Rows 2 Total rows (participant records) in uploaded file.
Records Imported 2 Rows imported successfully.
Magazines

Imported by: Dinusha on 14-Jan-2019 as requested by Rob

External ID stub: Media2018 MAGAZINES

Tag: Magazines

File name: Organisations.csv

Total Rows 8 Total number of rows in the imported data.

File Name: Individuals.csv

Total Rows 10 Total number of rows in the imported data.
Total Contacts 20 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 10 contacts are tagged with this tag. 10 contacts NOT tagged (already tagged to this tag).

File Name: relationships.csv

Total Rows 2 Total rows (participant records) in uploaded file.
Records Imported 2 Rows imported successfully.

Journalists

Imported by: Dinusha on 14-Jan-2019 as requested by Rob

External ID stub: Media2018 JOURNALISTS

Tag: Journalists

Total Before – Organisations: 932

File name: Organisations.csv

Total Rows 2 Total number of rows in the imported data.
Total Contacts 2 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 2 contacts are tagged with this tag.

Total After – Organisations: 933

File Name: Individuals.csv

Total before – Individuals: 5765

Total Rows 9 Total number of rows in the imported data.
Total Contacts 18 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 8 contacts are tagged with this tag. 10 contacts NOT tagged (already tagged to this tag).

Total After – Individuals: 5773

File Name: relationships.csv

Total Rows 9 Total rows (participant records) in uploaded file.
Records Imported 9 Rows imported successfully.

Local Government

Imported by: Rob on 11-Jan-2019 as requested by Nicky Barry

Source: Victorian Municipal Councils List of Local Councils Victorian Local Government Contacts – December – 2018

External ID stub: GENERAL2019 LG Org

Tag: Local Government

Totals before -Organisations: 1099, Local Government tags and Organisation: 137

Total Rows 79 Total number of rows in the imported data.
Total Contacts 79 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 58 contacts are tagged with this tag. 21 contacts NOT tagged (already tagged to this tag).

Totals after – Organisations: 1146 (+47), Local Government tags and Organisation: 195 (+58)

Community Health Services

Imported by: Rob on 11-Jan-2019 and initially put into the Local Government tag and then removed from that tag

Source: Community Health Directory

External ID stub: MEDIA2019 Community Health Services Org

Tag: Community Health Services

Totals before – Organisations: 1014, Local Government Tag: 80

Total Rows 95 Total number of rows in the imported data.
Total Contacts 95 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 94 contacts are tagged with this tag. One contact NOT tagged (already tagged to this tag).

Totals after – Organisations: 1099 (+85), Local Government Tag: 174 (+94)

Regional Newsletters

External ID stub: Media2018 REGIONALNEWSLETTERS

Tag: Regional Newsletters

Total Org – 74

Organisations.csv

Total Rows 74 Total number of rows in the imported data.
Total Contacts 74 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 74 contacts are tagged with this tag.

Total Organisation After – 1014

Radio

External ID stub: Media2018 RADIO

Tag: Radio

Total Org – 120

File Name : Organisations.csv

Total Rows 120 Total number of rows in the imported data.
Total Contacts 120 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 119 contacts are tagged with this tag. One contact NOT tagged (already tagged to this tag).

Total Organisation After – 1321

File Name: Individuals.csv

Total Rows 10 Total number of rows in the imported data.
Total Contacts 20 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 10 contacts are tagged with this tag. 10 contacts NOT tagged (already tagged to this tag).

Total After – Individuals: 5827

Newspapers

External ID stub: Media2018 NEWSPAPERS

Tag: Newspaper

Total Org before – 1392

File Name : Organisations.csv

Total Rows 152 Total number of rows in the imported data.
Total Contacts 152 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 145 contacts are tagged with this tag. 7 contacts NOT tagged (already tagged to this tag).

Total Organisation After – 1535

File Name: Individuals.csv

Total Rows 62 Total number of rows in the imported data.
Total Contacts 124 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 55 contacts are tagged with this tag. 69 contacts NOT tagged (already tagged to this tag).

Total After – Individuals: 6000

Victorian Community Information Centres

External ID stub: Vic Community Infor Centres

Tag: Victorian Community Information Centres

Total Org before – 1535

File Name : Organisations.csv

Total Rows 63 Total number of rows in the imported data.
Total Contacts 63 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 63 contacts are tagged with this tag.

Total Organisation After – 1597

Victorian Primary Health Networks

External ID stub: Victorian Primary Health Network

Tag: Victorian Primary Health Networks

Total Org before – 1597

File Name : Organisations.csv

Total Rows 6 Total number of rows in the imported data.
Total Contacts 6 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 6 contacts are tagged with this tag.

Total Organisation After – 1603

File Name: Individuals.csv

Total Individuals before – 5910

Total Rows 6 Total number of rows in the imported data.
Total Contacts 12 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 6 contacts are tagged with this tag. 6 contacts NOT tagged (already tagged to this tag).

Total After – Individuals: 5916

Victorian Public Health Services

External ID stub: Victorian Public Health Services

Tag: Victorian Public Health Services

Total Org before – 1603

File Name : Organisations.csv

Total Rows 94 Total number of rows in the imported data.
Total Contacts 94 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 94 contacts are tagged with this tag.

Total Organisation After – 1603

Victorian Lions Clubs

Imported by: Kavya on 29-Jan-2019 as requested by Rob

External ID Stub: VIC LIONS CLUBS ORG

Tag: Victorian Lions Clubs

File Name: Organisations.csv

Total before – Organisations: 1671

Total Rows 340 Total number of rows in the imported data.
Total Contacts 340 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 340 contacts are tagged with this tag.

Total After – Organisations: 2011

File Name: Individuals.csv

Total Individuals before – 5923

Total Rows 528 Total number of rows in the imported data.
Total Contacts 1056 Total number of contact records created or modified during the import.
Tagged Imported Contacts Media Contact: 0 contacts are tagged with this tag. 528 contacts NOT tagged (already tagged to this tag).

Total After – Individuals: 6451

U3As

Imported by: Kavya on 31-Jan-2019 as requested by Rob

External ID Stub: U3A Org

Tag: U3A

File Name: Organisations.csv

Total before – Organisations: 2011

Total Rows 109 Total number of rows in the imported data.
Total Contacts 109 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 109 contacts are tagged with this tag.

Total After – Organisations: 2108

Victorian Rotary Clubs

Imported by: Kavya on 31-Jan-2019 as requested by Rob

External ID Stub: VitorianRotaryClubs ORG

Tag: Victorian Rotary Clubs

File Name: Organisations.csv

Total before – Organisations: 2108

Total Rows 159 Total number of rows in the imported data.
Total Contacts 159 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 159 contacts are tagged with this tag.

Total After – Organisations: 2266

File Name: Individuals.csv

Total Individuals before – 6452

Total Rows 185 Total number of rows in the imported data.
Total Contacts 370 Total number of contact records created or modified during the import.
Tagged Imported Contacts : 0 contacts are tagged with this tag. 370 contacts NOT tagged (already tagged to this tag).

Total After – Individuals: 6635