Pals.. Listed the album names, year of release and also the star cast for them in this attached file. Pls go through the list and pls modify if there is any changes / corrections to be done. Need to fill in directors/producers and other info..!
--- On Mon, 8/23/10, raj <arr_naga...@yahoo.com> wrote: From: raj <arr_naga...@yahoo.com> Subject: Re: [arr] Song Database Structure To: arrahmanfans@yahoogroups.com Date: Monday, August 23, 2010, 1:20 AM 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.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 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 >