collecting user information

[lorraine]

Hello. We have powerpoint slides that we use for face-to-face training,
but now we want to allow users to download the slides in case they
can't make the training sessions.

The issue is that we need to be able to collect data on how long
they've actually been viewing the presention in order to give them
credit for "taking the course."

I realize there are third party products that do this, but we don't
want to go down that path. Based on some preliminary research it seems
like I should be able to use event handlers to connect to our database
to see who is viewing what and when. But is this the best way to go? I
don't want to expose our database connections in the vba code or make
it cumbersome for the user by launching an IE window to run an asp with
sql queries (is that actually doable anyhow? I'm just brainstorming...)

I guess my question is two fold: what is the best solution suited for
tracking how long a person is viewing a presentation, and any tips how
to get that done.

Thanks
Lorraine

 

[lorraine]

When you mention "when they quit" do you mean when they log out? What
exactly would drive the data collection to the file and the FTP after
quiting?

My original solution was to save the presentations as web pages or
archive (*.mht i believe) and when the user selects it from our
website, open the presentation in a pop-up window and basically poll
that child window to generally track how long the user is "viewing" the
presentation. There really isn't much we can do to be sure they are
actually paying attention to the presentation or if they close the
parent window...

But I've heard of people running executables to do similar training and
those executables hold the means of tracking the users back in the
server. So I've been thinking about ways of making our training
presentations more "portable" through background events and downloading
the slides to their own computer.

Our presentations already have macros that users must allow in order to
view associated video content so it is not huge limiting factor --
we'll warn them.

But again is it possible to do something similar to this without
revealing our connection information -- perhaps not through VBA as you
said password protection is faulting, but maybe an executable or
opening IE to an asp page? Should I just stick with the child-window
polling idea? Or are there other free technologies better suited for
this type of task? Macromedia presenation solution instead of
Powerpoint? (Not too familiar with macromedia though although whatever
it is that google video uses is rather interesting...)

Thanks
Lorraine

 

[lorraine]

Thank you for the link and suggestions! I think a vba executable to
launch and monitor the presentation is exactly the direction I should
be heading in. I have more experience with vbscript and automation than
vba, but I think I'll be able to get a handle on it. Thank you once
more.