Visual Guide to Project Data Import

This visual guide links Projects data import columns to site positions.

Full Page View

Summary View

URL Match for Social Links







Column NameTypeSizeRequiredNotesExample
ContentItem.namestring100YesThe item name that will be seen in the admin interfaceAfrica Campaign
ContentItem.aliasstring100NoLowercase characters, numbers and dashes are accepted. If this is not passed a converted version of ContentItem.name will be usedafrica-campaign
ContentItem.external_idstring50YesRecord's ID from the external data sourcePRJ-01
ContentItem.publish_datetimedatetimeNoShould be passed in the format Y-m-d H:i:s2015-01-25 16:30:00
ContentItem.unpublish_datetimedatetimeNoShould be passed in the format Y-m-d H:i:s2015-03-31 00:00:00
ContentItem.is_searchableboolean1NoDetermines if the item will be indexed for search. Acceptable values are 0 and 11
ContentItem.external_person_idstring50NoID that was passed to 'external_id' in the Person/Group data mapPERSON-01
ContentItem.external_person_is_groupboolean1NoSet this to 1 for linking with a people group record0
ContentItem.content_folder_idinteger11NoID of the SiteStacker content folder (only pass if you want to override the default)12
ContentItem._use_content_folder_defaultsboolean1NoUse this to merge the content folder defaults with the data1
WorkflowStage.idinteger11NoID of the SiteStacker Workflow Stage (only pass if you want to override the default)3
text_onestring300NoName of the project
image_onestring1000NoSummary view image (Multi-Field: Use |#| separator for multiple values)
url_onestring300NoFacebook link
url_twostring300NoTwitter link
url_threestring300NoYouTube link
url_fourstring300NoInstagram link
url_fifestring300NoLinkedin link
url_sixstring300NoVimeo link
url_sevenstring300NoMissionary website URL
geo_location.locationtextNo
geo_location.latitudefloatNo
geo_location.longitudefloatNo
text_area_onetextNoSummary text for the project
text_area_twotextNoFull detail page description for the project
image_two.urlstring300No
image_two.alt_textstring300No
image_two.brightnessinteger11No
image_two.contrastinteger11No
image_two.position_hstring300No
image_two.position_vstring300No
ContributionCampaign.goal_amountdecimal10,2NoThe goal amount for this campaign25000.00
ContributionCampaign.min_amountdecimal10,2NoThe minimum amount that can be donated towards this campaign5.00
ContributionCampaign.max_amountdecimal10,2NoThe maximum amount that can be donated towards this campaign1000.00
ContributionCampaign.startdateNoStart date of this campaign. Should be passed in the format Y-m-d H:i:s2015-01-15
ContributionCampaign.enddateNoEnd date of this campaign. Should be passed in the format Y-m-d H:i:s2016-01-15
ContributionCampaign.accounting_codestring50NoReserved for Virutous integration
ContributionCampaign.inventory_statusstring50NoReserved for Virutous integration
ContributionCampaign.show_extra_fieldboolean1NoFlag to enable the extra data field for this campaign. 0=Do Not Show 1=Show1
ContributionCampaign.extra_field_labelstring100NoLabel for the extra data fieldMissionary Name
ContributionCampaign.extra_field_is_requiredboolean1NoDetermines if the extra data field should be required. 0=Not Required 1=Required1
ContributionCampaign.allow_multiple_in_cartboolean1NoDetermines if the system should allow the user to have multiple gifts towards this campaign in the same batch0
ContributionCampaign.is_disabledboolean1NoDetermines if the campaign should allow donations1

Modified on Tue, 19 Sep, 2023 at 10:17 AM

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

Make sure these features are added to your Site Stacker installation by learning how to run updates here!