SmartDukaan – /trunk/pentaho/data-integration/transformations/

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

Rev 5417 – Trac #1374 Reviewer : Mandeep Dhir Cleaned CRMResponse cube.

anupam.singh — Thu, 14 Jun 2012 01:35:33 +0530

anupam.singh – 3 file(s) modified
Trac #1374
Reviewer : Mandeep Dhir

Cleaned CRMResponse cube.

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

Rev 5392 – Pointing to loader scripts to hadb2

anupam.singh — Fri, 08 Jun 2012 18:12:24 +0530

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

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

Rev 5160 – ktr scripts for populating booking date

anupam.singh — Mon, 14 May 2012 03:47:28 +0530

anupam.singh – 1 file(s) modified
ktr scripts for populating booking date

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

Rev 5157 – Trac # 1180, 1266 Added Measures for tracking new logistic ...

anupam.singh — Mon, 14 May 2012 02:28:34 +0530

anupam.singh – 2 file(s) modified
Trac # 1180, 1266
Added Measures for tracking new logistic states. Added statusGroup and statusSubGroup in this cube.

~ /trunk/pentaho/data-integration/transformations/orderFulfilmentLoader.ktr
~ /trunk/pentaho/schema/FulfilmentReport.xml

Rev 5156 – Trac#1055 Introduced price-range column in productActivity cube.

anupam.singh — Mon, 14 May 2012 01:24:00 +0530

anupam.singh – 2 file(s) modified
Trac#1055

Introduced price-range column in productActivity cube.

~ /trunk/pentaho/data-integration/transformations/itemLoader.ktr
~ /trunk/pentaho/schema/ProductActivitySchema.xml

Rev 5046 – Using cod field from order table to identify an order ...

anupam.singh — Mon, 23 Apr 2012 00:37:25 +0530

anupam.singh – 1 file(s) modified
Using cod field from order table to identify an order as COD instead of payment gateway field that was being used earlier.
Trac #1140

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

Rev 4942 – ETL scripts for aggregate tables for productactivity

anupam.singh — Wed, 11 Apr 2012 10:45:16 +0530

anupam.singh – 3 file(s) modified
ETL scripts for aggregate tables for productactivity

+ /trunk/pentaho/data-integration/transformations/dateItemAggregate.ktr
+ /trunk/pentaho/data-integration/transformations/dateOnlyAggregate.ktr
+ /trunk/pentaho/data-integration/transformations/lostItemAggregate.ktr

Rev 4170 – Fixed the logic to count reopen tickest.

vikas — Fri, 02 Dec 2011 11:14:46 +0530

vikas – 1 file(s) modified
Fixed the logic to count reopen tickest.

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

Rev 4097 – trim coupon_code.

vikas — Fri, 18 Nov 2011 16:33:58 +0530

vikas – 1 file(s) modified
trim coupon_code.

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

Rev 4093 – Store coupon_code in uppercase.

vikas — Fri, 18 Nov 2011 15:54:45 +0530

vikas – 1 file(s) modified
Store coupon_code in uppercase.

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

Rev 4044 – Update dataserver for new crm server.

vikas — Mon, 14 Nov 2011 16:55:57 +0530

vikas – 1 file(s) modified
Update dataserver for new crm server.

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

Rev 4030 – Add measures for average time taken to close a ticket, ...

vikas — Fri, 11 Nov 2011 15:06:56 +0530

vikas – 2 file(s) modified
Add measures for average time taken to close a ticket, how many times tickets are reopened

~ /trunk/pentaho/data-integration/transformations/crmLoader.ktr
~ /trunk/pentaho/schema/CRMResponseReport.xml

Rev 3750 – Add payment mode dimension.

vikas — Wed, 19 Oct 2011 12:03:46 +0530

vikas – 2 file(s) modified
Add payment mode dimension.

~ /trunk/pentaho/data-integration/transformations/orderFulfilmentLoader.ktr
~ /trunk/pentaho/schema/FulfilmentReport.xml

Rev 3747 – CRMResponse report data loader.

vikas — Wed, 19 Oct 2011 11:29:36 +0530

vikas – 1 file(s) modified
CRMResponse report data loader.

+ /trunk/pentaho/data-integration/transformations/crmLoader.ktr

Rev 3634 – Fix a bug in logic to find host from url.

vikas — Thu, 13 Oct 2011 16:48:34 +0530

vikas – 2 file(s) modified
Fix a bug in logic to find host from url.

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

Rev 3594 – orderfulfillment etl with delay_reason column added

vikas — Tue, 11 Oct 2011 19:39:03 +0530

vikas – 1 file(s) modified
orderfulfillment etl with delay_reason column added

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

Rev 3548 – Add delay-cause column.

vikas — Fri, 07 Oct 2011 18:52:42 +0530

vikas – 1 file(s) modified
Add delay-cause column.

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

Rev 3544 – Order fulfillment loader kettle script.

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

vikas – 1 file(s) modified
Order fulfillment loader kettle script.

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

Rev 3510 – Updated production data source

rajveer — Sat, 01 Oct 2011 06:43:40 +0530

rajveer – 4 file(s) modified
Updated production data source

~ /trunk/pentaho/data-integration/transformations/cartLoader.ktr
~ /trunk/pentaho/data-integration/transformations/itemLoader.ktr
~ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr
~ /trunk/pentaho/data-integration/transformations/userLoader.ktr

Rev 3496 – Add catalogId column in item loader kettle script.

vikas — Fri, 30 Sep 2011 15:01:21 +0530

vikas – 1 file(s) modified
Add catalogId column in item loader kettle script.

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