Export 500 x 200 emails into csv

HCL Domino Domino Forum
1

Dear List Members,

I suspect that some kind of script is needed for the following task. (I work with perl on linux from linux and windows terminals)

I have a .nsf file with 500 bundles, each containing 200 emails. I would like to automatically export all fields of all 100k emails into csv files.

Thanks in advance for your suggestions,

Illes

2

Subject: RE: export 500 x 200 emails into csv

Hi Illes

Have you tried - File , Export → Structured text ?

If this does not “work” you probably need a bit of LS.

ozNotes.NET

3

Subject: RE: export 500 x 200 emails into csv

Hi,

Thanks. I may be entirely wrong here… but I can see only the following export formats: ASCII text, CGM Image, Microsoft RTF, TIFF 5.0 Image.

Where can I find ‘Structured text’ ?

Is there a CSV export option ?

Thanks again,

Illes

4

Subject: Export entire database rather that a single document

The options you’ve mentioned apply for a single note. Export formats for entire database are different.

5

Subject: Re: Export entire database rather that a single document

Thanks.

Do you happen to know, if it’s possible to use a different field separator (instead of the comma) ? Many fields in my database contain a comma.

Thank you for your help in advance.

6

Subject: What about ‘Structured Text’?

You can try ‘Structured Text’ option. The doc output has following structure:

  1. Item Name - Item Value pairs, separated by ": " (colon-space-space)

  2. Empty line

  3. Message Body

  4. Separator between docs Form-feed chr(12) or other arbitrary character

Parsing it from Perl would be a sheer pleasure :slight_smile:

7

Subject: Re: What about ‘Structured Text’?

Thanks a lot, that’s great for perl.

Do you happen to know, if it’s possible to replace the comma character separating the data items inside each field ?

In the structured text export for each pack of 200 emails the subject appears on a single “SUBJ: …” line, and the 200 subjects (themselves containing comma characters) are separated by the comma separator.

Thank you in advance again.