Database help

Dormant threads from the high school sections are preserved here.
Locked
kcommo
Wakka
Posts: 239
Joined: Fri Apr 18, 2003 11:33 pm
Location: Burlington, VT

Database help

Post by kcommo »

I was trying to post results from a tournament to the Quizbowl Database but received the error message:
Scoreboard report was not saved because it does not appear to be a valid SQBS file.
Do the files have to be straight out SQBS without any editing? If so, how do I make adjustments to the files to reflect actual order of finish?
Kevin Commo
Coach, Burlington (Vt.) HS
Tournament Director, Vermont-NEA Scholars' Bowl
Director of Staffing and Statistics, International Academic Competitions
ScoBo
Rikku
Posts: 286
Joined: Wed Jan 10, 2007 5:05 pm
Location: Kansas City area
Contact:

Re: Database help

Post by ScoBo »

If the SQBS files are edited in a program like Microsoft Word or FrontPage where you edit the rendered content rather than the raw HTML, that program will probably save the changes in a way that the database will reject. Right now you would have to edit the raw HTML from the original SQBS output in a basic text editor and reorder the rows there. It looks like you have the stats uploaded elsewhere, but if you'd like to also upload them to the database I can do that for you if you need assistance. Sorry for the inconvenience.
Jeffrey Hill • Missouri Quizbowl Alliance president • UMR/Missouri S&T 2009 • Liberty (MO) 2005
Post your tournaments, SQBS reports, and question sets to the Quizbowl Resource Center Database!
User avatar
AKKOLADE
Sin
Posts: 15783
Joined: Thu Apr 24, 2003 8:08 am

Re: Database help

Post by AKKOLADE »

Could an "add tournament" link be added to the account information page on the DB?
Fred Morlan
University of Kentucky CoP, 2017
International Quiz Bowl Tournaments, CEO, co-owner
former PACE member, president, etc.
former hsqbrank manager, former NAQT writer & subject editor, former hsqb Administrator/Chief Administrator
User avatar
jonpin
Auron
Posts: 2266
Joined: Wed Feb 04, 2004 6:45 pm
Location: BCA NJ / WUSTL MO / Hackensack NJ

Re: Database help

Post by jonpin »

As Jeff said, you have to do HTML editing. Luckily, if all you want to do is change the order of the teams on the standings, it's not too hard. Fairly basic HTML editing turned raw SQBS created files into these color-coded and properly ordered NSC standings.

These instructions are assuming you use Windows in some form.
Generate your SQBS report. Then open Notepad. File/Open, and go to the folder where the HTML documents were created. Where it says "Text documents (.txt)", click the drop-down box and select "All Files". Now your HTML files should show up. Open the one that says "..._standings".
Each team's information appears over the course of many lines, but is bounded by tags that say <tr> and </tr>. To re-order the teams, highlight everything from the <tr> to the </tr>, hit CTRL-X (cut), move to where you want that team placed, put the cursor between the </tr> of the previous team and the <tr> of the next team, then hit CTRL-V (paste). Then, the first bit of data for each team is always rank, in the form of <td> # </td>. Change the number to the correct rank.
Then save the file, and open it up in your browser (IE/FF/Chrome/etc.) to make sure it looks right. If your table is wonky, you've probably got some combination of <td> and <tr> in the wrong place.

There's more stuff you can do, but that's the basics to re-arrange teams so that your stat report has the teams in the correct order.
Jon Pinyan
Coach, Bergen County Academies (NJ); former player for BCA (2000-03) and WUSTL (2003-07)
HSQB forum mod, PACE member
Stat director for: NSC '13-'15, '17; ACF '14, '17, '19; NHBB '13-'15; NASAT '11

"A [...] wizard who controls the weather" - Jerry Vinokurov
Locked