Possible JSON configuration for Bespoke

gistfile1.js

  {
    "index": {
      "student_personal":   ["ref_id"],
      "student_personal":   ["ref_id"],
      "staff_personal":     ["ref_id"],
      "school_course_info": ["ref_id"],
      "section_info":       ["ref_id"],
      "term_info":          ["ref_id"],
      "school_info":        ["ref_id"],
      "student_section_enrollment":
        ["student_personal_ref_id", "section_info_ref_id"]
    },
    "export": {
      "users": [
        {
          "student_personal": {
            "fields": {
              "user_id":    "{{student_personal.local_id}}",
              "login_id":   "{{student_personal.username}}",
              "password":   "{{student_personal.password}}",
              "first_name": "{{student_personal.name.first_name}}",
              "last_name":  "{{student_personal.name.last_name}}",
              "email":      "{{student_personal.email}}",
              "status":     "active"
            }
          }
        },
        {
          "staff_personal": {
            "fields": {
              "user_id":    "{{staff_personal.ref_id}}",
              "login_id":   "{{staff_personal.username}}",
              "password":   "",
              "first_name": "{{staff_personal.name.first_name}}",
              "last_name":  "{{staff_personal.name.last_name}}",
              "email":      "{{staff_personal.email}}",
              "status":     "active"
            }
          }
        }
      ],
      "courses": [
        {
          "section_info": {
            "fields": {
              "course_id":  "{{section_info.local_id}}",
              "short_name": "{{section_info.schedule_infos.first.first_meeting_time.expression}}-{{{school_course_info.course_title}}}-Course-{{school_course_info.course_code}}-{{staff_personal.name.last_name}}",
              "long_name":  "{{section_info.schedule_infos.first.first_meeting_time.expression}}-{{{school_course_info.course_title}}}-Course-{{school_course_info.course_code}}-{{staff_personal.name.last_name}}",
              "account_id": "{{school_course_info.school_info_ref_id}}",
              "term_id":    "{{section_info.term_info_ref_id}}",
              "start_date": "{{term_info.start_date}}",
              "end_date":   "{{term_info.end_date}}",
              "status":     "active"
            },
            "joins": {
              "term_info": "term_info_ref_id",
              "school_course_info": "school_course_info_ref_id",
              "staff_personal": "teacher"
            }
          }
        }
      ]
    }
  }