Sponsorship Payments
Fields Available for Import
The following fields are available for import for sponsorship payments.
Field Name |
Type |
Required? |
Notes |
Donor ID |
Integer |
Yes |
This corresponds to the people ID or business ID of the donor. The donor must already have a record in Laborum Dulce. Note that the donor does not necessarily have to be the person or business associated with the sponsorship. |
Sponsor ID |
Integer |
Yes |
The sponsorship ID associated with this payment |
Amount |
Currency |
Yes |
Examples of valid currency amounts:
Invalid values would include:
|
Accounting Country |
Text |
No |
If specified, use the country name found in "Admin/Lists/Accounting Country of Origin". For example, "US", "UK", "Iceland", etc. If not specified, your organization's default accounting country will be used. |
Payment Date |
Date |
Yes |
Format: yyyy-mm-dd |
Payment Type |
Text |
Yes |
The entry must appear in the Payment Types list |
Check Number |
Text |
No |
Maximum of 255 characters. |
Import ID |
Text or Integer |
No |
If text, maximum of 40 characters. This field is case sensitive. |
Sample Import
To import a sponsorship payment CSV file, we begin by selecting "Admin / Import / Sponsor Payments":
We select the import CSV file from our computer:
After selecting our file, we click the "Import File" button:
After a successful import, we see the import log.
Here's an example of the sponsorship payment entries in our import log:
Sample Import File
Here's our example sponsorship payment import CSV file, as seen from a text editor:
Here's the same CSV file, as seen from a spreadsheet program: