Export to Excel - data all goes in a single column
Last Post 06-20-2012 04:43 AM by Julie Ellsworth. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Julie EllsworthUser is Offline
going with the flow
going with the flow
Posts:42
Avatar

--
06-18-2012 11:02 AM
    After upgrade to DF 4.1, all data goes into a single column when exporting to Excel instead of each field going in a seperate column. We are using dynamic Forms 4.1 and DNN 6.1.2. Thoughts?
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-19-2012 01:46 PM
    Hi Julie - I thought we had this fixed so ill have to check again...

    But... Here is the work around for what to do about this:
    http://www.datasprings.com/dnn-modu...l-issue/3/

    Thanks,

    Chad
    Julie EllsworthUser is Offline
    going with the flow
    going with the flow
    Posts:42
    Avatar

    --
    06-20-2012 04:43 AM
    Hi Chad-

    So, this is going to sound strange but I swear it's true. As I said above, if I go to one of our forms that existed before the last upgrade and go to export results to excel, it saves it as a csv file and when I open it in Excel all data goes into one column.

    I spent some time this morning trying out the different options from the discussion you mentioned above. After much experimenting, I found out that simply opening up the "View Results Options" under Module Configuration, not making any changes at all, and clicking on "Update Settings" triggers it into exporting the file as an xls and everything looks as it should with each field in a seperate column.

    One thing to note - when I go to open the file in Excel I get a warning saying "The file you are trying to open is in a different format than specified by the file extention. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to opent the file now?" I choose "yes" and the file opens without incident.

    Hope this is helpful for anyone else who is experiencing this problem... a pretty easy solution.

    Thanks for you help Chad.


    ---
  • 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