<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
p.xxmsonormal, li.xxmsonormal, div.xxmsonormal
{mso-style-name:x_x_msonormal;
margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Christiana,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I was able to successfully create a traveler instantiation (#147).<o:p></o:p></p>
<p class="MsoNormal">It has CAVSN=5C75-RI-028.<o:p></o:p></p>
<p class="MsoNormal">At first I thought it was because you didn’t put the 5 before the C75 in the serial number (C75-RI-028), but that wasn’t it.<o:p></o:p></p>
<p class="MsoNormal">LOL.<o:p></o:p></p>
<p class="MsoNormal">Actually, the database system is on a Linux machine and it doesn’t like all the WINDOWS Text stuff.<o:p></o:p></p>
<p class="MsoNormal">You had some commas in your actions (do this, if needed) as an example.<o:p></o:p></p>
<p class="MsoNormal">The system saw this as an additional field.<o:p></o:p></p>
<p class="MsoNormal">We have similar issues with apostrophes and such.<o:p></o:p></p>
<p class="MsoNormal">I don’t have a “fix” for it yet, but if you avoid any special characters other than underscore and dash, you should be okay to go.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I can delete #147 if you don’t need it, or you can rename the CAVSN. Your choice.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Valerie<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Christiana Wilson <grenoble@jlab.org> <br>
<b>Sent:</b> Monday, September 18, 2023 12:41 PM<br>
<b>To:</b> Valerie Bookwalter <bookwalt@jlab.org><br>
<b>Subject:</b> Re: ER5C-PRCO-CAV Instantiation Page (dupplicate) <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Hi Valerie,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">I tried to use the tool to copy C75-RI-024 process to C75-RI-028 and first it through a generic error message that said error. The second attempt it through a large error which I copied below.
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Christiana<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">mod_user,mod_date,PROCTASKREQU,PROCTASKSUBDATE,CAVSN,ProcTask1center,ProcTask1Other,ProcTask1Instructions,ProcTask2center,ProcTask2Other,ProcTask2Instructions,ProcTask3center,ProcTask3Other,ProcTask3Instructions,ProcTask4center,ProcTask4Other,ProcTask4Instructions,ProcTask5center,ProcTask5Other,ProcTask5Instructions,ProcTask6center,ProcTask6Other,ProcTask6Instructions,ProcTask7center,ProcTask7Other,ProcTask7Instructions,ProcTask8center,ProcTask8Other,ProcTask8Instructions,ProcTask9center,ProcTask9Other,ProcTask9Instructions,ProcTask10center,ProcTask10Other,ProcTask10Instructions
<br>
'GRENOBLE',sysdate,'GRENOBLE',sysdate,'5C75-RI-028','Other','Process: Flash BCP and single cav test','','BCP','','5um BCP to reset the cavity.','USC','','single pass','LAP','','Flange lap, if needed.','BCP','','Flange BCP, if needed.','CMM','','Flange check','USC','','1st
liquinox2nd room temperature DI water','HPR','','Four pass with hot water.','ASSY','','','Other','VTA single cavity test.',''
<br>
Instantiaion successfully performed. <br>
Column Names: mod_user,mod_date,PROCTASKREQU,PROCTASKSUBDATE,CAVSN,ProcTask1center,ProcTask1Other,ProcTask1Instructions,ProcTask2center,ProcTask2Other,ProcTask2Instructions,ProcTask3center,ProcTask3Other,ProcTask3Instructions,ProcTask4center,ProcTask4Other,ProcTask4Instructions,ProcTask5center,ProcTask5Other,ProcTask5Instructions,ProcTask6center,ProcTask6Other,ProcTask6Instructions,ProcTask7center,ProcTask7Other,ProcTask7Instructions,ProcTask8center,ProcTask8Other,ProcTask8Instructions,ProcTask9center,ProcTask9Other,ProcTask9Instructions,ProcTask10center,ProcTask10Other,ProcTask10Instructions
<br>
Column Values: 'GRENOBLE',sysdate,'GRENOBLE',sysdate,'5C75-RI-028','Other','Process: Flash BCP and single cav test','','BCP','','5um BCP to reset the cavity.','USC','','single pass','LAP','','Flange lap, if needed.','BCP','','Flange BCP, if needed.','CMM','','Flange
check','USC','','1st liquinox2nd room temperature DI water','HPR','','Four pass with hot water.','ASSY','','','Other','VTA single cavity test.',''
<o:p></o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> Christiana Wilson <<a href="mailto:grenoble@jlab.org">grenoble@jlab.org</a>><br>
<b>Sent:</b> Tuesday, August 15, 2023 1:53 PM<br>
<b>To:</b> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Subject:</b> Re: ER5C-PRCO-CAV Instantiation Page (dupplicate) </span><o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Hi Valerie,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">I tried out the application this way.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">I selected C75-031 to copy fields into a new C75-021 process traveler. I was surprised to find the fields filled in from C75-031 #113. It is not the first or the last process traveler for this
cavity. I am not sure what the algorithm does, but I need it to copy the last closed traveler of the selected cavity number. Otherwise, I am very excited to use this new tool.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Thank you,<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Christiana<o:p></o:p></span></p>
</div>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="98%" align="center">
</div>
<div id="x_divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black"> Valerie Bookwalter <<a href="mailto:bookwalt@jlab.org">bookwalt@jlab.org</a>><br>
<b>Sent:</b> Monday, August 14, 2023 4:39 PM<br>
<b>To:</b> Christiana Wilson <<a href="mailto:grenoble@jlab.org">grenoble@jlab.org</a>><br>
<b>Cc:</b> pansophy <<a href="mailto:pansophy@jlab.org">pansophy@jlab.org</a>><br>
<b>Subject:</b> ER5C-PRCO-CAV Instantiation Page (dupplicate) </span><o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xxmsonormal">Christiana,<o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal">I created an ER5C-PROC-CAV Traveler Maker page for you.<o:p></o:p></p>
<p class="xxmsonormal">You can find it on the menu<o:p></o:p></p>
<p class="xxmsonormal">TRAVELERS MENU -> TRAVELER TOOLS -> ER5C PROC INST<o:p></o:p></p>
<p class="xxmsonormal">Or here’s a link<o:p></o:p></p>
<p class="xxmsonormal"><a href="https://pansophy.jlab.org/pansophy/Travelers/ER5C/Example_TravelerMaker.cfm">https://pansophy.jlab.org/pansophy/Travelers/ER5C/Example_TravelerMaker.cfm</a><o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal">Hopefully the instructions on the screen make sense, but here is a repeat…<o:p></o:p></p>
<p class="xxmsonormal">Select CAVSN from the blue area<o:p></o:p></p>
<p class="xxmsonormal">Hit submit in blue area<o:p></o:p></p>
<p class="xxmsonormal">The table below the yellow are will be filled with the tasks from the select CAVSN.<o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal">Now enter a newCAVSN in the red highlighted cell<o:p></o:p></p>
<p class="xxmsonormal">Adjust any other Process Tasks in the table<o:p></o:p></p>
<p class="xxmsonormal">And then hit SUBMIT at the bottom of the page.<o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal">This will generate a new instantiation of the ER5C-PROC-CAV traveler with that newCAVSN.<o:p></o:p></p>
<p class="xxmsonormal">You will see a bunch of strings on the final page, which is just debug information letting you know those values were sent to the database.<o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal">I will clean up after you validate it does what you need.<o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal">Let me know if you have any problems.<o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<p class="xxmsonormal"> <o:p></o:p></p>
<div>
<p class="xxmsonormal" style="background:white"><span style="font-size:14.0pt;color:#201F1E">Valerie Bookwalter</span><o:p></o:p></p>
<p class="xxmsonormal" style="background:white"><span style="font-size:14.0pt;color:#201F1E">Jefferson Lab, SRF Department</span><o:p></o:p></p>
<p class="xxmsonormal" style="background:white"><span style="font-size:14.0pt;color:#201F1E">Pansophy Team</span><o:p></o:p></p>
<p class="xxmsonormal" style="background:white"><span style="font-size:14.0pt;color:#201F1E">1-757-269-5802 (OFFICE – currently working offsite)</span><o:p></o:p></p>
</div>
<p class="xxmsonormal"> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>