Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Live Content v1.6 :: Web 2.0

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!

Ultra Video Gallery 2.4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

Opt In Email 4.0

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Open-DocumentLibrary v3.0

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

Dynamic Forms 2.7

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

Ultra Media Gallery 5.4

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Data Springs Collection 2.0 (20+ Modules)

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

Catalyst By DrNuke

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

Minimalist by Evan O'Neil - ALL NEW !

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

    |   Register   |   Thursday, December 04, 2008   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Subject: Looking for a clean, quick and painless export solution for your Dynamic Forms data? This thread is for you.
Prev Next
You are not authorized to post a reply.

Author Messages
Alfonso
Posts:8
skipping stones
skipping stones
06/17/2008 11:12 AM  

Click here to download the PA @ RapidShare

Like may of you, I had the need to get cleaner export results, so I ended up with the task of developing a custom solution myself. 

This module allows you to export your modules without the hassle of some problematic characters and unwanted HTML fields, and you can also use it to retrieve data from any of your dynamic forms modules within your portal.

The link will provide you with my module PA, just download it and upload it via module definitions and you're all set!!!

Don't be fooled by anyone, this baby is freebie. Code is included inline if you're curious. Cheers!
Alfonso
Posts:8
skipping stones
skipping stones
06/20/2008 11:40 PM  
Sooooo... what do you think?
I expected a bit more enthusiasm about the sharing of this custom module, as it's a good alternative for the cursor/temp table solution provided in another thread. The module also gives you the ability to extract results from any form you have in the portal, so you don't have to extract the results one module at a time.

In any case, I hope it helps some people to get out of a binding, as it did with me.

Cheers,
Al
Chad
Posts:2271
river guide
river guide
06/21/2008 6:15 PM  

Al,

Hi. Well it has only been posted a few days

I also installed and checked out the code and it looks like a very clean solution that should be very useful to anyone wanting to export the data and having problems with the current two methods (either the standard Export or the advanced SQL query). Ill add a comment to that post as well with a link to this thread.

Thank you for your contributions...

-Chad
Bamse
Posts:71
river guide
river guide
06/24/2008 8:24 AM  
thx for your contribution!

two things that would be good to have is module id in the dropdown (sometimes the form is without name so the dropdown is empty) and add username in the export.
Bamse
Posts:71
river guide
river guide
08/26/2008 4:27 AM  

Hi, i have a updated version. This version fixes problems when one user submitt more then one question and some answers where always blank. Also username and email address for a logged in user is also default inserted. Where can we put it?
Chad
Posts:2271
river guide
river guide
08/26/2008 6:42 PM  
Hi, thanks!

If you would like you can email it to us or add it as a zip file (file upload) to this thread. When adding or replying you should be able to attach a document I believe.

-Chad
Chad
Posts:2271
river guide
river guide
08/27/2008 11:27 AM  

---------------

 

Here is a update modified version of a generic DF exporter that works for us.

Br /Ls

Attachment: DynamicForms_Exporter_PA_.zip
Alfonso
Posts:8
skipping stones
skipping stones
09/10/2008 9:57 AM  
Hi there guys,

Before anything thanks for the update Bamse&Chad!! it did come in handy with a DF that I just released. In my case, most of my forms are filled in by Unregistered users, so in order to enable the exports these answers I had to run the following script which you can use as well in Host->SQL:

ALTER PROCEDURE {databaseOwner}{objectQualifier}DynamicForms_GetResultsUR
(
@PortalId INT,
@TargetModuleId INT
)
AS
DECLARE @itQuestions TABLE (Idx INT IDENTITY, DynamicQuestionID UNIQUEIDENTIFIER, Question NVARCHAR(3000), SortOrder INT)

INSERT INTO @itQuestions (DynamicQuestionID, Question, SortOrder)
SELECT Q.DynamicQuestionID, Q.Question, Q.SortOrder
FROM DynamicForms_Question AS Q (NOLOCK)
WHERE Q.PortalId = @PortalId AND Q.ModuleID = @TargetModuleId
AND Q.InActive = 0
AND Q.QuestionType IN ('CheckBox', 'CheckBoxList', 'ComboBox', 'Date', 'ListBox', 'RadioButton', 'TextBox')
ORDER BY Q.SortOrder

SELECT * FROM @itQuestions

SELECT Q.Idx, REPLACE(R.Response, CHAR(13), '') AS Response, ISNULL(U.UserName, '') AS [UserName], ISNULL(U.Email, '') AS [Email], R.UniqueResponseID AS [ResponseId]
FROM @itQuestions Q
JOIN DynamicForms_QuestionResponse AS R (NOLOCK) ON R.DynamicQuestionID = Q.DynamicQuestionID
LEFT JOIN dbo.Users AS U (NOLOCK) ON R.UserId = U.UserId
ORDER BY R.UserId, R.UniqueResponseID, Q.SortOrder

Now... most of the exporting issues might be already solved in the latest release of DF, but we can keep this thread alive and keep releasing updates for the rest of us that for one reason or another can't update to the latest release of DF, or why not, use this module a centralized exporting solution for your DF modules in your portal. If you think of a feature that you would like to see in this satellite module please feel free to either post it in this thread or update the module yourself with the feature added




You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms > Looking for a clean, quick and painless export solution for your Dynamic Forms data? This thread is for you.


ActiveForums 3.7

Copyright 2005 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement