The courses import is not working

Last updated on by

Home › Forums › Legacy Support › Support queries › Setup issues › The courses import is not working

Tagged: ,

Viewing 10 posts - 16 through 25 (of 25 total)
1 2
  • Author
    Posts
  • February 17, 2021 at 2:03 pm #340820
    Veronica
    Moderator
    checking on your site
    February 17, 2021 at 2:15 pm #340825
    Veronica
    Moderator
    hi just checked on your site and found that this issue is with only one course and the course ID is 688 and for this course just checked the CSV and this particular CSV has more than 54k rows! http://prntscr.com/zuzn0v each row runs a query and the database crashed part this into atleast50 files and then import or maybe in at least 250 and then import them one by one
    February 17, 2021 at 4:02 pm #340851
    mohanur252
    Participant
    Hi, I really can't do this, I am not good with excel, could you please get an alternative way to end this?
    February 18, 2021 at 11:27 am #341005
    Veronica
    Moderator
    hi this was the last thing we can go with for you, I will search and ask my teammates if any alternative is possible and then let you know
    February 18, 2021 at 12:48 pm #341024
    mohanur252
    Participant
    Please let me know what we can do. I really want hard the solution. Dividing 1 file into 250 pieces and importing one by one is really shocking. If exporting 1 course creates this kind of complexity, what is your solution if one of the customers want exporting 50+ courses or so. Please make this easy.
    February 19, 2021 at 3:05 pm #341274
    Veronica
    Moderator
    hi Well this is the only way to import such big data as of now, as the database simply cannot such huge amount of requests in one go, it can never process 54000 queries in one go
    February 28, 2021 at 7:17 am #342918
    mohanur252
    Participant
    Hi If importing one course become such complex, I don't know if you have a solution for 20 or more courses. I have to lose my course data as i see, but could you please import just the units, the description and the course reviews? If that one is not possible, please just let me get the reviews? Tell me how I can get the reviews if i can't get the others.
    March 1, 2021 at 2:01 pm #343209
    Anshuman Sahu
    Keymaster
    Well no course data is going to loose you can import the files in any manner , it will just import the data .Such huge data processing needs a very strong server . A software has no limits but hardware has this is the only way to import your such a big course .
    March 1, 2021 at 3:05 pm #343224
    mohanur252
    Participant
    Ok, I got it. Could you please help me to import what can be imported not what we can't or seems complex? I would like to get the data of the course that's possible to be imported. Thanks.
    March 2, 2021 at 1:30 pm #343460
    Anshuman Sahu
    Keymaster
    ITs simple just break the csv file into parts such that no file contains more than 1000 rows . There could be 50 files in your case then import them one by one .
  • Author
    Posts
Viewing 10 posts - 16 through 25 (of 25 total)
1 2
  • The topic ‘The courses import is not working’ is closed to new replies.