Since Tables will only be accessible via webview and no longer by database view from October 2023, please make code table reports available (as a spreadsheet export if possible) in webview.
This is particularly useful for maintaining the active and inactive entries for tables that we use with attributes/custom fields as some have a large number of entries and users who will not have access to edit tables themselves play a big role in this maintenance. Typically, we export the table entries, share them with users and they highlight those that should now be inactive before returning the list for administrators to tidy.
A vital function for table clean-up and maintenance. Disappointing that this is not available in web view now that there is no table access in database view.
Attachments Open full size
Agreed...being able to export code tables would make clean up so much easier! Please make this happen :) TIA
Attachments Open full size
I am completely disappointed (but not surprised) that code tables can no longer be printed in NXT. Not really sure what the engineers were thinking, taking the database view away before the web view was fully functional. Just another downgrade...
Attachments Open full size
Agreed with a ll the comments made. Also really disappointed that the table lists cannot be exported anymore as excel spreadsheets whcih was really useful for auditing/clean up purpose. Found myself having to save the web page as a PDF :-(
Attachments Open full size
I want to similarly add that I often used these code table reports for data analytics to review database usage. So losing this report will make it much more difficult to review what areas of the database need to be cleaned up and simplified.
Attachments Open full size
If you want to be GREAT, Blackbaud, and not merely "adequate", here are a few suggestions that would allow your users to more efficiently manage table entries AND where they are used:
In the list of tables, show the table name and category as currently displayed, AND add a total of how often ALL of the table entries are being used in RE
When you click into a table to show the entries, the description and active / inactive flag is being shown. Display the number of instances where each specific table entry is being used.
When users click "view uses" they should see a list of constituent IDs and constituent names, and allowed to save it as a List or Query in webview. You are SO close, but the system record ID is not helpful at all.
Ideally, allow user to open a constituent record to see use of the table entry in context. This would be a great cleanup option for situations when a table entry is used only one time.
Also allow users to filter by tables that were set up for use in Attributes / Custom Reports. It is almost there because these have no category, but you cannot filter for "category is blank"
Rename the button at the top to anything BUT "New Donor Table". These are not applicable only to donors. And when you DO click the button, the screen says "Add donor category table" which is potentially confusing. There are already three "donor category tables" available.
Attachments Open full size
I am not able to even find our job assignment codes in the volunteer tables displayed. This is incomplete and doesn't even translate to database view - where you can at least segment by attributes. Attributes don't have a category. You have to know the table name which isn't always obvious.
Attachments Open full size
Seconding Lara Couture's comment! Please make sure ALL functionality is built out before terminating a database feature.
Attachments Open full size
The timeframe for this change is way too short. Also, all functionality that is offered in DBv should be available in webview when there's a change to move to webview.
Attachments Open full size