MTU.Community


Go Back   MTU.Community > Hoster Software > Hoster Help

Hoster Help Post Hoster questions, tips and suggestions here.

Closed Thread
 
Thread Tools Display Modes
  #1  
Old April 2nd, 2018, 08:09 PM
Gonzo Gonzo is offline
Registered User
 
Join Date: Jan 2016
Location: Dayton, OH
Posts: 32
Search String

Recently I did a massive overhaul of all my songs, removed duplicates, renamed everything to be consistent, then re created my database.
Everything went smoothly.
I had the great idea the change ALL of the duet titles to \"whoever & whoever\" and then do a search for \"&\" and I could tag these as duets.
Problem is, you cant search for an & symbol, you get no results. I tried with quatation marks as well.. nothing.

Any ideas on how i can trick hoster into searching for \"&\" in the artist or filename so I can tag them as duets?
  #2  
Old April 3rd, 2018, 07:02 AM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,343
Re: Search String

Try this:
Edit dialog with Multiples selected, search mode as Word not String, on the Match row select only Artist & Genre buttons, I don’t know why but just selecting Artist only finds a few
On the Yes/No fields select Just Karaoke. If you also have Audio, Video & Kvideo you want to include Try them separate after wards I only tried this with Karaoke types.

Now in the search field enter * & * make sure to enter a space between characters and press search.
Now I don’t know if it finds all but my test produced a lot of results.

I attach a screen shot showing my settings to make it clearer.

One note though, not all songs with & in the artist field are true duets having the start of the track showing different colors for each singer.
Attached Images
File Type: jpg Ambersand duets.jpg (316.5 KB, 6 views)
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.
  #3  
Old April 3rd, 2018, 05:42 PM
Lonman Lonman is offline
VIP
 
Join Date: Mar 2005
Location: Tacoma, WA
Posts: 2,758
Re: Search String

Roy, \"Call Me When You\'re Sober\" did not include Paul McCoy
__________________

Show PC Lenovo nVidia 3.2ghz proc
Win 8.1 64bit
Vid: nVidia GT720 2gb mem
Aud: Lexicon Alpha
Mem: 8gb ram
HD: 1tb int/1tb int
Test PC ASUS AMD 4ghz 8 core proc
Win 7 Pro 32 bit

Vid: LP Radeon HD 5450 Video Card - 1GB
Aud: Lexicon Omega USB I/O Interface
Mem: 16gb ram
HD: 1TB/1TB

Like us on Facebook http://facebook.com/lonmanproductions
  #4  
Old April 3rd, 2018, 07:03 PM
kod kod is offline
Registered User
 
Join Date: Mar 2010
Location: North Carolina
Posts: 1,583
Re: Search String

Quote:
Originally Posted by Lonman View Post
Roy, \\\\\\\"Call Me When You\\\\\\\'re Sober\\\\\\\" did not include Paul McCoy
Lonman,

You might want to recheck this! I just found it in the MTV site and it listed \\\"With Paul McCoy\\\" ...
__________________
KOD
  #5  
Old April 3rd, 2018, 07:17 PM
Lonman Lonman is offline
VIP
 
Join Date: Mar 2005
Location: Tacoma, WA
Posts: 2,758
Re: Search String

I changed all my & signs for duets to \\\'ftg\\\'
Kid Rock ftg Sheryl Crow.
__________________

Show PC Lenovo nVidia 3.2ghz proc
Win 8.1 64bit
Vid: nVidia GT720 2gb mem
Aud: Lexicon Alpha
Mem: 8gb ram
HD: 1tb int/1tb int
Test PC ASUS AMD 4ghz 8 core proc
Win 7 Pro 32 bit

Vid: LP Radeon HD 5450 Video Card - 1GB
Aud: Lexicon Omega USB I/O Interface
Mem: 16gb ram
HD: 1TB/1TB

Like us on Facebook http://facebook.com/lonmanproductions
  #6  
Old April 3rd, 2018, 07:21 PM
Lonman Lonman is offline
VIP
 
Join Date: Mar 2005
Location: Tacoma, WA
Posts: 2,758
Re: Search String

Quote:
Originally Posted by kod View Post
Lonman,

You might want to recheck this! I just found it in the MTV site and it listed \\\\\\\"With Paul McCoy\\\\\\\" ...
It may be referring to Bring Me To Life - Call Me When You\'re Sober wasn\'t even a duet.
__________________

Show PC Lenovo nVidia 3.2ghz proc
Win 8.1 64bit
Vid: nVidia GT720 2gb mem
Aud: Lexicon Alpha
Mem: 8gb ram
HD: 1tb int/1tb int
Test PC ASUS AMD 4ghz 8 core proc
Win 7 Pro 32 bit

Vid: LP Radeon HD 5450 Video Card - 1GB
Aud: Lexicon Omega USB I/O Interface
Mem: 16gb ram
HD: 1TB/1TB

Like us on Facebook http://facebook.com/lonmanproductions
  #7  
Old April 3rd, 2018, 07:54 PM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,343
Re: Search String

My post was to help find the & Character in his database, I am not saying my own database is 100% accurate. Having said that this YouTube link shows as listed.

http://www.mtv.fr/musique/videos/f0f...en-Youre-Sober
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.

Last edited by Roy Dennis; April 3rd, 2018 at 08:00 PM.
  #8  
Old April 3rd, 2018, 08:10 PM
kod kod is offline
Registered User
 
Join Date: Mar 2010
Location: North Carolina
Posts: 1,583
Re: Search String

Quote:
Originally Posted by Lonman View Post
It may be referring to Bring Me To Life - Call Me When Youre Sober wasnt even a duet.
With or Featuring does not always imply a duet...
Attached Images
File Type: png Lonman-2.png (816.0 KB, 3 views)
__________________
KOD

Last edited by Roy Dennis; April 3rd, 2018 at 08:16 PM.
  #9  
Old April 3rd, 2018, 08:26 PM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,343
Re: Search String

Quote:
Originally Posted by Roy Dennis View Post
Try this:

One note though, not all songs with & in the artist field are true duets having the start of the track showing different colors for each singer.
The songs in my own database actually listed as duets are songs that show the different colours for each singer, I notice now especially with these new releases that they are often listed as ft. But there is no pre screen indication of colour to indicate who sings what.
That is why I stated that not all songs listed as & are true duets to my way of thinking.
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.
  #10  
Old April 4th, 2018, 06:46 AM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,343
Re: Search String

As I stated not all songs where the & or ft appear are duets, looking into the track:
Quote:
Originally Posted by Lonman View Post
Roy, “Call Me When You’re Sober” did not include Paul McCoy
Looking at the video it is not a Duet, it appears that he just featured in the video.

There are numerous examples like this one being Valerie - Amy Winehouse. Some versions listed as Mark Ronson Ft Amy Winehouse in which case Mark Ronson is just the band.

Another example James Hype - ft Kelli-Leigh.

So just finding all the songs with & in the artist field is not going to find the true Duets.
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.
  #11  
Old April 4th, 2018, 12:29 PM
kod kod is offline
Registered User
 
Join Date: Mar 2010
Location: North Carolina
Posts: 1,583
Re: Search String

Quote:
Originally Posted by Roy Dennis View Post
As I stated not all songs where the & or ft appear are duets, looking into the track:


Looking at the video it is not a Duet, it appears that he just featured in the video.

There are numerous examples like this one being Valerie - Amy Winehouse. Some versions listed as Mark Ronson Ft Amy Winehouse in which case Mark Ronson is just the band.

Another example James Hype - ft Kelli-Leigh.

So just finding all the songs with & in the artist field is not going to find the true Duets.
Roy,

Sometimes they just accompany the primary artist...
__________________
KOD
  #12  
Old April 4th, 2018, 12:47 PM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,343
Re: Search String

Quote:
Originally Posted by kod View Post
Roy,

Sometimes they just accompany the primary artist...
That’s right.
There’s the other scenario with groups: Gerry & The Pacemakers, KC & the Sunshine Band, Buddy Holly & The Crickets, Harold Melvin & The Blue Notes, etc. etc..
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.
  #13  
Old April 4th, 2018, 03:37 PM
Lonman Lonman is offline
VIP
 
Join Date: Mar 2005
Location: Tacoma, WA
Posts: 2,758
Re: Search String

Quote:
Originally Posted by kod View Post
With or Featuring does not always imply a duet...
Right and technically neither does an & sign, but it would allow you to search for \'ftg\' to change the status to duet instead of the & sign - which the OP stated doesn\'\'t search.
__________________

Show PC Lenovo nVidia 3.2ghz proc
Win 8.1 64bit
Vid: nVidia GT720 2gb mem
Aud: Lexicon Alpha
Mem: 8gb ram
HD: 1tb int/1tb int
Test PC ASUS AMD 4ghz 8 core proc
Win 7 Pro 32 bit

Vid: LP Radeon HD 5450 Video Card - 1GB
Aud: Lexicon Omega USB I/O Interface
Mem: 16gb ram
HD: 1TB/1TB

Like us on Facebook http://facebook.com/lonmanproductions
  #14  
Old April 4th, 2018, 03:42 PM
Lonman Lonman is offline
VIP
 
Join Date: Mar 2005
Location: Tacoma, WA
Posts: 2,758
Re: Search String

Quote:
Originally Posted by Roy Dennis View Post
There are numerous examples like this one being Valerie - Amy Winehouse. Some versions listed as Mark Ronson Ft Amy Winehouse in which case Mark Ronson is just the band.
But in this case it was Mark Ronson\'s album/recording in which he hired Amy to do vocals, so Valerie - Mark Ronson ftg Amy Winehouse would technically be the correct entry.
__________________

Show PC Lenovo nVidia 3.2ghz proc
Win 8.1 64bit
Vid: nVidia GT720 2gb mem
Aud: Lexicon Alpha
Mem: 8gb ram
HD: 1tb int/1tb int
Test PC ASUS AMD 4ghz 8 core proc
Win 7 Pro 32 bit

Vid: LP Radeon HD 5450 Video Card - 1GB
Aud: Lexicon Omega USB I/O Interface
Mem: 16gb ram
HD: 1TB/1TB

Like us on Facebook http://facebook.com/lonmanproductions
  #15  
Old April 4th, 2018, 08:53 PM
Gonzo Gonzo is offline
Registered User
 
Join Date: Jan 2016
Location: Dayton, OH
Posts: 32
Re: Search String

Quote:
Originally Posted by Roy Dennis View Post
Try this:

Now in the search field enter * & * make sure to enter a space between characters and press search.
Now I don’t know if it finds all but my test produced a lot of results.
Perfect! Worked like a charm!
Thanks Roy!
  #16  
Old April 5th, 2018, 04:03 PM
Roy Dennis's Avatar
Roy Dennis Roy Dennis is offline
Super Moderator
 
Join Date: Mar 2004
Location: Kent, England
Posts: 6,343
Re: Search String

Glad to hear that, will close this thread now.
__________________
Roy.
Test Laptop: Windows 10 Home Premium 64bit. Acer Aspire 5738G Intel core 2 Duo T6600 ATI Graphics 500Mb dedicated. 4Gb Memory 500 Gb SSD Drive. K-lite Mega version 1205
Show Backup: Windows 10 Acer Aspire Touch Screen V15, Intel core i5, Iris Graphics 6100 up to 8277mb dynamic video, 16Gb memory, 1 TB hybrid HDD. K-lite Mega pac.
Show Computer: Windows 10, Dell Inspiron 15 7000, CPU I7-855OU, Ram 8GB, Graphics UHD620 + Nvidea GeForce 940MX, Hard Drive SSD 256GB + 1GB internal.
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On


All times are GMT -4. The time now is 08:40 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2024, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.