Daniel Francis
asked 10 years ago

I have a site that is built in a CMS system called Vivvo, which is now redundant so I am building a WordPress one.  I have installed and am going to use your Questions and Answers plugin but I would like to import the questions and their answers that I have currently on my site.  They are available to me in in an SQL database and I’m trying to work out to import them into my new wordpress site so that they show up in the relevant questions and answers areas in your plugin.  Can this be done through SQL or another way perhaps via CSV importer?!

1 Answers
xzen xzen
answered 10 years ago

You can use WP Allimport plugin with the call php function to get post id from meta key and value.
Key to connect Question and Answer is custom field _question (from DWQA plugin)
My data are in CSV, I have only one answer, I use this forum for FAQ.
“lister_id”;”post_title”;”dwqa-question”;”dwqa-answer”;”keywords”;”user_id”;”date”;”date_send”
“225”;”Question title 1″;”question text”;”answer text 1″;”tag1, tag2″;3;”2008-10-08 14:44:31″;”2008-10-10 14:44:31″;
“226”;”Question title 2″;”question text”;”answer text 2″;”tag3, tag4″;3;”2009-10-08 14:44:31″;”2009-10-12 14:44:31″; 
Use this function (functions.php in current theme):
https://gist.github.com/feedmeastraycat/3065969

1st step – import questions: Load Unique ID values “lister_id” to extra Custom field with name “qimport”, value: [{lister_id[1]}]
2nd step – import answers: Call this function in custom field name: _question value: [get_post_id_by_meta_key_and_value(“qimport”,{lister_id[1]})]
I didn´t try for more answers for one question
 
 
 

Abdur Rehman
replied 10 years ago

Did you find a way for your problem i also have same problem please can any one help xzen xzen can you enplane it for multiple .

Dominic Staff
replied 9 years ago

Apologies for the delay in replying to you.At the moment, you just can import & export via Dashboard > Tools section.Regards,

Powered by DW Question & Answer Pro