Downloading submissions as Excel - CSV/Old Layout: Selected options in check boxes are not separated on the report

  • Profile Image
    Kevin_G
    Asked on January 16, 2018 at 12:52 PM
  • Profile Image
    Langdon
    Answered on January 16, 2018 at 01:00 PM

    For example the old CSV file would have options separated as such:

    Red; Blue; Green; Yellow

    The new CSV files are spitting out:

    RedBlueGreenYellow

    Without the formatting in place I am not able to use the CSV file the way I need to. I can manually add the formatting back in, but that is a short term solution as every single multiple choice field across multiple submissions a day will be an unrealistic amount of work. Is there a way I can get the CSV files in their prior formatting?

  • Profile Image
    Mike
    Answered on January 16, 2018 at 01:58 PM

    Kevin has already escalated a bug report ticket, so this should be checked by our developers.

    If possible, please share a CSV file example of the old report. This might help our developers in their troubleshooting.

  • Profile Image
    jackkellerinc
    Answered on January 16, 2018 at 02:51 PM

    I've linked an old CSV file to the end of this comment.

    Note Column AO has multiple choice answers and they are formatted as such: "ClosetoBusLine; CornerLot; InCounty; LotOversized; StreetPaved"

    However on a NEW CSV file downloaded today they look like "ClosetoBusLineCornerLotInCountyLotOversizedStreetPaved" with no formatting.


    (Link removed for privacy)

  • Profile Image
    Mike
    Answered on January 16, 2018 at 03:51 PM

    Thank you for provided information. I have included it to the ticket details and marked this thread as private.

    We will get back to you once we have any updates on this.

  • Profile Image
    Langdon
    Answered on January 17, 2018 at 10:43 AM

    Hello, is there a reason I’ve been blocked from a thread that was created specifically for me by a customer service rep? I’m capable of making my own forum threads and have done so several times in the past. I allowed the chat agent to make one on my behalf out of convenience. Had I known I would be subject to losing access to it by doing so I would have made it myself. This change your team is investigating is seriously hindering my day to day business operations. Any chance I can regain access to the thread?

  • Profile Image
    david
    Answered on January 17, 2018 at 11:39 AM

    The thread was marked as private due to sharing a link to your submission document.  If you don't mind that document being publicly available we can set the thread back to public.  We can remove the document link from your post being doing so.

  • Profile Image
    Langdon
    Answered on January 17, 2018 at 12:43 PM

    It is okay if it is private from the public, however I have lost access to the thread as well. I get an “Unauthorized Access” message when attempting to view it. What good does that do me if I am unable to view future developments or get updates myself?

  • Profile Image
    david
    Answered on January 17, 2018 at 12:47 PM

    The thread is now set to public and should be accessible once again.  We will let you know as soon as we have any updates.

  • Profile Image
    onur
    Answered on January 19, 2018 at 02:49 AM

    Hello,

    It should be fixed by now. Sorry for the inconvenience. 

    Regards.