***************************************************
*                                                 *
*          Time Management System v1.3            *
*          Installation instructions              *
*                                                 *
*                                                 *
***************************************************

PREREQUISITES
- Oracle Database 10g or higher - all editions are supported
- Oracle Application Express 3.2.x or higher
- Workspace with at least 50 MB space

Howto install APEX 3.2.1 step by step can be found here (German):
http://www.oracle.com/global/de/community/tipps/einsteiger/APEX32_XE.pdf

INSTALLING THE BASE APPLICATION (includes the german language)
- Logon to the workspace
- In the Application Builder, open the application and click on "Export/Import"
- Click on "Import"
- Import the application file "TMS_DE_APEX32_5678901234_UTF8_V1.sql" using Unicode UTF-8 as file character set
- You MUST reuse the application ID 5678901234 (or otherwise you won't be able to install the translations of the application)
- When asked to install the supporting objects, select "Yes" (this will install the data model, images and demo data)


INSTALL THE ENGLISH LANGUAGE PACK (optional)
- Logon to the workspace
- In the Application Builder, click on "Export/Import"
- Click on "Import"
- Import the application file "TMS_EN_APEX32_5678901334_UTF8_LANGPACK_V1.sql" using Unicode UTF-8 as file character set
- You MUST reuse the application ID 5678901334 (or otherwise you won't be able to see the translations in the application)
- After the installation, run the BASE application


IMPORT THE LANGUAGE MAPPING FILE (needed if you want to change the application)
- Logon to the workspace
- In the Application Builder, click on "Shared Components" and then on "Translate Application"
- Click on "Seed and export the translation text of your application into a translation file." and then on "Seed Translatable Text"
- Now, click on "Apply your translation file and publish", upload the XLF file, click on "Apply XLIFF Translation File" and then on "Publish Application"
- You can now make your changes to the application
- Whenever you are ready with the development of the application, you MUST seed, export and apply the translations for texts that have been changed
  or added in the application. This also keeps the translated application synchronized with the base application


DELETING THE DEMO DATA
- Logon to the database with the database user that has all db objects installed
- Execute the script TMS_DELETE_TRANSACTIONAL_DATA.sql: @TMS_DELETE_TRANSACTIONAL_DATA.sql
Note: only transactional data like (planned) holidays and the hours worked on a project is deleted


TRANSLATING ACTIVITY TYPES
As the activity types aren't translated, by default, the activity types are presented in the base language which is German.
You may use the following table to change the description of the activity types:
DE 			EN
Urlaub		Holiday
Verfügbar		Available
Akquisition		Acquisition
Fehlzeit		Absence
Projektstunden	Project Hours
Sonderurlaub	Special Leave
Schulung		Training
Krank			Ill
Reisezeit		Travel Time


HISTORY
v1.3
- Fixed a minor bug to make an import in APEX 4.0 possible

v1.2
- You may now change the description of an internal activity type
- Corrected some english translations
- Fixed some minor bugs