Page 1 of 1

export notes in csv :?:

Posted: 08 Jun 2007, 20:55
by myrme
I've got some users wanting to export the notes in the csv running 1.06. I already added an override function to include all custom fields in csv from vboctors blog.

Looks to me like notes are in their own table with id's? so this isn't so simple or is it?

Posted: 09 Jun 2007, 21:29
by vboctor
There are several issues with including the notes:

1. There are several notes per issue.
2. Notes are multi-line.
3. Notes have there own fields like submit date, last update date, etc. These sometimes conflict with similar fields in the issue.

The possible way to go around this would be:

- Support another csv format which starts by a field type.
- Output a row of type issue, followed by N rows of type notes. In the future more row types can be added (e.g. sponsorships, users monitoring, etc).
- Encode the notes body so that they are not multi-line and they don't include the csv separator.

If someone is interested in implementing this, then I wouldn't mind working with him/her on the design and integrating it into Mantis.

Re: export notes in csv :?:

Posted: 26 Nov 2007, 16:44
by ana
Hi,

regarding this one : "Encode the notes body so that they are not multi-line and they don't include the csv separator. "

The case is - I am looking for a way to add 'description' filed (which is multi-line) to csv-export. Do you think that the encoding you've mentioned above might help me to achieve the target?
If yes - would you please kindly guide me how to do it ?

Thanks in advance
Ana