Enhancement #1869

need method to correct license scan data

Added by Bob Gobeille about 1 year ago. Updated 9 months ago.

Status:Closed Start date:05/02/2012
Priority:High Due date:
Assignee:Bob Gobeille % Done:

0%

Category:Nomos
Target version:2.1.0
Rank:2 Tester:

Description

We actually need a method to correct any scanned data but license data is the highest priority.
This involves keeping an audit trail of who changed what and when.

common-license-file.tiff (121.4 kB) Bob Gobeille, 07/23/2012 03:35 pm

changelicense.tiff (42.8 kB) Bob Gobeille, 07/23/2012 03:39 pm

1869.tiff (97.3 kB) Bob Gobeille, 07/25/2012 07:47 pm

1865b.tiff (48.9 kB) Bob Gobeille, 08/02/2012 03:17 pm

1865viewlic.tiff (123.5 kB) Bob Gobeille, 08/06/2012 09:46 pm


Related issues

duplicated by Feature #2199: Need method to correct license scan (#1869) Rejected 06/12/2012

History

Updated by Paul Holland about 1 year ago

  • Priority changed from Normal to High

Changing to high priority per Bob. Should be something we do sooner rather than later.

Updated by Paul Holland 11 months ago

  • Rank set to 4

Updated by larry shi 11 months ago

  • Status changed from New to In Progress
  • Rank changed from 4 to 2
  • Estimate set to 3
  • IterNum set to 4

Objective:
For some users (e.g. admin), for a scanned package, if the admin find that the license report of some files are incorrect, can change it.
1. Can change license data on UI, display the change of license data (click on the license data, you can see who changed what and when.
2. Change the table: license_file_ref, add 2 new fields user_fk and license_file_time
3. Change other code if needed

Updated by larry shi 11 months ago

  • Assignee set to larry shi

Updated by larry shi 11 months ago

  • Target version set to 2.0.1
  • Estimate changed from 3 to 4

A medium task, 4 points

Updated by larry shi 11 months ago

  • Estimate changed from 4 to 8

Updated by larry shi 10 months ago

  • IterNum changed from 4 to 5

did not finish in iteration 4.

Updated by larry shi 10 months ago

  • Status changed from In Progress to Feedback

one fix in svn 6069.
Hi guys,
thanks for your testing, have fun.

Function Description: right after any license name, there is a link called ‘[Edit]’, you can click on it to change this license. On the license change page, you can change it or delete it, for now, delete has no trail; I do not have a solution to trace one deleted license. If one license is changed, when the mouse move out of this license, one license audit trail window will pop up, you can get the license audit trail information on this window.

Updated by larry shi 10 months ago

  • Assignee changed from larry shi to Bob Gobeille

Updated by Bob Gobeille 10 months ago

  • Assignee changed from Bob Gobeille to larry shi

Testing this I got an error that table license_file_audit does not exist. That file doesn't exist in core-schema.dat.

You don't need to delete a license. Just change it to license "No_license_found".

Updated by larry shi 10 months ago

sorry, forgot to check in the schema. :-(

Updated by larry shi 10 months ago

  • Assignee changed from larry shi to Bob Gobeille

new fix in svn 6075.
it is pity, I can not test it today, because of uploadtree issues.

Updated by Bob Gobeille 10 months ago

  • Assignee changed from Bob Gobeille to larry shi

What uploadtree issues? The only uploadtree issue I'm aware of is that the migration of pre 2.1 uploadtree to 2.1 needs to be rewritten.

Updated by larry shi 10 months ago

another fix in svn 6081,
for one file, it has multiple licenses, if you change one license to a exist license, how to deal with this phenomenon, want to talk with bob after tomorrow's meeting.

Updated by larry shi 10 months ago

  • Status changed from Feedback to In Progress

Bob Gobeille wrote:

What uploadtree issues? The only uploadtree issue I'm aware of is that the migration of pre 2.1 uploadtree to 2.1 needs to be rewritten.

yes, that is because the migration. it works now.

Updated by Bob Gobeille 10 months ago

Testing shows PHP warnings. See attached.

Updated by Bob Gobeille 10 months ago

Change License requires user to type in license shortname as free text. This should be a pulldown. See attached screenshot.

Updated by Bob Gobeille 10 months ago

Tested on svn 6086, see attached .tiff for screenshot of error

Updated by larry shi 10 months ago

  • Status changed from In Progress to Feedback
  • Assignee changed from larry shi to Bob Gobeille

fixed in svn 6089. thanks for your testing.

Updated by Bob Gobeille 10 months ago

  • Assignee changed from Bob Gobeille to larry shi

tested on svn 6095. Same problem as before (see 1869.tiff).

Updated by larry shi 10 months ago

  • Assignee changed from larry shi to Bob Gobeille

Bob Gobeille wrote:

tested on svn 6095. Same problem as before (see 1869.tiff).

I tested on your machine, and my 2 machines, can not reproduce it. perhaps we can have a talk after the meeting tomorrow.

Updated by Bob Gobeille 10 months ago

  • Assignee changed from Bob Gobeille to larry shi

retested on 6098 - same problem
Do you have your log level set so that you will see php Notices?

Also, where is the license audit trail?

Also, there is no link to return to the license viewer.

Updated by Dan Stangel 10 months ago

  • IterNum changed from 5 to 6

Bumped to iteration # 6

Updated by larry shi 10 months ago

Bob Gobeille wrote:

retested on 6098 - same problem
Do you have your log level set so that you will see php Notices?

please try svn 6103.

Also, where is the license audit trail?

if one license of one file is changed, when mouse out, pop up audit trail window.

Also, there is no link to return to the license viewer.

I can add it on the change license window.

Updated by larry shi 10 months ago

  • Status changed from Feedback to Resolved

fixed in svn 6104.thanks for your testing.

Updated by larry shi 10 months ago

  • Status changed from Resolved to Feedback
  • Assignee changed from larry shi to Bob Gobeille

thanks for your testing, anything please let me know.

Updated by Bob Gobeille 10 months ago

  • File 1865b.tiff added
  • Assignee changed from Bob Gobeille to larry shi
  • Target version changed from 2.0.1 to 2.1.0

Tested on 6104
The previous php notices are gone. That's good.

There is still a lot wrong with this from a usability standpoint. I'll send an email.

Updated by larry shi 10 months ago

  • Estimate changed from 8 to 10

Updated by Bob Gobeille 10 months ago

testing svn 6113, clicking on the license browser gives an undefined variable notice. See attached.

Also, on Change License, since the history of the changed license is now displayed, you don't need to display the extraneous "[Close] 'license1' is changed to 'license2'"

Also, the Change License screen could use some headings, like "Change History" and "Change License" (or something).

Also, the change license dialog should be before the change license history.

Also, change "Changed To" in the change license dialog to "Change To"

Updated by Bob Gobeille 10 months ago

I just noticed that you are reporting the date like "2012-08-06 15:41:27.75263-06". Instead of that, use "2012-08-06 15:41:27". You can find an example of how to do that in Show Jobs.

Updated by larry shi 10 months ago

  • Status changed from Feedback to Resolved

fixed in svn 6115.

Updated by Bob Gobeille 9 months ago

  • Status changed from Resolved to In Progress

tested on svn 6118

There still needs to be a way to visually separate the change dialog from the history list. I suggested using headings above. Headings alone would probably work. If not then use headings plus background coloring.

The update is still not restricted to the owner. I was able to change a license without even logging in.

The user is currently allowed to enter HTML and have it rendered in the change history. That is probably a mistake.

Changing a license will also require a bucket rescan of the file.

Changing a license will require any cached license browser pages to be removed.

Updated by larry shi 9 months ago

  • Estimate changed from 10 to 14

Updated by larry shi 9 months ago

  • IterNum changed from 6 to 7

Updated by larry shi 9 months ago

  • Status changed from In Progress to Resolved

fixed in svn 6152.

Updated by Mary Laser 9 months ago

  • Assignee changed from larry shi to Bob Gobeille

Please verify & close this issue AND document your step-by-step method/test for verifying this new enhancement using the manual test template (or any other test you deem necessary).
Thanks,
Mary

Updated by Bob Gobeille 9 months ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF