WordPress.org

Forums

SlickQuiz
Is there a way to export the test results to a CSV format? (9 posts)

  1. thesanto
    Member
    Posted 1 year ago #

    Hello there,

    Thanks for this awesome plugin!

    I was wondering if there;s a way to export the test results via WP Admin to a CSV format?

    Thanks,
    Henry

    https://wordpress.org/plugins/slickquiz/

  2. jewlofthelotus
    Member
    Plugin Author

    Posted 1 year ago #

    Hey @thesanto! At this point there isn't an option within the WordPress interface to export the quiz results, so your best best for now would be to grab/convert them out of the database if you have access to it.

    I have gotten quite a few request recently for export options, so I'm going to add this to my list of features for the next release cycle that I'm currently working my way though.

    Thanks for the question and glad to hear you're liking SlickQuiz!

  3. dennis93q
    Member
    Posted 1 year ago #

    I suppose there isn't any easy way to grab the questions either? Into excel.... A text file.... ANYTHING?? :)

  4. jewlofthelotus
    Member
    Plugin Author

    Posted 1 year ago #

    @dennis93q The easiest way to do that right now would be to grab the JSON object storing all of the data. This can be accessed from the quiz page, the quiz preview popup, or directly from the database.

    From the quiz page or preview page, if you view source of the page and search for slickQuiz({ towards the bottom - you'll find the script that initializes the quiz, the very first option, "json" contains all of the quiz data that you created via the quiz form.

    If you wanted to grab from the database, it'd be in the plugin_slickquiz table in a field called publishedJson.

    Hope one of those methods will help you out.

  5. dennis93q
    Member
    Posted 1 year ago #

    I see it in the database, yes... unfortunately I don't know of a way to export it -- if it was multiple lines, I could easily take the database and use separators when export to a csv - but i dont think that's possible with the way it's structured now.... Right?

  6. jewlofthelotus
    Member
    Plugin Author

    Posted 1 year ago #

    Correct, exporting directly to a CSV format is not possible, you'd need to manually break the lines and comma separate the values.

    May I ask what you're trying to do that you require a CSV of the questions and answers for?

  7. dennis93q
    Member
    Posted 1 year ago #

    Basically, I wanted to print the questions (don't need the answers and/or choices) so I could hand it to a person who's not online and have them look over what questions were asked... that's all. Nothing too elaborate.

  8. technoterms
    Member
    Posted 10 months ago #

    Can I take complete back up of the quizzes I made ? I m planning to migrate everything or keeping the back up of all posts, pages, quizzes etc. Is there any way to take a back up ?

  9. jewlofthelotus
    Member
    Plugin Author

    Posted 10 months ago #

    @technoterms Yes, if you have access to the database you can generate a dump of the plugin_slickquiz and plugin_slickquiz_scores tables. You'll also want to grab the slickquiz_admin_options row from the options table.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • SlickQuiz
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic

Tags

No tags yet.