Activity

From 08/17/2011 to 09/15/2011

05:17 PM Feature #118: DP Profit Batch File: • memory usage on writing 100,000 records to excel file - 144212200 bytes (144MB)
• memory usage on writing 500,00... Chee-Hoong

09:35 AM Feature #118: DP Profit Batch File: The load test result and the changes should be ready by this Thursday as we will calculate profit next week. chin-yeh

05:54 PM Feature #118: DP Profit Batch File: load test still in progress
latest code commited to CVS Chee-Hoong
12:04 PM Feature #118: DP Profit Batch File: Just a reminder. The *total amount* in the sheet's footer is referring to total amount (_USD & local currency_) on th... chin-yeh

05:37 PM Feature #118: DP Profit Batch File: is the Runtime under java.lang? if is i try it now Chee-Hoong
05:28 PM Feature #118: DP Profit Batch File: you could use this code snippet to capture the memory usage:... chin-yeh
11:44 AM Feature #118: DP Profit Batch File: In excel, there's a limit on number of rows & columns per sheet.
* *prior office 2007* - 65,536 rows by 256 columns... chin-yeh

06:09 PM Feature #118: DP Profit Batch File: get the latest stable version from the official website chin-yeh
05:46 PM Feature #118: DP Profit Batch File: is the excel API (APACHE POI) already exist in our eclipse or need to download? Chee-Hoong
02:53 PM Feature #118: DP Profit Batch File: Use the "Apache POI":http://poi.apache.org/ to generate the excel file.
Regarding to the load test, I would sugges... chin-yeh
11:22 AM Feature #118: DP Profit Batch File: Changes:
1) Generate the Finance Reference Report into excel(xls) format, with VIP records group by country as tab(s... Chooi-Mey

03:47 PM Feature #118: DP Profit Batch File: finding test data to enable verification Chee-Hoong
03:05 PM Feature #118: DP Profit Batch File: INV_NO field refer to profit month, for example, if you are generating for May 2011 profit, then it will be BONUS2011... Chooi-Mey
02:58 PM Feature #118: DP Profit Batch File: INV_NO field refers to current date time?
Chee-Hoong
02:50 PM Feature #118: DP Profit Batch File: adding Chee-Hoong
02:35 PM Feature #118: DP Profit Batch File: Changes:
1) Add in USD_DP_AMT field at last column (position 531-543), with length 13N (13,2). Pass the DP amount ... Chooi-Mey
12:22 PM Feature #117: DP Client Interface: The programming guide is ready and can be found in [[Programming Guide]]. The implementer should understands the requ... chin-yeh

05:58 PM Feature #119: Sales Return Web Services: Based on the feedback by Benny (25-Aug-2011), the DP system was able to process the sample batch file which contains ... chin-yeh
05:57 PM Feature #120: VIP Upgrade Web Service: Based on the feedback by Benny (25-Aug-2011), the DP system was able to process the sample batch file which contains ... chin-yeh
05:55 PM Feature #117: DP Client Interface: Based on the feedback by Benny (25-Aug-2011), the DP system was able to process all of the sample batch files, which ... chin-yeh

03:44 PM Feature #118: DP Profit Batch File: production generated file sent to ting ting and benny.
bug fixed Chee-Hoong
12:33 PM Feature #118: DP Profit Batch File: As discussed, do provide the profit batch file, which generated in live environment, to Ting-Ting & Benny for final v... chin-yeh

05:51 PM Feature #118: DP Profit Batch File: i just gen the file and send to ting ting? Chee-Hoong
05:35 PM Feature #118: DP Profit Batch File: I've imported the live *VIP_STAT* & *mend_currconv* tables into development STORE db. Can you generate a copy and pas... chin-yeh
10:59 AM Feature #118: DP Profit Batch File: wat is the formula or how to calculate the dp that need to convert 2 decimal? Chee-Hoong
10:03 AM Feature #118: DP Profit Batch File: ok i get it Chee-Hoong
09:49 AM Feature #118: DP Profit Batch File: Use the util to format all monetary value to 2 decimal places *after* calculation chin-yeh
09:32 AM Feature #118: DP Profit Batch File: format dp earned to 2 decimal is after currency conversion? for calculation purpose?
Chee-Hoong

06:17 PM Feature #118: DP Profit Batch File: The file encoding of the profit batch file will be *UTF-8*.
FYI, the file encoding for all of the VP/DP batch fil... chin-yeh
05:46 PM Feature #118: DP Profit Batch File: *Important notes:*
* Refer to the *format2Decimal* method in *my.com.eCosway.util.MyUtil* class in usa-mall reposito... chin-yeh
05:03 PM Feature #118: DP Profit Batch File: Add requirements:
1) Finance Report
- Filename Format: DP_PROFIT_FINANCE_REFERENCE_MMyyyy.csv
- File Encoding: ISO... Chooi-Mey
12:29 PM Feature #118: DP Profit Batch File: For DP Amount in profit file, the value need to be in Local currency of the mapped country.
The retrieval value fro... Chooi-Mey

05:28 PM Feature #120: VIP Upgrade Web Service: Already integrated. The demo app can be found in:
> http://192.168.2.66:8080/dp-test/vip_upgrade.html
> If do not... chin-yeh
11:56 AM Feature #118 (Feedback): DP Profit Batch File: Ok. Verified. Chooi-Mey
11:41 AM Feature #118: DP Profit Batch File: ok i get wat u mean. now the file regenerated Chee-Hoong
11:24 AM Feature #118: DP Profit Batch File: The Currency_to should mapped to HKD as well, besides the residing country. Same to exchange rate.
It means when sy... Chooi-Mey
11:17 AM Feature #118: DP Profit Batch File: the macau and china residing country is mapped to hong kong residing country in program and file generated.
only dat... Chee-Hoong
10:57 AM Feature #118: DP Profit Batch File: Bugs:
1) Those VIP residing in China, Macau and Hong Kong, should mapped into HKD currency (Currency_To), instead of... Chooi-Mey

05:15 PM Feature #118: DP Profit Batch File: yes, please generate again and send to Benny. chin-yeh
04:33 PM Feature #118: DP Profit Batch File: neeed to gen and send sample file again? Chee-Hoong
03:48 PM Feature #118: DP Profit Batch File: Just prepare for the profit batch program first.
Besides that, here are the latest changes needed:
* change the *... chin-yeh

06:13 PM Feature #118: DP Profit Batch File: •how to deploy the batch program
•how to execute the batch program
•how to configure the application properties if ... Chee-Hoong
05:49 PM Feature #118: DP Profit Batch File: Could you prepare the following guide:
* how to deploy the batch program
* how to execute the batch program
* how ... chin-yeh
11:36 AM Feature #118: DP Profit Batch File: ok Chee-Hoong
11:23 AM Feature #118: DP Profit Batch File: *Updates:*
* output filename convention is *DP_PROFITMMyyyy.txt*
** *MMyyyy* - profit month, e.g. 092011 for Septem... chin-yeh

Also available in: Atom

Taiwan Services » DP Client