CALLSHEET V 2.0
HELP !!!
Window screen shots :
Status Read Problem Solution Query Summary Help About
Abstract :
This page covers help for Call sheet program version 2.0. This is a Relational database management program for Call sheets which has information related to system problems, experiments in GMRT. This program is written in C++ using QT 3.3.4 libraries with MYSQL 4.0 as database server for Red hat Linux 8.0 and above.
History:
The first level call sheet program V 1.0 was written in 1999 by Mr. Jitendra Kodilkar in C using X Forms libraries for graphical interface and binary file for database. This program was used till 2003 and was a huge help for GMRT activities. Later GCC felt a need for modifications in program along with added data fields also this program was written for SOLARIS operating system and it was needed to work on Linux as Linux and Pentium processors where replacing SOLARIS based computers in GMRT.
Call sheet program V 1.99 was introduced in February 2004 which was written C++ with QT libraries 3.1.3 with MYSQL V 3.0 as database server on Red hat Linux 9.0 operating system. This program was a introduction for the present V 2.0 and flow of operations, report generation were totally new from the V 1.0. This program was successfully used till Nov. 2005. After receiving suggestions from various groups for more facilities and change in flow of operations V 2.0 was written. The present call sheet program v 2.0 covers all suggestions and modifications in operation flow along with some added features like taking screen shots, file attachment and web based status monitoring etc.
What is Call sheet ?
A Call sheet is record with information regarding system problems and experiments in GMRT. The record contains information at problem such as problem date and time, antenna name, system name and also about solution like description , solved by etc. This record keeps track of daily activities in GMRT and is useful for system analysis and future reference for the solutions. A printout of the record in proper format is assigned to staff and solution is written on the same which is to be entered later in database.
What is Database and RDBMS ?
Database is set of information related to each other. Relational database management software is a program which maintains a database with inter relations. This means database which are inter dependent like client correspondence database and sales database of a company , in which client name and address will be same. In this program call sheet number and antenna name is same for problem and solution data tables.
What is QT ?
It is C++ toolkit for multi platform GUI and application development by Troll tech. Same code will work for Windows , Linux and Mac operating systems. This is used for many applications like K DESKTOP and OPERA web browser etc. A GUI designer helps to choose and place graphical objects easily and user can write code for them using QT library functions which have database drivers for MYSQL,PGSQL and ORACLE. It is well documented with free future support for Linux.
What is MYSQL ?
It is popular free database server for multiple platforms. The database is generally in SQL format and a server handles the communication between database and the user. Server starts as operating system is loaded fully , then it bridges database and user. User can access database via server only. The user sends queries to server for all operations like creating new record, updating , or reading so user will get record its within program for accessing it.
High lights of the program :
Database is secured & accessible to authorized clients only.
Multiple users can access & modify data simultaneously.
Database can be modified without loss of old records.
Database import / export is easy so forwarding of old call sheets to next year is possible.
Database can be used by other programs such as Worksheet.
Tab box allows multitasking within single window.
Combo box allows easy selection of data value without typing.
Check box allows to view status with multiple combinations of antennas or systems.
Reading a Call sheet is simple and display is like print preview.
Status bar at bottom displays Tips or Current operation status.
System configuration stores system settings at problem.
4 system dependent queries are asked at problem time as first aid information of the problem.
Summary generation with multiple combinations of data fields is possible.
Report with full information can be generated for multiple combinations of data fields.
Both summary and report can be saved as text or postscript file.
Help is available for Overall program and summary generation.
Whats
new ?
1. New fields
added in problem and solution part are :
Problem part :
Assigned Date and Time, Assigned by, Assigned To
Solution part :
Release Date and Time, Released by, Entry by
2. Flow of Call
sheet generation and entry is changed.
3. Color indication for
Antenna and system in Status window is modified.
4. Printout
of Call sheet is changed with added fields also Call sheet No. and
Antenna name are highlighted on top.
5. User can view
history i.e previous problem or solution entries for any call sheet
and print.
6. User can attach files in POSTSCRIPT format to
call sheet and view,print.
7. User can take screen shot of
30to1 or band shape window and attach.
8. Summary and Report
can be generated as per previous method with added field
and
format
9. Current call sheet status can be viewed in HTML
format without logging in to
call sheet PC on following
address,
http://callsheet/callstatus.html
10.
Groups are requested to submit SOP's (in PS format) for the system as
per problem
code or in general which can be referred for
solution. This can be viewed from call sheet
program.
Database comparison table :
|
Data field in V 2.0 |
V 1.0 |
V 1.99 |
V 2.0 |
Format (size) in V 2.0 |
Remarks for V 2.0 |
|---|---|---|---|---|---|
|
Problem table |
|||||
|
Call sheet No. |
* |
* |
* |
int |
not null,auto increment, primary key |
|
Type |
NA |
* |
* |
varchar(16) |
|
|
Date |
* |
* |
* |
DATE yyyy-mm-dd |
From system clock |
|
Time |
NA |
* |
* |
TIME hh:mm:ss |
From system clock |
|
Observer |
* |
* |
* |
varchar(3) |
|
|
Antenna |
* |
* |
* |
varchar(3) |
|
|
System |
* |
* |
* |
varchar(3) |
|
|
Code |
* |
* |
* |
varchar(4) |
|
|
Description |
* |
* |
* |
varchar(32) |
|
|
Diary |
Common |
* |
* |
varchar(255) |
|
|
Configuration |
NA |
* |
* |
varchar(255) |
|
|
ADate |
NA |
NA |
* |
DATE yyyy-mm-dd |
From system clock |
|
ATime |
NA |
NA |
* |
TIME hh:mm:ss |
From system clock |
|
Assigned By |
NA |
NA |
* |
varchar(8) |
|
|
Assigned To |
NA |
NA |
* |
varchar(3) |
|
|
Res |
NA |
* |
* |
varchar(8) |
|
|
Solution table |
|||||
|
Call sheet No. |
* |
* |
* |
int |
not null,auto increment, primary key |
|
Status |
* |
* |
* |
varchar(8) |
|
|
Date |
* |
NA |
* |
DATE yyyy-mm-dd |
From system clock |
|
Time |
NA |
NA |
* |
TIME hh:mm:ss |
From system clock |
|
Released By |
NA |
NA |
* |
varchar(3) |
|
|
Entry by |
NA |
NA |
* |
varchar(8) |
|
|
SDate |
* |
* |
* |
DATE yyyy-mm-dd |
From system clock |
|
STime |
NA |
* |
* |
TIME hh:mm:ss |
From system clock |
|
System |
NA |
* |
* |
varchar(3) |
|
|
SubSys1 |
NA |
* |
* |
varchar(3) |
|
|
SubSys2 |
NA |
* |
* |
varchar(3) |
|
|
Unit |
NA |
* |
* |
varchar(3) |
|
|
Code |
NA |
* |
* |
varchar(4) |
|
|
Solved By |
* |
* |
* |
varchar(3) |
|
|
Entry By |
NA |
* |
* |
varchar(8) |
|
|
GSE |
NA |
* |
* |
varchar(3) |
|
|
Description |
* |
* |
* |
varchar(32) |
|
|
Diary |
Common |
* |
* |
varchar(255) |
|
|
Res |
NA |
* |
* |
varchar(8) |
|
How to 's for program :
Generate New call sheet Click on 'Write' tab => Click on 'Problem' tab => Click on 'clear' button => Click and select field values or enter => fill up all fields => click on 'save new' button to generate new call sheet.Attach plots / pictures to call sheet after it is saved. To attach files :Click on 'Write' tab => Click on 'problem' tab => Enter call sheet no. in 'assign/modify' box and press 'enter' key => Click and select 'Attach PS file' button.Use 'Take screen shot' to grab a picture available on screen- save it as postscript with extension *.ps and then proceed to Attach file.
Note: Any Attached files will be indicated in the Problem diary area.You can not print call sheet unless it is assigned to staff.
Assign call sheet
Click on 'Write' tab => Click on 'problem' tab => Enter call sheet no. in 'assign' box and press 'enter' key => Click and select on combo box 'To' to assign it to staff member => Click on 'assign' button.
Release call sheet
Click
on 'Write tab' => Click on 'Solution' tab => Enter call sheet
no. in 'release' box and press 'enter' key. => Click and select
'Released by' combo box => Click on Release' button.
Note.
Releasing of Call sheet means problem is
solved but solution part is not entered. As Antenna can be used for
the observation the status in call sheet program is changed to GREY
color.
Entering solution
Click on 'Write tab' => Click on 'Solution' tab => Enter call sheet no. in 'Call sheet' box and press 'enter' key. => Click and select field values or enter => fill up all fields => Click on 'Save' button.
Note. Files in postscript format can be attached to the solution (ref 1 above).
Summary / Report generation
Click on 'Summary' tab => Click on 'Query' tab => Click and select or enter field values => Click on 'summary' / 'Report' button => In 'Report/Summary' tab => Click on 'Save' button to save it as text file or print directly.
Note. Summary is generated on combinations of the selected field so keep fields blank for which summary is not needed. Also refer to 'Help' in Help window.
For
feedback contact :
Email
: sandeep@gmrt.ncra.tifr.res.in
Mr
Sandip S. Parkhi
Email
: ajit@gmrt.ncra.tifr.res.in
Mr
AjithKumar B.
