 |
|
PRODUCT: Web Organization Chart |
VERSION
: 2.4
|
 INDEX |
|
|
| Overview |
|
|
Web Organization Chart
(WebOrgChart) 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 in an organization
chart.
Using XSL customization your
organization will be able to use existing data to
transform it into building blocks that will be
presented in the chart giving establishment wide
scope that will be distributed immediately.
WebOrgChart comprises of a
very simple and intuitive user interface supported
by your existing Active Server Pages backend
infrastructure providing your organization's
desktop with security and reliability or your
existing infrastructure and improving your
communication standards and HR management
WebOrgChart 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.
WebOrgChart 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 a HR database table. WebOrgChart
will create a 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.
There is also the availability to view personal information in different
formats of data including the employee's photo, which can be displayed on
the right frame by clicking on the View icon of the person. The
Orgchart view frame is designed so that you can retrieve the employee's photo
from the hard drive, or any other type of database. Our sample application
assumes that the employee's photo already exists on the hard drive.
An administrator can also insert, edit, delete and move any
employee to your Orgchart. To do this, you need to call manager.asp and enter
the admin password. After entering the admin password, you will see the tree
chart with one more icon (the Edit icon) for each employee record. By clicking
on that icon, you can insert a new employee, edit, delete or move the current
employee.
The data on the Organization Chart program is read only for
everybody except the admin person. The WebOrgChart application has the ability
to be modified to a greater or lesser degree based on your company's needs.
|
|
|
|
|
|
| Web
Organization Chart Program version 2.4 new Features |
|
New features in version 2.4:
1. Can display multi level display chart.
2. Can display 3 Level display chart.
3. Can display Chart in Matrix format.
4. Can display Multi chart from your XML data.
5. Can display 3 Level chart from your XML data.
6. Can display Matrix Chart from your XML data.
7. Multi level and 3 level display chart can be easily customized by either
yourself or us.
|
|
|
|
|
|
| Different
Chart style |
|
|
When loading the default.asp the "Tree Chart" will be shown on the left frame and
the "Chart View" to the right frame. To view the chart in the right frame you need
to click on the employee name in the left frame. A picture of each employee can be
placed in that giving a higher level of personalization for your departments.
There are 8 available chart
styles in this version.
|
Standard format |
|
The drawing lines are coming from top to bottom.
You need to have :
ChartStyle = 0
Secretary = ""
in the setting.asp to draw this type of chart.
Standard
|
|
|
|
|
Full Chart |
|
You can view the chart in "Full display" format. In this view all 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 into the Stylesheet Section.
Full Chart
|
|
|
|
|
3 Levels Display |
|
The "3 Level" display format, allows you to view up to 3 levels of the chart at
a time, i.e. 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 Levels 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 (vertical) 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 into the Stylesheet Section.
|
|
|
|
|
|
|
Support Secretary Style |
|
Like standard style the drawing lines are coming from top to bottom except for the secretary which is coming 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.
To be able to update this field from the admin mode, you need to include this field in your setting.asp and in the arrProperties parameter. (We have that in our setting.asp page)
Since this is the Boolean field, you can either have the true or false value for the update.
You need to have :
ChartStyle = 0
Secretary = "Secretary"
in the setting.asp to draw this type of chart.
Support Secretary Style
|
|
|
|
|
Ladder format |
|
The lines are coming from left to right.
You need to have :
ChartStyle = 1
Secretary = ""
in the setting.asp to draw this type of chart.
Ladder format
|
|
|
|
|
Multiple Category Style 1 |
|
You can divide employee to different category like: E for employee, C for
Contractor.
You can set the background color of each category frame to the color that you
would like.
You need to have :
| Category = "Category"
|
(Database Field Name. You need to have the
field called Category in your database to use this style.) |
| ReDim arrCategory(1, 1)
|
|
| arrCategory(0, 0) = "E"
|
(Defines the first Category. You need to
have the data value of E in the Category field in your
database.)
|
| arrCategory(0, 1) = "Green"
|
(Define the back ground color of Green) |
| arrCategory(1, 0) = "C"
|
(Defines the second Category. You need to
have the data value of C in the Category field in your
database.)
|
| arrCategory(1, 1) = "Red"
|
(Define the back ground color of Red) |
in the setting.asp to draw this type of chart.
Where arrCategory is 2 dimensional array. First element defines the maximum
number of the category minus 1.
The second element of the array is always 1. It defines the back ground color
of the Category. In the above example we have only two different Category.
Employee (E) and Contractor (C). We want the Green back ground color for
Employee and Red for Contractor.
Category 1
|
|
|
|
|
Multiple Category Style 2 |
|
Similar to Multiple Category Style 1 plus you can also define the dotted frame
border for any category.
You need to have :
| Category = "Category"
|
(Database Field Name. You need to have the
field called Category in your database to use this style.) |
| ReDim arrCategory(1, 2)
|
|
| arrCategory(0, 0) = "E"
|
(Defines the first Category. You need to
have the data value of E in the Category field in your
database.)
|
| arrCategory(0, 1) = "Green"
|
(Defines the back ground color of Green) |
| arrCategory(0, 2) = 0
|
(Defines normal border frame) |
| arrCategory(1, 0) = "C"
|
(Defines the second Category. You need to
have the data value of C in the Category field in your
database.)
|
| arrCategory(1, 1) = "Red"
|
(Defines the back ground color of Red) |
| arrCategory(1, 2) = 1
|
(Defines dotted border frame) |
in the setting.asp to draw this type of chart.
Where arrCategory is 2 dimensional array. First element defines the maximum
number of the category minus 1.
The second element of the array is always 2. It defines the back ground color
of the Category plus the frame border. In the above example we have only two
different Category. Employee (E) and Contractor (C). We want the Green back
ground color for Employee and Red for Contractor. For the contractor we want to
have dotted frame border
Category 2
|
|
|
|
|
| Different
Tree style |
|
There are 2 available tree
styles in this version.
|
Standard format |
|
|
When you start the chart, the tree is in the collapse mode. You need to click on
the + sign to expand each node.
You need to set the following property of the Chart object to false :
DisplayAll = false (Default is standard format)
to view this type of tree.
Standard
|
|
|
|
|
Expanded format |
|
When you start the chart, the tree is in the expanded mode.
You need to set the following property of the Chart object to true :
DisplayAll = true
to view this type of tree.
Expanded
|
|
|
|
|
Display Legend |
|
You can display the Legend of the chart at the end of this frame.
You need to set the following setting in the setting.asp to 1 :
Legend = 1
to view the Legend.
Legend
|
|
|
|
|
Display HeadCount |
|
You can also display the Heand Count of the chart at the end of this frame.
You need to set the following setting in the setting.asp to 1 :
HeadCount = 1
to view the Legend.
HeadCount
|
|
|
|
|
|
|
| Administrative Functions
|
|
|
Administrative tasks such as adding, update and delete an employee
information can be accomplished by using the administration panel exposed by
Manager.asp. (You can not update or delete when you are attaching to the
recordset). To be in the admin mode, call Manager.asp and enter the password.
The default system password is Manager
however it can be changed using the Manager.asp page.
After entering the password and getting the chart, you can click on the edit
icon to add, update or delete any employee information. From the edit.asp page,
type the proper employee information, select the proper transaction from the
Command option control, and click on the Submit button. Records for new
employees are inserted immediately following the previously selected record.
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.
To be able to update this field from the admin mode, you need to include this
field in your setting.asp and in the arrProperties parameter. (We have that in
our setting.asp page)
Since this is the Boolean field, you can either have the true or
false value for the update.
|
|
|
|
|
|
| Search
Employee |
|
|
Searching functionality is also exposed by Weborgchart. Simply, from
default.htm page click the Search Employee link. Enter the name of the employee
in the search page and click enter. You will get the list of employees having
the same name. If you click on each employee in the searched list you can
browse the chart from that employee.
Search Employee
Results
|
|
|
|
|
|
| Advanced Topics (Using Stylesheet) |
|
|
For each node both XSL transformation scripts (structure and matrix) displays the information from the source XML.
Each node is described by a single < ROW…> tag, any specific node attributes are presented as < 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 WebOrgChart:
< 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 = re.exec(strUrl);
if(arr != null)
return arr[1];
return ‘’;
}
Furthermore, there is the toggleLevel() function which handles the behavior and appearance of the
navigation
function toggleLevel(img, el1, el2)
{
if (el1.style.display == ‘none’)
{
img.src = ‘images/newup.gif’;
el1.style.display="block";
el2.style.display="block";
}
else
{
img.src = ‘images/newdown.gif’;
el1.style.display="none";
el2.style.display="none";
}
}
The toggle level will also be dictated by the type of chart schema in currently loaded (3 level or matrix).
|
|
|
|
|
|
| Application
setup |
|
|
| What
customers can do to tailor Organization Chart to their specific requirements |
|
|
Since each customer may require different enhancements or modifications,
WebOrgChart is designed so that it can be individually customized .
It is easy to link the chart frame page to any other HR asp page that you might
have in your organization.
Web Organization chart can be used as a plug in to your current HR application
by linking to your HR table.
Within the Orgchart application, there are many places where you can customize
the chart display.
Sample1.asp's sample code shows how you can display the chart on the web by
passing the info from a different location than tree.asp. In this sample, the
chart.asp is linked to one simple HR table or view.
You can build your own link from your own tables to the chart.asp page.
To perform other modifications to the WebOrgChart, contact AASOFTECH or email
at: support@aasoftech.com
.
If you look at any of the following pages you will notice you can call these
pages directly yourself without using the Web Organization Chart navigation
flow.
Tree.asp
Chart.asp (You only need to pass the Manager ID in the QueryString Format)
FullChart.asp (You only need to pass the Manager ID in the QueryString Format)
MatrixChart.asp (You only need to pass the Manager ID in the QueryString
Format)
3LevelChart.asp (You only need to pass the Manager ID in the QueryString
Format)
|
|
|
|
|
|
| How
to uninstall the Organization program |
|
|
If you have installed the application using Express setup
-
Start the control panel.
-
Start Add/Remove program.
-
Select "Web Organization Chart".
-
Click on the Remove push button.
|
|
|
|
|
|
| Requirements
for using Organization program |
|
|
You need to have:
Microsoft Internet Explorer version 4.0 or higher on the client machines.
Microsoft Windows NT on the server with IIS 4.0 installed.
VB 6.0 dependency files.
MSXML 3.0 or higher.
HR database and table or recordset in your system.
|
|
|
|
|
|
| How
to print the Organization Chart |
|
|
After you create the chart, you can print it. From the menu bar, click on File
and then click on Print to print the chart. You can create the chart either
using chart.asp or allchart.asp.
|
|
|
|
|
|
| Frequently
Asked Questions |
|
|
Q: I have downloaded and set up the Web Org. chart Trial version on my IIS
server. When I try to start it on my local development server, I get a Type
mismatch error: |
|
A: You have to create the File DSN (not the System DSN) and correctly point it
to the chart.mdb file. Perform the following sequence:
From the Start Menu, open your control panel
Click on ODBC data source.
If you have already created a System DSN, click on the System DSN tab , select
the file and click on the Remove button.
Click on the DSN tab.
Click on the Add button,
Select "Microsoft Access Driver" and click on Next.
Type "Chart"; and click on Next.
Click on Finish.
Click on the Select button.
Find Chart.Mdb and click OK.
Open your Setting.asp page
Change the following line from:
GetConnectionString = "dsn=chart"
To:
GetConnectionString = "Filedsn=chart"
Save the page.
Close your browser.
Stop IIS.
Start IIS.
Start your browser.
|
|
|
Q: I have created the DSN. I still get Type mismatched. |
|
A: The problem is that you can not connect to the database. There is a asp page
coming with the product called TestConnection.asp. Modify the dsn in this asp
page and try to run it. Any dsn (filedsn, system dsn or dsnless connection
string) defined in this page can be used in the setting.asp.
If TestConnection is not working with any dsn, use one of the dsn that you use
in other application and try that one. If that one is not working then update
your ADODB from Microsoft site for free. This is the URL:
http://www.microsoft.com/data/download.htm
|
|
|
Q: What are the new features in version 2.3.3 |
You can:
Update the chart from the web using the admin utility (Manager.asp).
Format the chart frame screen (change the font, background color, foreground
color and a lot more) using Chart setting page.
View an employee's photo from the view frame.
Browse and print the whole chart.
Filter to view part of the chart.
Have 8 different chart styles plus 2 different tree styles.
Search the employee.
|
|
|
Q: What are the new features in version 2.4 |
You can:
Can display multi level display chart.
Can display 3 Level display chart.
Can display Chart in Matrix format.
Can display Multi chart from your XML data.
Can display 3 Level chart from your XML data.
Can display Matrix Chart from your XML data.
Multi level and 3 level display chart can be easily customized by either
yourself or us.
Version 2.4 uses Stylesheet to display Full display, Multi level, 3 level
display. For more information about how to set your data fields in the
stylesheet have a look at the stylesheet document
|
|
|
Q: Who should we contact? |
|
Contact AASoftech at sales@aasoftech.com
(for order or trial version) or support@aasoftech.com (for technical support)
for any more information or go to:
http://www.aasoftech.com.
Or mail us at:
AASoftech Inc.
1909 Baton Drive
Vienna, VA 22182
USA
|
|
|
|
|
|
| Custom
setup |
|
|
Install VB 6.0 dependency files |
|
|
|
|
|
Web Organization Chart Installed files |
|
|
-
You should see following files there:
-
Component/Orgchart.DLL: This is the DLL used in the application
-
Default.htm: This is the startup .htm page to display the link to all aother
asps and help file.
-
Default.asp: This is the startup .asp page to display the tree and chart frame.
-
Tree.asp: This displays the chart in the format asp page.
-
Chart.asp: This displays the chart for each supervisor (manager)
-
FullChart.asp: This is the startup .asp page to display multi level chart.
-
3LevelChart.asp: This is the startup .asp page to display up to 3 level chart.
-
MatrixChart.asp: This is the startup .asp page to display the chart in Matrix
format.
-
ChkPWD.asp: This page is used to check the Manager password for accessing the
admin (edit.asp page) utility.
-
Edit.asp: This page is used by the admin to edit employee's information.
-
View.asp: This page is used to display personal information as well as
employees' photos.
-
Error.asp: This page is used by other asp pages to display any errors.
-
Manager.asp: This is the entry page for the admin to enter the admin password.
-
Proceed.asp: This page is used internally by the other asp page.
-
Refresh.asp: This page is used internally by the other asp page.
-
Setting.asp: This is an entry place to change or modify any setting like
database name, table name, fields, etc..
-
Treecmd.asp: This page is used internally by the other asp page.
-
AllDefault.asp: This page is used to display the tree.asp and the allchart.asp
page.
-
AllChart.asp: This page is similar to chart.asp except that it displays the
rest of the chart starting with the supervisor selected by tree.asp.
-
VerticalChart.asp: This page is similar to tree.asp except that it displays the
employee information in the frame format.
-
Sample1.asp: Sample page to display how you can use another table to link to
chart.asp
-
ListView.asp: sample page related to the Sample1.asp example.
-
Images/Edit.gif
-
Images/Plusb.gif
-
Images/minustb.gif
-
Images/back.gif
-
Images/linetb.gif
-
Images/linet.gif
-
A lot of other gif files.
-
WebOrgChart.htm
-
Database/Chart.MDB sample HR database
-
Database/Chart.dsn sample ODBC DSN.
|
|
|
|
|
ASSIGNING A DATA SOURCE NAME (File DSN) FOR THE OrgChart DATABASE |
|
|
Although the database that you use to get HR information can reside anywhere,
you'll need to set up a data source name with ODBC on the system where the
database is located. If you are using the example database (chart.mdb) and
default File DSN (chart), follow the directions below.
-
Run the ODBC Data Source Administrator found in the Control Panel
[Start/Settings/Control Panel and then select the 32bit ODBC icon].
-
Select the File DSN tab and click the Add button.
-
A list of ODBC drivers will be displayed. Highlight the 'Microsoft Access
Driver (*.mdb)' line and click the Finish button.
-
In the Data Source Name text field, type 'chart'
-
Click the Select button and browse to the Database directory. Select the file
'Chart.mdb'.
-
Click the OK button to complete the ODBC registration.
If you need to change the DSN (and/or the database), assign a new DSN (and/or
database) and restart the asp pages.
IMPORTANT NOTE:
With some systems, you may have to reboot your operating system in order for
the changes to take place. Not having your system recognize a change in DSN
(and/or database) assignment is the most common source of error.
If you choose a different Data Source Name than the default of "Chart", you'll
need to set the DSN property to the value of your new Data Source Name. Simply
set the DSN property in your asp host file:
GetConnectionString = "dsn=chart"
While the ODBC property value for a SQL Server DSNcouldbe:
GetConnectionString="DSN=DSNChart;UID=MyUserID;PASSWORD=MyPassword;"
You can basically treat the DSN property as any ADO Connection String. This
means that you can use Native Providers as well as ODBC Providers, which may
speed your OrgChart connection up quite significantly. The native OLEDB
provider for Access is:
GetConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51; Data
Source=c:\Database\Chart.mdb"
A typical Native Provider connection string for SQL Server is:
GetConnectionString = "Provider=SQLOLEDB; Data Source=DSNChart; Initial
Catalog=DBcat; UID=MyUserID; PASSWORD=MyPassword;"
In case you still can not connect to the database, there is a asp page coming
with the product called TestConnection.asp. Modify the dsn in this asp page and
try to run it. Any dsn (filedsn, system dsn or dsnless connection string)
defined in this page can be used in the setting.asp. If TestConnection is not
working with any dsn, use one of the dsn that you use in other application and
try that one. If that one is not working then update your ADODB from Microsoft
site for free. This is the URL:
http://www.microsoft.com/data/download.htm
|
|
|
|
|
MODIFY Setting.asp |
|
|
Setting.asp is the place where chart settings can be individually customized.
Setting.asp is included in all other asp pages.
The settings that must be changed are indicated in italics below.
-
sTableName
= "ReportTable" Enter the name of your HR (organization) table
-
GetConnectionString
= "Filedsn=chart" 'Enter the DSN-less Connection String or the File DSN that
you want to use. In this example, chart is the DSN that is identified to
connect to the database.
-
sChildField
= "ORG_ID" ' Enter employee ID here. Employee ID should exist in the table that
you have identified
-
sParentField
= "MGR_ID" 'Enter employee ID here. Employee ID should exist in the table that
you have identified
-
OrderField
= "Name" 'Enter the field that you would like to order the chart.
-
redim arrProperties(2)
'Redim to the number of items that you want to view in the chart MINUS 1. If
you want to see phone number and title which are two items then type 1 which is
2 minus 1
-
arrProperties(0)
= "Name" 'Field name in the HRTable that you want to display in the chart
-
arrProperties(1)
= "Job Title" 'Another field name in the HRTable that you want to display in
the chart
-
arrProperties(2)
= "Dept Name" 'Another field name in the HRTable that you want to display in
the chart
-
redim arrTreeFieldName(0)
'Redim to the number of items that you want to view in the tree MINUS 1. If you
want to see Name which is one item then type 0 which is 1 minus 1.
-
arrTreeFieldName(0) = "Name" 'Field name in the HRTable that
you want to display in the tree.
|
|
|
|
|
Orgchart advance setting |
|
|
The following are new settings that you can customize in the Orgchart. These
settings relate to formatting the chart within the chart frame.
-
Screenwidth: This is the width of the screen in the chart.
-
SupervisorFrameHeight:This is the height of your
supervisor frame in the chart.
-
SupervisorFrameWidth:This is the width of your supervisor
frame in the chart.
-
EmployeeHeight:This is the height of your employee frame
in the chart.
-
EmployeeWidth:This is the width of your employee frame in
the chart.
-
EmployeeHSpace:This is the space between each employee
frame.
-
SupFrameborder:This is the width of the Supervisor frame
border.
-
SupFrameBackColor:This is the background color of the
Supervisor frame.
-
EmpFrameBackColor:This is the background color of the
Employee frame.
-
SupBorderIsOutSet:This is the boolean (true / false) value
to define if the Supervisor border style is outset.
-
EmpBorderIsOutSet:This is the boolean (true / false) value
to define if the Employee border style is outset.
-
SupervisorFont:This is the font of Supervisor frame.
-
EmployeeFont:This is the font of Employee frame.
-
SupervisorFontSize:This is the font size of Supervisor
frame.
-
EmployeeFontSize:This is the font size of Employee frame.
-
WhereField:This is the existing field within your database
that is used for filtering. An example would be WhereField = "[Dept Name]" in
our sample database.
-
WhereValue:This is the value for the filtered field. An
example would be 'HR' as the filter value for [Dept Name] in our sample
database.
-
For more information have a look at How to create the filter to
view part of the chart.
-
Category:(Optional) Field name in the HRTable to define
different Category.
-
arrCategory:(Required if you have defined Category) For
more information read Multiple Category Style 1 and Multiple Category Style 2
section.
-
ChartStyle:0for standard and 1
for ladder format. For more information read Different Chart Style section.
-
Secretary:(Optional) Boolean Field name in the HRTable to
define Secretary field
-
Legend:(Optional) Field to display the Legend. "1" means
to display the legend.
-
HeadCount:(Optional) Field to display the Head count. "1"
means to display the Head count.
|
|
|
|
|
How to create the filter to view part of the chart |
|
|
From the Web Organization Chart version 2.3.1, you can create the filter to
view just the portion of the chart that you have filtered. The filter can be
used by the company that wants each department to view their own department.
You can define the filter field as (WhereField variable in the setting.asp).
You can also define the filter value as (WhereValue field in the setting.asp)
to identify which portion of the chart you would like to see. For example, if
you would like to view only the HR portion of the organization, you need to
define the WhereField as [Dept Name] and the wherevalue as 'HR'. In this
scenario the chart is viewed only for HR department. Remember the [Dept Name]
must be one of the valid fields in your table. On the other hand, if you would
like to view the Canada section of your orgchart you need to define the
WhereField as Section and the WhereValue as Canada, and so forth.
The following two fields are used as the filter field. If both of them are
used, the program creates the filter for that criteria.
WhereField:
This must be one of the valid fields in the database. It is the filter field
that can be used in the application to view the chart by adding the filter
value for that field. You can use this field with the WhereValue parameter.
WhereValue:
This is the filter value for WhereField.
For example:
If
WhereField:="[Dept Name]" And
WhereValue="'HR'"
That means that the chart is filtered and displays only the employee whose
[Dept Name] = "'HR'"
|
|
|
|
|
START Default.asp |
|
|
All employees can use the system by clicking on default.asp
From your browser point to OrgChart.asp and start it. (For instance:
http://localhost/WebOrgchart/Default.asp)
Admin users can start the system using manager.asp. (For instance:
http://localhost/WebOrgchart/Manager.asp)
|
|
|
|
|
| How
to migrate from version 1.0 to Version 2.x |
|
|
-
Close all the browsers.
-
Unregister orgchart.dll
Regsvr32.exe /u [Full path of the dll]\Orgchart.DLL
-
Run the setup.exe
|
|
|
|
|
|
| Contact
us |
|
For each node both XSL transformation scripts (structure and matrix)
displays the information from the source XML. Each node is described by a
single
tag, any
specific node attributes are presented as XML attribute,
e.g. .
Both XSL transformation scripts have a special template named
"RenderNodeCell". If is defined as follows:
...
This 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 and Web.Config (this is
shown in the following
section).
|
| Orgchart.DLL
Public methods |
|
|
BuildTree (ManagerID as Variant) |
|
Creates the tree chart starting with the Manager ID passing to the method.
Tree.asp uses this method to display the tree chart.
|
|
|
BuildChart (ManagerID as Variant) |
|
Creates the chart of the supervisor (manager) having the Manager ID as his key
and of all the employees associated with that supervisor. Chart.asp uses this
method.
|
|
|
BuildAllChart (ManagerID as Variant) |
|
Creates all the charts starting with the supervisor (manager) having the
Manager ID as his key and of all the employees associated with tha | | | | | |
