My snapshot database got totally hosed when I sorted it. I had over 30000
records in it. The sorted/corrupted version has 46,184. Virtually all of them
appear blank (no before and after icons). Many of them have "unknown user"
as the creator. Many of them are marked as private records.
Any idea on what happened and what I can do to avoid it in the future?
The backup of the snapshot database is c:\sqdata\sqproof\sqproof.dbu
To restore the backup copy of the database,
delete the current snapshot database (c:\sqdata\sqproof.db); and then
rename the backup (.dbu) to the current database (.db).
I don't know what the problem is or was. I haven't experienced any
problems in the last several years with sorting the snapshot database. I
regularly sort my snapshot database on three different computers.
If your data is important to you, then make regular backups!
When a snapshot or getin/getout database is sorted, the original is saved as .dbu.
When the list, parse, or abbreviation database is edited, the original is saved as .dbu.
So... As long as you don't try sorting a corrupted database, you can
still retrieve the entire contents of the original.
The following files should occasionally be backed up:
the snapshot database (c:\sqdata\sqproof\sqproof.db)
the getout database (c:\sqdata\squaredb\getout.dat)
your sequences (c:\sqdata\seq*.seq)
the 'dates' databases (c:\sqdata\sqused\sqused.db1 and c:\sqdata\sqused\sqused.db2)
I selected the menu item "Sequence / Proofread / Specified" and said "No prompts". One of the error messages I got is:
Sequence C2-96 line 6 -- Call not found:
Hocus Pocus 
The sequence I tested is ok in the graphical editor:
(This is a test, only),
Heads Pass The Ocean,
Extend The K,
(Exit: Detour, Those Facing Start Dixie Grand, L.A.),
Split Counter Rotate 1/4,
Vertical Tag Back To A Wave,
Any idea what could cause error messages like that where it
says "Call not found" but says "" nevertheless ?
Is there a way to check the consistency of the snapshot database or to repair it?
I tried the sequence given above on my machine in both the
'Edit Seq [Graphics]' and the 'Proofread | Specified' sections of the program. It worked fine.
The most probable cause for this error is that there is a problem with the snapshot database.
My guess is that you may have a bad record for "The K". You may have two records starting from the same position, one of which is
incorrect. CSDS uses a binary search of the snapshot database, so if two records match the formation, it will choose the first one (with the highest priority and the lowest fuzziness rating) that it finds. Since the order of the actual records accessed by a binary search depends upon the number of records in the database, the program could match on a different snapshot record than was used when the sequence was written.
In any case, there are two validation functions for the snapshot database:
Snapshot | Validate | Record Access: -- (this is the validation function that should help you resolve the problem) -- for each record within the specified range, the program sets up all possible starting positions specified in the record and then tries to execute the specified call specified. If the 'execute call' function does not match the record itself, a message is output to the output file. Hence this function basically searches for
duplicate records, and
superfluous records (which aren't exactly duplicates, but if they are deleted then the specified call would still be executed in the exact same manner).
This function also finds occurrences when two records specify different ending formations for the same call from the same position, or when two records specify different roll attributes at the end of the call. I generally run this function on the snapshot database prior to major releases of CSDS. Feel free to run it, and experiment with the checkbox settings.
Snapshot | Validate | Handle Lists: -- for each specified snapshot record, the program converts the handle list into a text string, then converts the text string back into a handle list. It then checks to see if the two handle lists match. Mismatches may indicate that there is a problem in the parse database, or the snapshot record may need to be edited to reflect the new handle list. A mismatch could also indicate that I need to rethink how the call is parsed.
Deleting or editing records
I created some snapshots soon after I got the program. I'm not
sure I want to keep them. How do I find them so I can delete or correct them ?
From the main menu, select 'Snapshot' followed by 'View a record'.
From the view snapshot menu, select 'Change record' followed by 'Last
record in database'. (if the 'Last record in database' menu option is disabled, it means that
you are already positioned at the last record).
Near the lower right-hand corner, just above the 'flags' frame, you should
see a box containing the author name (if you have a complete version of the program,
this field should have your name in it; otherwise, if you have the demo version, this field
will contain the word 'DEMO'). This box shows who created the
currently displayed snapshot record. All snapshot records created by you
should have this field set to your name (if you have the complete version) or to 'DEMO' (if you have
the demo version).
To delete a record, press the F8 key, or select 'Toggle delete' from the menu.
Similarly, a deleted record can be undeleted the same way. A deleted record will
have the words RECORD MARKED AS DELETED
displayed in large red letters centered on the
screen. Records aren't physically deleted until the next time that the database is sorted. (and DEMO users can't
sort the database).
To edit the current snapshot record, from the menu select 'Edit' followed
either by 'Edit data' to modify the dancer positions, or by 'Edit name of call' to modify the name of the
To display other snapshot records that you created, use the 'Change record' menu to select the
previous or next record in the database.
Alternatively, to find the records that you created, you can use the
'Find' menu option followed by
'Find a record'. From this screen, click on the 'Match everything' tab;
then check the 'Author' checkbox
and select your name (or 'DEMO' if you have the demo version) from the dropdown list. Click the 'OK' button to start
the search. The program will search for and
then display a record that you created. At this point you can navigate to
each of your records by pressing
'F3' for the next record or 'Ctrl+F3' for the previous record.
last modified: 30-May-2006 ID: 55
Error - Snapshot database Version is 10 - This program requires version 1
I'm getting the following error message:
Snapshot database Version is 10
This program requires version 1
Contact Vic for assistance
After this message the screen goes to
Initializing snapshot database and then it appears to lock up
This error message indicates that the snapshot database is corrupted.
There is no version 10 of the snapshot database, so something bad has happened.
My guess is that one of the following has happened:
you somehow tried to open the snapshot database
(c:\sqdata\sqproof\sqproof.db) in word or some other program, and
somehow you 'saved' it, overwriting something. In this case, the
database is no longer useable.
you copied the database from one computer to another using FTP or
some other program, and it swapped bytes, did disk blocking, or used
text mode when it should have been using binary mode. In this case, the database is no longer useable.
you somehow have more than one version of CSDS or more than one version of the snapshot database on your computer. In this case, you must search your computer for 'sqproof.db' and also 'csds.exe' and see how many copies you can find. Get rid of all of them (but be sure to backup your sequences and
other data); then re-install CSDS.
another (remote) possibility is that somehow CSDS was aborted while it was upgrading or sorting the snapshot database, and something happened to the database.
In any case, I believe the correct course of action now is to backup your sequences (c:\sqdata\seq\*.seq)
and any other data you might need, delete the CSDS folder entirely (c:\sqdata), and re-install CSDS.
last modified: 25-May-2011 ID: 342
Percolate But <anything>
I'm trying to write choreo using Percolate But <Anything>, where the anything replaces the hinge and cross.
There's no problem doing it from parallel waves. I noticed that there's a snapshot record for Percolate But from parallel waves.
But I can't figure out how to do it from other formations (e.g. facing lines or outfacing lines). I made a snapshot record for Percolate But from outfacing lines, but CSDS still doesn't extrapolate when I enter Percolate But (something else, like recycle). Is there some trick to making a snapshot record that's used in a parameterized call?
Create a snapshot record for "Percolate But" by doing a
Circulate 1 & 1/2, Outsides Any Hand Turn Thru. Then,
set the Actives so that only the center 4 are Active. This will make them active for the next call.
Could you explain the Priorities on Snapshot records?
The priority field of a snapshot record indicates how 'normal' or 'abnormal' the call usage
The priority field is used only when determining how to execute calls
from phantom formations. If more than one snapshot record could be
executed from the current
phantom position, the program selects the record with the 'highest'
The values for the priority field has been somewhat arbitrarily defined as follows:
highest priority: Normal
medium priority: T-Bone
lowest priority: Same-spot
I wish I had better names than 'Normal', 'T-Bone', 'Same-spot'. But,
anyway, that's the current state of the program.
If the call ends such that some dancers share the same spot, set
the priority to 'Same spot'.
If the call starts from a T-Bone setup (or, from an usual
setup, such as Pass Thru
from a R-H Mini-Wave), then set the priority field to
the default value of 'Normal' should be used.
Removing a record
I added a bogus definition of a call to the snapshot database.
How do I remove it?
There are several ways to do this.
From the main screen, goto 'Snapshot | View Record'. If the record in question is not already displayed,
you need to find it. Ctrl+F12 will go to the last record in the database. From there, press F11 as necessary until you locate it. (this assumes that you haven't sorted the snapshot database).
Press Ctrl+D to mark the record as deleted.
If you are writing a sequence and just entered an incorrect record, from the menu bar, select 'View | Last snapshot record used'. Press Ctrl+D to delete it.
Unable to do 'Pass Thru'
I entered the Snapshot database to correct a new application that I had entered.
That worked fine, but now I find that the program won't respond to Pass Thru.
I apparently managed to erase the call inadvertently - how, I have no idea.
However, is there a way to restore the snapshot database to a previous issue
that contained Pass Thru?
In the 'Sequence Edit [Graphics]' window, select the 'Flags' menu item.
Make sure all 4 flags starting with 'No' are unchecked.
If you're saying 'Pass Thru' when you should say 'Centers Pass Thru',
Add the word 'Centers'.
There is no restore command for the snapshot database, however,
Records are not physically deleted until the database has been sorted.
From the CSDS main menu, select 'Snapshot | View a Record'.
Then select 'Find | Find a Record'.
In the 'Exact Match' tab, enter 'Pass Thru'.
Press the 'OK' button.
Now cycle thru the Pass Thru records by pressing F3 (e.g., Find Next)
If a record has been deleted, it has a large pink banner near the top saying 'RECORD MARKED AS DELETED'.
To undelete the record, press the 'Del' key or 'Ctrl+D'.
last modified: 25-May-2011 ID: 686
If you have a question that is not answered here, feel free to E-mail Vic at