Importing Sponsorships | Pure Charity Development

Preparing the Sponsorship Program

The base for importing sponsorships includes a sponsorship program to group them together. Remember, nothing is visible to the public until you review your entire program and publish it. All sponsorship programs will ask for the following information:

Sponsorship Program Title – This is the name of your sponsorship program

Sponsorship Program URL – The preferred URL on purecharity.com (example: http://purecharity.com/[custom-url-here])

Sponsorship Program Reference – This is the internal tracking code you will use.

Call to Action – 6 or 7 words (max 60 characters)

Description – Short description of the sponsorship program. This field is 250 characters or about 2 tweets.

Avatar & Widget Image

Maximum file size: 5MB
File types: JPEG, PNG, GIF, or BMP

Adding Sponsorships

Adding images

All images are automatically centered when they are uploaded. To make sure the images are centered when displayed use photo editing software to modify the size so that the focal point is directly in the middle of the image.

—

File format

A zip file is expected, with the following structure inside:

images
image_1.jpg
image_2.jpg
…
sponsorships.csv
sponsorships.csv is a standard CSV file with headers.

Verifying data

Prior to uploading, open the file in Google Spreadsheets or Open Office and check the data as follows:

FullName

The column FullName should be filled in in all lines.

PledgeType

All lines should be filled in with ‘child’.

Number of Sponsorships

If this column is present and if there’s a number greater than 0 in this column, contact the development team via help@purecharity.com to verify that all the records should be imported.

Birthdate

If there is already an Age column, that is ignored by our importer. The Age column can be used however to “calculate” a date of birth for each child. This formula Google Spreadsheet formula works with the following:

=CONCAT(“01/01/”, 2015-AGE)
Remember to replace AGE by the actual cell that has the age info.

ImageFileName

Make sure that the image names are clear of typos, wrong extensions, files that don’t exist. The image names are case sensitive and if there is any difference in the structure of the image file name the file will not be uploaded.