Timetable with (almost) static data

doubleT

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.

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!).

AxLed

@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

ninjabreadman

@AxLed Honestly, I derailed the conversation with other ways it could be accomplished.

If you have apache2 and php serving up your .csv file, you’ve accomplished what you need to in a way that can easily be updated in future. You already solved the requirement with option A. You could change how you generate the table from the CSV, but that’s a lot of work with no real benefit.

If you want to post your CSV/HTML, we can maybe recommend ways to help style it, but you’ve already accomplished what you set out to do.

doubleT

Or maybe I derailed it when I looked at the question of “how to get the csv” after the thread already went to the iframe solution? :D
@AxLed Did you get the php page shown via iframe module?

A. Show the .php page via node

A. will not be able to show the php page via node – if you mean my suggestion. It will just get all echo’d content from the php file into the js module. So in this case it’s an over-complicated way of receiving the csv file into a module.

B. use the node_helper.js to open a .csv file and loop through the datas.

The node_helper.js should send the whole package back to the module.js and there it should loop through the datas.

If you have the php knowledge to build a page that reads a csv and shows the content, it shouldn’t be too hard to get into the necessary js. To build a module for the MM, the Readme in the module folder is the first step to go to.

AxLed

@doubleT said in Timetable with (almost) static data:

@AxLed Did you get the php page shown via iframe module?

Yes i did, see my screenshot:

Timetable and datas below is a .php Website, which runs local on RPI and is integrated in MM via MMM-iFrame

Axled

doubleT

Ah, true. If that works for you, I’d leave it at that. But then again, it’s always good to learn something new.
Do you want to try it yourself and maybe ask for help when you get stuck? Or maybe this would be an excellent case for a tutorial, I could try to do something like that.

pinsdorf

@AxLed, I also wanted to show today’s class schedules on my magic mirror. Those weekly schedules, e.g. at school or sports clubs, are very reliable and update only with a low frequency. So it is no big deal to change the config every now and then.

I’ve created a module MMM-WeeklySchedule to solve this for me. Feel free to give it a try. Feedback is most welcome.

Cheers.

alt text

AxLed

@pinsdorf
Thanks for the link an the name of your module, thats that what i was looking for. I will test it. I like your implementation with “starting time only” and “actual weekday only”, so this saves a lot of space in width to fit better to the other modules.

And you are right, if i change datas in an .csv or in a list in the config-file is pretty most the same.

Regards

Axled