phpScheduleIt2 alpha 1 feedback wanted!

[dunnts2]

Nick,
-i downloaded the version you pointed to http://sourceforge.net/projects/phpscheduleit/files/1.%20phpScheduleIt/2.0.0%20Alpha/
-installation does not goes well. I thought I followed the instruction from "unzipped-package"/phpScheduleIt/readme.html
-there are 2 issues: 1) the page http://localhost/phpScheduleit/Web/ does not load until i restart the machine 2) the database is failed to create attached is the screen shot - and i am stuck here
- installation on: mac lion, apache2.x, php 5.3.6, mysql 5..5.16
- my guess of the issue is something has to do with permission of creating database in mysql
- below is log file from apache error out
****

[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP Warning:  fopen(../../database_schema/create-db.sql): failed to open stream: Permission denied in /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php on line 173, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP Stack trace:, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   1. {main}() /Library/WebServer/Documents/phpScheduleit/Web/install/index.php:0, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   2. InstallPage->PageLoad() /Library/WebServer/Documents/phpScheduleit/Web/install/index.php:7, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   3. InstallPresenter->PageLoad() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:259, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   4. InstallPresenter->RunInstall() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:366, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   5. Installer->InstallFresh() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:455, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   6. Installer->ExecuteScript() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:85, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   7. MySqlScript->GetFullSql() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:122, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   8. fopen() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:173, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP Warning:  fread() expects parameter 1 to be resource, boolean given in /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php on line 174, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP Stack trace:, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   1. {main}() /Library/WebServer/Documents/phpScheduleit/Web/install/index.php:0, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   2. InstallPage->PageLoad() /Library/WebServer/Documents/phpScheduleit/Web/install/index.php:7, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   3. InstallPresenter->PageLoad() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:259, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   4. InstallPresenter->RunInstall() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:366, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   5. Installer->InstallFresh() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:455, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   6. Installer->ExecuteScript() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:85, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   7. MySqlScript->GetFullSql() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:122, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   8. fread() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:174, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP Warning:  fclose() expects parameter 1 to be resource, boolean given in /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php on line 175, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP Stack trace:, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   1. {main}() /Library/WebServer/Documents/phpScheduleit/Web/install/index.php:0, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   2. InstallPage->PageLoad() /Library/WebServer/Documents/phpScheduleit/Web/install/index.php:7, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   3. InstallPresenter->PageLoad() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:259, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   4. InstallPresenter->RunInstall() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:366, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   5. Installer->InstallFresh() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:455, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   6. Installer->ExecuteScript() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:85, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   7. MySqlScript->GetFullSql() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:122, referer: http://localhost/phpScheduleit/Web/install/index.php
[Tue Oct 25 10:01:02 2011] [error] [client ::1] PHP   8. fclose() /Library/WebServer/Documents/phpScheduleit/Pages/InstallPage.php:175, referer: http://localhost/phpScheduleit/Web/install/index.php


****


Attachments were too large for the forum so i had to send it via email to Nick.

[mr626]

Just tried out the online demo site for the beta version- looking great! Thanks for all your hard work with this.

[ricoj1321]

I work for a major university that is using your system for internal reservations. I took a few minutes to look over 2.0 and I love the additions, specifically to the actual resources sections. Few items:
1. Limited admin acounts that can simply approve reservations for sub-resources - basically a better user and group management system
2. the initial load of Dashboard would be best if it retained the sidelinks from 1.x version. Maybe not all of them, but at least for admins if it contained : Approve Reservations, Bookings rather than just your current reservations. Thanks!

[Nick]

1. Limited admin accounts that can simply approve reservations for sub-resources - basically a better user and group management system

I'm planning on adding resource admins who would essentially do what you describe.  Haven't fully thought it out yet, though.

2. the initial load of Dashboard would be best if it retained the sidelinks from 1.x version. Maybe not all of them, but at least for admins if it contained : Approve Reservations, Bookings rather than just your current reservations.

The header in 2.0 should contain everything that the 1.x dashboard page had.  Reservation approval can be accessed from the Manage Reservations menu item.  Does this work, or are you looking for something different?

[Arokh]

Very nice demo indeed!

I'm running 1.2.12 now with several mods regarding permissions -- or rather restrictions on what users should be able to do and see. So here are some questions for 2.0:

• Will it be possible to set permissions for schedules?
• Will there be a way to hide a resource (from the schedule, as well as its bookings from the calendars), if the user doesn't have access to it?
• In 1.2 blackouts could be defined in much the same way as other reservations. This way one could add i.e. a recurring blackout on a specific day of the week, or a single blackout of a few hours, without having to change the schedule. In the 2.0alpha I saw only the very basic 'Layout Editor' to define blackouts.

Thanks for this nice software and I'll look forward to 2.0 

[npap]

Hello

I have almost the same problem as dunnts2

I follow the instructions in readme.html but when I try to see the application, I only see a blank page.,

My log file from apache error out is:

Code:

[Mon Oct 31 23:56:44 2011] [error] [client ::1] PHP Fatal error:  Uncaught exception 'Exception' with message 'Datasource file does not exist.' in /var/www/html/phpScheduleIt/lib/Config/Configuration.php:73\nStack trace:\n#0 /var/www/html/phpScheduleIt/lib/Config/Configuration.php(55): Configuration->Register('/var/www/html/p...', 'phpscheduleit')\n#1 /var/www/html/phpScheduleIt/lib/Common/Resources.php(176): Configuration::Instance()\n#2 /var/www/html/phpScheduleIt/lib/Common/Resources.php(45):
Resources->GetLanguageCode()\n#3 /var/www/html/phpScheduleIt/lib/Common/Resources.php(56): Resources::Create()\n#4 /var/www/html/phpScheduleIt/Pages/Page.php(27): Resources::GetInstance()\n#5 /var/www/html/phpScheduleIt/Pages/LoginPage.php(25): Page->__construct('LogIn')\n#6 /var/www/html/phpScheduleIt/Web/index.php(8): LoginPage->__construct()\n#7 {main}\n  thrown in /var/www/html/phpScheduleIt/lib/Config/Configuration.php on line 73

Any idea what is the problem


Sorry but I had to read more carefully file readme.html. There is a good reason that Nick wrote it and put it there!!
I forgot to rename config.dist.php

 

[Nick]

Code:

Will it be possible to set permissions for schedules?

I hadn't considered this, but it should be pretty simple to add.  I'll put it on my list.

Code:

Will there be a way to hide a resource (from the schedule, as well as its bookings from the calendars), if the user doesn't have access to it?

   
There is a config option to hide resource that users don't have permission to.

Code:

In 1.2 blackouts could be defined in much the same way as other reservations. This way one could add i.e. a recurring blackout on a specific day of the week, or a single blackout of a few hours, without having to change the schedule. In the 2.0alpha I saw only the very basic 'Layout Editor' to define blackouts.

At this point I hadn't given one-off blackouts much thought.  Does the approach in 1.2 work well?  Is there a better way to make a specific time unavailable?

[yuma_nishizaki]

Hello, I used ver 2.0 demo.
I think after I used this demo, "Admin"-"Manage Schedules" menu seems to stopping(error message displays).
So I posted this reply.

I think I have done is following;
In "Admin"-"Manage Schedules" menu, I set "every 1440 minutes" and "0:00 - 24:00" or "0:00 - 23:59".

I am sorry to down your demo (if my action cause this) and very happy if this post contributes you.
Thanks.

[saeed]

Hi Nick,
Has the/will the ability to check items back in on return made it into the 2.0 release?

[Lazi]

Hi again!

Nick, when I set e.g. "Reservation cannot last more than 03:00" as admin and later as user I try to reserve some resource for more than mentioned 3hrs I receive:

Code:

Fatal error: Cannot use object of type DateDiff as array in /home/nkorbel/public_html/demo2/lib/Common/Resources.php on line 93

BTW how can I define limit for reservation resource for e.g. 3 months? Few weeks ago we spoken in this thread about it. Will be great to have separate fields [Years] [Days] [Hours] [Minutes].

[Arokh]

Code:

Will it be possible to set permissions for schedules?

I hadn't considered this, but it should be pretty simple to add.  I'll put it on my list.

Code:

Will there be a way to hide a resource (from the schedule, as well as its bookings from the calendars), if the user doesn't have access to it?

   
There is a config option to hide resource that users don't have permission to.

Thanks Nick. I'm at a German university and we manage access to our spectrometers for several research groups. Right now, I have a single schedule with multiple resources setup and several hacks to distinguish between users, because the different groups all have access to some, but not all, resources. The single-schedule mode is convenient for those with high-level access, whereas the "low-level" users could just as well use multiple schedules. So both types of permissions/ways of grouping resources would be useful for us.

Code:

In 1.2 blackouts could be defined in much the same way as other reservations. This way one could add i.e. a recurring blackout on a specific day of the week, or a single blackout of a few hours, without having to change the schedule. In the 2.0alpha I saw only the very basic 'Layout Editor' to define blackouts.

At this point I hadn't given one-off blackouts much thought.  Does the approach in 1.2 work well?  Is there a better way to make a specific time unavailable?

For me the 1.2 approach works well, because we have different reasons for blackouts. The spectrometers run (and therefore can be booked) 24/7 but there is scheduled maintenance in a weekly (i.e. Wednesdays 08-10am) and monthly (i.e. every first Monday of every other month) fashion. These are known in advance and the admin can blackout the respective time slots similarly to a repeating reservation. In addition there are irregular events (tests, implementation of new experiments, recalibration, etc...), in which case the admin can blackout time slots a couple of days in advance. These are not known too long in advance and the admin needs a way to prevent users from booking only a couple of time slots, while still allowing them to make reservations before and after the blackout.

I can't really tell you if there's a "better" way to make time unavailable, but for me the 2.0alpha Layout Editor is a little too simplified, while the 1.2 approach works just fine.

[Nick]

Has the/will the ability to check items back in on return made it into the 2.0 release?

I'm planning on it.

[Nick]

Few weeks ago we spoken in this thread about it. Will be great to have separate fields [Years] [Days] [Hours] [Minutes].

It's a great suggestion.  I'll be making that change before the official 2.0 release.

[Lazi]

I'll be making that change before the official 2.0 release.

By the way, if You mention this. When we can expect release? In weeks, months? :-)

[Nick]

The second alpha revision is available for download!

https://sourceforge.net/projects/phpscheduleit/files/1.%20phpScheduleIt/2.0.0%20Alpha/

This includes all features and bug fixes since 2011.10.24 and attempts to simplify the installation.