Awesome work..Great start..Thanks Aravind..We will start updating
--- In arrahmanfans@yahoogroups.com, ARRvind <arr_arv...@...> wrote:
>
> 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...@...> wrote:
>
> From: raj <arr_naga...@...>
> 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.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
>
> >
>
