{"text_format":"2","workbook":"xlsx","n_sheets":15,"sheets":["Migration Template (INFO)","Schools info","Department Info","Course Type Info","Course Info","Student Info","Student History Log","Team Info","Tags Info","Faculty info","Opportunities","Volunteer Coordinators","Programs","Org Info","Partner Opportunities"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":11,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Migration Template (INFO)","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Introduction"]
[null,null,"This Excel workbook describes the Fundly Connect's migration template for universities."]
[null,null,"If you provide the data that you want to migrate into Fundly Connect by using the columns from the templates that will make the migration much smoother!"]
[null,null,"If your data is in a different format then it will take us longer to migrate and may be more costly."]
[null,null,"You can use whichever templates best match your data and then modify them by adding or deleting columns as needed for your specific situation."]
[]
["Tabs","This file contains the following tabs:"]
[]
[]
[null,"Schools Information"]
[null,"Departments Information"]
[null,"Course Type Information"]
[null,"Course Information"]
[null,"Student Information"]
[null,"Student History Log"]
[null,"Team Information"]
[null,"Tags Information"]
[null,"Faculty Information"]
[null,"Opportunities"]
[null,"Student Coordinators"]
[null,"Programs"]
[null,"Organization Information"]
[null,"Partner Opportunities"]
[]
[null,"Volunterr"]
[]
["Migration file worksheet format",null,"The migration file can be in one or more Excel spreadsheets or .CSV files.  (If using .CSV, be sure that any columns that could have commas in them are delimited by quotes so we can determine the number of fields properly like \"123 Anystreet, Apartment #24\" so we don't end up with Apartment #24 in a new field instead of as part of the address.)",null,"Column Requirements: "]
[{"$nulls":4},"Mandatory","Fields are required to Migrate data to Fundly Connect. Without data in the required fields, certain data may not get migrated"]
[null,"Rows","The top row of the migration file contains the heading for the data in that column.  ",null,"Typical"," Fields are data fields that are frequently used by Non-Profits migrating data to Fundly Connect"]
[null,null,"For your convenience, we also indicate the priority of each column in row 2.  You can delete that row or we will do it for you.",null,"Typical \n*(Config Required)","Additional Values may be required for configuration (added) if they are not standard within Fundly Connect. If the values provided in the columns are not standard and not configured prior to migration, they will not be successfully transfered."]
[null,null,"All subsequent rows contain the data to migrate.",null,"Seldom","Fields are seldomly used by Non-Profits when migrating to Fundly Connect"]
[{"$nulls":4},"Seldom\n*(Config Required)","Additional Values may be required for configuration (added) if they are not standard within Fundly CRM. If the values provided in the columns are not standard and not configured prior to migration, they will not be successfully transfered."]
[null,"Column Headings","We prefer to receive migration data with the columns and column headings that we have provided.  If you must use other columns then it will take us longer to determine how to map the data."]
[]
[null,"Column Values","You must supply values in the the Mandatory columns.  Other columns are optional.  For example, if you are not migrating donations then you do not need to include those columns.  Further, you can include the optional columns but have empty values in the cells."]

{"sheet":"Schools info","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Schools Configuration ->","School Name","Status\nACTIVE/INACTIVE"]
[null,"Typical","Typical"]

{"sheet":"Department Info","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Department Configuration ->","Department Name","School Name","Status ACTIVE/INACTIVE"]
[null,"Mandatory","Typical","Typical"]

{"sheet":"Course Type Info","index":3,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Course Type Configuration ->","Course Type Name (e.g. Service Learning, Academic Internship, etc)","Status ACTIVE/INACTIVE"]
[null,"Typical","Typical"]

{"sheet":"Course Info","index":4,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Course Configuration ->","Course Name","Course #","Associate Organization\n(CSV if Multiple values)","Course Type\n(CSV if Multiple values)","Department","Start Date","End Date","Course Description","Faculty\n(CSV if Multiple values)","Status ACTIVE/INACTIVE"]
[null,"Mandatory","Mandatory","Typical","Typical *Config Required","Mandatory","Mandatory","Typical","Typical","Typical","Typical"]

{"sheet":"Student Info","index":5,"n_rows":2,"n_cols":87,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Student Information ->","External Contact ID","Prefix","First Name","Last Name","Suffix","Gender:\n- Male\n- Female\n-Other","Birth Date:\nmm/dd/yyyy","Nickname","Joining Date","Status \nActive/Inactive","Email #1","Email #1 \nType: \n-Personal \n-Work","Email #1 is Primary?\nTRUE/FALSE","Email #2","Email #2 \nType: \n-Personal \n-Work","Email #2 is Primary?\nTRUE/FALSE","Phone #1","Phone #1 \nType: \n-Work\n-Home\n- Mobile\n- Fax\n- Other","Phone #1 is Primary?\nTRUE/FALSE","Phone #2","Phone #2 \nType: \n-Work\n-Home\n- Mobile\n- Fax\n- Other","Phone #2 is Primary?\nTRUE/FALSE"," Mailing - Address Line 1"," Mailing - Address Line 2"," Mailing - Country","Mailing - Zip/Postal Code","Mailing - City","Mailing - County","Mailing - State"," Other - Address Line 1"," Other - Address Line 2"," Other - Country","Other - Zip/Postal Code","Other - City","Other - County","Other - State","Communication Preference - Send Email TRUE/FALSE","Additional Student Information ->","Courses\n(CSV if Multiple values)","Causes\n(CSV if Multiple values)","Skills\n(CSV if Multiple values)","Comments","Tags\n(CSV if Multiple values)","Associated Team","Programs\n(CSV if Multiple values)","Custom Data Set","Custom Data Set 2","Emergency Contact Information ->","Emergency Contact \nFirst Name","Emergency Contact \nLast  Name","Emergency Contact \nEmail","Emergency Contact Mobile Phone","Emergency Contact \nStreet Address","Emergency Contact \nZip/Postal Code","Emergency Contact \nCity","Emergency Contact \nState","Emergency Contact \nCountry","Social Media\n->","Social Media Type:\n-Facebook\n-Twitter\n-Google+\n-LinkedIn\n-Instagram","URL","Search Preferences\n->","Distance: \n-Any\n-Within 5 miles -Within 10 miles -Within 20 miles -Within 50 miles","Organization/s","Program/s","Availability","Student ","Skills","Activity Type","Appropriate for what age group","Serving what age group","Serving what gender","Serving what group of people","Student Opportunity\n->","Opportunity/ Activity Name","Organization Name","Application Status:\n- Approved\n- Pending","Organization Programs","Venue","Shift","Position","Shift Start Date\n(mm/dd/yyyy)","Shift End Date\n(mm/dd/yyyy)","Shift  Start Time\n(00:00)","Shift End Time\n(00:00)","# of Verified Hours","# of Unverified Hours"]
[null,"Typical","Seldom","Mandatory","Mandatory","Seldom","Typical","Typical","Seldom","Typical","Typical","Typical","Typical","Typical ","Typical ","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom",null,"Typical","Seldom","Seldom","Seldom","Seldom\n*(Config Required)","Seldom\n*(Config Required)","Seldom\n*(Config Required)","Seldom\n*(Config Required)","Seldom\n*(Config Required)",null,"Typical","Typical","Typical","Typical","Seldom","Seldom","Seldom","Seldom","Seldom",null,"Seldom","Seldom",null,"Seldom","Typical","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom",null,"Mandatory","Mandatory","Mandatory","Seldom","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical"]

{"sheet":"Student History Log","index":6,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Student Hours Log ->","Opportunity/Activity","Location","Shift","Position","Student Contact ID","Student/Team (First) Name","Student Last Name","Email","Shift Start Date\n(mm/dd/yyyy)","Shift End Date\n(mm/dd/yyyy)","Shift  Start Time\n(00:00)","Shift End Time\n(00:00)","# of Verified Hours","# of Unverified Hours"]
[null,"Mandatory","Typical","Typical","Typical","Typical","Mandatory","Mandatory","Typical","Mandatory","Mandatory","Typical","Typical","Typical","Typical"]

{"sheet":"Team Info","index":7,"n_rows":2,"n_cols":55,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Team Information ->","External Contact ID","Team Name","Approximate Team Size","Team Type","Team Captain First Name","Team Captain Last Name","Team Captain Email","Team Captain Mobile Number"," Team Captain Address Line 1"," Team Caption Address Line 2"," Team Captain Country"," Team Captain Zip/Postal Code"," Team Captain City","Team Captain County","Team Captain State","Team Co-Captain First Name","Team Co-Captain Last Name","Team Co-Captain Email","Joining Date","Status \nActive/Inactive","Additional Team Information ->","Causes","Search Preferences\n->","Distance: \n-Any\n-Within 5 miles -Within 10 miles -Within 20 miles -Within 50 miles","Organization/s","Program/s","Availability","Causes","Skills","Activity Type","Appropriate for what age group","Serving what age group","Serving what gender","Serving what group of people","Team Members\n->","Member First Name\n(CSV if Multiple values)","Member Last Name\n(CSV if Multiple values)","Member Email\n(CSV if Multiple values)","Member Mobile No.\n(CSV if Multiple values)","Create Member User Account\n(CSV if Multiple values)","Team Opportunity\n->","Opportunity/ Activity Name","Organization Name","Application Status:\n- Approved\n- Pending","Organization Programs","Venue","Shift","Position","Shift Start Date\n(mm/dd/yyyy)","Shift End Date\n(mm/dd/yyyy)","Shift  Start Time\n(00:00)","Shift End Time\n(00:00)","# of Verified Hours","# of Unverified Hours"]
[null,"Typical","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical",null,"Seldom",null,"Seldom","Typical","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom","Seldom",null,"Mandatory","Mandatory","Mandatory","Mandatory","Mandatory",null,"Mandatory","Mandatory","Mandatory","Seldom","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical"]

{"sheet":"Tags Info","index":8,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Tags Information ->","Tag Name"]
[null,"Seldom"]

{"sheet":"Faculty info","index":9,"n_rows":2,"n_cols":40,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Faculty Information ->","External Contact ID","Prefix","First Name","Last Name","Suffix","Title","Department","Note","Gender:\n- Male\n- Female\n-Other","Birth Date:\nmm/dd/yyyy","Nickname","Joining Date","Status \nActive/Inactive","Email #1","Email #1 \nType: \n-Personal \n-Work","Email #1 is Primary?\nTRUE/FALSE","Email #2","Email #2 \nType: \n-Personal \n-Work","Email #2 is Primary?\nTRUE/FALSE","Phone #1","Phone #1 \nType: \n-Work\n-Home\n- Mobile\n- Fax\n- Other","Phone #1 is Primary?\nTRUE/FALSE","Phone #2","Phone #2 \nType: \n-Work\n-Home\n- Mobile\n- Fax\n- Other","Phone #2 is Primary?\nTRUE/FALSE"," Mailing - Address Line 1"," Mailing - Address Line 2"," Mailing - Country","Mailing - Zip/Postal Code","Mailing - City","Mailing - County","Mailing - State","Communication Preference - Send Email TRUE/FALSE","Additional Faculty Information ->","Courses\n(CSV if Multiple values)","Causes\n(CSV if Multiple values)","Skills\n(CSV if Multiple values)","Comments","Tags\n(CSV if Multiple values)"]
[null,"Typical","Seldom","Mandatory","Mandatory","Seldom","Mandatory","Seldom","Seldom","Typical","Typical","Seldom","Typical","Typical","Typical","Typical","Typical ","Typical ","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Seldom",null,"Typical","Seldom","Seldom","Seldom","Seldom\n*(Config Required)"]

{"sheet":"Opportunities","index":10,"n_rows":2,"n_cols":47,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Opportunity Information\n->","1. Basic Info. ","External \nOpportunity  ID","Status\nActive/Inactive","Opportunity Name","Opportunity Owner (Users)","Virtual Opportunity"," Address Line 1"," Address Line 2"," Zip/Postal Code"," City"," State"," Country","Program (s)","Position(s)","Opportunity Details","Published/ Not Published","2. University Info","Opportunity Type\n(CSV for Multiple values)","Course\n(CSV for Multiple values)","CNCS Funded","3. Requirements","Keywords","Causes","Skills","Activity Type","Student can schedule for this opportunity","Display on Public Calendar","Student can log hours for this opportunity","Auto Log Hours When Marked As Attended","Approval required for student application","Background check required for student?","Is this a Paid internship?","Orientation and/or training is required before student can work","Who will benefit from this opportunity:\nAge group","Who will benefit from this opportunity:\nPopulation","Who will benefit from this opportunity:\nGender","Appropriate for which type of student: Age group","4. Scheduling and Shift","Venue","Shift","Position","Shift Start Date\n(mm/dd/yyyy)","Shift  Start Time\n(00:00)","Shift End Date\n(mm/dd/yyyy)","Shift End Time\n(00:00)","Frequency"]
[null,null,"Typical","Mandatory","Mandatory","Mandatory","Typical","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Typical","Mandatory","Typical","Mandatory",null,"Mandatory\n*(Config Required)","Typical","Typical",null,"Typical","Mandatory","Typical","Typical","Typical","Typical","Typical","Seldom","Typical","Seldom","Typical","Seldom","Seldom","Seldom","Seldom","Seldom",null,"Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory"]

{"sheet":"Volunteer Coordinators","index":11,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Student Coordinator Information\n->","Student Coordinator First Name","Student Coordinator Last Name","Student Coordinator Email","User/Student","Opportunity Name","Opportunity Venue","Coordinating Start Date","Coordinating End Date"]
[null,"Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory"]

{"sheet":"Programs","index":12,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Program Information\n->","Program Name","Active / Inactive"]
[null,"Mandatory","Mandatory"]

{"sheet":"Org Info","index":13,"n_rows":2,"n_cols":39,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Organization Information\n->","Organization Name","Organization EIN","Organization Website","Contract Date","Renewal Date"," Address Line 1"," Address Line 2"," Zip/Postal Code"," Country"," City","County"," State","Organization Type\n- NonProfit\n- Corporation\n- Faith Based\n- School \n- Civic Organization\n- Foundation\n- Government Organization","Email #1","Email #1 \nType: \n-Personal \n-Work","Email #1 is Primary?\nTRUE/FALSE","Email #2","Email #2 \nType: \n-Personal \n-Work","Email #2 is Primary?\nTRUE/FALSE","Phone #1","Phone #1 \nType: \n-Work\n-Home\n- Mobile\n- Fax\n- Other","Phone #1 is Primary?\nTRUE/FALSE","Phone #2","Phone #2 \nType: \n-Work\n-Home\n- Mobile\n- Fax\n- Other","Phone #2 is Primary?\nTRUE/FALSE","Mission Statement","Additional Note","Organization Program(s)","Causes","Custom Data Set","Custom Data Set 2","Primary Contact Info ->","First Name","Last Name","Job TItle","Email","Phone","Phone\nType: \n-Work\n-Home\n- Mobile\n- Fax\n- Other"]
[null,"Mandatory","Typical","Typical","Seldom","Seldom","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Typical","Mandatory","Mandatory","Mandatory","Typical ","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Typical","Seldom","Seldom\n*(Config Required)","Seldom\n*(Config Required)","Seldom\n*(Config Required)","Seldom\n*(Config Required)",null,"Mandatory","Mandatory","Typical","Mandatory","Typical","Typical"]

{"sheet":"Partner Opportunities","index":14,"n_rows":2,"n_cols":26,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Partner Opportunity Information\n->","Opportunity Name","Partner Organization/Faculty Name","Opportunity Owner (Users)","Virtual Opportunity"," Address Line 1"," Address Line 2"," Zip/Postal Code"," City"," State"," Country","Opportunity Details","Organization Program","Causes","Approved/ Pending","Published/ Not Published","Active/Inactive","Scheduling and Shift\n->","Venue","Shift","Position","Shift Start Date\n(mm/dd/yyyy)","Shift  Start Time\n(00:00)","Shift End Date\n(mm/dd/yyyy)","Shift End Time\n(00:00)","Frequency"]
[null,"Mandatory","Mandatory","Mandatory","Typical","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Typical","Seldom\n*(Config Required)","Mandatory","Mandatory","Mandatory","Mandatory",null,"Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory","Mandatory"]