Updates on the OpenChain certification website


Gary O'Neall
 

Greetings all,

 

I just pushed an update to the website which fixes the question sorting issue.

 

I am also adding a feature to download and upload the questionnaire using a CSV file.

 

Attached is an example using the old survey questions (I haven’t updated the site yet with Miriam’s latest).

 

Most of the columns you will recognize.  There are a few columns which are used internally by the application to generate the UI.   For example, the Answer Type is used to determine how the radio buttons are displayed.

 

The Evidence Prompt and Evidence Validation is a hook for future functionality where we can ask the user to specify locations for publicly available artifacts.

 

The Sub-question Of number is how we relate the indented bulleted questions under a higher level question (e.g. 1.6 and 1.6.1).

 

I don’t expect that the team would use this spreadsheet directly - when updating the site, an admin could copy/paste the originating document text to this spreadsheet and upload. 

 

Finally, I created an admin user for the site.

 

If you would like to try out the admin functions, email me and I’ll send you the login.

 

One last note – the sign-up functionality only works for a limited number of email addresses.  Since it is running in an Amazon Web Services sandbox, I have to register each email address with amazon before it can be used by the site.

 

If you would like to try out the sign-up, send me your email address and I’ll add it to the approved emails for the site.

 

Let me know if you have any questions or feedback.

 

Gary

 

-------------------------------------------------

Gary O'Neall

Principal Consultant

Source Auditor Inc.

Mobile: 408.805.0586

Email: gary@...

 


Jim Hutchison
 

Hi Gary,

 

For the CSV upload does the CSV include the questions, or just answers?

If solely answers, we’ll need  a date/version for the questionnaire used.

If also questions, there is perhaps a temptation for folks to edit them.

 

I like the CSV upload, as it benefits testability and some folks just don’t like web interfaces.

 

Regards,

 

Jim Hutchison

 

From: openchain-bounces@... [mailto:openchain-bounces@...] On Behalf Of gary@...
Sent: Thursday, September 29, 2016 6:07 PM
To: openchain@...
Subject: [OpenChain] Updates on the OpenChain certification website

 

Greetings all,

 

I just pushed an update to the website which fixes the question sorting issue.

 

I am also adding a feature to download and upload the questionnaire using a CSV file.

 

Attached is an example using the old survey questions (I haven’t updated the site yet with Miriam’s latest).

 

Most of the columns you will recognize.  There are a few columns which are used internally by the application to generate the UI.   For example, the Answer Type is used to determine how the radio buttons are displayed.

 

The Evidence Prompt and Evidence Validation is a hook for future functionality where we can ask the user to specify locations for publicly available artifacts.

 

The Sub-question Of number is how we relate the indented bulleted questions under a higher level question (e.g. 1.6 and 1.6.1).

 

I don’t expect that the team would use this spreadsheet directly - when updating the site, an admin could copy/paste the originating document text to this spreadsheet and upload. 

 

Finally, I created an admin user for the site.

 

If you would like to try out the admin functions, email me and I’ll send you the login.

 

One last note – the sign-up functionality only works for a limited number of email addresses.  Since it is running in an Amazon Web Services sandbox, I have to register each email address with amazon before it can be used by the site.

 

If you would like to try out the sign-up, send me your email address and I’ll add it to the approved emails for the site.

 

Let me know if you have any questions or feedback.

 

Gary

 

-------------------------------------------------

Gary O'Neall

Principal Consultant

Source Auditor Inc.

Mobile: 408.805.0586

Email: gary@...

 


Gary O'Neall
 

Hi Jim,

 

Both the questions and the “correct answers”.

 

It is intended to make is easier for an admin to update the website questions, not targeted for the end users (sorry about the confusion on that).

 

For the admin there are 2 menu options – update and add.  Both take a questionnaire version in the UI (not stored in the spreadsheet).

 

Adding a CSV upload and download for the end users is a good feature as well – in fact downloading is probably a key feature so that they can save their answers.

 

Excellent point on the versions.  I am versioning the questions.  I appended an extra digit to the spec version (e.g. 1.0.1, 1.0.2 etc) to track updates to the questions themselves.

 

I’ll add a download which will contain the questionnaire version in the first row, followed by the column header, followed by the answers.

 

I have been making a few enhancements and doing a lot to improve the quality of the site.  I’m also running into a number of detail questions on how we want to operate this website.  I’ll send out an email  on those changes later today along with a list of questions to be discussed in the openchain group.

 

Regards,

Gary

 

From: Hutchison, Jim [mailto:hutch@...]
Sent: Monday, October 3, 2016 9:45 AM
To: gary@...; openchain@...
Subject: RE: [OpenChain] Updates on the OpenChain certification website

 

Hi Gary,

 

For the CSV upload does the CSV include the questions, or just answers?

If solely answers, we’ll need  a date/version for the questionnaire used.

If also questions, there is perhaps a temptation for folks to edit them.

 

I like the CSV upload, as it benefits testability and some folks just don’t like web interfaces.

 

Regards,

 

Jim Hutchison

 

From: openchain-bounces@... [mailto:openchain-bounces@...] On Behalf Of gary@...
Sent: Thursday, September 29, 2016 6:07 PM
To: openchain@...
Subject: [OpenChain] Updates on the OpenChain certification website

 

Greetings all,

 

I just pushed an update to the website which fixes the question sorting issue.

 

I am also adding a feature to download and upload the questionnaire using a CSV file.

 

Attached is an example using the old survey questions (I haven’t updated the site yet with Miriam’s latest).

 

Most of the columns you will recognize.  There are a few columns which are used internally by the application to generate the UI.   For example, the Answer Type is used to determine how the radio buttons are displayed.

 

The Evidence Prompt and Evidence Validation is a hook for future functionality where we can ask the user to specify locations for publicly available artifacts.

 

The Sub-question Of number is how we relate the indented bulleted questions under a higher level question (e.g. 1.6 and 1.6.1).

 

I don’t expect that the team would use this spreadsheet directly - when updating the site, an admin could copy/paste the originating document text to this spreadsheet and upload. 

 

Finally, I created an admin user for the site.

 

If you would like to try out the admin functions, email me and I’ll send you the login.

 

One last note – the sign-up functionality only works for a limited number of email addresses.  Since it is running in an Amazon Web Services sandbox, I have to register each email address with amazon before it can be used by the site.

 

If you would like to try out the sign-up, send me your email address and I’ll add it to the approved emails for the site.

 

Let me know if you have any questions or feedback.

 

Gary

 

-------------------------------------------------

Gary O'Neall

Principal Consultant

Source Auditor Inc.

Mobile: 408.805.0586

Email: gary@...