Answers.Body: <p>Take a look at Fuzion's <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport" rel="nofollow noreferrer">API import extension</a> if you need an import option that goes beyond the standard Import options. It may not help directly with the volunteer data that goes in the civicrm_volunteer_ tables, but could help with other stuff, like Activities and Relationships.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T00:44:46.820Z
Answers.Text: Thanks. I'm having a look. However, it doesn't make clear how to import volunteer data. Now I'm still learning CiviCRM, so maybe there's something I haven't worked out yet.
  
  I still can't quite work out how to map my data to the relevant fields.
  
  As a side note, I have some of the people volunteering for multiple jobs. I tried making the import field "job1|job2" but I'm not sure that's going to work to import two jobs....
Answers.UserDisplayName: Norman Cates
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T03:38:47.753Z
Answers.Text: Hi Norman - sorry I haven't used CiviVolunteer so can't really comment on the data structure involved, so it could be that the above does not actually get you a step ahead. I see that civivol sets up tables called civicrm_volunteer_need civicrm_volunteer_project and civicrm_volunteer_project_contact. If you are familiar with sql then you could potentially do the required via an sql import once you have set up the Projects via the UI
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-18T17:59:03.567Z
Answers.LastActivityDate: 2017-10-19T03:39:50.587Z
Answers.LastEditDate: 2017-10-19T03:39:50.587Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>CiviCRM 4.7.24
  Wordpress 4.8.x
  CiviVolunteer </p>
  
  <p>I have installed CiviVolunteer. I have created a project which I need in order to import some basic volunteer data from a spreadsheet.</p>
  
  <p>I have imported the contacts already, and have a unique ID to match them back with the rest of the data.</p>
  
  <p>Now I need to import the volunteer data. There's not really too much. </p>
  
  <p>From what I can glean from the pretty sparse documentation, you have to import the volunteer information as an activity. But there's no indication of what fields in the import list correspond to. </p>
  
  <p>Do some of them correspond to the project I created above? Or are they their own thing?</p>
  
  <p>I haven't seen any documentation about projects joining to activities and how they all link up. </p>
  
  <p>Is this something i might be able to find in the CiviCRM API Explorer?</p>
  
  <p>Thanks!</p>
  
Tags: <civivolunteer>
Title: How can I import Volunteer information from a spreadsheet
ThreadText: # How can I import Volunteer information from a spreadsheet
  
  (Asked by: username_0 on 2017-10-18)
  
  CiviCRM 4.7.24
  Wordpress 4.8.x
  CiviVolunteer
  
  I have installed CiviVolunteer. I have created a project which I need in order to import some basic volunteer data from a spreadsheet.
  
  I have imported the contacts already, and have a unique ID to match them back with the rest of the data.
  
  Now I need to import the volunteer data. There's not really too much.
  
  From what I can glean from the pretty sparse documentation, you have to import the volunteer information as an activity. But there's no indication of what fields in the import list correspond to.
  
  Do some of them correspond to the project I created above? Or are they their own thing?
  
  I haven't seen any documentation about projects joining to activities and how they all link up.
  
  Is this something i might be able to find in the CiviCRM API Explorer?
  
  Thanks!
  
  **Tags:** civivolunteer
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-10-18. Score: 1
  
  Take a look at Fuzion's [API import extension](https://github.com/eileenmcnaughton/nz.co.fuzion.csvimport) if you need an import option that goes beyond the standard Import options. It may not help directly with the volunteer data that goes in the civicrm\_volunteer\_ tables, but could help with other stuff, like Activities and Relationships.
  
  > **Comments:**
  > **username_0**: Thanks. I'm having a look. However, it doesn't make clear how to import volunteer data. Now I'm still learning CiviCRM, so maybe there's something I haven't worked out yet.  I still can't quite work out how to map my data to the relevant fields.  As a side note, I have some of the people volunteering for multiple jobs. I tried making the import field "job1|job2" but I'm not sure that's going to work to import two jobs....  
  > **username_1**: Hi Norman - sorry I haven't used CiviVolunteer so can't really comment on the data structure involved, so it could be that the above does not actually get you a step ahead. I see that civivol sets up tables called civicrm_volunteer_need civicrm_volunteer_project and civicrm_volunteer_project_contact. If you are familiar with sql then you could potentially do the required via an sql import once you have set up the Projects via the UI  
  
  ---
  
  