›  Survey Software
------------------

    ›  Survey Consulting

------------------

    ›  Survey Articles

------------------

    ›  HR Software

------------------

    ›  Order Information

------------------

    ›  William Steinberg
------------------

    ›  View Cart
 Product Search help
.
INDEX
  1. Overview
  2. Desktop Organization Chart Program Version 2.0 Features
  3. Different Chart Styles
  4. Different HTML Chart Format
    1. Horizental Format
    2. Full Chart
    3. 3 Levels Display
    4. Matrix Display
    5. Full Chart (Secretary)
    6. 3 Levels Display (Secretary)
    7. Matrix Display (Secretary)
  5. Table Setup
  6. Advanced Topics (Using Stylesheet)
  7. Application Setup (Installation)
  8. Running the Application
  9. Tailoring Organization Chart to Specific Requirements
  10. Requirements for Using Organization Program
  11. Printing the Organization Chart
  12. Frequently Asked Questions
  13. Custom Setup
    1. Installing VB 6.0 Dependency Files
    2. Desktop Organization Chart Installed Files
    3. Assigning Data Source Name (file DSN) for OrgChart Database
    4. Creating the Filter to View Part of the Chart
    5. Starting Default.asp
  14. Contact Us
  15. License Agreement

Overview

Desktop Organization Chart (DesktopOrgChart) is an application used to create corporate organizational charts based on personnel information from a database directly to your Intranet or Extranet. It allows you to automatically examine your current employee's information in the outlined form of an organization chart.

Desktop Organization Chart can be used by HR administrators with minimum computer knowledge. It can also be used by developers who would like to customize and integrate the application with other corporate applications.

Desktop Organization Chart can be installed on Window 95, XP and 2000 series. The chart output result could either be an html file or a windows form. Html chart result can be deployed on any computer platform on the server and can be viewed by IE browser.

You can print the char using windows chart format.
Desktop Organization Chart comes with the sample access database. However, you can connect the application to other databases like SQL server or Oracle.

Orgchart can be displayed in two different styles, HTML or Windows format. You can copy HTML chart to the server and enable the employees to view it by IE browser. Windows chart style retrieves data directly from the database and displays the chart instantaneously.

To generate the Windows Chart simply select Windows Chart Style, type the (Person) ID of the person desired at the Root and click on "Generate" Button.

In Windows Chart you can:
Click on the top left icon of the manager employee to expand and collapse the chart.
Copy the chart using "Copy to Clipboard" button and paste it in the word.
Print the Windows Chart.

By using XSL customization, your organization will be able to use existing data to transform it into building blocks presented in the chart. This will give establishment wide scope that will be distributed immediately.

DesktopOrgChart comprises of a very simple and intuitive user interface supported by your existing XP/Windows 2000/Windows 2003 backend infrastructure.

DesktopOrgChart provides you with security and reliability to improve your standards of communication and HR management. It will enable you to create corporate organizational charts based on personnel database tables (or recordset). In each organization, a HR table contains information on existing personnel data.

DesktopOrgChart can connect to any HR table (or recordset). It is as simple as defining two child identifier fields (i.e.: an employee ID) and a parent identifier (a supervisor ID) from an HR database table. DesktopOrgChart will create tree format charts based on the current database connection.

Once created, the chart can retrieve the organizational data, formatted in a chart, for the selected individual and his/her subordinates, superiors, and associated employees on the right hand side of the screen by simply clicking on the desired person. You can then print your chart.

The data on the Organization Chart program is read only for everybody except the admin person. The DesktopOrgChart application can be modified to a greater or lesser degree based on your company's needs.

 

Desktop Organization Chart Program Version 2.0 Features

1. Can display multi-level display chart.
2. Can display 3-Level display chart.
3. Can display chart in Matrix format.
4. Can display Full chart.
5. Can display Horizontal chart.
6. Multi-level and 3-level display chart can be easily customized by either yourself or us.
7. Display the Full chart in windows form.
8. Full print support in Windows Full chart.
9. Can copy Windows Full Chart and paste it to Word document.

Different Chart Styles

Orgchart can be displayed in two different styles, HTML or Windows format.

HTML Chart Style

You can copy HTML chart to the server and enable the employees to view it by IE browser.

Windows Style

Windows chart style retrieves data directly from the database and displays the chart instantaneously.

Different HTML Chart Format

There are 7 available chart styles in HTML chart format.

Horizontal

Employees under specific supervisor are all displayed horizentally.
Horizontal

Full Chart

You can view the chart in "Full" display format. In this view all of the chart elements can be displayed by simply clicking on the expand/collapse icon.
You have the option to put the picture of your employee in the chart.

Have a look at the Stylesheet section.



Full Chart

3 Level Display

The "3 Level" display format allows you to view up to 3 levels of the chart at a time. In other words, if you click on any supervisor’s icon on level 3, level 1 is replaced by level 3, and you can see the other levels of the chart. You can view the Chart in "3 Level" display if you click on "3 Level" icon on the top of the page.

Have a look into the Stylesheet section.



3 Levels

Matrix Display

The "Matrix display" format is used to view up to 3 levels of the chart at a time. Level 3 is displayed differently (vertically) compared to "3 Level" display. If you click on any supervisor’s icon on level 3, level 1 is replaced by level 3, and you can see the other levels of the chart. You can view the chart in Matrix display if you click on "Matrix" icon on the top of the page.

Have a look at the Stylesheet section.


Matrix display

Full Chart (Secretary)

Like "Full Chart" style, the drawing lines displayed vertically from top to bottom, except for the secretary, which is displayed horizontally from right to left.
If you want to use the chart having the secretary type display, you need to have this field in your database. We have similar field called "Secretary" in our sample database.
Since this is the a boolean field, you can either have a true or false value for the update.

Full Chart (Secretary style)

3 Levels Display (Secretary)

Like "3 Levels" style, the drawing lines are displayed vertically from top to bottom, except for the secretary, which is displayed horizontally from right to left.
If you want to use the chart having the secretary type display, you need to have this field in your database. We have a similar field called "Secretary" in our sample database.
Since this is a boolean field, you can either have the true or false value for the update.

3 Levels Display (Secretary style)

Matrix Display (Secretary)

Like "Matrix" style, the drawing lines are displayed vertically from top to bottom, except for the secretary, which is displayed horizontally from right to left.
If you want to use the chart having the secretary type display, you need to have this field in your database. We have a similar field called "Secretary" in our sample database.
Since this is the Boolean field, you can either have the true or false value for the update.

Matrix Chart Display (Secretary style)

Table Setup

By clicking on "Setup" button in the application you will get the setup window.

In the setup window, you can set the connection string to point to your database.
You can also define your HR table, View name, and the fields within your HR table.

If you want to use the chart having the secretary type display, you need to have this field in your database. We have a similar field called "Secretary" in our sample database.
Since this is the Boolean field, you can either have a true or false value for this field.

 

Advanced Topics (Using Stylesheet)

For each node, both XSL transformation scripts (structure and matrix) display the information from the source XML.

Each node is described by a single < ROW…> tag, and any specific node attributes are presented as an < ROW…> XML attribute, e.g. .

Both XSL transformation scripts have a special template named "RenderNodeCell" (look at the stylesheet file).

< xsl:template nasme=”RenderNodeCell”>
< xsl:param name=”node”/>
< xsl:param name=”level”/>
< xsl:attribute name=”class”>
...
< xsl:value-of select=”$node/@{Field0}”/>< br/>
< img>
< xsl:attribute name=”src”>< xsl:value-of
select=”local:getPicture(string($node/@{Field6}))”/>
< /xsl:attribute>
< /img>< br/>
< xsl:value-of select=”$node/@{Field1}”/>< br/>
< xsl:value-of select=”$node/@{Field2}”/>< br/>
< xsl:value-of select=”$node/@{Field7}”/>< br/>
...
< /div>
< /xsl:template>

The template is called whenever the transformation is rendering a cell content to the HTML. In order to add or remove fields to be displayed inside the chart information box, the RenderNodeCell template has to be modified along with the schema of the database.

Implicit and Custom XSL Functions
Some of the functions already existent in the XSL files are used for implicit calls to the generated XML file, which is retrieved from the database.

i.e.:
The function getEmailAddress() is used to retrieve the node where email address information is contained. The context of this function can be customized. The sample of a node retrieved in XML format from the database would be:
Database stored value:

sales@aasoftech.com

XML format retrieved from DesktopOrgChart:

< Email >
< ![CDATA[sales@aasoftech.com]]>
< /Email>
In order to capture it, we use the following function:
function getEmailAddress(strMailto)

{
var re = new RegExp("’mailto:(.*)’","i");
var arr = re.exec(strMailto);
if(arr != null)
return arr[1];
return ‘’;
}
However this function can be modified according to your database field format to either retrieve entire HTML tags stored in the database or retrieve only the email address and build the tags back in the XSL file. The same concept can be used with other functions such as getPicture(), which is used to return the relative location including the HTML tag of the employee picture.
function getPicture(strUrl)
{
var re = new RegExp("src=’(.*)’","i");
var arr =