<span style=" font-size:10pt;font-family:sans-serif">Tom,</span>
<br><span style=" font-size:10pt;font-family:sans-serif">
sorry but I cannot recall that kind of consensus
on excel and the MoMs statement I see says"It was agreed to re-assess
the RID tool based on excel, that was produced by David Ross, and discuss
its suitability at the mid-term Telecon."</span>
<br><span style=" font-size:10pt;font-family:sans-serif">Regards</span>
<br>
<br><span style=" font-size:10pt;font-family:sans-serif">Gian Paolo</span>
<br>
<br>
<br>
<br><span style=" font-size:9pt;color:#5f5f5f;font-family:sans-serif">From:
</span><span style=" font-size:9pt;font-family:sans-serif">"Thomas
Gannett" <thomas.gannett@tgannett.net></span>
<br><span style=" font-size:9pt;color:#5f5f5f;font-family:sans-serif">To:
</span><span style=" font-size:9pt;font-family:sans-serif"><Gian.Paolo.Calzolari@esa.int>,
"'CCSDS CESG --'" <cesg@mailman.ccsds.org></span>
<br><span style=" font-size:9pt;color:#5f5f5f;font-family:sans-serif">Date:
</span><span style=" font-size:9pt;font-family:sans-serif">20-05-19
16:18</span>
<br><span style=" font-size:9pt;color:#5f5f5f;font-family:sans-serif">Subject:
</span><span style=" font-size:9pt;font-family:sans-serif">RE:
[Secretariat] [CESG] [EXTERNAL] RID Database</span>
<br>
<hr noshade>
<br>
<br>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri">Dear
Colleagues:</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri">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.</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri">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.</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri">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.</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri">My
two cents, or plugged nickel, as the case may be,</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri">Tom</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:12pt;color:#004080;font-family:Times New Roman"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:12pt;color:#004080;font-family:Times New Roman">Logothete,
L.L.C.</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:12pt;color:#004080;font-family:Times New Roman">thomas.gannett@tgannett.net</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:12pt;color:#004080;font-family:Times New Roman">+1
443 472 0805</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;color:#004080;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Tahoma"><b>From:</b>
Secretariat [</span><a href="mailto:secretariat-bounces@mailman.ccsds.org"><span style=" font-size:10pt;font-family:Tahoma">mailto:secretariat-bounces@mailman.ccsds.org</span></a><span style=" font-size:10pt;font-family:Tahoma">]
<b>On Behalf Of </b>Gian.Paolo.Calzolari@esa.int<b><br>
Sent:</b> Monday, May 20, 2019 4:19 AM<b><br>
To:</b> CCSDS CESG --<b><br>
Subject:</b> Re: [Secretariat] [CESG] [EXTERNAL] RID Database</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:12pt;font-family:Times New Roman"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Arial">Dear
All,</span><span style=" font-size:12pt;font-family:Times New Roman"> </span><span style=" font-size:10pt;font-family:Arial"><br>
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><span style=" font-size:12pt;font-family:Times New Roman">
</span><span style=" font-size:10pt;font-family:Arial"><br>
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><span style=" font-size:12pt;font-family:Times New Roman">
</span><span style=" font-size:10pt;font-family:Arial"><br>
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><span style=" font-size:12pt;font-family:Times New Roman">
<br>
</span><span style=" font-size:10pt;font-family:Arial"><br>
My cent.......</span><span style=" font-size:12pt;font-family:Times New Roman">
<br>
</span><span style=" font-size:10pt;font-family:Arial"><br>
Gippo</span><span style=" font-size:12pt;font-family:Times New Roman">
<br>
<br>
<br>
</span><span style=" font-size:9pt;color:#5f5f5f;font-family:Arial"><br>
From: </span><span style=" font-size:9pt;font-family:Arial">"Shames,
Peter M \(312B\) via CESG" <cesg@mailman.ccsds.org></span><span style=" font-size:12pt;font-family:Times New Roman">
</span><span style=" font-size:9pt;color:#5f5f5f;font-family:Arial"><br>
To: </span><span style=" font-size:9pt;font-family:Arial">"Colin.Haddow@esa.int"
<Colin.Haddow@esa.int>, "cesg@mailman.ccsds.org" <cesg@mailman.ccsds.org></span><span style=" font-size:12pt;font-family:Times New Roman">
</span><span style=" font-size:9pt;color:#5f5f5f;font-family:Arial"><br>
Date: </span><span style=" font-size:9pt;font-family:Arial">17-05-19
19:37</span><span style=" font-size:12pt;font-family:Times New Roman">
</span><span style=" font-size:9pt;color:#5f5f5f;font-family:Arial"><br>
Subject: </span><span style=" font-size:9pt;font-family:Arial">Re:
[CESG] [EXTERNAL] RID Database</span><span style=" font-size:12pt;font-family:Times New Roman">
</span><span style=" font-size:9pt;color:#5f5f5f;font-family:Arial"><br>
Sent by: </span><span style=" font-size:9pt;font-family:Arial">"CESG"
<cesg-bounces@mailman.ccsds.org></span><span style=" font-size:12pt;font-family:Times New Roman">
</span></p>
<div align=center>
<hr noshade></div>
<p style="margin-top:0px;margin-Bottom:240px"><span style=" font-size:12pt;font-family:Times New Roman"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">Hi
Colin,</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">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></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">That's
a lot of baggage to buy and support just to submit RIDs.</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">Thanks
for try though. </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">Peter</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:12pt;font-family:Calibri"><b>From:
</b>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></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Arial">Dear
all,</span><span style=" font-size:11pt;font-family:Calibri"> </span><span style=" font-size:10pt;font-family:Arial"><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:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">1.
</span><span style=" font-size:10pt;font-family:Arial">Document
Details Entry Form - Used to enter the details
of the document(s) under review.</span><span style=" font-size:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">2.
</span><span style=" font-size:10pt;font-family:Arial">Reviewer
Details Entry Form - Used to enter details
of the reviewer(s)</span><span style=" font-size:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">3.
</span><span style=" font-size:10pt;font-family:Arial">RID
Entry Form -
Used to enter the RID details</span><span style=" font-size:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">4.
</span><span style=" font-size:10pt;font-family:Arial">RID
Review Form -
Used to review the RIDs</span><span style=" font-size:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">5.
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Arial">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. <br>
<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:11pt;font-family:Calibri">
</span><span style=" font-size:10pt;font-family:Arial"><br>
<br>
In the upload there are 4 files;</span><span style=" font-size:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">1.
</span><a href=https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database.accdb><span style=" font-size:10pt;color:blue;font-family:Arial"><u>https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database.accdb</u></span></a><span style=" font-size:10pt;font-family:Arial">
-
An empty access database with
the appropriate table, forms etc.</span><span style=" font-size:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">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:10pt;color:blue;font-family:Arial"><u>https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database%20Report%20Template.docx</u></span></a><span style=" font-size:10pt;color:blue;font-family:Arial">
- </span><span style=" font-size:10pt;font-family:Arial">Word
document providing the template for the mail merge report.</span><span style=" font-size:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">3.
</span><a href=https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example.accdb><span style=" font-size:10pt;color:blue;font-family:Arial"><u>https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example.accdb</u></span></a><span style=" font-size:10pt;font-family:Arial">
-
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:11pt;font-family:Calibri">
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">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:10pt;color:blue;font-family:Arial"><u>https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example%20RIDs%20Database%20Report.docx</u></span></a><span style=" font-size:10pt;font-family:Arial">
-
An example report generated via mail merge from the example
database.</span><span style=" font-size:11pt;font-family:Calibri"> </span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:11pt;font-family:Calibri">5.
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Arial">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:11pt;font-family:Calibri">
</span><span style=" font-size:10pt;font-family:Arial"><br>
<br>
Anyway if you're interested please take a look.</span><span style=" font-size:11pt;font-family:Calibri">
</span><span style=" font-size:10pt;font-family:Arial"><br>
<br>
Cheers for now,</span><span style=" font-size:11pt;font-family:Calibri">
</span><span style=" font-size:10pt;font-family:Arial"><br>
<br>
Colin</span><span style=" font-size:11pt;font-family:Calibri"> </span><span style=" font-size:10pt;font-family:Arial"><br>
<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></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Courier New">This
message is intended only for the recipient(s) named above. It may contain
proprietary information and/or</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Courier New">protected
content. Any unauthorised disclosure, use, retention or dissemination is
prohibited. If you have received</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Courier New">this
e-mail in error, please notify the sender immediately. ESA applies appropriate
organisational measures to protect</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Courier New">personal
data, in case of data privacy queries, please contact the ESA Data Protection
Officer (dpo@esa.int).</span></p>
<p style="margin-top:0px;margin-Bottom:240px"><span style=" font-size:10pt;font-family:Courier New"><br>
_______________________________________________<br>
CESG mailing list<br>
CESG@mailman.ccsds.org</span><span style=" font-size:12pt;color:blue;font-family:Times New Roman"><u><br>
</u></span><a href="https://mailman.ccsds.org/cgi-bin/mailman/listinfo/cesg"><span style=" font-size:10pt;color:blue;font-family:Courier New"><u>https://mailman.ccsds.org/cgi-bin/mailman/listinfo/cesg</u></span></a><span style=" font-size:10pt;font-family:Courier New"><br>
</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Courier New">This
message is intended only for the recipient(s) named above. It may contain
proprietary information and/or</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Courier New">protected
content. Any unauthorised disclosure, use, retention or dissemination is
prohibited. If you have received</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Courier New">this
e-mail in error, please notify the sender immediately. ESA applies appropriate
organisational measures to protect</span></p>
<p style="margin-top:0px;margin-Bottom:0px"><span style=" font-size:10pt;font-family:Courier New">personal
data, in case of data privacy queries, please contact the ESA Data Protection
Officer (dpo@esa.int).</span></p>
<p style="margin-top:0px;margin-Bottom:0px"></p>
<p style="margin-top:0px;margin-Bottom:0px"></p><PRE>This message is intended only for the recipient(s) named above. It may contain proprietary information and/or
protected content. Any unauthorised disclosure, use, retention or dissemination is prohibited. If you have received
this e-mail in error, please notify the sender immediately. ESA applies appropriate organisational measures to protect
personal data, in case of data privacy queries, please contact the ESA Data Protection Officer (dpo@esa.int).
</PRE>