Exporting view to csv file (not Excel)

HCL Domino Domino Forum
1

First let me say my LotusScript is pretty weak so any help is appreciated.

I’m trying to export a view to a csv file for import into a SQL table. I cannot change the forms or fields so I created a view which uses @formulas to concatenate and ‘tidy’ the fields in the columns so the data presented is correct. I have created an agent using @commands to export this view in R6 using the csv format and it works fine. Now I want to run the agent on a schedule (where @commands are not allowed).

Basically I just want to write the contents of the view as it is displayed, to a file with commas delimiting the columns. Is this possible?

2

Subject: Try ANDI at http://www.bpjl.com

Try this tool and you will save a lot of your time.You can directly export to SQL using ODBC without the need of the CSV file.

But this tool does CSV export anyway.

3

Subject: Exporting view to csv file (not Excel)

Do you want to just export the view contents? If so, you can use File>Export to do it. To do so:1. Open your view

  1. Select File> Export

  2. Select the Save as type: Tabular Text

  3. Enter the File name: e.g test.txt

  4. Press Export