Since we are aiming for this to be a comprehensive source of information, it would help. Tomorrow if someone wants to know which actor has acted most in ARR movies, etc, it will be just a query away.
Warm Regards ~~~~~~~~~~~~~~~ Vinayak http://www.flickr.com/photos/rightplacerighttime/ On Tue, Aug 24, 2010 at 4:47 AM, Roshan <[email protected]> wrote: > > > 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 < > [email protected]> wrote: > >> >> [Attachment(s) <#12aa2000d826af2d_12aa0fcd00fc3b02_TopText> 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 < >> [email protected]> 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 < >>> [email protected]> 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 <[email protected]> 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 [email protected] <arrahmanfans%40yahoogroups.com>, >>>>> Roshan <c.pix...@...> 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.pix...@...> 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.li...@...> 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_naga...@...> 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 >>>>> > >>> [email protected]<arrahmanfans%40yahoogroups.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: >>>>> > >>> > [email protected]<arrahmanfans%40yahoogroups.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: >>>>> > >>> > >>[email protected]<arrahmanfans%40yahoogroups.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" >>>>> > >>> > >>>><[email protected]<arrahmanfans%40yahoogroups.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 > > >
