Main menu

Data Download 1.0

Rate this item
(9 votes)

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

Features:

  • 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: alter table #__datadownload_datasets change field_titles field_titles Longtext;
  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

13 comments

  • Comment Link Machiel Friday, 26 April 2013 14:29 posted by Machiel

    Any news on the 2.0 version of datadownload. In the old forum 15th of april was set as release date.
    Would like to see the user access control and query wizard.
    Andy: It's coming, honest, still working on it when I have time (paid work has to take priority you understand). I'd rather not make any more broken promises, but suffice to say I know many people are waiting on it and it is coming along.

  • Comment Link Alberto Thursday, 04 April 2013 15:04 posted by Alberto

    Hi andy, thank you for this extension, but dunno if it fits my needs. I'm trying to use JOIN to export both the "users" table and "user_profile" in one file, keeping in relation the columns "id" and "user_id".
    I'm not very skilled in programming (just marckup), but i make DataDownload works just selecting from one table.
    Is it possible to extract data from more then one table?
    Thank you very much.
    P.s. I wrote here because i can't register for login in the support forum.

    Andy: Yes, joins are possible. You can perform whatever query you like to join the two (or more) tables. Could you let me know the issue with registering? I've not had any reports with issues, but I'd like to know if there is a problem. Cheers.

  • Comment Link Pete Tuesday, 02 April 2013 22:28 posted by Pete

    Hi - This component does need access levels (groups) added imho - its works great, but being able to copy the url, and then use it from the front end with no security is a definite issue for my site.. Thanks :)

    Just adding the default Joomla groups code should do the trick.. I would plan to set my exports to Administrator, or a custom variant of Admin / Super Admin.

  • Comment Link Jos Blokdijk Wednesday, 20 March 2013 16:39 posted by Jos Blokdijk

    Andy, could you give us an update about the expected release date of the new version?
    Andy:It's a week off I'm afraid. Flat out at the moment! Will contact you personally when I have something for you. I appreciate the interest.

  • Comment Link Jos Saturday, 02 March 2013 15:07 posted by Jos

    Yes, I think that will do the job!
    Andy: I'll get that in the next phase. I'll let you know when it's released

  • Comment Link Jos Friday, 01 March 2013 10:31 posted by Jos

    Hi,

    is there a way to passwordprotect the downloads? The url is unique and not easy to guess, but i would like te make an extra security measure.

    Hi Jos,
    I always imagined the hashcode on the URL would provide adequate protection, but perhaps more security could be added. The best I can think to do this is to set an access level ('admins') to running the URL. Would that do the job?

  • Comment Link Jos Tuesday, 12 February 2013 07:47 posted by Jos

    Hi, i did some other tests and i'm really impressed by the ease of use of your component.

    I keep one issue though, in the export file are 14 field labels but i've got 58 different fields in the table. Is there a way to solve this?

    Keep up the good work!

    Best regards, Jos

    Send me the query you're having an issue with and I'll investigate. It's probably a parse error being caused by field names, but I'll get to the bottom of it. New version due out in a week!

  • Comment Link Jos Monday, 11 February 2013 19:41 posted by Jos

    Hi, is there a limit in the field labels? When i make a datadump it works ok all data is exported, but not all fieldlabels are generated?

  • Comment Link Andrea Pluhar Saturday, 02 February 2013 19:22 posted by Andrea Pluhar

    Hi Andy, I've been trying to use your contact form but reCAPTCHA keeps telling me I've got it wrong. ??

    I've datadownload on two sites but I'm having trouble with it. It may be my query, since the sample query is working fine. Mine looks like this:

    SELECT EventName,EventStartDate,EventEndDate,EventDescription,EventURL,EventEmail,EventPhone FROM #_rsevents_events WHERE EventStartDate> 1357059600

    This creates a file I can download, but there's nothing in the file but an error message. To wit:

    Warning: Invalid argument supplied for foreach() in /home/wellflee/public_html/components/com_datadownload/models/getcsv.php on line 53

    The same query worked like a dream locally, btw. Maybe the remote server is using a different sql version, so it doesn't understand my query? This is all new to me. Could you help me out?

    I appreciate your time- and i love this extension! It's really brilliant. ;-)

  • Comment Link Andrea Friday, 01 February 2013 22:29 posted by Andrea

    Thanks, Andy. That's good to know. I'll be using this on a regular basis to export events from one calendar and import them into another. It's going to make my life peachy easy!

Leave a comment

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