| Karaoke Scene's Karaoke Forums https://mail.karaokescenemagazine.net/forums/ |
|
| My karaoke list on a www database...Help! https://mail.karaokescenemagazine.net/forums/viewtopic.php?f=1&t=21390 |
Page 1 of 2 |
| Author: | twansenne [ Sat Apr 09, 2011 2:17 pm ] |
| Post subject: | My karaoke list on a www database...Help! |
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.com to 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? |
|
| Author: | Phill Cross [ Sat Apr 09, 2011 2:50 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
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... 
|
|
| Author: | MtnKaraoke [ Sat Apr 09, 2011 3:14 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
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. |
|
| Author: | TroyVnd27 [ Sat Apr 09, 2011 4:05 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
You can post them on my website. www.whattosing.com. It is still under construction, but functional. No charge btw. |
|
| Author: | toqer [ Sat Apr 09, 2011 5:46 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
Try google docs (spreadsheet) PDF's are nice too. |
|
| Author: | mckyj57 [ Sat Apr 09, 2011 7:55 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
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. |
|
| Author: | Alan B [ Sat Apr 09, 2011 8:49 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
I also have a pdf file on my website. Works out great. |
|
| Author: | twansenne [ Sun Apr 10, 2011 7:00 am ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
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. |
|
| Author: | mckyj57 [ Sun Apr 10, 2011 8:39 am ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
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. |
|
| Author: | TopherM [ Mon Apr 11, 2011 5:06 am ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
FastTracks will publish a website database automatically. What is your songbook software? |
|
| Author: | mckyj57 [ Mon Apr 11, 2011 7:24 am ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
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. |
|
| Author: | mckyj57 [ Mon Apr 11, 2011 12:51 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
OK, here's my book using my facility: http://www.inkaraoke.com/k/m/mickey Derived from a three-column table: title artist diskid You 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.) |
|
| Author: | Lonman [ Mon Apr 11, 2011 1:10 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
This rocks Mickey! Beatifully written! And free to boot (for now anyway!!!  )
|
|
| Author: | twansenne [ Mon Apr 11, 2011 2:16 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
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) |
|
| Author: | twansenne [ Mon Apr 11, 2011 2:18 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
mckyj57 wrote: OK, here's my book using my facility: http://www.inkaraoke.com/k/m/mickey Derived from a three-column table: title artist diskid You 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? |
|
| Author: | Lonman [ Mon Apr 11, 2011 2:27 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
twansenne wrote: mckyj57 wrote: OK, here's my book using my facility: http://www.inkaraoke.com/k/m/mickey Derived from a three-column table: title artist diskid You 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? |
|
| Author: | twansenne [ Mon Apr 11, 2011 3:04 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
No list yet LON just doing some testing..... http://dj.sskaraoke.com/test.html This 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. |
|
| Author: | mckyj57 [ Mon Apr 11, 2011 4:30 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
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. |
|
| Author: | twansenne [ Mon Apr 11, 2011 5:19 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
twansenne wrote: No list yet LON just doing some testing..... http://dj.sskaraoke.com/test.html This 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 #4 Will it be possible to have 2 list? One for DJ songs, one for Karaoke Songs. I'd even donate to the cause for that! |
|
| Author: | mckyj57 [ Mon Apr 11, 2011 5:35 pm ] |
| Post subject: | Re: My karaoke list on a www database...Help! |
twansenne wrote: twansenne wrote: No list yet LON just doing some testing..... http://dj.sskaraoke.com/test.html This 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 #4 Will 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.... |
|
| Page 1 of 2 | All times are UTC - 8 hours |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|