Appointments Module in Servoy - mfModuleAppointments

Classic Servoy
1

Hello everybody,

It is immense pleasure for us to release Appointments Module in Servoy - mfModuleAppointments, developed in Servoy which can be embedded with any existing Servoy application to serve user appointments. This module provides an efficient way to maintain appointments. A user can create and manage its own appointments. A good and user friendly interface, with keyboard shortcuts and context menus allowing easy access as well as easy handling of the appointments. This module is both Smart and Web client compatible. Internationalization is implemented for multi language support.

Preferences for the application can be set by Admin users. Multiple concurrent appointments at a particular time for a user are possible. User is notified by the application before the start of an appointment for which the time duration of sending alerts is configurable in Settings section.

Another module called “mfModuleBatchprocessor” is created. This module will work as a batch processor and will run in the Servoy Server as a Headless Client. This headless client periodically checks the upcoming appointments and sends e-mail notification to the respective users about their upcoming appointments.

There are two modules. The first one is used to create, manage and to display the appointments. And the second one is used as the Headless client to serve email notifications.

1.mfModuleAppointments
2.mfModuleBatchprocessor

Some salient features of this application are:

  • Create and manage own appointments.
  • Recurrence Support
  • Good user friendly interface with keyboard shortcuts and context menus for easy handling of appointments
  • Both Smart and Web client compatible.
  • Multi-language support.
  • Multiple concurrent appointments at a particular time are possible.
  • E-mail notification sent about upcoming appointments as well as on screen appointment reminder available.

For more details & download : http://www.mindfiresolutions.com/servoy … module.htm

Any feedback/comments are highly appreciated.

2

Nice job, guys! Thanks for sharing it with the community!

3

+1

4

Nice one guys, yes.

Did you ever considered using ServoyForge to host your projects?
That’s what it’s here for!

5

ptalbot:
Nice one guys, yes.

Did you ever considered using ServoyForge to host your projects?
That’s what it’s here for!

+1 :-)

6

If it is on SourceForge then the community could help to support it, enhance it, fix it etc.
Or is it proprietary?

7

ptalbot:
Nice one guys, yes.

Did you ever considered using ServoyForge to host your projects?
That’s what it’s here for!

+1

8

Thanks for the contribution.

Greetings.

9

ptalbot wrote:Nice one guys, yes.

Did you ever considered using ServoyForge to host your projects?
That’s what it’s here for!

+1

10

Works for both smart and web client.
Very nice. Thank you!

Dean Westover

11

Thank you all for your appreciation.

ptalbot:
Nice one guys, yes.

Did you ever considered using ServoyForge to host your projects?
That’s what it’s here for!

I could not find a way to host the application in ServoyForge. Can you please help on this.

12

You can find all the information here:
https://www.servoyforge.net/projects/se … ateProject

13

Thanks for sharing the link.

14

Hi,

When I launch the solution I get this error: Cannot rander the Calendar. Please Restart the application!

15

jasantana:
Hi,

When I launch the solution I get this error: Cannot rander the Calendar. Please Restart the application!

Hi, did you import the solution in a Postgres db?

I also had this error. The problem is in

	var apptDataset = databaseManager.getDataSetByQuery(datasource, 
		sqlQuery, [globals.mfcal_g_getUserIDx(), 
		utils.dateFormat(monthViewStartDate, 'yyyy-MM-dd HH:mm:ss'),
		utils.dateFormat(monthViewlastTime, 'yyyy-MM-dd HH:mm:ss')], 10000);

I think that Postgres expect a date instead of a string.
I searched all the databaseManager.getDataSetByQuery and replaced the utils.dateFormat(, ‘yyyy-MM-dd HH:mm:ss’) with and it worked.

16

victor.rojo:
I think that Postgres expect a date instead of a string.

That is correct. PostgreSQL doesn’t implicitly cast strings to a date (anymore).

17

victor.rojo:

jasantana:
Hi,

When I launch the solution I get this error: Cannot rander the Calendar. Please Restart the application!

Hi, did you import the solution in a Postgres db?

I also had this error. The problem is in

	var apptDataset = databaseManager.getDataSetByQuery(datasource, 

	sqlQuery, [globals.mfcal_g_getUserIDx(), 
	utils.dateFormat(monthViewStartDate, 'yyyy-MM-dd HH:mm:ss'),
	utils.dateFormat(monthViewlastTime, 'yyyy-MM-dd HH:mm:ss')], 10000);




I think that Postgres expect a date instead of a string.
I searched all the databaseManager.getDataSetByQuery and replaced the utils.dateFormat(<date>, 'yyyy-MM-dd HH:mm:ss') with <date> and it worked.

Thanks Victor that did the trick. I got it working now

18

For this module we have used MySQL.

victor.rojo:
I think that Postgres expect a date instead of a string.
I searched all the databaseManager.getDataSetByQuery and replaced the utils.dateFormat(, ‘yyyy-MM-dd HH:mm:ss’) with and it worked.

Yes you are right for PG you need to use only date without any formatting.
Thanks Victor Rojo for sharing this information.

19

Someone has tested to use this module in an application based on the servoy navigation framework ?
I receive an error (“Cannot rander the Calendar. Please Restart the application!” when the main form is opened and i can’t see the months panel on the left…

20

michele:
Someone has tested to use this module in an application based on the servoy navigation framework ?
I receive an error (“Cannot rander the Calendar. Please Restart the application!” when the main form is opened and i can’t see the months panel on the left…

I think the solution for your problem is some posts ago. It might be the SQL to retrieve the data and the dates format