INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('2,,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Organizer,'f_programe_year'=>'required','f_programe_name_eng'=>'required','f_programe_name_th'=>'required','f_programe_name_initials'=>'required','f_programe_school'=>'required','f_programe_branch'=>'required','f_programe_level'=>'required','f_programe_plan'=>'required','f_programe_normal_year'=>'required','f_programe_max_year'=>'required','f_programe_calender'=>'required','f_programe_status'=>'required',,user=>user_meta(user_userid|user_fullname),INSERT INTO m_programe (f_programe_year,f_programe_name_eng,f_programe_name_th,f_programe_name_initials,f_programe_school,f_programe_branch,f_programe_level,f_programe_plan,f_programe_normal_year,f_programe_max_year,f_programe_calender,f_programe_status) VALUES ('$f_programe_year$','$f_programe_name_eng$','$f_programe_name_th$','$f_programe_name_initials$','$f_programe_school$','$f_programe_branch$','$f_programe_level$','$f_programe_plan$','$f_programe_normal_year$','$f_programe_max_year$','$f_programe_calender$','$f_programe_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('3,,Queue,maxrow:100,maxcolumn:50,import_temptable,Import School and Program,'f_programe_year'=>'required','f_programe_name_eng'=>'required','f_programe_name_th'=>'required','f_programe_name_initials'=>'required','f_programe_school'=>'required','f_programe_branch'=>'required','f_programe_level'=>'required','f_programe_plan'=>'required','f_programe_normal_year'=>'required','f_programe_max_year'=>'required','f_programe_calender'=>'required','f_programe_status'=>'required',,,INSERT INTO m_programe (f_programe_year,f_programe_name_eng,f_programe_name_th,f_programe_name_initials,f_programe_school,f_programe_branch,f_programe_level,f_programe_plan,f_programe_normal_year,f_programe_max_year,f_programe_calender,f_programe_status) VALUES ('$f_programe_year$','$f_programe_name_eng$','$f_programe_name_th$','$f_programe_name_initials$','$f_programe_school$','$f_programe_branch$','$f_programe_level$','$f_programe_plan$','$f_programe_normal_year$','$f_programe_max_year$','$f_programe_calender$','$f_programe_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('4,Campus,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Campus,'campus_name'=>'required','campus_date'=>'required','campus_university'=>'required','campus_score'=>'required','campus_detail'=>'required',,,INSERT INTO campus (campus_name,campus_date,campus_university,campus_score,campus_detail,campus_picture) VALUES ('$campus_name$','$campus_date$','$campus_university$','$campus_score$','$campus_detail$','$campus_picture$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('5,University,Queue,maxrow:100,maxcolumn:50,import_temptable,Import University,'university_name'=>'required','university_province'=>'required',,,INSERT INTO university (university_name,university_province) VALUES ('$university_name$','$university_province$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('6,Campus1,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Campus1,'campus_name'=>'required','campus_date'=>'required','campus_university'=>'required','campus_score'=>'required','campus_detail'=>'required',,,INSERT INTO campus1 (campus_name,campus_date,campus_university,campus_score,campus_detail,campus_picture) VALUES ('$campus_name$','$campus_date$','$campus_university$','$campus_score$','$campus_detail$','$campus_picture$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('7,Workflow,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Workflow,'wf_name'=>'required','wf_detail'=>'required','wf_state'=>'required','wf_document'=>'required',,,INSERT INTO wf (wf_name,wf_detail,wf_state,wf_document) VALUES ('$wf_name$','$wf_detail$','$wf_state$','$wf_document$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('8,Register,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Register,'register_year'=>'required','register_semester'=>'required','register_advisor'=>'required',,,INSERT INTO register (register_year,register_semester,register_advisor) VALUES ('$register_year$','$register_semester$','$register_advisor$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('9,course,Queue,maxrow:100,maxcolumn:50,import_temptable,Import course,'f_course_year'=>'required','f_course_code'=>'required','f_course_name_th'=>'required','f_course_name_eng'=>'required','f_course_credit'=>'required','f_course_credit1'=>'required','f_course_credit2'=>'required','f_course_credit3'=>'required','f_course_grade_type'=>'required','f_course_status'=>'required',,,INSERT INTO m_course (f_course_year,f_course_code,f_course_name_th,f_course_name_eng,f_course_credit,f_course_credit1,f_course_credit2,f_course_credit3,f_course_description,f_course_condition,f_course_grade_type,f_course_status) VALUES ('$f_course_year$','$f_course_code$','$f_course_name_th$','$f_course_name_eng$','$f_course_credit$','$f_course_credit1$','$f_course_credit2$','$f_course_credit3$','$f_course_description$','$f_course_condition$','$f_course_grade_type$','$f_course_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('10,Open,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Open,'open_course_year'=>'required','open_course_semester'=>'required','open_course_course'=>'required','open_course_seat'=>'required','open_course_sec'=>'required','open_course_faculty'=>'required',,,INSERT INTO open_course (open_course_year,open_course_semester,open_course_course,open_course_seat,open_course_sec,open_course_faculty) VALUES ('$open_course_year$','$open_course_semester$','$open_course_course$','$open_course_seat$','$open_course_sec$','$open_course_faculty$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('11,โครงสร้างหลักสูตร,Queue,maxrow:100,maxcolumn:50,import_temptable,Import โครงสร้างหลักสูตร,'f_programe_year'=>'required','f_programe_name_eng'=>'required','f_programe_name_th'=>'required','f_programe_name_initials'=>'required','f_programe_school'=>'required','f_programe_branch'=>'required','f_programe_level'=>'required','f_programe_plan'=>'required','f_programe_normal_year'=>'required','f_programe_max_year'=>'required','f_programe_calender'=>'required','f_programe_status'=>'required',,,INSERT INTO m_programe (f_programe_year,f_programe_name_eng,f_programe_name_th,f_programe_name_initials,f_programe_school,f_programe_branch,f_programe_level,f_programe_plan,f_programe_normal_year,f_programe_max_year,f_programe_calender,f_programe_status) VALUES ('$f_programe_year$','$f_programe_name_eng$','$f_programe_name_th$','$f_programe_name_initials$','$f_programe_school$','$f_programe_branch$','$f_programe_level$','$f_programe_plan$','$f_programe_normal_year$','$f_programe_max_year$','$f_programe_calender$','$f_programe_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('12,กลุ่มวิชา,Queue,maxrow:100,maxcolumn:50,import_temptable,Import กลุ่มวิชา,'f_group_name'=>'required','f_group_level'=>'required','f_group_plan'=>'required','f_group_major_courses'=>'required','f_group_major_courses_credit'=>'required','f_group_thesis'=>'required','f_group_thesis_credit'=>'required','f_group_electivecourses'=>'required','f_group_electivecourses_cradit'=>'required','f_group_basiccourses'=>'required','f_group_basiccourses_cradit'=>'required','f_group_basienineerirg'=>'required','f_groupe_basienineerirg_cradit'=>'required',,,INSERT INTO m_group (f_group_name,f_group_level,f_group_plan,f_group_major_courses,f_group_major_courses_credit,f_group_thesis,f_group_thesis_credit,f_group_electivecourses,f_group_electivecourses_cradit,f_group_basiccourses,f_group_basiccourses_cradit,f_group_basienineerirg,f_groupe_basienineerirg_cradit) VALUES ('$f_group_name$','$f_group_level$','$f_group_plan$','$f_group_major_courses$','$f_group_major_courses_credit$','$f_group_thesis$','$f_group_thesis_credit$','$f_group_electivecourses$','$f_group_electivecourses_cradit$','$f_group_basiccourses$','$f_group_basiccourses_cradit$','$f_group_basienineerirg$','$f_groupe_basienineerirg_cradit$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('13,รายวิชา,Queue,maxrow:100,maxcolumn:50,import_temptable,Import รายวิชา,'f_course_year'=>'required','f_course_code'=>'required','f_course_name_th'=>'required','f_course_name_eng'=>'required','f_course_credit'=>'required','f_course_credit1'=>'required','f_course_credit2'=>'required','f_course_credit3'=>'required','f_course_status'=>'required',,,INSERT INTO m_course (f_course_year,f_course_code,f_course_name_th,f_course_name_eng,f_course_credit,f_course_credit1,f_course_credit2,f_course_credit3,f_course_description,f_course_status) VALUES ('$f_course_year$','$f_course_code$','$f_course_name_th$','$f_course_name_eng$','$f_course_credit$','$f_course_credit1$','$f_course_credit2$','$f_course_credit3$','$f_course_description$','$f_course_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('14,School,Queue,maxrow:100,maxcolumn:50,import_temptable,Import School,'school_name'=>'required','school_code'=>'required',,,INSERT INTO school (school_name,school_code) VALUES ('$school_name$','$school_code$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('15,Programme,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Programme,'programme_year'=>'required','programme_code'=>'required','programme_name_eng'=>'required','programme_name_th'=>'required','programme_initials'=>'required','programme_program'=>'required','programme_degree'=>'required','programme_status'=>'required','programme_credit'=>'required',,,INSERT INTO programme (programme_year,programme_code,programme_name_eng,programme_name_th,programme_initials,programme_program,programme_degree,programme_normal_year,programme_max_year,programme_status,programme_credit,programme_descriptions) VALUES ('$programme_year$','$programme_code$','$programme_name_eng$','$programme_name_th$','$programme_initials$','$programme_program$','$programme_degree$','$programme_normal_year$','$programme_max_year$','$programme_status$','$programme_credit$','$programme_descriptions$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('16,Faculty,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Faculty,'faculty_title_eng'=>'required','faculty_name_eng'=>'required','faculty_lastname_eng'=>'required','faculty_name_th'=>'required','faculty_lastname_th'=>'required','faculty_position'=>'required','faculty_citizen'=>'required','faculty_education_program'=>'required','faculty_education'=>'required','faculty_education_level'=>'required','faculty_teach_level'=>'required','faculty_appoint_no'=>'required','faculty_appoint_date'=>'required','faculty_department'=>'required','faculty_program'=>'required','faculty_programme'=>'required','faculty_address'=>'required','faculty_phone'=>'required','faculty_email'=>'required','faculty_module_title'=>'required','faculty_status'=>'required',,,INSERT INTO faculty (faculty_title_eng,faculty_name_eng,faculty_lastname_eng,faculty_name_th,faculty_lastname_th,faculty_position,faculty_citizen,faculty_education_program,faculty_education,faculty_education_level,faculty_teach_level,faculty_appoint_no,faculty_appoint_date,faculty_department,faculty_program,faculty_programme,faculty_address,faculty_phone,faculty_email,faculty_picture,faculty_module_title,faculty_status) VALUES ('$faculty_title_eng$','$faculty_name_eng$','$faculty_lastname_eng$','$faculty_name_th$','$faculty_lastname_th$','$faculty_position$','$faculty_citizen$','$faculty_education_program$','$faculty_education$','$faculty_education_level$','$faculty_teach_level$','$faculty_appoint_no$','$faculty_appoint_date$','$faculty_department$','$faculty_program$','$faculty_programme$','$faculty_address$','$faculty_phone$','$faculty_email$','$faculty_picture$','$faculty_module_title$','$faculty_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('17,Student,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Student,'student_citizen'=>'required','student_advisor'=>'required','student_advisor_co'=>'required','student_code'=>'required','student_title_eng'=>'required','student_name_eng'=>'required','student_lastname_eng'=>'required','student_name_th'=>'required','student_lastname_th'=>'required','student_school'=>'required','student_program'=>'required','student_degree'=>'required','student_curriculum'=>'required','student_nationality'=>'required','student_place_birth'=>'required','student_birth'=>'required','student_previous_degree'=>'required','student_admission_date'=>'required','student_first_year'=>'required','student_first_semester'=>'required','student_admission_type'=>'required','student_private_school'=>'required','student_private_grad'=>'required','student_email'=>'required','student_phone'=>'required','student_address'=>'required','student_status'=>'required','student_father_title'=>'required','student_father_name'=>'required','student_father_lastname'=>'required','student_mother_title'=>'required','student_mother_name'=>'required','student_mother_lastname'=>'required','student_guardian'=>'required','student_guardian_address'=>'required',,,INSERT INTO student (student_citizen,student_advisor,student_advisor_co,student_code,student_title_eng,student_name_eng,student_lastname_eng,student_name_th,student_lastname_th,student_school,student_program,student_degree,student_curriculum,student_nationality,student_place_birth,student_birth,student_previous_degree,student_admission_date,student_first_year,student_first_semester,student_admission_type,student_private_school,student_private_grad,student_email,student_phone,student_address,student_status,student_picture,student_father_title,student_father_name,student_father_lastname,student_mother_title,student_mother_name,student_mother_lastname,student_guardian,student_guardian_address,student_application_id) VALUES ('$student_citizen$','$student_advisor$','$student_advisor_co$','$student_code$','$student_title_eng$','$student_name_eng$','$student_lastname_eng$','$student_name_th$','$student_lastname_th$','$student_school$','$student_program$','$student_degree$','$student_curriculum$','$student_nationality$','$student_place_birth$','$student_birth$','$student_previous_degree$','$student_admission_date$','$student_first_year$','$student_first_semester$','$student_admission_type$','$student_private_school$','$student_private_grad$','$student_email$','$student_phone$','$student_address$','$student_status$','$student_picture$','$student_father_title$','$student_father_name$','$student_father_lastname$','$student_mother_title$','$student_mother_name$','$student_mother_lastname$','$student_guardian$','$student_guardian_address$','$student_application_id$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('18,Open Class,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Open Class,'openclass_level'=>'required','openclass_course'=>'required','openclass_seat_reserve'=>'required','openclass_room'=>'required','openclass_teaching_datefrom'=>'required','openclass_teaching_dateto'=>'required','openclass_year'=>'required','openclass_semester'=>'required','openclass_midterm_day'=>'required','openclass_midterm_timefrom'=>'required','openclass_midterm_timeto'=>'required','openclass_finalday'=>'required','openclass_final_timefrom'=>'required','openclass_final_timeto'=>'required',,,INSERT INTO openclass (openclass_level,openclass_course,openclass_seat_reserve,openclass_room,openclass_teaching_datefrom,openclass_teaching_dateto,openclass_year,openclass_semester,openclass_midterm_day,openclass_midterm_timefrom,openclass_midterm_timeto,openclass_finalday,openclass_final_timefrom,openclass_final_timeto) VALUES ('$openclass_level$','$openclass_course$','$openclass_seat_reserve$','$openclass_room$','$openclass_teaching_datefrom$','$openclass_teaching_dateto$','$openclass_year$','$openclass_semester$','$openclass_midterm_day$','$openclass_midterm_timefrom$','$openclass_midterm_timeto$','$openclass_finalday$','$openclass_final_timefrom$','$openclass_final_timeto$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('19,Student Group,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Student Group,'student_group_code'=>'required','student_group_type'=>'required','student_group_year'=>'required',,,INSERT INTO student_group (student_group_code,student_group_type,student_group_year) VALUES ('$student_group_code$','$student_group_type$','$student_group_year$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('20,Event,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Event,'event_code'=>'required','event_name'=>'required',,,INSERT INTO event (event_code,event_name) VALUES ('$event_code$','$event_name$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('21,Calendar,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Calendar,'calendar_event'=>'required','calendar_student_group'=>'required','calendar_year'=>'required','calendar_semester'=>'required','calendar_code'=>'required','calendar_date_from'=>'required','calendar_date_to'=>'required','calendar_status'=>'required',,,INSERT INTO calendar (calendar_event,calendar_student_group,calendar_year,calendar_semester,calendar_code,calendar_date_from,calendar_date_to,calendar_descriptions,calendar_status) VALUES ('$calendar_event$','$calendar_student_group$','$calendar_year$','$calendar_semester$','$calendar_code$','$calendar_date_from$','$calendar_date_to$','$calendar_descriptions$','$calendar_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('22,Curriculum,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Curriculum,'curriculum_year'=>'required','curriculum_code'=>'required','curriculum_name_eng'=>'required','curriculum_name_th'=>'required','curriculum_initials'=>'required','curriculum_program'=>'required','curriculum_degree'=>'required','curriculum_status'=>'required',,,INSERT INTO curriculum (curriculum_year,curriculum_code,curriculum_name_eng,curriculum_name_th,curriculum_initials,curriculum_program,curriculum_degree,curriculum_status,curriculum_descriptions) VALUES ('$curriculum_year$','$curriculum_code$','$curriculum_name_eng$','$curriculum_name_th$','$curriculum_initials$','$curriculum_program$','$curriculum_degree$','$curriculum_status$','$curriculum_descriptions$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('23,Grade,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Grade,'grade_type'=>'required',,,INSERT INTO grade (grade_type) VALUES ('$grade_type$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('24,Staff,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Staff,'stuff_title_eng'=>'required','stuff_name_eng'=>'required','stuff_lastname_eng'=>'required','stuff_email'=>'required','stuff_school'=>'required',,,INSERT INTO staff (stuff_title_eng,stuff_name_eng,stuff_lastname_eng,stuff_email,stuff_school,stuff_picture) VALUES ('$stuff_title_eng$','$stuff_name_eng$','$stuff_lastname_eng$','$stuff_email$','$stuff_school$','$stuff_picture$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('25,Admin,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Admin,'admin_title_eng'=>'required','admin_name_eng'=>'required','admin_lastname_eng'=>'required','admin_email'=>'required',,,INSERT INTO admin (admin_title_eng,admin_name_eng,admin_lastname_eng,admin_email,admin_picture) VALUES ('$admin_title_eng$','$admin_name_eng$','$admin_lastname_eng$','$admin_email$','$admin_picture$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('26,Course Form,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Course Form,'course_addition_userid'=>'required','course_addition_year'=>'required','course_addition_semester'=>'required','course_addition_open_course'=>'required','course_addition_instructor'=>'required','course_addition_advisor'=>'required','course_addition_status'=>'required',,,INSERT INTO course_addition (course_addition_userid,course_addition_year,course_addition_semester,course_addition_open_course,course_addition_instructor,course_addition_advisor,course_addition_status) VALUES ('$course_addition_userid$','$course_addition_year$','$course_addition_semester$','$course_addition_open_course$','$course_addition_instructor$','$course_addition_advisor$','$course_addition_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('27,Registetion Form,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Registetion Form,'course_registetion_userid'=>'required','course_registetion_year'=>'required','course_registetion_semester'=>'required','course_registetion_open_course'=>'required','course_registetion_instructor'=>'required','course_registetion_advisor'=>'required','course_registetion_status'=>'required',,,INSERT INTO course_registetion (course_registetion_userid,course_registetion_year,course_registetion_semester,course_registetion_open_course,course_registetion_instructor,course_registetion_advisor,course_registetion_status) VALUES ('$course_registetion_userid$','$course_registetion_year$','$course_registetion_semester$','$course_registetion_open_course$','$course_registetion_instructor$','$course_registetion_advisor$','$course_registetion_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('28,Registration Form,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Registration Form,'registration_userid'=>'required','registration_year'=>'required','registration_semester'=>'required','registration_open_course'=>'required','registration_instructor'=>'required','registration_advisor'=>'required','registration_status'=>'required',,,INSERT INTO registration (registration_userid,registration_year,registration_semester,registration_open_course,registration_instructor,registration_advisor,registration_status) VALUES ('$registration_userid$','$registration_year$','$registration_semester$','$registration_open_course$','$registration_instructor$','$registration_advisor$','$registration_status$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('29,Deparment,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Deparment,'deparment_name'=>'required',,,INSERT INTO deparment (deparment_name) VALUES ('$deparment_name$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('30,Nationality,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Nationality,'nationality_name'=>'required',,,INSERT INTO nationality (nationality_name) VALUES ('$nationality_name$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('31,Title,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Title,'title_name_eng'=>'required',,,INSERT INTO title (title_name_eng,title_name_th) VALUES ('$title_name_eng$','$title_name_th$')');
INSERT INTO `import` (ID,NAME,TYPE,PROPERTIES,TEMP_TABLE,DESCRIPTION,VALIDATION_ROLE,CONVERSION_ROLE,IMPORT_RULE) VALUES ('32,Department,Queue,maxrow:100,maxcolumn:50,import_temptable,Import Department,'deparment_name'=>'required',,,INSERT INTO deparment (deparment_name) VALUES ('$deparment_name$')');
