RMControls : Project Diary

User Documentation completed. Follow link on main project page entitled "User Documentation".

delDoc scenario resolved - documents need to be uploaded AND deleted remotely
radiobutton loop not working for lists with only one radiobutton
microsoft upload code found to be too slow for application, will use pre-existing method from Jon archive

aspfaq.com used as resource for recursive page calling for MC
several issues resolved, incl.
- selecting radio button values with loop
- window.navigate in client script to resend pages

returned to previous levels of usability/completion but with new COM code design
preliminary load test complete; metrics available here in spreadsheet format
begin first phase of MC COM and asp coding

difficulty passing Recordsets from one COM (.dll) to another - see previous entry
found FMstocks example of enterprise web app on MSDN
attempted to emulate strategies of FMstocks app
abandoned 3-.dll framework and switched to 2-.dll concept
- RMCSQL = holds all presentation code (MC and htm), all DB select queries
- (not yet named) = holds all add/del/edit queries and associated MC code
Process under way to return to previous usability level of 04/13/02

first attempt to separate COM code into three modules:
- RMCMC == all MC display
- RMCPresentation (also htm*) == all display methods for external site
- RMCSQL == all select queries for display and MC add/del/edit/select sill be passed as recordsets from this COM to the others

Process Diagrams now posted on web:
- Context Level Diagram
- Level 0 Diagram
Entity Relationship Diagram (ERD) coming soon
Prototype page design created for Mgmt Console Prod pages
- dropdowns and radio buttons for selection
- vbscript on asp page to determine actions, onClick procedures
- minimal code to be added to htmCOM for changeover to MC - only buttons
- layout will resemble rmcontrols.com as closely as possible
asp methods/functions pseudocoded for MC Prod pages
Separation of DB query COM and MC COM discussed
table css to be transparent and background pics to be used as tint

Updated error handling in ASP pages
Found two possible ways to create MgmtConsole
- ActiveX control in a web page
- RDS remote connection
Jim got book from Jon: Database Developer's Guide to Visual Basic
Labels added to prod.asp for ease of reading

Updated table structure to accomodate multiple model numbers for each product name/type
Agreed on four ASP pages to display product data
- categories.asp == returnCategories function
- scategories.asp == retSubCategories function
- selection.asp == retProdName function
- prod.asp == retProdInfo function
Populated Database with limited test data : to be completed with management console
Designed, coded queries for ASP pages
Agreed on prod.asp layout, coded
Researched ADODB and ActiveX for MgmtConsole
Before docLoc info is stored in db, MgmtConsole code must trim filenames of all whitespaces
For next mtg:
- complete style sheets for asp pages
- research mgmt console

Meeting with Customer/CEO led to simplification of goals
Greatly simplified data structure, many tables deleted
Only two levels in hierarchy of product, no series or seriesModel tables: mainGroup->subGroup->prod
YCA main vendor
Mario agreed to contact Phil
Neles information obtained - it now fits into structure
Emailed Barry an update
Mario will use cust data - track how many are downloading docs vs only browsing page; include login and pass at later date
For next mtg:
- update data structure to reflect discussion