Welcome, Guest
Username: Password: Remember me

TOPIC: Filter / Export to CSV

Filter / Export to CSV 19 Dec 2011 03:22 #733

  • iconvisual
  • iconvisual's Avatar
  • Offline
  • Senior Member
  • Keen Joomla! 1.7 Developer
  • Posts: 53
  • Thank you received: 5
  • Karma: 1
Hello,

I am desperate. Can we please have an ETA on the implementation of the Export Functionality which you have said exists, but is not yet enabled?

Thank you kindly!

Ed.
Keen Joomla! and PHP/MySQL developer. Excited about J-Cook.
The administrator has disabled public write access.

Filter / Export to CSV 19 Dec 2011 11:35 #736

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 987
  • Karma: 140
Well, I used Cook for personal uses to answer professional customers needs.
So I started to develop this functionality. Even Imports.
But both of them are not ready at all. Totally in standby for the moment.
It is not a question of simply enable or not.
I mean, it is not locked for a commercial strategy.
All functionalities present are all we have.

I will even propose some complex functionalities in beta, in order to let you enjoying before the final stability (Files and Images are coming soon, in beta)


Export is much more easy than import.

If you want to do this,
Create a new layout in the Builder. ('export' for example)
You can even use filters.
Compose the export layout adding all the joined datas. (It will create the SQL call)

Then, when you develop inside, don't show it.
In the view file, instead of displaying : parent:display()
Try to make a dump of you $items var, and you will find your beatifull array with all datas you need.

So.
In the helper maybe, create a function that convert such array in CSV.
You can, then, output the file with a application/force-download mime header, it will download it.
Maybe you can furnish to your function an added array to labelise the column, and to dispatch the fields
-> label
-> order
-> presence or not in export (because all columns of main table are selected in default query)
If you want to optimize the query for big table, you can also create, in the model, a new query profile.
If you write well, your export functionality will even be reusable for any export you want.

Really easy. Cook does 80% of the job. (even more)
Cannot help you more.
Coding is now a piece of cake
The administrator has disabled public write access.
The following user(s) said Thank You: kristianharmer

Re: Filter / Export to CSV 19 Oct 2012 13:51 #4681

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
  • Karma: 30
The administrator has disabled public write access.
Time to create page: 0.364 seconds

Get Started