Importing songs from my own numbered discs

[bryant]

What is the simplest and quickest way to import songs (while keeping a reasonably fast searching system) from my own discs that are already logged in my current songbook as disc numbers such as 854 , 855, etc., etc. Most discs contain about 18 songs each but only have the title and track in the file name ("title - track.bin"). I have renumbered all my brand-name discs as well with simple three digit numbers. Some discs are also filenamed as "artist - title", while some are filenamed as "title - artist". Will I have to rename all these files with a disc and track number in front of their filenames as I import them. Will I have to rename the "artist - track" ones to a "track - artist" sequence. That would take a year or two with 5,000 songs, wouldn't it? Help!

[Beavis]

re-do your books and use the book id !

i changed all mine from my personal format and im glad i did !

[mindonstrike]

Originally Posted by bryant

What is the simplest and quickest way to import songs (while keeping a reasonably fast searching system) from my own discs that are already logged in my current songbook as disc numbers such as 854 , 855, etc., etc. Most discs contain about 18 songs each but only have the title and track in the file name ("title - track.bin"). I have renumbered all my brand-name discs as well with simple three digit numbers. Some discs are also filenamed as "artist - title", while some are filenamed as "title - artist". Will I have to rename all these files with a disc and track number in front of their filenames as I import them. Will I have to rename the "artist - track" ones to a "track - artist" sequence. That would take a year or two with 5,000 songs, wouldn't it? Help!

It appears that the fastest/easiest way to keep your custom numbering is to reimport from original CDG. Then you are only looking at a couple of weeks

[bryant]

To Beavis: Yes, but by re-doing my books only solves part of the question. I would still (or would I not) have to enter the disc and track number of every song in the program. Also, and would I still have to convert the songs that are "artist - title" back to "title - artist". Please clarify how you determined that re-doing my books will eliminate the work I had previously posted. Perhaps I am missing something, I am a brand new user still with NO experience whatsoever.

Thanx

[bryant]

To MindonStrike: Yes, but the original discs are numbered in my songbook with my own simplified numbering system, e.g., a three digit disc ID and track number only. The numbers on the original are usually long and cumbersome i.e., CBEP-6-04-01. Mine would say 888-1. SO I would still have the problem of my books not conforming to a more cumbersome numbering system. Also, I have re-arranged some songs on original discs to my own discs with their own numbers as well; to save space and not have too many junk songs.

[bryant]

Originally Posted by Beavis

re-do your books and use the book id !

i changed all mine from my personal format and im glad i did !

Please explain exactly what you did and how you did it? How many songs? How long did it take? What prompts you to say "I'm glad I did"! Did you use the book ID and nothing else (just artist and track)? Please help again?

[mindonstrike]

Originally Posted by bryant

To MindonStrike: Yes, but the original discs are numbered in my songbook with my own simplified numbering system, e.g., a three digit disc ID and track number only. The numbers on the original are usually long and cumbersome i.e., CBEP-6-04-01. Mine would say 888-1. SO I would still have the problem of my books not conforming to a more cumbersome numbering system. Also, I have re-arranged some songs on original discs to my own discs with their own numbers as well; to save space and not have too many junk songs.

Based on your initial post it appears that your file system is extremely inconsistant which is what will make importing from the hard drive slow and cumbersome.Files that are numbered and corespond to a disk will be easy as you just tell Hoster the brand and diskid and the root id you wish to use for that disk, for example you select 888-1 and Hoster would place every file that starts with 888 into the import list, you then tell it that it is a Chartbuster brand with a disk id of CBEP456-4, you then tell it to assign the rootid of 888 to that disk, and in 2-3 minutes (about 10 seconds per track importing .bin's) that disk is done.
With files that do not have something like a number or diskid with a track # to tie them together, you will have to go through that whole process 1 song at a time

The numbers on the original are usually long and cumbersome i.e., CBEP-6-04-01

The disk id is only used by Hoster to look up artist/title info when it is absent from the file, otherwise it has little to do with how you number things.

There are no rules saying you can't mix import methods. You could do the easy ones from the hard drive and the harder from CDG's. You'll just have to study your situation and see what's going to work best for you.

Sam

[Beavis]

there is no easy way to correct the mis-match in the importing process you used.

i went back and corrected each song (spelling & first name first) it took a while, but my book is correct now and was well worth the time.

[lmcmains]

Your books and bood ID should look something like this when you use Hoster's book ID's. This is just pasted in so it don't look as good here. They come out in two colums, and have a line bewteen the artist and the book id.



Jennifer; 1225-15
And I Love Her; Beatles, The; 1577-05
And I Love You So; McLean, Don; 1374-03
And I Love You So; Como, Perry; 267-03
And I Love You So; Presley, Elvis; 248-05
And It Stoned Me; Morrison, Van; 1391-09
And She Was; Talking Heads, The; 1339-13
And So It Goes; Joel, Billy; 1054-09
And Still; McEntire, Reba; 155-12
And The Beat Goes On; Whispers, The; 1054-15
And The Cradle Will Rock; Van Halen; 366-15
And The Crowd Goes Wild; Wills, Mark; 2079-01
And The Grass Won't Pay No Mind; Diamond, Neil; 2347-10
And Then; Drake, Dusty; 1228-05
And We Danced; Hooters; 1054-08
And When I Die; Blood Sweat & Tears; 417-09
And When I Die; Jones, Tom; 1008-07
And Your Bird Can Sing; Beatles, The; 1134-14
Ando Amanecido; Los Tigres Del Norte; 2014-08
Angel; Shaggy & Rayvon; 1377-12
Angel; Aerosmith; 1345-04
Angel; Baker, Anita; 1203-12
Angel; McLachlan, Sarah; 1644-05
Angel; Westlife; 1922-11
Angel; Corrs, The; 1188-12
Angel; Richie, Lionel; 563-10
Angel; Stewart, Rod; 2197-05
Angel; Perez, Amanda; 2063-04
Angel; Madonna; 1544-05
Angel; Hendrix, Jimi; 1774-05
Angel Baby; Rosie & The Originals; 1054-12
Angel Boy; McGraw, Tim; 1171-05
Angel De Amor; Mana; 2093-02
Angel Eyes; Abba; 1313-02
Angel Eyes; Wet Wet Wet; 1856-05
Angel Eyes; Sinatra, Frank; 367-08
Angel Eyes; Ferry, Bryan; 1908-09
Angel Eyes; Walker, Tamara; 487-13
Angel Eyes; Ferry, Bryan; 1054-05
Angel Eyes; Jeff Healey Band, The; 418-11
Angel Face; Glitter Band; 1868-13
Angel Fingers; Wizzard; 1832-15
Angel Flying Too Close To The Ground; Nelson, Willie; 87-01
Angel From Montgomery; Raitt, Bonnie & John Prine; 1302-08
Angel In Disguise; Brandy; 1054-03
Angel In My Eyes; Montgomery, John Michael; 686-12
Angel In Your Arms; Hot; 1719-07
Angel In Your Arms; Hot; 1055-07
Angel Of Harlem; U2; 1600-13
Angel Of Mine; Eternal; 1884-08
Angel Of Mine; Monica; 345-13
Angel Of The Morning; Newton, Juice; 279-14
Angel Of The Morning; Rush, Merilee; 1055-14
Angel On My Shoulder; Cole, Natalie; 1378-11
Angel Standing By; Jewel; 162-07
Angelia; Marx, Richard; 1514-12
Angeline Is Coming Home; Badlees, The; 1543-09
Angelo; Brotherhood Of Man, The; 1713-13
Angels; Williams, Robbie; 424-05
Angels; Simpson, Jessica; 916-09
Angels; Travis, Randy; 1728-05
Angels; Grant, Amy; 1677-04
Angels (Acoustic Version); Williams, Robbie; 1958-15
Angels Among Us; Alabama; 1427-02
Angels Don't Fly; Prosser, James; 898-08
Angels Eye; Aerosmith; 1365-06
Angels From The Realms Of Glory; Christmas; 512-08
Angels In Waiting; Cochran, Tammy; 1392-05
The Angels Listened In; Crests, The; 1509-07
Angels Of The Silences; Counting Crows; 1564-15
Angels Son; Strait Up & Lajon; 1377-05
The Angels Wanna Wear My Red Shoes; Costello, Elvis; 360-01
Angels We Have Heard On High; Christmas; 506-08
Angels Working Overtime; Carter, Deana; 1055-03
Angels Would Fall; Etheridge, Melissa; 424-01
Anger Rising; Cantrell, Jerry; 616-06
Angie; Rolling Stones, The; 1375-04
Angie Baby; Reddy, Helen; 1055-12
Angry Again; Megadeth; 1284-11
Angry All The Time; McGraw, Tim & Faith Hill; 1255-13
Angry Eyes; Loggins & Messina; 2261-10
Angry Johnny; Poe; 1555-11
Animal; Def Leppard; 1127-12
Animal; Pearl Jam; 532-16
Animal (F### Like A Beast); WASP; 1253-09
The Animal Song; Savage Garden; 1903-13
Animaniacs; TV Theme; 1621-20
Ann Don't Go Runnin'; Overstreet, Tommy; 1013-09
Annie's Song; Denver, John; 720-12
Anniversary; Tony Toni Tone; 1411-11
Anniversary Song; Standard; 369-14
Anniversary Song; Jones, Tom; 2283-12
Anniversary Waltz; Standard Reminiscing; 1742-02
The Anniversary Waltz (Part One); Status Quo; 2252-17
Another ; Drusky, Roy; 2332-03
Another Brick In The Wall (part II); Pink Floyd; 1450-08
Another Brick Wall; Pink Floyd; 181-02
Another Chance; Sanchez, Roger; 1056-13
Another Chance At Love; Lynne, Shelby; 1526-07
Another Day; Lemar; 1939-13
Another Day Goes By; Dakota Moon; 1642-02
Another Day In Paradise; Brandy; 1920-15
Another Day In Paradise; Collins, Phil; 2306-13
Another Dumb Blonde; Hoku; 1321-10
Another Good Reason Not To Drink; Jackson, Alan; 593-01
Another Goodbye; Fargo, Donna; 1380-07
Another Lonely Song; Wynette, Tammy; 993-14
Another Lover; Hear Say; 1944-04
Another Night; Real McCoys, The; 1424-11
Another Nine Minutes; Grey, Yankee; 31-01

[bryant]

So are you saying that the root BookID for the first song would be entered as 157700, and the tracks from that disc(up to 99 of them) are listed as 1577 - "track #). Is it possible to assign root bookID numbers to custom discs?
Am I correct in saying that the custom discs I have with no associated brand name would all have to be typed in one at a time. I have about 200 brand name discs that are renumbered I want to keep, and about 100 custom discs that would need typing in the songs. How much time am I talking about for the import process? Estimate please? thanx.
Bryant

[bryant]

Originally Posted by mindonstrike

Based on your initial post it appears that your file system is extremely inconsistant which is what will make importing from the hard drive slow and cumbersome.Files that are numbered and corespond to a disk will be easy as you just tell Hoster the brand and diskid and the root id you wish to use for that disk, for example you select 888-1 and Hoster would place every file that starts with 888 into the import list, you then tell it that it is a Chartbuster brand with a disk id of CBEP456-4, you then tell it to assign the rootid of 888 to that disk, and in 2-3 minutes (about 10 seconds per track importing .bin's) that disk is done.
With files that do not have something like a number or diskid with a track # to tie them together, you will have to go through that whole process 1 song at a time
The disk id is only used by Hoster to look up artist/title info when it is absent from the file, otherwise it has little to do with how you number things.

There are no rules saying you can't mix import methods. You could do the easy ones from the hard drive and the harder from CDG's. You'll just have to study your situation and see what's going to work best for you.

Sam

MindOnStrike...my file system is actually quite efficient as it stands now. All my discs have no more than 5 numbers for the requester to fill in along with the artist and title on the slip.
Also, there are no duplicate songs(of approx. 5,000 now) as there is in almost all song books(many contain 5 - 10 listings of the same song with song numbers of 4-5 letters and 10-12 numbers apiece.
I understand about the program rarely using the song number, but the requester needs to fill it in with the tite; as often they make a mistake and you need the song number for searching to compare accuracies.
That is why I feel a need to keep the numbering system.
My books now are really easy to read(3 columns: title, artist, and simple number), with not one duplicated song.
However, how long do you think it will take me to log in 200 discs that have a brand name associated with them but need a new rootbookID; and another 100 custom discs with NO associated brand name( I assume I have to enter the song titles one - by- one at the rate of 15 songs per disc)?
Can you give me an estimate of how much time might be involved in this import process?
Thanx a bunch, you guys have been a BIG help!
Bryant

[mindonstrike]

Your file system may be efficient as it stands now. What I'm saying (if I'm reading your initial post correctly) is that with some files number only and some artist/title and some title/artist it will be slow and cumbersome to import

I understand about the program rarely using the song number, but the requester needs to fill it in with the tite; as often they make a mistake and you need the song number for searching to compare accuracies.

I was refering to Hoster using the diskid to lookup artist and title info for the importing process. If that info is already in the file name then an accurate diskid is not necesary. For me a song# or bookid is very important, I'm already having to deal with some KJ's in town no longer requireing it so some singers are not bothering to give me that info, I can do it that way but I don't want to. The people who give me incorrect song#s slow me up enough as it is.

However, how long do you think it will take me to log in 200 discs that have a brand name associated with them but need a new rootbookID; and another 100 custom discs with NO associated brand name( I assume I have to enter the song titles one - by- one at the rate of 15 songs per disc)?
Can you give me an estimate of how much time might be involved in this import process?

Too many variables involved in your situation to even hazard a guess. At the time I had no hard drive files and Hoster wouldn't import them at the time if I did but it took me a couple of weeks of every spare minute to do 700 CDG's, of course that was using my numbering scheme as well as taking care to avoid duplicates which slowed things up I'm sure.
Studying the manual and experimenting with different files would give you a better idea.

Sam

[bryant]

My apologies to mindonstrike and Imcmains. I forgot to add that I have not imported anything yet. My system as stands now is for using the cdg's. Just recently purchased Hoster and want to get up and running as fast as possible and efficiently once I'm there, while keeping the same numbering system in my books. If I can't , I may hold off on going to Hoster for a while.
Thanx again, keep replying as I do need your trusted expertise!
Bryant

[Beavis]

if you buy hoster you will only have to deal with one number per song. no more artist and title to fill out. each song is assigned a number.

[bryant]

Beavis; please listen to my question? I already have song numbers that work fine and do not wish to change the numbering system as I have spent much time and bukkarooson newly printed books that get all kinds of compliments as compared to the competition.

My real question is how long would you expect it to take to import those songs I mentioned in the previuos posts?

I realize each song is assigned a number, but singers request for title artist and by number because many times they put the wrong number in and you need to have the title or artist as well.

[Beavis]

you can import using your system.

it takes about 3 to 4 minutes per cdg to import.

[bryant]

Yes Beavis;
But I was referring to my special situation of loading a number of custom discs and brand name discs that need to be rset up so the rootbookid end up matching my existing disc numbers and track numbers. Will you please take a look at my post above and tell me what you might think a total time might be. Remember, my importing was a little unusual because of my persistence to retain my current song book and numbering system?
Thanx,
Bryant

[WDEWDAD7]

I have been reading this post, and have become a little confused. One nice thing about Hoster is, regardless of what your karaoke book number system is...Hoster still works. I know a few KJ's who have NO disc numbers in their books, or use NO books at all. I prefer a book because your singers like to look; and it gives them something else to do while waiting their turn. When importing, you can use " custom disc " and use any number you want. As far as how long, doesn't that depend on how many discs you intend to download? Sorry if I'm not on track with this one.

[Beavis]

in hoster you can search or enter by book id or brand. you can create your own brand by typing something in the brand slot. you dont have to choose what MTU put in there. where it say "select brand" just type what you want.

you dont have to use the book-id to enter singers choice.


i hope this is'nt getting confusing.

[nreel]

What is the simplest...way to import songs...from my own discs that are already logged in my current songbook as disc numbers such as 854 , 855, etc., etc.

With this example, I will use Disc #854
With Hoster OPEN:
1. Insert Disc #854 in the CDROM.
2. Open the IMPORT CD TRACKS Window.
3. Click the DROP DOWN arrow to the right of the BRAND and select CUSTOM ASSEMBLY
4. Click INTO the DISCID Box and TYPE the Number 854
5. Click INTO the BOOKID Box and TYPE the Number 854
6. Click the ADD TRACKS TO IMPORT Button

STOP! Read the response to the second question before proceeding.

What is the...quickest way to import songs...from my own discs that are already logged in my current songbook as disc numbers such as 854 , 855, etc., etc.

Your ACTUAL Discs may contain Title and Artist info, before the .BIN extension, but Hoster WILL NOT be able to populate its TITLE and ARTIST List Box when the ADD TRACKS TO IMPORT Button (#6 above) is Clicked.

Therefore, the answer to your second question is:
There is NO QUICK WAY...period.

Continue to STEP 7:
7. TYPE in all TITLE and ARTIST information into that correspond to EACH Trk.
8. Click the SELECT ALL Box to CHECK it, if it has not already been Checked.
9. Click PROCESS SELECTED TRACKS.
DONE.
REPEAT for EACH Disc that you have.

Make a note as to the time it takes to process Disc #854. Multiply that times the number of Discs you have left to get the time it will take to complete the task.

With the above procedure, YOUR Disc #854 will be:
Assigned DiscID 854
and
Assigned BookID 854

Your CURRENT printed Song Lists will, then, work for either looking up by BRAND, which I would never do, because it takes THREE clicks and THREE choices to finally add a Song to the Playlist, or SIMPLY enter the BOOKID, which would correspond to YOUR Song Lists DISCID.

In other words:
DiscID=BookID
So, when a Singer submits a request Slip with what they would be submitting as a DISCID of 85401 or 854-01 (However you have them listed in your Song Lists), which would be DISC 854 and TRACK 01, then, you would SIMPLY TYPE this number, without the DASH (-), in case your are using 854-01 as printed in your Song Lists, and, as submitted by the Singer, into the BOOKID Box, in which, the BOOKID is what makes Hoster soooooo unique.

ONLY HAVING TO ENTER A BOOKID is infinity quicker than adding a SONG via the BRAND!

I hope this helps,

Norm