Announcement

Collapse
No announcement yet.

Organizing A Song Database

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Organizing A Song Database

    Hi guys,

    I've been meaning to create a database of all the songs I have acquired for the past years for purposes of easy indexing.

    Whenever I build song line ups for the mass, I usually have a hard time creating a lineup without reference. We tend to sing songs over and over again.

    If created well, I guess this will help us enrich our participation in the liturgy. I'd know what my choir can sing, or what songs I should teach them still. Also, this could be a valuable tool to identify which specific songs are opt for certain occasions/seasons.

    I'm planning to use Microsoft Excel for the database. Do you have any ideas you could share on how I could organize that? Or perhaps you may have a better software in mind?

    Ok kasi sana kung may search engine (lol) pero parang hardcore na ata yun!
    At the rate our people are bombarded with all sorts of Western pop and commercial music through radio, television, jukeboxes, record players, and movies the day may not be too far away when we shall have committed our own native music to the grave; harshly forgotten, abandoned, its beauty laid to waste by an unknowing generation whose only fault is not having been given the chance to cultivate a love of it

    Felipe Padilla de Leon

  • #2
    Re: Organizing a song database

    Originally posted by tuningspork View Post
    Hi guys,

    I've been meaning to create a database of all the songs I have acquired for the past years for purposes of easy indexing.

    ...

    I'm planning to use Microsoft Excel for the database. Do you have any ideas you could share on how I could organize that? Or perhaps you may have a better software in mind?

    Ok kasi sana kung may search engine (lol) pero parang hardcore na ata yun!
    Tignan mo ang mga ito:

    http://www.magsimba.com/Awit_Lahat.asp

    http://www.magsimba.com/AwitSaPista_Talaan.asp
    -- Vic Romero

    www.magsimba.com
    www.tagalog1.com
    www.kasaysayan1.com
    www.photoromero.com

    Comment


    • #3
      Re: Organizing a song database

      Nakita ko na po, kuya vic_romero, salamat! Malakiiiiing tulong ito!

      Subalit ang gusto ko ho sana ay magkaroon ako ng pansariling kopya ng mga kantang mayroon na ako. Hindi rin naman po kasi palagian ang koneksyon ko sa Internet kung kaya't hindi ko ho makikita nang madalas ang websayt mo. Isa pa, mayroon din po akong mga kantang nasusulat sa ibang lengguwahe (gaya ng Ingles), kaya mas ninanais ko ho ang magkaroon ng personalized na kopya.

      Hmm, siguro magandang ibukod ko na ho yung mga kantang angkop para sa mga ispesipikong pagdiriwang, ano? Kaso iniisip ko pa po kung papaano ko kaya gagawin na mukhang malinis ang database ko. Medyo iniiwasan ko ho ang pag-uulit-ulit ng mga pamagat ng mga kantang bagay sa iba't ibang okasyon.

      Hmm... salamat po muli kuya vic_romero!
      At the rate our people are bombarded with all sorts of Western pop and commercial music through radio, television, jukeboxes, record players, and movies the day may not be too far away when we shall have committed our own native music to the grave; harshly forgotten, abandoned, its beauty laid to waste by an unknowing generation whose only fault is not having been given the chance to cultivate a love of it

      Felipe Padilla de Leon

      Comment


      • #4
        Re: Organizing a song database

        puwede mo itong gawin sa excel, kase sa excel may Find function ctrl+f o kaya pag nag enter ka ng multiple title's lalabas yung kamukha niyang entry pag enter mo ng mga few letters, at least sa ganung way maalert ka niya kung naka enter na yung data na yun. yan din ang balak ko, d lang sa liturgical library ko kung di sa lahat ng scores at mp3 collection ko, sabog sabog din ang library ko.

        Comment


        • #5
          Re: Organizing a song database

          @allen lucas: gusto ko nga sanang gamitin yung "table" function ng excel para mas madaling makapaghanap.

          isa itong drop down list na pipiliin mo kung papaano iaarrange yung database mo: pwedeng by title, composer, etc. kaso ang problema lang e kung hindi na 1:1 ang ratio ng mga elemento sa table (halimbawa, 1 kanta na makikita sa 3 songbook). hindi ko alam kung papaano i-organize ang listahan kung gayon ang sitwasyon. pero kung di naman o-oc-hin ang paggawa nito e di naman ito problema.

          naghanap ako sa internet ng mga software na makatutulong sa paggawa ng databas at nakita ko ang microsoft access (kasama sa microsoft office). mukha siyang maganda pero hindi ko pa nasusubukan. will try that later today. hehe.

          Microsoft Office Access 2007 features a number of improvements that make the process of creating a new database easier. Even if you have created databases before, it is likely that you will appreciate these features for their ability to speed up the creation process.

          This article covers the basic process of starting Office Access 2007 and creating a database, either by using a template or by creating your own tables, forms, reports, and other database objects. It also details a few techniques that you can use to get information into your new database.
          salamat sa suhestyon, allen lucas!
          At the rate our people are bombarded with all sorts of Western pop and commercial music through radio, television, jukeboxes, record players, and movies the day may not be too far away when we shall have committed our own native music to the grave; harshly forgotten, abandoned, its beauty laid to waste by an unknowing generation whose only fault is not having been given the chance to cultivate a love of it

          Felipe Padilla de Leon

          Comment


          • #6
            Re: Organizing a song database

            Ang ginagawa ko sa aking koleksyon ng mga piyesa ay ini-scan ko lahat at saka ko susuriin ayon sa pangalan ng kanta, mang-aawit o kung saang album ito nanggaling (sa kaso ng mga MP3) at kung sa mga piyesa naman ay sinusuri ko na lang sa pangalan. Maaari mo rin silang ilagay sa mga panlupi (folder) ayon sa panahon kung kailan ninyo ito nais awitin o kung saang bahagi ito ng misa nabibilang. Ang magiging problema lang rito ay kung magkakaroon ka ng napakaraming "subfolder".

            Maaari mo na silang ayusin ayon sa mga nabanggit na pag-uuri sa pamamagitan ng pagpindot sa mga pangalan ng uri, katulad ng iyong ginagawa sa Microsoft Excel.
            Attached Files

            My blog: http://azwc.blogspot.com/ | http://eowpo.multiply.com/
            Blog currently inactive. It's a little messy with my random thoughts, but if you can bear the madness, please comment, or at least, follow :D

            Comment


            • #7
              Re: Organizing a song database

              @sjclc: Salamat sa malalim mong sagot. Magpupunas muna ako ng ilong. Hehe.

              Matanong ko lang: may soft copy ka ng mga piyesa mo? Kung oo, ideal ba yun? Kasi parang napakahassling nun kung marami kang mga songbook e. O:

              Anyway, hmm, nagawa ko na kasing ayusin sa Excel yung database alphabetically e. Plus nailagay ko na rin kung sino yung composers, etc etc.

              Ang pinoproblema ko na lang ngayon e kung papaano ko ito mas maiaayos pa para sa tuwing maghahanap ako ng pwedeng kantahin sa misa, madali akong makakikita ng posibleng pagpipilian. Kasi kung ang reference ko lang ay yung masterlist na puro pamagat lang ang nakikita ko, masakit lang sa ulo. Hehe.

              Iniisip ko icategorize pa by theme. Siguro ibubukod ko na rin sa ibang spreadsheet yung special songs.

              Hay, ang hirap ng ganito! Haha.

              Salamat ulit!
              At the rate our people are bombarded with all sorts of Western pop and commercial music through radio, television, jukeboxes, record players, and movies the day may not be too far away when we shall have committed our own native music to the grave; harshly forgotten, abandoned, its beauty laid to waste by an unknowing generation whose only fault is not having been given the chance to cultivate a love of it

              Felipe Padilla de Leon

              Comment


              • #8
                Re: Organizing a song database

                Hindi po lahat, pero sa pananaw ko po ay mainam rin magkaroon ng mga soft copy ng mga piyesa upang mapadali ang pagdadala at pangangasiwa sa mga ito, katulad na nga roon sa nabanggit ko sa huli kong tugon.

                Katulad na lamang noong ako ay mayroon pang USB Flash Drive. Lagi ko iyong dala at nakalagay doon ang aking mga piyesa upang kung sakali man na kailanganin ang mga ito ay pupunta laman ako sa suking piso print internet shop.

                Ang problema nga lang na nakikita ko ay kung hindi magagawan ng tukod (backup) ang mga nasabing piyesa, bagamat ang mga piyesa na ito ay nagsisilbing tukod ng mga nakalimbag na piyesa.

                At hindi ka nag-iisa sa iyong pabalik-balik na balinguyngoy. LOL

                My blog: http://azwc.blogspot.com/ | http://eowpo.multiply.com/
                Blog currently inactive. It's a little messy with my random thoughts, but if you can bear the madness, please comment, or at least, follow :D

                Comment


                • #9
                  Re: Organizing a song database

                  (Ano'ng nangyari sa flash drive mo? O: )

                  Hmm, maganda nga sigurong may soft copy. Kaso pag ginawa ko yun, panibagong ioorganize na naman e. Ang hirap hirap mag-organize. Haha. Kaya isasantabi ko muna yung ideya na mag-scan ng mga pyesa.

                  Mahirap siguro maging librarian.
                  At the rate our people are bombarded with all sorts of Western pop and commercial music through radio, television, jukeboxes, record players, and movies the day may not be too far away when we shall have committed our own native music to the grave; harshly forgotten, abandoned, its beauty laid to waste by an unknowing generation whose only fault is not having been given the chance to cultivate a love of it

                  Felipe Padilla de Leon

                  Comment


                  • #10
                    Re: Organizing a song database

                    Originally posted by tuningspork View Post
                    (Ano'ng nangyari sa flash drive mo? O

                    Hmm, maganda nga sigurong may soft copy. Kaso pag ginawa ko yun, panibagong ioorganize na naman e. Ang hirap hirap mag-organize. Haha. Kaya isasantabi ko muna yung ideya na mag-scan ng mga pyesa.

                    Mahirap siguro maging librarian.
                    Heto ang isang SQL database design. Pag-isipan. Baka makakuha ng mga ideya.


                    create table AWIT
                    (
                    awit_id smallint,
                    pamagat varchar (100),
                    titik_ni varchar (100),
                    tugtugin_ni varchar (100),
                    mga_tala varchar (255),
                    primary key (awit_id)
                    )

                    create table AKLAT
                    (
                    aklat_id smallint,
                    pamagat varchar (100),
                    maykatha varchar (100),
                    tagalathala varchar (100),
                    taon smallint,
                    mga_tala varchar (255),
                    primary key (kapistahan_id)
                    )

                    create table AKLAT_AWIT
                    (
                    aklat_id smallint,
                    awit_id smallint,
                    mga_tala varchar (255),
                    primary key (aklat_id, awit_id)
                    )

                    create table KAPISTAHAN
                    (
                    kapistahan_id smallint,
                    leksyonaryo_bilang smallint,
                    pangalan varchar (100),
                    fecha_A smalldatetime,
                    fecha_B smalldatetime,
                    fecha_C smalldatetime,
                    mga_tala varchar (255),
                    primary key (kapistahan_id)
                    )

                    create table KAPISTAHAN_AWIT
                    (
                    kapistahan_id smallint,
                    awit_id smallint,
                    mga_tala varchar (255),
                    primary key (kapistahan_id, awit_id)
                    )
                    -- Vic Romero

                    www.magsimba.com
                    www.tagalog1.com
                    www.kasaysayan1.com
                    www.photoromero.com

                    Comment


                    • #11
                      Re: Organizing a song database

                      Naku, kuya vic_romero hindi po ako marunong mag-Greek. Hehe.

                      Siguro makatutulong po ito kaso hindi ko lang po alam kung anong programming language ito at kung papaano gagamitin.
                      At the rate our people are bombarded with all sorts of Western pop and commercial music through radio, television, jukeboxes, record players, and movies the day may not be too far away when we shall have committed our own native music to the grave; harshly forgotten, abandoned, its beauty laid to waste by an unknowing generation whose only fault is not having been given the chance to cultivate a love of it

                      Felipe Padilla de Leon

                      Comment


                      • #12
                        Re: Organizing a song database

                        Originally posted by tuningspork View Post
                        Naku, kuya vic_romero hindi po ako marunong mag-Greek. Hehe.

                        Siguro makatutulong po ito kaso hindi ko lang po alam kung anong programming language ito at kung papaano gagamitin.
                        Igagaw
                        -- Vic Romero

                        www.magsimba.com
                        www.tagalog1.com
                        www.kasaysayan1.com
                        www.photoromero.com

                        Comment


                        • #13
                          Re: Organizing a song database

                          Heto ang pinapanibagong disenyo ng database.
                          Attached Files
                          -- Vic Romero

                          www.magsimba.com
                          www.tagalog1.com
                          www.kasaysayan1.com
                          www.photoromero.com

                          Comment


                          • #14
                            Re: Organizing a song database

                            Originally posted by tuningspork View Post
                            @allen lucas: gusto ko nga sanang gamitin yung "table" function ng excel para mas madaling makapaghanap.

                            isa itong drop down list na pipiliin mo kung papaano iaarrange yung database mo: pwedeng by title, composer, etc. kaso ang problema lang e kung hindi na 1:1 ang ratio ng mga elemento sa table (halimbawa, 1 kanta na makikita sa 3 songbook). hindi ko alam kung papaano i-organize ang listahan kung gayon ang sitwasyon. pero kung di naman o-oc-hin ang paggawa nito e di naman ito problema.

                            naghanap ako sa internet ng mga software na makatutulong sa paggawa ng databas at nakita ko ang microsoft access (kasama sa microsoft office). mukha siyang maganda pero hindi ko pa nasusubukan. will try that later today. hehe.



                            salamat sa suhestyon, allen lucas!
                            Mukhang nagegets ko na ang sinasabi mo, tuningspork. Mukhang ang "filter" function ang tinutukoy mo. Napaisip nga ako kung papaano gagawin yun. Pero posible. Kung sa Microsoft Access lang, mas madali sana kung gagamit ng relationships. Pero iisipin ko pang mabuti kung posible nga ba sa Excel.
                            People want:
                            -the FRONT of the bus
                            -the BACK of the church
                            -and the CENTER of attention.

                            Comment


                            • #15
                              Re: Organizing a song database

                              Kapatid, naisip ko na kung paano. Idownload mo yung attachment at tingnan mo ang aking ihinandang step-by-step tutorial.
                              Attached Files
                              People want:
                              -the FRONT of the bus
                              -the BACK of the church
                              -and the CENTER of attention.

                              Comment

                              Working...
                              X