Visual Guide to Missionary Data
The diagram and definitions below will be used to help clarify the data migration that links Missionary data columns to site content and how it will look when filled out correctly.
**Full Page View
**
**Summary View
**
****URL Match for Social Links
**
**
****Text three is window tab name
**
*
**Image View in content explorer
**
**Image View matched to live site
**
Below is a table with the descriptions of each field and the fields required for importing along with examples. Reminder: Any bold items are required!
Column Name
Type
Size
Required
Notes
Example
string
100
Yes
The item name that will be seen in the admin interface
Africa Campaign
ContentItem.alias
string
100
No
Lowercase characters, numbers and dashes are accepted. If this is not passed a converted version of ContentItem.name will be used
africa-campaign
ContentItem.external_id
string
50
Yes
Record's ID from the external data source. Also known as the Campaign External ID
PRJ-01
ContentItem.publish_datetime
datetime
No
Should be passed in the format Y-m-d H:i:s
2015-01-25 16:30:00
ContentItem.unpublish_datetime
datetime
No
Should be passed in the format Y-m-d H:i:s
2015-03-31 00:00:00
ContentItem.is_searchable
boolean
1
No
Determines if the item will be indexed for search. Acceptable values are 0 and 1, with 1 being that it is able to be indexed and 0 for being non-indexed
1
ContentItem.external_person_id
string
50
No
This is the ID passed from the Person/Group data map to the 'external_id'
PERSON-01
ContentItem.external_person_is_group
boolean
1
No
Set this to 1 for linking with a people group record, or 0 to not link to a people group record
0
ContentItem.content_folder_id
integer
11
No
ID of the SiteStacker content folder (only pass if you want to override the default)
12
ContentItem._use_content_folder_defaults
boolean
1
No
Use this to merge the content folder defaults with the data
1
integer
11
No
ID of the SiteStacker Workflow Stage (only pass if you want to override the default)
3
text_one
string
300
Yes
This is the primary text that will be first to display (Ex: First Name)
Africa
text_two
string
300
Yes
This is the secondary text that will be displayed next (Ex: Last Name)
Campaign
image_one
string
1000
No
(Multi-Field: Use |#| separator for multiple values)
url_one
string
300
No
First Social Media URL
url_two
string
300
No
Second Social Media URL
url_three
string
300
No
Third Social Media URL
url_four
string
300
No
Fourth Social Media URL
url_fife
string
300
No
Fifth Social Media URL
url_six
string
300
No
Sixth Social Media URL
url_seven
string
300
No
Seventh Social Media URL
geo_location.location
text
No
Determine the specified location of the content item you are importing
geo_location.latitude
float
No
This determines your specific location's latitude
geo_location.longitude
float
No
This determines your specific location's longitude
text_area_one
text
No
This is the initial summary text that will not be seen on the Full View page
text_area_two
text
No
This is the body text that will be seen on the Full View page
image_two.url
string
300
No
This is the URL of your second image
image_two.alt_text
string
300
No
This field will apply alt text to your image, which is great for SEO purposes
image_two.brightness
integer
11
No
This field adjusts the brightness of the image you chose
image_two.contrast
integer
11
No
This field adjusts the contrast of the image you chose
image_two.position_h
string
300
No
This adjusts the horizontal position of the image you choose
image_two.position_v
string
300
No
This adjusts the vertical position of the image you choose
ContributionCampaign.goal_amount
decimal
10,2
No
The goal amount for this campaign
25000.00
ContributionCampaign.min_amount
decimal
10,2
No
The minimum amount that can be donated towards this campaign
5.00
ContributionCampaign.max_amount
decimal
10,2
No
The maximum amount that can be donated towards this campaign
1000.00
ContributionCampaign.start
date
No
Start date of this campaign. Should be passed in the format Y-m-d H:i:s
2015-01-15
ContributionCampaign.end
date
No
End date of this campaign. Should be passed in the format Y-m-d H:i:s
2016-01-15
ContributionCampaign.accounting_code
string
50
No
Reserved for Virtuous integration
ContributionCampaign.inventory_status
string
50
No
Reserved for Virtuous integration
ContributionCampaign.show_extra_field
boolean
1
No
Flag to enable the extra data field for this campaign. 0=Do Not Show 1=Show
1
ContributionCampaign.extra_field_label
string
100
No
Label for the extra data field
Missionary Name
ContributionCampaign.extra_field_is_required
boolean
1
No
Determines if the extra data field should be required. 0=Not Required 1=Required
1
ContributionCampaign.allow_multiple_in_cart
boolean
1
No
Determines if the system should allow the user to have multiple gifts towards this campaign in the same batch
0
ContributionCampaign.is_disabled
boolean
1
No
Determines if the campaign should allow donations
1
Updated on: 13/04/2026
Thank you!