Wiki » History » Revision 3
Revision 2 (Soh Keong, 09/18/2004 07:38 AM) → Revision 3/4 (Soh Keong, 09/18/2004 07:42 AM)
{{TOC}}
h1. Wiki
h2. Overview
!batch.png!
h2. File Download
"Jar file":http://192.168.2.13:50000/redmine/attachments/download/461/Stockist_batch.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/462/stockist.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/463/run.bat 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/464/Stockist.xls 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/465/EmailNewPassword.xml 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.
h2. SCM
_CVS:_
<pre>
Host: cwyrnd2-server [IP address:192.168.2.11]
Path: d:/source/ecoswayNew
Module: Stockist_batch
Tag: HEAD
</pre>