We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 10164
    • 27 Posts
    Hi
    I am looking to build a site, a business to business site. the function is to take complex orders using eForm, there will be some sensitive information so i have an idea of using a shared SSL certificate, and the http://modxcms.com/Encryption-1229.html Encryption snippet behind WebLoginPE.
    Web users will be manually added by the site administrator to keep it extra secure.
    I think all this is possible in MODx, However the one thing I am not sure of...
    When a user logs in, they are redirected to a page, (as specified in WebLoginPE), BUT i need to be able to add an .XLS spreadsheet which is unique to that user.
    To clarify, i need to send data to the log in page which is unique to the user, an XLS spreadsheet with invoice/billing details for that month.
    How would MODx handle this??
    Any ideas greatly appreciated.
    Thanks
      • 28042 ☆ A M B ☆
      • 24,524 Posts
      Depending on where this spreadsheet would be coming from...

      I have one site with a database table of client information, with one key being the client name. So when the client logs in, he’s sent to the page with the datagrid, and an AJAX application loads the datagrid with the first page of that user’s data. So I would suppose it would not be any more difficult to get an .xls file from wherever they’re stored, based on the logged-in user’s name.

      I discuss the creation of this application and the creation of the original module for back-end management of the same database (including csv import) in two sets of articles on my site.
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 10164
        • 27 Posts
        Thanks Sottwell.
        I was hoping you would be around to answer this.
        I have spoke with the client, they want the same set up as they have right now, which is, a /user_folder/ on the server somewhere, they manually update and upload the xls file by ftp.
        So the question is now, can webloginPE be used to redirect to a /folder/ depending on the user name login?
        Thanks
          • 29774
          • 386 Posts
          @Fresh79

          I’d just like to point out that storing the documents in a folder under the webroot, as you propose, will not provide security for the information in any sense. Security by obscurity != security. If you want real security you will need to store the xls documents in the database rather than the filesystem. I would suggest writing a module to manage this.
            Snippets: GoogleMap | FileDetails | Related Plugin: SSL
            • 28042 ☆ A M B ☆
            • 24,524 Posts
            I set up one site to do this, the client updated an xml file and I used PHP’s simpleXML parser to display the desired fields from the xml file.

            It wasn’t rocket science, but it wasn’t simple, either. It had a simple form to determine which fields to access from the xml file; their clients had their own company codes and identifiers that were used. As they say in Texas, I’ve slept since then, and really don’t remember the details. I may have a backup of the code around here somewhere; I’ll see if I can dig it out.
              Studying MODX in the desert - http://sottwell.com
              Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
              Join the Slack Community - http://modx.org