<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
<!--
@font-face
{font-family:"Cambria Math"}
@font-face
{font-family:Calibri}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif}
a:link, span.MsoHyperlink
{color:#0563C1;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:#954F72;
text-decoration:underline}
p.msonormal0, li.msonormal0, div.msonormal0
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif}
span.E-mailStijl18
{font-family:"Calibri",sans-serif;
color:#1F497D}
.MsoChpDefault
{font-family:"Calibri",sans-serif}
@page WordSection1
{margin:70.85pt 70.85pt 70.85pt 70.85pt}
-->
</style><style type="text/css" id="owaParaStyle">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body fpstyle="1" ocsi="0" 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="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">Egbert de Smet<br>
Universiteit Antwerpen</div>
</span></font></div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div id="divRpF437099" style="direction: ltr;"><font size="2" color="#000000" face="Tahoma"><b>From:</b> isis-users [isis-users-bounces+egbert.desmet=ua.ac.be@iccisis.org] on behalf of Piet De Keyser [piet.dekeyser@ucll.be]<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="WordSection1">
<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:isis-users-bounces+piet.dekeyser=ucll.be@iccisis.org]
<b>Namens </b>Wenke Adam<br>
<b>Verzonden:</b> vrijdag 14 juli 2017 5:24<br>
<b>Aan:</b> Isis Comunidad <isis-users@iccisis.org><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..............................................^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">____________________________________________________________________________________________</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..............................................^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>
</body>
</html>