Click here to Skip to main content
15,885,435 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Ive had an idea for a basic application that would help save us a few quid

We do karaoke events in local pubs for every having to have new play list printed as they just get destroyed

we have already built two custom 19" 2U rack mount computers one for our DMX lights and blue tooth advertising and the other runs VDJ with over 5000 Karaoke files and 10,000 music tracks

Basic idea is to have laptop hidden with another screen mouse and keyboard as terminal that people can come up search throw our music catalog

I started putting the design together and the basic menus and commands and search bar and a user mode and admin mode but got stuck when try to gather and make data searchable

We have all our music catalog in a excel sheet. what would be this simplest way to to make this search able so it recalls and display what you search for

idea then would be to make this connect to the blue tooth or wifi networks and send it to the one of the other 19" rack mounts so it could then be added to play list or could there be away to make it automaticly add it to VDJ playlist

This would then get rid of the little paper tickets we have to print for each event

Just wondering if anybody had any idea on the simplest way to recall the data from excell sheet ive serched the site for idea but cannot see anything that even comes close to the idea any help welcome
Posted

Excel interop[^] should help...
 
Share this answer
 
Comments
Sergey Alexandrovich Kryukov 16-Jun-11 3:44am    
Right reference. Thank you, I credited it in my solution. My 5.
There are more to it -- please see. Excel should not be used as a database, they only need to populate a real database -- once.
--SA
CS2011 16-Jun-11 4:08am    
Someone is on fire today. Is it 'coz you are inching towards 200K landmark. Have 5+ for the link.
OriginalGriff 16-Jun-11 4:19am    
Bloody heck! I hadn't noticed! :blush:
I would say you should get rid of the stone-age style of using a spreadsheet and use a decent but small-footprint data base. One can easily develop a simple client-server network application to give access to your users, based on Web technology (ASP.NET) or simply a custom server with Windows application.

You need to populate your data taken from your spreadsheet only once. Come to thing about, 10,000 tracks is nothing. Office API you can use for extracting Excel data is readily available. (See the link provided by Griff.)

You should have two applications: a read-only UI for the customers (however, orders can written on this side, and support application running on a computer not accessible by public (or even on a inaccessible location on the same computer). You will use the support application for adding new records to the database, fixing existing data and other service chores.

This development could be done pretty soon, maybe a few days of good work.

—SA
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900