Quotation marks are omitted
Just a friendly bug report for Quirkos v1.5.2 (signed 13-Aug-2018) and running Windows 10 Pro x64 version 1803.

When quotation marks are present in a source document, strange things happen when when importing from a CSV file (i.e., using Structured Questions): 
  • In the case of double quotes ( " ), they are silently omitted as if they simply were not there. 
  • In the case of single quotes ( ' ), they are also omitted, but additionally strange results appear after the import, such as the merging of two cells into one (thus leaving holes in the questions where data should be) and adding a comma between the two question responses. Please see the attached screenshots and XLSX* file for clarification.
In both cases, the quotes can successfully be re-inserted using Quirkos (i.e., the edit is retained), and the problem does not appear when importing the source as a docx (i.e., not using Structured Questions).


*P.S. This forum won't accept CSV file attachments, but note that I created the CSV file by saving the attached XLSX file as a "CSV UTF-8 (comma delimited) (*.csv)" using Word 2016 (installed locally via Office 365).

Screenshot 1 
.png   QuotesTest_SingeQuoteStrangeness.png (Size: 452.72 KB / Downloads: 0)

Screenshot 2 
.png   QuotesTest_DoubleQuotesOmitted.png (Size: 447.95 KB / Downloads: 0)

Spreadsheet with data
.xlsx   TestSources.xlsx (Size: 9.62 KB / Downloads: 1)
Thanks for providing an example file Ryan, I can see the same problem in Windows and we are looking into it.

(20-09-2018, 12:08 PM)daniel Wrote: Thanks for providing an example file Ryan, I can see the same problem in Windows and we are looking into it.


Any progress on this? Unfortunately, I'm still seeing the problem in v1.6.1.
However, I've found a workaround that may help with troubleshooting and save others considerable frustration: 

  1. In the original Excel spreadsheet, use Ctrl+h to find/replace all single quotes and double quotes with their respective HTML codes:
    ' with  & #39;  [note: remove the space after the &] 
    " with  & #34;  [note: remove the space after the &]
  2. Save the spreadsheet as file type "CSV UTF-8 (comma separated values)" 
  3. Import this CSV into Quirkos 
Doing so preserves the double quotes and avoids the problem I described with the single quotes (i.e., causing adjacent cells to merge together unexpectedly and being replaced with commas). 

Attached is a sample Excel file that implements the workaround for ease of testing (TestSources_WorkAround.xlsx) and a screen shot showing the result of the workaround (QuotesTest_SingleQuoteStrangeness_Corrected.png).

The one drawback I've found with this workaround is that the Search function in Quirkos then fails to find single and double quotes unless you instead search for the appropriate HTML code. It then displays them as ' and " until you try to expand the quote leftwards. See attached screen shot (QuotesTest_SingleQuote_SearchSideEffect.png)

Thanks for your efforts toward a more straightforward and intuitive import of data.

Attached Files
.xlsx   TestSources_WorkAround.xlsx (Size: 11.14 KB / Downloads: 0)
.png   QuotesTest_SingleQuoteStrangeness_Corrected.png (Size: 316.12 KB / Downloads: 0)
.png   QuotesTest_SingleQuote_SearchSideEffect.png (Size: 287.27 KB / Downloads: 1)
Still an issue v2.3.1, but the workaround with HTML codes (above) no longer works very well. 
A better workaround using Excel is to find/replace all quotes with right-slanting quotes (i.e., replace " with ” and replace ' with ’ ) and save as CSV UTF-8. This gives both a successful import and retains some semblance of the quotes and apostrophes within the text. 

Forum Jump:

Users browsing this thread: 1 Guest(s)