Alpha Custom Database Solutions, LLC
Committed to the pursuit of excellence in quality, service and value.
Welcome to ACDS DHX Scheduler

ACDS DHX Scheduler

Introduction

Alpha Custom Database Solutions, LLC (ACDS) ACDS DHX Scheduler is a custom user defined web component addition for use with Alpha Software's Alpha Anywhere RAD environments (A5). It is only supported for use in A5 browser/mobile based applications (A5 desktop and A5 WCD are not supported). A supported SQL backend is required. There is no support for DBF tables. The component uses a builder, much like native Alpha Five web components, to add a third party scheduler control, DHX's dhtmlxScheduler, a product of Dinamenta, UAB, to your web project. You are responsible for obtaining a license to use the DHX Javascript libraries. A license to use the DHX libraries is not included with the ACDS DHX Scheduler.

The DHX Scheduler control is independently owned, licensed, and maintained by DHX. License terms, pricing, and the DHX documentation can be found on the DHX  web site.

dhtmlxScheduler is a JavaScript event calendar that allows you to add a Google-like scheduler to your web app or website. Intuitive drag-and-drop interface allows the end users to quickly manage events and appointments in different views: Day, Week, Month, Year, Agenda, Timeline, etc. Very lightweight (about 20Kb gzipped), highly customizable, and fast, dhtmlxScheduler provides a quick way to add an Ajax-based event calendar on a web page.

The ACDS DHX Scheduler uses the DHX dhtmlxScheduler Javascript libraries and custom Xbasic code to give the A5 developer a scheduler to use in A5 web projects with full interaction to a SQL backend. Currently tested and supported databases are MySql, Maria DB, Oracle, postgreSQL, Access, and MS SQL Server. Database interaction is accomplished using Alpha's AlphaDAO and portable SQL for seamless support of various databases. Once the necessary SQL table and AlphaDAO connection string is in place a scheduler can be added to a web project with a few clicks of the mouse. No other coding is required for a basic scheduler control. The ACDS DHX Scheduler builder allows for custom HTML to be inserted above and below the scheduler and also provides both pre-initialization and post-initialization Javascript sections that allow the developer to leverage the powerful and feature rich DHX Scheduler API.

Minimum Requirements

  • Alpha Anywhere Version 12 Developer and Application Server
  • Administrator access for installation.
  • An Alpha Five Web Application. Desktop and Desktop web are not supported.
  • A supported SQL back end database with the required database schema. (MySQL, MariaDB, MS SQL Server, PostgreSQL, Access, Oracle) See the section "SQL Table Requirements" for more information.
  • A license to use the third party DHX Javascript files. See the DXH website for current license information. DHX

Initial Installation

After purchasing ACDS DHX Scheduler, you will receive an email with a link for downloading the installer as well as your license key. You will need the key to install. There is a video that shows the installation process located at: http://www.a5customsolutions.com/dhx_scheduler_videos.html

SQL Table Requirements

The scheduler requires a sql table. Below are the minimum requirements for the table structure for use in the ACDS DHX Scheduler control.

The tasks table requires four columns. Additional columns, for the various views and options, can be added. Up to five user defined columns, in addition to the required columns can be added for additional data the user defined column inserts and edits will be persisted back to the database. See the section on user defined columns for more detail. An example of the table structures in MySQL is below. Adjust the column types for your database.

/* MySQL format */

CREATE TABLE `tasks` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`text` varchar(255) NOT NULL,

`start_date` datetime NOT NULL,

`end_date` datetime NOT NULL,

PRIMARY KEY (`id`)

)

User defined additional columns in the tasks table.

The ACDS DHX Scheduler component builder allows for the use of up to five additional columns in the tasks table. These can be most data types. The data in the columns will be sent to the client and can be used in the scheduler. Changes made to the values of the custom columns are persisted back to the database when their values are changed in the scheduler. See the video on custom task columns for more information. http://www.a5customsolutions.com/dhx_scheduler_videos.html

Creating your first ACDS DHX Scheduler

For a detailed overview of creating your first ACDS DHX Scheduler there is a video located at: http://www.a5customsolutions.com/dhx_scheduler_videos.html

Support

Alpha Custom Database Solutions, LLC (ACDS) will provide email support, for ACDS DHX Scheduler licensed users, for a period of 30 continuous calendar days, starting with the date that the ACDS DHX Scheduler license key is sent.

ACDS support is limited to the function of the ACDS Alpha Five custom component and Xbasic code associated with the builder and used for the database CRUD operations.

Questions or issues involving the dhtmlxScheduler control libraries, and its support libraries, both Javascript and CSS, are not included.

Copyright © 2015 Alpha Custom Database Solutions, LLC

A help file, in HTML format is available at the clicking this link: HTML HELP FILE

A PDF of the same help file can be downloaded by clicking this link: PDF HELP FILE