TIS-Office ToolBox 2 User Guide
TIS-Office ToolBox User Guide Imprint The information contained in this documentation is subject to change without prior notice. In doing so, Siemens VDO Trading GmbH does not enter into any obligation. The description is based on the information available at the time this documentation was printed. We reserve the right to change technical details in the description, information and illustrations in this manual.
TIS-Office ToolBox User Guide Document history Document history Date Chapter/ page Subject, change, action taken 07/2007 Revision TIS-Office 2.6.
TIS-Office ToolBox User Guide Table of contents Table of contents Requirements and security .................................................... V Introduction .............................................................................1 Functional overview ....................................................................................... 2 Characteristics at a glance ............................................................................ 3 About this document ..................................
TIS-Office ToolBox User Guide Requirements and security Requirements and security System requirements TIS-Office Toolbox • Edition 07/2007 As TIS-Office ToolBox 2 is installed with TIS-Office, the same requirements must be met: Operating system Windows® 2000 Professional (current Service Pack) Windows® XP Professional (current Service Pack) Windows Vista Database MSDE200RelA / Microsoft® SQL Server 2005 Express / Microsoft® SQL Server 2005. Browser Microsoft® Internet Explorer® from Version 6.
TIS-Office ToolBox User Guide Introduction Introduction TIS-Office is a fleet management office application intended for fleet company office staff, fleet managers and authorities. Its various modules include functions for managing master data, analysing tachograph data, generating driver, vehicle and security reports, configuring the system, setting tachograph and scanner parameters and defining user settings.
TIS-Office ToolBox User Guide Introduction Functional overview TIS-Office ToolBox 2 provides the functions mentioned below: Function Description Backup and Restore Saves a backup file of a TIS-Office database, e.g. to archive a database status before compressing it in TISOffice. TIS-Office Toolbox • Edition 07/2007 Restores any backup of the database later, if you find that certain reports have not been created in time for example.
TIS-Office ToolBox User Guide Introduction Characteristics at a glance TIS-Office databases During installation two databases are created by default: • the administration database (TISAdminDB) for meta information and • the TIS-Office database for the (automatically created) default company. If you add a new company in TIS-Office, the corresponding database is created and can be managed with ToolBox 2. Access to TIS-Office ToolBox 2 You must log in to access the ToolBox 2 utility.
TIS-Office ToolBox User Guide Database administrator TIS-Office Toolbox • Edition 07/2007 Important Introduction Start ToolBox and enter the credentials below to log in as a database administrator: • User ID: TISOFFICEDBA • Password: dbasvsso The company code must not be entered when logging on as a database administrator. A separate log file named "TISAdmin.log" is saved in the path entered when TIS-Office is installed, e.g. "C:/Program Files/Siemens/TIS-Office/Logs".
TIS-Office ToolBox User Guide Introduction TIS-Office Toolbox • Edition 07/2007 About this document What you should know This document has been written for the TIS-Office administrator. It assumes that the administrator has gained practical experience of how to manage data with TIS-Office and SQL databases. Uniform structure The uniform structure of the sections that describe this application should make it easier for you to start using the programme. Typographical conventions • The left column … .
TIS-Office ToolBox User Guide Introduction Symbol Description Example Condition Conditions that must be met in order to carry out an instruction or a programme command successfully Before logging on for the first time you must ensure that … Tip Practical tips for working with the TIS-Office ToolBox 2 and this documentation For further information on analysing tachograph charts … Notes on the application, explanations on programme connections and background knowledge If your password or user name
TIS-Office ToolBox User Guide Starting and closing ToolBox 2 Starting and closing ToolBox 2 Start and login When TIS-Office is installed, you can create a short cut for ToolBox 2 either on your desktop or on the Quick launch bar. Tip You must log in to access ToolBox 2: Starting ToolBox 2 1 Select "[Start] > All Programs > TIS-Office > ToolBox 2". TIS-Office Toolbox • Edition 07/2007 The login screen will be displayed.
TIS-Office ToolBox User Guide Starting and closing ToolBox 2 If you start ToolBox 2 for the first time or want to access a new company’s database, you must enter the default data; please also refer to the Marginal note "Company manager" on Page 3. Important If you log in as a database administrator the language selection is displayed every time. Language 3 Select the appropriate language and click on [OK].
TIS-Office ToolBox User Guide Company manager features Exiting and closing To exit ToolBox 2: Logout • Click on [Exit] in the main window. You will be logged out and ToolBox 2 will be closed. Company manager features TIS-Office Toolbox • Edition 07/2007 You can only carry out the functions described in this chapter for the company to which you are assigned as a company manager or company administrator.
TIS-Office ToolBox User Guide Company manager features Backup and Restore This feature enables you to save a backup file of a TIS-Office database, e.g. to archive a database status before compressing it in TIS-Office. You can restore any backup of the database later if you find that certain reports have not been created in time for example. You should save a backup file of the database that is to be deleted by the database administrator, e.g. if a company is to be closed.
TIS-Office ToolBox User Guide Company manager features TIS-Office Toolbox • Edition 07/2007 4 Select the "Backup" option and enter the name of the server where the database is located. With a stand-alone installation the current computer name is entered by default. Server name If you work in a TIS-Office client / server environment, the default access data for the TIS-Office database is: 5 • User name: ADMIN • Password: admin123 Select the database you want to back up.
TIS-Office ToolBox User Guide Company manager features 7 Select the folder and click on [OK]. TIS-Office Toolbox • Edition 07/2007 The dialogue box will close and the complete path is displayed in the BackUp Folder box. Start backup function 8 Click on [Backup] to start the backup function. A message will be displayed telling you that backup has been successful. 9 Confirm the message with [OK]. The backup is saved under the database name to which the current date is added, e.g.
TIS-Office ToolBox User Guide Company manager features Restoring a database You can restore any database backup that matches the TIS-Office database structure. This could also be a "repaired" or simply a backup database. Stop the TIS-Office application before performing the restore function. This also applies to all clients in a client / server installation. Condition If you want to restore a database, you must have administrator rights on the computer where the database is located.
TIS-Office ToolBox User Guide Company manager features Displaying the databases used TIS-Office Toolbox • Edition 07/2007 4 Select the "Restore" option and enter the name of the server where the database is to be restored. With a stand-alone installation the current computer name is entered by default.
TIS-Office ToolBox User Guide Company manager features TIS-Office Toolbox • Edition 07/2007 6 Select the file and click on [Open]. The dialogue box will close and the complete path is displayed in the Restore File Path box. Do not enter the name of a database that does not belong to TIS-Office. This will overwrite the database which can then no longer be used with the corresponding application. Caution Please note: • Only select backup files created with the current TIS-Office version.
TIS-Office ToolBox User Guide Start restore function Company manager features 8 Click on [Restore] to start the restore function. If the database name already exists, you will be prompted to confirm that you want to overwrite the existing database. A message will be displayed telling you that the restore operation has been successful. 9 Confirm the message with [OK]. The restored database is listed in the database box. If an error has occurred, a corresponding message will be displayed.
TIS-Office ToolBox User Guide Company manager features Configure DB This feature is used to connect the TIS-Office application with a database located on a server. The function saves the server name to the registry. When starting TIS-Office later, it will connect to the database server automatically.
TIS-Office ToolBox User Guide Company manager features 4 Confirm the message with [Yes]. The connection to the database server will be established. 5 Confirm the message with [OK]. TIS-Office Toolbox • Edition 07/2007 ToolBox 2 will be closed.
TIS-Office ToolBox User Guide Company manager features Check Data Integrity This feature is used to check the database for invalid chart data. This could be required after converting a KISCAN database into TIS-Office database format. Tip For database security reasons you should perform this function at regular intervals. TIS-Office Toolbox • Edition 07/2007 You can search for Tip • Chart without modes: The system checks for chart totals without corresponding activity data.
TIS-Office ToolBox User Guide Company manager features To check chart data integrity: 1 Start ToolBox 2 and enter the appropriate login data. Please refer to the Marginal note "Access to TIS-Office ToolBox 2" on Page 3. The corresponding main window will open. 2 Click on [Check Data Integrity]. TIS-Office Toolbox • Edition 07/2007 The corresponding dialogue box will open. Company code 3 Select the TIS-Office database that contains the chart data to be checked.
TIS-Office Toolbox • Edition 07/2007 TIS-Office ToolBox User Guide Company manager features If you have selected one of the options only, the dialogue box will show either the Chart without modes group box or the Chart Total Not Same As Mode Total group box. Important 6 Select an entry from the list and click on – [Delete] if you want to delete a chart data record without modes. The selected chart data record will be deleted from the list and from the database.
TIS-Office ToolBox User Guide Company manager features ReIndex/Compress DB This feature is used to reorganise the index of a database and thus eliminate fragmentation. With large databases this can take some time.
TIS-Office ToolBox User Guide Company manager features "Compress/ IndexRebuild" dialogue box for database administrator If you are logged in as database administrator you can select a database. TIS-Office Toolbox • Edition 07/2007 Start re-index function 3 Click on [Compress]. A progress bar will show the process and a corresponding message will be displayed when compressing is complete. Do not stop the process by clicking on [Cancel]. This could irrevocably destroy the database.
TIS-Office ToolBox User Guide Database administrator features Database administrator features In addition to the functions described in Chapter "Company manager features", there are functions that can only be carried out by the database administrator. For information on the login credentials please refer to the Marginal note "Database administrator". It is highly recommended to save a backup copy of any database that is to be deleted, converted or upgraded.
TIS-Office ToolBox User Guide Database administrator features If you delete a database by clicking on [Drop] it will be physically removed from the computer and can be restored only with a previously saved backup. Caution Start the Drop function 3 Select the database from the list box and click on [Drop]. A message will be displayed to indicate the successful removal of the database. 4 Click on [OK] to close the message and then click on [Cancel].
TIS-Office ToolBox User Guide Database administrator features KiscanDB Converter It is, of course, possible to change from KISCAN to TIS-Office without losing any data stored in your database. However, you must convert your KISCAN database to the TIS-Office database format. TIS-Office Toolbox • Edition 07/2007 Proceed as follows: Important • Backup your KISCAN database, e.g. on an external storage. • Transfer the tables; see Chapter "KISCAN database conversion to ANSI format" on Page 30.
TIS-Office ToolBox User Guide Database administrator features Database fields Driver Data TIS-Office Toolbox • Edition 07/2007 : TU00-0881-01410 02 KISCAN Data Field Description Code Number Reference number Vehicle Vehicle assigned to the driver Hiring Date Hiring date Leaving Date Leaving date Department Site to which the driver is assigned Title Title Name Surname Forname Forename Maiden Name Maiden name Birth Date Date of birth Birth City Place of birth Birth Country Native
TIS-Office ToolBox User Guide Database administrator features TIS-Office Toolbox • Edition 07/2007 Vehicle Data KISCAN Data Field Description Vehicle Code Vehicle code, internal number License# Registration number Vehicle Type Transport type, e.g.
TIS-Office ToolBox User Guide Database administrator features Activity Data KISCAN Data Field Description Activity Date Activity date Start Time Start time of the activity Duration Duration Activity Activity type, e.g.
TIS-Office ToolBox User Guide Database administrator features KISCAN database conversion to ANSI format If more than one database has been maintained in KISCAN, each database must be converted individually. Important To convert the KISCAN tables to the ANSI format: 1 In Explorer copy all database files of the relevant company from the "Base1" folder to the "BaseInit" folder.
TIS-Office ToolBox User Guide TIS-Office Toolbox • Edition 07/2007 Parameters Database administrator features 3 Select the "Driver" tab and then "PARADOX" from the "Driver Name" list. 4 Set the "LANGDRIVER" parameter to "Paradox 'ascii'". 5 Click on the "System" tab. 6 Set the "LANGDRIVER" parameter to "Pdox ANSI Intl850". 7 Open the "File" menu, save the settings and close the window. The Explorer window is displayed again.
TIS-Office ToolBox User Guide Database administrator features 8 Start "BdeLang.exe" with a double click. TIS-Office Toolbox • Edition 07/2007 The PARADOX Tables : LangDriver Modification window will open. 9 Check the settings as shown in the screen above and select the "LangDriver Modification (DBE)" check box. The [Initialization of Files using the new LangDriver] button will be made available.
TIS-Office ToolBox User Guide Database administrator features KISCAN database conversion to TIS-Office format To convert the KISCAN database: 1 Start ToolBox 2 and enter the login data for the database administrator. Please refer to the Marginal note "Access to TIS-Office ToolBox 2" on Page 3. The Main Window For TISOffice DBA window will open. 2 Click on [KiscanDB Converter]. TIS-Office Toolbox • Edition 07/2007 The Migration: KISCAN TO TIS-Office DB Converter dialogue box will open.
TIS-Office ToolBox User Guide Start conversion Database administrator features 5 Click on [Start]. If you have selected Complete, the message below will be displayed. If you have selected Append, you can skip step 5. 6 Click on [Yes] to continue converting the database. If you click on [No] the process will stop and you can change the settings. 7 Confirm the message that conversion has been successful with [OK] and close ToolBox 2 with [Exit].
TIS-Office ToolBox User Guide Database administrator features TIS-Office Upgrades You can use a database created with an earlier TIS-Office version without losing any data. However, you must restore the database using the ToolBox Restore function and then upgrade it to the database format of the current TIS-Office version. If you have not selected the installation program's update function when updating TIS-Office, you must use this function to upgrade your databases.
TIS-Office ToolBox User Guide Database administrator features 6 Repeat steps 3 and 4 for each TIS-Office database. If you have created several companies, you must upgrade all the relevant databases. Important Please remember to upgrade the administrator database (TISAdminDB) too. Starting the service 7 Start the TIS-Office Service. Right-click on the Service icon in the notification area on the taskbar and select "Start" from the shortcut menu.
TIS-Office ToolBox User Guide Database administrator features Automatic Transfer Settings You use this function to assign transfer folders to your company sites and define the Outdoor Terminal settings for the automatic file transfer service (TISFileTransfer Service). This service enables you • to transfer download files from an Outdoor Terminal to a transfer folder. You can assign the transfer folders to your company sites; see the next chapter.
TIS-Office Toolbox • Edition 07/2007 TIS-Office ToolBox User Guide Transfer interval Database administrator features 3 Under "Transfer Files Every" modify the download file transfer interval to suit your company requirements. You can select 4, 8, 12, 16, 20 or 24 hours. The default setting is 24 hours. Please note that this setting also applies to the download interval on the Outdoor Terminal Settings tab; see also the Marginal note "Download interval" on Page 41.
TIS-Office ToolBox User Guide Database administrator features 6 Click on the button to the right of the "Folder Path" box to specify the transfer folder. The Browse for Folder dialogue box will open. TIS-Office Toolbox • Edition 07/2007 7 Select the folder and click on [OK]. The dialogue box will close and the transfer folder is displayed under Folder Path. 8 Click on [OK] and confirm the message telling you that the settings will be saved with [OK].
TIS-Office ToolBox User Guide Database administrator features You can modify the transfer folder assignment at any time. Just select the relevant entry from the list and click on [Modify]. Important 9 10 Perform Step 4 to Step 8 again to assign a transfer folder to any other site. Proceed by – making the necessary settings for transferring files from an Outdoor Terminal Start with Step 5 described in the next Chapter "Outdoor Terminal transfer settings".
TIS-Office Toolbox • Edition 07/2007 TIS-Office ToolBox User Guide Download interval Database administrator features 4 Under "Download Files Every" modify the Outdoor Terminal download file transfer interval to suit your company requirements. You can select 4, 8, 12, 16, 20 or 24 hours. The default setting is 24 hours. Please note that the download interval setting is the same as for Automatic File Transfer Settings; see also Marginal note "Transfer interval" on Page 38.
TIS-Office ToolBox User Guide Database administrator features Important The transfer folders must have already been assigned to a company site. If not, you cannot make a selection here. See also Chapter "Assigning transfer folders" on Page 37. TCP/IP settings 7 Enter the Outdoor Terminal's TCP/IP settings into the IP Address, Gateway and Subnet Mask boxes. Please contact your network administrator for the correct TCP/IP settings.
TIS-Office ToolBox User Guide Glossary TIS-Office Toolbox • Edition 07/2007 Glossary *.bkp File extension for database backup files. *.ldf File extension for database transaction log (protocol) files. *.mdf File extension for database files. These files contain the database contents. Administrator database Database that controls queries to the company database and maintains functions. In TIS-Office it is called "TISAdminDB".
TIS-Office ToolBox User Guide MSDE Glossary MSDE = Microsoft SQL Server Desktop Engine SQL Server version with a limited number of database management functions, limited data size (2 GB) and limited number of parallel access operations (max. 5 parallel processes). Re-index An index is a separate database file that stores information on the fields used in database tables. Thus, frequent queries can be performed more quickly. An index can get fragmented when data is being modified.
TIS-Office ToolBox User Guide Index Index A D Access ............................................................................ 3 – company manager.................................................... 3 – database administrator............................................. 4 ANSI.............................................................................. 31 Append data from KISCAN database............................ 33 Automatic Transfer Settings ..........................................
TIS-Office ToolBox User Guide Index G Q Glossary........................................................................ 43 Quit ToolBox 2 ................................................................ 9 I R Imprint ............................................................................. II Integrity of chart data .................................................... 19 Introduction ..................................................................... 1 Recalculate chart total................
TIS-Office ToolBox User Guide W TIS-Office ToolBox • Edition 07/2007 What you should know ....................................................
