#2606 Include Quality column from qcol plugin on Export dialog

[Mike Zandvliet]

The qcol plugin is fantastic --- is there any way that the Quality column could be included in an Export? We have ~3000 entries in our KDBX, and I've been tasked with tackling the lowest quality 1000 entries. It would help a great deal to be able to track my progress on a spreadsheet that is sorted by Quality (ascending). At the moment my only option is to transcribe the Quality value by hand (1000 times!) and then sort the list.

[Paul]

Given there is a password quality report in KeePass V2 (Find > Password Quality), it would be more sensible for KeePass to provide a way to copy and paste that report.

cheers, Paul

p.s. I think the report should not include the passwords. At present you get an unhidden list of passwords.

[wellread1]

There is no need to export when updating passwords. A couple of methods of updating a database or a copy of it are described below.

Method 1, select and edit an entry with low password quality: Select the menu item Find>Password quality to show the list of all entries ordered by ascending password quality. Click on the entry you want to update and change the password. Repeat 3000 times.

Method 2, select a group of entries to modify:

1. Turn entry list grouping off (View>Entry List Grouping>OFF).
2. Display the quality column.
3. Select the menu item Find>All.
4. Sort the entries in ascending password quality order (click on the quality column header).
5. Select a group of entries that you plan to change. Mark them by tagging them (Right-click on the selected entries and select the context menu option Edit Entry (Quick)>Add tag).
6. When you wish to work on the tagged entries, select Find>Tag.
7. When you finish editing the group, use the Edit Entry (Quick) context menu to remove or change the tag and/or color the updated entries. Repeat until you have worked through all entries.

There are a variety of ways to monitor your progress. For example you could tag or color updated entries. The last modified date and/or the quality column may also be useful.

---

If you have been tasked with changing 3000 passwords, expect 4-6 weeks of solid work if it takes you 3-5 minutes per password change and you are working 40hrs/week. I won't comment on the advisability of sharing 3000 passwords.

[Paul]

You could read the Title, UUID and password fields via KPScript, then test each password in KPScript (-c:EstimateQuality -text:MyTopSecretPassword). This will return a quality number.
Write the title, uuid and quality to a CSV file and import to your spreadsheet.

cheers, Paul

[wellread1]

For simplicity and security, I recommend you keep all password update work in KeePass.

If you feel that you need one or more columns to save progress information, you can add custom string value(s) to all entries or selected entries. The KPEnhancedEntryView plugin is convenient for this task because it can add and modify custom string fields in selected groups of entries. For example, you could add a custom field call 'password updated' to the 1000 entries containing the weakest passwords. Initialize the 'password updated' with the value 0. As you update each entry, set the entry's 'password updated' field to 1.

I recommend you make edits in an "update" copy of the working database. Frequently save changes and periodically backup the updated database. Once a set of changes are validated (verified that changes are correct), sync the updated database with the production database.