[CESG] [EXTERNAL] RID Database

Mon May 20 14:43:38 UTC 2019

I support the points made by Tom and Gippo about the need for us to encourage our agencies to do a better job of reviewing documents and producing RIDs.  It is really only through this sort of independent audit of the draft standards that we have the best chance to identify issues.

That said, and being mindful of the discussion we had in the recent CESG meeting, I do believe that there was very strong support for re-evaluating the use of a RID spreadsheet as the means to submit RIDs.  Several of us commented that the first thing we all do in processing RIDs in a paper or Word or PDF form is to do the tedious cut and paste of text from that page by page form into a spredsheet.  The reason for that is that a spreadsheet is just so much more convenient to work on, for the following reasons I can think of:

  1.  All inputs in one place
  2.  Possible to sort all of them based on document page and section
  3.  Easy to track which are resolved and which are open
  4.  Useful as a checklist to make document updates once resolution is reached

There are probably others as well.

I would strongly support using a simple spreadsheet as the input format for RIDs.  I think it is trivial to create, is no more work for the reviewers than the one RID per page format, works on all platforms, and makes the whole task easier.

Regards, Peter

From: CESG <cesg-bounces at mailman.ccsds.org> on behalf of Gian Paolo Calzolari <Gian.Paolo.Calzolari at esa.int>
Date: Monday, May 20, 2019 at 1:18 AM
To: CCSDS Engineering Steering Group - CESG Exec <cesg at mailman.ccsds.org>
Subject: Re: [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%20Example/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%20Example/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%20Example/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%20Example/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

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/0ef7e57a/attachment-0001.html>