Go Back   Pace and Cap - Sartin Methodology & The Match Up > RDSS
Mark Forums Read
Google Site Search Get RDSS Sartin Library RDSS FAQs Conduct Register Site FAQ Members List Search Today's Posts

RDSS Racing Decision Support System – The Modern Sartin Methodology

 
 
Thread Tools Display Modes
Old 09-17-2010, 01:04 PM   #1
alydar_ David
Grade 1
 
Join Date: Jun 2005
Posts: 2,654
RDSS Data Management

Hello Ted,

What's the best way to manage data?

I've taken some old data and moved it to a folder I created on my D drive. I've named that folder "Old Data."

However, if I want to access that data I have to move it back to my "Data" folder on drive C.

Is there some way all the data can be stored on the D drive and accessed by RDSS which is running in the C drive?

That way I could leave drive C exclusively clear for operating functions.

Thanks.
Attached Images
 
alydar_ David is offline  
Old 09-20-2010, 11:09 AM   #2
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Nanaimo, British Columbia, Canada
Posts: 8,853
Hi David,

Yes indeed there are some controls you can use to tell RDSS where to find its data (the following involves just a few details, so grab a coffee ).


This comes in 2 parts:

A) where downloaded TrackMaster files go (i.e. where the RDSS Data Archive is located)
B) where the RDSS Database is located

A) RDSS Data Archive location - RDSS downloads and subsequently looks for downloaded Trackmaster data files EITHER in subfolders of the \RDSS\DATA\ folder on the Drive where you installed RDSS (the default) - OR in the alternate folder defined in the RDSS.INI term: Datadir. Within either location, Past Performance files are stored in further subfolders by YEAR and TRACK.

Consider the downloaded data file for Woodbine September 19, 2010 'wo20100919rdss.zip' (nice day of races, BTW)! For example, normally you would install RDSS to the C: drive in the default RDSS folder, in which case the downloaded file is stored in c:\rdss\data\PP\2010\WO\ ...

You can tell RDSS that your downloaded files should reside in the alternate folder defined by 'Datadir' - close RDSS, open your RDSS.INI Configuration file (in the RDSS folder) with a text editor and add the following line just under the line which reads [General] (i.e. in the General Section):

Datadir=d:\olddata\

(don't forget that final \ character above!)

Save and close RDSS.INI and reload the RDSS software. Now when you download the above Woodbine file, it is stored to d:\olddata\PP\2010\WO\... - same with all your other downloaded Trackmaster cards, to their own respective subfolders. This then also becomes the location where RDSS looks when it Converts a downloaded file for use in the RDSS Database. If you ever want to revert to the default Data Archive location, just disable the Datadir term in your RDSS.INI file by placing a semi-colon in front of it: ;Datadir


B) RDSS Database location - the RDSS database is normally a file named DATA.DB and normally it resides in the \RDSS\DATA\ folder on your Drive C (e.g. c:\rdss\data\data.db). RDSS knows where to find the database file by checking the ODBC database connection info found also in the RDSS.INI file, in the [Database] Section. When you install RDSS, the installer creates an entry in your Windows ODBC list (Open Data Base Connections). The entry is named 'Rdss Database'. You can see the reference to this ODBC entry in the RDSS.INI [Database] Section, the line reading:

DBParm=ConnectString='DSN=Rdss Database'

You can relocate the RDSS Database file itself (c:\rdss\data\data.db) to your new data drive location (e.g. d:\olddata\data.db) by editing the 'Rdss Database' entry in the Windows ODBC Data Sources Administrator utility, which is usually found here: C:\Windows\System32\odbcad32.exe (you could make a Desktop shortcut for future access). Here are a few pictures:

Name:  odbc1.gif
Views: 865
Size:  18.1 KB

Name:  odbc2.gif
Views: 833
Size:  16.5 KB

Double-click the Rdss Database entry (per the 1st picture above), then choose the Database Tab (the 2nd picture above). This records the name of the Database engine to use (in 'Start line' - don't touch this) and the location of the RDSS Database file (in 'Database file'), which normally is as shown: c:\rdss\data\data.db. Once you have moved that database file to your new data folder, edit the Database file entry to show that new location, e.g. d:\olddata\data.db.

Then click OK and close out of the ODBC editor, then restart RDSS. If all entries were correct, and your RDSS database file is indeed located in folder d:\olddata\ then all will work normally with the database. (RDSS still looks for its database according to the RDSS.INI file [Database] Section info ('Rdss Database'), and the Windows ODBC entry for 'Rdss Database' tells Windows where to find that particular database (i.e. its new location).

By following the above two A) and B) steps, you have moved ALL data used by RDSS (downloaded files and the database itself) from its default location to a new location, e.g. d:\olddata.

Hope that's what you were looking for! Give it a try and let us know how it works.


BTW, using the ODBC editor, you can set up a new separate entry for the RDSS Demo Database (e.g. in a file named c:\rdss\data\demo_data2010.db, or wherever else you might locate it) and a separate entry in your RDSS.INI [Database] section for it (e.g. 'Rdss Demodata 2010'), then switch between looking at the upcoming new extensive 2010 Demo Data, say for research purposes or if you are evaluating RDSS, AND the normal and typically smaller, main database of your own downloaded data and pacelines.

If anyone is interested in further instructions to manage this, just let me know.

cheers,

Ted
__________________

R
DSS -
Racing Decision Support System™

Last edited by Ted Craven; 09-20-2010 at 11:14 AM.
Ted Craven is offline  
Old 09-23-2010, 02:22 AM   #3
alydar_ David
Grade 1
 
Join Date: Jun 2005
Posts: 2,654
No dice, Ted.

Methinks you may have omitted (what is to you) an obvious step or two. I've spent waaaaaaaaaaay too much time on this and now RDSS doesn't work at all.

PS-I'm computer literate and had no problem following your directions to the letter (which were very well written, thank you). Unfortunately, they didnt' work.
alydar_ David is offline  
Old 09-23-2010, 06:53 AM   #4
Ted Craven
Grade 1
 
Ted Craven's Avatar
 
Join Date: Jun 2005
Location: Nanaimo, British Columbia, Canada
Posts: 8,853
David,

Check your email. Call me and we'll get it sorted.

Ted
__________________

R
DSS -
Racing Decision Support System™
Ted Craven is offline  
Old 09-23-2010, 06:27 PM   #5
alydar_ David
Grade 1
 
Join Date: Jun 2005
Posts: 2,654
Ted was gracious enough to send a few emails which enabled me to straighten everything out.

My bad. The problem was having two data folders on my secondary drive. It had nothing to do with the actual database itself (other than the fact that it was residing in the "wrong" folder based on where I told the database administrator to look).

I assumed (there's that word again) I'd need a "Data" folder on my "D:" drive. Wrong.

The "olddata" folder did not need to have a "Data" subfolder. Ted's instructions were perfect.
Attached Images
 
alydar_ David is offline  
Old 09-23-2010, 06:38 PM   #6
dlivery
Grade 1
 
Join Date: May 2009
Location: Thornhill ON
Posts: 437
Excellan help

Hi There

Your post has help me with your problem to resolve this

Thank - You for your posting this
__________________
May all wagers be Winners...
dlivery is offline  
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
RDSS 2.0/Happy Holidays/Thank You! Ted Craven RDSS2 / FAQ's 4 01-09-2010 06:03 PM
Release Notes - Version 0.98.7 Ted Craven RDSS Info, Reference 2 07-17-2009 11:09 AM
Import Old Race Cards Ted Craven RDSS 1 05-07-2009 08:25 AM
RDSS Subscription / Forum Re-organization Ted Craven RDSS 1 03-07-2009 01:35 PM


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.

All times are GMT -4. The time now is 07:22 AM.