Hi. I just want to start off by saying that I love Buzztouch. Question- I'm making a sat vocab app and I have hundreds of vocabulary questions with correct and wrong answers in excel. My columns are Item ID, Correct, wrong 1, wrong 2, wrong 3. But how on earth do you configure this into JSON and have it connected to a Buzztouch quiz? I looked at Btouch's site and can't understand it. Is there a pdf anywhere that will help me step by step? (That's sort of what I need) Thanks!!

Yep, try this tutorial, that was originally created by user MGoBlue, i had it in my tutorial archives on my computer but cannot for the life of me find the original post on buzztouch! ---- by: MGoBlue This is what I do. (Long explanation, but pretty easy) Create an excel file with the following COLUMN headers: itemId itemType questionText correctAnswerText incorrectText1 incorrectText2 incorrectText3 imageURLSmallDevice imageURLLargeDevice Then copy/paste your questions into the "questionText" row. Copy the correct answers into "correctAnswerText" etc. If you're only doing text questions and answers, leave the two url columns blank. The first two columns should look like this: itemId itemType question1 BT_questionItem question2 BT_questionItem question3 BT_questionItem question4 BT_questionItem Column two never changes. It's a BT reference. A couple tips: - Do not use quotation marks anywhere in your questions or answers. - Keep your questions to no more that 175 characters. Much larger than that and you need to adjust the font size too small. Once you have a finished file, save it, then save as a windows csv file. Open your windows csv file in a text editor. It should look like this (but with more rows): itemId,itemType,questionText,correctAnswerText,incorrectText1,incorrectText2,incorrectText3,imageURLSmallDevice,imageURLLargeDevice question1,BT_questionItem,Who created BuzzTouch?,David Book & Crew,Space Aliens,Al Gore,Bill Gates,, Select all and copy. Visit this url: http://www.cparker15.com/code/utilities/csv-to-json/ Paste your csv into the proper section and press convert. Copy the json that's created and paste that into a new blank text file document. It should look something like this (the single quotes should be quotation marks): [ { "itemId": "question1", "itemType': "BT_questionItem", "questionText": "Who created BuzzTouch?", "correctAnswerText": "David Book & Crew", "incorrectText1": "Space Aliens", "incorrectText2": "Al Gore", "incorrectText3": "Bill Gates", "imageURLSmallDevice": "", "imageURLLargeDevice": "" } ] This is important. Replace the first [ with {"childItems":[ Add } to the very end of the file. Save the file (ie. trivia.txt) or whatever, then upload that file to your webserver, dropbox, etc. In the BuzzTouch quiz menu, under Advanced Settings, click on Screen Data Url. Enter the url to your newly uploaded file. That's it. The app should pull the data from your file. I'd suggest testing with just a few questions first to make sure you can get it to work. I've done this method with a couple dozen apps. Works great. I have one app that has nine different quizzes in it, each pulling a different text file. Hope this makes sense.

Thanks. when you saved as a csv file did you use 1) csv (delimited) 2) csv ms-dos or 3) csv macintosh ? I'm unsure which csv I should save the excel as...

Or use this amazing tool from @stobe: http://idevdepot.com/quiz-maker-tool/ Mark

I second the Quiz Maker Tool. It is a huge time saver :) http://www.youtube.com/watch?v=lMOupr4ftmU

I was just about to mention the tool too, haha, love it. Cheers, David buzztouchmods.com

Sadly, none of the converters (CSV to JSON) (Quiz Maker Tool) work with scandinavian lettes as æ,ø,å.