Hi,
I have created a view with multiple data models and would like to download this combined data in a csv file.
My DB Read function is read_data having 2 data models Ind1 and Ind2. The combined relation gives me the required relevant report.
In my csv function, in the data provider field usually we would use {var:read_data.[n].Ind1} but I would like to include {var:read_data.[n].Ind2} also.
How to correctly represent the combined array?
I tried using both by filling the Data provider field as "{var:read_data.[n].Ind1}, {var:read_data.[n].Ind2}". This did'nt work.
Only the column titles are getting downloaded, the data is empty.
Please guide me on how to proceed further.
Thanks,
Anu
I have created a view with multiple data models and would like to download this combined data in a csv file.
My DB Read function is read_data having 2 data models Ind1 and Ind2. The combined relation gives me the required relevant report.
In my csv function, in the data provider field usually we would use {var:read_data.[n].Ind1} but I would like to include {var:read_data.[n].Ind2} also.
How to correctly represent the combined array?
I tried using both by filling the Data provider field as "{var:read_data.[n].Ind1}, {var:read_data.[n].Ind2}". This did'nt work.
Only the column titles are getting downloaded, the data is empty.
Please guide me on how to proceed further.
Thanks,
Anu
Hi
I was unable to find how to resolve this issue using ChronoConnectivity.
But for now I was able to work out a fix. Would be glad if any others have better solutions.
Instead of creating the DB table relations in Chronoconnectivity, I created the same as a view in my Database. I used the DB View as my Model and downloaded the CSV file.
Please feel free to provide any insights regarding this work around.
I would still love to know if this could be done using CC itself.
Thanks for an Awesome Extension.
Anu
I was unable to find how to resolve this issue using ChronoConnectivity.
But for now I was able to work out a fix. Would be glad if any others have better solutions.
Instead of creating the DB table relations in Chronoconnectivity, I created the same as a view in my Database. I used the DB View as my Model and downloaded the CSV file.
Please feel free to provide any insights regarding this work around.
I would still love to know if this could be done using CC itself.
Thanks for an Awesome Extension.
Anu
Hi Anu,
In this situation you will need someway to combine both datasets, which is not possible using shortcodes (yet), you could have done that using a PHP action before running the CSV to prepare the data list using code.
Best regards,
Max
In this situation you will need someway to combine both datasets, which is not possible using shortcodes (yet), you could have done that using a PHP action before running the CSV to prepare the data list using code.
Best regards,
Max
Hi Max
I was not clear of how exactly the PHP action has to be written, hence the query.
If you could give an example it would be extremely helpful.
Thanks
Anu
Hi Anu,
In this situation you will need someway to combine both datasets, which is not possible using shortcodes (yet), you could have done that using a PHP action before running the CSV to prepare the data list using code.
Best regards,
Max
I was not clear of how exactly the PHP action has to be written, hence the query.
If you could give an example it would be extremely helpful.
Thanks
Anu
This topic is locked and no more replies can be posted.
