Tcal Help


TcalServer

First install MacOSX (Demo)

First install Windows (Demo)

TcalServer FAQ

Tcal

Tcal FAQ

History








TcalServer v1.4.4

What is TcalServer?

TcalServer is the server component of the Tcal calendar, a product of Trevix Design.
Tcal is a calendar in a Client-Server system that allows you to record timed events and to see other’s resource calendars, if they are connected to TcalServer.
The main characteristic of this calendar is that it uses a common Database (FileMaker Pro, FileMaker Server, Microsoft Access or MySQL) in order to record timed events, to allocate resources and jobs to them and to record each resource job load.
This allows the connection between the company-shared calendars and the company management Database, made by you in order to handle the everyday workload.
TcalServer is the server component of this system; every company calendar connects to it using Tcp/Ip on Intranet or over Internet, while it handles the connection to the company databases.

Where do I put TcalServer?

The Installer will install TcalServer on the application folder of your company server or shared computer where you installed your company management database. This computer must be connected trough Tcp/Ip to your intranet or be accessible trough Internet from outside.
For MySQL it is also possible to use TcalServer and MySQL on different computers, connected trough intranet or Internet.

What kind of computer can I install TcalServer on?

This version of TcalServer uses the databases of FileMaker Pro (v. 11 or superior), FileMaker Server (11 or superior), Microsoft Access (on Windows 7 or XP) or MySQL 5.6.19 (Mac and Windows).
This version of TcalServer, unlike what occurred previously, communicates with the database primarily using ODBC. Apple script (OSX only) is only used with the Runtime Demo FileMaker or the runtime you have built with FileMaker Advanced.

So TcalServer can be installed on
- OSX 10.5.8 (PowerPC) - FileMaker Pro 11/12 - FileMaker Pro Advanced 11/12 - MySQL 5.6.19
- OSX 10.6.8 (Intel) - FileMaker Pro Advanced 11/12 - MySQL 5.6.19
- OSX 10.9.4 Mavericks - Yosemite - FileMaker Pro 12/13, FileMaker Server 13, - MySQL 5.6.19
- Windows 7 - FileMaker Pro 12 - Microsoft.Jet.OLEDB.4.0 (Microsoft Access 2000) - MySQL 5.6.19

Naturally Tcal calendars can be installed on both platforms (Mac OSX and Windows 7 or XP).



What's new in this version
- Changed the method of connection to FileMaker and Microsoft Access. Now using ODBC
- Added the ability, via ODBC, to connect to FileMaker Server
- Updated for compatibility with FileMaker Pro 12/13, FileMaker Advanced 12/13 and FileMaker Server 12-13
- Updated for compatibility with Mac OSX Mavericks (10.9.4) and Yosemite (10.6.8)
- Updated to be compatible with Windows 7 (sp1)
- Added the FileMaker runtime 12/13, only for Mac OSX, to use TcalServer without FileMaker Pro or FileMaker Server.
- Modification and simplification of the preferences file

Database
Tcal and TcalServer use 4 different databases:

1) “Events” (as the name of the demo database)
This database holds the events created by the Tcal calendars and transmitted to TcalServer.
2) “Events_register”
This database holds the hours of the resources for each event of the week that has been certified.
3) “Jobs”
This database holds the Jobs of your company, with a Job number, name of the Job, Team on the Job, eventually the Job typology (one only in order to distinguish for ex the internal Jobs, as vacation) and a mark to sign if the Job is concluded or not.
4) “Resources”
This database holds the resources of your company that will use the Tcal calendars.

The database 2,3 and 4 are ideally linked to your company database or are part of it, so to make an integrated system.

FileMaker Runtime
Installing TcalServer on Mac OSX and wanting to use the database with FileMaker runtime application "DBDemo_FM.app" (which you have to download separately), if you want to modify databases (you will need FileMaker Pro) it should be noted:

- In every database there must be a format named "List”, in which the fields are the same of the demo database, of the same type, with the list view and the fields made ​​"
in the same sequential order of the examples”. In Mac OSX TcalServer communicates with the runtime via Apple script and Apple script identifies the fields numerically, from left to right when it needs to load the values ​​to send it to TcalServer.
- The name of the fields that appear in the layout of the Database (Table) "List" can not be changed (the required fields must exactly match the names of the fields in the File DB for example), except for the DB Jobs and DB resources (these, being by definition the management of the company, can be changed. See preferences). These fields, however, to be recognized, must have a name that begins with "tcs_”.
- Tcal uses the ID number generated by FileMaker or Access to uniquely identify the events. This field is therefore essential and cannot be removed.
- In the DB “Events_Register” (where are loaded the hours of work) in addition to the ID field that identifies each record, the” tcs_ud" field is used to save the unique number of the Event (taken from the ID of the DB “Events”).


FileMaker Pro/ FileMaker Server
Installing TcalServer on Mac OSX you can still use FileMaker Pro with AppleScript: just identify in the preferences of TcalServer the application. It is however recommended to install the ODBC driver for FileMaker (free), define the data source, and allow TcalServer to communicate via ODBC.

- The name of the fields of Database “Events” and “Events_register” cannot be changed (the required fields must exactly match the names of the fields in the Demo example and also the field type, number, text, date, etc., should be strictly accurate). Only in DB “resources” and “Jobs” the field names can be changed (these, being by definition used by the management database of your company. See Preferences).
But they must necessarily have a name that starts with "tcs_", so that TcalServer can recognize the fields on which to operate.
- Tcal uses the ID number generated by FileMaker or Access to uniquely identify the events. This field is therefore essential and cannot be removed.
- In the DB “Events_register” (where are loaded the hours of work) in addition to the ID field that identifies each record, the” tcs_ud" field is used to save the unique number of the Event (taken from the ID of the DB “Events”).

Microsoft Access
The demo databases downloaded with Tcal are similar in substance to those of FileMaker described above.

MySQL
In the “DBDemo_MySQL” folder you will find a file that explains in detail how to use MySQL with TcalServer.
Even in this case, in all the databases you must be a table "List" with the necessary fields of the correct name and type.



Preferences settings

General preferences
Connected Database
This setting decides which Database connects to TcalServer.
In this version, the only supported databases are the runtime of FileMaker (through Apple script), or MySQL, or FileMaker Pro, FileMaker Server and Microsoft Access, all with ODBC.

IP Server and IP Port
The IP number of the PC where you installed TcalServer is automatically displayed.
The port number, used to access TcalServer on Internet from outside, must be written out. Otherwise will be used the default number “65432” (this is a generic number that should be available…)

Update timer
TcalServer updates from the DB Jobs and the DB Resources on the time of this field (if you checked the “Daily update…” button). It is also possible to update twice a day, if you mark the “Secondary daily update” button and decide a time for it.
Finally you may decide if you want the update every day of the week or on working days only (in case you do backup on weekends…)

Events categories
It is possible to assign an aforethought category to the events, for exampled linked to a precise step of the job. The abbreviation must be 3 characters max in length.

“Access levels” preferences

The administrator must insert on TcalServer the names of every resource that will eventually connect to it. Every resource name (one word only, no spaces) must be unique (for example the last name) and you have to assign a password (used to connect to TcalServer) and an IP number (ex 10.0.0.1). The IP number belongs to the computer connected with Tcal in the intranet. This number is unique for each resource and it is used by TcalServer to authorize the connection of each client to the server.
Finally the administrator must assign an access level:
1 administrator level (future version of Tcal will allow administrator operations directly from the Tcal client, without having to operate on the TcalServer.)
The administrator, besides operating in the same way as each resource, can have total control on every event of every resource calendar (erase other people events, create events for other resources and de-certify weeks).
2advanced level
This level is the same as administrator level but without the possibility to change resources and access to TcalServer (could be used for example by the production secretary).
3base level
This is the typical access level of a user resource. This resource cannot modify or erase events that do not belong to it.

“FileMaker Pro” preferences

After installing TcalServer on the same computer on which the database resides, the "FileMaker RT" preferences on TcalServer are used to give directions to TcalServer on the positioning of the application (the runtime of FileMaker or the FileMaker Pro application) and the names of the fields to be queried.

Interface with Database ...
With this button, show in TcalServer where is located the FileMaker Runtime or, if you so desire, the application FileMaker Pro.

DB Events
By pressing this button, you are prompted for the database where “events” are logged. This is the real storehouse of information of all the calendars (the DB demo attached to the application is already set up for this purpose. Any change to the DB should contain these fields, formatted in the same manner).

DB Events_register
In this DB are stored the hours spent working for each user, when it decides to certify them (see Tcal - week registration), by calling the menu "Certify" on the Tcal calendar.

DB Jobs
This is your housework management Database, where you store jobs and keep track of them. TcalServer pull the job titles and numbers in order to allow the assignment of them to Events:
TcalServer must have access to the following fields (you can name them as you want as long as the name start with “tcs_”):
A Job number field: unique ID (“tcs_job_num” on the Demo DB)
A Job title field: the name you choose for the Job (“tcs_job_title” ” on the Demo DB)
A Job Team field: the name of resources assigned to the job (“tcs_job_team” ” on the Demo DB)
A Job typology field: this is used to eventually split work jobs from internal assignment: holidays, internal jobs, company meetings...(“tcs_job_typology” on the Demo DB). This field must be empty or filled with the word that on the DB, on the typology field, differentiates a certain kind of job from the others.
A Job concluded field: this field [“yes” or “no”] defines if the work on the selected job is ended or not, showing it on the Tcal list (“tcs_job_concluded” on the Demo DB). This field is used to shrink the list of showed jobs, potentially elevated, and to avoid the insertion of concluded jobs on new events.
Naturally your Company Jobs management Database will be much more complex then the downloaded example (“Jobs.fp5”). You must anyway create a layout named “List” on which to put the required fields.

DB Resources
This DB lists the company resources using Tcal (eventually using the job management DB) that can be invited on the events. The two fields:
- “tcs_resources” (the name of the field holding, for example, the resource last name)
- “tcs_resource_active” (the DB field name [“yes” or “no”] where you decide if the resource is active and is showed on the resource list of each
Tcal calendar)
ATTENTION: on the “tcs_resource” field use only one word (no spaces).

Finally, if necessary, you can enter the User and Password of the database (the same for all databases)

"MySQL" preferences

After the installation of MySQL and the 4 necessary databases, with the "List" tables and the fixed name fields (on “Events” and “Events_register”), on the TcalServer preferences, on the MySQL page, you must manually write:
- The exact name of the Events database (or whatever name you choose)
- The exact name of the Events_register database
- The exact name of the Jobs database and of its 5 fields (starting with “tcs_”)
- The exact name of the Resources database and of its 2 fields (starting with “tcs_”)

The Demo database requires an "Admin" user, with no password. I you have a remote connection (MySQL and TcalServer are on different computers, connected trough intranet or Internet) you must write the MySQL address. If it is local, you can leave the field empty.
The "Check connection" button allows you to see if the databases are on line, if the field’s names are correct, and to obtain the MySQL version you are using.

Preferences “ODBC”

Interface with Database of ...
With this button you can show if you want to connect to FileMaker Pro (or FM Server) or Microsoft Access (Windows only).


Important: before you can use TcalServer with these databases, you must have installed the ODBC driver and have defined ODBC data sources on the computer (ODBC manager).
The preferences are similar to those of FileMaker RT. You have to write the names of the 4 databases (tables) to connect to, with the addition of the names of the data sources.
For more information, see the file "readme TcalServer" in the folder of the program.

Using it
Once you start ("Start server" button), TcalServer connects via ODBC to FileMaker Pro or FileMaker Server (the application must reside on the same computer TcalServer) or MS Access.
NOTE: FileMaker Pro or FileMaker Server must already be started for the communication to takes effect.
With MySQL, TcalServer connects directly with the MySQL server you have installed
TcalServer holds in memory job list and resource list, but will access other databases when necessary (this is the reason of the update timer for Jobs and Resources).
Each Tcal client calendar, once completed their preferences and the IP number of the TcalServer computer, will be able to connect and be operative.

Registration
This is not free software.  This Software is distributed as Shareware and as such you may use the software without charge for evaluation purposes for an unlimited time with a limit of two connected users to the server component TcalServer.  If you wish to connect more then two users to TcalServer you will have to buy a registration code from Trevix Design (See www.tcal.it for details on purchasing a registration code).  When payment is received you will be sent a license key to unlock TcalServer.  Unregistered use of Tcal and TcalServer with more then two connected users without a granted unlock key is in violation of international copyright laws and treaties.
You can easily register it on-line, or by mail.
In order to activate the registration, go to the Info menu of TcalServer and follow instructions.


------------------------------------
Back to top
------------------------------------





TcalServer – first install (DEMO)Installation Demo allows you to become familiar with the programs, and test the functionality.
Next, simply by changing the preferences of TcalServer, you can change the databases at your leisure.


Mac OSX
Install TcalServer with RunTime of FileMaker Pro
Download Tcal and "DBDemo_FM_Runtime.zip, unzipping the files. Place the folder "DBDemoR_FM" on the desktop.

  1. Launch the application "Tcal Server Installer" (Mac OSX), accepting the license agreement.
  2. The installer asks you for the administrator password (password to log in) in order to submit the application in the Applications folder ..
  3. After Tcal Server will be launched, along with the "Readme" file that contains this information.
  4. You will be required, since this is the first installation, if you want to use preferences to the Demo. Confirme.
  5. In the next screen select "Demo runtime FM"
  6. Click on "Tcal eTcalServer on the same computer (to set preferences of Tcal and use it on the same PC x Demo)
  7. The Runtime FileMaker will be launched (the 4 registration database)
  8. If all goes well you will be asked for an account name and password (calendar) Tcal.
  9. At the close of the demo, you open the screen Tcal Server. Click on "Start server
  10. Install Tcal that at this point it will open on the same PC, asking you to create a new calendar.
  11. Creating a new calendar will be asked to save it to your PC, with the same name point 8
  12. Press the "Connect" button on Tcal
  13. When you first open Tcal asks you the password again for the calendar created (the one entered in step 8)

In case you want to start again, use the two installer to "uninstall" the two applications and delete files of preference:
/Users/UserName/Library/Preferences/preferenze_Tcal.txt
/Users/UserName/Library/Preferences/preferenze_TcalServer.txt

Install TcalServer with FileMaker Pro or FileMaker Server

Note: Filemaker pro must have been previously installed on the Mac and you have to open the file "Events.fmp12" with it.(/Users/UserName/Desktop/DBDemo_FM/Events.fmp12)

  1. Having downloaded and unzipped the files, start the application "TcalServer Installer" (MacOSX), accepting the license agreement.
  2. After that, Tcalserver will be launched, along with the "Readme" file that contains this information.
  3. You will be required, since this is the first installation, if you want to use preferences to the Demo. Confirm.
  4. In the next screen select "ODBC FileMaker Pro or FMS"
  5. Launch “ODBC Manager”. If is not installed yet, download it from here: http://www.tcal.it/resources/download/ODBC_Manager.dmg
  6. In the User DSN or System DSN, click on "Add", selecting the driver "FileMaker ODBC", and create the first data source.
  7. The first data source will be called "fm_Events".
  8. As host, define “localhost”
  9. Put a check on "Connect to host to obtain ..."
  10. From the list, select the database "Events" and press "Continue"
  11. On the next screen, you can eventually press on "Test" to confirm the connection, entering "Admin" as the user ID, without any password
  12. Repeat this procedure to create the data sources:
  13. “fm_Register” per il database “Events_register”
  14. “fm_Jobs” per il file “Jobs”
  15. “fm_Resources” per il file “Resources”
  16. Close ODBC Manager
  17. Return on the Demo window of TcalServer and click continue
  18. Click on "Tcal and TcalServer on same computer" (to set preferences of Tcal and use it on the same Mac (Demo)
  19. If all goes well you will be asked for an account name and password (calendar) for Tcal. Otherwise you may need to restart your Mac
  20. At the close of the demo, TcalServer will launch. Click on "Start server"
  21. Install Tcal that at this point it will open on the same Mac, asking you to create a new calendar.
  22. Creating a new calendar you will be asked to save it to your PC, with the same name of point 20
  23. Press the "Connect" button on Tcal
  24. When you first open Tcal asks you the password again for the calendar created (the one entered in step 20)


In case you want to start again, use the two installer to "uninstall" the two applications and delete files of preference:
/Users/UserName/Library/Preferences/preferenze_Tcal.txt
/Users/UserName/Library/Preferences/preferenze_TcalServer.txt



------------------------------------
Back to top



Windows 7
Install TcalServer with Microsoft Access
Have downloaded and unzipped the file, launch the application "TcalServer Installer" (Windows), accepting the license agreement.
1 After Tcal Server will be launched, along with the "Readme" file that contains this information.
2 You will be required, since the first installation, if you want to use preferences to the Demo Demo. Confirm.
3 In the next screen select "ODBC MS Access"
4 Launch the "Control Panel / Administrative Tools / Data Sources (ODBC)".
5 In the User DSN or System DSN, click "add" and, by selecting the driver "Microsoft Access Driver (* .mdb), created the first data source.
6 The first data source will be named "acc_Events".
7 Click "SELECT" to choose the file in the demo (C: \ Users \ Username \ Desktop \ DBDemo_Access \ Events.mdb)
8 Repeat this procedure to create the data sources:
9 “acc_Register” for the file “Events_register.mdb
10 “acc_Jobs” for the file “Jobs.mdb”
11 “acc_Resources” for the file “resources.mdb”
12 Close ODBC Data Source Administrator confirming
13 Return on window Demo TcalServer and click continue
14 Click on "Tcal and TcalServer on the same computer (to set preferences and Tcal and use it on the same PC (Demo)
15 If all goes well you will be asked for an account name and password (calendar) Tcal. Otherwise you may need to restart your PC
16 At the close of the demo, you open the screen Tcal Server. Click on "Start server"
17 Install Tcal that at this point it will open on the same PC, asking you to create a unuovo calendar.
18 Creating a new calendar will be asked to save it to your PC, with the same name point 15
19 Press the "Connect" button on Tcal
20 When you first open Tcal asks you the password again for the calendar created (the one entered in step 15)



In case you want to start again, use the two installer to "uninstall" the two applications and delete files of preference:
C:\Users\UserName\AppData\Roaming\preferenze_Tcal
C:\Users\trevix7\AppData\Roaming\preferenze_TcalServer


Installare TcalServer con FileMaker Pro
Note: FileMaker Pro should already be installed on your PC and you have to open with FileMaker the file "Events" (C: \ Users \ UserName \ Desktop \ DBDemo_FM \ Events.fmp12)

1 Have downloaded and unzipped the file, launch the application "TcalServer Installer" (Windows), accepting the license agreement.
2 After Tcal Server will be launched, along with the "Readme" file that contains this information.
3 You will be required, since the first installation, if you want to use preferences to the Demo Demo. Confirm.
4 In the next screen select "ODBC FileMaker Pro or FMS"
5 Launch the "Control Panel / Administrative Tools / Data Sources (ODBC)".
6 In the User DSN or System DSN, click "add" and, by selecting the driver "FileMaker ODBC", created the first data source.
7 The first data source will be named "acc_Events".
8 As Host define “localhost”
9 Put a check on "Connect to host to obtain ..."
10 From the list, select the database "Events and press" Next "
11 On the next screen, you can possibly press on "Test" to confirm the connection, entering "Admin" as the user ID, without any password
12 Repeat this procedure to create the data sources:
13 “fm_Register” for the file “Events_register”
14 “fm_Jobs” for the file “Jobs”
15 “fm_Resources” for the file “Resources”
16 Close ODBC Data Source Administrator confirming
17 Return on window Demo TcalServer and click continue
18 Click on "Tcal and TcalServer on the same computer (to set preferences and Tcal and use it on the same PC (Demo)
19 If all goes well you will be asked for an account name and password (calendar) Tcal. Otherwise you may need to restart your PC
20 At the close of the demo, you open the screen Tcal Server. Click on "Start server"
21 Install Tcal that at this point it will open on the same PC, asking you to create a unuovo calendar.
22 Creating a new calendar will be asked to save it to your PC, with the same name point 19
23 Press the "Connect" button on Tcal
24 When you first open Tcal asks you the password again for the calendar created (the one entered in step 19)



In case you want to start again, use the two installer to "uninstall" the two applications and delete files of preference:
C:\Users\UserName\AppData\Roaming\preferenze_Tcal
C:\Users\trevix7\AppData\Roaming\preferenze_TcalServer

------------------
Back to top






TcalServer - FAQ Version 1.4.4

Q: Why did you change the field names of the database?
A: The communication via AppleScript or VBScript (with Access) was complex and inefficient. For this reason we decided to use ODBC, fast and relatively simple to implement. In the work of reorganizing the database we had to uniquely identify the fields that are REQUIRED to TcalServer to operate, thus marking a clear distinction between the fields of TcalServer and those that may be created by you. For this purpose, all fields used by TcalServer database must have a name that begins with “tics_”

Q: Why Tcal?
A: we made this calendar because every FileMaker Pro calendar shows the limits of the FileMaker or Access interface. With Tcal you can now have a functional graphic calendar to connect and modify your databases.

Q: Why not just a plug-in?
A: A Plug-in usually records calendar data to the database, but does not allow flowing of data in the other direction: on the calendar we needed to show job and resource lists, so to be able to create events linked to them.

Q: When I start TcalServer, it launches FileMaker Pro 11 instead of the version 12
A: TcalServer cannot detect if on your Mac you have both version of the FMP application. Just launch FMP before starting TcalServer.

Q: I'm having problems using FileMaker Pro 8 installed, with TcalServer, on Mac OSX 10.5.5
A: This version of TcalServer works only with FileMaker Pro v. 11 or superior

Q: I want to use TcalServer with the FileMaker runtime under Windows, but I cannot make it work.
A: You can only download the OSX version of the FileMaker runtime and it cannot works on Windows. It is impossible in fact to talk to the FM runtime using VBscript and Apple script is not available on windows

Q: When I start TcalServer, there always is a window saying "database error".
A: One or more database field name is wrong. Compare field names and change the database accordingly.

Q: When I start TcalServer, I get a message saying "the...xxx..file is not correct".
A: One or more database field name is wrong or is of the wrong type. Compare field names and change the database accordingly.

Q: When I start the demo databases, FileMaker Pro starts a script that modify the "events" file records.
A: This script is only used to update the records to the current date, in order to show events on the current week: You can delete the script.

Q: On the "events" database there is a “tcs_ud” field. What's his use for?
A: When a user certifies a week, from the Tcal menu, all the week events created by the user get recorded on the “Event_Register “DB. This field is used to mark, in the “Events” DB, the registered events that have been added to the “Event_Register” DB: This field is used to mark, on the Events DB, the activities that have already been certified (added to the Events_register DB). 0= not certifiable (private events), 1= certifiable, 2= certified.

Q: What is that meaning, on the lower left of TcalServer, of the "Server Time Zone GMT +02:00"?
A: Tcal and TcalServer can be installed on computers operating on different countries, with different Time Zones (You need of course to use a public IP number, fixed).
GMT +02:00 for example, means that TcalServer operates with a Date and Time difference of +2 hours and 00 minutes over the Greenwich Median Time. You can check the Tcal Time zone on the "Info" menu.

Q: Can I use FileMaker or Access or MySQL, the name of a table or database fields "Events" and "Events_register" different from the demo?
A: NO. Fields beginning with "tcs_" in the demo database, are the fields required and must be in all implementations of database you want to achieve. Must be called in the same manner and be of the same type (text, number, date, time, etc.). Almost all the connection problems between TcalServer and database, comes from wrong field names or wrong field type.

------------------
Back to top





Tcal v1.4.4

What is Tcal?

Tcal is the client component of the Tcal calendar, a Trevix Design product.
Tcal is a calendar that allows, in Client-Server system, to records your appointment and to see the calendars of other resources of your company that are connected to TcalServer, the server component of the system.
The main characteristic of this calendar is that it uses a common database (ex. FileMaker Pro, FileMaker Server or Microsoft Access or MySQL), trough Tcalserver, to records your appointments, to assign resource and Jobs to them and to record the work time load.
This allows connecting the shared company calendar (Tcal) to an internal management system, custom-made by you and tailored on the needs of your company, tracking the time spent by your employee on each job.
Tcal connects to TcalServer trough Tcp/Ip.

Where to put Tcal?
Tcal has to be copied on every Mac or PC of users you want to enable. These computers must be allowed to connect to TcalServer through Tcp/Ip, on an intranet or trough Internet.

What Computer systems does Tcal support?
Tcal can be installed on Mac OSX, Windows 7, Windows 8

Security
As of now the data transmitted between Tcal and TcalServer are not crypted. Security is handled inserting on TcalServer the password and Tcp/Ip number of each user; on Tcal each user must insert his password and the Tcp/Ip number of TcalServer

What's new in this version
- Updated compatibility with Mac OSX Mavericks (10.9.4)
- Updated compatibility with Windows 7 (sp1)
- Wider use of the sound interface volume
- Style change of the interface
- Solved problems relating to shared calendar links
- Easier and faster preferences
- Better speed for some functions


Setting of Tcal preferences
(note: with "Owner" we mean the calendar user, hose name is shown on the top right on the Tcal launch)

Basic Setup

Last name
This is the user name (resource) that qualifies him as owner of the calendar, as he connects to TcalServer. The resource names must be unique and different on any computer connected to TcalServer.
The resource name must be made of only one word (no spaces...)

Password
The personal password must be the same of the one inserted on TcalServer for the specific resource.

Update weeks
In order to lighten up the net traffic between the Tcal calendars and TcalServer, usually, on connection, Tcal will load only the present week events, all the future events and, according to this setting, the number of past weeks events. If necessary, inside Tcal, you will anyway be able to load any week, once connected.

Save the Password
To save the inserted password without retyping it every time you connect.

Connect on opening
Allows Tcal to automatically connect to TcalServer after launch

Text on the Event rectangle
Select here the 4 text markers that describe the event. On deadline they are space delimited. On Activities they are return delimited

TcalServer

Type the IP number of the computer where you installed TcalServer (for demo purpose can be the same on witch you installed Tcal).
The default port should give you no problem ("65432"). In order to use Tcal over Internet, the port where you installed TcalServer must be reachable from outside.

Working with Tcal

Tcal differentiates two modes of Events:
1 – Activity
2 – Deadline

The
Activities are Events, with a specific date and time, which concern the owner calendar or other resources (ex from 10:00 to 12:00 on the 15/2/09 I work on the project xx of the Job yy).
The
Deadlines concern one or more resources but without time; only the full day (ex. "send invoice on that day").

Each Event differentiates, beside by the mode of event, by the presences of other resources on the Team, by the reference Job and, eventually, by the category (a work can be divided for example on several time phases that need to be singled out).

Activities and Deadline can be of two types: Public or Private
Public Events can be seen by all calendars. Private Events instead are not visible to other resources (they concern only the calendar's owner). Private Events cannot have other resources on the Team and cannot be marked with Job names or categories.

Connect to TcalServer
TcalServer must be launched and on-line.
Once connected, the owner events will be displayed.

To see other resources calendars
With the pull down menu "calendar", on the top right, over the list, is possible to select the Jobs, to show only the owner calendar, the owner plus other resources, other resources only (the Event are differentiated by different colors). It is also possible to see the available categories (chosen in the TcalServer preferences)

Events

Create an Activity
Pull down the mouse on the calendar and drag vertically for the needed time length.
If the starting hour of your new Activity is covered by another activity, you can create it with the command-drag (control on Windows)

Create a Deadline
Click on the field at the bottom of each day and drag horizontally.

Erase an Activity or a Deadline
Select the Event rectangle and press delete.

Add resources to an Activity of a Deadline
Double clicking on the event, on the dialog window you can select the resource on the "Added Resources" list. You will see a question mark that will stay until the resource will confirm (then will become a "OK" or a "NO)

Define the Event Job
Always on the dialog window of the event, on the Option Menu, select the Job. For an easier search is possible to limit the shown list only to the Jobs where the owner is on the Team, those selected (click on the left column of the Job list on the Tcal window), the specific Job typology (named on the TcalServer preferences, ex "internal"), or all of them.

Tcal supports drag drop; it is possible to add a resource, a Job or a Category simply dragging them from the list to the Event.

Updates

Once you are invited to an event, made by another resource, you will receive a message from him. It is possible to see the details of the invitation clicking on the "Updates" button (that becomes red when there are available data). From the dialog window you can then accept or refuse the event. It is also possible to speed verify, accept or refuse the invitation clicking with the right mouse button (or click-control) directly on the Event: you will be shown the list of the guests of the Event, where you can accept or refuse the same.

Send a message to another user
On the resource list (on the right of the main window), on the update window and on the user-invited list shown when you right click on an Event, you can right click on a name in order to send a message to the user.

Menus

Rebuild calendar
You may need to completely rebuild you calendar (that is on the DB "Events"), in case it is corrupted or the user is on a computer not updated.
With this menu, Tcal will load all the events (1 year only) that have the owner on the Team.
Naturally will be synchronized the last weeks too (as from preferences).

Synch
This menu is the same a "connect" to TcalServer: will load all the present and future events. Past events are loaded only for the number of past weeks as from Tcal Preferences.

Sync week
Load form TcalServer only the shown week. Tcal will also ask you (and you can accept or decline) to perform this operation when you go to a past week outside the period stated on the Tcal preferences.

Certify week
Tcal can be used to track the working hours on each specific Job. I each resource, at the end of the week, certify the week with this menu item, on the database "events_register" will be recorded all the hours worked by the resource (ex. to do a final balance of the Job).

The certification is made recording the time of each resource like this:
- Will record all the events of witch you are the owner
- Will record the resources on the Team of your events, if they confirmed their presence.
- On your events, if there are resources on the Team that did not confirm the event, you are not allowed to certify the week. You need first to ask the other resources to confirm their presence on the event.
- All the events of the week, of other owners, that are still waiting your confirmation, will be confirmed.
- You cannot certify future events
- Once the week is certified, a base level user cannot modify the week.

I you have an advanced or administrator level access, you can de-certify the week (every data of the owner will be erased from the registration DB). You just need to click on the certification stamp of the week.

Log
You will load from TcalServer every occurrence the owner is involved with, starting from last connection, last week, month or every data on TcalServer. With an administrator level access is possible to see the log of other resources.

Administration
(not active yet...)

Launch TcalAlarms
Tcal has an alarm system that can be applied to any event on your calendar or the calendar of other resources. If the connection between Tcal and TcalAlarms should be lost, use this menu to re-establish it.
TcalAlarms is an application that sleeps on the background and is launched on the first launch of Tcal. If you need alarms, never shut off this application.
(Note: with option-key on this menu is possible to see the IP ports used to connect to TcalServer and TcalAlarms)

HTML exports
It is a quick and dirty html generator. Once you set its preferences, Tcal create Png screenshot of each chosen month view, for the selected months. It will create an HTML page that you will be able to save on disk or upload, trough FTP, to a folder on your web site.
The generated web page is not editable and it used for consulting only.
On the HTML export preferences:
-
Ftp address. Usually obtained from your web host. Since the name of the generated HTML page is "index.html", it is better to create a folder on the web where to upload the Tcal web page (not on the main directory...).
-
Username and Password. Supplied by your web host
-
Month export from. Tcal can create a max of 12 month view. Here you supply the starting month and the requested number of months.
-
Text on the Events. As in Tcal preferences, here you can decide what text appear on the event rectangle
-
Title, Subtitle, Text, Header and Footer. This text will appear on the created HTML page

Shortcuts
Control-click (right mouse button) on a resource name to send him a text message.
Control-click (right mouse button) on events (that have other resources on the Team) to open a window with the Team list and quickly modify the state of each member of the Team.
Control-click (right mouse button) on the names inside the previous window, to send a text message.
Control-click-drag to duplicate an event.

Other
As for now, it is not possible to print Tcal.
The rest of commands should explain themselves.

Registration
This is not free software.  This Software is distributed as Shareware and as such you may use the software without charge for evaluation purposes for an unlimited time with a limit of two connected users to the server component TcalServer.  If you wish to connect more then two users to TcalServer you will have to pay a registration fee to Trevix Design (See www.tcal.it for details on purchasing a registered copy of the software).  When payment is received you will be sent a license key to unlock TcalServer.  Unregistered use of Tcal and TcalServer with more then two connected users without a granted unlock key is in violation of international copyright laws and treaties.
You can easily register it on-line, or by mail.
To activate the registration, goes to the info menu, on TcalServer, and follow instructions.
 


Using with the Demo databases
1) Launch TcalServer (as from indication on the help of TcalServer)
2) Install Tcal on the client computer (for demo purpose can be the same of TcalServer)
3) Launch Tcal and set preferences as described above
4) Connect Tcal
5) Done !!!

------------------------------------
Back to top







Tcal - FAQ Version 1.4.4

Tcal
Q: I have Tcal on the wrong language.
A: There is only one Tcal and TcalServer version that, automatically switch to the system language and date and time format of the computer where they are installed (Italian and English only). If you need to change language or formats, you have to go to your system "Control panel" or "System preferences" and act accordingly.

Q: How can I export a weekly view over a HTML page?
A: You cannot. You only can export monthly views (max 12 months). We did not think to be useful the weekly export.

Q: How can I create a new Activity Event, starting from an hour already covered by another Event?
A: Command-click (Control on Windows) on the starting hour

Q: What are the difference between the 1,2 and 3 access levels?
A: At this time, 1 and 2 levels are equals (once implemented, the 1 level will allow TcalServer remote management). Levels 1 and 2, but not level 3, allow the creation of Events for different Tcal calendars or to modify the Event of another resource. With these levels you can see the complete log, too.

Q: What really happens when I certify a week on Tcal?
A: first of all, you need to know that Tcal certify only activities with a related Job name and with the check mark "Certifiable". No deadline or private events.
Besides locking the week, Tcal records on the Events_register database only the activities created by the user doing the certification. One record for each team member. On the Events database, there is a simple update of the "tcs_ud" field, from "1" to "2".
Remember that you cannot certify an activity following the current day.

Q: How do I de-certify a week?
A: The level 3 user cannot do it. Level 1 and 2 can just click on the "Certified" stamp. On this case, all the records of that week get erased from the Events_register database.



Connection and Tcal
Q: I started TcalServer but the Tcal calendar cannot connect to it.
A: Check Tcal preferences: the IP number and port must be the IP number and port of the PC where you installed TcalServer. Check TcalServer preferences for correct user data: name, password, IP number (where you installed Tcal) and access level. Check the Port number (TcalServer general preferences): must be available and not used by other application. Check the connection (Intranet or Internet)

Q: On the invitation and answer lists I do not see every recorded event
A: If the event is antecedent to today's date, event invitation will not be listed

Q: How do I add resources to an event?
A: Tcal supports "drag and drop". Drag the resource over the event rectangle. Or double-click on the event and click on each resource you want to add (the "?" sign means that the resource has not yet confirmed)

Q: How do I modify a resource access level?
A: On this version, to modify or add resources, you must do it on the TcalServer preferences.

------------------------------------
Back to top





Version history
Tcal Version 1.4.4 (January 2016)
bugs fix
Tcal Version 1.4.3 (april 2015)
- solved window bugs
Tcal Version 1.4.2 (february 2015)
- solved bugs and connection problems
Tcal Version 1.4.1 (october 2014)
- solved bugs and connection problems
Tcal Version 1.4.0 (august 2014)
- Changed the connection method to FileMaker and Microsoft Access. Now using ODBC
- Added the ability, via ODBC, to connect to FileMaker Server
- Updated for compatibility with FileMaker Pro 12/13, FileMaker Advanced 12/13 and FileMaker Server 12/13
- Updated for compatibility with Mac OSX Mavericks (10.9.4)
- Updated to be compatible with Windows 7 (sp1)
- Added the FileMaker runtime 12/13, only for Mac OSX, to use TcalServer without FileMaker Pro or FileMaker Server.
- Modification and simplification of the preferences file


Tcal Version 1.3.9 (November 2012)
TcalServer now connects to FileMaker 12
A new installer for Tcal and TcalServer
Solved connection problems between Tcal and TcalServer

Tcal Version 1.3.8 (February 2012)
Solved problems related to date and time format

Tcal Version 1.3.7 (December 2011)
Solved problems related to:
- It is now possible to enlarge TcalServer in order to view long Job names
- Under Windows, making a new event, it is now possible to scroll le Job list.
- It is now possible in Tcal to view long Job names, using the CapsLockKey while the mouse is on top of the Job list

Tcal Version 1.3.6 (February 2011)
- Maintenance version.

Tcal Version 1.3.5 (January 2011)
- A few bugs cleared up.

Tcal Version 1.3.4 (November 2010)
- Loading a past event, previously "all" the events up to the current date were loaded. This could create memory problems. Now instead will be loaded only the requested week or month.
- The application launch has been accelerated
- Defining a new event, the ending time is now dependent from the starting time
- In preferences, it is now possible to set a default alarm for every new event.
- It is now possible to delete an event using the "cancel" keyboard key.
- The alarm of an event goes off after 30'.
- In preferences you can now see the IP number of the current PC.

Tcal Version 1.3.3 (October 2009)
- You can now use TcalServer with MySQL
- Certification now takes in account the fact that you may have activities spanning more then one day.
- While TcalServer is started, you can now add a resource while keeping all connected Tcal calendars up to date.
- The HTML export page takes now less screen space. There is no more a "subtitle" field.

Tcal Version 1.3.2 (October 2009)
- Activities (like deadlines) can span several days
- Both the creation and the editing of activities can now be done dragging the mouse up and down, left and right from the starting point
- We have solved the Time Zone bug, where calendars on different Time Zone were not synchronizing properly. IMPORTANT NOTE: for simplicity reasons, the different Time Zone is ignored for "Deadline" (all day events).
- Tcal now support the YYYY/MM/GG date format (as in French Canada...2009/9/25)
- On the Tcal preferences you can now chose witch text is shown on the rectangle of the events
- It is now possible to export any month view on a HTML page. This page can be exported on your disk or, trough FTP, to your web server.
- In order to create an activity on an hour covered by another activity, you can now command-click to create a new one
- Bugs clean-up





For any comment or request:
info@tcal.it
www.tcal.it



Trevix Design - 2015
© All rights reserved worldwide
Trevix Design - Tcal 2009 - www.tcal.it © All rights reserved worldwide

Apple, the Apple logo, AppleScript, AppleTalk, Finder, Mac, Macintosh, and PowerBook are trademarks of Apple Computer, Inc.,
registered in the United States and other countries

Windows, Windows Vista, Windows 98, Windows XP are trademarks of Microsoft, Inc.,
registered in the United States and other countries

NO WARRANTY TREVIX DESIGN EXPRESSLY DISCLAIMS ALL WARRANTIES AND REPRESENTATIONS, EXPRESS OR IMPLIED, WITH RESPECT TO THIS SOFTWARE.
 
THIS SOFTWARE AND THE ACCOMPANYING FILES ARE DISTRIBUTED "AS IS" AND WITHOUT WARRANTIES AS TO PERFORMANCE OR MERCHANTABILITY OR ANY OTHER WARRANTIES WHETHER EXPRESSED OR IMPLIED.  Because of the various hardware and software environments into which the Software may be put, NO WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE IS OFFERED.

NO LIABILITY IN Any EVENT WILL TREVIX DESIGN BE LIABLE FOR ANY DAMAGES WHATSOEVER ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE OR DOCUMENTATION, EVEN IF TREVIX DESIGN IS ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.  EXCLUSION FROM LIABILITY INCLUDES, BUT IS NOT LIMITED TO, LOST PROFITS, LOST SAVINGS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION OR ANY OTHER DIRECT, INDIRECT, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES.
 
IN NO EVENT SHALL TREVIX DESIGN 'S LIABILITY EXCEED THE PURCHASE PRICE PAID (IF ANY) FOR THE SOFTWARE AND DOCUMENTATION.
 
Good data processing procedure dictates that any program be thoroughly tested with non-critical data before relying on it. The user must assume the entire risk of using the program. ANY LIABILITY OF THE SELLER WILL BE LIMITED EXCLUSIVELY TO PRODUCT REPLACEMENT OR REFUND OF PURCHASE PRICE.
Back to top