[Isis-users] Ayuda con el formato de vista previa

Thu Sep 30 18:35:03 CEST 2021

Yes, that is a very smart solution, using little known Formatting Language statements like getenv() and putenv().

For users who don't know the 'environment variables' : that is a memory area reserved by the Operating System to store, in 'key-value' pairs, certain strings like path-names etc. to be accessed from and exchanged with executables.

In this case an environment variable is created with the 'key' TITLE= and for each record the title is temporarily stored (until the next MFN is processed) in that variable. So when ISIS takes the next title, the previous one is still available for comparison, which would not be the case if not using some external-to-ISIS memory space : for each MFN all variables from fields are reset.

Then only if there is a new title (<>v245^a) the output is produced, resulting in a list of only different titles.

Good job, Soraya.

Egbert de Smet
Universiteit Antwerpen

P.S. Piet De Keyser's suggestion to re-organize such a database however, in my view, remains recommendable. There are ways to do so automatically, using similar techniques : produce a tagged-text output with all the records, but only print the record-separator when the title is different, if the title is the same only increment a counter ('no. of copies') which is stored in an environment variable and finally in the record. Then use the id2i utility to create your new database from that text-file.

________________________________
From: Soraya Ferraz Lima <soyferrazlima at gmail.com>
Sent: Thursday, September 30, 2021 5:46 PM
To: Piet De Keyser
Cc: Egbert De Smet; Lista Isis
Subject: Re: [Isis-users] Ayuda con el formato de vista previa

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

Hi guys!

Egbert, I tried using ref(l, but it still didn't work.

Piet, I had thought of changing the base structure, but the option to generate the automatic control number (auto increment in FDT) is being used and from what I have tested, this function cannot be used in a repetitive field =/

For feedback, I achieved the goal using the putenv getenv function, like this:
if getenv('TITLE')<>v245^a then
v245^a,'<br/>',(v100^a+| / ),
putenv('TITLE='v245^a),fi,

Thank you very much for your attention!
Take care!

Em qua., 29 de set. de 2021 às 11:14, Piet De Keyser <piet.dekeyser at ucll.be<mailto:piet.dekeyser at ucll.be>> escreveu:
Hi all,

Maybe the best way to handle this situation is to restructure the database in order to get only one record for each unique title. You could store the information of the number of copies, the call numbers etc. in one field that record or use a configuration where you store that information in the copies and loanobjects database.

Piet de Keyser
Belgium

________________________________
Van: Egbert De Smet <egbert.desmet at uantwerpen.be<mailto:egbert.desmet at uantwerpen.be>>
Verzonden: woensdag 29 september 2021 16:07
Aan: Soraya Ferraz Lima <soyferrazlima at gmail.com<mailto:soyferrazlima at gmail.com>>; Piet De Keyser <piet.dekeyser at ucll.be<mailto:piet.dekeyser at ucll.be>>
CC: Lista Isis <isis-users at iccisis.org<mailto:isis-users at iccisis.org>>
Onderwerp: Re: [Isis-users] Ayuda con el formato de vista previa

Can't you use a REF(L()) within the same database, since the L-function will only result in the first hit ? Just an idea.

Having some sample records available (e.g. as an ISO2709 export) would allow testing such ideas, whereas creating sample-sets with your rather unconventional situation is cumbersome.

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: Wednesday, September 29, 2021 3:44 PM
To: Piet De Keyser
Cc: Lista Isis
Subject: Re: [Isis-users] Ayuda con el formato de vista previa

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

HI all!

I want to use this feature (reports)
[image.png]

and then export to a txt format.

Exporting to Excel is an alternative, but I would like to make the format ready for the user to not have the trouble of opening the file and removing the duplicates, as this can lead to errors

Thanks for the help!

Em qui., 23 de set. de 2021 às 05:53, Piet De Keyser <piet.dekeyser at ucll.be<mailto:piet.dekeyser at ucll.be>> escreveu:
Hi all,

It seems to me that the problem here is not so much how to export to Excel, but how to export only the first of 10 equal records. Maybe the easiest sollution is:

  1.  export everything to Excel
  2.  then use the Excel feature to find and remove duplicates

Piet de Keyser
Belgium
________________________________
Van: isis-users <isis-users-bounces+piet.dekeyser=ucll.be at iccisis.org<mailto:ucll.be at iccisis.org>> namens Daniel Motola <danymot2007 at gmail.com<mailto:danymot2007 at gmail.com>>
Verzonden: woensdag 22 september 2021 11:54
Aan: Soraya Ferraz Lima <soyferrazlima at gmail.com<mailto:soyferrazlima at gmail.com>>
CC: Lista Isis <isis-users at iccisis.org<mailto:isis-users at iccisis.org>>
Onderwerp: Re: [Isis-users] Ayuda con el formato de vista previa

Hi Soraya,

When you said you want to extract the data what do you want to do? Print the information? Export to Excel?

They are different options to do it.

Regards,

Daniel

On 9/22/21 12:47 AM, Soraya Ferraz Lima wrote:
Hi Daniel!

It's in ABCD v 2.2.
It's not an error, all the mfns are working properly. I just want to extract the data using a pft.

Thanks

Em qua., 22 de set. de 2021 às 01:05, Daniel <danymot2007 at gmail.com<mailto:danymot2007 at gmail.com>> escreveu:
Hi Soraya,

It's in ABCD? Or winisis? In any case do a full invertion of the index of the database. If this does not fix the problem, recreate a new record and delete the previous one.

Regards

Daniel

On Tue, Sep 21, 2021, 11:35 PM Soraya Ferraz Lima <soyferrazlima at gmail.com<mailto:soyferrazlima at gmail.com>> wrote:
Hi all!

Does someone know how to solve this?

In my book database, I have 10 copies of the same book, each one in one record (mfn 1, mfn 2, ...) but in the report I would like to display/export in Excel, only the data of the first record (since they are all the same).

Is there a way to do this?

Thank you for your attention!

Em ter., 14 de set. de 2021 às 21:07, Soraya Ferraz Lima <soyferrazlima at gmail.com<mailto:soyferrazlima at gmail.com>> escreveu:
Não funciona pois são registros diferentes... Tenho 10 registros com 10 títulos iguais.

Att,

Em ter., 14 de set. de 2021 às 20:33, Ernesto Spinak <spinaker at adinet.com.uy<mailto:spinaker at adinet.com.uy>> escreveu:
Usa  v245[1]

Ernesto spinak

El 14 sep. 2021 20:22, Soraya Ferraz Lima <soyferrazlima at gmail.com<mailto:soyferrazlima at gmail.com>> escribió:
-----
Em português

Espero que todos os colegas estejam bem!

Em minha base de livros, tenho 10 exemplares do mesmo livro, porém no relatório gostaria de exibir/exportar no Excel, somente o primeiro.

Saberiam me dizer como deve ser esse formato?
Tentei utilizar if nocc(v245)=1 then ..., mas ai não me exibe nada já que o índice de ocorrências é maior que 1.

Agradeço a atenção!

Em ter., 14 de set. de 2021 às 20:05, Soraya Ferraz Lima <soyferrazlima at gmail.com<mailto:soyferrazlima at gmail.com>> escreveu:
¡Espero que a todos los compañeros les vaya bien!

En mi base de libros, tengo 10 copias del mismo libro, pero en el informe me gustaría mostrar / exportar en Excel, solo el primero.

¿Podrías decirme cómo debería ser este formato?
Intenté usar if nocc (v245) = 1 entonces ..., pero luego no me muestra nada ya que la tasa de ocurrencia es mayor que 1.

¡Agradezco la atención!

_______________________________________________
isis-users mailing list
isis-users at iccisis.org<mailto:isis-users at iccisis.org>
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users<https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.iccisis.org%2Flistinfo%2Fisis-users&data=04%7C01%7Cegbert.desmet%40uantwerpen.be%7C75e874f2cfce4db6423208d984297fc0%7C792e08fb2d544a8eaf72202548136ef6%7C0%7C0%7C637686136601955464%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=SwMKGcNPP3YkR533b1KXQP57opk%2F6T7in1ff0bjRtmA%3D&reserved=0>
Or contact Henk Rutten: hlrutten at xs4all.nl<mailto:hlrutten at xs4all.nl>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20210930/439ff285/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 21308 bytes
Desc: image.png
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20210930/439ff285/attachment.png>