Code Tables Report for webview

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.

  • Rachel Cavalier
  • Sep 6 2023
  • Attach files
  • Samantha Henderson commented
    02 May 16:01

    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.

  • Julie Abramson commented
    22 Mar 15:24

    Agreed...being able to export code tables would make clean up so much easier! Please make this happen :) TIA

  • Maryann Grifasi-Miller commented
    07 Feb 20:23

    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...

  • Bene vB commented
    22 Jan 15:11

    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 :-(

  • Ben Draskovic commented
    10 Jan 20:11

    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.

  • Karen Diener commented
    September 12, 2023 20:16

    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.

  • Deb Dressely commented
    September 11, 2023 15:15

    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.

  • Faith Murray commented
    September 11, 2023 14:39

    Seconding Lara Couture's comment! Please make sure ALL functionality is built out before terminating a database feature.

  • Lara Couture commented
    September 11, 2023 14:16

    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.