My responses inline. --- In arrahmanfans@yahoogroups.com, Indmov Buff <indmovb...@...> wrote: /* This may be a very silly question - can we add tags to each entry? For eg , names of singers etc are sometimes spelt in different ways.In order to cover all the variations, should we add tags?
*/ Yes can. Perhaps have it comma separated or have a additional column. /* Also , would it help to add the Raaga of each song. I am sure there are songs which have more than one raaga. presumably they are separated by a comma? */ Ragas can be comma separated as of now. /* And how do we want to export this database to the group? Is the only solution to host it external to the group? or could we somehow attach it to the group? Sorry about the stupid questions. */ The idea is to develope a page/application like Roshan did which would help us search all the details we need. The page or application would demand bit of thinking to do. But, as a first step we would need the data to be represented in some format which the guys the working on. Once the song details are complete, we ca start working on the application. Changing or adding data to the database is not a difficult task anyways. /* Could we also add a column for the musicians who worked on each album? and sound engineer as well. Try and capture all the data on the cd perhaps? but this might be going overboard. No harm adding a column I guess. Should Genre have a subdivision to say what the song is predominantly about? patriotic, mother, wedding song etc? */ Yes definitely. We can add a column as sound engineer. Please feel free to add columns with related info. Target is to have all the details on CD. But its a tough target to think of right now. To get started we can first start with song list with a few basic details. As said earlier, rest of the details can be added later on as they come. Thank you for your suggestions Thanks for this Roshan. Great start. I think before people start entering data > into this, we should decide on whether more columns/data are required and > agree > on it collectively? Just a suggestion. > > > > ________________________________ > From: Roshan <c.pix...@...> > To: arrahmanfans@yahoogroups.com > Sent: Tue, 24 August, 2010 0:48:33 > Subject: [arr] songs database > > > Thank you everyone who took the time to compile the list for the db. > > > i have just created a form to collect the data directly to MySQL. so that > exporting it to any db would be easier. > > http://sandbox.roshanravi.com/arrdb/use/ARRahmanDatabase/form1.html > > i will be adding in teh album names from the excel file we have when i get a > chance, but if you want to add something by yourself, please feel free.. > > > > it is just using a form generator. the only goal is to collect the data. > > > these are the updated fields for Album. yet to do the songs db section. > > > Film Or Album Language Dubbed Year of Movie Release Year of Audio Release > Genre > Audio Company Actors director Movie Genre Awards Won for music Awards > Nominated > for music AWards won for movie awards nominated for movie Other notes > > > > -- > ----------------------------------- > http://roshanravi.com > http://ramblingsoul.com > http://cssheaven.org >
