I have a view in Lotus Notes 8.5 that I want to export the data to a csv file. There are these kind of fields that are list. Say I have a field called "editors".It has multiple editors for one document. When I export the data to a csv file, the field is "frank, john, Tom". It is comma separated. But I found that sometimes, it is losing data. Sometimes I only got "frank, john". "Tom" is lost.
I have had the same thing happen to me.... losing data. I found that in some of the fields there were commas included in the field values and this is how the data did not completely export.
I ended up writing an agent with Lotusscript and exported the data in that manner.