Main menu

Data Download 1.0

Rate this item
(10 votes)

Data download simplifies the export of database table data from your site into CSV format to be used in other places.


  • Simple, standard Joomla install (no hacks, no overrides)
  • Simple admin interface
  • Field label generator
  • File date and name options
  • Quick download from admin or create front end menu item
  • Hash check in URL to protect from unauthorized access

DataDownload is in its first version, but we have more features planned, including:

  • Query wizard for beginners or custom queries for the more advanced
  • Query validity checker
  • More file export options (xls, sql,...)
  • Query generators for Virtuemart, HikaShop, RedShop, and other data-critical components
  • Download logs to track exports

Please get in touch to tell us what you think, and don't forget to leave a review on the Joomla Extension Directory here

Bugfix: Optional-

If you have an export with a lot of fields and the component is not generating all of your field labels properly, you can actually use the component to fix the component (which I think is quite clever):

  1. Create a new dataset query in the DataDownload admin panel as you normally would
  2. Use the query: This email address is being protected from spambots. You need JavaScript enabled to view it.
  3. Give the query a title, and the rest of the settings are not required. Save.
  4. Click on the link in the admin panel to download the csv- it'll be empty/useless, but you need to do this to run the table update
  5. Refresh the field titles in the dataset that was missing titles and it should do the job
  6. If successful you can remove the query. If it doesn't work, get in touch

This issue will of course be fixed in the next release, due 24th March.

Go to: Data Download Support forum

Additional Info

  • Extension name: com_datadownload
  • Compatibility: Joomla 1.6/1.7, Joomla 2.5
Your clomid cost per pill doctor may do certain tests to.
Phosphatidylserine modulates the fluidity phenergan online uk of cell.


  • Comment Link Andrea Pluhar Thursday, 31 January 2013 15:25 posted by Andrea Pluhar

    This is a great idea, and exactly what I need. I gather the query wizard doesn't work for me because it's not quite done yet? So while the query wizard isn't functional a dweeb like me can't really use it since I haven't a clue how to write the query I need. Any chance this will be usable soon?

    Yes, the wizard will be released on the 17th of Feb. You will be able to upgrade then. Andy

  • Comment Link Cody Sunday, 13 January 2013 05:41 posted by Cody

    Works great. I'm new to joomla and sql.

    I figured out how to download user information like:

    FROM #__users

    But couldn't figure out how to get user information for users from a certain group. I tried something like:

    FROM #__users
    WHERE = #__user_usergroup_map.user_id
    AND #__user_usergroup_map.user_group = 12

    But that doesn't work. Can you send me the sql needed to select users from a certain group?
    thank you.

  • Comment Link william white Thursday, 10 January 2013 12:38 posted by william white

    searching for your contact info. Left a request on skype to andy.hicky1
    my skype name is wmjwhitejr, please look me up when you have time

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.