[Isis-users] Print report for multiple databases

[Soraya Ferraz Lima]

I get it, so it's really not possible.

I had already thought about printing one at a time and then joining them,
but as there is another folder for the second library and it contains 5
databases, it would be more practical to create a single format that could
generate all of them.

Anyway, I really appreciate your help and goodwill!

I wish you the best! Thanks a lot

Em ter., 12 de mai. de 2020 às 12:28, Egbert De Smet <
egbert.desmet em uantwerpen.be> escreveu:

> Well,
>
> one could print a report in which for each record from the catalog a
> record with the same MFN (as the common key) of the other database is
> printed, using REF, e.g.
>
> REF->TRIDI(L->TRIDI(mfn), v1, v2 ...)
>
> Since there is no logical relation to the records of both databases it
> doesn't make sense, but technically it would be possible.
>
> If the only idea is to print all catalog records and all keywords records
> in one spreadsheet, indeed it makes more sense to print both databases
> separately and then merge both CSV-files within the spreadsheet. But I
> don't see the point of it.
>
>
> Are you sure you don't want to print for each catalog record the keywords
> which are related to that catalog record ? But then : see my previous
> e-mail with explanation how to relate records using a common key.
>
>
> Egbert de Smet
> Universiteit Antwerpen
>
>
> ------------------------------
> *From:* Piet De Keyser <piet.dekeyser em ucll.be>
> *Sent:* Tuesday, May 12, 2020 5:21 PM
> *To:* Soraya Ferraz Lima; Egbert De Smet
> *Cc:* Lista Isis
> *Subject:* RE: [Isis-users] Print report for multiple databases
>
>
> Soraya,
>
>
>
> I am afraid this is not possible. The report function is meant to retrieve
> data from only one database. The ref function is, like Egbert explained,
> meant to get additional data from another database for each record. You
> still have to make two reports and add them together using other software,
> e.g. a word processor, Excel. If I understand it well you want a list with
> all titles and keywords. I would make two exports, in comma delimited
> format and import one after the other in Excel. This would allow me to sort
> them alphabetically. From there you can export that list to whatever you
> want: a word processor report, HTML etc.
>
>
>
> Piet
>
>
>
> *Van:* Soraya Ferraz Lima <soyferrazlima em gmail.com>
> *Verzonden:* dinsdag 12 mei 2020 16:25
> *Aan:* Egbert De Smet <egbert.desmet em uantwerpen.be>
> *CC:* Piet De Keyser <piet.dekeyser em ucll.be>; Lista Isis <
> isis-users em iccisis.org>
> *Onderwerp:* Re: [Isis-users] Print report for multiple databases
>
>
>
> Piet, this is exactly what I want to do:
>
> To list all data from two databases in one list!
>
> The bases are different, there is no connection between them. I just want
> to list the data and fields in a single list with the option to generate
> spreadsheet.
>
> As if I were going to make an inventory of all the registered content (in
> fact, I was not able to make the stock-taking tool [manual ref.] work, as I
> do not use the copies base, but that is another matter).
>
> Currently, it is possible to generate a base-by-base list, but I want to
> unify that list.
> I'm using the report module (central / dbadmin / pft.php).
>
> Thank you for your attention!
>
>
>
> Em ter., 12 de mai. de 2020 às 06:15, Egbert De Smet <
> egbert.desmet em uantwerpen.be> escreveu:
>
> Sofie,
>
>
>
> I expect your problem to be the third one listed by Piet under here : you
> want to print records from the ACERVO-database (your catalog) but with, for
> each individual record, additional data which are stored in a different
> database, i.e. TRIDI.
>
> In that case (but ignore the following if not) the assumption is that
> there is a 'common key', i.e. a value in the fields of both databases which
> is common and links the individual records.
>
> E.g. :
>
>  - the principal author name in your catalog, e.g. v100
>
>  - 'other variants' of the same author name, stored in a separate
> database, where the author-name is stored in v1 and the other variant in v2
>
> Then in this case the author name would act as the common key and the
> REF-link would be constructed as :
>
> REF->TRIDI(L('AU_'v100), v2)
>
> because when reading e.g. MFN1 of ACERVO, ISIS can use the v100 value
> (author name) to look for it in the index of TRIDI with the prefix 'AU_'
> (assuming TRIDI indexes the author names with AU_ prefix), retrieve the
> record of the first posting (and only the first one...unless you use the
> special ABCD Central 'repeated REF' trick) and take the v2 from that record
> to print in the catalog record of MFN1.  If the L-function doesn't find the
> correspondent record in TRIDI (there is no variant name), nothing will be
> output with the REF.
>
>
>
> Of course in this example author-names in both databases should exactly
> match, which is not obvious. In most cases for such set-ups you would
> prefer to use a numerical key stored in both databases. E.g. the 'accession
> number' assigned automatically in a MARC-catalog could serve as the key in
> your TRIDI-database, to mark in TRIDI-records the catalog-record to which
> it is linked.
>
>
>
> If you need more help, maybe you should send one or more examples with
> concrete data (e.g. a few ISO-output records from both databases), or at
> least a sample output (manually constructed) to illustrate what you are
> aiming at.
>
>
>
> Egbert de Smet
> Universiteit Antwerpen
>
>
> ------------------------------
>
> *From:* Piet De Keyser <piet.dekeyser em ucll.be>
> *Sent:* Tuesday, May 12, 2020 9:40 AM
> *To:* Soraya Ferraz Lima; Egbert De Smet
> *Cc:* Lista Isis
> *Subject:* RE: [Isis-users] Print report for multiple databases
>
>
>
> Soraya,
>
>
>
> I am afraid it still is not very clear what you want to do. Do you want:
>
>
>
> ·       to list all data from two databases in one list?
>
> ·       to make a list from e.g. which records contain the word “water”
> in the title in both databases?
>
> ·       to list data from database A and for each record retrieve some
> corresponding data from database B (comparable with what happens in
> relational databases)?
>
> ·       …
>
>
>
> Piet de Keyser
>
> Belgium
>
>
>
>
>
> *Van:* isis-users <isis-users-bounces+piet.dekeyser=ucll.be em iccisis.org> *Namens
> *Soraya Ferraz Lima
> *Verzonden:* maandag 11 mei 2020 23:33
> *Aan:* Egbert De Smet <egbert.desmet em uantwerpen.be>
> *CC:* Lista Isis <isis-users em iccisis.org>
> *Onderwerp:* Re: [Isis-users] Print report for multiple databases
>
>
>
> Hi Egbert!
>
> Thanks for your reply.
>
>
>
> I want to use this function
>
> [image: image.png]
>
> to show data of my two databases. When I select a database (in this case
> ACERVO [catalog]) the report format only shows data of this database. I
> want to "combine" the data of catalog and tridi in a format.
>
> I like I said, the ref function only shows the first record of tridi and I
> would like to show data for all of its records.
>
>
>
> I hope I was clear now.
>
> Thanks!
>
>
>
> Em seg., 11 de mai. de 2020 às 17:40, Egbert De Smet <
> egbert.desmet em uantwerpen.be> escreveu:
>
> Hi,
>
>
>
> I is not fully clear to me what you want, at least not from you
> description. But what you are doing is this : you use the 'L'(ookup)
> function to identify in the TRIDI database the first posting (and only the
> first) for the key 'BASE=TRIDI' and from that record you retrieve some
> fields like v245 and v650 (title and descriptors).
>
> Normally the key used with the L-function would not be a fixed one, but
> one constructed by a value (preceded by your prefix) from the actual record
> (in the catalog database). Now, with a fixed key, all REF-operations will
> go to the same (first) posting of the TRIDI-database.
>
>
>
> Could you perhaps explain better what you want ?
>
>
>
> Egbert de Smet
> Universiteit Antwerpen
>
>
> ------------------------------
>
> *From:* isis-users <isis-users-bounces+egbert.desmet=ua.ac.be em iccisis.org>
> on behalf of Soraya Ferraz Lima <soyferrazlima em gmail.com>
> *Sent:* Monday, May 11, 2020 8:40 PM
> *To:* Lista Isis
> *Subject:* [Isis-users] Print report for multiple databases
>
>
>
> Hello all!
>
> I have two databases (catalog and tridi) and I would like to print a
> report with the data from the two databases using the print feature.
>
> I tried to use the ref feature, but only the first record of the base is
> displayed.
> Here is the format I used from the catalog base:
>
> '<tr>'
>
> '<td valign="top">',v245^a,|: |v245^b,if a(v245^a) then
> ' ',fi,'</td>'/
> '<td valign="top">',(v650+| / |),if a(v650) then ' ',fi,'</td>'/
>
> '</tr>'
>
>
>
> ref->tridi(l->tridi('BASE=TRIDI'),
>   '<tr>'
>
> '<td valign="top">',v245^a,|: |v245^b,if a(v245^a) then
> ' ',fi,'</td>'/
> '<td valign="top">',(v650+| / |),if a(v650) then ' ',fi,'</td>'/
>
> '</tr>')
>
>
>
> OBS. I have the 'BASE=TRIDI' configured in the fst of tridi database.
>
>
> Is there any way to make the ref recursive or some other way to build this
> format?
>
>
>
> Thanks!
>
>
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20200512/18ba69fb/attachment.html>
-------------- Próxima Parte ----------
Um anexo não-texto foi limpo...
Nome: image001.png
Tipo: image/png
Tamanho: 9316 bytes
Descrição: não disponível
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20200512/18ba69fb/attachment.png>