[Pocolap-cvscommit] pocolap/data/scripts_tools/outdated MANIFEST.MF,NONE,1.1 sampleconfig.xml,NONE,1

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/pocolap/pocolap/data/scripts_tools/outdated
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9992/data/scripts_tools/outdated

Added Files:
	MANIFEST.MF sampleconfig.xml testPage.jsp config.xml build.xml 
	setupNSS.sql web.xml CaseConverter.pl 
Log Message:
Reorganization of resources

--- NEW FILE: MANIFEST.MF ---
Manifest-Version: 1.0
Created-By: TaR
--- NEW FILE: build.xml ---
<project name="Package MCS site" basedir="." default="run">
	<property name="zipFile" value="site.zip" />
	<property name="buildDir" value="build" />
	<property name="topDir" value="../../" />
	<property name="srcDir" value="${topDir}/src" />
	<property name="binDir" value="${topDir}/bin" />
	<property name="cpj2ee" value="/opt/eclipse/jars/j2ee.jar" />
	<!--<property name="cpxerces" 
		value="/opt/eclipse/jars/xercesImpl.jar:/opt/eclipse/jars/xmlParserAPIs.jar" />
	-->
	<property name="cpxerces" value="/opt/eclipse/jars/oldXerces.jar" />

	<target name="run">
		<antcall target="populateBuild" />
		<antcall target="zip" />
	</target>

	<target name="populateBuild" depends="cleanBuild">
	<javac description="compile source code to classes directory"
			srcdir="${srcDir}" 
			destdir="${buildDir}/WEB-INF/classes"
			excludes="**/Test*"
			classpath="com.pocolap.**:${cpj2ee}:${cpxerces}"
		/>
		<copy todir="${buildDir}" description="copy jsp pages">
			<fileset 
				dir="${srcDir}/jsps" 
				includes="*.jsp,Error.html" 
				excludes="jspRedirector.jsp" />
		</copy>
		<copy todir="${buildDir}/WEB-INF/tlds" description="copy tld">
			<fileset 
				dir="${srcDir}/tlds"
				includes="*"
			/>
		</copy>
		<copy todir="${buildDir}/WEB-INF" description="copy descriptor (web.xml)">
			<fileset 
				dir="."
				includes="web.xml"
			/>
		</copy>
		<copy todir="${buildDir}/META-INF" description="copy manifest">
			<fileset 
				dir="."
				includes="MANIFEST.MF"
			/>
		</copy>
		<copy todir="${buildDir}/scripts" description="copy js and css files">
			<fileset
				dir="${srcDir}/scripts"
				includes="*"
			/>
		</copy>
		<copy todir="${buildDir}/config" description="copy config file">
			<fileset
				dir="."
				includes="config.xml"
			/>
		</copy>
	</target>

	<target name="zip" description="Bundle build into a zip file">
		<zip destfile="${zipFile}" basedir="${buildDir}" />
	</target>

	<target name="cleanBuild">
		<delete dir="${buildDir}" />
		<mkdir dir="${buildDir}" />
		<mkdir dir="${buildDir}/META-INF" />
		<mkdir dir="${buildDir}/WEB-INF" />
		<mkdir dir="${buildDir}/WEB-INF/classes" />
		<mkdir dir="${buildDir}/WEB-INF/tlds" />
		<mkdir dir="${buildDir}/scripts" />
		<mkdir dir="${buildDir}/config" />
	</target>

	<target name="cleanAll">
		<delete dir="${buildDir}" />
	</target>
</project>
--- NEW FILE: config.xml ---
<reptconfig>
	<rept name="Sales SpreadSheet">
		<source classtype="com.pocolap.conn.StandardJDBC" driver="org.gjt.mm.mysql.Driver" user="nssUser" pass="nssPass">jdbc:mysql://localhost:3306/nss</source>
		<measure name="Sold Items" table="SALES" key="AMOUNT" function="sum" />
 		<dimension name="Customers" table="CUSTOMERS" key="CUSTOMERID" measureKey="CUSTOMERID">
 			<group name="Customer" defaultField="Customer Last Name">
				<field name="Customer Last Name" key="LASTNAME" />
 				<!-- other fields are to be used when formatting is implemented -->
				<field name="Customer Number" key="CUSTOMERNUMBER" />
 				<drilldown>Shoe Size</drilldown>
			</group>
			<group name="Customer Origin" defaultField="Zip Code">
				<field name="Zip Code" key="ZIP" />
 				<field name="City" key="CITY" />
 				<drilldown>Customer</drilldown>
			</group>
			<group name="Shoe Size">
				<field name="Shoe Size" key="SHOESIZE" />
 				<field name="Size Type" key="SIZINGGENDER" />
 				<field name="Extra Width" key="WIDESIZES" />
 			</group>
		</dimension>
		<dimension name="Items to Sell" table="SALABLEITEMS" key="SALABLEITEMSID" measureKey="SALABLEITEMSID">
 			<group name="Stock Keeping Unit">
				<field name="SKU Value" key="SKU" />
 				<field name="Product Desription" key="DESCRIPTION" />
 				<field name="Product or Service" key="ISPRODUCT" />
 				<drilldown>Vendor</drilldown>
			</group>
			<group name="Vendor">
				<field name="Vendor Name" key="VENDOR" />
 				<field name="Vendor Number" key="VENDORNUMBER" />	
 				<drilldown>Stock Keeping Unit</drilldown>
			</group>
		</dimension>
		<dimension name="Dates" table="CALENDAR" key="CALENDARID" measureKey="CALENDARID">
 			<group name="Sale Date">
				<field name="Date" key="DAYDATE" />
 			</group>
			<group name="Month" defaultField="Month">
				<field name="Number of Month" key="MONTHOFYEAR" />	
 				<field name="Month" key="MONTHNAME" />
 				<field name="Abbreviated Month" key="MONTHABBREV" />
 				<drilldown>Sale Date</drilldown>
			</group>
			<group name="Year">
				<field name="Year" key="YEAR" />
 				<drilldown>Month</drilldown>
				<drilldown>Sale Date</drilldown>
		</dimension>
	</rept>
</reptconfig>
--- NEW FILE: testPage.jsp ---
<%@page language="java" import="java.sql.*"%>

<%!
Driver driver = null;
String dbURL = null;
Connection conn = null;
Statement stat = null;
ResultSet rs = null;
Object rsValue = null;
int counter;
String query = "select * from \"CUSTOMERS\";";
%>

<%
try {
driver = (Driver) Class.forName("org.hsqldb.jdbcDriver").newInstance();
dbURL = "jdbc:hsqldb:" + application.getRealPath("/~pocolap/nss/nss");
conn = DriverManager.getConnection(dbURL,"nssUser", "nssPass");
stat = conn.createStatement();

rs = stat.executeQuery(query);
} catch (Exception e) {
out.print("Unable do make connection to customers");
out.print(e);
}
%>

<html>
<head>
<title>Test Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<h3>Test Page<br>
</h3>
<table border="1"><tr><td>ID</td><td>NAME</td></tr>
<% 
if (rs!=null){
	if (rs.next()){
	StringBuffer buffer = new StringBuffer("<tr><td>");
		Object id = rs.getObject(1);
		Object name = rs.getObject(2);
		if (id==null){
			//id = "null";
			buffer.append("null");
		}else{
			buffer.append(id.toString()+" ");
		}
		buffer.append("</td><td>");
		if (name==null){
			buffer.append("null");
		}else{
			buffer.append(name.toString()+" ");
		}
		buffer.append("</td></tr>");
		out.println(buffer.toString());
	}else{
		out.println("No rows for " + application.getRealPath("/~pocolap/nss/nss"));
	}
}else{
	out.println("it's null");
}
try{
	rs.close();
	stat.close();
	conn.close();
}catch(Exception e){
	//ignore
}
%>
</table>
Done
</body </html>

--- NEW FILE: CaseConverter.pl ---
#! /usr/bin/perl

##########################
#
# This script creates config.xml by 
# copying sampleconfig.xml and
# converting all "table" and "key" 
# entries to uppercase since HSQLDB 
# converts everything whether you 
# want it to or not.
#
###########################

$origfile = "sampleconfig.xml";
$config = "config.xml";
open (ORIG, "<", $origfile) || die "Couldn't open original file";
open (CONFIG, ">", $config) || die "Couldn't open config file";
while (defined ($str=<ORIG>)){
	if ($str =~ /table=\"/ || $str =~ /key=\"/){
		@tokens = split(/ /,$str);
		foreach my $token (@tokens){
			if ($token =~ /table=\"/ || $token =~ /key=\"/ || $token =~ /measureKey=\"/ ){
				$token =~ s/\"(\w+)\"/\"\U$1\"/g;	
			}	
			print CONFIG "$token ";
		}
	}else{
		print CONFIG $str;
	}
}
close(ORIG);
close(CONFIG);
print 'Done';

--- NEW FILE: setupNSS.sql ---
create database if not exists nss;

use nss;

drop table if exists `customers`;
drop table if exists `salableitems`;
drop table if exists `calendar`;
drop table if exists `sales`;

create table `customers`(
`customerid` int unsigned auto_increment primary key ,
`customerNumber` int,
`firstName` varchar(50) null,
`lastName` varchar(50) default ' ' not null ,
`address` varchar(100) null,
`city` varchar(60) null,
`stateName` varchar(50) null,
`stateAbbrev` char(2) null,
`zip` varchar (15) null,
`phone` varchar(25) null,
`birthdate` date null,
`sizingGender` varchar(20) default 'mens' not null ,
`shoesize` float null,
`wideSizes` bit default '0' not null );

create table `salableitems`(
`salableitemsid` int unsigned auto_increment primary key ,
`sku` int default '0' not null,
`description` varchar(50) default ' ' not null,
`isProduct` bit default '0' not null,
`isSizeDependant` bit default '0' not null,
`color` varchar(30) default 'none' not null,
`vendor` varchar(80) default ' ' not null,
`vendorNumber` int default '0' not null);

create table `calendar`(
`calendarid` int unsigned auto_increment primary key,
`dayDate` date default '1950-01-01' not null,
`dayName` varchar(12) default ' ' not null,
`dayAbbrev` char(3) default '   ' not null,
`dayOfWeek` int default '0' not null,
`dayOfMonth` int default '0' not null,
`monthName` varchar(12) default ' ' not null,
`monthAbbrev` char(3) default '   ' not null,
`monthOfYear` int default '0' not null,
`year` int default '0' not null,
`isHoliday` bit default '0' not null,
`wasOpened` bit default '0' not null);

create table `sales`(
`customerid` int default '0' not null,
`salableitemsid` int default '0' not null,
`calendarid` int default '0' not null,
`amount` float default '0' not null,
`webSale` bit default '0' not null);

GRANT select,insert,delete,update on nss.* to nssUser@localhost identified by 'nssPass';

insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`,
  `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) 
  values (17, 'Tom', 'Ling', '112 SomeStreet', 'Portland', 'Oregon', 'OR', '97201', 
  '503-555-1233', '1962-02-25','mens','7.5', '0');
insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`,
  `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) 
  values (19, 'Sammy', 'Hamm', '4102 W. First', 'Portland', 'Oregon', 'OR', '97210', 
  '503-555-4754', '1964-10-04','mens','9.0', '1');
insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`,
  `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) 
  values (24, 'Sarah', 'Weston', '421 Sideline St. Apt #4', 'Lake Oswego', 'Oregon', 'OR', '97035', 
  '503-555-8874', '1974-03-21','mens','8.0', '0');
insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`,
  `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) 
  values (25, 'Lisa', 'Weston', '421 Sideline St. Apt #4', 'Lake Oswego', 'Oregon', 'OR', '97035', 
  '503-555-8874', '1991-10-07','girls','2.0', '0');
insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`,
  `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) 
  values (26, 'Bill', 'Franklin', '801 Lake Ave.', 'Portland', 'Oregon', 'OR', '97202', 
  '503-555-4120', '1965-09-21','mens','10.0', '0');
insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`,
  `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) 
  values (28, 'Wilma', 'Barkley', '7021 SW 66th', 'Tigard', 'Oregon', 'OR', '97224', 
  '503-555-4998', '1975-09-21','womens','7.0', '0');
insert into `customers` (`customerNumber`,`firstName`,`lastName`,`address`,`city`,
  `stateName`,`stateAbbrev`,`zip`,`phone`,`birthdate`,`sizingGender`,`shoesize`, `wideSizes`) 
  values (29, 'Walter', 'McClellan', '10425 Walling Cir', 'West Linn', 'Oregon', 'OR', '97068', 
  '503-555-8856', '1938-02-29', 'mens','8.5', '1');

insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('234001', '36" laces', '1', '0', 'Brown', 
  'Laces USA', '78778');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('234002', '36" laces', '1', '0', 'Black', 
  'Laces USA', '78778');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('234003', '36" laces', '1', '0', 'Beige', 
  'Laces USA', '78778');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('234004', '36" laces', '1', '0', 'White', 
  'Laces USA', '78778');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('234011', '54" laces', '1', '0', 'Brown', 
  'Laces USA', '78778');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('234012', '54" laces', '1', '0', 'Black', 
  'Laces USA', '78778');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('234013', '54" laces', '1', '0', 'Beige', 
  'Laces USA', '78778');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('234014', '54" laces', '1', '0', 'White', 
  'Laces USA', '78778');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('170211', 'odor insoles', '1', '1', 'none', 
  'feeterEater', '117');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('170211', 'cushioned insoles', '1', '1', 'none', 
  'feeterEater', '117');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('170211', 'cushioned odor insoles', '1', '1', 'none', 
  'feeterEater', '117');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('42187', 'Polish', '1', '0', 'Black', 'Shine Right', '4242');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('42188', 'Polish', '1', '0', 'Brown', 'Shine Right', '4242');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('42189', 'Polish', '1', '0', 'Tan', 'Shine Right', '4242');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('42190', 'Polish', '1', '0', 'Beige', 'Shine Right', '4242');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('42191', 'Polish', '1', '0', 'Red', 'Shine Right', '4242');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('42192', 'Polish', '1', '0', 'Blue', 'Shine Right', '4242');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('100', 'Restitch', '0', '0', 'none', 'Self', '1');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('101', 'Glue', '0', '0', 'none', 'Self', '1');
insert into `salableitems` (`sku`,`description`,`isProduct`,`isSizeDependant`,
  `color`,`vendor`,`vendorNumber`) values ('102', 'Shine', '0', '0', 'none', 'Self', '1');

insert into `calendar` (`dayDate`) values ('2002-12-29');
insert into `calendar` (`dayDate`) values ('2003-01-05');
insert into `calendar` (`dayDate`) values ('2003-01-12');
insert into `calendar` (`dayDate`) values ('2003-01-19');
insert into `calendar` (`dayDate`) values ('2003-01-26');
insert into `calendar` (`dayDate`) values ('2003-02-02');
insert into `calendar` (`dayDate`) values ('2003-02-09');
insert into `calendar` (`dayDate`) values ('2003-02-16');
insert into `calendar` (`dayDate`) values ('2003-02-23');
insert into `calendar` (`dayDate`) values ('2003-03-02');
insert into `calendar` (`dayDate`) values ('2003-03-09');
insert into `calendar` (`dayDate`) values ('2003-03-16');
insert into `calendar` (`dayDate`) values ('2003-03-23');
insert into `calendar` (`dayDate`) values ('2003-03-30');
insert into `calendar` (`dayDate`) values ('2003-04-06');
insert into `calendar` (`dayDate`) values ('2003-04-13');
insert into `calendar` (`dayDate`) values ('2003-04-20');
insert into `calendar` (`dayDate`) values ('2003-04-27');
insert into `calendar` (`dayDate`) values ('2003-05-04');
insert into `calendar` (`dayDate`) values ('2003-05-11');
insert into `calendar` (`dayDate`) values ('2003-05-18');
insert into `calendar` (`dayDate`) values ('2003-05-25');
insert into `calendar` (`dayDate`) values ('2003-06-01'); 

update `calendar` set `dayName` = DATE_FORMAT(`dayDate`, '%W');

insert into `calendar` (`dayDate`) 
  select DATE_ADD(`dayDate`, INTERVAL 1 DAY) from `calendar`;
insert into `calendar` (`dayDate`) 
  select DATE_ADD(`dayDate`, INTERVAL 2 DAY) from `calendar` where `dayName` = 'Sunday';
insert into `calendar` (`dayDate`) 
  select DATE_ADD(`dayDate`, INTERVAL 3 DAY) from `calendar` where `dayName` = 'Sunday';
insert into `calendar` (`dayDate`) 
  select DATE_ADD(`dayDate`, INTERVAL 4 DAY) from `calendar` where `dayName` = 'Sunday';
insert into `calendar` (`dayDate`) 
  select DATE_ADD(`dayDate`, INTERVAL 5 DAY) from `calendar` where `dayName` = 'Sunday';
insert into `calendar` (`dayDate`) 
  select DATE_ADD(`dayDate`, INTERVAL 6 DAY) from `calendar` where `dayName` = 'Sunday';

update `calendar` set `dayName` = DATE_FORMAT(`dayDate`, '%W'),
  `dayAbbrev` = DATE_FORMAT(`dayDate`, '%a'),
  `dayOfWeek` = DATE_FORMAT(`dayDate`, '%w'),
  `dayOfMonth` = DATE_FORMAT(`dayDate`, '%e'), 
  `monthName` = DATE_FORMAT(`dayDate`, '%M'),
  `monthAbbrev` = DATE_FORMAT(`dayDate`, '%b'),
  `monthOfYear` = DATE_FORMAT(`dayDate`,'%c'),
  `year` = DATE_FORMAT(`dayDate`, '%Y');

update `calendar` set `wasOpened`='1';
update `calendar` set `wasOpened`='0' 
  where `dayName` = 'Sunday' or `dayName`='Monday';

update `calendar` set `isHoliday`='1' 
  where `dayDate` = '2002-12-31' or
  `dayDate` = '2003-01-01' or
  `dayDate` = '2003-02-17' or
  `dayDate` = '2003-05-05' or
  `dayDate` = '2003-05-26';

insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('1', '3', '35', '2.25', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('1', '2', '35', '2.25', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('1', '2', '35', '2.25', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('4', '7', '27', '2.50', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('4', '7', '32', '2.50', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('3', '5', '47', '2.50', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('3', '6', '47', '2.50', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('3', '7', '47', '2.50', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('3', '6', '116', '2.50', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('3', '10', '116', '15.00', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('7', '11', '75', '17.50', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('7', '20', '75', '10.00', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('2', '15', '105', '7.25', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('2', '10', '105', '15.00', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('2', '13', '105', '7.25', '0');
insert into `sales` (`customerid`,`salableitemsid`,`calendarid`,`amount`,`webSale`)
  values ('2', '18', '105', '8.00', '0');
--- NEW FILE: web.xml ---
<?xml version="1.0"?>
<!DOCTYPE web-app PUBLIC
   "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
   "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>

	<servlet>
		<servlet-name>XTabMain</servlet-name>
		<servlet-class>com.pocolap.servlets.XTabMain</servlet-class>

		<init-param>
			<param-name>whs_b</param-name>
			<param-value>./config/config.xml</param-value>
		</init-param>
	</servlet>

	<servlet-mapping>
		<servlet-name>XTabMain</servlet-name>
		<url-pattern>/servlets/XTabMain</url-pattern>	
	</servlet-mapping>

	<taglib>
		<taglib-uri>ReptTags</taglib-uri>
		<taglib-location>/WEB-INF/tlds/ReptTags.tld</taglib-location>
	</taglib>

</web-app>

--- NEW FILE: sampleconfig.xml ---
<reptconfig>
	<rept name="Sales SpreadSheet">
		<source classtype="com.pocolap.conn.StandardJDBC" driver="org.gjt.mm.mysql.Driver" user="nssUser" pass="nssPass">jdbc:mysql://localhost:3306/nss</source>
		<measure name="Sold Items" table="sales" key="amount" function="sum" />
		<dimension name="Customers" table="customers" key="customerid" measureKey="customerid">
			<group name="Customer" defaultField="Customer Last Name">
				<field name="Customer Last Name" key="lastName" />
				<!-- other fields are to be used when formatting is implemented -->
				<field name="Customer Number" key="customerNumber" />
				<drilldown>Shoe Size</drilldown>
			</group>
			<group name="Customer Origin" defaultField="Zip Code">
				<field name="Zip Code" key="zip" />
				<field name="City" key="city" />
				<drilldown>Customer</drilldown>
			</group>
			<group name="Shoe Size">
				<field name="Shoe Size" key="shoesize" />
				<field name="Size Type" key="sizingGender" />
				<field name="Extra Width" key="wideSizes" />
			</group>
		</dimension>
		<dimension name="Items to Sell" table="salableitems" key="salableitemsid" measureKey="salableitemsid">
			<group name="Stock Keeping Unit">
				<field name="SKU Value" key="sku" />
				<field name="Product Desription" key="description" />
				<field name="Product or Service" key="isProduct" />
				<drilldown>Vendor</drilldown>
			</group>
			<group name="Vendor">
				<field name="Vendor Name" key="vendor" />
				<field name="Vendor Number" key="vendorNumber" />	
				<drilldown>Stock Keeping Unit</drilldown>
			</group>
		</dimension>
		<dimension name="Dates" table="calendar" key="calendarid" measureKey="calendarid">
			<group name="Sale Date">
				<field name="Date" key="dayDate" />
			</group>
			<group name="Month" defaultField="Month">
				<field name="Number of Month" key="monthOfYear" />	
				<field name="Month" key="monthName" />
				<field name="Abbreviated Month" key="monthAbbrev" />
				<drilldown>Sale Date</drilldown>
			</group>
			<group name="Year">
				<field name="Year" key="year" />
				<drilldown>Month</drilldown>
				<drilldown>Sale Date</drilldown>
		</dimension>
	</rept>
</reptconfig>

[Pocolap-cvscommit] pocolap/data/scripts_tools/outdated MANIFEST.MF,NONE,1.1 sampleconfig.xml,NONE,1

[Pocolap-cvscommit] pocolap/data/scripts_tools/outdated MANIFEST.MF,NONE,1.1 sampleconfig.xml,NONE,1.1 testPage.jsp,NONE,1.1 config.xml,NONE,1.1 build.xml,NONE,1.1 setupNSS.sql,NONE,1.1 web.xml,NONE,1.1 CaseConverter.pl,NONE,1.1