SmartDukaan – //trunk/pentaho/scripts/

Rev 9341 – Getting data for 2 months instead of one

anupam.singh — Thu, 09 Jan 2014 17:55:15 +0530

anupam.singh – 1 file(s) modified
Getting data for 2 months instead of one

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 9340 – Correcting logic for previous month

anupam.singh — Thu, 09 Jan 2014 17:32:45 +0530

anupam.singh – 1 file(s) modified
Correcting logic for previous month

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 8207 – Added source wise info for last day accessories sales.

rajveer — Wed, 25 Sep 2013 16:40:52 +0530

rajveer – 1 file(s) modified
Added source wise info for last day accessories sales.

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py

Rev 8075 – Added summary to email and source to sheet

rajveer — Wed, 04 Sep 2013 17:46:14 +0530

rajveer – 1 file(s) modified
Added summary to email and source to sheet

~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 6714 – Added khushal and chandan to product report

anupam.singh — Mon, 21 Jan 2013 11:49:52 +0530

anupam.singh – 1 file(s) modified
Added khushal and chandan to product report

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 6713 – Added chandan to last day orders reports

anupam.singh — Fri, 18 Jan 2013 23:59:46 +0530

anupam.singh – 2 file(s) modified
Added chandan to last day orders reports

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 6652 – Added Chaitnaya to Last day order reports.

anupam.singh — Fri, 11 Jan 2013 17:06:12 +0530

anupam.singh – 2 file(s) modified
Added Chaitnaya to Last day order reports.

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 6554 – Changes in itemLoader script, added commonorders schema

anupam.singh — Fri, 28 Dec 2012 20:59:41 +0530

anupam.singh – 4 file(s) modified
Changes in itemLoader script, added commonorders schema

~ /trunk/pentaho/data-integration/transformations/itemLoader.ktr
~ /trunk/pentaho/data-integration/transformations/RepeatSaleAnalysis.ktr
+ /trunk/pentaho/schema/CommonOrdersSchema.xml
+ /trunk/pentaho/scripts/temp.py

Rev 6080 – Removing Pankaj Jain, Pankaj Kankar and Ashutosh from report mails.

anupam.singh — Thu, 04 Oct 2012 12:56:16 +0530

anupam.singh – 2 file(s) modified
Removing Pankaj Jain, Pankaj Kankar and Ashutosh from report mails.

~ /trunk/HotspotDashboard/src/main/resources/in/shop2020/hotspot/dashbaord/server/InventoryReportProcessor.properties
~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 5969 – Including those orders as well which are in verification pending ...

anupam.singh — Tue, 11 Sep 2012 14:10:56 +0530

anupam.singh – 2 file(s) modified
Including those orders as well which are in verification pending state.

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 5728 – Adding correct recepients

anupam.singh — Sat, 04 Aug 2012 11:25:03 +0530

anupam.singh – 2 file(s) modified
Adding correct recepients

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 5727 – Fixed SQL statement

anupam.singh — Sat, 04 Aug 2012 11:17:45 +0530

anupam.singh – 2 file(s) modified
Fixed SQL statement

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 5726 – including only uncancelled orders

anupam.singh — Sat, 04 Aug 2012 11:05:24 +0530

anupam.singh – 2 file(s) modified
including only uncancelled orders

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 5708 – Script to generate repeat sale report.

anupam.singh — Wed, 01 Aug 2012 14:56:36 +0530

anupam.singh – 1 file(s) modified
Script to generate repeat sale report.

+ /trunk/pentaho/scripts/repeatSaleReporter.py

Rev 5670 – Adding proper recipients

anupam.singh — Wed, 25 Jul 2012 03:14:14 +0530

anupam.singh – 2 file(s) modified
Adding proper recipients

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 5666 – Made following updates Add a column for Value also ...

anupam.singh — Tue, 24 Jul 2012 17:08:14 +0530

anupam.singh – 2 file(s) modified
Made following updates

Add a column for Value also to the right of quantity
Add a Grand Total row at the top.
Remove sub-category.
And Sort by first Category and then Brand.

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 5653 – Removed email addresses meant for testing

anupam.singh — Sat, 21 Jul 2012 03:21:54 +0530

anupam.singh – 2 file(s) modified
Removed email addresses meant for testing

~ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
~ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 5652 – Reports for previous day sales for accessories and other categories

anupam.singh — Sat, 21 Jul 2012 03:11:17 +0530

anupam.singh – 2 file(s) modified
Reports for previous day sales for accessories and other categories

+ /trunk/pentaho/scripts/LastDayAccessoriesSales.py
+ /trunk/pentaho/scripts/PreviousDayOrdersMailer.py

Rev 5301 – Including sitakanta@mysmartprice.com in the report

anupam.singh — Tue, 29 May 2012 11:03:21 +0530

anupam.singh – 1 file(s) modified
Including sitakanta@mysmartprice.com in the report

~ /trunk/pentaho/scripts/AffiliatePerformanceReport.py

Rev 5265 – Added recipients in one line

anupam.singh — Thu, 24 May 2012 16:10:59 +0530

anupam.singh – 1 file(s) modified
Added recipients in one line

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 5226 – Adding asghar

anupam.singh — Mon, 21 May 2012 19:49:28 +0530

anupam.singh – 1 file(s) modified
Adding asghar

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 5195 – Using 18th column instead of 14th.

anupam.singh — Wed, 16 May 2012 17:57:12 +0530

anupam.singh – 1 file(s) modified
Using 18th column instead of 14th.

~ /trunk/pentaho/scripts/start-pentaho

Rev 5092 – Adding Abhishek

anupam.singh — Wed, 02 May 2012 11:24:23 +0530

anupam.singh – 1 file(s) modified
Adding Abhishek

~ /trunk/pentaho/scripts/AffiliatePerformanceReport.py

Rev 5091 – Using yesterday's date

anupam.singh — Wed, 02 May 2012 11:20:49 +0530

anupam.singh – 1 file(s) modified
Using yesterday's date

~ /trunk/pentaho/scripts/AffiliatePerformanceReport.py

Rev 5087 – This script generates an excel sheet which shows number of ...

anupam.singh — Tue, 01 May 2012 15:52:32 +0530

anupam.singh – 1 file(s) modified
This script generates an excel sheet which shows number of views and number of Add to carts that happened for last day for all traffic coming from MySmartPrice.in
Reviewer : Varun Gupta
Trac # 1189

+ /trunk/pentaho/scripts/AffiliatePerformanceReport.py

Rev 5081 – Adding try catch

anupam.singh — Mon, 30 Apr 2012 20:54:27 +0530

anupam.singh – 1 file(s) modified
Adding try catch

~ /trunk/pentaho/scripts/ProductActivityLoader.py

Rev 5054 – Adding filter for year as well. Reviewer : Amar Kumar

anupam.singh — Tue, 24 Apr 2012 12:22:48 +0530

anupam.singh – 1 file(s) modified
Adding filter for year as well.
Reviewer : Amar Kumar

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 5029 – Including Ashutosh in mailing list

anupam.singh — Thu, 19 Apr 2012 14:15:25 +0530

anupam.singh – 1 file(s) modified
Including Ashutosh in mailing list

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 5018 – Script to periodically monitor pentaho and bring it up if ...

anupam.singh — Wed, 18 Apr 2012 13:57:35 +0530

anupam.singh – 1 file(s) modified
Script to periodically monitor pentaho and bring it up if its down.
Reviewer : Amar
Trac#1151

+ /trunk/pentaho/scripts/start-pentaho

Rev 4943 – panscript changes to include aggregate table ETLs

anupam.singh — Wed, 11 Apr 2012 10:52:04 +0530

anupam.singh – 1 file(s) modified
panscript changes to include aggregate table ETLs

~ /trunk/pentaho/scripts/panScript.sh

Rev 4809 – Changing script to reflect changes in orderstatus table in pentaho.

anupam.singh — Mon, 26 Mar 2012 20:53:58 +0530

anupam.singh – 1 file(s) modified
Changing script to reflect changes in orderstatus table in pentaho.

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 4800 – Send mail from cnc.center instead of help

rajveer — Mon, 26 Mar 2012 13:05:18 +0530

rajveer – 1 file(s) modified
Send mail from cnc.center instead of help

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 4074 – Update sql query to filter out refunded items.

vikas — Wed, 16 Nov 2011 13:16:52 +0530

vikas – 1 file(s) modified
Update sql query to filter out refunded items.

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 4070 – Update sql query to filter only valid orders.

vikas — Wed, 16 Nov 2011 12:42:19 +0530

vikas – 1 file(s) modified
Update sql query to filter only valid orders.

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 4068 – Update sql query to get data from current and previous ...

vikas — Wed, 16 Nov 2011 12:25:06 +0530

vikas – 1 file(s) modified
Update sql query to get data from current and previous months.

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 4067 – Update subject and attachment filename to contain date

vikas — Wed, 16 Nov 2011 12:18:24 +0530

vikas – 1 file(s) modified
Update subject and attachment filename to contain date

~ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 4066 – Daily product sale Report mailer.

vikas — Wed, 16 Nov 2011 12:01:42 +0530

vikas – 1 file(s) modified
Daily product sale Report mailer.

+ /trunk/pentaho/scripts/ReportMailerFromDb.py

Rev 3837 – Normalize is_paid and source url columns.

vikas — Fri, 21 Oct 2011 12:18:28 +0530

vikas – 1 file(s) modified
Normalize is_paid and source url columns.

~ /trunk/pentaho/scripts/ProductActivityLoader.py

Rev 3748 – Add crmloader to cron.

vikas — Wed, 19 Oct 2011 11:33:37 +0530

vikas – 1 file(s) modified
Add crmloader to cron.

~ /trunk/pentaho/scripts/panScript.sh

Rev 3545 – Add cart, user and order fulfilment transformations.

vikas — Fri, 07 Oct 2011 13:24:57 +0530

vikas – 1 file(s) modified
Add cart, user and order fulfilment transformations.

~ /trunk/pentaho/scripts/panScript.sh