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