<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi all,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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.<br>
</div>
<div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div>Piet de Keyser</div>
<div>Belgium<br>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>Van:</b> Egbert De Smet <egbert.desmet@uantwerpen.be><br>
<b>Verzonden:</b> woensdag 29 september 2021 16:07<br>
<b>Aan:</b> Soraya Ferraz Lima <soyferrazlima@gmail.com>; Piet De Keyser <piet.dekeyser@ucll.be><br>
<b>CC:</b> Lista Isis <isis-users@iccisis.org><br>
<b>Onderwerp:</b> Re: [Isis-users] Ayuda con el formato de vista previa</font>
<div> </div>
</div>
<div dir="ltr">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<p style="margin-top: 0px; margin-bottom: 0px;">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.</p>
<p style="margin-top: 0px; margin-bottom: 0px;">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. </p>
<p style="margin-top: 0px; margin-bottom: 0px;"><br>
</p>
<div id="x_Signature">
<div class="x_BodyFragment"><font size="2"><span style="font-size:10pt">
<div class="x_PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<br>
<br>
<div style="color:rgb(0,0,0)">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>From:</b> isis-users <isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org> on behalf of Soraya Ferraz Lima <soyferrazlima@gmail.com><br>
<b>Sent:</b> Wednesday, September 29, 2021 3:44 PM<br>
<b>To:</b> Piet De Keyser<br>
<b>Cc:</b> Lista Isis<br>
<b>Subject:</b> Re: [Isis-users] Ayuda con el formato de vista previa</font>
<div> </div>
</div>
<div>
<p style="margin-top: 0px; margin-bottom: 0px;"></p>
<div style="background-color:#FFEB9C; width:100%; border-style:solid; border-color:#9C6500; border-width:1pt; padding:2pt; font-size:10pt; line-height:12pt; font-family:'Calibri'; color:Black; text-align:left">
<span style="color:#9C6500; font-weight:bold">CAUTION:</span> 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.</div>
<br>
<p style="margin-top: 0px; margin-bottom: 0px;"></p>
<div>
<div dir="ltr">
<div dir="ltr">HI all!
<div><br>
</div>
<div>I want to use this feature (reports)</div>
<div><img alt="image.png" style="" width="410" height="105" data-outlook-trace="F:1|T:1" src="cid:ii_ku5k2egg0"><br>
</div>
<div><br>
</div>
<div>and then export to a txt format. </div>
<div><br>
</div>
<div>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<br>
</div>
<div><br>
</div>
<div>Thanks for the help!</div>
<div><br>
</div>
</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">Em qui., 23 de set. de 2021 às 05:53, Piet De Keyser <<a href="mailto:piet.dekeyser@ucll.be">piet.dekeyser@ucll.be</a>> escreveu:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
Hi all,</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
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:</div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<ol>
<li><span>export everything to Excel</span></li><li><span>then use the Excel feature to find and remove duplicates<br>
</span></li></ol>
</div>
<div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_gmail-m_-2754850208913544124Signature">
<div>
<div>Piet de Keyser</div>
<div>Belgium<br>
</div>
</div>
</div>
</div>
<div id="x_gmail-m_-2754850208913544124appendonsend"></div>
<hr style="display:inline-block; width:98%">
<div id="x_gmail-m_-2754850208913544124divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" face="Calibri, sans-serif" color="#000000"><b>Van:</b> isis-users <isis-users-bounces+piet.dekeyser=<a href="mailto:ucll.be@iccisis.org" target="_blank">ucll.be@iccisis.org</a>>
namens Daniel Motola <<a href="mailto:danymot2007@gmail.com" target="_blank">danymot2007@gmail.com</a>><br>
<b>Verzonden:</b> woensdag 22 september 2021 11:54<br>
<b>Aan:</b> Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" target="_blank">soyferrazlima@gmail.com</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] Ayuda con el formato de vista previa</font>
<div> </div>
</div>
<div>
<p style="margin-top: 0px; margin-bottom: 0px;">Hi Soraya,</p>
<p style="margin-top: 0px; margin-bottom: 0px;">When you said you want to extract the data what do you want to do? Print the information? Export to Excel?</p>
<p style="margin-top: 0px; margin-bottom: 0px;">They are different options to do it.<br>
</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Regards,</p>
<p style="margin-top: 0px; margin-bottom: 0px;">Daniel<br>
</p>
<div>On 9/22/21 12:47 AM, Soraya Ferraz Lima wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hi Daniel!
<div><br>
</div>
<div>It's in ABCD v 2.2.</div>
<div>It's not an error, all the mfns are working properly. I just want to extract the data using a pft.</div>
<div><br>
</div>
<div>Thanks </div>
</div>
<br>
<div>
<div dir="ltr">Em qua., 22 de set. de 2021 às 01:05, Daniel <<a href="mailto:danymot2007@gmail.com" target="_blank">danymot2007@gmail.com</a>> escreveu:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="auto">Hi Soraya,
<div dir="auto"><br>
</div>
<div dir="auto">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.</div>
<div dir="auto"><br>
</div>
<div dir="auto">Regards</div>
<div dir="auto"><br>
</div>
<div dir="auto">Daniel</div>
</div>
<br>
<div>
<div dir="ltr">On Tue, Sep 21, 2021, 11:35 PM Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" target="_blank">soyferrazlima@gmail.com</a>> wrote:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">Hi all!
<div><br>
</div>
<div>Does someone know how to solve this?</div>
<div><br>
</div>
<div>
<div>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).</div>
<div><br>
</div>
<div>Is there a way to do this?</div>
<div><br>
</div>
<div>Thank you for your attention! </div>
</div>
<div><br>
</div>
</div>
</div>
</div>
<br>
<div>
<div dir="ltr">Em ter., 14 de set. de 2021 às 21:07, Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" rel="noreferrer" target="_blank">soyferrazlima@gmail.com</a>> escreveu:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">Não funciona pois são registros diferentes... Tenho 10 registros com 10 títulos iguais.
<div><br>
</div>
<div>Att,</div>
</div>
<br>
<div>
<div dir="ltr">Em ter., 14 de set. de 2021 às 20:33, Ernesto Spinak <<a href="mailto:spinaker@adinet.com.uy" rel="noreferrer" target="_blank">spinaker@adinet.com.uy</a>> escreveu:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="auto">Usa v245[1]
<div dir="auto"><br>
<div dir="auto">Ernesto spinak </div>
</div>
</div>
<div><br>
<div>El 14 sep. 2021 20:22, Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" rel="noreferrer" target="_blank">soyferrazlima@gmail.com</a>> escribió:<br type="attribution">
<blockquote style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div dir="ltr">-----</div>
<div dir="ltr">Em português
<div><br>
</div>
<div>
<div>Espero que todos os colegas estejam bem!</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Saberiam me dizer como deve ser esse formato?</div>
<div>Tentei utilizar if nocc(v245)=1 then ..., mas ai não me exibe nada já que o índice de ocorrências é maior que 1.</div>
<div><br>
</div>
<div>Agradeço a atenção!</div>
</div>
<div><br>
</div>
</div>
</div>
<br>
<div>
<div dir="ltr">Em ter., 14 de set. de 2021 às 20:05, Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" rel="noreferrer" target="_blank">soyferrazlima@gmail.com</a>> escreveu:<br>
</div>
<blockquote style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div>¡Espero que a todos los compañeros les vaya bien!</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>¿Podrías decirme cómo debería ser este formato?</div>
<div>Intenté usar if nocc (v245) = 1 entonces ..., pero luego no me muestra nada ya que la tasa de ocurrencia es mayor que 1.</div>
<div><br>
</div>
<div>¡Agradezco la atención!</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
</div>
</blockquote>
</div>
_______________________________________________<br>
isis-users mailing list<br>
<a href="mailto:isis-users@iccisis.org" rel="noreferrer" target="_blank">isis-users@iccisis.org</a><br>
To manage your own subscription options go to: <a href="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" originalsrc="http://lists.iccisis.org/listinfo/isis-users" shash="COxGWXJZPg0SLGLdVH7kJmAzKavKtyX8TbYjkkwsO0mCPwUEv2tOruduzl+OMayUPqKiOOHPGCYRmmSoHWbDqJEdW1oQGEZmIPmpH1DtdhDh2gkNzYDc3HkufntR6EC6IN1SJioyGHWWOcDF2Qo9LbbvAsvcmsX1bw8e19BTNks=" rel="noreferrer noreferrer" target="_blank">
http://lists.iccisis.org/listinfo/isis-users</a><br>
Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl" rel="noreferrer" target="_blank">
hlrutten@xs4all.nl</a><br>
</blockquote>
</div>
</blockquote>
</div>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>