How To Import

[mesrick]

So I followed your instructions on creating an import file in excel by exporting existing questions. I am just confused on how I import this csv file. I tried doing it in LMS settings, but nothing happens even though I get the success message. Do I just use wordpress importer? SQL? Please advise.

[Anshuman Sahu]

Can you share the file that you are trying to import . refer : https://wplms.io/support/knowledge-base/import-bulk-questions-via-csv-file/ Please do carefully refer the file that you export for the sample to import it .

[mesrick]

Attached is the file.

[mesrick]

When I try to export a question, the file doesn't actually download by the way, so I am wondering if there is an issue with the import/export system as a whole. here are logins to check: http://kingspark.thehistorytutor.com u: medialibrary p: dapebbs2427

[Anshuman Sahu]

I tried to import the question after the export and found no issues in it . Can you please check that the question ids of your question each question that you will import must have a unique id and this id should not match with the id in the database of the wordpress itself . Please try giving a id statinng with random number to your questions  . Also please try importing the questions by breaking the csv file in such way that a file may contain a maximum of 30 questions . check video of our import  : http://screencast-o-matic.com/watch/co6oXuhVHm

[mesrick]

The ids are sequential but start at a value about 8 thousand above the last known id (we started the questions at 10,001). Any idea what the sql insert command would look like for this, I have database access.

[mesrick]

nevermind i realized i was missing a key. thanks.

[Author]

Posts