Export joined tables to CSV

Hello,

is there some step-by-step instruction on how to export 2 joined tables as one CSV file using Chronoforms? I'm trying to attempt to export the CB xx_comprofiler table joined with the xx_users table. I tried many ways but got a little stuck.

Can anybody offer some setp-by-step instructions on how to create a form using the advanced wizard ?

Many thanks in advance,

Erik

Hi Erik,

I'm not sure if you can :-( Maybe creating a View would make it straightforward.

Otherwise you could use a pair of linked FB Multi-Record Loaders to get the data and then hand-code the export.

Bob

Hi Bob,

I don't thhink the view is going to make it easier for me as the xxx_comprofiler table definition is prone to alterations. What about this 'pair of linked FB Multi-Record Loaders' and handcoding the export, can you elaborate on that ? The latter part doesn't seem a big problem for me, but I do not get how the multi-record loader works, let alone how to create 2 and then link them...😟

Thanks in advance,

Erik

Hi Erik,

It's been a long while but there is now a FAQ about this, please see this FAQ.

Bob