s
Contact Login Register
h M

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 (169020)/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 (188136)/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 (171863)/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 (170846)/Comments (-)/ Article rating: No rating
Categories: In The Flow
Tags:
RSS
First 567891011121314

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