SQMS1 Export to SQMS2 JSON

Händisches Anlegen der Topics

Topics mit importieren!

Bei view_sqms_used_questions

question_id ist erste deutsche ID
id_external ist der verknüpfte englische Text
Wenn external_id = 0 dann soll nur der deutsche text übernommen werden.

---------------------------------- export topic_id

SELECT sqms_topic_id + 872438324, name FROM bpmspace_sqms_v6.sqms_topic where sqms_topic_id IN (SELECT distinct topic_id FROM bpmspace_sqms_v6.v_sqms_used_questions where bpmspace_sqms_v6.v_sqms_used_questions.language_ID = 1);

# de question id -> en question id

SELECT distinct sqms_question_id, id_external FROM bpmspace_sqms_v6.v_sqms_used_questions where bpmspace_sqms_v6.v_sqms_used_questions.language_ID = 1;

for 1 to count do

                # read german id

                SELECT question, "multiple choice", sqms_topic_id + 872438324 FROM bpmspace_sqms_v6.sqms_question where sqms_language_id = 1;

                # read english id if not "0"

------------------------------ sqms_answer

SELECT * FROM sqms_answer;

[sqms_answer_id, sqms_question_id, sqms_correct]

BPMspaceUG / SQMS2

SQMS1 Export to SQMS2 JSON #35