Notice: Constant DS already defined in /home/netamity/public_html/templates/meet_gavern/index.php on line 16
Netamity - Data Download 1.0
Main menu

Andy has been bad...

Recently, I have been rightfully reprimanded by users of my extensions about lack of updates to Data Download, Alphabetter and ContentedPDF. I have been overtaken with other work, but I appreciate your ongoing interest and will make good on my promises in May, when a new version (or first in the case of Alphabetter) will be released.

By way of apology, all users with an existing paid subscription can upgrade to the 12 month membership free by entering the coupon code 'EXTENDMYMEM' at the checkout- you'll bypass Paypal and be upgraded instantly. Any new people wishing to subscribe should sign up the Be Contented For A Week option, paying their subscription and then they'll be able to make use of this free upgrade without further payment. Hope that makes things better

Stick with me guys, I'm still really keen on getting these to you- I've just been swamped!


Strict Standards: Only variables should be assigned by reference in /home/netamity/public_html/plugins/content/contented_accessText/contented_accessText.php on line 27

Strict Standards: Only variables should be assigned by reference in /home/netamity/public_html/plugins/content/contented_accessText/contented_accessText.php on line 28

Strict Standards: Only variables should be assigned by reference in /home/netamity/public_html/plugins/content/contented_accessText/contented_accessText.php on line 27

Strict Standards: Only variables should be assigned by reference in /home/netamity/public_html/plugins/content/contented_accessText/contented_accessText.php on line 28

Strict Standards: Only variables should be assigned by reference in /home/netamity/public_html/plugins/content/contented_pdf/contented_pdf.php on line 44

Strict Standards: Only variables should be assigned by reference in /home/netamity/public_html/plugins/content/contented_pdf/contented_pdf.php on line 44

Strict Standards: Only variables should be assigned by reference in /home/netamity/public_html/plugins/content/contented_accessText/contented_accessText.php on line 27

Strict Standards: Only variables should be assigned by reference in /home/netamity/public_html/plugins/content/contented_accessText/contented_accessText.php on line 28

Data Download 1.0

Rate this item
(8 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 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:

    SELECT ID,NAME,USERNAME,EMAIL,REGISTERDATE
    FROM #__users

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

    SELECT ID,NAME,USERNAME,EMAIL,REGISTERDATE
    FROM #__users
    WHERE #__users.id = #__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

    Hello,
    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.