CSV Export drops Notes data
A lightweight and easy-to-use password manager
Brought to you by:
dreichl
Hello,
I have noticed that when I export an entry to CSV, data from Notes is dropped.
You can see an example here.
The exported CSV does contain only one line of text, while it originally contained more lines of text.
If this is an expected behaviour, there should be a possibility to have a full export.
This is the picture, I could not add two attachments to the same post.
The test.csv that you posted contains 12 lines of text. It contains all of the text showning in you Edit Entry screenshot plus a " (quote) at the end, that is not shown in your screenshot.
Note: Excel truncates the data in the file if you open the csv file directly. I think, when you open the file directly in excel, the automatic import that Excel executes is getting confused by the line breaks embedded within the note. However, if you import the csv file into an open worksheet, the entire file contents can be imported.
I opened the csv file in a text editor and saw the entire contents.
Also you can add multiple attachments. You need to select all of the files that you want to upload at once.
Last edit: wellread1 2016-06-06
Actually on furher inspection, Excel correctly imports all of the data. The last column "E1" that contains the value "note1" in the second row is a multi-line entry. In order to see all the data in the excel row you need to expand that row (make the row heigh about 160).
Last edit: wellread1 2016-06-06
Allright, my bad.
As wellread1 said, by using a data editor like Notepad++, all information is exported.
Please disgregard this request.