Bulk Import feature deleted question instead of adding

Home Forums Legacy Support Support queries Other issues Bulk Import feature deleted question instead of adding

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #274187
    neuromath
    Spectator
    Hi, i'm trying to add questions through bulk import, however despite following steps found https://vibethemes.freshdesk.com/support/solutions/articles/1000165107-bulk-import-export-wplms-via-csv, not only that didnt work, my existing qn gets deleted:
    • new question didnt get added
    • existing question gets deleted
    Here are the steps of what I did:
    1. Export questions to .csv
    2. Modify the .csv to have different title, qn, answer, explanation, etc
    3. Save the .csv
    4. Import
    What happened:
    • The exported question gets deleted
    • The imported question is nowhere to be seen.
    This is the video: https://www.screencast.com/t/S5USzZALEB4 Please help. I'll include the admin credential next.
    #274188
    neuromath
    Spectator
    This reply has been marked as private.
    #274348
    Veronica
    Moderator
    hi, for this we need to check this on your site so please give me the permission to check this out also let me know the prefix
    #274783
    neuromath
    Spectator
    Hi Veronica, the admin access has been given previously, you may access the site. What prefix are you referring to?  
    #274986
    Veronica
    Moderator
    hi, i am trying to import/export questions on your site
    http://prntscr.com/tiqiz1 i have set it 1 means it is going to escape 1 question and then proceed it with next two
    http://prntscr.com/tiqjve this is your prefix(prefix of the databases' tables)
    these two questions were exported
    http://prntscr.com/tiqn7j
    http://prntscr.com/tiqons changed the title
    import http://prntscr.com/tiqp2n
    status: http://prntscr.com/tiqphf
    http://prntscr.com/tiqq01 
    as you can see that result previous question deleted and new questions were added with the same ID
    so what we have do is just change the id too.
    http://prntscr.com/tiqr7z id must be unique for the question in order to import new question and not to update the same post with same id
    #275210
    neuromath
    Spectator
    Hi Veronica, But what is the id that I should use? if I see it here, they are not in order https://prnt.sc/tjlhyi "id must be unique for the question in order to import new question and not to update the same post with same id" Are you saying that I can just use any number that are not listed in question? like for example 819? because it looks to me the IDs are also related to course/unit/quizzes/assignments/etc And also, there is already an assignment with ID= 819, will that cause problem? This is confusing.
    #275570
    Anshuman Sahu
    Keymaster
    But what is the id that I should use? the id can be anything except its not present in the database already . You can put any unique value for each question in order to import them. But please maintain one unique for one question content and its settings .
    #275670
    neuromath
    Spectator
    Hi Alex/Veronica, I've figured out that setting the id empty works as well. Finding that unique id is hard for admins who don't have technical knowledge on db query, and here is no easy export of all ids to find out which ids canNOT be used. Next, trying with a unique id for question doesn't work, as you mentioned, if the id happens to belong to either quiz, course or assignment. I've tried this before and didn't realise the id belongs to an assignment, which caused my assignment to disappear and had to go database to correct it. Anyway, I've figured out that leaving the id empty will get the system to auto generate the unique id. Saves me all the potential clashes/deletion/problems. Hope this helps anyone out there having similar issues. You may close this thread.
    #275757
    Veronica
    Moderator
    that's really great!!! amazing fact! thanks for sharing this valuable information here yes for sure will help others too. thanks for confirming closing this topic.
Viewing 9 posts - 1 through 9 (of 9 total)
  • The topic ‘Bulk Import feature deleted question instead of adding’ is closed to new replies.