How do I create a CSV file to import volunteer data into our Complyfile?

The first thing to do is to create a valid import CSV file.

(What's a CSV file? If you're not sure, click here to learn the difference beween an Excel file and a CSV file).

Why do I need to import any data using a CSV file (or any file for that matter)?

If you have volunteers who you have already recruited (prior to your adoption of the Complyfile software), you may decide to create a secure private profile page for these persons within your Complyfile, against which you can upload their paper volunteer records.

If you don't intend importing data for existing volunteers, you can skip this help article.

If you do intend to import data for your existing volunteers, please read on.

Prepare your import file using your Complyfile 'Volunteer Upload CSV file'

Log in to your Complyfile Admin Dashboard.

Go to your Toolkit.

Click the Manage button.

Click Upload Volunteers in the dropdown that appears under the Manage button.

Click Upload VolunteersOnce you see the Upload Volunteers screen, click the link that says 'Click here to download the Volunteer Upload CSV file':

Download template screen(You can also see the number of volunteers currently in your Complyfile, and the upper threshold under your current plan. You can upload volunteers up to and including the upper threshold of your plan. Click here to see how to change your plan to increase the upper threshold of volunteers in your Complyfile):

Upload volunteers pageOpen the file you just downloaded. You will find it in the Downloads section of your computer.

Populating your File with Data

  • Once you have your template file, which should be empty of volunteer data, open the file in your worksheet editor of choice (e.g. Microsoft Excel, or an alternate)
  • Populate this file with the details of the volunteers for whom you want to create records in your Complyfile

What information should go into the File for upload?

Pay careful attention to the column headings, making sure that you input the information accurately. You will be inputting into this file the names of existing volunteers who the branch has already recruited, but for whom you want to create a record in your Complyfile database, against which you can then in the future upload such existing paper documents/records that you currently have (e.g. training certs, vetting letters etc).

Format of Data Import

It is very important that the information ("data") that you type into the fields (the little boxes in the spreadsheet) should reflect the instructions in the column headers of your template spreadsheet.

Remember, the quality of your data import is tied to the quality of the data that you put into the spreadsheet. Complete it accurately, and you'll get accurate data imported. Complete it inaccurately, and you'll get inaccurate data imported.

Email Address Cannot be Changed Once Uploaded

Important: triple check that you use the correctly spelled (and current) email address for the person for whom you're creating a secure page within your Complyfile. Once imported, you cannot change this email address at a later date (your only option is to delete their profile page and create one afresh). The page is private and secure to the person for whom you're creating it, and accessible only by you (in your capacity as an organisation administrator) and them.

 

Widen the Column to see instructions

(When you open your file, you may need to increase the width of your columns, to see them displayed as above).

 

 

So e.g.

· Column A: (mandatory field): First Name: e.g. Jennifer

· Column B: (mandatory field): Surname: e.g. Smith

· Column C: (mandatory field): Mobile Number: can simply go in as either: 0862283213 or 862283213 (but no country code). It's fine for the zero to drop at the start. Do not leave a blank e.g. 086 228 1234 (with blanks inside the number). 

· Column D: (mandatory field): Email Address: This must be their correctly spelled email and cannot be amended at a later stage, so please double check you have this right.

· Column E: (mandatory field): Date of Birth: should read: 07/11/1967 (for 7th November 1967). If you are not sure of the person’s date of birth, simply type in a test date e.g. 01/01/1970 (which you can then update at a later date). If you type simply 01 01 2000 this will not be recognise.

· Column F: (mandatory field): Gender: type one of: Male    or  Female

· Column G: Address 1 (i.e. the first field in the address section):

· Column H: (optional field): Address 2 (i.e. the second field in the address section):

· Column I: (optional field): Address 3 (i.e. the third field in the address section):

· Column J: (mandatory field): City/Town: for the City/Town, simply put e.g. Dublin, Kildare, Wicklow (not County Dublin, or Co. Kildare). For Dublin addresses, put Dublin instead of e.g. Dublin 18

· Column K: (optional field): Postcode

Column L: e.g. Dublin, Kildare, Wicklow (not County Dublin, or Co. Kildare). For Dublin addresses, put Dublin instead of e.g. Dublin 18

· Column M: (mandatory field): Country: type  Ireland  (not Republic of Ireland) or Northern Ireland

Save as .csv file 

Important: Save your file as a .csv file (you can do this by going to File > Save as > open Save as type drop-down > select CSV (comma delimited) (*.csv) > Give your file a name that you will understand (e.g. "Upload Current Volunteers File [today's date]").

 

Important: Save your file as a .csv file (you can do this by going to File > Save as > open Save as type drop-down > select CSV (comma delimited) (*.csv) > Give your file a name that you will understand (e.g. "Upload Current Volunteers File [today's date]").

Using the 'example' data above, this is what you would type into the spreadsheet for a volunteer who I'm calling Jennifer Smith:

Creating Multiple Records for Multiple Persons

Simply repeat the process as many times as you have persons for whom you want to create a profile page with your organisation's Complyfile.

Remember, for each person, start an entry on a new line in the file which you will be uploading. Do take your time here, as if you can get the data right at this stage, on your spreadsheet, it will save you time in the future making updates / amendments to any incorrect data inadvertently uploaded.

Next Steps - Importing the File 

Once you've created the file that you want to import into your Complyfile, you'll need to import that file into your Complyfile. 

Click here to learn how to import your CSV file into your Complyfile, to create new volunteer records (for your existing volunteers) in your Complyfile.

 

 

 

 

Did this article help you?

COPYRIGHT © COMPLYFILE LTD 2015. ALL RIGHTS RESERVED

Knowledge Base Software powered by Helpjuice