|
Welcome Best Buddies Friendship Programs Staff! The Kintera and Friendship Programs Departments have joined forces to create a spreadsheet that you can enter all of your Membership Applications into, which can then be submitted for import into the Kintera Database. Included on this webpage is all you need to know about properly completing and submitting the Participation Spreadsheet Template, as well as the link to download the latest version of the Participation Spreadsheet Template. Before you begin entering your Membership Applications, be sure to return to this webpage to download the latest version of the Participation Spreadsheet Template!
If you have more than 20 Membership Applications that you would like entered into Kintera, and you feel it would be easier for you to enter them into a spreadsheet instead of entering them directly into Kintera, then you should use the Participation Spreadsheet Template. The Database Administrator will not accept spreadsheets of less than 20 rows. For illustrated instructions on how to enter Membership Applications directly into Kintera, click the link below. How to enter program participant info into Kintera What should I do before entering my Membership Applications in the Participation Spreadsheet Template? Before entering your Membership Applications in the Participation Spreadsheet Template, it is recommended that you run a report on the Membership Applications for your chapter(s) that have already been entered into Kintera. By doing this, you can avoid creating duplicate entries. For illustrated instructions on how to look up your existing Membership Applications in Kintera, click the link below. *Remember: when searching for multiple Regions / School Names or Participation Years, use the "Contains Any Of" filtering option and separate your choices with commas.
1. Right click the link below. 2. Select "Save Target As..." 3. Use the pop-up window to select where your template will be saved. 4. Open the file in Excel. 5. Enter your Membership Applications using the guidelines below. 6. E-mail the completed spreadsheet to danielblair@bestbuddies.org for import (allow at least one month for importing). Participation Spreadsheet Template
Best Buddies Grammar Guidelines 1. Building numbers or floors that are single-digit numerals should be written out.
2. All address directionals and street names should be written out. 3. The exception to Grammar Guideline #2 is in Washington D.C., where the directional is addreviated and comes at the end of the address line, but the street name should still be written out. 4. When writing numbers, do not add "th", "rd" or "st". 5. When writing floor numbers, include "th", "rd" or "st". 6. Apartment numbers should be written as "No. 123" on the first address line, unless it is a alphabetical apartment number - which should be written as "Unit ABC". 7. Suite numbers, Floor numbers and Apartment numbers should be written on the first address line. What do I do if I have contacts to be imported to Kintera but they're not in the Friendship Programs? If you need a large number of contacts entered into Kintera that are not related to the Friendship Programs, you can use the same Grammar Guidelines listed above to complete and submit a spreadsheet template similar to the Participation Spreadsheet Template. The template you'll want to use for non-Programs? contacts is called the General Contact Spreadsheet Template.
If you have more than 20 contacts that you would like entered into Kintera, and you feel it would be easier for you to enter them into a spreadsheet instead of entering them directly into Kintera, then you should use the General Contact Spreadsheet Template. The Database Administrator will not accept spreadsheets of less than 20 rows. For illustrated instructions on how to enter general contacts directly into Kintera, click the link below. How to add contacts to Kintera
1. Right click the link below. 2. Select "Save Target As..." 3. Use the pop-up window to select where your template will be saved. 4. Open the file in Excel. 5. Enter your Membership Applications using the guidelines below. 6. E-mail the completed spreadsheet to danielblair@bestbuddies.org for import (allow at least one month for importing), with instructions on how the entire spreadsheet should be Segmented in Kintera. |