Guestbook: Guestbook csv download has issues if contents also includes commas, title, text q.

[kcondon]

Found by a user, see RT 243224, if a dataset's title contains a comma, loading the guestbook download csv into a spreadsheet requires manually removing the comma before it is properly imported. This would also happen if a question had commas or an answer had commas.

One solution might be to scrub commas from content when writing this doc.

---

Update by @pdurbin 2018-05-21

connects to #4671

[mheppler]

Closed this issue as a duplicate of Dataverse Guestbook: Custom question output has inconsistent order #4671 and copied over the original comment.

[pdurbin]

Now that pull request @4700 is in and has nothing to do with commas, @mheppler and I feel a little weird about having this issue closed so I'm re-opening it to put it through QA.

Basically, I added commas all over the place, in questions, answers, dataset titles, etc, and I could not reproduce the bug reported in #4671. It looks like the comma handling was rewritten in Dataverse 4.8 as part of pull request #4057 so I think this bug was fixed then but never tested.

I will say that the code replaces commas with spaces, which is a little weird.

[mheppler]

Confirmed on demo (4.8.6) that commas in answers to custom questions are being replaced with spaces.

Also went back and tried commas in the dataset title, as well as custom guestbook questions, and everything seems kosher here. Looks like commas are properly "scrubbed" and the CSV of responses is downloadable and openable.

[mheppler]

This looks like the commit 4eb80d1 from @landreev that removed the commas from the responses.

[mheppler]

This looks like a duplicate of Guestbook: Cannot download a particular guestbook using Chrome, throws duplicate header error #3581 and also Cannot download guestbook in Chrome if Dataverse has a "," in the name #4512.

@kcondon and @scolapasta are the of those. I already suggested to Kevin that #3581 be closed as a duplicate. I will let the two of them arm wrestle it out to determine if this gets closed, or remains open as the one issue to rule them all.

[kcondon]

@mheppler @scolapasta This appears related to the other 2 since it is a problem with Chrome guestbook download when content contains ',' but I'd just point out that this refers to a comma in dataset whereas the other 2 are likely due to comma in dataverse name.

If Gustavo or Dev wants to work on this together (ask Danny) feel free to combine them. I'd combine to this one, just point to the other 2 since this is the earliest one.

[cmbz]

To focus on the most important features and bugs, we are closing issues created before 2020 (version 5.0) that are not new feature requests with the label 'Type: Feature'.

If you created this issue and you feel the team should revisit this decision, please reopen the issue and leave a comment.