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...@gmail.com> wrote: > > [Attachment(s) <#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...@yahoo.com> 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 <indmovb...@...> 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 <catchg...@...> >> >> > 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.pix...@...> 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 <indmovb...@...> 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.pix...@...> >> >> > >>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_arv...@...> 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 <indmovb...@...> wrote: >> > >>> >> > >>> >> > >>>>From: Indmov Buff <indmovb...@...> >> >> > >>>>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
