Tim Hardin
wading in the water
Posts:24
 |
| 02-20-2008 01: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 Hardin
wading in the water
Posts:24
|
| 02-20-2008 01: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 Cunningham
new to the springs
Posts:3
|
| 04-22-2008 06: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 Nash
Posts:5260
|
| 08-06-2008 05: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 Ross
going with the flow
Posts:39
|
| 08-15-2008 04:48 PM |
|
I am having similar 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 Ross
going with the flow
Posts:39
|
| 08-15-2008 05: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 Nash
Posts:5260
|
| 08-18-2008 09: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 screw). 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
|
 RemoveHeaderLines7a5b7931-0a51-417d-bf3c-5521a4741
|
|
|
|
Kevin Ross
going with the flow
Posts:39
|
| 08-19-2008 09: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 Nash
Posts:5260
|
| 08-19-2008 10:15 AM |
|
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
|
|
|
|
|
Tim Hardin
wading in the water
Posts:24
|
| 03-01-2009 08:53 PM |
|
OK, I just upgraded from 2.5 to 2.7, and the output is still skewed.
The form was created in 2.5. I deleted all the data, but now the new data is still off by two columns (or more).
The form I have is pretty big, do I have options other than rebuilding the whole form?
Thanks
Tim |
|
|
|
|
Tim Hardin
wading in the water
Posts:24
|
|
Tim Hardin
wading in the water
Posts:24
|
| 03-12-2009 08:04 PM |
|
OK, not sure why no one could have just told me this...
Updating from 2.7.0 to 2.7.5 fixed the problem. In the thread, it stated that "2.7" fixed the issue.... I really with this hadn't taken this long to resolve.
Tim |
|
|
|
|
Candace
river guide
Posts:2431
|
| 03-13-2009 07:45 AM |
|
Hi Tim,
Sorry about that. I'm glad you got it working now. Please do let us know if you have additional questions. You can post your question here in the forums or use the Contact Us form. Thanks!
Candace |
|
|
|
|
Shawn Romine
Posts:73
|
| 04-16-2010 11:06 AM |
|
I am having this issue as well.....when I export all data to excel - the column headings do not match up with the data.....I am running Dynamic Forms version 03.30.40......
Any solutions for me? |
|
|
|
|
Shawn Romine
Posts:73
|
| 04-16-2010 11:06 AM |
|
Let me add that the normal Views Results looks fine. |
|
|
|
|
Mark Buelsing
river guide
Posts:241
|
| 05-06-2010 05:13 AM |
|
You are not alone. My Excel output is a bit jumbled also. I'm on DF Ver:3.3.40.0 / 5.4.1. I'd like to hear your solution when you get it. |
|
|
|
|
David To
river guide
Posts:2719
|
| 05-06-2010 02:04 PM |
|
This has been something that we have been able to duplicate on our test environment and is our on list for future patches/fixes. Fits rom our research and your email…
1. It appears that whenever question events are used
2. AND if sometimes the question events bring in different results for different submissions
3. If the results are null/empty these values are being skipped and its causing the excecl output to be skewed.
So… I am assuming on export we will need to check for null values and let it be represented be an empty string… I have not had time to test this but its on our list for future patches/releases. We hope to have the next Dynamic Forms patch fixing some other issues as well by the end of the month.
-- Chad |
|
|
|
|
ClydeG
going with the flow
Posts:61
|
| 06-04-2010 10:09 AM |
|
Quote Reply Alert
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'.
I havent been able to find where this feature is located. Has it been added yet? |
|
|
|
|
Chad Nash
Posts:5260
|
| 06-04-2010 10:12 AM |
|
Hi Clyde, Thanks for the heads up... At this time this feature has not currently been added to the module. I just checked again though and it is on a future enhancement list (just set to a lower priority). I bumped it up to at least medium priority though  . Thanks, Chad |
|
|
|
|
ClydeG
going with the flow
Posts:61
|
| 06-04-2010 11:12 AM |
|
Thanks Chad. It would be very helpful. Is there another way to make this happen? |
|
|
|
|
Chad Nash
Posts:5260
|
| 06-04-2010 11:15 AM |
|
Hi Clyde,
Well what specifically is happening to your export? Is it skewed because of the column names (questions)? It might not matter if it was based on short field names, the bigger issue could be that there are commas in the values/data entered and this is messing things up maybe? The CSV file is a comma seperate file so if the values have comma's in them I think this could skew the results when you open it in Excel.
-Chad
|
|
|
|
|
ClydeG
going with the flow
Posts:61
|
| 06-04-2010 11:25 AM |
|
Hi Chad, luckily, my results arent getting skewed, I just need the names of the columns to be the same as the short name. We are taking the results and importing them into another software product.
Thanks for the help! |
|
|
|
|
Chad Nash
Posts:5260
|
| 06-04-2010 11:27 AM |
|
In that case there really shouldn't be too much trouble (until the feature is added). You should just be able to remove the entire top line and then put a comma separated list at the top of all of the short field names.
-Chad
|
|
|
|
|
ClydeG
going with the flow
Posts:61
|
| 06-04-2010 11:30 AM |
|
Ha, yes...that would work as a manual fix..thanks. |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 06-07-2010 12:02 PM |
|
Hello Clyde,
I'm glad to see that you have your issue resolved. If you ever need any assistance please let us know.
Thank you,
Ryan |
|
|
|
|
Chad Nash
Posts:5260
|
| 07-01-2010 09:34 PM |
|
Just a heads up... This has been added under control panel, module configuration, view form result options, under a few feature to export the results with the short field name as the column headers instead of the question. We also added feature to choose an alternate excel file delimiter as well. These will be in the upcoming 3.4 release along with many other goodies!
Thanks,
Chad
|
|
|
|
|
ClydeG
going with the flow
Posts:61
|
| 07-02-2010 04:01 AM |
|
Awesome Chad! Thanks a ton! This has been a great product with excelland support!
Do you have an estimated release date? |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 07-02-2010 08:08 AM |
|
Hello Clyde,
Thank you very much for your input, if you really like our products and support, you can post a review for us on snowcovered. This helps us stand out against other competitors. Can you please visit this link to post a review for us:
Snowcovered Review
The expected release date for Dynamic Forms 3.4 is around the end of July.
Thanks Clyde,
Ryan |
|
|
|
|