MagicMirror Forum
    • Recent
    • Tags
    • Unsolved
    • Solved
    • MagicMirror² Repository
    • Documentation
    • 3rd-Party-Modules
    • Donate
    • Discord
    • Register
    • Login
    A New Chapter for MagicMirror: The Community Takes the Lead
    Read the statement by Michael Teeuw here.

    Timetable with (almost) static data

    Scheduled Pinned Locked Moved Requests
    16 Posts 5 Posters 7.2k Views 5 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A Offline
      AxLed Module Developer
      last edited by

      Hi, i am looking for a possibility to enter a timetable for my kids, which is based on static datas and change only on a yearly base.
      My idea would be to have a file (.txt/.csv) somewhere in the filefolders of magic mirror. I can probably realize it by .php but i dont have a clou how to show this in MM2 (as i would like to run the .php directly on the raspberry pi.

      Best regards

      Axled

      1 Reply Last reply Reply Quote 0
      • OdomLinxO Offline
        OdomLinx
        last edited by

        Use the Module iframe to Display the php Site

        1 Reply Last reply Reply Quote 0
        • A Offline
          AxLed Module Developer
          last edited by

          Hi OdomLinx,
          i tried this, but i dont know where to run my php site on the raspberry pi:

          • does Raspian/MM2 support .php
          • where do i have to save the files and what will the (web)path be?
            Axled
          1 Reply Last reply Reply Quote 0
          • A Offline
            AxLed Module Developer
            last edited by

            So, now i installed apache2 and php on my test system (ubuntu vm). I got a first solution with a .php site (running on same machine) and MMM-iFrame pointing to local php site.

            Here is a first screenshot:
            0_1516830260556_timetable.JPG

            My Webfolder looks like this:
            0_1516830359419_www-folder.JPG

            • index.html (comes from apache2)
            • phpinfo.php (was a testfile to check if php works)
            • timetable.php (is my php site, which reads the datas of timetable.csv, so it is easier to change datas once a year)

            Right now i am fighting with css and formatting, but the first steps are made.

            I am not sure what the performance on RPI will be with apache2 and php running next to MM2.

            Axled

            N 1 Reply Last reply Reply Quote 1
            • N Offline
              ninjabreadman @AxLed
              last edited by

              @AxLed To answer your question, apache2 or xginx serving a single static page without (image) assets will have a negligible footprint and cause minimal load, certainly not noticeable with everything else the Pi is doing for MM and Node.js.

              As for your layout and styling question, I quickly Googled this layout here, which might help, and comes with example markup and styling (and explanatory article): https://codyhouse.co/demo/schedule-template/index.html

              Problem with config or JavaScript? Copy/paste it into JSHint.
              Check out the detailed walkthroughs on install, config, modules, etc.

              1 Reply Last reply Reply Quote 0
              • D Offline
                doubleT Module Developer
                last edited by doubleT

                Node can execute a php – if a php.ini is in the PATH – with this in the node_helper.js :

                const runner = require("child_process");
                runner.exec("php " + proxy + " " + params, function(err, data, stderr) {
                //         ("php timetable.php parameter", function(err, data, stderr) {
                    var content = data; // "Clean your room - now!"
                    this.workWithTheData(content);
                });
                

                timetable.php :

                < ? php // remove spaces
                $params = explode(",", $argv[1]); // example, you can leave parameters out (see above)
                $content = "Clean your room – now!";
                echo $content;
                ?>
                

                Now that we know we can, let’s talk about if we should: I like it, I use it for a proxy to call APIs while ignoring CORS. BUT I don’t think it makes sense in this case! It’s like using a hammer to fix a loose screw.

                To show a static website in the iframe, HTML is enough. Do you really need server side scripts?

                If you want a csv, use this in the node_helper.js :

                const fs = require("fs"); // before module.exports = ...
                
                getTimeTable: function() {
                    var rawdata = fs.readFileSync('modules/my-module/file.json'); // or txt or csv
                    var timetable = JSON.parse(rawdata); // in this case
                    this.sendSocketNotification("Response", timetable);
                }
                

                EDIT: I know that for users with basic HTML or even PHP knowledge, the iFrame solution is an easy win. Use runner or fs if you want to import data directly into your own module.

                N 1 Reply Last reply Reply Quote 2
                • N Offline
                  ninjabreadman @doubleT
                  last edited by ninjabreadman

                  @doubleT Not exactly. More like making and keeping around a hammer for the occasional tiny nail. Locally loading an HTML file absent a server is more akin to hammering with the handle is a screwdriver. ;)

                  Will the existing instance of Server in server.js not serve files in the /modules directory? Like an iframe of /modules/MMM-iframe/sched.html? If not, could you add a /static or similar folder to directories? As you say, seems overkill to (1) run an apache2 instance, but even to (2) create a separate webserver in Node, given that MM already runs one that can be used or modified.

                  Apologies all, I’m posting from my phone on vacation, so am speaking before properly testing.

                  Problem with config or JavaScript? Copy/paste it into JSHint.
                  Check out the detailed walkthroughs on install, config, modules, etc.

                  1 Reply Last reply Reply Quote 0
                  • D Offline
                    doubleT Module Developer
                    last edited by

                    Actually, I wasn’t really thinking about loading a page and displaying it (in an iFrame) but I rather looked at the questions of loading file contents and suggested the runner.exec child process because php was specifically mentioned (I don’t think PHP is necessary at all).

                    If we’re talking about HTML, I’d agree with you (also without testing, though). But for PHP within Node.js: That won’t work, you’d have to have a PHP server running parallel to node and address it, etc. My suggestion (runner.exec child_process) doesn’t run a server but executes that one file with PHP and returns what it parsed.

                    N 1 Reply Last reply Reply Quote 1
                    • N Offline
                      ninjabreadman @doubleT
                      last edited by ninjabreadman

                      @doubleT D’oh! I totally overlooked the PHP requirement in contemplating a revised approach. Given it’s already written, probably not worth porting the code to native js. ¯\_(ツ)_/¯

                      @AxLed could however view the PHP file, save the generated HTML, and then serve the static file (until next semester, anyway!).

                      Problem with config or JavaScript? Copy/paste it into JSHint.
                      Check out the detailed walkthroughs on install, config, modules, etc.

                      1 Reply Last reply Reply Quote 0
                      • A Offline
                        AxLed Module Developer
                        last edited by

                        @doubleT and ninjabreadman

                        My request was to show a timetable, where i can change the datas in an .csv file.
                        The only way i knew to realize this was via php. So thats the reason why i tried this via apache2 an php which worked (somehow).
                        If i understood you right, there are to ways to solve my request:
                        A. Show the .php page via node
                        B. use the node_helper.js to open a .csv file and loop through the datas.

                        If i am right, i dont know what do i need for Way A and Way B, as i dont know (right now) how to write a own module.

                        I am looking forward hearing from you.

                        Best regards

                        Axled

                        N 1 Reply Last reply Reply Quote 0
                        • 1
                        • 2
                        • 1 / 2
                        • First post
                          Last post
                        Enjoying MagicMirror? Please consider a donation!
                        MagicMirror created by Michael Teeuw.
                        Forum managed by Sam, technical setup by Karsten.
                        This forum is using NodeBB as its core | Contributors
                        Contact | Privacy Policy