How Can We Help?
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 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 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. |
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