Where to begin reloading music lost

[Beavis]

are you absolutely sure the hard drive is dead ??

you can always take the hard drive out of the case and hook it up to a desktop as a slave. it may run long enough to get all you kma files to another hard drive.

[Nitecat]

Beavis,

The computer tech at my electronic repair place has tried everything and says he cannot retrieve the data from the hard drive. Originally we had hoped that the hard drive inside the case would be fine. They now believe it is also damaged. They say that the USB port got pushed in and damaged some things inside (capitor, transistor.... I think). They opened the case, removed the hard drive and tried a number of things to get it to work, but no luck. They said for the USB port to be damaged like this, the drive was most likely dropped. I know for a fact that it has never been dropped or mishandled. I am very puzzled about how it was damaged, but guess even if I could figure that out, it doesn't help me now. I had tried a couple times to back up this drive that had all my KMA files, but was not successful in getting them all backed up. The drive would always stop part way through during the backup, which I now believe was due to the drive file system being FAT32 instead of NTSF. I did get 38 gigs backed up out of 53, so I am at the point now of trying to recover (reload) what I am missing. Believe me, once I manage to get the 53 gigs loaded again, I will have several drives backing this up. I will never put off getting that accomplished again.

Norm has been kind enough to offer advice. I don't want to proceed with anything until I know for sure what I am doing. I'm in a bad enough spot now without making it any worse. So that's where things are.

If you know of any other way to try and get the data from the damaged drive, please give me detailed instructions. I'll try anything. Thanks. Nitecat

[nreel]

Q1. Yes, this is an MSAccess Database. MDB is from an MSAccess Database.
You are looking for SONGS.MDB

If you cannot see the extension "MDB" then do this: (assuming you have WinXP)
Open MY COMPUTER

Click on TOOLS at the top

Click on FOLDER OPTIONS at the Bottom of the TOOLS Menu

Click on the VIEW Tab in the FOLDER OPTIONS Menu

Under FILES and FOLDERS, make sure all Boxes are "CHECKED" but the box next to the one that says "Do Not Cache Thumbnails."

Under HIDDEN FILES and FOLDERS, make sure the RADIO BUTTON on "Show Hidden Files and Folders" is selected. Make sure all Boxes are "CHECKED" except the FOUR boxes next to the ones that say "Hide Extensions For Known File Types," "Hide Protected Operating System Files," "Restore previous Folder Windows at login," and "Show Control Panel in My Computer."

Click APPLY
Click OK

Now you should be able to see all extensions on all files.

The, original, Songs.MDB, prior to Hard Drive Failure, is what you are looking for and trying to save.

Q2. I have MSAccess Software, so I don't know if you will be able to OPEN the SOngs.MDB if you do not have MSAccess.
Once you locate the Songs.MDB, double-click the file and see if it Opens. If it does Open, then you can read the file.

Q3. Correct
Info about Brand/Disc#/Track#/BookID#
If you can Open the files, you can Print them.

Q4. Alpha Sort, meaning, "to put in order," however that order is.
First, I would Alpha sort the Book ID column so that an accounting of all Book Ids will be at a ready reference and Print the Data.

This gets tricky Alpha Sorting this column because there are no leading ZEROS on BOOK ID 1, which is where MTU didn't see the wisdom in adding Leading ZEROS - which, as you can see, is needed for just this purpose - Alpha Sorting, and you will end up with this kind of Sort:
101
10101
Obviously, 10101 (ten thousand one hundred and one DOESN'T come after one hundred and one...does it? I mean, there are a lot of Book Ids between 1 and 101 that will not Alpha Sort where they should be due to the lack of leading ZEROS.)
With 3 Leading Zeros: (This accounts for 9,999 discs, which we will never see in our lifetime.)
000101
000102
etc.
010101
Which, an alpha sort would be 100% meaningful on the Book ID column.
But, suffice to say, most of the Book IDs will be in order.

Unless you know how to REPLACE text...Then, you can add 3 ZEROs in front of all numbers beginning with 1 through 9 and Two ZEROs in front of 10 thru 99 and One ZERO in from of 100 thru 999 so that all Book IDs will have the same number of Place Holdings for true Alpha Sorting. This is very complicated, though.

Then, I would Alpha Sort on the Disc# and Track#. Go through Disc by Disc and separate what I have from what I don't have.

Once separation is accomplished, I would use the OLD Songs.MDB to determine, on a disc by disc basis, what Book IDs belong to the remaining and unaccounted for discs and Re-import those discs using the, now, known and previous assigned Book ID.

The saved SongBook file may help, somewhat, but, Book Ids without Disc Numbers may be worthless. Even, assuming you had your SongBook print the Disc Id info, the Disc IDs are not in columns by themselves in order to perform an Alpha SORT.

Basically, it may become an added reference for checks and balances.

Q5.Fortunately, when the database is rebuilt with what you have salvaged, all the editing, previously done to the KMA Header, will be restored.

Unfortunately, any disc that needs to be re-imported will only go by the data pulled from the BUCKET.MDB. However, the silver lining is that, with the Original SONGS.MDB, you can compare, line-by-line, info of how its Artist/Song Title info was to the Song info you are getting ready to Import and make changes accordingly.

I know that this is a lot of info, but approaching the problem in a systematic way will help ease the burden.

If you need help in manipulating your Songs.MDB PM (Private Message) me your email and I will help as much as I can. I could probably tell you, in about 3-hours, what is missing and what Book Ids belong to what is missing.

Norm

For those of you, other than Nitecat, who may read this POST but do not have the ability to understand what I am offering, in the way of help, I will spell it out.

I am not asking Nitecat to send me ANY KMA files. I am only offering assistance with his MSAccess Database.

[Nitecat]

Norm,

Well, I just finished typing a long posting to you on all of this. When I hit send, I discovered my internet connection was gone.....and of course then so was the lengthy posting. So, I'll start again. My luck just has to get better.

Wow, thanks for all of the great information. I had been trying to figure out how to get those file extensions to show and knew there was a way, just hadn't found it yet. Your intructions were great. Anyway, I do have the songs.mdb file, but cannot open it without Access. I'll either take the file to work where I have Access or buy Access for use at home. I'm stuck till I do one of those. I think I understand everything you have said. If I run into trouble, I'll send a PM. Was posting on here so that others might benefit from something we cover.

As for the Alpha Sort, I did understand that you meant for me to put the file in order by Book Id. I was just confused that it was an Alpha sort when it looks like it should be a numeric field. Perhaps it is categorized as an Alpha field even though it contains numbers. I don't know if I'll try the adding zeros thing to the 1-9 and 10-99 listings. You are right, I wish MTU had that already built in. Would be one less thing for me to handle right now.

I'm glad there is a way for me to be sure I have the song title and artist listed the same as before on the songs I reload. Whew! This will be quite a process. I do have one more question at this point:

Q1. I understand that MTU changed some of the disc names in Hoster 3.0. I read a post someplace about that, but didn't look into it much, since I had just printed my books with the old names. How do you think that will affect what I am doing now? How have you handled that with your database and songbooks? I'd prefer that my songbooks match the disc names in my database, but maybe that is not possible now with Hoster renaming discs and my having to reload some. I suppose if I have to reload a disc that was renamed by MTU, it will have to have the new name? If so, then it won't match the songbooks that I just printed.

Guess that's about it for now. Thanks again for all your help. You'll probably hear from me again. Oh, by the way.......I'm a chick!! I thought your assumption that I was a guy was kind of cute though. You've been great and very clear in your instructions. Thank goodness for the boards here. Would you believe this hard drive problem happened at my FIRST Hoster show? I had hoped for a glorious night like other Hoster users, since I had been working on getting ready for this since August 1. I had had no problems with anything until my external drive went bad. That is of course the worst thing I could imagine happening. I will certainly understand better how it all works and will get through this problem, if it kills me. Until I can run Hoster, I'll be looking up each song manually (my books now show Book ID for Hoster use) and flipping discs. I want to resolve the reloading issue soon!!

The not techy enough Chick.......Ruth (Nitecat)

[nreel]

Hi Nitecat,

Sorry about the gender comment. I usually keep it neutral but I see I slipped in that last sentence. I almost made it...LOL.

I kind of figured you weren't seeing the file extension names. So, I'm glad my directions worked out.

MSAccess has two Tool Icons to perform a SORT. They are side by side with one icon having a letter A above the letter Z with Down Arrow and the tool tip says SORT ASCENDING. The other Icon is just the opposite with letter Z on top of the letter A with the tool tip saying SORT DESCENDING.

Since the Icons were showing letters and could be used to sort any column, whether or not the column was Numeric, Alpha/Numeric, or Text, I just called it an Alpha Sort.

Yes, adding leading ZEROS is quite tricky when performing a REPLACE function. You want to add 3 Leading ZEROS to all Book Ids from 1 to 10, but you don't want to add 3 Leading Zeros to Book Ids from 100 to 1000, which start with a 1, and so on.

But, if you take the time to get all the Leading ZEROS in the right place, sorting the Book ID column will prove invaluable.

Q1. First, I do not use the MTU SongBook Feature to print my SongLists. However, I think, in your case, you will be OK with your newly printed SongBooks and should not affect your show. It is true that some BRANDS have changed, but the BRAND, if you chose to list them in your SongLists, are only for the Singer's convenience. These BRAND Prefixes have nothing to do with you running your show because you will only be interested in the Book ID Numbers that the Singers give you.

If any BRAND is different upon re-importing, then, this will straighten itself out upon the next Complete SONGBOOK printing that you will, eventually, do.

What you see, when operating Hoster at a show, compared to what the Singer sees in your newly printed SongBooks, will not be in conflict if you run into the situation of a BRAND change. Because, again, you are only concerned with the Book ID numbers...not the BRAND.

You will be the only one to know the difference. For instance, and, I'm not sure what may have changed, but, for example, if the Previous designation for POP HITS ROCK 0410 was PHR0410, and, is listed in your new SongBooks that way, with Book ID 102, now becomes POP HITS MONTHY ROCK 0410 with a designation of PHMR0410, with Book ID 102, you will be the only one to know anything has changed. You will have, still, assigned and IMPORTED this disc on the ORIGINAL Book ID…So, no harm.

My New Year wish is that you will be successful with all your shows using Hoster.

Again, if you want me to straighten out your Songs.MDB by adding ZEROS where needed, just say the word. I've done this several times over the past year and a half that I've been using Hoster and I have become quite proficient.

Norm

[Nitecat]

Norm,


I now have Access. Purchased the upgrade version last night and loaded it. All fine there. I can now open the songs.mdb file and have done the sort on Book ID. I really do think it would be much easier if they sorted correctly (with those leading zeros in place). Can you give me instructions on how to do the replace on these to get the zeros as they should be or is it too complicated? I hate to have you spend any more time working on this than you already are now with all of your wonderfully detailed posts. I certainly do appreciate the personal attention you are giving me with my problem. I hope MTU appreciates users such as yourself.

I assume that once I get this file into a useable Book ID order, I can widen columns to see all in the field and hide columns I don't care to see (can I delete them?), then print the file. When I have both my original songs.mdb file and the new songs.mdb file with the 38 gigs of songs I had backed up printed out, then I will manually compare the two printouts line by line and determine what I need to reload and what Book IDs to use, etc. Does this sound correct?

Will wait to hear from you before I do anything more on my end. Thanks. Ruth (Nitecat)

[nreel]

If you haven't used Access, it will be exceptionally hard to explain.

Also, do you have WinWord?

WinWord allows more Replace features that are not possible in Access.

Assuming you do, here's what you will do. Keep in mind this is a way I found to do it. There may be others who are more knowledgeable and can do it easier.

OK...you asked for it...here it is...Good Luck !!

Task=Make all BookIDs 6-Place numbers by adding leading ZEROS. 6-Place Number will allow for BookIDs up through 9,999 (9,999 Discs), which no KJ will ever have in my lifetime.
Reason=So that one may SORT on the BookID Column in the SONGS.MDB and cause all the BookIDs to be in ORDER.

You may want to make a Backup copy of your Songs.MDB so that, if you make any mistake on the one that you are modifying, you can restore with the Backup and start over.

Open WinWord...do not CLOSE
Open Access...do not CLOSE

ACCESS 1 STEPS
.1. Open Songs.mdb
.2. Double Left-Click the SONGS TABLE to OPEN and MAXIMIZE the window.
.3. Left-Click on BookID Column Header to Highlight the BookID Column.
.4. Left-Click the A/Z (with Down Arrow) Icon to SORT ASCENDING.
.5. Left-Click RECORDS.
.6. Left-Click FILTER.
.7. Left-Click ADVANCED FILTER SORT (Field should be filled-in with
.....BookID/Ascending).
.8. In the CRITERIA Field, Enter: Like "???"
.9. Right-Click Mouse anywhere in the solid Grey area.
10. Left-Click APPLY FILTER SORT.
11. Left-Click on BookID Column Header to Highlight the BookID Column.
.....(All Filtered Records should be Highlighted.)
12. Right-Click anywhere in the Highlighted area.
13. Left-Click COPY.

WINWORD STEPS
.1. Left-Click on the WinWord Icon that is located on the TASKBAR.
.....(WinWord should Maximize and show a BLANK DOCUMENT 1 -- We'll use this Doc.)
.2. Right-Click anywhere on the Blank Document.
.3. Left-Click PASTE.
.4. Left-Click BookID, located at the TOP of the single column Table, to
.....Highlight the Table with the words BookID in it. To HIGHLIGHT this table,
.....you must place the CURSOR in the LEFT MARGIN just to the LEFT of the
.....TABLE that contains the word BookID and Left-Click.
.5. Right-Click in the HIGHLIGHTED area.
.6. Left-Click CUT.
.7. Left-Click the COLUMN of Tables to HIGHLIGHT.
.8. Left-Click EDIT that is located on the TOP BAR.
.9. Left-Click REPLACE
10. Left-Click MORE
11. Left-Click USE WILD CARDS
12. Enter in the FIND WHAT Field: <(1)
13. Enter in the REPLACE WITH Field: 0001
14. Click REPLACE ALL -- If asked if you want to search the remaining Doc.
.....Answer NO.
15. Repeat steps 12-14 but change FIELDS to all single numbers from 2 thru 9
......IMPORTANT - The FIND Field MUST MATCH THE REPLACE Field
......DO NOT GET THIS WRONG !!
......... ex. <(2) and 0002
...............<(9) and 0009 and every number between.
16. Left-Click anywhere in the WHITE area of the Document.
.....(Column should still be Highlighted)
17. Right-Click in the Highlighted area.
18. Left-Click CUT.

ACCESS 2 STEPS
.1. Left-Click MSAccess Icon on TASKBAR
.2. Left Click SONGS:TABLE (BookID should still be Highlighted)
.3. Right-Click anywhere in the HIGHLIGHTED area.
.4. Left-Click PASTE
.5. Left-Click YES to accept the changes.


Repeat process ONCE if you have less than 100 BookIDs and TWICE if you have more than 100 BookIDs following the procedure below.

If ONCE, you will add ONE additional QUESTION MARK (?) in STEP 8 of ACCESS 1 STEPS.
.......(In the CRITERIA Field, Enter: Like "????")
A N D,
You will DECREASE the number of ZEROS in STEP 13 of WINWORD STEPS by ONE.
.......(Enter in the REPLACE WITH Field: 001)

If TWICE, first complete the one above, then, continue with this.
Add TWO additional QUESTION MARKS (??) in STEP 8 of ACCESS 1 STEPS.
.......(In the CRITERIA Field, Enter: Like "?????")
A N D,
You will DECREASE the number of ZEROS in STEP 13 of WINWORD STEPS by TWO.
.......(Enter in the REPLACE WITH Field: 01)


Hopefully, these steps will be easy to follow.

Norm

[Nitecat]

Norm,

First of all......happy new year!! Also, thanks for the wonderfully detailed answers that you have given me. You are one great guy! I have made it through New Year's and another night of karaoke (without my Hoster). Tomorrow and Sunday I'll be focusing on figuring out the databases and getting something to compare...then begin the process loading my missing music.

Wow, that find and replace stuff looks complicated. I hope I can manage. I did have a bright idea today and wondered what you thought. I thought that if I opened the songs.mdb file in Windows Explorer and could somehow print the list there, I would have the list of discs by manurfacturer and could then compare to the file in Access. If this is somehow possible, I could sort the Access file by Manufacturer also (not sure if this is possibel). Anyway, it was a thought and my main problem is if you open a folder with Windows Explorer, is there some way to print the list of files. I figure there surely is. I haven't managed to find out how to do this yet. Any ideas? I'm trying to figure out a way to avoid adding those zeros to the Book Ids in Access....lol. If this makes no sense, it's because I been running karaoke all night and celebrating the new year. Any thoughts? Norm, I know you seem to be night owl like myself. Ruth (Nitecat)