Data download simplifies the export of database table data from your site into CSV format to be used in other places.
DataDownload is in its first version, but we have more features planned, including:
Please get in touch to tell us what you think, and don't forget to leave a review on the Joomla Extension Directory here
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):
This issue will of course be fixed in the next release, due 24th March.
Go to: Data Download Support forum
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.
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.
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.
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.
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
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.
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?
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!
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?
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. ;-)
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!
Make sure you enter the (*) required information where indicated. HTML code is not allowed.