[Isis-users] PFT for music database

[Guilda Ascencio]

Go to abcdwiki.net  spanish->demo abcd with no copies-> Cepal database->new
record ->monografías -> existencias -> click on then + icon.  I think is
not difficult to enter the information of a repetible field in that way.

Another thing you can do is assign an identification number to the each CD
and identify the track with the same number, also you must have 2 types of
record: CD and Track.  You can use the picklist procedure for copying in
the tracks some information of the CD (see
http://abcdwiki.net/wiki/es/index.php?title=Pasar_a_un_registro_la_informaci%C3%B3n_de_una_base_de_datos_relacionada
)

Then using a proper FST and the  the display format the command (only
available on ABCD. See http://
http://abcdwiki.net/wiki/es/index.php?title=Formatos_de_salida_que_integran_la_informaci%C3%B3n_de_bases_de_datos_relacionadas)


/'$$REF:Base_de_datos, Formato, Expresion de búsqueda'/

 you can integrate in one display the information of the cd and the tracks

When you browse the data base by Mfn you will display the cd record and the
tracks record, but if you do a search you could only recover the CD and you
will see the tracks as part of the CD record.


But, if you ask my opinion, I think is easier and more consistent having
the tracks as a repetible field of the CD record.

Regards

Guilda

On Tue, Mar 17, 2015 at 3:10 AM, Renate Morgenstern <rmorgenstern at iway.na>
wrote:

>  The track information is not only the track title, but it entails all
> the information: artists, publisher, composer, record label. etc, etc.
> There are really many fields for the track info, and to enter this is one
> repeatable field is not very easy for data entry.
> Regards
> Renate
>
>  Abcd is record oriented.  What you can do is one record for CD and each
> track an occurrence of a repetible field
>
>
>  On Mon, Mar 16, 2015 at 4:21 PM, Renate Morgenstern <rmorgenstern at iway.na>
> wrote:
>
>  Hi Guilda,
>
>
> I have a music database which consists of the CDs and one records fro
> every track on the CD, which in the display links to the CD.
> I also would like to have in the display that it should list all the
> tracks on the CD, but for this it only lists one track, and the others.
>
> Currently it looks like this when the CD title is displayed:
> Record no: 020005
> Library No: CDE01158A
>
> CD-Cover Title: Greatest Hits [Dan Fogelberg]
> *Other tracks on CD : Part of the plan*
> Album type:Same artist(s)
> Dan Fogelberg
>
> How can I get the display to list ALL the tracks?
> Here is the PFT:
>
> Thanks for the help,
> Renate
>
> ==========================
>
> (if p(v800) then '<tr><td width=20% valign=top><font face=arial
> size=2>'v0| |,'</td><td valign=top><font face=arial size=2>
> <img src="../common/show_image.php?image='v800'&base=music" width=70
> target=top>'/'<br></td>' fi/)/
>
> 'Record no: 'mfn(6)'<br>'
> if p(v20) then 'Library No: 'v20+|; |'<br>'/fi/
> if p(v78) then 'Library No: 'v78,'<br>'fi/
> if a(v1) and p(v41) then "TRACK: "v41,/'<br> ON CD:
> ',ref(l(|LIB_|v78),v1," : "v2), fi/'<br>'
> if p(v1) and a(v41) then 'CD-Cover Title: ',v1," : "v2," ("v3")",fi,'<br>'
> if p(v1) then 'Other tracks on CD : ',ref(l(|MID_|v20),(v41," :
> "v44|<br>|)), fi/'<br>'
> if p(v55) then 'Album type:'v55,'<br>',fi/
> if p(v4) then if occ=1 then 'Variant titles:',fi,v4 '<br>'fi/
> if p(v8) then if occ=1 then 'Artist or choir or orchestra:',fi,v8,'<br>'
> fi/
> if p(v9^a) then if occ=1 then 'Composer:',fi,v9^b| |v9^a,'<br>' fi/
> if p(v12) then if occ=1 then 'Author:',fi,v12,'<br>' fi/'<p>'
> if p(v154) then 'Status:',v154+|; |,'<br>',/fi/
>
> (if p(V41) and a(v1) then `<a href='javascript:CruzarABCD("`v1,|,
> |v1`","MID_")'>` v1,|, |v2`</a>`,if iocc<>nocc(v41) then `;  ` fi fi/)
>
> '<br>'
>
>
>
>
>    --
>
> Renate Morgenstern
> Tel.: +264 61 242124
> Cell: +264 81 2910284
> Fax: 088637518
> Windhoek, Namibia
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20150317/d2277b42/attachment.html>