Product Keys Buy Professional Versions
Check Check Order Status
Ask License / Activation Issues
User Account
Username:  Register
Password:  Forgot?
Stay logged-in
Softwares / Apps
PalGreeterPoster v1.0.7 Updated
HDMusicBot v6.8.x Updated
TriviaMaster v4.x Updated
KoolText v3.x
How To ...
Configure Sound & Video
Programming / Scripts
PaltalkHelper Library

I find solutions to your business. For a FREE consultation call/text me at (909)742-9133.
Hi [Guest], License / Activation Issues
Editing Q and A
[Guest]
Avatar
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]
Avatar
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
Avatar
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]
Avatar
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
Avatar
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
Avatar
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
Avatar
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]
Avatar
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
Avatar
Administrator
Posted on 2/5/2020 5:56:44 AM 1763 days ago
Scramble words are each word per line.
------ example ----
Word1
Word2