Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Looking for a clean, quick and painless export solution for your Dynamic Forms data? This thread is for you.
Last Post 11-10-2009 09:06 PM by Ian Symonds. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Alfonso PerezUser is Offline
skipping stones
skipping stones
Posts:8
Avatar

--
06-17-2008 09: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 PerezUser is Offline
    skipping stones
    skipping stones
    Posts:8
    Avatar

    --
    06-20-2008 09: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 NashUser is Offline
    Posts:5260
    Avatar

    --
    06-21-2008 04: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



    bamseUser is Offline
    going with the flow
    going with the flow
    Posts:70
    Avatar

    --
    06-24-2008 06: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.


    bamseUser is Offline
    going with the flow
    going with the flow
    Posts:70
    Avatar

    --
    08-26-2008 02: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 NashUser is Offline
    Posts:5260
    Avatar

    --
    08-26-2008 04: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 NashUser is Offline
    Posts:5260
    Avatar

    --
    08-27-2008 09:27 AM

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

     

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

    Br /Ls


    DynamicForms_Exporter_PA_.zip

    Alfonso PerezUser is Offline
    skipping stones
    skipping stones
    Posts:8
    Avatar

    --
    09-10-2008 07: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






    Ian SymondsUser is Offline
    new to the springs
    new to the springs
    Posts:3
    Avatar

    --
    11-10-2009 09:06 PM

    Hey.. Thanks...this rocks. I first ran it and showed no results, but the updated version is great.
    It gets my client out of a bind, in the short term. In the medium to long term we'll be updated the version.

    Thank you



    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi