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: Excel Output Columns skewed
Prev Next
You are not authorized to post a reply.

Author Messages
Tim
Posts:4
skipping stones
skipping stones
02/20/2008 3:03 PM  

Weird, using 2.5.1

If I look at the results on the site, everything looks right (see below for example).  If I download the excel sheet, however, everything (almost) is in the wrong column, with no order whatsoever (see attached).  What could cause this???

Club Name : Wright State University
Your Name : Jennifer xxxxxx
Your Position : Assistant Director, Fitness & Wellness
Street : 3640 Colonel Glenn Highway
City : Dayton
State : Ohio
Postal Code : 45440
Telephone : xxxxxxx
Health Club Email : xxxxxxx
Health Club Website Address : www.xxxxxx/crec
hr1 :
Event Start Time : 9:00am
How many bikes will you have available for the event? : 21
Tim
Posts:4
skipping stones
skipping stones
02/20/2008 3:05 PM  

OK, it didn't give me the ability to add the attachment, but here is a cut/paste

 

Club Name Your Name Your Position Street City State Postal Code Telephone Health Club Email Health Club Website Address hr1 Event Start Time How many bikes will you have available for the event?
Dayton 21 Assistant Director, Fitness & Wellness 3640 Colonel Glenn Highway jennifer.turpin@wright.edu Ohio 45440 9:00am 937-775-5816 Jennifer Turpin www.wright.edu/crec Wright State University
Chris
Posts:3
04/22/2008 8:42 AM  

I'm having the same problem.  When I click on "View Form Results it data looks fine, but when I export it to Excel it moves all the data around under the wrong columns.
Chad
Posts:2271
river guide
river guide
08/06/2008 7:06 PM  
Hi guys... I wanted to follow up on this, we found out why this was happening sometimes. Please go to Host, SQL and execute the following script:

ALTER PROCEDURE {databaseOwner}{objectQualifier}DynamicForms_GetDynamicQuestionResponsesByUniqueResponseID
@UniqueResponseID as UniqueIdentifier
AS
select distinct dqr.*,dq.question,dq.questionType, dq.sortorder from {databaseOwner}{objectQualifier}DynamicForms_QuestionResponse as dqr,{databaseOwner}{objectQualifier}DynamicForms_Question_vw as dq
where dqr.DynamicQuestionID=dq.DynamicQuestionID
and UniqueResponseID=@UniqueResponseID
Order By dq.SortORder


This should fix up any Export to Excel issues between versions 2.3 thru 2.6 and this fix has already been applied to the 2.7/beta and upcoming release.


Thanks,

Chad
Kevin
Posts:23
going with the flow
going with the flow
08/15/2008 6:48 PM  
I am having simiilar problems. I executed the script, and am still having scrambled issues. Actually, the module is saving two HTML fields that are marked as don't save. I think that may be the cause of the problem in my case anyway. Stumped!
Kevin
Posts:23
going with the flow
going with the flow
08/15/2008 7:19 PM  
Chad,

I exported my form and uploaded it to betasprings. It is under Dynamic Forms, FIRSTWA Excel Problem. If you do an Excel export, you can see the mess in the file. If the form gets torched, there is an import module called WorkshopSignup.xml in the DynamicForms_Upload directory.

I think I have done this correctly. If you look at the excel output, it has saved two fields it should not have. Both are Text/HTML fields, and are checked not to be saved nor displayed. The result is a mess. Any options on how to fix this would be greatly appreciated.

In addition, is there a way to save the short name in the excel file rather than the full question as the column heading? That would also be very nice.

Thanks
Kevin
Chad
Posts:2271
river guide
river guide
08/18/2008 11:19 AM  

Kevin,

 

Hi. After a  quick review it appears that its adding HTML field columns to the file, however its not adding the HTML field to each row (which would cause a scew). We have added code in the past to skip row data such as HTML and HR fields, however it doesn't appear that this was added to the area when the columns are being created in the initial part of the file.

 

So... We have fixed this now for the 2.7 upcoming release (you can test again on the same page you set this demonstration on) and you will see that its exporting properly.

 

For now... I was also able to get around this by deleting the first few rows of data which was causing the problem. I opened the file in notepad and then resaved it after deleting the first two rows causing the problem. I am also attaching the file below so you want see it opened properly after I deleted the first row.

 

-Chad

 

 


Kevin
Posts:23
going with the flow
going with the flow
08/19/2008 11:51 AM  

Thanks so much for the quick fix. Much appreciated.

Any thoughts on the idea of using the shortname instead of the question as the header for the column?

Thanks
Kevin

 
Chad
Posts:2271
river guide
river guide
08/19/2008 12:15 PM  
Hi. Yes I think this would be a nice enhancement with minimal overhead. The 2.7 release is already at documentation and testing right now so it probably won't make that release but we will review adding it to the next minor or major release. Just a checkbox that says 'Use short field names for column headings'.

-Chad
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms > Excel Output Columns skewed


ActiveForums 3.7

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