[CESG] [Secretariat] [EXTERNAL] RID Database

Mon May 20 14:18:18 UTC 2019

Dear Colleagues:

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.

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.

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.

My two cents, or plugged nickel, as the case may be,

Tom

Logothete, L.L.C.

thomas.gannett at tgannett.net

+1 443 472 0805

From: Secretariat [mailto:secretariat-bounces at mailman.ccsds.org] On Behalf
Of Gian.Paolo.Calzolari at esa.int
Sent: Monday, May 20, 2019 4:19 AM
To: CCSDS CESG --
Subject: Re: [Secretariat] [CESG] [EXTERNAL] RID Database

Dear All, 
        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. 
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. 
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. 

My cent....... 

Gippo 

From:        "Shames, Peter M \(312B\) via CESG" <cesg at mailman.ccsds.org> 
To:        "Colin.Haddow at esa.int" <Colin.Haddow at esa.int>,
"cesg at mailman.ccsds.org" <cesg at mailman.ccsds.org> 
Date:        17-05-19 19:37 
Subject:        Re: [CESG] [EXTERNAL]  RID Database 
Sent by:        "CESG" <cesg-bounces at mailman.ccsds.org> 

  _____  

Hi Colin,

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.

That's a lot of baggage to buy and support just to submit RIDs.

Thanks for try though.  

Peter

From: CESG <cesg-bounces at mailman.ccsds.org> on behalf of Colin Haddow
<Colin.Haddow at esa.int>
Date: Friday, May 17, 2019 at 7:37 AM
To: CCSDS Engineering Steering Group - CESG Exec <cesg at mailman.ccsds.org>
Subject: [EXTERNAL] [CESG] RID Database

Dear all, 
                 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; 

1.       Document Details Entry Form -        Used to enter the details of
the document(s) under review. 

2.       Reviewer Details Entry Form -         Used to enter details of the
reviewer(s) 

3.       RID Entry Form -                        Used to enter the RID
details 

4.       RID Review Form -                        Used to review the RIDs 

5.        

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. 

It is also possible to produce a a Word report of the RIDs from the database
using Words mail merge facility. 

In the upload there are 4 files; 

1.
<https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20E
xample/CCSDS%20RID%20Database.accdb>
https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Ex
ample/CCSDS%20RID%20Database.accdb -                                An empty
access database with the appropriate table, forms etc. 

2.
<https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20E
xample/CCSDS%20RID%20Database%20Report%20Template.docx>
https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Ex
ample/CCSDS%20RID%20Database%20Report%20Template.docx -        Word document
providing the template for the mail merge report. 

3.
<https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20E
xample/Example.accdb>
https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Ex
ample/Example.accdb -
An example populated database (data used to populate it comes from an old
Simple Schedule Red Review + some test data) 

4.
<https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20E
xample/Example%20RIDs%20Database%20Report.docx>
https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Ex
ample/Example%20RIDs%20Database%20Report.docx -                        An
example report generated via mail merge from the example database. 

5.        

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. 

Anyway if you're interested please take a look. 

Cheers for now, 

Colin 

----------------------------------------------------------------------------
-----------------------------
Dr. Colin R. Haddow,
HSO-GI, European Space Agency,
European Space Operations Centre,
Robert-Bosch-Str 5,
64293 Darmstadt,
Germany.

Phone; +49 6151 90 2896
Fax;      +49 6151 90 3010
E-Mail;  colin.haddow at esa.int
----------------------------------------------------------------------------
-----------------------------

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 at esa.int).

_______________________________________________
CESG mailing list
CESG at mailman.ccsds.org
 <https://mailman.ccsds.org/cgi-bin/mailman/listinfo/cesg>
https://mailman.ccsds.org/cgi-bin/mailman/listinfo/cesg

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 at esa.int).
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.ccsds.org/pipermail/cesg/attachments/20190520/0b5284db/attachment-0001.html>