<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 14 (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:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas","serif";}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@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=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Dear Colleagues:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>At the CESG meeting in Mountain View, there was consensus that RID packages should be delivered to the top-level CCSDS review coordinator in Excel format.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Beyond that, CCSDS agencies (not the CCSDS, not the Secretariat, not the CESG) are responsible for conducting reviews. How agencies choose to conduct their reviews is their business. More importantly, tools/formats/ restrictions related to how agency reviewers are allowed to input RIDs are matters for each agency to determine; the only requirement at the CCSDS level is that the agency-approved RID packages be delivered in Excel format.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I personally think the CESG may have better things to do than endlessly debate the input format for RIDs, but I can only offer my opinion.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>My two cents, or plugged nickel, as the case may be,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Tom<o:p></o:p></span></p><div style='mso-element:para-border-div;border:none;border-bottom:solid windowtext 1.0pt;padding:0in 0in 1.0pt 0in'><p class=MsoNormal style='border:none;padding:0in'><span style='color:#1F497D'><o:p> </o:p></span></p></div><p class=MsoNormal><span style='color:#1F497D'>Logothete, L.L.C.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>thomas.gannett@tgannett.net<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>+1 443 472 0805<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Secretariat [mailto:secretariat-bounces@mailman.ccsds.org] <b>On Behalf Of </b>Gian.Paolo.Calzolari@esa.int<br><b>Sent:</b> Monday, May 20, 2019 4:19 AM<br><b>To:</b> CCSDS CESG --<br><b>Subject:</b> Re: [Secretariat] [CESG] [EXTERNAL] RID Database<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Dear All,</span> <br><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> I confirm my opinion in keeping the simplest possible approach to favour anybody to enter RIDs: i.e. the simple text/winword form with plenty of editing possibilities.</span> <br><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Just based on experience the problem is not having a sophisticated tool to manage RIDs but rather to promote review among Agencies with proper processes.</span> <br><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>In other words, more than spending time/resources in access, excel, RIDzilla,MyBestWayForDoingRIDs, RIDuberAlles, etc I would push up the issue to MC for having proper Agency feedback for reviews.</span> <br><br><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>My cent.......</span> <br><br><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Gippo</span> <br><br><br><br><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#5F5F5F'>From: </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>"Shames, Peter M \(312B\) via CESG" <cesg@mailman.ccsds.org></span> <br><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#5F5F5F'>To: </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>"Colin.Haddow@esa.int" <Colin.Haddow@esa.int>, "cesg@mailman.ccsds.org" <cesg@mailman.ccsds.org></span> <br><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#5F5F5F'>Date: </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>17-05-19 19:37</span> <br><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#5F5F5F'>Subject: </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>Re: [CESG] [EXTERNAL] RID Database</span> <br><span style='font-size:9.0pt;font-family:"Arial","sans-serif";color:#5F5F5F'>Sent by: </span><span style='font-size:9.0pt;font-family:"Arial","sans-serif"'>"CESG" <cesg-bounces@mailman.ccsds.org></span> <o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" noshade style='color:#A0A0A0' align=center></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Hi Colin,</span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Umm. Not to throw too much water on this, but for those of us with Macs (most of JPL uses Macs and Mac OSX), this is not in any way functional. When I try to open it I get a message saying I need to have installed Parallels, a VM that supports Windows, and then, of course, Windows itself, and then, of course, the whole Windows Office suite that includes Access. </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>That's a lot of baggage to buy and support just to submit RIDs.</span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Thanks for try though. </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Peter</span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><b><span style='font-family:"Calibri","sans-serif"'>From: </span></b><span style='font-family:"Calibri","sans-serif"'>CESG <cesg-bounces@mailman.ccsds.org> on behalf of Colin Haddow <Colin.Haddow@esa.int><b><br>Date: </b>Friday, May 17, 2019 at 7:37 AM<b><br>To: </b>CCSDS Engineering Steering Group - CESG Exec <cesg@mailman.ccsds.org><b><br>Subject: </b>[EXTERNAL] [CESG] RID Database</span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Dear all,</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br> I am aware that the decision at the Mountain View Meeting with respect to the CCSDS RID database was to use an Excel based approach. However after having spent a little time on it I've uploaded an MS Access based database that could be used. This contained 4 forms;</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>1. </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Document Details Entry Form - Used to enter the details of the document(s) under review.</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>2. </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Reviewer Details Entry Form - Used to enter details of the reviewer(s)</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>3. </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>RID Entry Form - Used to enter the RID details</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>4. </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>RID Review Form - Used to review the RIDs</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>5. </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>The fields in the RID forms correspond pretty much to the existing CCSDS text based form with the addition of 2 fields, 1 for attachments and 1 to indicate which other RIDs the RID may be related to. </span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><br></span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>It is also possible to produce a a Word report of the RIDs from the database using Words mail merge facility.</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <br></span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>In the upload there are 4 files;</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>1. </span><a href="https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database.accdb"><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database.accdb</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> - An empty access database with the appropriate table, forms etc.</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>2. </span><a href="https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database%20Report%20Template.docx"><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database%20Report%20Template.docx</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue'> - </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Word document providing the template for the mail merge report.</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>3. </span><a href="https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example.accdb"><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example.accdb</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> - An example populated database (data used to populate it comes from an old Simple Schedule Red Review + some test data)</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>4. </span><a href="https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example%20RIDs%20Database%20Report.docx"><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example%20RIDs%20Database%20Report.docx</span></a><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> - An example report generated via mail merge from the example database.</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>5. </span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>The above was nailed together quite quickly and I won't claim its totally bullet proof but I think it covers pretty much all that's needed.</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <br></span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>Anyway if you're interested please take a look.</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <br></span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>Cheers for now,</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <br></span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>Colin</span><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'> <br></span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br><br><br>---------------------------------------------------------------------------------------------------------<br>Dr. Colin R. Haddow,<br>HSO-GI, European Space Agency,<br>European Space Operations Centre,<br>Robert-Bosch-Str 5,<br>64293 Darmstadt,<br>Germany.<br><br>Phone; +49 6151 90 2896<br>Fax; +49 6151 90 3010<br>E-Mail; colin.haddow@esa.int<br>---------------------------------------------------------------------------------------------------------</span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Courier New"'>This message is intended only for the recipient(s) named above. It may contain proprietary information and/or</span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Courier New"'>protected content. Any unauthorised disclosure, use, retention or dissemination is prohibited. If you have received</span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Courier New"'>this e-mail in error, please notify the sender immediately. ESA applies appropriate organisational measures to protect</span><o:p></o:p></p><p style='margin:0in;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Courier New"'>personal data, in case of data privacy queries, please contact the ESA Data Protection Officer (dpo@esa.int).</span><o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><br><tt><span style='font-size:10.0pt'>_______________________________________________</span></tt><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>CESG mailing list</tt><br><tt>CESG@mailman.ccsds.org</tt><br></span><a href="https://mailman.ccsds.org/cgi-bin/mailman/listinfo/cesg"><tt><span style='font-size:10.0pt'>https://mailman.ccsds.org/cgi-bin/mailman/listinfo/cesg</span></tt></a><span style='font-size:10.0pt;font-family:"Courier New"'><br><br></span><o:p></o:p></p><pre>This message is intended only for the recipient(s) named above. It may contain proprietary information and/or<o:p></o:p></pre><pre>protected content. Any unauthorised disclosure, use, retention or dissemination is prohibited. If you have received<o:p></o:p></pre><pre>this e-mail in error, please notify the sender immediately. ESA applies appropriate organisational measures to protect<o:p></o:p></pre><pre>personal data, in case of data privacy queries, please contact the ESA Data Protection Officer (dpo@esa.int).<o:p></o:p></pre></div></body></html>