Task Notes

[Laurence Haswell]

Hello, firstly, thanks for developing this facility and making it available.

I add notes to many of my tasks, but the CSV file only seems to include the first line. Is there a means to backup the complete notes section?

Laurence

[Google Tasks Backup Moderator]

Hello Laurence,

GTB does export all lines of the notes, but the format is slightly different depending on which CSV format is used. GTB has 5 different CSV export types;

1. Outlook CSV
   
2. Raw CSV
   
3. Raw CSV, formatted dates
   
4. Raw CSV, RFC3339 timestamps
   
5. Import/Export CSV
   

The first 4 formats include embedded line breaks within the notes field.

The 5th format (Import/Export CSV) replaces each embedded line break with the \n literal.

Which CSV format are you using? 

Which program and operating system are you using to read the exported CSV file?

Different programs handle columns with embedded line breaks differently.

For example;

• Text editors such as Notepad displays the entire text
• LibreOffice Calc 5 on Windows or Linux displays all the lines
  
• Excel 2007 on Windows, by default only displays the first line in each cell [1]
  

[1] To quickly display all the lines in a cell in Excel 2007, click on the cell and press <F2>.

To display all lines for all the notes in Excel 2007;

• Select the Notes column
  
• Right click the selected column and click "Format cells ..."
  
• Click the [Alignment] tab
  
• Ensure that "Wrap text" is ticked (not a black square)
  

I hope this helps,

Julie

GTB/GTI Developer

--
You received this message because you are subscribed to the Google Groups "Google Tasks Backup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to tasks-backup+unsubscribe@googlegroups.com.
To post to this group, send email to tasks-...@googlegroups.com.
Visit this group at https://groups.google.com/group/tasks-backup.
For more options, visit https://groups.google.com/d/optout.