SmartDukaan – //trunk/pentaho/

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 7890 – Adding source to Pentaho

anupam.singh — Thu, 01 Aug 2013 15:29:02 +0530

anupam.singh – 2 file(s) modified
Adding source to Pentaho

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 7205 – Changed type of otg to integer during transformation

anupam.singh — Mon, 29 Apr 2013 17:30:02 +0530

anupam.singh – 1 file(s) modified
Changed type of otg to integer during transformation

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr

Rev 7203 – Added NLC, OTG, Insurer in pentaho

anupam.singh — Mon, 29 Apr 2013 17:01:08 +0530

anupam.singh – 4 file(s) modified
Added NLC, OTG, Insurer in pentaho

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr
~ /trunk/pentaho/data-integration/transformations/RepeatSaleAnalysis.ktr
~ /trunk/pentaho/schema/CommonOrdersSchema.xml
~ /trunk/pentaho/schema/SalesSchema.xml

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 6572 – Pointing item loader to hadb2

anupam.singh — Tue, 01 Jan 2013 15:47:25 +0530

anupam.singh – 1 file(s) modified
Pointing item loader to hadb2

~ /trunk/pentaho/data-integration/transformations/itemLoader.ktr

Rev 6560 – Including timestamp also

anupam.singh — Mon, 31 Dec 2012 14:11:33 +0530

anupam.singh – 2 file(s) modified
Including timestamp also

~ /trunk/pentaho/data-integration/transformations/MarkRepeatOrders.ktr
~ /trunk/pentaho/data-integration/transformations/RepeatSaleAnalysis.ktr

Rev 6557 – Forcing spoon to use db2 for loading commonorders

anupam.singh — Mon, 31 Dec 2012 11:48:05 +0530

anupam.singh – 1 file(s) modified
Forcing spoon to use db2 for loading commonorders

~ /trunk/pentaho/data-integration/transformations/RepeatSaleAnalysis.ktr

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 6547 – ETL now successful for commonorders

anupam.singh — Thu, 27 Dec 2012 18:14:54 +0530

anupam.singh – 2 file(s) modified
ETL now successful for commonorders

~ /trunk/pentaho/data-integration/transformations/MarkRepeatOrders.ktr
~ /trunk/pentaho/data-integration/transformations/RepeatSaleAnalysis.ktr

Rev 6541 – Job and corresponding transformations which load common orders.

anupam.singh — Wed, 26 Dec 2012 18:58:57 +0530

anupam.singh – 3 file(s) modified
Job and corresponding transformations which load common orders.

+ /trunk/pentaho/data-integration/transformations/CommonOrdersJob.kjb
+ /trunk/pentaho/data-integration/transformations/MarkRepeatOrders.ktr
+ /trunk/pentaho/data-integration/transformations/RepeatSaleAnalysis.ktr

Rev 6479 –

anupam.singh — Tue, 11 Dec 2012 11:55:02 +0530

anupam.singh – 1 file(s) modified

~ /trunk/pentaho/data-integration/transformations/orderFulfilmentLoader.ktr

Rev 6474 – Improved ETL for orderLoader so that it takes less time.

anupam.singh — Mon, 10 Dec 2012 16:40:49 +0530

anupam.singh – 1 file(s) modified
Improved ETL for orderLoader so that it takes less time.

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr

Rev 6306 – Removing orders in same transaction from repeat sale cube

anupam.singh — Tue, 06 Nov 2012 16:12:18 +0530

anupam.singh – 1 file(s) modified
Removing orders in same transaction from repeat sale cube

~ /trunk/pentaho/data-integration/transformations/repeatLoader.ktr

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 5905 – Added two dimensions Days to Second Order and averageValue.

anupam.singh — Tue, 28 Aug 2012 18:45:07 +0530

anupam.singh – 2 file(s) modified
Added two dimensions Days to Second Order and averageValue.

~ /trunk/pentaho/data-integration/transformations/repeatLoader.ktr
~ /trunk/pentaho/schema/RepeatSalesSchema.xml

Rev 5899 – Changing username for prod DB

anupam.singh — Mon, 27 Aug 2012 19:56:55 +0530

anupam.singh – 1 file(s) modified
Changing username for prod DB

~ /trunk/pentaho/data-integration/transformations/repeatLoader.ktr

Rev 5898 – Changing password for prod connection

anupam.singh — Mon, 27 Aug 2012 19:52:38 +0530

anupam.singh – 1 file(s) modified
Changing password for prod connection

~ /trunk/pentaho/data-integration/transformations/repeatLoader.ktr

Rev 5897 – Using hadb2 instead of hadb

anupam.singh — Mon, 27 Aug 2012 19:44:09 +0530

anupam.singh – 1 file(s) modified
Using hadb2 instead of hadb

~ /trunk/pentaho/data-integration/transformations/repeatLoader.ktr

Rev 5896 – ETL and Cube schema for repeat sale analysis cube.

anupam.singh — Mon, 27 Aug 2012 19:39:25 +0530

anupam.singh – 3 file(s) modified
ETL and Cube schema for repeat sale analysis cube.

+ /trunk/pentaho/data-integration/transformations/repeatLoader.ktr
+ /trunk/pentaho/schema/RepeatSalesSchema.xml
~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5857 – Extracting HotspotId instead of Id from pickupStore table.

anupam.singh — Wed, 22 Aug 2012 00:54:01 +0530

anupam.singh – 1 file(s) modified
Extracting HotspotId instead of Id from pickupStore table.

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr

Rev 5799 – Trac#1550 Added pickupType dimension in salesCube

anupam.singh — Wed, 15 Aug 2012 23:38:05 +0530

anupam.singh – 1 file(s) modified
Trac#1550

Added pickupType dimension in salesCube

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5798 – Updating ETR script to include pickupStoreId while loading sales cube.

anupam.singh — Wed, 15 Aug 2012 23:34:06 +0530

anupam.singh – 1 file(s) modified
Updating ETR script to include pickupStoreId while loading sales cube.

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr

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 5710 – Adding key expression to sales cube for productName heirarchy

anupam.singh — Wed, 01 Aug 2012 15:00:24 +0530

anupam.singh – 1 file(s) modified
Adding key expression to sales cube for productName heirarchy

~ /trunk/pentaho/schema/SalesSchema.xml

Rev 5709 – Including newsletter in the productactivity cube

anupam.singh — Wed, 01 Aug 2012 14:58:03 +0530

anupam.singh – 1 file(s) modified
Including newsletter in the productactivity cube

~ /trunk/pentaho/schema/ProductActivitySchema.xml

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 5539 – Trac # 1413 Breaking 0-2000 price range in further smaller ...

anupam.singh — Tue, 03 Jul 2012 15:02:57 +0530

anupam.singh – 1 file(s) modified
Trac # 1413
Breaking 0-2000 price range in further smaller groups of 0-250, 250-500, 500-1000, 1000-2000

~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr