概念想法行不通 [英] Concept Idea Not Working Out

问题描述

我有一个基本应用程序的构想，可以帮助我们节省一些麻烦

我们会在当地的酒吧里进行卡拉OK活动，因为每当他们被销毁时都必须打印新的播放列表

我们已经建立了两台定制的19英寸2U机架式计算机，其中一台用于DMX灯和蓝牙广告，另一台用于运行VDJ，其中包含超过5000个卡拉OK文件和10,000个音乐曲目

基本想法是将笔记本电脑隐藏在另一个屏幕鼠标和键盘作为终端的终端上，人们可以出来搜索我们的音乐目录.

我开始将设计，基本菜单和命令以及搜索栏以及用户模式和管理模式放到一起，但是在尝试收集数据并使数据可搜索时被卡住了

我们在excel表中列出了所有音乐目录.使该搜索成为可能的最简单方法是什么，以便它调出并显示您搜索的内容

然后的想法是使它连接到蓝牙或wifi网络，并将其发送到其他19英寸机架安装中的一个，这样就可以将其添加到播放列表中，或者可以将其自动添加到VDJ中播放列表

这样一来，我们就不必再为每次活动打印一些纸质票据了

只是想知道是否有人对从excell工作表中检索数据的最简单方法有想法，因此在站点上搜索该想法，但看不到任何与该想法接近的东西，任何帮助都欢迎您. div>

Excel互操作 [
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

解决方案

Excel interop[^] should help...

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

这篇关于概念想法行不通的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！