Import CSV with parent ID
Import CSV with parent ID
I have Parent - Child tables - Quiz and Question. With Alan's help they are working perfectly.
Now I am trying to import Questions using this example. The import works fine except I don't know how to send the id of the parent table [Quiz].
I have added the following code that adds a new field to the Question editor in the initSubmit event. That seems to work but it is adding it to each record. Is there a better way of sending in the quizId to the server?
questionSimpleEditor.on('initSubmit', function (e, action) {
return new Promise(function (resolve) {
var quizId22 = quizTable.row({ selected: true }).data().Id;
questionSimpleEditor.add( {
name: "quizId",
type: "hidden",
}, null);
questionSimpleEditor.val('quizId', quizId22);
questionSimpleEditor.submit();
resolve("");
});
});
This question has accepted answers - jump to:
This discussion has been closed.
Answers
I'd say that is close, but small modification. When you first create
questionSimpleEditoradd yourquizIdfield there. Then set its value in theinitSubmitas you are doing, but don't callsubmit()(already in the submit phase, so no need to).Allan
Thank you allan. The reason I did not add
quizIdto thequestionSimpleEditoris because after I upload the file, that field still shows up on the form before submission even if I mark it as hidden. Is there a way to hide that field? If so, it will be great.Also, do you now I can disable the
New&Import CSVbuttons in the child table till user selects a row in the parent table?I never considered the case of want to upload a file with a hidden field to be honest. I don't actually quite get that - could you explain that a little further for me please?
Also you can use
button().enable()andbutton().disable()to enable / disable buttons. Useselectto know when a row has been selected.Allan
Thanks for the
Newidea. Would you suggest I disable them when the child table is first loaded and enable them when a parent row is selected?As to why I need to send a value via hidden field - here is the scenario
I have a Parent table -
Quiz. EachQuizhas multipleQuestionsfor which I have a child table.I am using the
Import CSVto importQuestionsfor a givenQuiz. On server side, I needidof the selectedQuizto save theQuestionsin the my database.Please note that I am not using DataTables server side code as I have a custom API which drives the website.
Hope that clarifies.
Yes, that sounds about right.
Thanks for the clarification - I thought that it was the file upload that you wantted hidden, rather than specific fields!
Allan