Alpha Video Training
Results 1 to 5 of 5

Thread: Multi Company - Multi User Shared Website

  1. #1
    Member
    Real Name
    Kevin Callanan
    Join Date
    Feb 2007
    Location
    Upstate New York USA
    Posts
    11

    Default Multi Company - Multi User Shared Website

    I am creating a website where multiple users from multiple companies will come to enter and later retrieve data. Users from each company will see only data from their own company, but the data will reside in a single database alongside the data from all of the companies. This will be a service the users pay for (subscribe to) by company. I have figured out how to display the data correctly using session variables and ulink. I anticipate creating a filter which is a combination of the company name and address, in case there are two companies with the same name.

    The intent is to have one or more persons at each company with administrative rights to features of the site. (separate and distinct from my administration of the site itself) for example they would be allowed to add users at their company with lesser rights (maybe view the data only, or maybe rights to add data but not to delete it).

    My question is: What is the best way to manage or structure the signup and payment areas of the site. I anticipate using Paypal to collect the $$$. Do I simply create an "Add new user at this company" page available only to those with admin rights which skips the payment parts of the site. I could then populate the company info fields of the new user(which is important for filtering records) with the company info already in the record of the person creating the new user.

    I have seen discussion threads about how difficult or impossible it is to keep track of concurrent users so I'm not trying to do that. I will have a base price for each company for a year of access with an add-on to that dependent on how many records they are storing.

    Thank you.

    Kevin Callanan
    Last edited by Kevin Callanan; 01-18-2009 at 03:45 PM.

  2. #2
    Moderator Steve Workings's Avatar
    Real Name
    Steve Workings
    Join Date
    Apr 2000
    Location
    The Dreaded Chair
    Posts
    5,596

    Default Re: Multi Company - Multi User Shared Website

    Seem to me like you're on track Kevin. As long as you're recording the company_ID for the added users, you should get what you want.

    I don't know how involved the signup process is, and whether it's best to simply skip the Paypal part as you said, or just provide a simple dialog or grid for the authorized person(s) to manage their user list. But it sounds like you've considered this sort of thing already, so I don't see anything substantial to suggest to you.
    -Steve


  3. #3
    Member ColinJD's Avatar
    Real Name
    Colin Davies
    Join Date
    Jun 2006
    Location
    NZ
    Posts
    481

    Default Re: Multi Company - Multi User Shared Website

    As we <strike>speak</strike> write I am still in the process of doing something similar, Aprox 2000 users and 240 admins.
    Some aditional features I am implimenting is a log file generated on user creation activity, by the minor level admins. Plus a recorded log of the admins activity. The reason for this is principally to halt 3 way disputes between me, the minor admins, and the general users.

    Also each user record has a hidden GUID of their minor admin recorded as an aditional check on the minor Admin's authority to work on that record, (Unsure how this would work with multiple Admins)
    Note: I don't want to administer approx 240 groups + 240 admin groups.

  4. #4
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    Location
    S.E. Michigan
    Posts
    5,763

    Default Re: Multi Company - Multi User Shared Website

    Just curious - are you guys doing this with just .dbf tables? (I doubt it but had to ask.)

  5. #5
    Member ColinJD's Avatar
    Real Name
    Colin Davies
    Join Date
    Jun 2006
    Location
    NZ
    Posts
    481

    Default Re: Multi Company - Multi User Shared Website

    dbf and nothing but dbf,
    Any new project I use dbf for everything, unless I believe the File or record size may become humungous.
    On anything older, that is running another file system, I'll leave it as is if it isn't broken.

Similar Threads

  1. Multi-Company Reporting Question...
    By fhannaford in forum QReportBuilder
    Replies: 7
    Last Post: 12-29-2008, 11:26 PM
  2. Multi Company Accounts
    By Mike Vance in forum Alpha Five Version 8
    Replies: 10
    Last Post: 05-23-2007, 02:15 AM
  3. Multi Company Accounts
    By sarper dayanik in forum Alpha Five Version 6
    Replies: 14
    Last Post: 06-27-2005, 07:27 AM
  4. Multi Company Setup
    By Ray in forum Alpha Five Version 5
    Replies: 9
    Last Post: 03-21-2004, 04:22 AM
  5. Multi Company Request
    By Larry F. Carraher in forum Alpha Five Version 5
    Replies: 4
    Last Post: 06-04-2003, 05:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •