SM - Manage Your Scouts

scacchicgardenSoftware and s/w Development

Dec 13, 2013 (4 years and 19 days ago)

75 views

mys.metcarob.com

Scout Management

Technical Overview Screen cast

mys.metcarob.com

Screen cast Aims


Explain the basic design of SM


Show the tools used


Encourage people to sign up and contribute


Show where independent projects could fit
in


Multi part screen cast


mys.metcarob.com

SM Backend

Scout

Management

SM ActiveX Control

SM Structure Overview

User

VBA

?

?

Independent

Projects

mys.metcarob.com

SQLite


Database software library that handles all
file operations (http://sqlite.org/)


Interfaced through SQL commands


Data files can be viewed with a number of
applications


I use SQLite Administrator
(http://sqliteadmin.orbmu2k.de/)

mys.metcarob.com

SM Backend


Written in C++ (Maybe compliable on
Linux)


Uses SQLite to Create Opens and operate
on the data file


Manages user security


Provides logical operations (like Add Scout,
etc.)


Contains all the validation logic

mys.metcarob.com

Scout Management


Main application the user sees


Written in C++ using MFC (Windows
Only)


Uses SM Backend to access operations

mys.metcarob.com

SM ActiveX Control


Written in C++


An activeX control that runs on Windows
machines.


Provides Interface to SM Backend


Can be accessed by any program that
supports activeX controls


Develop on demand


so far reporting only

mys.metcarob.com

VBA


Microsoft Office Visual Basic for
Applications


Uses activeX controls to access data and
produce reports in Word and Excel


I plan to provide templates and examples in
knowledge base so it is very easy for
programmers to develop their own reports

mys.metcarob.com

Independent Projects


Programs can work with SM by linking in to SM
Backend or using ActiveX control


All programs will use same data file


Users can use a suite of programs with the same
data


In Theory SM Backend provides validation etc.


Developers may work with SM Backend
developers to include new data structures


In future SM Backend may include custom table
functionality

mys.metcarob.com

SM Structure Overview

User

SM Backend

Scout

Management

SM ActiveX Control

VBA

?

?

Independent

Projects

mys.metcarob.com

Scout Management

Technical Overview Screen cast

Thank you for watching!

I am trying to make SM a community project.

Any comments suggestions of help in doing this is very welcome!!!