<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 id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr">
<p>Yes, that is a very smart solution, using little known Formatting Language statements like getenv() and putenv().</p>
<p>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.</p>
<p>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. </p>
<p>Then only if there is a new title (<span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;"><>v245^a) the output is produced,
resulting in a list of only different titles. </span></p>
<p><span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;">Good job, Soraya. </span></p>
<p><span style="font-family: Calibri, Helvetica, sans-serif, EmojiFont, "Apple Color Emoji", "Segoe UI Emoji", NotoColorEmoji, "Segoe UI Symbol", "Android Emoji", EmojiSymbols; font-size: 16px;"><br>
</span></p>
<div id="Signature">
<div class="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
<div class="PlainText"><br>
</div>
<div class="PlainText">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. </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="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Soraya Ferraz Lima <soyferrazlima@gmail.com><br>
<b>Sent:</b> Thursday, September 30, 2021 5:46 PM<br>
<b>To:</b> Piet De Keyser<br>
<b>Cc:</b> Egbert De Smet; Lista Isis<br>
<b>Subject:</b> Re: [Isis-users] Ayuda con el formato de vista previa</font>
<div> </div>
</div>
<div>
<p></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></p>
<div>
<div dir="ltr">
<div dir="ltr">
<div>Hi guys!</div>
<div><br>
</div>
<div>Egbert, I tried using ref(l, but it still didn't work.</div>
<div><br>
</div>
<div>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 =/</div>
<div><br>
</div>
<div>For feedback, I achieved the goal using the putenv getenv function, like this:</div>
</div>
<blockquote style="margin:0 0 0 40px; border:none; padding:0px">
<div>
<div>if getenv('TITLE')<>v245^a then</div>
</div>
<div>
<div>v245^a,'<br/>',(v100^a+| / ),</div>
</div>
<div>
<div>putenv('TITLE='v245^a),fi,</div>
</div>
</blockquote>
<div dir="ltr">
<div><br>
</div>
<div>Thank you very much for your attention!</div>
<div>Take care!</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Em qua., 29 de set. de 2021 às 11:14, Piet De Keyser <<a href="mailto:piet.dekeyser@ucll.be">piet.dekeyser@ucll.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 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="gmail-m_285328738894057342Signature">
<div>
<div>Piet de Keyser</div>
<div>Belgium<br>
</div>
</div>
</div>
</div>
<div id="gmail-m_285328738894057342appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr style="display:inline-block; width:98%">
<div id="gmail-m_285328738894057342divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>Van:</b> Egbert De Smet <<a href="mailto:egbert.desmet@uantwerpen.be" target="_blank">egbert.desmet@uantwerpen.be</a>><br>
<b>Verzonden:</b> woensdag 29 september 2021 16:07<br>
<b>Aan:</b> Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" target="_blank">soyferrazlima@gmail.com</a>>; Piet De Keyser <<a href="mailto:piet.dekeyser@ucll.be" target="_blank">piet.dekeyser@ucll.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] Ayuda con el formato de vista previa</font>
<div> </div>
</div>
<div dir="ltr">
<div id="gmail-m_285328738894057342x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:rgb(0,0,0); 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="gmail-m_285328738894057342x_Signature">
<div><font size="2"><span style="font-size:10pt">
<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_285328738894057342x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> isis-users <isis-users-bounces+egbert.desmet=<a href="mailto:ua.ac.be@iccisis.org" target="_blank">ua.ac.be@iccisis.org</a>>
on behalf of Soraya Ferraz Lima <<a href="mailto:soyferrazlima@gmail.com" target="_blank">soyferrazlima@gmail.com</a>><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:rgb(255,235,156); width:100%; border-style:solid; border-color:rgb(156,101,0); border-width:1pt; padding:2pt; font-size:10pt; line-height:12pt; font-family:Calibri; color:black; text-align:left">
<span style="color:rgb(156,101,0); 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 naturalheight="297" naturalwidth="1158" alt="image.png" width="410" height="105" style="user-select: none;" src="cid:17c3761f01ecb971f161"><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>
<div dir="ltr">Em qui., 23 de set. de 2021 às 05:53, Piet De Keyser <<a href="mailto:piet.dekeyser@ucll.be" target="_blank">piet.dekeyser@ucll.be</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 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="gmail-m_285328738894057342x_gmail-m_-2754850208913544124Signature">
<div>
<div>Piet de Keyser</div>
<div>Belgium<br>
</div>
</div>
</div>
</div>
<div id="gmail-m_285328738894057342x_gmail-m_-2754850208913544124appendonsend"></div>
<hr style="display:inline-block; width:98%">
<div id="gmail-m_285328738894057342x_gmail-m_-2754850208913544124divRplyFwdMsg" dir="ltr">
<font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><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://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" 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>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</body>
</html>