Print To; Save As; etc.
15 posts
• Page 1 of 1
before I go hacking my way through SQL, and since I haven't found any code in the forums ( at least where/what I have searched on ):
Does anyone have any code for Saving the output of "found records" into a file of any sort? I know Dadabik has an "Export to CSV", just wondered if anyone has written anything - In advance, I thank you - dan
Hi Dan,
People have been asking for this one for a while and its so easy to do, so I thought I'd just whip it up. Download the new release of Dataface 0.6.11 at http://sourceforge.net/project/showfiles.php?group_id=153729&package_id=170571&release_id=480550 If you don't want to have to upgrade the whole thing, you could actually just copy the actions.ini file and the actions/export_csv.php file into your dataface distribution and it should work ok. Only tested on PHP 5 so far. -Steve
Oh.. yeah..
The way it works is: In the List view and related records list view, you'll notice a little icon that looks like a spread sheet in the upper right corner of the result set. Click on that to export the results to CSV format. Best regards Steve
Hi Dan, Thanks - I'll give it the test. I had just downloaded 6.10 dan
Hi Dan, Thanks - I'll give it the test. I had just downloaded 6.10 dan
>If you don't want to have to upgrade the whole thing, you could actually just copy the actions.ini file and the actionsexport_csv.php file into your dataface distribution and it should work ok.
1 ( one) error in export_csv.php TOP line missing an "f" if ( !function_exists('putcsv') ){ should be if ( !function_exists('fputcsv') ){ ( I think ) Though now I'm getting: Fatal error: Class 'actions_find' not found in ~/dataface-0.6.11/Dataface/Application.php on line 763 trying to work through it dan
#1 ) Thanks again Steve, you saved my butt
#2 ) I promise, I'll start learning framework.... &3 ) For anyone having issues using MS IE and trying to download across SSL and having problems... I found a fix that works... For a per-computer setting, locate the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings On the Edit menu, click Add Value, and then add the following registry values: "BypassSSLNoCacheCheck"=Dword:00000001 PER USER SETTING HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings "BypassSSLNoCacheCheck"=Dword:00000001
The MS IE fix? Its official @ http://support.microsoft.com/kb/323308
Hi Steve,
just was wondering if there«s an export function too. But found the solution (just like so many more before) on your site. It«s awesome how one person is managing such an impressive support! Thanx a lot! But one suggestion about this feature (export): I believe it would be better placed beside the import-action (in the actions row). Why "hide" such a useful function... Daniel
Hi Daniel, You an move the export function to be beside the import function by adding the following to your application's actions.ini file (if you're using Dataface 0.7) [export_csv > export_csv] What this does is override the export_csv action to be in the "table_actions" category.Ê The "category" is what dataface uses to know where to display different actions. Best regards steve
I HAVE AN UPDATE.. TESTED ACROSS SSL XP ServicePack 3 07/19/2009 In ~/actions file export_csv.php current lines: header("Content-type: text/csv; charset={$app->_conf['oe']}"); header('Content-disposition: attachment; filename="'.$query['-table'].'_results_'.date('Y_m_d_H_i_s').'.csv"'); add: header("Content-type: text/csv; charset={$app->_conf['oe']}"); header("Pragma: public"); header('Content-disposition: attachment; filename="'.$query['-table'].'_results_'.date('Y_m_d_H_i_s').'.csv"'); and this solved the issue. you should not have to edit within regedit
Thanks for the tip. I have added this to the issue tracker so that it will be fixed when I get a chance.
http://bugs.weblite.ca/view.php?id=562 -Steve
15 posts
• Page 1 of 1
Who is onlineUsers browsing this forum: No registered users and 29 guests |