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...@gmail.com> 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...@yahoo.com> 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 <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 >> > >>> arrahmanfans@yahoogroups.com<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: arrahmanfans@yahoogroups.com >> > >>> > <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: >> > >>> > >>arrahmanfans@yahoogroups.com<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" >> > >>> > >>>><arrahmanfans@yahoogroups.com<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 >> > >> >> >> > >