Export SQMS1 and import SQMS2

AnaMickovic commented 5 years ago

DB export

BPMspace commented 4 years ago

At the Import, the following things are necessary:

If ID is empty, then create new (append)
If ID is a number, then look
- if this ID already exists in Table, then exit, else create with this ID.

BPMspace commented 4 years ago

{
    "Topic": [{
        "Topic_ID": 123,
        "title": "topic 1",
        "Syllabus": {
            "Syllabus_ID": 34567,
            "Syllabus_fromdate": "2018-06-25",
            "Syllabus_todate": 12,
            "Syllabus_attribute": "abc",
            "SyllabusDescription": [{
                "SyllabusDescriptionID": 1234,
                "SyllabusDescriptionLan": "en",
                "SyllabusDescriptionText": "<hmtl>"
            }],         
            "SyllabusChapter": [{
                "SyllabusChapter_ID": 1234565432,
                "SyllabusChapterDescription": [{
                    "SyllabusChapterDescriptionID": 345678,
                    "SyllabusChapterDescriptionLan": "en",
                    "SyllabusChapterDescriptionText": "<hmtl>"
                }, {
                    "SyllabusChapterDescriptionID": 345679,
                    "SyllabusChapterDescriptionLan": "en",
                    "SyllabusChapterDescriptionText": "<hmtl>"
                }],
                "Question": [{
                    "QuestionID": 43584,
                    "QuestionText": [{
                        "QuestionTextID": 345678,
                        "QuestionTextLan": "en",
                        "QuestionText": "<hmtl>"
                    },{}],
                    "Answer": [{
                        "AnswerID": 78439576,
                        "AnswerCorrect": true,
                        "AnswerText": [{
                            "AnswerTextID": 345678,
                            "AnswerTextLan": "en",
                            "AnswerText": "<hmtl>"
                        },{}]
                    },{}]
                }]
            }]
        }
    }]
}

dwu300 commented 4 years ago

8h ok by Rob

BPMspace commented 4 years ago

rename since no duplicate to SQMS1 Export

BPMspaceUG / SQMS2

Export SQMS1 and import SQMS2 #1