Netamity - Data Download 1.0

Data Download 1.0

Add to PDF Report

font size decrease font size increase font size
15 comments

Rate this item

(5 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):

Create a new dataset query in the DataDownload admin panel as you normally would
Use the query: alter table #__datadownload_datasets change field_titles field_titles Longtext;
Give the query a title, and the rest of the settings are not required. Save.
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
Refresh the field titles in the dataset that was missing titles and it should do the job
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

Download link: Download
Extension name: com_datadownload
Compatibility: Joomla 1.6/1.7, Joomla 2.5

Add to PDF Report

15 comments

Comment Link 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 Tuesday, 29 January 2013 05:18 posted by Jiesot
Hi
Thanks for this extension.
While the Query wizard is ready could you tell my how to exclude some table fileds from the return data?
I dont know hoe to write the code next to:
SELECT * from #__content where category= 'axions'

Sure, rather than using '*', just comma separate the fields you need. You'll need to use the catid rather than the category name, so something like:

SELECT id,title,introtext from #__content where catid= 2 would work (Assuming 'axions' is category 2 - check this in your category manager)
Comment Link Sunday, 20 January 2013 08:43 posted by Ralph
Dear Sirs, great extension idea! Question: do you plan to issue a Joomla 3 compatible version in due course? Looking forward to your reply. Regards, Ralph
Comment Link 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 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