Karaoke Scene's Karaoke Forums
https://mail.karaokescenemagazine.net/forums/

Need help with compuhost
https://mail.karaokescenemagazine.net/forums/viewtopic.php?f=1&t=19112
Page 1 of 1

Author:  jerry12x [ Sat Feb 27, 2010 8:15 pm ]
Post subject:  Need help with compuhost

Hey guys.
My naming convention for files is artist - song - manu.
In Compuhost if the artist is a duo e.g. it can take up a lot of characters.
Sometimes I can not search the song because of the 40 character limit.
Are there any work arounds.
Thanks.

Author:  mckyj57 [ Sun Feb 28, 2010 12:14 am ]
Post subject:  Re: Need help with compuhost

jerry12x @ Sat Feb 27, 2010 11:15 pm wrote:
Hey guys.
My naming convention for files is artist - song - manu.
In Compuhost if the artist is a duo e.g. it can take up a lot of characters.
Sometimes I can not search the song because of the 40 character limit.
Are there any work arounds.
Thanks.

I wasn't aware of any limit. I never seem to have a problem finding, including Lady Marmalade which has a huge artist string.

How does the limit work?

Author:  srnitynow [ Sun Feb 28, 2010 6:16 am ]
Post subject:  Re: Need help with compuhost

Put it on search as you type, and the songs should be found withih the first 10 characters max.

Rosario

Author:  jerry12x [ Sun Feb 28, 2010 10:33 am ]
Post subject:  Re: Need help with compuhost

As an example, I have the file
Meatloaf - Paradise by the dashboard light - Sun.cdg
What Compuhost displays is
Meatloaf - Paradise by the dashboard lig
I can not see who the manu is.
I emailed Compuhost and they replied
"Thats right. There is a 40 character limit"
It does search as I type but only displays 40 characters.

Author:  srnitynow [ Sun Feb 28, 2010 11:56 am ]
Post subject:  Re: Need help with compuhost

Jerry, instead of adding the song by the add song box, use the song search. This will not only give you the song as you type, but ALL versions that you have, then just drag and drop onto que section. If this is confusing, let me know, I'll explain better.

Rosario

Author:  DannyG2006 [ Sun Feb 28, 2010 12:22 pm ]
Post subject:  Re: Need help with compuhost

I believe his problem is that he can't see what version it is due to the 40 character limit. He must have imported into the database using the Artist - Title naming format. If the OP imported using Artist - Title - D-T format I believe he would be able to tell what version was what based on the format he listed in his original post.

Author:  tbreen [ Sun Feb 28, 2010 12:30 pm ]
Post subject:  Re: Need help with compuhost

jerry12x @ Sun Feb 28, 2010 10:33 am wrote:
As an example, I have the file
Meatloaf - Paradise by the dashboard light - Sun.cdg
What Compuhost displays is
Meatloaf - Paradise by the dashboard lig
I can not see who the manu is.
I emailed Compuhost and they replied
"Thats right. There is a 40 character limit"
It does search as I type but only displays 40 characters.


Compuhost has excellent song search capabilities, however, in this case, I'm reminded of the adage "Garbage in, Garbage out". That's what you have here. The naming format of your example file does not adhere to any common format that I have ever heard of. If your files were properly named, following any of the common formats that CH supports, you wouldn't have a problem. Instead, you are obviously importing the files using the Combined method, of which CH itself displays a warning message when selecting that format, stating that its search abilities are seriously limited when using that format.

tbreen

Author:  jerry12x [ Sun Feb 28, 2010 2:42 pm ]
Post subject:  Re: Need help with compuhost

tbreen, you are right.
The trouble is I named my files that way and was happy using them in winamp.
I then moved to Compuhost and have this problem.
It is not possible to rename all the files.
Any ideas please...

Author:  ripman8 [ Sun Feb 28, 2010 4:03 pm ]
Post subject:  Re: Need help with compuhost

wow. that sucks. mine is set up the traditional way. I usually type about 4 to 6 characters and disc number, track number, artist, song name as well as the number of the song being entered. For instance, my first song ever entered is "1" so on and so forth. Only way I know to fix your problem is to manually edit each song from the "Search songlist" window or delete all song titles and start from scratch in fastTracks. There must be an easier way. Good luck.

Author:  mckyj57 [ Sun Feb 28, 2010 8:03 pm ]
Post subject:  Re: Need help with compuhost

Unfortunately I am not standing next to you. I could write a Perl script that would rename your files recursively and solve your problem. Unfortunately, there is really no way to get something to you that you could use.

If you could get me a real recursive directory listing, i.e. a text file with all of the file names as they are on the disk, I could write you a batch file that would rename everything.

Author:  jerry12x [ Mon Mar 01, 2010 2:16 pm ]
Post subject:  Re: Need help with compuhost

What does a proper file look like ? :shock:

Author:  mckyj57 [ Mon Mar 01, 2010 6:52 pm ]
Post subject:  Re: Need help with compuhost

jerry12x @ Mon Mar 01, 2010 5:16 pm wrote:
What does a proper file look like ? :shock:

[pre]Chartbuster/CBE3XX/CBE317/CBE317-01 - Beach Boys, The - Good Vibrations.zip
Chartbuster/CBE3XX/CBE317/CBE317-02 - Orbison, Roy - Blue Bayou.zip
Chartbuster/CBE3XX/CBE317/CBE317-03 - Redding, Otis - These Arms Of Mine.zip
Chartbuster/CBE3XX/CBE317/CBE317-04 - Franklin, Aretha - Think.zip
Chartbuster/CBE3XX/CBE317/CBE317-05 - Jan & Dean - Surf City.zip
Chartbuster/CBE3XX/CBE317/CBE317-06 - Four Seasons, The - Dawn.zip
Chartbuster/CBE3XX/CBE317/CBE317-07 - Peter & Gordon - World Without Love, A.zip
Chartbuster/CBE3XX/CBE317/CBE317-08 - 5th Dimension, The - One Less Bell To Answer.zip
Chartbuster/CBE3XX/CBE317/CBE317-09 - Beatles, The - Lucy In The Sky With Diamonds.zip
Chartbuster/CBE3XX/CBE317/CBE317-10 - Simon & Garfunkel - Sounds Of Silence.zip
Chartbuster/CBE3XX/CBE317/CBE317-11 - Beach Boys, The - I Get Around.zip
Chartbuster/CBE3XX/CBE317/CBE317-12 - Newton-John, Olivia & John Travolta - Summer Nights.zip
Chartbuster/CBE3XX/CBE317/CBE317-13 - Dion & The Belmonts - Abraham, Martin & John.zip
Chartbuster/CBE3XX/CBE317/CBE317-14 - Creedence Clearwater Revival - Susie Q.zip
Chartbuster/CBE3XX/CBE317/CBE317-15 - King, Carole - So Far Away.zip
Chartbuster/CBE3XX/CBE318/CBE318-01 - Beach Boys, The - Barbara Ann.zip
Chartbuster/CBE3XX/CBE318/CBE318-02 - Creedence Clearwater Revival - Midnight Special.zip
Chartbuster/CBE3XX/CBE318/CBE318-03 - Puckett, Gary & The Union Gap - Young Girl.zip
Chartbuster/CBE3XX/CBE318/CBE318-04 - James, Tommy & The Shondells - Crystal Blue Persuasion.zip
Chartbuster/CBE3XX/CBE318/CBE318-05 - King, Carole - You've Got A Friend.zip
Chartbuster/CBE3XX/CBE318/CBE318-06 - Creedence Clearwater Revival - Down On The Corner.zip
Chartbuster/CBE3XX/CBE318/CBE318-07 - South, Joe - Games People Play.zip
Chartbuster/CBE3XX/CBE318/CBE318-08 - Beatles, The - Here Comes The Sun.zip
Chartbuster/CBE3XX/CBE318/CBE318-09 - Carpenters, The - Hurting Each Other.zip
Chartbuster/CBE3XX/CBE318/CBE318-10 - Dylan, Bob - Lay Lady Lay.zip
Chartbuster/CBE3XX/CBE318/CBE318-11 - Clapton, Eric - After Midnight.zip
Chartbuster/CBE3XX/CBE318/CBE318-12 - Three Dog Night - One.zip
Chartbuster/CBE3XX/CBE318/CBE318-13 - Partridge Family, The - I Think I Love You.zip
Chartbuster/CBE3XX/CBE318/CBE318-14 - Harrison, George - My Sweet Lord.zip
Chartbuster/CBE3XX/CBE318/CBE318-15 - Brotherhood Of Man, The - United We Stand.zip[/pre]
With luck, you would have the files in a one disk per folder setup. But if you had about anything, I could probably handle it.

I would create something like:
[pre]rename "Chartbuster\CBE3XX\CBE317\CBE317-01 - Beach Boys, The - Good Vibrations.zip" "Good Vibrations - Beach Boys, The - CBE317-01.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-02 - Orbison, Roy - Blue Bayou.zip" "Blue Bayou - Orbison, Roy - CBE317-02.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-03 - Redding, Otis - These Arms Of Mine.zip" "These Arms Of Mine - Redding, Otis - CBE317-03.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-04 - Franklin, Aretha - Think.zip" "Think - Franklin, Aretha - CBE317-04.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-05 - Jan & Dean - Surf City.zip" "Surf City - Jan & Dean - CBE317-05.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-06 - Four Seasons, The - Dawn.zip" "Dawn - Four Seasons, The - CBE317-06.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-07 - Peter & Gordon - World Without Love, A.zip" "World Without Love, A - Peter & Gordon - CBE317-07.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-08 - 5th Dimension, The - One Less Bell To Answer.zip" "One Less Bell To Answer - 5th Dimension, The - CBE317-08.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-09 - Beatles, The - Lucy In The Sky With Diamonds.zip" "Lucy In The Sky With Diamonds - Beatles, The - CBE317-09.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-10 - Simon & Garfunkel - Sounds Of Silence.zip" "Sounds Of Silence - Simon & Garfunkel - CBE317-10.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-11 - Beach Boys, The - I Get Around.zip" "I Get Around - Beach Boys, The - CBE317-11.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-12 - Newton-John, Olivia & John Travolta - Summer Nights.zip" "Summer Nights - Newton-John, Olivia & John Travolta - CBE317-12.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-13 - Dion & The Belmonts - Abraham, Martin & John.zip" "Abraham, Martin & John - Dion & The Belmonts - CBE317-13.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-14 - Creedence Clearwater Revival - Susie Q.zip" "Susie Q - Creedence Clearwater Revival - CBE317-14.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-15 - King, Carole - So Far Away.zip" "So Far Away - King, Carole - CBE317-15.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-01 - Beach Boys, The - Barbara Ann.zip" "Barbara Ann - Beach Boys, The - CBE318-01.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-02 - Creedence Clearwater Revival - Midnight Special.zip" "Midnight Special - Creedence Clearwater Revival - CBE318-02.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-03 - Puckett, Gary & The Union Gap - Young Girl.zip" "Young Girl - Puckett, Gary & The Union Gap - CBE318-03.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-04 - James, Tommy & The Shondells - Crystal Blue Persuasion.zip" "Crystal Blue Persuasion - James, Tommy & The Shondells - CBE318-04.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-05 - King, Carole - You've Got A Friend.zip" "You've Got A Friend - King, Carole - CBE318-05.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-06 - Creedence Clearwater Revival - Down On The Corner.zip" "Down On The Corner - Creedence Clearwater Revival - CBE318-06.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-07 - South, Joe - Games People Play.zip" "Games People Play - South, Joe - CBE318-07.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-08 - Beatles, The - Here Comes The Sun.zip" "Here Comes The Sun - Beatles, The - CBE318-08.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-09 - Carpenters, The - Hurting Each Other.zip" "Hurting Each Other - Carpenters, The - CBE318-09.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-10 - Dylan, Bob - Lay Lady Lay.zip" "Lay Lady Lay - Dylan, Bob - CBE318-10.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-11 - Clapton, Eric - After Midnight.zip" "After Midnight - Clapton, Eric - CBE318-11.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-12 - Three Dog Night - One.zip" "One - Three Dog Night - CBE318-12.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-13 - Partridge Family, The - I Think I Love You.zip" "I Think I Love You - Partridge Family, The - CBE318-13.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-14 - Harrison, George - My Sweet Lord.zip" "My Sweet Lord - Harrison, George - CBE318-14.zip"
rename "Chartbuster\CBE3XX\CBE318\CBE318-15 - Brotherhood Of Man, The - United We Stand.zip" "United We Stand - Brotherhood Of Man, The - CBE318-15.zip"[/pre]
If you didn't have numbers and only manufacturers, I would create fake ones like CB0001-01 etc.

Author:  jerry12x [ Tue Mar 02, 2010 12:35 pm ]
Post subject:  Re: Need help with compuhost

Hmmm. Got to think this one through.
I would be renaming my filenames to longer filenames.
Also I would be reversing names e.g.
Aretha Franklin to Franklin, Aretha.
Not really what I wanted.
Time for a big think.

Thanks mckyj57 for the offer

Author:  Moonrider [ Tue Mar 02, 2010 12:41 pm ]
Post subject:  Re: Need help with compuhost

mckyj57 @ Mon Mar 01, 2010 9:52 pm wrote:
I would create something like:
[pre]rename "Chartbuster\CBE3XX\CBE317\CBE317-01 - Beach Boys, The - Good Vibrations.zip" "Good Vibrations - Beach Boys, The - CBE317-01.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-02 - Orbison, Roy - Blue Bayou.zip" "Blue Bayou - Orbison, Roy - CBE317-02.zip"


Dude! That's what regex patterns are for! I know they look like line noise, but they sure save a ton of typing.

Perl be da shizzle!

Author:  mckyj57 [ Tue Mar 02, 2010 6:50 pm ]
Post subject:  Re: Need help with compuhost

Moonrider @ Tue Mar 02, 2010 3:41 pm wrote:
mckyj57 @ Mon Mar 01, 2010 9:52 pm wrote:
I would create something like:
[pre]rename "Chartbuster\CBE3XX\CBE317\CBE317-01 - Beach Boys, The - Good Vibrations.zip" "Good Vibrations - Beach Boys, The - CBE317-01.zip"
rename "Chartbuster\CBE3XX\CBE317\CBE317-02 - Orbison, Roy - Blue Bayou.zip" "Blue Bayou - Orbison, Roy - CBE317-02.zip"


Dude! That's what regex patterns are for! I know they look like line noise, but they sure save a ton of typing.

Perl be da shizzle!

I don't think you understand. I am a Perl programmer and a fairly major one at that. If I had Perl on his machine I could write a script in a few minutes that would rename all his files. But I am not on his machine, and I don't expect him to install Perl.

My Perl script would run on my machine and produce a .bat file he could just run, *without* Perl.

Author:  mckyj57 [ Tue Mar 02, 2010 6:56 pm ]
Post subject:  Re: Need help with compuhost

jerry12x @ Tue Mar 02, 2010 3:35 pm wrote:
Hmmm. Got to think this one through.
I would be renaming my filenames to longer filenames.
Also I would be reversing names e.g.
Aretha Franklin to Franklin, Aretha.
Not really what I wanted.
Time for a big think.

It was only an example -- I wouldn't have changed the titles and artists, it would have mirrored what you sent me.

Actually, if you used the DOS prompt and did:

c:
cd \karaoke

Those first two change your directory to wherever the files are. Then:

tree /f /a > output.txt

you could send me the output.txt file and I could do it from that.

Page 1 of 1 All times are UTC - 8 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/