Difference between revisions of "Help:BNH Project Enhancement Ideas"

From Bank Note History
Jump to: navigation, search
m
(2 intermediate revisions by the same user not shown)
Line 9: Line 9:
 
== B&B Database/Search Webapp ideas ==
 
== B&B Database/Search Webapp ideas ==
 
* **** MD: (10/21/19) Show a new section on the Bank Info page, listing the VanBelkum 'Bank Note Types Issued' information (right below the Bank History Timeline section). (3 column table of data similar to Bank Balance section).
 
* **** MD: (10/21/19) Show a new section on the Bank Info page, listing the VanBelkum 'Bank Note Types Issued' information (right below the Bank History Timeline section). (3 column table of data similar to Bank Balance section).
 +
: (This section should go between the 'Bank History Summary' and 'Bank Balance Summaries' sections)
  
 
: Bank Note Types Issued (VanBelkum)        (This is the Section Title, with (VanBelkum) in grey like other section titles)
 
: Bank Note Types Issued (VanBelkum)        (This is the Section Title, with (VanBelkum) in grey like other section titles)
Line 17: Line 18:
 
|style="text-align:center;"|Serial#s
 
|style="text-align:center;"|Serial#s
 
|-
 
|-
|style="text-align:left;" |1882BB
+
|style="text-align:left;" |1882 Brown Back
 
|style="text-align:left;" |3x10-20
 
|style="text-align:left;" |3x10-20
 
|style="text-align:right;"|1-2200
 
|style="text-align:right;"|1-2200
 
|-
 
|-
|style="text-align:left;" |1902RS
+
|style="text-align:left;" |1902 Red Seal
 
|style="text-align:left;" |4x5
 
|style="text-align:left;" |4x5
 
|style="text-align:right;"|1-1200
 
|style="text-align:right;"|1-1200
 
|-
 
|-
|style="text-align:left;" |1902DB
+
|style="text-align:left;" |1902 Date Back
 
|style="text-align:left;" |3x10-20
 
|style="text-align:left;" |3x10-20
 
|style="text-align:right;"|1-1200
 
|style="text-align:right;"|1-1200
 
|-
 
|-
|style="text-align:left;" |1902PB
+
|style="text-align:left;" |1902 Plain Back
 
|style="text-align:left;" |3x10-20
 
|style="text-align:left;" |3x10-20
 
|style="text-align:right;"|1201-3500
 
|style="text-align:right;"|1201-3500
 
|-
 
|-
|style="text-align:left;" |1929T1
+
|style="text-align:left;" |1929 Type 2
 
|style="text-align:left;" |6x100
 
|style="text-align:left;" |6x100
 
|style="text-align:right;"|1-200
 
|style="text-align:right;"|1-200
 
|}
 
|}
: (The data table will be 3 (20 char max) columns with a variable number of rows)
+
: (The data table will be 3 (25 char max) columns with a variable number of rows)
 
: (SQL is: Select ViewSheetSeries, ViewSheetDenoms, ViewSheetSerials From BBNBSheetsIssued Where NBCharter = 12345)
 
: (SQL is: Select ViewSheetSeries, ViewSheetDenoms, ViewSheetSerials From BBNBSheetsIssued Where NBCharter = 12345)
 +
: (Note: If the query comes back empty, that means this Natl Bank did not issue bank notes, so skip this section entirely).
  
  

Revision as of 20:23, 8 November 2019

This page is meant to consolidate Enhancement Ideas for the Bank Note History Project for future programming/wiki consideration.

BankNoteHistory.com Wiki ideas

B&B Database/Search Webapp ideas

  • **** MD: (10/21/19) Show a new section on the Bank Info page, listing the VanBelkum 'Bank Note Types Issued' information (right below the Bank History Timeline section). (3 column table of data similar to Bank Balance section).
(This section should go between the 'Bank History Summary' and 'Bank Balance Summaries' sections)
Bank Note Types Issued (VanBelkum) (This is the Section Title, with (VanBelkum) in grey like other section titles)
Series/Type Sheet/Denoms Serial#s
1882 Brown Back 3x10-20 1-2200
1902 Red Seal 4x5 1-1200
1902 Date Back 3x10-20 1-1200
1902 Plain Back 3x10-20 1201-3500
1929 Type 2 6x100 1-200
(The data table will be 3 (25 char max) columns with a variable number of rows)
(SQL is: Select ViewSheetSeries, ViewSheetDenoms, ViewSheetSerials From BBNBSheetsIssued Where NBCharter = 12345)
(Note: If the query comes back empty, that means this Natl Bank did not issue bank notes, so skip this section entirely).


  • **** MD: (3/28/19) Allow to Edit 'Bank History Link' (inline?) on the 'Bank Info Page' (if Users.AllowModifyBankInfo=Y) (The data field is Banks.BankHistoryLink varchar(250).
  • **** MD: (10/22/2019) Allow to Edit the 3 'Bank History Highlight' fields (60 char edit boxes) on the same screen as Editing the Bank History Link above. (The 3 data fields are Banks.BankHistoryHightlight1,2,3 varchar(60)).
(Note: These should be the Only 4 Bank data fields that would need to be edited in the search webapp)


  • (if easy, else wait) ** MD: (3/28/19) Show Source page# column on the Officer Detail page for lookup reference/verification.


  • Wait - ** MD: (6/24/2019) Support the Users.Allow SwitchBankerState & Allow SwitchBankerCounty user options to Lock State/County search values (for example could have a PCHS login restricted to Pipestone County, MN searches). Also see IP Address login restriction below.
  • Wait - ** MD: (6/24/2019) ALSO Support the Users.UserPublicIPAddress1 & 2 (new fields), so (if not blank) ONLY allow login from these IP Address(es). (MD-Check code in windows modules). ** NOTE: Use the LocalIPAddress field/value (Equals PUBLIC IP Address) that is already getting set in SYXLog table.


  • NO/wait - MD: (3/29/19) On the Bank Info Page also show the Pollock Succession/Merger data? (1863-1909 Charters 1-9843).
(Data is from BankersMags, and only available from 1863-1909 (Charters 1-9843). This data no longer shown in BMags after 1909).
Show this below VBH TimeLine? Also show SOURCE/page#, ie BMv021-p1234?
Note: This could be sometimes Redundant/New/Contradictory data with VBH Timeline data, but useful to know.
(Maybe eventually merge this data into VBH.VBInfo field to show in VBH TimeLine? (PH's call on this. Would require manual vfy work).


  • NO/wait - SH: (3/29/19) I was looking around the BB database pages some. It occurred to me you might want to have cross links between the Bank Info page and the Officer Detail page for a given bank so that you don't have to go to the Bank Officer Search page to navigate between the two. Just a thought. (MD Comment: This would probably be problematic for the user interface to return to main (Bank Officer) Search list).