Forum Index ยป TriviaMaster |
|
Editing Q and A |
[Guest]
| Posted on 1/31/2020 9:53:54 AM 1768 days ago | Is there a file where I can edit the Questions and Answers in a database of a file? Doing this one by one makes it very time consuming. I tried editing the database file, added a question and answer and saved, but it doesn't show up in the game. I tried to import but it says it's not a valid database file. Any ideas? |
|
[Guest]
| Posted on 1/31/2020 10:41:29 AM 1768 days ago | Also, is there a way to clear all tables and questions to start fresh. So that all the ID's and information in the database starts back at 1? |
|
rntrauma93
| Posted on 2/3/2020 7:35:30 AM 1765 days ago | to zero out the scores of the users in the trivia profesional >>>just do>>delete all and it will zero all the scores and no players |
|
[Guest]
| Posted on 2/3/2020 1:45:26 PM 1764 days ago | Thanks rntrauma93,
I appreciate you taking time to answer. I was referring to the questions that are currently there and what is in database. I deleted the tables in the database but that didn't do anything. I can't find the file that holds the questions and answers as well. Thank you. |
|
VNFox
Administrator | Posted on 2/4/2020 2:44:27 PM 1763 days ago | You can delete the questions by:
The database is located on:
C:\Program Files (x86)\PickMike.com\TriviaMaster\data.mdb
|
|
Reformed DJ
| Posted on 2/4/2020 12:13:11 AM 1764 days ago | I have imported thousands of questions using a text file....I edited everything in a spread sheet, used formulas to put the answers in the proper format then saved as either a comma or tab delimited file (I forget off the top of my head) then you can import that file into a category....easy peezy....I actually purchased trivia questions from a few online trivia shops, and got the questions/answer in a spreadsheet file....that you can then edit/manipulate. |
|
Reformed DJ
| Posted on 2/4/2020 12:21:13 AM 1764 days ago | so here is the final format for a question/answer
Entertainment: Celebrities - What college did Brad Pitt attend?|||University Of Missouri
and here is the formula I used in my particular case...
=CONCATENATE(B4," - ",D4,"|||",E4)
so the final cell takes the question catagory, then the question, then adds the ||| ten the answer....then just copy the column with the final result and paste into a text document...do about 500 at a time, and import that text document into a category...and done. The most work is in editing the questions and answers for any weird characters or fixing the multiple choice answers etc... |
|
[Guest]
| Posted on 2/4/2020 1:46:54 AM 1764 days ago | Thank you both for the reply. Is there a formula for the scramble word? TY |
|
VNFox
Administrator | Posted on 2/5/2020 5:56:44 AM 1763 days ago | Scramble words are each word per line. ------ example ---- Word1 Word2 |
|
|