>From the Single song excel sheet uploaded by murugan, any kind of list can be easily extracted.
--- In arrahmanfans@yahoogroups.com, Indmov Buff <indmovb...@...> wrote: > > My personal preference is to have a thorough list (actor, actresses, director > etc), Roshan but if it makes things more complex, i guess we can exclude it. > > > > ________________________________ > From: Roshan <c.pix...@...> > To: arrahmanfans@yahoogroups.com > Sent: Tue, 24 August, 2010 0:17:05 > Subject: Re: [arr] Song Database Structure > > > do we need the actors information and all ? not sure.. they don't mean > anything > to music. > > > just my opinion. but if you all think it is useful, let's keep it. > > > > > On Mon, Aug 23, 2010 at 10:18 PM, Vinayakam Murugan <mvinayakam.li...@...> > wrote: > > > >[Attachment(s) from Vinayakam Murugan included below] > >I have switched the Movie name and Song Name column in the sheet sent by > >ARRvind. > > > > > >Warm Regards > >~~~~~~~~~~~~~~~ > >Vinayak > > > >http://www.flickr.com/photos/rightplacerighttime/ > > > > > > > >On Mon, Aug 23, 2010 at 10:15 PM, Vinayakam Murugan <mvinayakam.li...@...> > >wrote: > > > >Sorry, I thought I had added Movie Name. ARRvind has added both of your > >requests. > >> > >> > >>Thanks, ARRvind. > >> > >>Warm Regards > >>~~~~~~~~~~~~~~~ > >>Vinayak > >> > >>http://www.flickr.com/photos/rightplacerighttime/ > >> > >> > >> > >>On Mon, Aug 23, 2010 at 10:07 PM, Vinayakam Murugan <mvinayakam.li...@...> > >>wrote: > >> > >>Hey Raj > >>> > >>>Movie Name is already there. I will add Raga to the same. > >>> > >>> > >>> > >>>Warm Regards > >>>~~~~~~~~~~~~~~~ > >>>Vinayak > >>> > >>>http://www.flickr.com/photos/rightplacerighttime/ > >>> > >>> > >>> > >>>On Mon, Aug 23, 2010 at 6:50 AM, raj <arr_naga...@...> wrote: > >>> > >>> > >>>>Hi Vinayagam Murugan, > >>>> > >>>>The format is ok. Please add the following columns on the songs sheet. > >>>> > >>>>> movie_name > >>>>> Ragaa > >>>> > >>>>Please upload the same to google docs as it can be edited online by the > >>>>group > >>>>members. > >>>> > >>>> > >>>>--- In arrahmanfans@yahoogroups.com, Roshan <c.pixels@> wrote: > >>>>> > >>>>> sorry.. scratch that. opened it. > >>>>> > >>>>> I think it is a good format. let's start using it and probably add some > >more > >>>>> columns. > >>>>> > >>>> > >>>>> On Mon, Aug 23, 2010 at 1:44 AM, Roshan <c.pixels@> wrote: > >>>>> > >>>>> > Vinayak, > >>>>> > > >>>>> > I am not able to open it on iWork Numbers. it usually opens all the > >>>>> > spreadsheet formats including .xls. but i can't open this one. > >>>>> > > >>>>> > what do you think is the problem ? I don't have windows. I can try it > >>>>> > on > >>>>> > Ubuntu later. > >>>>> > > >>>>> > > >>>>> > > >>>>> > On Sat, Aug 21, 2010 at 3:56 PM, Vinayakam Murugan < > >>>> > > > mvinayakam.lists@> wrote: > >>>>> > > >>>>> >> > >>>>> >> [Attachment(s) <#12a9b6fdb7b61031_12a94d62ec0198a1_TopText> from > >>>> > >>>>> >> Vinayakam Murugan included below] > >>>>> >> > >>>>> >> Hello Friends > >>>>> >> > >>>>> >> I decided to change the Subject line to make it more relevant. > >>>>> >> > >>>>> >> Here is a scratch Db Structure. Like I have seperated Films / Albums > >from > >>>>> >> Songs, we should seperate Singers & Awards also from Songs. However > that > >>>>> >> could be better achieved through a Db than excel. This sheet is for > >>>>> >> illustration purposes only. Further Db normalization is required. > >>>>> >> > >>>>> >> > >>>>> >> Warm Regards > >>>>> >> ~~~~~~~~~~~~~~~ > >>>>> >> Vinayak > >>>>> >> > >>>>> >> http://www.flickr.com/photos/rightplacerighttime/ > >>>>> >> > >>>>> >> > >>>> > >>>>> >> On Fri, Aug 20, 2010 at 8:02 AM, raj <arr_nagaraj@> wrote: > >>>>> >> > >>>>> >>> > >>>>> >>> > >>>>> >>> Ok..I make a living by Databases and Databases only :) > >>>>> >>> I am a DBA. So yes..I can help. As a first step, it would be great > >>>>> >>> if someone can comeup with a excel containing the following fields. > >>>>> >>> > >>>>> >>> 1) Film_name > >>>>> >>> 2) Song_name > >>>>> >>> 3) Singers_name ( comma seperated ) > >>>>> >>> 4) date of release > >>>>> >>> 5) Genre of the song ( Western,fusion,carnatic classical,quawalli ) > >>>>> >>> 6) Director of the film > >>>>> >>> 7) Lead actor > >>>>> >>> 8) Actress > >>>>> >>> 9) Ragaa of the song ( if possible ) > >>>>> >>> 10) Language > >>>>> >>> 11) is_dubbed_film ( yes/no) > >>>>> >>> 12) Producer of the film > >>>>> >>> 13) Lyricst. > >>>>> >>> 14) Miscellaneous. > >>>>> >>> > >>>>> >>> You can add few more fields if you feel like. I am keeping it simple > >>>>> >>> as of now and we can change the DB design( (De)Normalize ) > >>>>> >>> depending > >>upon > >>>>> >>> our needs. As a first step, someone can create a document on google > >>>>> >>> docs > >>>>>and > >>>>> >>> start updating the same. As its on Google docs, most of us can > >>contribute > >>>>> >>> and we can get these details soon. Once the data > >>>>> >>> collection is complete, DB design can be adjusted and we can start > >>>>> >>> working on the application. > >>>>> >>> > >>>>> >>> > >>>> > > >>> --- In arrahmanfans@yahoogroups.com <arrahmanfans%40yahoogroups.com>, > >>>> > >>>>> >>> Indmov Buff <indmovbuff@> wrote: > >>>>> >>> > > >>>>> >>> > Fantastic! The majority vote is for a database it seems. > >>>>> >>> > > >>>>> >>> > I don't have any skills in database but open to learning. Also, > >>>>> >>> > I'd > >be > >>>>> >>> happy to > >>>>> >>> > allocate time to sit through the group mails for the information > that > >>>>> >>> will make > >>>>> >>> > it a good database. I am mainly interested in the research > >>>>> >>> > aspects > of > >>>>> >>> the work > >>>>> >>> > involved in finishing this database that we are after. So happy to > >>>>> >>> contribute in > >>>>> >>> > the form getting the data together , more on the creative side > rather > >>>>> >>> than the > >>>>> >>> > technical side. So I guess, we should start off with a list of > people > >>>>> >>> who are > >>>>> >>> > willing to help. And this has got to be a bit of a commitment > >>>>> >>> > given > >>>>> >>> that we will > >>>>> >>> > need to co-ordinate with members around the world with different > work > >>>>> >>> and social > >>>>> >>> > commitments. I am up for it! > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > ________________________________ > >>>>> >>> > From: Gopal Srinivasan <catchgops@> > >>>>> >>> > >>>> > > >>> > To: arrahmanfans@yahoogroups.com <arrahmanfans%40yahoogroups.com> > >>>> > >>>>> >>> > Sent: Wed, 18 August, 2010 16:51:43 > >>>>> >>> > Subject: Re: [arr] Database for group of contents from useful > e-mails > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > Glad to see this outpouring of enthusiasm. Hopefully, it will > >sustain. > >>>>> >>> I, among > >>>>> >>> > others, have tried various forms of this previously that did not > >>>>> >>> culminate in > >>>>> >>> > anything (beyond my discography, which too hasn't been updated in > >>>>> >>> > a > >>>>> >>> year) as > >>>>> >>> > time turned out to be a major constraint. Some of the modes we > >>>>> >>> > have > >>>>> >>> considered > >>>>> >>> > includes static web lists, wikis and databases. In my opinion, a > >>>>> >>> database at the > >>>>> >>> > backend is probably the best with front end forms for querying. > >>>>> >>> Depending on how > >>>>> >>> > simple or complex it turns out, something like Zoho Creator might > >work > >>>>> >>> too. > >>>>> >>> > What's needed is the involvement of people who are well versed > >>>>> >>> > with > >>>>> >>> database > >>>>> >>> > design AND those that can source information. If we can do a good > >>>>> >>> enough job of > >>>>> >>> > this there is potential to make it official. Next steps perhaps > >>include > >>>>> >>> forming > >>>>> >>> > a core team, identifying the types of information we want stored, > >>>>> >>> design the > >>>>> >>> > schema and then create and populate. > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > On Wed, Aug 18, 2010 at 06:31, Roshan <c.pixels@> wrote: > >>>>> >>> > > >>>>> >>> > > >>>>> >>> > > > >>>>> >>> > >I can work on the technical side of it. (Development and > >>>>> >>> > >design). > >But > >>>>> >>> will > >>>>> >>> > >really appreciate if someone can assist as well. I will need > >>>>> >>> > >some > >>help > >>>>> >>> from you > >>>>> >>> > >guys about collecting the info from the group. it seems like a > >>>>> >>> > >lot. > >>>>> >>> but if we > >>>>> >>> > >collectively do it, we can finish it in within a month or two > >>>>> >>> (including the > >>>>> >>> > >development). > >>>>> >>> > > > >>>>> >>> > >I will also need some input in choosing the domain > >>>>> >>> > > > >>>>> >>> > >I thought of some > >>>>> >>> > > > >>>>> >>> > >ARDB.in > >>>>> >>> > > > >>>>> >>> > >arrinfo.org > >>>>> >>> > > > >>>>> >>> > >i tried some domains that has ar rahman in the name, but they > >>>>> >>> > >all > >>seem > >>>>> >>> to have > >>>>> >>> > >been taken. > >>>>> >>> > > > >>>>> >>> > >As for hosting and domain, I don't mind paying for it. I have a > >>>>> >>> dedicated server > >>>>> >>> > >where I host my clients. > >>>>> >>> > > > >>>>> >>> > >so, to sum it up > >>>>> >>> > > > >>>>> >>> > >1. website as a database of information on ar rahman and his > >>>>> >>> > >music. > >>>>> >>> > > > >>>>> >>> > >2. categorized, search-able contents like Reviews, Information, > >>>>> >>> Singers, > >>>>> >>> > >Instrumentalists, Instruments Used, Places performed, Debuts, > >quotes, > >>>>> >>> interviews > >>>>> >>> > >etc. > >>>>> >>> > > > >>>>> >>> > >3. Quality contents from the group. like awesome reviews of AJ > >>>>> >>> > >and > >>>>> >>> Gayathri and > >>>>> >>> > >the rest of those people who write good contents. of course, with > >>>>> >>> credits and > >>>>> >>> > >links to their blogs / websites etc, if they have any. > >>>>> >>> > > > >>>>> >>> > >please contribute your suggestions. > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > >On Wed, Aug 18, 2010 at 4:14 AM, Indmov Buff <indmovbuff@> wrote: > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > >>Me too! Like where we can sort by singer name or raaga name > >>>>> >>> > >>etc. > >>Just > >>>>> >>> info. IT > >>>>> >>> > >>savvy people out there- what's the best way to go about this? > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > ________________________________ > >>>>> >>> > From: Roshan <c.pixels@> > >>>>> >>> > >>>> > > >>> > >>To: arrahmanfans@yahoogroups.com <arrahmanfans%40yahoogroups.com> > >>>> > >>>>> >>> > >>Sent: Tue, 17 August, 2010 21:45:59 > >>>>> >>> > >>Subject: Re: [arr] Database for group of contents from useful > >>e-mails > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >>That gives me another idea. how about a website with all the > >>>>> >>> > >>info > >>>>> >>> about AR > >>>>> >>> > >>Rahman, his singers, his songs, Genres, and all the other info > >>>>> >>> > >>we > >>>>> >>> find from our > >>>>> >>> > >>group ? we can make it as an extension of this group. there > >>>>> >>> > >>won't > >be > >>>>> >>> any forum > >>>>> >>> > >>or anything.. just info. > >>>>> >>> > >> > >>>>> >>> > >>I would love to do it. > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >>On Tue, Aug 17, 2010 at 6:53 PM, ARRvind <arr_arvind@> wrote: > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >>>Nice initiative.! Would mean a lot to this group.! Lets get > >>>>> >>> > >>>Gopal > >>>>> >>> bro's comment > >>>>> >>> > >>>on this! > >>>>> >>> > >>> > >>>>> >>> > >>>--- On Tue, 8/17/10, Indmov Buff <indmovbuff@> wrote: > >>>>> >>> > >>> > >>>>> >>> > >>> > >>>>> >>> > >>>>From: Indmov Buff <indmovbuff@> > >>>>> >>> > >>>>> >>> > >>>>Subject: [arr] Database for group of contents from useful > e-mails > >>>> > > >>> > >>>>To: "A R" > ><arrahmanfans@yahoogroups.com<arrahmanfans%40yahoogroups.com> > >>>> > >>>>> >>> > > >>>>> >>> > >>>>Date: Tuesday, August 17, 2010, 12:54 PM > >>>>> >>> > >>>> > >>>>> >>> > >>>> > >>>>> >>> > >>>> > >>>>> >>> > >>>> > >>>>> >>> > >>>>Hi Gopal and the rest, > >>>>> >>> > >>>> > >>>>> >>> > >>>> > >>>>> >>> > >>>>I have read many e-mails containing useful data in this group > >>>>> >>> before. Just like > >>>>> >>> > >>>>Arvind's unique list of intro songs for singers there have > >>>>> >>> > >>>>been > >>>>> >>> other lists such > >>>>> >>> > >>>>as Mother songs, child singers lists, raaga based lists and > >>several > >>>>> >>> other > >>>>> >>> > >>>>extremely interesting lists. I strongly feel that we should > >>>>> >>> > >>>>have > >>>>> >>> all of this > >>>>> >>> > >>>>documented as part of the group? Any suggestions on how this > >>>>> >>> > >>>>can > >>be > >>>>> >>> done? > >>>>> >>> > >>>>Database? I am happy to put in time to dig out useful data > >>>>> >>> > >>>>from > >>old > >>>>> >>> e-mails. > >>>>> >>> > >>>> > >>>>> >>> > >>>> > >>>>> >>> > >>>> > >>>>> >>> > >>>> > >>>>> >>> > >>>> > >>>>> >>> > >>> > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >>-- > >>>>> >>> > >>----------------------------------- > >>>>> >>> > >>http://roshanravi.com > >>>>> >>> > >>http://ramblingsoul.com > >>>>> >>> > >>http://cssheaven.org > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > >> > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > >-- > >>>>> >>> > >----------------------------------- > >>>>> >>> > >http://roshanravi.com > >>>>> >>> > >http://ramblingsoul.com > >>>>> >>> > >http://cssheaven.org > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > > > >>>>> >>> > > >>>>> >>> > >>>>> >>> > >>>>> >> > >>>>> >> > >>>>> > > >>>>> > > >>>>> > > >>>> > > > -- > >>>> > >>>>> > ----------------------------------- > >>>>> > http://roshanravi.com > >>>>> > http://ramblingsoul.com > >>>>> > http://cssheaven.org > >>>>> > > >>>>> > > >>>>> > >>>>> > >>>>> -- > >>>>> ----------------------------------- > >>>>> http://roshanravi.com > >>>>> http://ramblingsoul.com > >>>>> http://cssheaven.org > >>>>> > >>>> > >>>> > >>> > >> > > > > > -- > ----------------------------------- > http://roshanravi.com > http://ramblingsoul.com > http://cssheaven.org >
