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...@gmail.com> 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...@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 >>> > >>> >>> >>> >> >> >
