Project

General

Profile

Wiki » History » Revision 2

Revision 1 (Soh Keong, 09/18/2004 07:18 AM) → Revision 2/4 (Soh Keong, 09/18/2004 07:38 AM)

{{TOC}} 

 h1. Wiki 

 h2. Overview 

 !batch.png! 

 h2. File Download 

 "Jar file":http://192.168.2.13:50000/redmine/attachments/download/458/Stockist_batch.jar 
 "Properties file":http://192.168.2.13:50000/redmine/attachments/download/458/stockist.properties 
 "Batch file":http://192.168.2.13:50000/redmine/attachments/download/458/run.bat 
 "Sample excel file":http://192.168.2.13:50000/redmine/attachments/download/458/Stockist.xls 
 "Sample email template":http://192.168.2.13:50000/redmine/attachments/download/458/EmailNewPassword.xml 

 h2. properties file 

 * *stockist.properties*  

 _DATABASE_ 
 # *database*                     - Which database used. 
 # *database.driver.class*        - Database driver class 
 # *database.ip*                  - Database server IP 
 # *database.port*                - Database server port 
 # *database.name*                - Database name 
 # *database.user*                - Database user name 
 # *database.pwd*                 - Database user password 

 _FILE_ 
 # *file.name*                    - Excel file name 
 # *file.total.sheet*             - Total sheet need to update 

 _EMAIL_ 
 # *email.template*               - xml template 
 # *email.send*                   - email send indicator 


 h2. Execute Program  

 1. Please make sure 
	   I. The value in stockist.properties is correct. 
	  II. The excel format is correct. 
	 III. The email template name is match with the name in stockist.properties 

 2. To run the program, double click on the run.bat 
 3. [SUCCESS] message will be display in case of update successful 
 4. [FAILED]    message will be display in case the record is not updated.