Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Link a personnel table to security tables

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Link a personnel table to security tables

    I am moving our desktop app to web based. We have a personnel table for all our personnel records and this is utilized throughout the application, and its primary key field called "persid" is numeric. Each of the 300 personnel will have login permissions which will be handled by the Alpha security, (i am also using the AlphaToGo Template). I need the ability to set permissions and filter some pages by the current logged in user, so i assume i will be using the ulink field. But i have no idea how to connect these tables.

    Do I add a field in the websecurity_users table and create a one-to-one relationship to my personnel table? or do I add the ulink value from the websecurity_users table to the personnel table.
    Do I even need to be using the web_users table since the personnel table will be used?

    Heck, this is even difficult to explain, so i am going to need some help with this.
    J.R.
    Epigate Software, LLC.

    [email protected]
    http://www.epigate.com
    sigpic

    #2
    Re: Link a personnel table to security tables

    Hi JR.

    As far as I know, you will have to enter each employee individually. I would suggest you use their email address as their userid. You do not link the tables as the security tables are in a separate folder.

    When a user logs if the login is successful they are taken to what I call a process page. This is a code only page and is not seen by the user. The code here takes the userid and looks up the personnel table and gets what you want into session variables. They are then redirected to a Welcome page which displays their name and any other details you want.

    I have not used the AlphaToGo Template, but I assume that is the way it works. It is what I have in my site www.churchjobfinder.co.uk
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

    Comment


      #3
      Link a personnel table to security tables: example

      .
      Hi J.R.,
      I did this short example in which I link my user table to the system's security table, using the ulink in Alpha Five 10.5. I hope it helps you.



      Also, take into account the following:

      A) It seems that the use of ulink will be discouraged in future versions of Alpha Five. "They" recommend using the security system's User Name / User id. From my point of view, the concepts are similar, so the switch should be of little effort.

      B) Probably you'll have to build a "New User" webpage that simultaneously gathers Personal and Security data. There's a Dialog2 template for that, plus a video.

      C) Probably you'll have to build a "Modify User" webpage that simultaneously retrieves and modifies Personal and Security data. There's a Dialog2 template for that, plus a video. The video is incomplete in the sense that the "example user" is hardcoded (you'll understand what I mean when you watch the video). This thread might be of help (there's a zipped file plus a how-to).

      D) Probably you'll have to build a "Delete User" webpage. You'll have to do that yourself.



      Regards,
      Felix

      Comment


        #4
        Re: Link a personnel table to security tables

        Originally posted by J.R. Noe View Post
        ...
        Do I even need to be using the web_users table since the personnel table will be used?

        Heck, this is even difficult to explain, so i am going to need some help with this.
        Yes, you need the web security tables. Watch the v11 videos on security. And you can import all 300 users into web security; you don't need to enter them manually. However, if your user table is not dbf, I think you have to convert it first. Look in the web security/users dialog.
        Peter
        AlphaBase Solutions, LLC

        [email protected]
        https://www.alphabasesolutions.com


        Comment


          #5
          Re: Link a personnel table to security tables

          Thanks eveyone for the help. I think i have a better grasp of the concept now. I did leave out that i am using SQL. Peter, my wording probably confused the situation. What i meant to ask is regarding the one table called "web_user" which actually has all the fields that i have in my personnel table. So my way of thinking, probably wrong, but why have 2 tables with the same data, so if i could use the personnel table it would cut out another link.

          I just need to be able to filter a dialog/grid by the person logged in, which is somewhat clear to me, but we have historic data that will need to provide that filter.
          Example: a supervisor entered an incident report a few years ago under his name and with a"persid" of 10052. Now that we are moving to Alpha, i want to allow only that supervisor to access that record, but there is no ulink in that record, so somewhere/somehow i need to mesh the security with the personnel and historic data.

          I will read the docs on it more and watch the videos, thank you Felix for the videos.

          Keith, using a process page is a good idea. Thanks.
          J.R.
          Epigate Software, LLC.

          [email protected]
          http://www.epigate.com
          sigpic

          Comment


            #6
            Re: Link a personnel table to security tables

            Originally posted by J.R. Noe View Post
            What i meant to ask is regarding the one table called "web_user" which actually has all the fields that i have in my personnel table. So my way of thinking, probably wrong, but why have 2 tables with the same data, so if i could use the personnel table it would cut out another link.
            Just to be clear. In order to import your 300 SQL users into security, you will probably have to export that table to dbf in order to perform the import.

            In Alpha you need to have the web_users security table as well as the other security tables. You can even move those tables over to SQL, but that's another topic. Your personnel table can be linked to security. Jerry shows that in the videos.
            Peter
            AlphaBase Solutions, LLC

            [email protected]
            https://www.alphabasesolutions.com


            Comment


              #7
              Re: Link a personnel table to security tables

              Thanks Peter. I have all tables in SQL, i do not have any dbf. The document Felix provided above has helped a lot.
              I think i understand it enough to tackle it now, thanks to everyone for all the help.
              J.R.
              Epigate Software, LLC.

              [email protected]
              http://www.epigate.com
              sigpic

              Comment


                #8
                Link a personnel table to security tables

                .
                Hi J.R.
                I received your email (no duplicates!). Thank you for the encouragement. Looking at my files, I found this one which is quite similar to the one I posted above but might be of help:


                Regards,
                Felix
                .

                Comment


                  #9
                  Re: Link a personnel table to security tables

                  Thank you Felix, that is very in-depth and just what i had been looking for.
                  J.R.
                  Epigate Software, LLC.

                  [email protected]
                  http://www.epigate.com
                  sigpic

                  Comment


                    #10
                    Re: Link a personnel table to security tables

                    Not to rain on anyone's parade, but as of v11 Alpha discourages using the ulink value since IIS does not support it. Of course, you are still free to use it, but...
                    Peter
                    AlphaBase Solutions, LLC

                    [email protected]
                    https://www.alphabasesolutions.com


                    Comment


                      #11
                      Re: Link a personnel table to security tables

                      Gee Peter, it was a sunny day. lol

                      Well, i would rather do it right the first time, so what is the recommendation?
                      I am pretty new, but it is kind of strange that ulink will not work since it is just a variable referencing a value in a table. I am using other variables the same way. Now i'm concerned.
                      What is it about ulink that will not work?
                      J.R.
                      Epigate Software, LLC.

                      [email protected]
                      http://www.epigate.com
                      sigpic

                      Comment


                        #12
                        Re: Link a personnel table to security tables

                        I think what they are saying is that since IIS doesn't support it, they may drop it from security at some point. But it still works of course. Alpha suggests using the user_id which must be unique. Use A5ws_GetCurrentUser() to get it for the currently logged in user.
                        Peter
                        AlphaBase Solutions, LLC

                        [email protected]
                        https://www.alphabasesolutions.com


                        Comment


                          #13
                          Re: Link a personnel table to security tables

                          http://wiki.alphasoftware.com/Breaki...11#Ulink_Field

                          Lenny Forziati
                          Vice President, Internet Products and Technical Services
                          Alpha Software Corporation

                          Comment


                            #14
                            Re: Link a personnel table to security tables

                            I wonder what means that IIS will not support ULINK. I think ULINK is just unique value like any other unique value so certainly IIS will support it like any other unique value.

                            Maybe it is better say that IIS will not support current security model.

                            Comment


                              #15
                              Re: Link a personnel table to security tables

                              Originally posted by kkfin View Post
                              I wonder what means that IIS will not support ULINK. I think ULINK is just unique value like any other unique value so certainly IIS will support it like any other unique value.

                              Maybe it is better say that IIS will not support current security model.
                              Under IIS, the username is the unique key. Ulink will not be available. If you want relational data, the username should be used as the foreign key in your other tables now, as it must be used as the foreign key later if you want to run under IIS.

                              Lenny Forziati
                              Vice President, Internet Products and Technical Services
                              Alpha Software Corporation

                              Comment

                              Working...
                              X