Exporting Views

[danmoss]

We have a database with several thousand documents on it. There is a view which lists some of the information in those documents in a table. I need to export the information in the view and not each of the documents (indeed I actually only need one of the columns from the table). When I tried to export as a CSV file, I got all the individual documents in one big file. Is there a way to export the information in the view instead of the database?

I really hope that makes sense.

Cheers,
Dan Moss
"Once again faced with Notes

 

[pmonett]

Why don't you use the spreadsheet option ?
Excel can open it, and you can simply delete all the info you do not need.
Or, you could create a script to do so, using an ExcelExport library with the necessary routines to write an Excel file directly - but you'd have to dabble with Notes programming to do that.

Pascal.

 

[danmoss]

Thanks for that, exactly what I needed. I exported it as a 123 file and opened it in Excel.

 

[ABOzIT]

Check out this link to get the code for an agent that extracts a view from Notes and creates it in Excel. I use it in a few apps and it works very well.

Once exported to Excel just delete the info you don't need.

http://www.bluestream.org/Domino/ExportToExcelViaNotes.htm

Hope this helps!