|
JCapper Message Board JCapper 101
|
| Home |
Register
Log In |
| By | Design Doc - JCapper Customizeable HTML Report | |
| jeff 9/20/2009 3:39:17 AM | Design Doc - JCapper Customizeable HTML Report: http://www.JCapper.com/HelpDocs/HtmlReportDesignDoc.html Just posting a link to some reading material in advance of tomorrow night's program release.  -jp .
| |
| ryesteve 9/20/2009 7:32:20 AM | Cool stuff... one question about the race sorting option to display by post time: some circuits don't appear to have the post time in the data file. Have you come up with a way to estimate it, or will the blank post times all appear together in the report?
| |
| JimG 9/20/2009 8:34:04 AM | I am very excited about this. Will there be any examples of how to wrote an sql expression? Maybe a glossary of sorts? I can see from this moment forward I will be in SQL mode so I really need to learn it. Any help from the master along that line will be much appreciated. Jim
| |
| jeff 9/20/2009 1:02:56 PM | Steve, In cases where post time is missing from the data file... when you sort by post time those races should be grouped together on the report. Also keep in mind that BRIS post times do not contain an AM / PM indicator... meaning that on special race days where post for R1 is at say 11:15 am... those races will sort towards the end of the report. The first few times you run a report sorted by post time I'd suggest scrolling all the way it just to get an idea of how it's laid out. I'm thinking a best practices strategy would be to use the Data Folder Manager to group tracks with like post times for R1 on the same folder... Then when you run a Calc Races... a post time sort becomes a lot more useful. -jp .
| |
| jeff 9/20/2009 1:18:35 PM | Jim, I've started a JCapper SQL "Cheat" Sheet: http://www.jcapper.com/HelpDocs/HelpFileSQL.txt So far it contains examples of how to do basic stuff for UDMs. In the coming days I'll be adding to it so that it includes examples that can be used in The Name Selection Tool, Report Level Sorting, Race Level Sorting, and finding quasi UDM plays for today's races using The Data Window. There's also a wealth of info about SQL on the web. Here's a link to an Introdcution to SQL tutorial at W3Schools.com: http://www.w3schools.com/SQl/sql_intro.asp And it goes without saying - my philosophy is that the only stupid question is the one that I am too stupid to ask. So if you get stuck trying to figure out how to do something on your own... Ask. -jp .
| |
| ryesteve 9/21/2009 9:34:08 AM | Yes, I've run into the AM/PM problem. You also have situations where the West Coast run night cards, and sometimes the post times are past midnight. But like you said, now that we have the data folder manager, you're not going to want to process a daytime east coast track with a nighttime west coast track in the first place. As for the blank post times, what I was really asking is whether you're using track/race# as secondary level sorts, so that in the absence of post times, the races will still be sequenced properly.
| |
| jeff 9/21/2009 6:12:20 PM | The default (inactive) sql expression included in the download for sorting by post time reads as follows: SELECT * FROM RACEHEADINGSTODAY WHERE FIELDSIZE >= 8 ORDER BY POSTTIME Which causes races with missing post times to be grouped together... but doesn't give the program instructions for how to sort the races in the missing post time group. Just go into the interface and change the sql expression to read: SELECT * FROM RACEHEADINGSTODAY WHERE FIELDSIZE >= 8 ORDER BY POSTTIME, TRACK, RACE ...which solves what you are asking about. -jp . ~Edited by: jeff on: 9/21/2009 at: 6:12:20 PM~
|
| Reply |
|
Copyright © 2018 JCapper Software back to the JCapper Message Board www.JCapper.com |