[Isis-users] Print report for multiple databases

Tue May 12 21:46:42 CEST 2020

Soraya,

If you have enough rights on and access to the server, you could run on a regular schedule  a small batch file with some mx commands that can automate the job. For a windows server it could contain something like the following:

mx db1 pft=@output.pft<mailto:pft=@output.pft> now -all  > myfile.txt
mx db2 pft=@output.pft<mailto:pft=@output.pft> now -all  >> myfile.txt

etc.

This would overwrite myfile.txt for the first database, and append the output for database 2 etc.
“Output.pft” of course would be your pft and “db1” and “db2” stand for the names of your databases.

This should be similar  in Linux – although I do not know the proper Linux commands for this kind of job.

Piet de Keyser
Belgium

Van: Soraya Ferraz Lima <soyferrazlima at gmail.com>
Verzonden: dinsdag 12 mei 2020 18:09
Aan: Egbert De Smet <egbert.desmet at uantwerpen.be>
CC: Piet De Keyser <piet.dekeyser at ucll.be>; Lista Isis <isis-users at iccisis.org>
Onderwerp: Re: [Isis-users] Print report for multiple databases

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 at uantwerpen.be<mailto:egbert.desmet at 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 at ucll.be<mailto:piet.dekeyser at 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 at gmail.com<mailto:soyferrazlima at gmail.com>>
Verzonden: dinsdag 12 mei 2020 16:25
Aan: Egbert De Smet <egbert.desmet at uantwerpen.be<mailto:egbert.desmet at uantwerpen.be>>
CC: Piet De Keyser <piet.dekeyser at ucll.be<mailto:piet.dekeyser at ucll.be>>; Lista Isis <isis-users at iccisis.org<mailto:isis-users at 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 at uantwerpen.be<mailto:egbert.desmet at 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 at ucll.be<mailto:piet.dekeyser at 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 at iccisis.org<mailto:ucll.be at iccisis.org>> Namens Soraya Ferraz Lima
Verzonden: maandag 11 mei 2020 23:33
Aan: Egbert De Smet <egbert.desmet at uantwerpen.be<mailto:egbert.desmet at uantwerpen.be>>
CC: Lista Isis <isis-users at iccisis.org<mailto:isis-users at iccisis.org>>
Onderwerp: Re: [Isis-users] Print report for multiple databases

Hi Egbert!

Thanks for your reply.

I want to use this function

[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 at uantwerpen.be<mailto:egbert.desmet at 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 at iccisis.org<mailto:ua.ac.be at iccisis.org>> on behalf of Soraya Ferraz Lima <soyferrazlima at gmail.com<mailto:soyferrazlima at 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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20200512/fe2f547e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 9316 bytes
Desc: image001.png
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20200512/fe2f547e/attachment.png>