Exporting excel/csv doc

[idpSteve]

Hi All.

I need to allow some of my users to export data from my app. The data they need to get out must include related objects. This would be OK if I didn't have multiple allowed objects that I need to export, but one of the related objects is a many to many relationship. I'd want to see something similar to the following:

Parent.Name, Parent.Surname, Parent.Child.Name, Parent.Child.Surname, Parent.Child.Name, Parent.Child.Surname, ...

When importing from a csv there is the option to map to a path. This doesn't exist for exporting.

Is my best option going to be making the csv string for each record manually and export only the attribute with the string in it? Would that even work?

Something like:

PROC1

Parent.csvString=Parent.Name+', '+Parent.Surname
FIND Child WHERE (Child IN Parent.Children)
PROC2

PROC2
Parent.csvString=Parent.csvString+', '+Child.Name+', '+Child.Surname

Really not ideal.. Any better solutions would be great.

[customaware]

Steve,

If you are ok concatenating X number of Children to the String then I would recommend using the LIST_LINE function which works perfectly for building this kind of string.

I am down in the Gobi Desert at the moment but have a crack at it and if you get stuck I will do a demo up for you once I get home later in the week.

[idpSteve]

Thanks, Mark.

I had forgotten about LIST_LINE. I was using LIST_TABLE in my excel template which works well if there aren't related fields.

I'll give it a go and see how I can use it, although I think I'll end up in the same place. LIST_LINE might be able to do something I don't know of.

I'll post here later today or tomorrow.

Thanks again!