Square Dance Resource Net  (Home)ArticlesCallers and CuersClubsEventsResourcesChoreographyRecordsFrequently Asked QuestionsAcademy for Advanced and Challenge Enthusiasts  (AACE)Ceder Chest Definition BooksCeder Square Dance System  (CSDS)Square Rotation Program  (SQROT)Vic Ceder - Square Dance CallerDefinitions of square dance calls and conceptsMore square dance DefinitionsLists of square dance calls and conceptsDigital music informationSquare dance linksBande DéssineesLos Olivos Honey BeesChocolate BarsBeanie BabiesPokémon Trading CardsSend us feedback
 
FAQ Database
Ceder Square Dance System (CSDS)
 
 Master Index    Recent Changes    Find by Record ID    Help    Feedback    administrator         
Find what:
  
 Inquiries prior to purchasing    Installation    Upgrading    Call from Screen    Choreography    Cue sheets    Errors    Levels    Music    Printing    Sequences    Snapshots    Other Questions  

 
Cue sheets
 
  1. 0 cue sheets upgraded
  2. Associating cue sheet with music
  3. Button is not enabled
  4. Caching problem #1
  5. Caching problem #2
  6. Changing style
  7. Clear the cue sheet and lyric paths
  8. Cue sheet comes up for PATTER record
  9. cue sheet confusion #1
  10. cue sheet confusion #2
  11. Cue sheets changed?
  12. Cue sheets not added
  13. cuesheets.css #1
  14. cuesheets.css #2
  15. DOC files (Microsoft Word)
  16. Document types
  17. Editing a cue sheet
  18. How do I add a cue sheet?
  19. How do you make your cue sheets?
  20. How to import
  21. How to submit cue sheets to the master database
  22. HTML doesn't display correctly
  23. HTML markup format
  24. Import fails
  25. Internet Explorer (MSIE) 7
  26. Label Pictures not showing up
  27. Lost my cue sheets
  28. Miscellaneous questions
  29. Missing from download file
  30. Missing lyrics
  31. Only one cue sheet per music file?
  32. Strange display
  33. Unable to bring back music player
  34. Upgrade from web
  35. Using the supplied cue sheet files
  1.  
    0 cue sheets upgraded
     
    Since all of my cue sheets are on paper, I thought I'd see if I could leverage cue sheets from your collection. I downloaded the cuesheets from your web site and created a file, csds_cuesheets.txt. I used the 'Music | Edit Music Database' and then 'Edit | Upgrade Cuesheets from the Web'. I then get a dialog box saying "0 cue sheets upgraded (2041 processed)".

    CSDS only generates cue sheets for entries in your Music Database that 'match' entries in out web-based Record Database.

    For CSDS to find a match, the following must be true:

    1. the singing call must be listed in your Music Database.
    2. the 'Label' and 'Label #' fields must exactly match the corresponding fields in our web-based Record Database.

    Make sure that the 'Label' and 'Label #' fields are properly set for all entries within your Music Database. For example, the record 'I Found A New Baby' on Blue Star should have Label='Blue Star', and Label #='2263'. The label number should NOT be followed with a 'A' or 'B' (for the vocal or instrumental side), it should just be the number.

    ID: 373
      
      
      
  2.  
    Associating cue sheet with music
     
    I have loaded songs into the database and downloaded the cue sheet files. On "Upgrade Cue Sheets form Web..' the program goes through the file and returns the message "0 files loaded, 0 files overwritten" What is the program matching. I know some of the songs have the identical titles. Please let me know what I need to do.

    Cue sheets (and lyrics files) are matched upon record label and label number, not upon title.

    This is because

    1. The title could be mispelled or different between the web-database and your database; and
    2. Cue sheets for the same song from different labels are different.

    For more information, see http://www.ceder.net/faqdb/view.php?section=1&category=38#rec373

    last modified: 01-September-2010   ID: 643
      
      
      
  3.  
    Button is not enabled
     
    The Cue Sheet button on the Music Player is not "Lit Up" so that I can use it. Do I need to do something to turn it on?

    The 'Cue Sheet' button is only turned on (i.e., enabled) when a cue sheet has been associated with an entry in the Music Database.

    To associate a cue sheet with a music file,

    1. go into 'Music | Edit Music Database';
    2. highlight an entry;
    3. edit the 'Cue Sheet' field, preferably via the 'Browse...' button.
    4. save the changes made to the music database.

    ID: 247
      
      
      
  4.  
    Caching problem #1
     
    I am continuing to have difficulty with cue sheets being "cached" somewhere that I can't find.

    When I initially add mp3's to my database I have usually scanned the record jacket as a jpg and attach that as a cue sheet. When I have the time to personalize the singing call, I create a Word document, and then ultimately an Acrobat pdf. I just did so with one of my records, making the change to the Cue Sheet field on the Edit Music Database screen. I subsequently called up the music player and hit the cue sheet button. The jpg was still displayed.

    You need to reload the music selection from the music database (via 'D').

    The music player, the quick list, and the history list each keep their own 'cache'.

    ID: 114
      
      
      
  5.  
    Caching problem #2
     
    I've discovered a weird symptom related to changing the cue sheet associated with an entry in the music database. When I create a new mp3 file I usually scan the record jacket and attached the jpg as the cue sheet.

    If it's a record I wind up using a lot, I will often generate a better cue sheet for myself in Word and save it as an acrobat pdf file.

    For several of my records, I've gone in to the music database, browsed for the pdf to replace the jpg and saved the change. When in the Edit music database function, if I press the View button, I see the pdf I have selected, but when I am in the call from screen function and press the Cue Sheet button on the Music Player, it continues to show me the old jpg. No combination of resaving the modified entry in the Edit music database function seems to allow me to have the correct cue sheet displayed. Can you see if you can banish these "ghosts" for me?

    The problem is that you are loading from the Music Quick List, which is just a copy of information from the music database at the time when the music was added to the quick list.

    Hence, to banish the "ghosts", you need to do one of the following:

    1. From the music player, use 'Load from Music Database' instead of 'Load from Quick List'; or
    2. Within the Edit Music Database or Load From Database, use the 'Quick Add' to replace the old entry in the quick list with the new entry.

    ID: 92
      
      
      
  6.  
    Changing style
     
    Can I change how the cue sheet looks?

    You can change the font sizes, and colors of different elements on the HTML cue sheets via CSDS by going to 'System | Settings... | Fonts | Cue Sheets HTML Style Sheet'.

    ID: 441
      
      
      
  7.  
    Clear the cue sheet and lyric paths
     
    Is there a way to clear all the cue sheet and lyric paths so I may simply reinstall off the web? (I found that it corrects the path situation however when I check the checkbox that says overwrite existing cue sheets, but import the latest batch from your site, it only overwrote 22 sheets...)

    The easiest way would be to

    1. Via the Windows File Explorer, delete the folder containing the cue sheets;
    2. Run CSDS, go to 'Music | Edit Music Database';
    3. Select 'Tools | File pathnames | Find non-existent files';
    4. Check the last checkbox (Clear cue sheet (or lyrics) field if the cue sheet (or lyric) file does not exist).
    5. Press 'OK';

    ID: 581
      
      
      
  8.  
    Cue sheet comes up for PATTER record
     
    Most of the music I use for patter is actually singing call music...it seems that, even though I have it marked as (P) Patter only, the main window comes up with the singing call cue sheet in the main window if a cue sheet exists. I don't know if this is what you intend the program do or not. I guess I think that it should not work this way. If I have the music marked as both singer and patter, you ask me which one I want, and if I choose patter, I would expect to not find the cue sheet in the main window. If I have it marked as Patter only, then I would never > expect to see the cue sheet in the main window. This is not what happens. In both cases, if a cue sheet exists, it appears in the main window even though patter is what I have chosen for the music.

    To solve this problem,

    1. Goto 'System | Settings';
    2. Click the 'Call from Screen' tab;
    3. Check the box entitled 'Bring cue sheets to foreground only for Singing Calls (S)'.

    ID: 505
      
      
      
  9.  
    cue sheet confusion #1
     
    I can't figure out how to display the cue sheets.

    In order for a cue sheet to be displayed, the pathname of the cue sheet file must be specified within the music database.

    How to associate a cue sheet file with an entry in the music database:

    1. within the 'Edit Music Database' screen, highlight the desired record in the 'Grid' section.
    2. the 'Edit item' section now allows you to modified fields for the highlighted record. The last line in the 'Edit item' section is the 'Cue Sheet' field. There is a text box where you can type in the pathname of the cue sheet file, or you can use the 'Browse' button to the immediate left to select the file. After the file has been selected, a 'View' button allows you to display the cue sheet to verify that it is correct.

    Cue sheets can be .TXT, .RTF, .HTML (or .HTM), .DOC, .PDF or other files. Recommended formats are .TXT, .RTF, and .HTML.

    ID: 319
      
      
      
  10.  
    cue sheet confusion #2
     
    I also don't understand how the cue sheets work. Right now I'm copying the record sleeves on a scanner and saving them in a "bmp" format, and "Windows Picture and Fax Viewer" is opening them. I've also saved some as doc files in "Word", and they are smaller(in KB's, while the picture viewer is in MB's), but as you told me before, they take awhile to open. I know you say to download the cue sheets from your site, but I don't understand how to set it up after download. Also a lot of the songs I use aren't on it. I guess I don't understand how to link the cue sheets to the songs(words) on your cue sheet data base. If all the songs are in ONE file, how do I link each mp3 to only the words for that one mp3. I would think it would bring up the words for all the songs, if they're all in the same file. Do you understand what I'm saying? I understand how to use a filing system pretty good, but can't figure out how this works.

    To use cue sheets in CSDS, you should be in (call from) the 'Dance | Call from Screen' portion of the program. This part of the program allows full access (single key strokes) to the music player as well as to the cue sheet, lists of calls, and sequences.

    Although cue sheets may be in almost any format, for optimal use within CSDS, cue sheets should be in RTF (Rich Text Format), HTML (Hypertext Markup Language), or TXT (Text) format. I suggest that you save your 'MS Word' cue sheet files in .rtf or .html format instead of .doc format.

    Each cue sheet needs to be associated with a piece of music. Use the 'Cue Sheet' field of the Music Database to do this.

    To download cue sheets from our web site, you need to download the file, then have CSDS process the file to create the cue sheets.

    The procedure is as follows:

    1. Download a set of cue sheets for CSDS from http://www.ceder.net/recorddb/csds_download.php
    2. Save the downloaded file on your hard drive (in a known location)
    3. Run CSDS
      1. Get into 'Music | Edit Music Database';
      2. Select 'Edit | Upgrade Cue Sheets from Web...'
      3. For the 'Source file', browse to the downloaded file.
      4. For the 'Destination folder', select a folder in which the generated cue sheets are to be placed.
      5. Press the 'OK' button to generate cue sheets and associate them with entries in the Music Database.
      6. Exit and Save changes to the Music Database.

    Note: the above procedure will create and associate a cue sheet with all music database entries in which the 'Label' and 'Label #' fields match the data within the downloaded file. Therefore, you must have properly specified the 'Label' and 'Label #' fields for all entries in the Music Database. The 'Label #' fields should not contain the 'record side' (A or B) indicator -- for example, Rockin' In Rosalies Boat should be label="Chaparral", label#="202" (the label# should not be "202B" for side B of the record). If you have a song for which we do not have the cuesheet in our web-based Record Database, please send it to Debbie and she will add it.

    last modified: 25-May-2011   ID: 315
      
      
      
  11.  
    Cue sheets changed?
     
    Why does loading your cue sheets now include text like the following
    before the OPENER in the html cue sheet that is created ?
    #LYRICSID:1069#
    #TLM:0000-00-00#
    Is this really needed & why? I preferred the cue sheets without this.

    The cue sheet input file now contains additional information that allows CSDS to

    1. automatically associate the correct lyrics with the cue sheet that's the #LYRICSID: tag).
    2. automatically determine whether or not the cue sheet requires updating in the new cue sheet database (that's the #TLM: tag).

    Get the latest version of CSDS, version 1.21.00 or later, (complete release). It will 'fix' this problem.

    last modified: 14-August-2006   ID: 605
      
      
      
  12.  
    Cue sheets not added
     
    I sent you 6 Royal cue sheets to add to the record database and you wrote back and said they were added. I've tried updating the cue sheets and they don't show up. I went into "Edit Music Database/Edit/Upgrade cue sheets from web/ and clicked OK. After going thru the cue sheet files, these records don't show up. Am I doing something wrong?

    I have confirmed that 1) the files are in the record database, and that 2) the CSDS cue sheet download files have been generated.

    If you're having problems, it's probably one of the following:

    1. You haven't downloaded the latest cue sheet download files. Get the latest cue sheet files from http://www.ceder.net/recorddb/csds_download.php
    2. You aren't accessing the correct cue sheet download file from CSDS. Maybe you're still using the old file.
    3. Either the label name or label number fields don't match. That is, the label name and label number in your CSDS Music Database doesn't match exactly the label name and label number in the online Record Database. The listing of records included in the cue sheet files can also be found at http://www.ceder.net/recorddb/csds_download.php

    last modified: 19-May-2006   ID: 572
      
      
      
  13.  
    cuesheets.css #1
     
    I seem to be missing the file cuesheet.css. Can I get it from you?

    You may download cuesheet.css from http://www.ceder.net/csds/ftp/cuesheet.css

    Place it in the same folder as your HTML cue sheets.

    This file is automatically created by CSDS if it doesn't already exist whenever you select 'Edit Music Database | Edit | Upgrade Cue Sheets from Web'.

    ID: 376
      
      
      
  14.  
    cuesheets.css #2
     
    There is a file, cuesheets.css, that gets created in the destination cue sheet folder. This file contains the following:

      
    .title { font-size: 18pt; font-weight: bold; }
    .label { font-size: 10pt; color: purple; }
    .artist { font-size: 10pt; color: green; }
    .hdr { font-size: 12pt; color: brown; font-weight: bold; margin-left: 25px; }
    .text { font-size: 14pt; margin-left: 50px; line-height: 140%; }
    .lyrics { font-size: 14pt; background-color: #FCC9C3; }
    font { font-family: Tahoma, Arial, Helvetica, Sans Serif; }
    body, p, font { font-family: Arial, Helvetica, Verdana, Sans Serif;
    font-size: 10pt; }
    body { background: #FFFFFF; color: #000000; }
    

    When I try to open the file, it brings up Microsoft FrontPage.

    The 'cuesheets.css' file is a HTML Cascading Style Sheet file. This file specifies the font type, font sizes, and colors used when displaying a cue sheet. CSDS allows you to edit this file via 'Settings | Fonts | Cue Sheets HTML Style Sheet'.

    ID: 374
      
      
      
  15.  
    DOC files (Microsoft Word)
     
    I have typed in the lyrics to all my singing calls and I have converted some of them into MS Word (.DOC) files. I can attach them to the music with no problem but when I use the 'Call from Screen' option and show the cue sheet, pressing F1 brings up the Word help menus!

    Pressing C, for the cue sheet, has a slightly long delay before appearing - can I make it quicker?

    When a cue sheet is displayed in the main frame of the 'Call from Screen' section, what is actually happening is that another program (i.e., MS Word, Internet Explorer, Adobe PDF Viewer, etc.) is imbedded into the CSDS program. When the imbedded program has the focus (i.e., it is the main frame), it receives and processes the keystrokes. I have been unable to stop this behavior. But even if I could, it might be impossible for the user to scroll the cue sheet.

    As for the long delay after pressing 'C', for the cue sheet: Don't use MS Word. The delay occurs because CSDS must physically load a copy of MS Word. The suggested course of action is to use MS Word to create the cue sheet, but then save the file as RTF (Rich Text Format) or HTML. RTF loads very fast, HTML loads a little slower, but DOC files are really slow.

    ID: 500
      
      
      
  16.  
    Document types
     
    What kind of documents can be used to hold song lyrics?

    CSDS can display most recognized file types. For example,

    • a .TXT file should bring up an application such as Notepad or Wordpad,
    • a .DOC file should bring up MS Word,
    • a .HTML file should bring up Internet Explorer,
    • a .RTF file should bring up a RichText viewer such as MS Word,
    • a .PDF file should bring up Adobe Acrobat

    I use HTML to format my cue sheets. You can download HTML-formatted cue sheets for some records from our Record Database Record Database.

    To download a single cue sheet:
    1. Go to the Record Database
    2. Click on the 'Advanced query' link
    3. Go to the bottom of the resultant page, click on the 'Cue Sheet' check box, then click a 'Submit Query' button.
    4. Click on a record title to display all data for the record.
    5. Next on 'full page' (in the 'Cue sheet' section) to bring up a new copy of your browser displaying the entire cue sheet in a reasonably large font.
    6. From the browser menu, select 'File' followed by 'Save As' to save the cue sheet on your computer.

    Records with cue sheets (shortcut for steps 1 thru 3 above)

    I suggest that all cue sheets be placed in the same directory (e.g., c:sqdatacuesheet).

    To download all available cue sheets at once:
    1. You must have CSDS 0.98.04 or later
    2. Go to http://www.ceder.net/recorddb/csds_download.php and follow the instructions

    ID: 48
      
      
      
  17.  
    Editing a cue sheet
     
    Is there anyway I can add some notes to a correct cue sheet. I have a few records I like to add words to.

    Cue sheet files (and also lyrics files) can be edited. Get the complete file pathname (you can get this via the 'Edit Item' box of the music database), open an text editor such as Wordpad or Notepad if the file extension is TXT or HTML; or open an editor such as MS Word if the file extension is RTF. Make the necessary changes, then save the file (with the same name).

    You can edit an HTML or TXT cue sheet via the 'Music Database - Edit Item' window. Just click on the edit toolbar button (with the 'pencil') icon to the right of the Cue Sheet filename.

    ID: 507
      
      
      
  18.  
    How do I add a cue sheet?
     
    After I have the music converted to a satisfactory MP3 and in the program, how do I add the corresponding cue or cheat sheet?

    To add a cue sheet, you basically have to do two steps:

    1. Create or obtain the cue sheet for each desired piece of music;

      You can create your own cue sheets in practically any format that can be displayed by a web browser (i.e., text files (.txt), HTML files (.htm or .html), rich text files (.rtf), Microsoft Word documents (.doc), Adobe Acrobat reader files (.pdf).

      I recommend using text files (.txt) and rich text files (.rtf), as CSDS has native support for these filetypes. CSDS will be faster (and have fewer) problems if you use TXT or RTF files -- if you use a DOC file, for example, CSDS must load a browser which then loads a copy of MS Word, which then loads the file. If you then press keys that CSDS is unable to try, MS Word will get the command instead, and you may inadvertently modify your cue sheet -- this can not happen with TXT or RTF files.

    2. Associate the cue sheet with the piece of music.

      From the CSDS main menu, select 'Music' followed by 'Edit Music Database'. For each piece of music to which you wish to associate a cue sheet: 1) highlight the music; 2) edit the 'Cue Sheet' field or use the 'Browse' button to the immediate right of the field to select a cue sheet; 3) Use the 'View' button to see what the cue sheet would look like when displayed by the program. (this last statement isn't quite true for TXT or RTF files).

    You can also download cue sheets from our web-based 'Record Database', and import them into CSDS. See http://www.ceder.net/recorddb/csds_download.php

    last modified: 25-May-2011   ID: 279
      
      
      
  19.  
    How do you make your cue sheets?
     
    How do you make your cue sheets? i.e., What program you use when making up cue sheets, do you type in all the info or scan it from the record cue sheet cover, etc.

    I like the way your cue sheets look and they take up less space than what I was using. I like to keep everything the same when making cue sheets and I have the ones from your site, but I need a lot more and want to make them the same.

    Our cue sheets are automatically generated from our web-based Record Database, http://www.ceder.net/recorddb/view.php?action=ftt. The cue sheets are in HTML format.

    Adding cue sheets is a common stumbling block for CSDS users. As such, there are future plans to allow users to create/edit the HTML-style cue sheets normally used by CSDS. But, that is in the future, so for now...

    The best thing to do would be to open an existing CSDS HTML-style cue sheet and edit it with a text editor (e.g., Wordpad) to create new cue sheets.

    If possible, please send us cue sheet information for all square dance records that you have that are not listed in our web-based Record Database. We will format the cue sheets, add them to the Record Database, and then you may download the cue sheets from the web. This allows everyone access cue sheets, keeps the cue sheets in a consistent format, and avoids a lot of re-inventing the wheel.

    ID: 372
      
      
      
  20.  
    How to import
     
    I still can't figure out how to import the cue sheets.

    To import cue sheets from our web site into CSDS, do the following:

    1. Go to http://www.ceder.net/recorddb/csds_download.php
    2. Set a file to download
    3. Wait for the page to finish downloading in your browser
    4. From the browser's menu, select File | Save As... and save the data (perhaps in file C:\CUESHEETS.TXT).
    5. Run CSDS
    6. From the CSDS menu, select Music | Edit Music Database
    7. From the Edit Music Database menu select Edit | Upgrade Cue Sheets from Web
    8. For the source file, enter (or browse to) the name of the downloaded file
    9. For the destination folder, select a folder such as C:\SQDATA\CUESHEETS (you may first need to create the folder via the Windows File Explorer)
    10. Click the OK button, and the program should import some cue sheets (this is assuming that you've correctly set the 'Label' and 'Label #' fields for items within your music database)

    ID: 205
      
      
      
  21.  
    How to submit cue sheets to the master database
     
    I would love to send you the cue sheets I write but what I did was started to edit the source codes for what you sent me and save it as a new file. ummm, That would take awhile, so I'm thinking you have a program to write it in HTML format. If you would send me just one of your text files in the format you want me to type it. I'll send some cue sheets back to you and you can convert them and add them to your database.

    Yes, I have a program to generate the HTML format. I believe that HTML is the most versatile way to implement cue sheets, since users can modify the cascading style sheet file (cuesheet.css) if desired to easily change the font size, font type, color, etc. of all cue sheets at once. In the future, the program can easily be modified to generate cue sheets in another format (RTF, PDF, ?).

    Here is a sample cue sheet in the proper format:

    OPENER
    
    All four ladies promenade one time around
    Get home and swing awhile with your man
    Join up hands and circle to the left around the ring
    Do a left allemande and weave the ring
    <L>Well the stars are bright and there's a moon out tonight</L>
    Why don't you do sa do and promenade her
    <L>We sure make lots of waves on the water
    Rock'n in Rosalie's boat.</L>
    
    MIDDLE BREAK - CLOSER
    
    Sides face, grand square (32 beats of drum rhythm) 
    Four ladies promenade one time around
    Get home and swing with your man
    Left allemande and promenade her
    <L>We sure make lots of waves on the water
    Rock'n in Rosalie's boat</L>
    
    FIGURE
    
    Heads roll away
    Zip into the middle and back
    Star thru - make a right hand star
    Heads star left in the middle - travel all the way around
    Square through the outside two - go 3
    Trade by, swing thru, boys trade, girls turn back
    Promenade the ring - go
    <L>*We sure make lots of waves on the water
    Rock'n in Rosalie's boat</L>
    
    TAG
    
    <L>Rock'n in Rosalie's boat
    *Note (second time through) 
    We sure makes lots of waves on the water
    Rock'n in Rosalie's</L>
    

    This file is just a plain ASCII text file. The requirements are

    1. Headers (e.g., OPENER, MIDDLE, BREAK, FIGURE, TAG, etc.) must be entirely in uppercase and on a separate line. The header may be more than one word (e.g., OPENER - MIDDLE BREAK can be a header)
    2. The remainder of the text (i.e., the lyrics and figures) should be in normal case (mixed uppercase and lowercase as appropriate).
    3. The actual lyrics of the song should be surrounded by <L> and </L> tags. <L> indicates the start of a lyric phrase, and </L> indicates the end.

    I will also need additional information about the record (i.e., the record label, record number, title of record, type of record (singing call, patter, etc.), and artist(s).

    last modified: 01-August-2008   ID: 306
      
      
      
  22.  
    HTML doesn't display correctly
     
    I wrote out a cue sheet and saved as an HTML file. When I attach it to the music file, it does not show up in HTML format. It shows up as if it were a text a file. See below...

    #BEGIN#
    #Rosalie's Boat#
    and so on.....

    That's because the file you created isn't a valid HTML file. This file, however, can be used as an input file by CSDS to create HTML files. It is used via Music | Edit Music Database | Edit | Upgrade Cue Sheets from Web....

    To create a new HTML file for a specific music selection, first find an existing HTML cue sheet file, copy it, then edit it. Or... you can send the data to Debbie, and she will update our web-based Record Database, and later you can download the upgrade file from there.

    last modified: 25-May-2011   ID: 473
      
      
      
  23.  
    HTML markup format
     
    I'd be interested in marking up my lyric sheets identically (well, almost) to yours, but clearly you use some proto-markup-language that gets converted to the HTML on import (and/or by your DB system). I have about 200 .txt files for singing calls that are not in your lyrics DB. Let me know if you think this would be useful & if so, some details about your markup syntax.

    I'd be interested in getting the lyric information from you, so I can add it to our web-based Record Database. If you decide to give me the txt files, I will need additional information (i.e., the record label, record number, title of record, type of record (singing call, patter, etc.), and artist(s).

    Basically, the format required is:

    1. Headers such as OPENER, ENDING, MIDDLE-BREAK, etc. must all be in uppercase.
    2. Lyrics (not the calls) must be surrounded <L> and </L> tags.

    For example, here is a cue sheet:

    OPENER - MIDDLE BREAK - CLOSER

    Four little ladies chain, go straight across the square
    You roll away, circle to the left from there
    Four ladies roll away, circle to the left and then
    Allemande left with the corner of the hall
    Weave around my friend
    <L>You are the one, you're the one in my heart
    My darling, my life's greatest thrill,</L>
    Promenade
    <L>You are the one in my heart and I know
    That I love you and I always will</L>

    FIGURE

    Head two couples promenade, halfway around the square
    Come down the middle, right & left thru
    Turn that lady there
    Flutter wheel and then, sweep 1/4 more
    Pass thru, square thru go walkin' round the floor
    Four hands and then, partner trade and roll
    Swing the corner, take her by the hand
    Promenade her home
    <L>You are the one in my heart and I know
    That I love you and I always will</L>

    TAG

    <L>Yes, I love you and I always will</L>

    ID: 249
      
      
      
  24.  
    Import fails
     
    The Import of downloaded cue-sheets fails.

    0 cue-sheets updated (1466 processed).

    Is this a restrictions of the DEMO-version ??

    There is no such restriction for the DEMO version of CSDS.

    For the 'Upgrade Cue Sheets from Web' procedure to work, each entry in the music database must have its 'Label' and 'Label #' fields properly set.

    The 'Upgrade Cue Sheets from Web' function only adds cue sheets for entries in the music database in which the 'Label' and 'Label #' fields match a corresponding item in the 'downloaded cue sheets' file. Therefore, it is imperative that these two fields are properly set.

    For example, "Rockin' In Rosalie's Boat" must have the Label set to 'Chaparral' and the Label # set to '202', or else the cue sheet will be not associated with the music.

    If you still have problems, send me the file generated via 'Edit Music Database | Tools | Export (dump database)', and I'll take a look at it.

    last modified: 13-October-2011   ID: 191
      
      
      
  25.  
    Internet Explorer (MSIE) 7
     
    Upgraded to Explorer 7 and now my cue sheets (html) will not open (get "this program can't display this web page") file:///C:/SQDATA/ceder%2520cue%2520sheets/MamaBear-JayBarKay-140.html

    What do I do to correct this or what did I do wrong?

    1. Make sure you have the latest version of CSDS, as this problem was supposedly fixed a few versions ago.
    2. Assuming you have CSDS 1.23.12 or later, try the following:
      1. from the CSDS main menu, select 'Systems | Settings'.
      2. go to the 'Web' tab.
      3. try different combinations of checking/unchecking the checkboxes.
      Hopefully, this will fix the problem. I successfully run CSDS on both Windows XP and Vista with Explorer 7.

    What operating system do you have? What version of CSDS? Have you rebooted since installing Explorer 7? You might try re-installing (complete version) of CSDS after upgrading to Internet Explorer 7.

    last modified: 03-December-2007   ID: 690
      
      
      
  26.  
    Label Pictures not showing up
     
    I have an issue with the label picture showing up in the cue sheets.

    I moved my installation from one computer (Windows XP) to another computer (Vista 64) and now the label picture in the right upper corner of each cue sheet won't show up. It's just a box with a red x. I have edited a couple of the cue sheets and found that the HTML code is pointing to the old location in Windows XP (C:Program Files\SQDATA\Labels\label#.gif). When I installed SQData on my Vista PC it installed to C:\Program Files (x86)\SQDATA. Now the sheets don't know where to find the label pictures. Do I have to edit each one of my cue sheets or is there a tool for this? Is there a way to fix this within CSDS?

    If you don't have any (or very few) cue sheets that you've added yourself or modified, I suggest the following (which deletes then re-creates your cue sheets and lyrics):

    1. Get CSDS 1.24.00 or later.
    2. Delete all your cuesheets except for the ones that you created/modified.
    3. Run CSDS and do the following:
      1. Goto 'Music | Edit Music Database';
      2. Select ' Tools | File pathnames | Find non-existent files';
      3. Check the 'Clear cue sheet (or lyrics) field if the cue sheet (or lyric) file does not exist;
      4. Click OK;
      5. Select 'Edit | Add cue sheets and lyrics from Database...';
      6. Close the music database, saving changes.

    last modified: 24-March-2008   ID: 697
      
      
      
  27.  
    Lost my cue sheets
     
    I followed your instructions for moving CSDS to my new laptop, got it moved over and it worked.

    However, for some reason I can NOT get the cue sheet, I've followed your instructions for updating, etc. and every time I click on a cue sheet I get 'path cannot be found' c:sqdata/cue sheets/Temp_

    Do the following to reset your cue sheets:

    1. start CSDS;
    2. goto Music | Edit Music Database;
    3. select Tools | File pathnames | Find non-existent files;
    4. check the last box, 'Clear cue sheet (or lyrics)...' then press OK;
    5. close the 'results' box;
    6. select Edit | Add cue sheets and lyrics from Database...
    7. close the 'results' box;
    8. close the 'Edit Music Datbase' window, saving changes.

    last modified: 01-November-2009   ID: 714
      
      
      
  28.  
    Miscellaneous questions
     
    1. I was looking at your cue sheets on the web and noticed they look like they are in HTML. Are they and if so, can you tell me why?
    2. What program do you use to type them in?
    3. It also looks like you have them all typed on one sheet. Do they not need to be typed in individual files?

    1. The cue sheets on our website physically reside in a database. When accessed, the PHP language is used to dynamically create the displayed HTML page.

      The cue sheets are in HTML format because that is the standard format for the web.

    2. I use a text editor (e.g., Notepad, Wordpad, HTMLKit) to edit my HTML files.

      Programs such as Microsoft Word can also be used to edit HTML files -- if you select 'Save As HTML'.

      If you create your own cue sheets, I suggest that you save them in RTF (Rich Text Format). Rich Text Files display faster within CSDS, and eventually, our web-based cue sheets will also be available in RTF.

    3. To be used by CSDS, each cue sheet must be in a separate file.

      The 'Download Cue Sheets for CSDS' option within the Record Database on our web site has all the cue sheets in a single file, so that CSDS can easily extract those that are needed.

    last modified: 25-May-2011   ID: 309
      
      
      
  29.  
    Missing from download file
     
    Some cue sheets that appear in your database are not in the download file. Is this because the download file has to be updated on your end?

    There are two reasons why a cue sheet is missing:

    1. Not all records in our web-based database have had their cue sheets added yet. It's a never-ending job, and Debbie works on it when she can. And, of course, I keep purchasing new records too...
    2. In order for CSDS to automatically add a cue sheet to an entry in the Music Database, the 'Label' and 'Label #' field of the entry must match the corresponding fields in the web-based Record Database.

    If you find that our Record Database is missing specific cue sheets, or the record simply isn't listed, please supply the information so that I can add it to the database. This enables others in the future to download those cue sheets. I've had a couple of other callers supply me this information. If you would like to assist, I need the following for each record:

    Label
    Label Number
    Type (singing call, patter, two-sided patter, round, etc.)
    Artist(s)
    Cue Sheet information

    If the cue sheet information is supplied in the appropriate format (i.e., the same format as the downloaded file), it is an easy task for me to use cut and paste to add the new information to the database.

    ID: 163
      
      
      
  30.  
    Missing lyrics
     
    My issue concerns Silver Sounds 222 ("I Can't Believe That You're In Love With Me"). I own this, and for some reason, CSDS recognizes the label and correctly brings up the Cue Sheet, but not the Lyrics. Both are available online at ceder.net, so I think some adjustment must be made.

    Geesh! The lyrics were just added yesterday.

    If you want the absolute latest and greatest cue sheets and lyrics, use 'File | Auto update from web' (in both the Cue Sheet and Lyrics database) instead of 'File | Update from web file'.

    The former does a realtime query of our web site, to get the most recent changes.

    The latter makes you download then import files that are generated about every week or so, so they don't necessarily have the most recent changes. There is a date associated with the web file (e.g., " A thru M -- 953 lyrics (24-December-2007) [1.11 MB]") that tells when the file was last generated.

    last modified: 25-May-2011   ID: 694
      
      
      
  31.  
    Only one cue sheet per music file?
     
    I'm entering cue sheets for various dances. It appears to me that only one cue sheet can be associated with a music file. I have quite a number of records for which there are multiple dances. For example, some of the records have one or more line dances and/or one or more round dances. I can also envision creating more than one square dance cue sheets for various levels (i.e. teaching, basic, mainstream, plus, etc.).

    What do you recommend to deal with this?

    You could add the same music more than once to the music database. Each entry could then have a different cue sheet. You could rename the entry to be "song-name (MS)", and another "song-name (Plus)", etc.

    The music database also has a 'Lyrics' field, which behaves the same as the 'Cue Sheet' field. In this manner, two windows will pop-up when you load the music within the 'Call from Screen' portion of the program.

    Or, you could just create a big cue sheet with everything in it, and scroll down to the part you wanted.

    last modified: 25-May-2011   ID: 386
      
      
      
  32.  
    Strange display
     
    I tried an update for the web for my cue sheets , it did find a few, but they dispay a little strange. I have attached a print screen so you can see what they look like displayed.

    It's probably a style sheet problem.

    Go to "System | Settings | Fonts | HTML Cue Sheets" and play around with the settings.

    last modified: 21-August-2006   ID: 619
      
      
      
  33.  
    Unable to bring back music player
     
    When I go to 'call from screen' with a word cue sheet, the cue sheet and the player are displayed on the screen. If I hit "p" for play and then hit "M" to get rid of the player, I can't get the player back by hitting "M" again. Is that normal or have I got a setting in the wrong place?

    If your cue sheet is a ".doc" file, it is displayed within CSDS in an imbedded copy of MS Word. When this is the case, MS Word grabs keystokes that may have been intended for CSDS.

    The cure is to not to use ".doc" files. Try using ".rtf" (the preferred format for CSDS) or ".html" files instead.

    last modified: 06-January-2008   ID: 582
      
      
      
  34.  
    Upgrade from web
     
    In the 'Edit Music Database' section, there is a menu option to 'Upgrade Cue Sheets from Web'. How do I do this?

    To download cue sheets, do the following:

    1. Goto the record database on our web site (i.e., http://www.ceder.net/recorddb/view.php?action=ftt);
    2. click on the menu item entitled 'Download into CSDS';
    3. At this point, your browser should be displaying a list of instructions. You might want to print it.
    4. Click on the link entitled 'Create a new window with a text file that can be imported into CSDS';
    5. At this point, a new browser window opens up, and should prompt you for where the file should be downloaded. Select a download location and click the 'OK' button;
    6. At this point, the browser downloads all cue sheets from the web. The cue sheet information is stored in a single file.
    7. Run CSDS, and, from the main menu, select 'Music | Edit Music Database'.
    8. From the 'Edit Music Database' menu, select 'Edit | Upgrade Cue Sheets from Web';
    9. For 'Source File', enter the file that your downloaded in step #5.
    10. For 'Destination Folder', select a folder in which to save the extracted cue sheets. I use C:\SQDATA\cuesheets. If the folder does not exist, the program may crash (I will fix this soon). You may first need to create the folder via the windows file explorer.

    Note: this procedure creates cue sheets only for music that exists in your music database that matches with the 'Label' and 'Label #'.

    last modified: 25-May-2011   ID: 103
      
      
      
  35.  
    Using the supplied cue sheet files
     
    How can I make use of the two cue sheet files "csds_cuesheets_a_thru_m.txt" and "csds_cuesheets_n_thru_z.txt" located in my directory where also the program files are located:

    The most recent cue sheet files can be downloaded from http://www.ceder.net/recorddb/csds_download.php

    Likewise, the most recent lyrics can be downloaded from http://www.ceder.net/recorddb/csds_lyrics.php

    To automatically load cue sheets into the CSDS Music Database,

    1. Start CSDS.
    2. Select menu option Music | Edit Music Database.
    3. Make sure that the 'Label' and 'Label #' fields are properly set for all records in the Music Database. In particular, the 'Label #' field should usually just be a number (e.g., 102) and not include a side A or B.
    4. Select menu option Edit | Upgrade Cue Sheets from Web....
    5. In the resulting dialog box, browse to the csds_cuesheets_a_thru_m.txt file. Select a destination folder (this folder must already exist). Then click the 'OK' button to begin the process.
    6. repeat steps 4 and 5 for csds_cuesheets_n_thru_z.txt

    Loading lyrics is similar, select menu option Edit | Upgrade Lyrics from Web and file 'csds_lyrics.txt'.

    ID: 485
      
      
      

If you have a question that is not answered here, feel free to E-mail Vic at

https://www.ceder.net/faqdb/view.php?section=1&category=38
21-November-2019 01:23:24
Copyright © 2019 Vic Ceder.  All Rights Reserved.