another gem related problem

[djbikeerrob]

ok i got the program opened it i assume when you said find the OS you meant for me to look in my explorer program and find the folder mtu i did that i tried opening the database file and nothing happens when i click on it
you said to find the folder of my songs and click on it and it will load but nothing happens what is the file name for the part that i can edit i tried database.mdb and all that happens when i click on it is the screen blinks and nothing else happens. i know how to use the find and replace but i cant seem to get the proper folder/ file opened to do it. help!!!

[djbikeerrob]

why is it hoster can find and edit the database through Hosters' edit songs feature but i can not seem to open that file or even find it, with any other program? What is the name of the file? How do i open it so i can use a file renamer to fix all the errors. Why doesn't hoster have a find and replace feature in its edit songs feature? I am still weeks later going through the files one by one to take out all the damned underscores that sound choice put into their new Gem series. it will take me months doing it this way......I have also noticed that when i rename the file the singers database loses the song so thanks a lot for that. Yes i am getting a bit hacked off about all this foolishness. you would be too if you had to do literally millions of keystrokes just to get rid a some damned underscores that in any primitive word processing program could be gotten rid of in a single search and replace command.

[Roy Dennis]

I would be very wary about making changes to imported files outside of Hosters edit function.
Hosters data base "Songs.mbd" is a Microsoft Access data base file which can be opened and edited in Access or viewed in the latest versions of Excel.

But it is not advisable to edit in these programs as any changes made will be undone as soon as you use the Rebuild Database function.

As far as I can tell the program EmilioM suggested is much the same as the one I suggested although may be easier to understand and would only change the original file names not the ones in the database.
Perhaps EmilioM can come back on this and prove me wrong.
I have not tried it so can't comment on it.
Whatever you try test it first on a small test amount first before going the whole hog.

And put a suggestion in the Hoster new features requests forum for the Find & Replace, they were working on it but this might remind them.

[EmilioM]

Originally Posted by Roy Dennis

I would be very wary about making changes to imported files outside of Hosters edit function.
Hosters data base "Songs.mbd" is a Microsoft Access data base file which can be opened and edited in Access or viewed in the latest versions of Excel.

But it is not advisable to edit in these programs as any changes made will be undone as soon as you use the Rebuild Database function.

As far as I can tell the program EmilioM suggested is much the same as the one I suggested although may be easier to understand and would only change the original file names not the ones in the database.
Perhaps EmilioM can come back on this and prove me wrong.
I have not tried it so can't comment on it.
Whatever you try test it first on a small test amount first before going the whole hog.

And put a suggestion in the Hoster new features requests forum for the Find & Replace, they were working on it but this might remind them.

Roy, that may be true as far as not affecting the database. I always download to a folder first and make any corrections there before importing into Hoster. What he should probably do is go to his folder that contains his music, cut and paste all the songs that have the underscores to a new folder on his desktop. Do a rebuild to wipe out the song files from his database, process the song files that are now located in the folder on his desktop with the aforementioned program, and once corrected, reimport into Hoster.

[EmilioM]

Okay, I've got my FileRenamer open. In the FileRenamer window, (from here on out I will refer to it as FR), go to the left hand side, and you'll see Desktop, Libraries, and so on. You'll see Computer with a (+) next to it. Click on the (+) to expand it. Once you expand it, you'll see OS (C) with a (+) next to it. Click on the (+) and expand it and you'll see a bunch of folders. Go down to the MTU folder and click the (+) that's next to it to expand MTU. Once it expands, you'll see Hoster, and I have the next folder named KMA Files. Yours may not say that cause I think I renamed it, but I'm not sure. If yours says KMA Files, then that the one you need. If indeed I renamed my folder, then your folder will be called something else but regardless, it will be the folder directly under Hoster. Once you click on that folder, remember, you're still in the FR program, the files will load up on the screen to the right. Once they finish loading, that's when I go to the headers File Name and New File Name and adjust them so the complete titles show. Then you go to the Find/Replace tab and it will open the options you need. In the find box that opens, you need to enter _, and below that in the replace box you click it so your cursor blinks in the box, and hit space. Now all you do is hit the Apply button located center right of FR, and your done. It will rename all your files that have a underscore (_) to a blank space.

[djbikeerrob]

ok it loaded the kma files but they are all named things like #01-1.kma and so on i expanded the file name header but still the whole name is still
#01-1.kma there is nothing to edit, no title, simply the kma file name where are the titles? oh and please explain what you mean by OS in your post

[EmilioM]

Originally Posted by djbikeerrob

ok it loaded the kma files but they are all named things like #01-1.kma and so on i expanded the file name header but still the whole name is still
#01-1.kma there is nothing to edit, no title, simply the kma file name where are the titles? oh and please explain what you mean by OS in your post

Guess what, I didn't realize they were all KMA files. A previous post by Roy was asking if they were downloaded as Zip files and that's what I was thinking. Unfortunately being KMA files, I can't think of any way you can do what your trying to do except doing it one by one through the edit utility in Hoster. If your talking only about the Gem Series, and there aren't an outrageous amount of songs, you would have to find which ones they are, take them from your database, (KMA folder), delete them, rebuild your database so Hoster knows they are no longer there, and redownload them. Except I would download to a folder on your desktop. Once in there, you can use FR to correct the problems, and then import into Hoster. Once they're imported, Hoster will assign KMA numbers like you posted above, ie., #01-1.kma, but when you do the search and the songs come up they won't have the underscores in the title. That will probably be quicker than correcting them one by one.

[djbikeerrob]

[quote=EmilioM;106937]Okay, I've got my FileRenamer open. In the FileRenamer window, (from here on out I will refer to it as FR), go to the left hand side, and you'll see Desktop, Libraries, and so on. You'll see Computer with a (+) next to it. Click on the (+) to expand it. Once you expand it, you'll see OS (C) with a (+) next to it. Click on the (+) and

please explain what os means? i do not see any os in the list of folders by c i think you mean the c drive? but i do not see any os anywhere if thisis some type of computer shorthand then please explain.

[EmilioM]

[quote=djbikeerrob;106944]

Originally Posted by EmilioM

Okay, I've got my FileRenamer open. In the FileRenamer window, (from here on out I will refer to it as FR), go to the left hand side, and you'll see Desktop, Libraries, and so on. You'll see Computer with a (+) next to it. Click on the (+) to expand it. Once you expand it, you'll see OS (C) with a (+) next to it. Click on the (+) and

please explain what os means? i do not see any os in the list of folders by c i think you mean the c drive? but i do not see any os anywhere if thisis some type of computer shorthand then please explain.

OS (C) Stands for operating system c drive. I'm using Windows 7 and that's what the folder says on that operating system. If your seeing C, then that's the one you expand.

[ddouglass]

Ok, stop. This is getting way to complicated and even I can't follow what is being said.
Rob,
What version of Hoster are you using?

Do you still have the original folder on your desktop that you imported these from?

Did you import them as KMA or KMH format?

Answer these first and Emilio please hold off on your posts until we get some answers from Rob and try to direct him in accomplishing this project.

[djbikeerrob]

Thanks dale I got it. I am using the latest and greatest hoster so that's not the problem. I am also using windows XP. Everything is ok. I will simply keep on keeping on. It is the gem series that is the problem. Their silly/ moronic use of the underscore. Oh and " Emillo" there are at least 4800 songs like that that i have to change. Oh well it will keep me busy for several more weeks but hey once it is done wooohooo. I will be able to update my songbooks and life will be good again. lol I want to thank everyone for all their help. I also suggested to MTU that they incorporate a search and replace feature into the edit songs feature. That alone would solve many many problems. But life goes on and as they say this too shall pass I understand from admin that "find and replace" is 95% finished and should be out in version 5.10 woohoo now i know when i will buy the rest of the sound choice gem series lol. Again my thanks to all of you.

[EmilioM]

Originally Posted by djbikeerrob

ok i got the program opened it i assume when you said find the OS you meant for me to look in my explorer program and find the folder mtu i did that i tried opening the database file and nothing happens when i click on it
you said to find the folder of my songs and click on it and it will load but nothing happens what is the file name for the part that i can edit i tried database.mdb and all that happens when i click on it is the screen blinks and nothing else happens. i know how to use the find and replace but i cant seem to get the proper folder/ file opened to do it. help!!!

djbikeerrob, no I'm not talking about finding OS in Explorer. I meant on the left hand side of the renamer program you'll see Computer with a (+) next to it. Hit the (+) to expand it and you'll see OS(C) with a (+) next to it. Click the (+) to expand that and you'll see alot of folders. Go down to MTU and click the (+) next to it and you'll see the folder your songs are in. Once you click that folder it will load up in the screen to the right in the FileRenamer program.