Navigation

    APPDRAG Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular
    1. Home
    2. ec Organizer
    3. Posts
    E
    • Profile
    • Following 0
    • Followers 0
    • Topics 0
    • Posts 3
    • Best 1
    • Groups 0

    Posts made by ec Organizer

    • RE: Importing google sheets to create a data base

      Hi Jean,

      another option may be to try a csv to sql converter, i.e. https://www.convertcsv.com/csv-to-sql.htm

      Then go to your Cloud Backend > Databases > New query

      Screenshot 2021-03-17 at 22.27.18.png

      The copy the sql code to create the table

      Screenshot 2021-03-17 at 22.26.32.png

      I've actually built my own tool to create this 'create table' sql code to quickly replicate FileMaker tables in AppDrag 🙂

      posted in Cloud Backend (Cloud DB
      E
      ec Organizer
    • RE: Protect API from calls outside of the private area

      @Daniel-Mulroy Hi Daniel, thanks! And sorry about the Dick Honing / ecOrganizer confusion. I created a second account to test the sharing settings before handing handing it over to third parties and somehow this account got stuck in Safari ...

      Btw: can I contact you backchannel / via email?

      posted in General Discussion
      E
      ec Organizer
    • RE: Protect API from calls outside of the private area

      An area/web pages the user has access to after loggin in.

      The private pages then all have the following additional bit of Javascript to protect these pages from direct access without having logged in first:

      <script>
          //Wait for jquery to load before executing code
          addEventListener('JqueryLoaded', function(e) {
              var readEmail = sessionStorage.getItem('email');
              var readToken = sessionStorage.getItem('token');
              if (readEmail == "" || readEmail == null || readToken == "" || readToken == null) {
                  window.location.href = 'login.html';
              }
          }, false);
      </script>
      

      Now I also want to protect the API functions from being accessed by anybody what has not successfully logged into the private area ...

      posted in General Discussion
      E
      ec Organizer