SmartDukaan – /trunk/pentaho/data-integration/transformations/ordersLoader.ktr

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 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 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 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 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 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 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 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 3483 – Fix a minor bug in case statement in sql.

vikas — Thu, 29 Sep 2011 17:15:40 +0530

vikas – 1 file(s) modified
Fix a minor bug in case statement in sql.

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

Rev 3482 – Changes to calculate price range and days to purchase at ...

vikas — Thu, 29 Sep 2011 17:10:43 +0530

vikas – 1 file(s) modified
Changes to calculate price range and days to purchase at the time of data integration itself.

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

Rev 3481 – Changes to calculate price range and days to purchase at ...

vikas — Thu, 29 Sep 2011 16:38:19 +0530

vikas – 2 file(s) modified
Changes to calculate price range and days to purchase at the time of data integration itself.

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

Rev 3436 – Split source columns into source type and source url for ...

vikas — Tue, 27 Sep 2011 11:12:12 +0530

vikas – 2 file(s) modified
Split source columns into source type and source url for performance.

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

Rev 3382 – Add first source time also in sales cube.

vikas — Tue, 20 Sep 2011 18:26:55 +0530

vikas – 1 file(s) modified
Add first source time also in sales cube.

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

Rev 3280 – Use SQL_NO_CACHE. As it cleans the sql cache of prod.

vikas — Tue, 13 Sep 2011 15:07:26 +0530

vikas – 4 file(s) modified
Use SQL_NO_CACHE. As it cleans the sql cache of prod.

Rev 3267 – Use gateway id to get paymethod, if paymethod is not ...

vikas — Mon, 12 Sep 2011 14:14:55 +0530

vikas – 1 file(s) modified
Use gateway id to get paymethod, if paymethod is not set.

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

Rev 3265 – Use latest payment in case of multiple payments for same ...

vikas — Mon, 12 Sep 2011 13:33:35 +0530

vikas – 1 file(s) modified
Use latest payment in case of multiple payments for same transaction.

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

Rev 3221 – Add affiliate to sales report.

vikas — Tue, 06 Sep 2011 18:47:50 +0530

vikas – 1 file(s) modified
Add affiliate to sales report.

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

Rev 2857 – For unknown session and first source dates uses 20110101 in ...

vikas — Mon, 08 Aug 2011 15:29:23 +0530

vikas – 2 file(s) modified
For unknown session and first source dates uses 20110101 in pentaho reports.

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

Rev 2856 – Add session and source times.

vikas — Mon, 08 Aug 2011 15:09:48 +0530

vikas – 4 file(s) modified
Add session and source times.

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

Rev 2853 – Add session and source times.

vikas — Mon, 08 Aug 2011 15:00:30 +0530

vikas – 4 file(s) modified
Add session and source times.

Rev 2834 – Add coupon code.

vikas — Wed, 03 Aug 2011 19:03:36 +0530

vikas – 2 file(s) modified
Add coupon code.

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

Rev 2597 – Add order hour.

vikas — Fri, 15 Jul 2011 14:17:20 +0530

vikas – 1 file(s) modified
Add order hour.

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

Rev 2585 – group by order id as it should be unique.

vikas — Thu, 14 Jul 2011 18:52:48 +0530

vikas – 1 file(s) modified
group by order id as it should be unique.

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

Rev 2584 – Order table transformation to include transfer price, payment details etc.

vikas — Thu, 14 Jul 2011 18:15:33 +0530

vikas – 1 file(s) modified
Order table transformation to include transfer price, payment details etc.

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

Rev 2519 – Updated Transaformations

vikas — Mon, 11 Jul 2011 16:12:24 +0530

vikas – 2 file(s) modified
Updated Transaformations

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

Rev 2400 – created transformations folder

ankur.singhal — Mon, 04 Jul 2011 11:45:46 +0530

ankur.singhal – 3 file(s) modified
created transformations folder

+ /trunk/pentaho/data-integration/transformations
+ /trunk/pentaho/data-integration/transformations/itemLoader.ktr
+ /trunk/pentaho/data-integration/transformations/ordersLoader.ktr