|
View unanswered posts | View active topics
Author |
Message |
twansenne
|
Posted: Sat Apr 09, 2011 2:17 pm |
|
Joined: Fri Jan 13, 2006 4:03 pm Posts: 1921 Images: 1 Location: N. Central Iowa Been Liked: 53 times
|
Ok, the other nite while hosting a show, a thought came to me. I want a database of my karaoke and DJ songs online that people can search from their web enable phones. Something simple to make it fast. Something cheap. I setup 2 sub domains..... http://KJ.sskaraoke.com& http://DJ.sskaraoke.comto hold the 2 lists. I though first just to put a text file, but scrolling through the songs on a phone would take to long. The I though have a simple HTML file with markers to go alphabetical to A,B, & C thru Z and return to top, but that would take too long to redo if I updated songs list. So in a perfect world, just a search box on the index page, and then after you typed in "Kid Rock", it would show all songs (files) with kid rock in them whether it was in artist or song title with a database/excel file that is actually searched. Looking on the WEB it can be done, but most things I find are WAY TO EXPENSIVE, or I cant get the JAVA script working to do it. HELP!!!!!! Tony ya out there?
|
|
Top |
|
|
Phill Cross
|
Posted: Sat Apr 09, 2011 2:50 pm |
|
Joined: Sun Jul 01, 2001 4:00 am Posts: 2807 Images: 36 Location: Anaheim, Orange County, CA Been Liked: 122 times
|
hmmm... It can be done. I can create a db - to function as you need - If you already have an excel spreadsheet I could develop a structure from that - then create a method to search and display results. You have a site is it on a Linux server? Do you have php capabilities and MySQL db? How soon and what's your budget? Currently, bustin' a hump working on here...
_________________ Phill CrossWebmaster, Host Provider & Part-Time “Technical” Problem SolverKJ / MCservices provided by: CROSS WEB TECH
|
|
Top |
|
|
MtnKaraoke
|
Posted: Sat Apr 09, 2011 3:14 pm |
|
Joined: Thu Aug 05, 2010 1:40 pm Posts: 1052 Images: 1 Been Liked: 204 times
|
I have found that the easiest is to post a pdf file of my song list on my site. Users can view it in a browser or save the file for use on any smartphone that can read pdf's.
Pdf's have inherent text search-ability and you can add an index tab to make moving through alphabetical sections easier.
_________________ Never the same show twice!
|
|
Top |
|
|
TroyVnd27
|
Posted: Sat Apr 09, 2011 4:05 pm |
|
Joined: Sun Nov 14, 2010 7:10 pm Posts: 933 Location: Twin Lake, MI Been Liked: 59 times
|
You can post them on my website. www.whattosing.com. It is still under construction, but functional. No charge btw.
_________________ I'm not a cheerleader, but I paid for my pom poms with my own money!
|
|
Top |
|
|
toqer
|
Posted: Sat Apr 09, 2011 5:46 pm |
|
Joined: Tue Jun 08, 2004 11:15 am Posts: 907 Location: San Jose CA Been Liked: 33 times
|
Try google docs (spreadsheet)
PDF's are nice too.
_________________ Living my life as Robert Cortese, 162 E. Jackson St, San Jose CA.
It's like the difference between high and low budget toilet paper, it really doesn't matter in the end. -exweedfarmer
Which is smarter? Just sticking to making/selling karaoke, while people all over the world create software FOR FREE that helps you sell it, or trying to compete with them and keeping it a closed loop while you blow your money into an industry (software) that you(the karaoke manu) knows nothing about? -me
|
|
Top |
|
|
mckyj57
|
Posted: Sat Apr 09, 2011 7:55 pm |
|
Joined: Tue Apr 04, 2006 9:24 pm Posts: 5576 Location: Cocoa Beach Been Liked: 122 times
|
I have something which I just whipped up. I will be ready to show it before long -- I did the first incantation for one of our members and would like to show him before I show others. But basically, it allows you to search-as-you-type through a song database, give singers a way to make requests via smartphone, search on the web, etc. etc.
I should post something here in a few days.
_________________ [color=#ffff55]Mickey J.[/color] Alas for those who never sing, but die with all their music in them. -- Oliver Wendell Holmes, Sr.
|
|
Top |
|
|
Alan B
|
Posted: Sat Apr 09, 2011 8:49 pm |
|
Joined: Sun Jul 30, 2006 7:24 pm Posts: 4466 Been Liked: 1052 times
|
I also have a pdf file on my website. Works out great.
_________________ Electro-Voice Evolve 50... Taking Sound To The Next Level.
|
|
Top |
|
|
twansenne
|
Posted: Sun Apr 10, 2011 7:00 am |
|
Joined: Fri Jan 13, 2006 4:03 pm Posts: 1921 Images: 1 Location: N. Central Iowa Been Liked: 53 times
|
mckyj57 wrote: I have something which I just whipped up. I will be ready to show it before long -- I did the first incantation for one of our members and would like to show him before I show others. But basically, it allows you to search-as-you-type through a song database, give singers a way to make requests via smartphone, search on the web, etc. etc.
I should post something here in a few days. That's what I am looking for. For all others that posted..... I already tested PDF, but some ppls phones couldn't handle it Phil.....NO PHP or SQL on my web host (tripod). I should change but it is cheap. And I have a VERY TINNY budget. Also tried GOOGLE docs with a Gadget, but then ya still have to scroll. This was cool, but no search function. Troy....cool site, might give it a try, but would like it to fit on mobile phone, and be linked directly thru my www site. SO that is a possibility.
|
|
Top |
|
|
mckyj57
|
Posted: Sun Apr 10, 2011 8:39 am |
|
Joined: Tue Apr 04, 2006 9:24 pm Posts: 5576 Location: Cocoa Beach Been Liked: 122 times
|
twansenne wrote: mckyj57 wrote: I have something which I just whipped up. I will be ready to show it before long -- I did the first incantation for one of our members and would like to show him before I show others. But basically, it allows you to search-as-you-type through a song database, give singers a way to make requests via smartphone, search on the web, etc. etc.
I should post something here in a few days. That's what I am looking for. For all others that posted..... I already tested PDF, but some ppls phones couldn't handle it Phil.....NO PHP or SQL on my web host (tripod). I should change but it is cheap. And I have a VERY TINNY budget. Also tried GOOGLE docs with a Gadget, but then ya still have to scroll. This was cool, but no search function. Troy....cool site, might give it a try, but would like it to fit on mobile phone, and be linked directly thru my www site. SO that is a possibility. Bear in mind that mobile phone != smart phone. I have no intention of supporting WML and WSCRIPT, only HTML and JScript. It will work on ioS/iPhone, Android, and Windows Mobile, and anything else like that. Not on first-generation "smart" phones that only accept text/vnd.wap.wml. Mine will be a hosted application. If traffic remains low, it will probably be "send me something via paypal if you have a mind to". If I start getting dozens of users, then I'll probably charge $60.00 per year. That will give you a virtual web site as well as a songbook. Eventually I plan on delivering printed Songbooks from the same database, and possibly some limited mail show-announcement functionality for users who sign up with you.
_________________ [color=#ffff55]Mickey J.[/color] Alas for those who never sing, but die with all their music in them. -- Oliver Wendell Holmes, Sr.
|
|
Top |
|
|
TopherM
|
Posted: Mon Apr 11, 2011 5:06 am |
|
Joined: Mon Dec 20, 2004 10:09 am Posts: 3341 Location: Tampa Bay, FL Been Liked: 445 times
|
FastTracks will publish a website database automatically. What is your songbook software?
_________________ C Mc
KJ, FL
|
|
Top |
|
|
mckyj57
|
Posted: Mon Apr 11, 2011 7:24 am |
|
Joined: Tue Apr 04, 2006 9:24 pm Posts: 5576 Location: Cocoa Beach Been Liked: 122 times
|
TopherM wrote: FastTracks will publish a website database automatically. What is your songbook software? Creating the database (read: spreadsheet) never seems to be the problem. It's what you do with it once you get it.
_________________ [color=#ffff55]Mickey J.[/color] Alas for those who never sing, but die with all their music in them. -- Oliver Wendell Holmes, Sr.
|
|
Top |
|
|
mckyj57
|
Posted: Mon Apr 11, 2011 12:51 pm |
|
Joined: Tue Apr 04, 2006 9:24 pm Posts: 5576 Location: Cocoa Beach Been Liked: 122 times
|
OK, here's my book using my facility: http://www.inkaraoke.com/k/m/mickeyDerived from a three-column table: title artist diskidYou can add a fourth column called book_number if you wish. This is only used when the singer sends a request. (Allows you to plug in a CAVS or Hoster ID.)
_________________ [color=#ffff55]Mickey J.[/color] Alas for those who never sing, but die with all their music in them. -- Oliver Wendell Holmes, Sr.
|
|
Top |
|
|
Lonman
|
Posted: Mon Apr 11, 2011 1:10 pm |
|
Joined: Mon Dec 10, 2001 3:57 pm Posts: 22978 Songs: 35 Images: 3 Location: Tacoma, WA Been Liked: 2126 times
|
This rocks Mickey! Beatifully written! And free to boot (for now anyway!!! )
_________________ LIKE Lonman on Facebook - Lonman Productions Karaoke & my main site via my profile!
|
|
Top |
|
|
twansenne
|
Posted: Mon Apr 11, 2011 2:16 pm |
|
Joined: Fri Jan 13, 2006 4:03 pm Posts: 1921 Images: 1 Location: N. Central Iowa Been Liked: 53 times
|
TopherM wrote: FastTracks will publish a website database automatically. What is your songbook software? No song book software, just grab file names and dump them into a spread sheet (with some formatting of the spreadsheet)
|
|
Top |
|
|
twansenne
|
Posted: Mon Apr 11, 2011 2:18 pm |
|
Joined: Fri Jan 13, 2006 4:03 pm Posts: 1921 Images: 1 Location: N. Central Iowa Been Liked: 53 times
|
mckyj57 wrote: OK, here's my book using my facility: http://www.inkaraoke.com/k/m/mickeyDerived from a three-column table: title artist diskidYou can add a fourth column called book_number if you wish. This is only used when the singer sends a request. (Allows you to plug in a CAVS or Hoster ID.) OK, gonna give it a try when I get some free time. Perhaps this weekend. I assume if I have ppl go to http://dj.sskaraoke.com I can just redirect them to you site?
|
|
Top |
|
|
Lonman
|
Posted: Mon Apr 11, 2011 2:27 pm |
|
Joined: Mon Dec 10, 2001 3:57 pm Posts: 22978 Songs: 35 Images: 3 Location: Tacoma, WA Been Liked: 2126 times
|
twansenne wrote: mckyj57 wrote: OK, here's my book using my facility: http://www.inkaraoke.com/k/m/mickeyDerived from a three-column table: title artist diskidYou can add a fourth column called book_number if you wish. This is only used when the singer sends a request. (Allows you to plug in a CAVS or Hoster ID.) OK, gonna give it a try when I get some free time. Perhaps this weekend. I assume if I have ppl go to http://dj.sskaraoke.com I can just redirect them to you site? Nothing comes up on your current site except a 'test' line. Is it supposed to at least have a list?
_________________ LIKE Lonman on Facebook - Lonman Productions Karaoke & my main site via my profile!
|
|
Top |
|
|
twansenne
|
Posted: Mon Apr 11, 2011 3:04 pm |
|
Joined: Fri Jan 13, 2006 4:03 pm Posts: 1921 Images: 1 Location: N. Central Iowa Been Liked: 53 times
|
No list yet LON just doing some testing..... http://dj.sskaraoke.com/test.htmlThis is a Google docs spread sheet with a Google Table Gadget on the website. I like the idea of this, but no search functions on the Gadget.
|
|
Top |
|
|
mckyj57
|
Posted: Mon Apr 11, 2011 4:30 pm |
|
Joined: Tue Apr 04, 2006 9:24 pm Posts: 5576 Location: Cocoa Beach Been Liked: 122 times
|
I'll be working next week on providing a few things:
1. Upload of new song database 2. Management to take old database off line and put new one on line. 3. Better smart phone template. 4. A default account setting so I can give out some blank accounts and let people upload their song database, change their page template, and tinker with their settings.
_________________ [color=#ffff55]Mickey J.[/color] Alas for those who never sing, but die with all their music in them. -- Oliver Wendell Holmes, Sr.
|
|
Top |
|
|
twansenne
|
Posted: Mon Apr 11, 2011 5:19 pm |
|
Joined: Fri Jan 13, 2006 4:03 pm Posts: 1921 Images: 1 Location: N. Central Iowa Been Liked: 53 times
|
twansenne wrote: No list yet LON just doing some testing..... http://dj.sskaraoke.com/test.htmlThis is a Google docs spread sheet with a Google Table Gadget on the website. I like the idea of this, but no search functions on the Gadget. Liking #4Will it be possible to have 2 list? One for DJ songs, one for Karaoke Songs. I'd even donate to the cause for that!
|
|
Top |
|
|
mckyj57
|
Posted: Mon Apr 11, 2011 5:35 pm |
|
Joined: Tue Apr 04, 2006 9:24 pm Posts: 5576 Location: Cocoa Beach Been Liked: 122 times
|
twansenne wrote: twansenne wrote: No list yet LON just doing some testing..... http://dj.sskaraoke.com/test.htmlThis is a Google docs spread sheet with a Google Table Gadget on the website. I like the idea of this, but no search functions on the Gadget. Liking #4Will it be possible to have 2 list? One for DJ songs, one for Karaoke Songs. I'd even donate to the cause for that! You would just use two accounts, I guess....
_________________ [color=#ffff55]Mickey J.[/color] Alas for those who never sing, but die with all their music in them. -- Oliver Wendell Holmes, Sr.
|
|
Top |
|
|
Who is online |
Users browsing this forum: No registered users and 284 guests |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|