Page 1 of 1

save csv only selected collumns

Posted: 2018-05-15 23:34
by D Oliveira
is there a way for the save csv button to only create collumns that are toggled to display?

Re: save csv only selected collumns

Posted: 2018-05-20 13:39
by R Tammam
Hello D Oliveira ,
there is a very helpful function in appgini tablename_csv you can find it in hooks/tablename.php, it has a query parameter
$query contains the query that will be executed to return the data in the CSV file.
you can find more about this function in the following link
http://bigprof.com/appgini/help/advance ... lename_csv

Re: save csv only selected collumns

Posted: 2018-05-23 21:01
by D Oliveira
can you please elaborate on that on how to get the query to import the toggled fields data?

Re: save csv only selected collumns

Posted: 2018-05-30 05:43
by R Tammam
if you mean by toggled fields something like that
https://www.screencast.com/t/ZshN7Acv

so the toggled fields are stored in a cookie here's a small screen cast elaborating how it's stored
https://www.screencast.com/t/hG935gY4tlWr
to access the cookies you will need $_COOKIE["name"] php variable , you can find the variable name in the coookie (in the screen cast)
you can use these variables of the cookie to build your query

i hope that idea would help you

Re: save csv only selected collumns

Posted: 2018-05-30 18:21
by D Oliveira
Is that a job u would be interested to get paid for developing? Really convenient way to generate payment sheets.

Re: save csv only selected collumns

Posted: 2018-06-05 00:39
by R Tammam
i will try to do it , and i will post the code here , but it might take more time

Re: save csv only selected collumns

Posted: 2018-06-05 15:32
by D Oliveira
take your time, really appreciate your help on this, this is a solid improvement for next release