1

(5 replies, posted in Suggestions)

Hi Roel

Yes, patch would be fine.  You can email me if you wish.

Otherwise the min of month test is adequate.

Pat

2

(5 replies, posted in Suggestions)

Hi Roel
When I bring up the Clean Up Functions page, the date fields for the clean up of 'Past events' and 'Inactive users are pre-loaded with a date that's a month earlier.  And yes I realise the dates must be a minimum of a month earlier.

The date fields for the others, that is, 'Attachments folder', 'Reciplists folder' and 'Thumbnails folder' are initially blank.

Yes I know that in all cases we can select dates in any of these fields from the date picker.  My preference however would be to have no pre-loaded dates when first bringing this page up, that is have all date fields initially blank until you consciously select dates as required. .

I am always cautious with pre-loaded fields in regard to accidental activation of clean up as there is no undo capability.

An alternative would be to have a confirmation pop-up before final clean up.

But don't get me wrong, this is a great new feature.

I have just upgraded our Club's system to V522.  I like the new features such as the transfer of event ownership and the clean up functions.

However, for the later (clean up), can we not have the pre-loaded dates (month old) for the 'Past events' and the 'Inactive users' when opening the clean up functions panel. I've warned our users to be careful in this panel as they may inadvertently click buttons with pre-loaded dates.

I don't know about others, but we often consult past events that are over a month old, particularly where we get high repeat customer numbers. But this would only be back to no more than two years, so we will cleanup for older events anyway.     

Not a big one and don't really need a setting for this.  A suggested code change would probably suffice.

4

(6 replies, posted in Suggestions)

Yes, that's about it Schwartz.  Luxcal is still the best system I've come across and that's why we use it.  There are calendars and there are booking systems but luxcal, for us at least, is adaptable to be both.  Because we have   a mixture of regular in-house events and one off booked events.
This year we will be upgrading our website to use Wordpress as the CMS to make it easier for others to maintain as I'm pulling back a bit.  Now I don't like Wordpress but it seems to be ideal for those in the club who would just update content and not make code changes .  But we will still retain luxcal.  I had used a small, very simple and free CMS called Responsee which allowed me to modify and create code, mostly php, to suit our needs and to create a system to manage our teams.  But our website is a bit tired now so hence the upgrade.

5

(6 replies, posted in Suggestions)

We only have 4 people who can log in and they manage the Calendar.  Then we have other volunteers who come and go and help with various aspects of events by customers. Almost all our people are older who have limited to no computer experience apart from emails, sms and facebook.  So setting up for all these other people as users with varying degrees of access is very difficult.  As it happens I'm the only one with IT knowledge.
To be honest. we don't use the events email function anyway.  It was just a thought to see if it could assist the Booking Officer.  If all it takes is to modify one line of code to make it acceptable, then that would probably do us.

6

(6 replies, posted in Suggestions)

Hi Shwartz.
Let me explain.  The 'customer' is not a user.  We use the system as follows.
1.  An external customer initially requests facilities hiring information via a web based contact form on our website.  This gets emailed to the Booking Officer.
2. Our Booking Officer responds with the necessary hiring information and sends a Booking Form to the external customer who then fills it out and sends back.
3. Our Calendar now comes into play.  The Booking Officer - who is the user with admin rights - fills in the necessary event booking information in the calendar.
4.  The Booking Officer then sends an invoice - MYOB generated - to the external customer for the booked event via email.  When the external customer pays the invoice, we change the category of the event.

In the meantime, there are other people i.e. volunteers, in the club who will view the calendar regularly.  They may have varying degrees of access e.g. Admin or Manager or Read Access.  This allows these volunteers, who may be assisting with the event just booked, to know whats going on.   In fact we also use Display 1 to show upcoming events, again for the benefit of our volunteers and helpers.

The external customer in the meantime is not aware of our calendar and as far as they are concerned the booking was made and they then turn up for their booked event at the Club.

It would be nice to generate an email message and perhaps an SMS message, to be sent to the external customer to confirm their booking.  Like the 'Send email' on the event panel.  The external customer does not need to know we run luxcal or how we manage our bookings.  They just want to know that we have booked them in.

I have tested the 'Send email' to external people and they can view the calendar via the link at the bottom, albeit at Read Access level only, even though they are not users.

We are a lawn bowling club in Perth, West Australia. We use luxcal extensively to manage our facilities bookings which is our financial lifeblood.  Primarily, we have two types of events.  One is in-house events and regular users events and the other is one off customers who book our facilities for functions.  Thus we operate with 'customers' who make 'bookings' with us for their events.

It would be nice to email  these 'customers' the confirmation of their 'booking'. This would be similar to  "Send email" function on the events pop-up panel.   We have played around with this is and it could probably be ok for us to use.  However the email message has an 'Open calendar' link at the bottom of the message.  We would like to not have this link as we don't allow 'customers' to view our calendar for multiple reasons.

I have looked at the files to see where it's generated and think it's in messaging.php around line 190 (V521).  If I disable this line I assume the 'Open calendar' link would not appear.

Now for the suggestion.  How about having an ability to send an email message to the 'customer' who would receive most of the event data but without the ability to access the calendar.

Luxcal has been used by our Bowls Club for our bookings since 2017 and it's great in helping us to manage our business which keeps us afloat.  It's also run by older age volunteers with little computer knowledge.

A couple of suggestions.

1.  One issue we have is deleting old users who may have left the club or no longer run the calendar.  If we delete them as users all the event entries associated with them are no longer viewable/accessible.  We sometimes need to do this for security reasons (disgruntled old members or departing staff). 

As a solution I allocate them to the 'no access' group.    But is there a way of allocating their event entries to another user so that we can delete them as a user ?  Maybe a swap user tool i.e. to swap names in the 'editor' column in the 'events' table.

2.  Server space is sometimes critical so culling or deleting old '\attachments' files is a way of freeing up space.  When I edit the event and remove the attachment file, it doesn't seem to delete it from the \attachments folder.
Can we have say a cleanup tool to delete old '\attachments' files if they are no longer referenced in the 'events' table.

I'm trying to upgrade from V475 to V521 but have struck an error.  According to the error log, it comes up with the following errors ..

ERROR Script: /luxcal/display1p.php - SQL query error: SQLSTATE[42S22]:
Column not found: 1054 Unknown column 'c.olapGap' in 'field list'

... and seems to be related to the displayx.php files.  The above error message is the first of many in the log file.

The PHP version running on the server is V5.5.34

Has the structure of the database tables changed i.e. more columns ?
If so, do I need to prep the tables with these new columns ?

I do make copies of database tables via phpMyAdmin in csv format.  So I haven't lost any data and have re-instated the older version (V475) for now. 

But the PHP Session Timeout issue is a BIG PROBLEM for us so am keen to upgrade asap.

I have noticed that the upgrade script has prepared the database tables (mycal_....etc ) by creating a copy of all tables and appending X at the end.

I can send the SQL error log file if required.