<div dir="auto">Thank you, Egbert, for the detailed answer. I think the authority database is the best solution. Actually, the data in the picklist come from a database dedicated to maintain the list! It has 130 records with 7 fields, and will grow very slowly if at all. New software, new thinking.<div dir="auto"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">El 14 jul. 2017 5:47 AM, "De Smet Egbert" <<a href="mailto:egbert.desmet@uantwerpen.be">egbert.desmet@uantwerpen.be</a>> escribió:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div vlink="#954F72" link="#0563C1" lang="NL-BE">
<div style="direction:ltr;font-family:Tahoma;color:#000000;font-size:10pt">Wenke,<br>
<br>
I am afraid the data-entry script at this moment always will put the first column of a picklist in subfield a and the second column in subfield b. See e.g. the picklist for 'user type' in the demo users-database.<br>
<br>
But there is a solution. In fact with 130 options I would suggest it anyway : use an authority database instead of a picklist. In this case you have to put the value of your 1st column in v1 and the column 2 code in v2. Then you can use 'list as' and 'extract
as' in the FDT to define the picklist behavior : list as becomes 'v2' and extract as 'v1'.<br>
With mx you can even convert the existing text-file which serves as your picklist to such database in one run :
<br>
mx seq=picklist.txt create=picklist now -all<br>
supposing your picklist-file is named 'picklist.txt' and your picklist-database is also named 'picklist' - so change whatever you need to.<br>
Then in your FDT use a database as picklist-type and put the 'list as' and 'extract as' values.<br>
<br>
If you want to stick to the text-based picklist type, you just have to accept the two forced subfields, deal with the existing tricks to manage repeatable subfields and use the PFT-techniques to show/extract what you need. I think the database-approach is more
practical.<br>
<br>
I hope this helps.<br>
<div><br>
<div class="m_8324085917640705979BodyFragment"><font size="2"><span style="font-size:10pt">
<div class="m_8324085917640705979PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<div style="font-family:Times New Roman;color:#000000;font-size:16px">
<hr>
<div id="m_8324085917640705979divRpF437099" style="direction:ltr"><font size="2" color="#000000" face="Tahoma"><b>From:</b> isis-users [isis-users-bounces+egbert.<wbr>desmet=<a href="mailto:ua.ac.be@iccisis.org" target="_blank">ua.ac.be@iccisis.org</a>] on behalf of Piet De Keyser [<a href="mailto:piet.dekeyser@ucll.be" target="_blank">piet.dekeyser@ucll.be</a>]<br>
<b>Sent:</b> Friday, July 14, 2017 10:00 AM<br>
<b>To:</b> Wenke Adam; Isis Comunidad<br>
<b>Subject:</b> Re: [Isis-users] Picklists en ABCD 1.5<br>
</font><br>
</div>
<div></div>
<div>
<div class="m_8324085917640705979WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Wenke,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US">What is your extraction fromat fort his picklist?</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US">Piet</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d" lang="EN-US"> </span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="NL">Van:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif" lang="NL"> isis-users [mailto:<a href="mailto:isis-users-bounces%2Bpiet.dekeyser" target="_blank">isis-users-bounces+<wbr>piet.dekeyser</a>=<a href="mailto:ucll.be@iccisis.org" target="_blank">ucll.be@iccisis.<wbr>org</a>]
<b>Namens </b>Wenke Adam<br>
<b>Verzonden:</b> vrijdag 14 juli 2017 5:24<br>
<b>Aan:</b> Isis Comunidad <<a href="mailto:isis-users@iccisis.org" target="_blank">isis-users@iccisis.org</a>><br>
<b>Onderwerp:</b> [Isis-users] Picklists en ABCD 1.5</span></p>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal">Necesito usar una picklist con 130 opciones (filas) para un campo que contiene 7 subcampos, abcdklm.</p>
<div>
<p class="MsoNormal">En Winisis hacía esto colocando en 1 linea el texto que el operador vería y en la 2ª línea el string completo con los 7 subcampos.</p>
</div>
<div>
<p class="MsoNormal">En el registro quedaba el string completo.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Traté de convertir esto al formato usado por ABCD, de la siguiente forma:</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">^aTextoA ^bTextoB ^cTextoC ^dTextoD ^kTextoK ^lTextoL ^mTextoM | Texto para visualizar (todo sin espacios, solo los puse para facilitar lectura)</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">entendiendo que el string "^a........^m..." correspondería a la columna 'Código' y el "Texto para visualizar" correspondería al 'Término' en la tabla de la picklist.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">En el editor de picklists estas dos columnas aparecen correctamente, pero en el registro queda grabado como:</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt">^a</span></b> ^aTextoA......................<wbr>........................^<wbr>mTextoM
<b><span style="font-size:13.5pt">^b</span></b> Texto para visualizar</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Alguna manera de corregir esto, o una solución diferente?</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Declaré el campo como Campo con los 7 subcampos, porque en la FST y en las PFTs necesito visualizar los subcampos por separado, pero para el ingreso de datos interesa ingresar los 7 subcampos como un solo string.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Declarando el campo como Grupo, la ventanilla de selección no aparecía.</p>
</div>
<div>
<p class="MsoNormal">______________________________<wbr>______________________________<wbr>______________________________<wbr>__</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Dear friends:</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">I need to use a picklist with 130 options (rows) for a field with 7 subfields.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">In Winisis I did this with a list where the first row contained the text the operator would see when picking, and the next row contained the complete string with the 7 subfields.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">I tried to convert this to the picklist table format ABCD uses, like follows:</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">^aTextoA ^bTextoB ^cTextoC ^dTextoD ^kTextoK ^lTextoL ^mTextoM | Text to view (without spaces between subfields and pipe)</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">as I understood the text string with the subfields would correspond to the 'Code' column and the "Text to view" would be the 'Term' column. </p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">In the picklist editor everything looks fine, but when I select one item it turns up on the field as</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt">^a</span></b> ^aTextoA...................<wbr>...........................^<wbr>mTextoM <b><span style="font-size:13.5pt">^b</span></b> Text to view.</p>
</div>
<div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Is there a way to correct this, or a different solution for this case?</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">I declared the field as a Field type, with the 7 subfields, because in the FST and PFTs I need to be able to handle the subfields independently, but for dataentry it is best to enter the complete string ^a.........^m in one go.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">When I declared the field as a Group, the picklist window didn´t come up.</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Regards</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<div>
<p class="MsoNormal">Wenke</p>
</div>
<div>
<p class="MsoNormal"> </p>
</div>
<p class="MsoNormal">-- </p>
<div>
<p class="MsoNormal">Wenke Adam<br>
Asesora Sistemas de Doc & Inf<br>
Santiago</p>
<div>
<p class="MsoNormal">Chile</p>
</div>
<div>
<p class="MsoNormal">Cel: +56-9-890 21 630</p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote></div></div>