close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Track Utilization

Thread began 4/26/2013 1:02 pm by Erin | Last modified 5/02/2013 2:00 pm by Jason Byrnes | 510 views | 7 replies |

Erin

Track Utilization

Hello, I would like to set up a page where we can track all user logins and also track what searches they conduct in a session. From reading past discussions, I roughly understand that I need to set up a table for this, as well as update record behavior. Is there any way I could get a little more assistance as to how to go about this? How do I set up the table, or should I do multiple tables? Thanks!

Sign in to reply to this post

Jason ByrnesWebAssist

I think you would want to have 2 tables, one to track the logins, and another to track the searches for the session.

the structure for the table to track logins would be something like:

logins:
loginID - Primary key
loginUserID - relates to the users.userID table


on the login page, the the security assist authenticate user behavior will store the logged in uses ID in a session. make sure the authenticate user behavior does not redirect to another page, then add an insert behavior to store the logged in users ID using the session variable binding.

make sure the insert code gets added after the security assist authenticate user code.

the insert behavior will also store a session with the loginID value for the was created.

for tracking the searches, you would need a table with the following structure:
searchID - Primary Key
searchLoginID - relates to the logins.loginID
search Terms

on the results page, you would add another insert behavior to capture the search. use the loginID session variable for the searchLoginID column.

you will need to add bindings to the bindings panel depending on the search form method, POST or GET for the search form, then use those bindings in the insert behavior.

Sign in to reply to this post

Erin

If I must remove the page redirect before inserting behavior on login page, how then do I get the page to redirect after inserting behavior?

Sign in to reply to this post

Jason ByrnesWebAssist

Set the redirect to occur in the insert behavior

the order of execution should be:
-authenticate user
-insert

if the authenticate user behavior redirects, it wont be able to execute the insert

so set the redirect to happen in the insert behavior.

Sign in to reply to this post

Erin

Ok, thank you. I believe the issue is that I am not properly understanding how to insert behavior. Is there any way you could explain this is more detail? Thank you very much for your help so far!

Sign in to reply to this post

Jason ByrnesWebAssist

add the insert record behavior by opening the server behaviors panel, clicking the plus button, and select Webassist -> Data Assist -> Insert Record -> Insert Single record

Sign in to reply to this post

Erin

Thank you, that was the issue. The other issue, I don't understand how to add bindings to the binding panel for the search form (which was GET). Any way I could get some clarification there, as well?

Sign in to reply to this post

Jason ByrnesWebAssist

The get method passes the form using URL variables.

make note of the names of each element in the search form

go to the bindings panel, click the plus button and URL variable, set the name to the name of the first form element. repeat for each element in the search form.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...