Stockist Announcement » Stockist Batch

{{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

"Properties file":http://192.168.2.13:50000/redmine/attachments/download/462/stockist.properties

"Batch file":http://192.168.2.13:50000/redmine/attachments/download/463/run.bat

"Sample excel file":http://192.168.2.13:50000/redmine/attachments/download/464/Stockist.xls

"Sample email template":http://192.168.2.13:50000/redmine/attachments/download/465/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>