Forums

Download csv

webcrea 13 Feb, 2019
Hi,

When i use download csv
Data providr = {var:read_enrollments_export}

i see in excel

enrollment | ID | First name | Last name
Array
Array
Array
Array
Array

enrollment is the model name in the read_data
it seams to find array where it should find value...

debug:
Array
(
    [read_enrollments_export] => Array
        (
            [log] => Array
                (
                    [0] => SELECT `enrollment`.`id` AS `enrollment.id`, `enrollment`.`student_first_name` AS `enrollment.student_first_name`, `enrollment`.`student_last_name` AS `enrollment.student_last_name` FROM `skf0d_admincrm_enrollments` AS `enrollment` WHERE `enrollment`.`sessions_id` = '290' LIMIT 100;
                )

            [var] => Array
                (
                    [0] => Array
                        (
                            [enrollment] => Array
                                (
                                    [id] => 3187
                                    [student_first_name] => Liying
                                    [student_last_name] => An
                                )

                        )

                    [1] => Array
                        (
                            [enrollment] => Array
                                (
                                    [id] => 3188
                                    [student_first_name] => Zhen
                                    [student_last_name] => Chao
                                )

                        )

                    [2] => Array
                        (
                            [enrollment] => Array
                                (
                                    [id] => 3189
                                    [student_first_name] => An Qi
                                    [student_last_name] => Xie
                                )
etc...

there are 5 line matches the count, it's ok.

Thanks
webcrea 14 Feb, 2019
Thanks for your help

Store file doesn't work, i have an error
Error saving the csv file.

The path exists, directory in 777
{path:front}/uploads/enrollments/enrollments_export.csv

Do you have any idea ?
Regards
healyhatman 14 Feb, 2019
Shouldn't it be 755? 777 is a bit too permissive right?

But I don't know what the deal is sorry. Just tested it and it works for me, so probably just make sure the folders actually exist.
webcrea 14 Feb, 2019
Answer
Don't use {path:front}
With the real path it works...
Thanks
This topic is locked and no more replies can be posted.