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

Thu Sep 30 17:46:29 CEST 2021

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 em 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 em uantwerpen.be>
> *Verzonden:* woensdag 29 september 2021 16:07
> *Aan:* Soraya Ferraz Lima <soyferrazlima em gmail.com>; Piet De Keyser <
> piet.dekeyser em ucll.be>
> *CC:* Lista Isis <isis-users em 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 em iccisis.org>
> on behalf of Soraya Ferraz Lima <soyferrazlima em 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: 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 em 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 em iccisis.org>
> namens Daniel Motola <danymot2007 em gmail.com>
> *Verzonden:* woensdag 22 september 2021 11:54
> *Aan:* Soraya Ferraz Lima <soyferrazlima em gmail.com>
> *CC:* Lista Isis <isis-users em 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 em 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 em 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 em 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 em adinet.com.uy> escreveu:
>
> Usa  v245[1]
>
> Ernesto spinak
>
> El 14 sep. 2021 20:22, Soraya Ferraz Lima <soyferrazlima em 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 em 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 em iccisis.org
> To manage your own subscription options go to:
> http://lists.iccisis.org/listinfo/isis-users
> <https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Flists.iccisis.org%2Flistinfo%2Fisis-users&data=04%7C01%7C%7C4ae11c2a50274dec115708d98352854e%7Ce638861b15d94de6a65db48789ae1f08%7C0%7C0%7C637685212711698300%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=yjL3rjnwzaVdYuHhdhnk%2FhJ8%2Fe06nHam7%2B7GpNyo7QA%3D&reserved=0>
> Or contact Henk Rutten: hlrutten em xs4all.nl
>
>
-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20210930/8e077a52/attachment.html>
-------------- Próxima Parte ----------
Um anexo não-texto foi limpo...
Nome: image.png
Tipo: image/png
Tamanho: 21308 bytes
Descrição: não disponível
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20210930/8e077a52/attachment.png>