[Isis-users] PFT for music database

[Guilda Ascencio]

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/20150317/14c2cc3a/attachment.html>