<<Home

ALPHA CALENDAR PRO
USER GUIDE

Alpha Calendar Pro current version: 1.4.2
Release Date: 02/Nov/2010
Documentation last update: 02/Nov/2010
Section(s) updated: 6. Troubleshooting

 Notes:

Index

1. Installation

2. Setup and testing

3. Using Alpha Calendar Pro

4. Troubleshooting

5. Vesrion History

6. Ask Us Live

 

1. Installation

Notice: In this document we will call “Main Database“ to the database which contains the tables that you want to display on the calendar

  1. First unzip the Alpha Calendar’s Folder to the desired location
  2. The Alpha Calendar folder should contain the next folders:
    • Alpha_Calendar: The actual application used to connect your alpha five applications with Flash Calendar Pro.
    • Scheduling_app: Included tables for events, categories and locations that you can optionally use as your data source

IMPORTANT: If you have a registered full copy of Flash Calendar Professional’ you should go to your web project folder (under your webroot) and replace the files contained in the "Alpha_Calendar_WebFiles" folder with your full copy files.

 

1.1 Web Security Framework
(Skip this section if your security framework is deactivated)

For testing purposes, it’s recommended to first setup Alpha Calendar with Web Security Framework tuned off on the server

If the Web Security Framework is activated on the server you should follow these steps before you begin alpha calendar’s setup:

  1. Open your Main Database
  2. Go to Web Projects / A5w Pages
  3. Add all the A5W pages that are inside the *Alpha_Calendar Folder/Alpha_Calendar.WebProjects/Default.WebProyects folder by clicking the ‘add file’ option on the toolbar. IMPORTANT: Opening alpha calendar’s a5w pages on the Alpha Five WYSIWYNG editor will damage the contained JavaScript code permanently.
  4. Set the security for these pages to either ‘always allowed’ or ‘requires login’ depending on your needs by right clicking each a5w page and going to the ‘page security’ option.
  5. Go to 'security settings' (key icon on the web projects toolbar) then go to 'Page Security' / 'file types always allowed' and add the next file types to the list
    • *.xml
    • *.swf
  6. Go again to 'security settings' and re-publish all the security files.

 

*This is the directory where you placed the Alpha_Calendar folder.

 

2. Setup and testing

2.1 Running the setup

Open the Alpha Calendar Pro database located under the ‘alpha_calendar’ folder and follow the on-screen instructions or watch the video tutorials.

2.2 Notes about SQL connections and active tables

DO NOT use "named connections" when creating Active Link Tables for events, locations or categories. Use the "Ad hoc Connection String" option instead.

Using Time fields (Y) on a SQL table will cause errors when making an Active Link table, instead use Datetime fiels to represent time.

2.3 Transfering a setup from a test server to a production server when the production server does not have an Alpha Five Developmer License Installed.

If you need to run Alpha Calendar Pro in a server that does not have an copy of Alpha Five Developer installed you should follow the next steps to copy all the required files from your test machine to the production server (we will assume that the folder schema on the test machine is identical to that on the production server):

  1. In your test machine open alpha calendar and enter your License Key, a message will appear saying that the "License Key is incorrect" just ignore it.
  2. Do a "fast and simple" setup and test it to see if everything is working as needed
  3. Once the calendar is working correctly, go to "advanced complication" setup and enter your Production sever name and the port in which the production WAS is working ("80" for most cases)  
  4. Re-Publish the files (you wont be able to test the calendar in your test machine any more, unless you change your setup again).
  5. Copy the next files to your production server webroot:
    • The whole Alpha_Calendar Folder (see point 7)
    • Copy the "DoNotDelete" file placed directly under your testing server a5webroot\ and place it directly on your Production server a5webroot\ (NOT your web project folder)
    • Copy the whole "Alpha_Calendar_WebFiles" folder and all the files that start with "CL_" that are under that your web project folder e.g. "C:\\A5webroot\MyWebProject". Files:
      • cl_test.a5w
      • cl_load_events.a5w
      • cl_tablepath.a5w
      • cl_calendar_full.a5w
      • cl_calendar_75.a5w
      • cl_calendar_50.a5w
      • Alpha_Calendar_WebFiles folder
  6. If your main database is placed under eg. "C:\databases" in your test server then you main database needs to be placed in that same path on your production server ( eg. C:\databases on your production server)
  7. If Alpha_Calendar folder is placed under eg. "C:\databases" in your test server then you need to place Alpha_Calendar in that same path on your production server ( eg. "C:\databases" on your production server)
  8. Now Run Cl_test.a5w in your browser and the calendar should be working.

 

3. Using Alpha Calendar Pro

There are several ways to use alpha calendar pro within your application, we will explain the most common scenarios.

3.1 Events

3.1.1 Viewing events on the calendar

To view your events in the calendar you can display either of this a5w pages:

Additionally you can include any of this pages on your own A5W page by using the xbasic function ‘A5W_Include()’ e.g. A5W_Include(“cl_calnedar_full.a5w”)

 

3.1.2 Adding/Editing events on the calendar

To add/edit events in the calendar you must create a grid that adds or edits records on the table you selected as your events source during the setup.

Additionally you can set the redirect "target page" on your grid to the page containing the calendar so when the user submits the grid they will be automatically redirected to the calendar page

 

3.2 Adding/Editing Locations and Categories

To add/edit Locations and Categories in the calendar you must create one grid for adding or editing locations and another grid for adding or editing catgories (the grids must add or edit the tables that you selected as your Locations or Categories source respectively during the setup).

 

3.3 Linking a specific event on the calendar to a grid for that event.

Suppose this:

URL to your Edit Event Grid a5w page: http://MyServer/MyWebProject/Edit_event.a5w
Event Id field name on your table: Event_id

  1. Go to your "Main Database" and open your events table in edit mode.
  2. Add a new field called "Link" (or your desired link name)
  3. Open the field rules and go to the "link" field
  4. Set the field as a calculated field
  5. write the next expression (remember our initial suppositions) "http://MyServer/MyWebProject/Edit_event.a5w?Event_id="+Event_id (no speces)
  6. go to your event edit grid
  7. In the Query(DBF) option go to "define arguments"
  8. Insert a new argument called event_id and set it to "get value from variable"
  9. set the variable field to Event_id
  10. Filter your grid by this expression Event_id=:Event_Id
  11. Open alpha Calendar Pro
  12. Go to setup
  13. In the event connection page (2nd page) select "Link" on the "URL" field, save and continue
  14. Publish the changes(last page of the setup)
  15. test it
  16. And there you have it


Additionally you can change the label of the "URL" field on the calendar to "edit event” (or your desired label name) in the "Customize your calendar" section on Alpha Calendar Pro

 

4. Troubleshooting

In the "Cl_Calendar_full.a5w" page I only get a blue frame, but where is the calendar?

 

I get the next error (or a similar one):

"Script Error
Error:Script:CL_LOAD_EVENTS.A5W line:72
addin.run("Cl_Load_Events")
Read past end of file"

 

I get the next error (or a similar one):

Script:OnInit line:8
tbl = table.open(tabla)
Error loading C:\AlphaFiveDB\AlphaCalendarPro_v1.0.8\Calendar_Tables\cl_locations_tbl.dbf  
: The system cannot find the path specified.
 C:\AlphaFiveDB\AlphaCalendarPro_v1.0.8\Calendar_Tables\cl_locations_tbl.dbf

 

I get the next error (or a similar one):

500 Internal Server Error
"Script Error
Error:Script:Cl_Load_Events line:151
No such field" 

 

I get the next error (or a similar one):

500 Internal Server Error
"Script Error
Error:Script:Cl_Load_Events line:139
Argument is incorrect data type"

 

I get an error saying that the tables where encrypted using a different key

 

I get the next error (or a similar one), when trying to connect to an SQL Active Link Table:

Script:OnInit line:14
tbl = table.open(tabla)
Error loading C:\USMONSQL\cl_Patient.dbf                                                                                                                                                                                                                                : Unable to connect to backend database while opening local cache C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\$$45_DATA_cl_Patient.dbf for table cl_Patient.
Invalid syntax for connection string.
Must be formatted in one of the following ways:

name1 + chr(9) + value1 + crlf() + name2 + chr(9) + value2 + crlf() ... or 

{name1='value1',name2='value2'...nameN='valueN'}

 

I get errors trying to connect to a SQL active table

 

5. Version History

1.0.7

1.0.8

1.0.9

1.1.0

1.1.1

1.3.0 (21/OCT/2009)

1.3.1 (22/OCT/2009)

1.3.2 (23/OCT/2009)

1.3.3 (26/OCT/2009)

1.3.4 (02/NOV/2009)

1.4.0 (03/NOV/2009)

1.4.1 (05/NOV/2009)

1.4.2 (09/DIC/2009)

 

6. Ask Us Live (Beta) :