Club Management installation
11. Download the following from the portal in 4.3 Optional Modules updates on the Siriusware Information Portal.
• E-Commerce Club Management Install Script
• E-Commerce Club Management Report Files
• E-Commerce 4.3.xx Club Management Pages
12. Unzip the Install Script package on your SQL server and run the script. This will add two stored procedures which the report will use to generate data. The stored procedures are named rs_ClubMemberPurchases and rs_ClubMemberPurchases_PT.
13. Navigate to the Stored Procedures in SQL by going to Databases > SiriusSQL > Programmability > Stored Procedures and select Properties.
14. Right click on the rs_ClubMemberPurchases stored procedure and select Permissions. Ensure the Sirius and Siriusweb user have Execute permissions.
15. Follow step 4 for the rs_ClubMemberPurchases_PT stored procedure.
16. Unzip the Club Management Pages and place the two pages into your E-Commerce directory where your pages are hosted (usually C:\Inetpub\wwwroot\E-Commerce).
17. Log into the Site Admin Panel of your E-Commerce pages, and ensure the Site Configuration setting UseClubLogin is set to 1.
• With the value of this key set to 1, requests or links to the original Group log-in page (GrpLogin.aspx) are redirected to GrpLogin2.aspx. So the link or links to the Club Management log-in page is constructed to go to GrpLogin.aspx (e.g., https://www.yourbusiness.com/E-Commerce/GrpLogin.aspx), and the software redirects the user to GrpLogin2.aspx.
18. Open the images directory of E-Commerce (C:\Inetpub\wwwroot\E-Commerce\images).
19. Create a new folder inside of the Images folder named, “clubs”.
20. Right-click on clubs and select Properties and go to the Security tab.
21. Look for a user named IIS_IUSRS. If it’s not present, add this user.
22. Give this user the following permissions: Modify, Read & Execute, List Folder Contents, Read and Write.
23. Repeat steps 2 through 4 above, for the images directory.