[Isis-users] PFT for music database

[Guilda Ascencio]

Renate:

For displaying all the tracks of a CD add to the display format

/'$$REF:music, tracks, MID_'v20/

 where you want the tracks to be displayed.

music is the database.

tracks is the display format to be used for displaying the information of
each track

MID_'V20 is the search expression to be used for recovering all the tracks
of the CD.

You must add in music.par a reference to the track format:

tracks.*=%path_database%music/pfts/en/tracks.*

You can see how it works in abcdwiki.net

English -> demo ABCD with copies ->database: Music


In
http://abcdwiki.net/wiki/es/index.php?title=Formatos_de_salida_que_integran_la_informaci%C3%B3n_de_bases_de_datos_relacionadas
you will find an explanation (in spanish) of how the '$$REF:  command
works.  This is a command of ABCD not of the display format of Cisis

Regards

Guilda


On Tue, Mar 17, 2015 at 9:16 AM, Guilda Ascencio <gascencio at msinfo.info>
wrote:

> Renate.
>
> The command
>
> /'$$REF:Base_de_datos, Formato, Expresion de búsqueda'/
>
> included in one Pft instructs ABCD to a search on the database
> "Base_de_datos", using the search expression identified in "Expresion de
> búsqueda"  and displays the record located using the display format
> "Formato".
>
> As internally ABCD does a search, all the records that satisfies the
> search expression are recovered. For instance if you identifies the cd with
> the id XXX and have 2 types of records :"CD"  and "TRACKS"  you could build
> a key in the FST that responds to XXXTRACKS in order to recover all the
> tracks of the CD XXX  and using the $$REF command  (the one of ABCD not of
> CISIS) all the tracks of a certains CD will be displayes
>
> We could do an example in abcdwiki if you send me the def and pfts folder,
> the fst of the database and one iso with some records of your database.  I
> think this will be of interest to all the users,
>
> On Tue, Mar 17, 2015 at 8:16 AM, Renate Morgenstern <rmorgenstern at iway.na>
> wrote:
>
>> Thanks for your mail.
>> Regarding option 1: I do not want to convert 300000 records now to such a
>> format. And there are too many subfields to be entered to capture all the
>> info about a track - about 30 only for the tracks.  But I read up on it for
>> other possible uses.
>>
>> We are using the 2nd option you mentioned already as on Winisis. We have
>> the fst which makes the linking possible, and it works fine when I want to
>> display the CD for the track.
>> The problem is when I want to show ALL the tracks on a CD. Currently it
>> only displays the 1st occurrence, but the others are not shown.
>> But thanks for the references - they will be helpful.
>> Regards
>> Renate
>>
>> ----- Original Message -----
>> From: Guilda Ascencio <gascencio at msinfo.info>
>> Date: Tuesday, March 17, 2015 1:59 pm
>> Subject: Re: PFT for music database
>> To: Renate Morgenstern <rmorgenstern at iway.na>, Lista Isis <
>> isis-users at iccisis.org>
>>
>> > 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``,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/20150325/eaa8592a/attachment.html>