Site Login Statistics
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=219
Printed Date: 18-February-2025 at 3:41pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Site Login Statistics
Posted By: dwatch
Subject: Site Login Statistics
Date Posted: 22-May-2006 at 10:00am
|
It would be great to be able to track and view some site login statistics. 1)who is currently logged in 2)daily list of who logged in, how many times, how long they were logged in for, there IP address Anyone doing this or need this too? |
Replies:
Posted By: amgqmp1
Date Posted: 25-May-2006 at 2:49pm
Yep, I could use this too. We sell "soft" services (e.g. ability to login and redownload a purchase). The ability to directly measure this would be terrific...would help us do more than just guess. 
|
Posted By: netprofits
Date Posted: 25-May-2006 at 2:56pm
|
I don't know if any other developers have implemented this but we have had requests for something similar from our clients but have not built it yet. Are you interested in having someone develop this functionality for you? ------------- NetProfits Internet Consulting Certified ProductCart Developer http://www.nicwebdesign.com" rel="nofollow - Our Site |
Posted By: dwatch
Date Posted: 25-May-2006 at 3:05pm
| hoping to get help right here in this forum for everyone. |
Posted By: netprofits
Date Posted: 27-May-2006 at 3:43pm
|
Here is a basic overview of what would need to be done. You would need to know ASP and SQL to accomplish this. 1. Setup a new table in SQL to store the user login information you want to collect: SessionID, CustomerID, StartDate/Time, EndDate/Time, IP Address. 2. In the global.asa Session_OnStart you would add code to create a new entry in the new SQL table with the initial information. You wouldn't have a customer ID until they login or create an account. 3. If/when a customer logs in or creates an account, add their customer ID to the SQL user record for the active session. 4. In the global.asa Session_OnEnd, write out the End Date/Time to the active SQL user record. 5. Create a report in the Control Panel that would summarize the data collected in the new SQL user table to show the details you want. Sum on CustomerID to see how many times a specific customer logged in. Perform cals on the Start/End times to see how long users stayed on the site, etc. 6. Create a report in the Control Panel that shows currently active users (where the EndTime is not filled in for the user table). If there is a customerID entered in the user record, you could pull the customer name from the customer table. Hope that points you in the right direction. ------------- NetProfits Internet Consulting Certified ProductCart Developer http://www.nicwebdesign.com" rel="nofollow - Our Site |
Posted By: dwatch
Date Posted: 19-June-2006 at 9:04am
| thanks! based on netprofits comments, the only thing I need help with is the global.asa code |
Posted By: netprofits
Date Posted: 19-June-2006 at 9:10am
|
Here is a helpful article on the global.asa events and where you would add your code: http://www.w3schools.com/asp/asp_globalasa.asp - http://www.w3schools.com/asp/asp_globalasa.asp . Is that what you need? ------------- NetProfits Internet Consulting Certified ProductCart Developer http://www.nicwebdesign.com" rel="nofollow - Our Site |