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.
0
votes
How are you doing the export? Are you 100% sure that the list is stored properly as multi-values? (I.e., have you examined the field data in the Document Properties dialog or in NotesPeek to see whether it might actually be stored as "frank, john" : "Tom"?)
– Richard Schwartz
I am exporting using Files/Export. Not using any scripts or code to do so. For the field, the Data Type is Text List. When I examine the data in Documents Properties dialog. It is always the right data. "Frank""john""Tom".
– Frank Zhang
Okay. That sounds strange. Perhaps a bug in the export facility. You may have to follow Karl-Henry's advice and write code to work around it.
– Richard Schwartz
2 Answers
0
votes
Please show your code for exporting the view to CSV. Are you looping through the NotesView, opening each document and using the GetItemValues method to get the values, or are you looping through a NotesViewEntryCollection, getting each NotesViewEntry and then using the ColumnValues property to get the visible values in the view?
I suspect that your problem is that you are not treating the values you get back as arrays, but instead only read the first value of the array. If you could post your code, it would help.
You could take a look at some code I posted on my blog a while back, perhaps that can help you: http://blog.texasswede.com/export-notes-view-to-excel-with-multi-value-fields/
