<div dir="ltr">Piet, this is exactly what I want to do:<br><br><span style="font-family:Calibri,sans-serif;font-size:14.6667px">To list all data from two databases in one list!</span><br><br>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.<br><br>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).<br><br>Currently, it is possible to generate a base-by-base list, but I want to unify that list.<br>I'm using the report module (central / dbadmin / pft.php).<br><br>Thank you for your attention!<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em ter., 12 de mai. de 2020 às 06:15, Egbert De Smet <<a href="mailto:egbert.desmet@uantwerpen.be">egbert.desmet@uantwerpen.be</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div id="gmail-m_-8616046397470881616divtagdefaultwrapper" style="font-size:12pt;color:rgb(0,0,0);font-family:Calibri,Helvetica,sans-serif" dir="ltr">
<p>Sofie,</p>
<p><br>
</p>
<p>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.</p>
<p>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.
<br>
</p>
<p>E.g. : <br>
</p>
<p> - the principal author name in your catalog, e.g. v100</p>
<p> - '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</p>
<p>Then in this case the author name would act as the common key and the REF-link would be constructed as :
<br>
</p>
<p>REF->TRIDI(L('AU_'v100), v2)</p>
<p>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. <br>
</p>
<p><br>
</p>
<p>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.
<br>
</p>
<p><br>
</p>
<p>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.
<br>
</p>
<div id="gmail-m_-8616046397470881616Signature">
<div><font size="2"><span style="font-size:10pt">
<div><br>
</div>
<div>Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr style="display:inline-block;width:98%">
<div id="gmail-m_-8616046397470881616divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> Piet De Keyser <<a href="mailto:piet.dekeyser@ucll.be" target="_blank">piet.dekeyser@ucll.be</a>><br>
<b>Sent:</b> Tuesday, May 12, 2020 9:40 AM<br>
<b>To:</b> Soraya Ferraz Lima; Egbert De Smet<br>
<b>Cc:</b> Lista Isis<br>
<b>Subject:</b> RE: [Isis-users] Print report for multiple databases</font>
<div> </div>
</div>
<div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US">Soraya,</span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US"> </span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US">I am afraid it still is not very clear what you want to do. Do you want:</span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US"> </span></p>
<ul style="margin-top:0cm;margin-bottom:0cm" type="disc">
<li style="margin:0cm 0cm 0.0001pt 36pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US">to list all data from two databases in one list?</span></li><li style="margin:0cm 0cm 0.0001pt 36pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US">to make a list from e.g. which records contain the word “water” in the title in both databases?</span></li><li style="margin:0cm 0cm 0.0001pt 36pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US">to list data from database A and for each record retrieve some corresponding data from database B (comparable with what happens in relational databases)?</span></li><li style="margin:0cm 0cm 0.0001pt 36pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US">…</span></li></ul>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US"> </span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US">Piet de Keyser</span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US">Belgium</span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US"> </span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span lang="EN-US"> </span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<b><span lang="NL">Van:</span></b><span lang="NL"> isis-users <isis-users-bounces+piet.dekeyser=<a href="mailto:ucll.be@iccisis.org" target="_blank">ucll.be@iccisis.org</a>>
<b>Namens </b>Soraya Ferraz Lima<br>
<b>Verzonden:</b> maandag 11 mei 2020 23:33<br>
<b>Aan:</b> Egbert De Smet <<a href="mailto:egbert.desmet@uantwerpen.be" target="_blank">egbert.desmet@uantwerpen.be</a>><br>
<b>CC:</b> Lista Isis <<a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a>><br>
<b>Onderwerp:</b> Re: [Isis-users] Print report for multiple databases</span></p>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
</p>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
Hi Egbert!</p>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
Thanks for your reply.</p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
</p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
I want to use this function</p>
</div>
<div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<img id="gmail-m_-8616046397470881616_x0000_i1025" alt="image.png" style="width: 3.1805in; height: 1.7847in;" width="305" height="171" src="cid:1720943949b4cff311"></p>
</div>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
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.</p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
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.</p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
</p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
I hope I was clear now.</p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
Thanks!</p>
</div>
</div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
</p>
<div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
Em seg., 11 de mai. de 2020 às 17:40, Egbert De Smet <<a href="mailto:egbert.desmet@uantwerpen.be" style="color:blue;text-decoration:underline" target="_blank">egbert.desmet@uantwerpen.be</a>> escreveu:</p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin-left:4.8pt;margin-right:0cm">
<div>
<div id="gmail-m_-8616046397470881616gmail-m_-9116797418747260820divtagdefaultwrapper">
<p><span style="font-size:12pt;color:black">Hi,</span></p>
<p><span style="font-size:12pt;color:black"> </span></p>
<p><span style="font-size:12pt;color:black">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).</span></p>
<p><span style="font-size:12pt;color:black">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.</span></p>
<p><span style="font-size:12pt;color:black"> </span></p>
<p><span style="font-size:12pt;color:black">Could you perhaps explain better what you want ?</span></p>
<p><span style="font-size:12pt;color:black"> </span></p>
<div id="gmail-m_-8616046397470881616gmail-m_-9116797418747260820Signature">
<div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:10pt;color:black">Egbert de Smet<br>
Universiteit Antwerpen</span></p>
</div>
</div>
</div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black"> </span></p>
<div>
<div style="text-align:center;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif" align="center">
<span style="font-size:12pt;color:black">
<hr width="98%" size="3" align="center">
</span></div>
<div id="gmail-m_-8616046397470881616gmail-m_-9116797418747260820divRplyFwdMsg">
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<b><span style="color:black">From:</span></b><span style="color:black"> isis-users <isis-users-bounces+egbert.desmet=<a href="mailto:ua.ac.be@iccisis.org" style="color:blue;text-decoration:underline" target="_blank">ua.ac.be@iccisis.org</a>> on behalf of
Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" style="color:blue;text-decoration:underline" target="_blank">soyferrazlima@gmail.com</a>><br>
<b>Sent:</b> Monday, May 11, 2020 8:40 PM<br>
<b>To:</b> Lista Isis<br>
<b>Subject:</b> [Isis-users] Print report for multiple databases</span><span style="font-size:12pt;color:black">
</span></p>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black"> </span></p>
</div>
</div>
<div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black">Hello all!<br>
<br>
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.<br>
<br>
I tried to use the ref feature, but only the first record of the base is displayed.<br>
Here is the format I used from the catalog base:<br>
<br>
'<tr>'</span></p>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black">'<td valign="top">',v245^a,|: |v245^b,if a(v245^a) then ' ',fi,'</td>'/<br>
'<td valign="top">',(v650+| / |),if a(v650) then ' ',fi,'</td>'/</span></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black">'</tr>'</span></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black"> </span></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black">ref->tridi(l->tridi('BASE=TRIDI'),<br>
'<tr>'</span></p>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black">'<td valign="top">',v245^a,|: |v245^b,if a(v245^a) then ' ',fi,'</td>'/<br>
'<td valign="top">',(v650+| / |),if a(v650) then ' ',fi,'</td>'/</span></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black">'</tr>')</span></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black"> </span></p>
</div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black">OBS. I have the 'BASE=TRIDI' configured in the fst of tridi database.</span></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black"><br>
Is there any way to make the ref recursive or some other way to build this format?</span></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black"> </span></p>
</div>
<div>
<p style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">
<span style="font-size:12pt;color:black">Thanks!</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div>