s
Contact Login Register
h M

Sell Modules and Skins? Setting up DotNetNuke Store w/ Google Analytics and Ecommerce Tracking

Hi everyone! Last week I spoke as a panelist for DotNetNuke store and vendors webinar which DNN Corp put together… Within the webinar I presented some new features and enhancements that DotNetNuke recently added to the DNN Store related to Google Analytics and ECommerce Tracking. Analytics with Ecommerce allows vendors to properly setup and measure their marketing dollars to find out where sales and transactions came from, and which marketing dollars led to those efforts. You can find out more about Ecommerce tracking here: https://developers.google.com/analytics/devguides/collection/gajs/gaTrackingEcommerce

I approached the DNN Store a few months ago regarding how the store could begin to take advantage (and vendors could then take advantage) of new Google Analytics w/ Ecommerce tracking features. DotNetNuke worked to create a pilot program for us to assist with the implementation/testing so that they can offer the enhancements to all vendors. BIG THANKS to DNN Corp for adding these enhancements!

Previously, Snowcovered did allow for Google Analytics integration, however this had to be a separate integration code that was specific to the www.snowcovered.com domain. When it comes to properly setting up analytics (and then enabling the ecommerce feature), there are several steps involved to make sure that the domain name can be properly tracked without losing the analytics information throughout the process. 

 

So… How can you take advantage of these new enhancements?

Step 1:  Make sure you have an Analytics account and you have already enabled/implemented your Analytics Code on your website. https://www.google.com/analytics

Step 2: Enable Ecommerce within your Google Analytics account. You can do this be signing into your account and navigating into “Admin”, then “Property Settings”, and finally choosing to enable the Ecommerce Option.

Step 3: Enable Ecommerce and your tracking code within the DNN Store.There are two new fields in the vendor profile area. The GA SetDomianName is set to “none” by default for all vendors, this is the setting needed for the cross site tracking. The Enable GA Ecommerce is disabled by default, if a vendor would like to track the ecommerce data they will need to check this.

DNNStore_GA

 

Step 4: Modify your JavaScript for using Google Analytics to include a few additional settings for setting the domain name, allowing the “Link Tracking”, and tracking the page view.  Specifically you need to enable the options for setDomainName, setAllowLinker, and trackPageView

 

Step 5:  Accurately utilize tracking… you will need to setup all hyperlinks that are pointing to the store to use the Google Analytics Link Tracking Onclick event. You can find more information here:

Here is an example.. Notice how the HREF still stays the same as it used to, however now there is also an “onclick” javascript reference within the hyperlink tag.

Tuesday, May 29, 2012/Author: Chad Nash/Number of views (72539)/Comments (-)/ Article rating: No rating

Categories: In The Flow
Tags:

Integrating Google Analytics with Data Springs Products

Do you want to, or are you already using Google Analytics with your DotNetNuke site?
 
Data Springs can assist by integrating our products with your Google Analytics via our newly formed “Premium Integration Services”.

 

Data Springs overtime has developed techniques that can help simplify the interaction layer between Google Analytics using our products. Below are a couple out of dozens of ways that Data Springs can help you with integrating our products with Google Analytics.

  • We can assist by creating a web interface to allow you to add Ecommerce Transactions & Items to Google Analytics.
  • We can assist by creating a web interface to allow you to delete Ecommerce Transaction & Items from Google Analytics.

 

Please contact us at dnnsupport@datasprings.com if you have any questions or would like to request additional information.

Tuesday, May 15, 2012/Author: Chad Nash/Number of views (68728)/Comments (-)/ Article rating: No rating
Categories: In The Flow
Tags:

Using Authorize.net Automated Recurring Billing (ARB) with DataSprings Dynamic Registration Module.

DataSprings Dynamic Registration Module (DR) provides an easy way to implement ARB into your portal by just dropping a few specifically named textbox fields (most of the hidden) on your registration page. This document and video will cover implementing a very basic registration page using the minimum required fields that authorize.net requires to set up an account.

I recommend getting a page with the minimum requirements working first before adding extra fields like billing startdate (trial), email, etc.

Other Notes before we begin:

1. I am assuming you already have a live authorize.net account with ARB capabilities. If you do not have ARB, you have to add that service to your account. At this time its $10 a month. I am not certain that ARB works with a developer account. I also did not try this in test mode. To test I set the amount to $1 and just cancelled the subscriptions as I tested.

2. DataSprings Registration 4.2 was used in this demo (currently in Beta with a scheduled release date of May 24th 2012).

3. It’s super helpful to make sure you have debug info being logged to the event log during development. This will help you find errors.

Here is the link to the video tutorial - http://www.youtube.com/watch?v=vvCuymywG-M

Set Up

If you are familiar with how to set up other gateways with DR, forget everything you know J. This one is set up totally different. Rather than building a big string of values to submit under Module configuration, you are populating and/or giving very specific names to fields on your form.

To get a form with the most basic ARB set up create a form with the following fields. To get a working version first I recommend making all of these text fields, then once its working change the appropriate fields to hidden. I marked them with an underline.

Your basic registration fields (username,email, password,confirm password)

 

Authorized.NET ARB Required fields. This fields MUST have their short names exactly as below;

1. PGateway – default this to AuthARB. This tells DR to use the arb gateway.

2. AuthARB_UserLoginNamedefault this to your login name from authorize.net.

3. AuthARB_TransactionKeydefault this to your transaction key generated fron authorize.net

4. AuthARB_BillToFirstName – assign this short name to your first name field on your form

5. AuthARB_BillToLastName - assign this short name to your Last name field on your form

6. AuthARB_SubscriptionAmountdefault this to the amount of your subscription. If you have different values that can be assigned here, you can use the DR tutorials to learn how to assign different values to a field using javascript.

7. AuthARB_CardNumber – assign this short name to your credit card field

8. AuthARB_CardExpireDateassign this shortname to your expire field. If you have a dropdown box for month and another one for year. You can use javascript to combine these values as text in this field. It likes it like mmyyyy.

9. AuthARB_SubscriptionID– (optional for Creating a subscription / Required for Cancel or Update of a subscription). When creating a subscription, this field will be stored within Dynamic Registration with the subscription ID when the subscription through ARB is created.  If you are referencing a subscription type of “Cancel” or “Update” then this field should reference the existing subscription ID.


Optional Properties

1. AuthARB_SubscriptionOccurrences

Tuesday, April 17, 2012/Author: Chad Nash/Number of views (75763)/Comments (-)/ Article rating: No rating
Categories: In The Flow
Tags:

Exporting Dynamic Form Results and Importing to flat table.

 

Hello Everyone,

I have taken the liberty to create SQL Stored Procedures to Export results from the DynamicForms_QuestionResponse table and insert these values into a temp table called “Export_Temptable”. I have also created SQL Stored Procedures to Import the records in the Export_TempTable to a Flat table of my choice.

 

This blog is broken into 2 parts.

Part 1 covers the Export

Part 2 covers the Import

 

Part 1 – Export

Step 1.) Start by creating this table on your data base(You can do so by going to Host –> SQL on your DNN Installation):

----EXPORT TEMP TABLE

CREATE TABLE Export_TempTable
(
ExportRecordID int identity(1,1),
QuestionResponse nvarchar(500),
QuestionName nvarchar(500),
QuestionValue nvarchar(500),
ResponseDate datetime
)

Step 2.) Now you will need to create the Export procedure on your data base(You can do so by going to Host –> SQL on your DNN Installation):

-----EXPORT PROCEDURE

CREATE PROCEDURE Export_DynamicForms_Results 

@ModuleID int 

AS 
BEGIN 
DECLARE Cart_Cursor CURSOR FOR 
select A.UniqueResponseID ,B.ShortFieldName, A.Response, A.ResponseDateTime from DynamicForms_QuestionResponse A inner join 
DynamicForms_Question B on A.DynamicQuestionID = B.DynamicQuestionID where B.ModuleID = @ModuleID and ShortFieldName <> 'HumanCaptcha' order by B.ShortFieldName 
OPEN Cart_Cursor 
DECLARE @V1 nvarchar(400), @V2 nvarchar(400), @V3 nvarchar(400) , @V4 nvarchar(400) 
FETCH NEXT FROM Cart_Cursor INTO @V1, @V2 , @V3, @V4
WHILE @@FETCH_STATUS = 0 
BEGIN 
If @V2 Is Null 
BEGIN 
Set @V2 = '' 
END 
If @V3 Is Null 
BEGIN 
Set @V3 = '' 
END 
INSERT INTO Export_TempTable(QuestionResponse, QuestionName, QuestionValue, ResponseDate) 
VALUES(@V1, @V2, @V3, @V4) 
FETCH NEXT FROM Cart_Cursor INTO @V1, @V2, @V3, @V4
END 
CLOSE Cart_Cursor 
DEALLOCATE Cart_Cursor 
end

Step 3.) Test the Export Procedure

To test the Export procedure, go to a Dynamic Form instance and obtain the ModuleID for that Dynamic Form.

Go to Host –> SQL on your DNN Installation and run this SQL (Example ModuleID = 224):

Exec Export_DynamicForms_Results  224

After executing the Stored Procedure execute the below query:

Select  * from Export_TempTable

You should be able to see all or most of your of your exported records.

 

Part 2 – Import

 

Step 1.) Create Import Procedure 1

 

----IMPORT PROCEDURE 1 OF 2


CREATE PROCEDURE Import_DynamicForms_Results

AS
BEGIN

DECLARE @UNIQUE nvarchar(200)
DECLARE @COUNT int

DECLARE Import_Cursor CURSOR FOR

select QuestionResponse from Export_TempTable order by QuestionResponse

OPEN Import_Cursor
DECLARE @V1 nvarchar(400)
FETCH NEXT FROM Import_Cursor INTO @V1
WHILE @@FETCH_STATUS = 0
BEGIN


If @V1 Is Null
BEGIN

Wednesday, April 11, 2012/Author: Chad Nash/Number of views (69650)/Comments (-)/ Article rating: No rating
Categories: In The Flow
Tags:

Need CC Test numbers?

Here is a nice cheat sheet of testing CC numbers.

Card Type Number
The table above contains a number of credit card numbers that can be used to test credit card handling software. None of these numbers will work when trying to buy something (if you hadn't guessed).
Master Card (16 Digits) 5105105105105100
Master Card (16 Digits) 5555555555554444
Visa (13 Digits) 4222222222222
Visa (16 Digits) 4111111111111111
Visa (16 Digits) 4012888888881881
American Express (15 Digits) 378282246310005
American Express (15 Digits) 371449635398431
Amex Corporate (15 Digits) 378734493671000
Dinners Club (14 Digits) 38520000023237
Dinners Club (14 Digits) 30569309025904
Discover (16 Digits) 6011111111111117
Discover (16 Digits) 6011000990139424
JCB (16 Digits) 3530111333300000
JCB (16 Digits) 3566002020360505
Thursday, April 5, 2012/Author: Chad Nash/Number of views (69168)/Comments (-)/ Article rating: No rating
Categories: In The Flow
Tags:
RSS
1234

Enter your email below AND grab your spot in our big giveaway!

The winner will receive the entire Data Springs Collection 7.0 - Designed to get your website up and running like a DNN superhero (spandex not included).

  
Subscribe
united luxury shop
konulu porno
deneme bonusu maltcasino bahis siteleri
sex video free download in mobile hot sexy naked indian girls download free xxx video
antalya escort
atasehir eskort antalya escort bahcelievler escort alanya escort atasehir escort
porno izle
gaziantep escort gaziantep escort
escort pendik
izmir escort kayseri escort gaziantep rus escort
vdcasino casino metropol casinomaxi
baybahis
holiganbet
beylikdüzü escort