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?Scoreboard report was not saved because it does not appear to be a valid SQBS file.
Database help
Database help
I was trying to post results from a tournament to the Quizbowl Database but received the error message:
Kevin Commo
Coach, Burlington (Vt.) HS
Tournament Director, Vermont-NEA Scholars' Bowl
Director of Staffing and Statistics, International Academic Competitions
Coach, Burlington (Vt.) HS
Tournament Director, Vermont-NEA Scholars' Bowl
Director of Staffing and Statistics, International Academic Competitions
Re: Database help
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!
Post your tournaments, SQBS reports, and question sets to the Quizbowl Resource Center Database!
Re: Database help
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
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
- jonpin
- Auron
- Posts: 2266
- Joined: Wed Feb 04, 2004 6:45 pm
- Location: BCA NJ / WUSTL MO / Hackensack NJ
Re: Database help
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.
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
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