Print To; Save As; etc.

A place for users and developers of the Xataface to discuss and receive support.

Postby dwisn » Mon Jan 22, 2007 1:17 pm

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
dwisn
 
Posts: 25
Joined: Wed Dec 31, 1969 5:00 pm

Postby shannah » Mon Jan 22, 2007 3:19 pm

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
--
Steve Hannah
@shannah78 (on twitter)
sjhannah.com blog
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Postby shannah » Mon Jan 22, 2007 3:20 pm

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
--
Steve Hannah
@shannah78 (on twitter)
sjhannah.com blog
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Postby dwisn » Mon Jan 22, 2007 3:45 pm

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



Thanks - I'll give it the test. I had just downloaded 6.10

dan
dwisn
 
Posts: 25
Joined: Wed Dec 31, 1969 5:00 pm

Postby dwisn » Mon Jan 22, 2007 3:45 pm

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



Thanks - I'll give it the test. I had just downloaded 6.10

dan
dwisn
 
Posts: 25
Joined: Wed Dec 31, 1969 5:00 pm

Postby dwisn » Mon Jan 22, 2007 4:25 pm

>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
dwisn
 
Posts: 25
Joined: Wed Dec 31, 1969 5:00 pm

Postby dwisn » Mon Jan 22, 2007 4:35 pm



>
>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




GRRRRRRRRRRRRRRRRRRRRRRRRRRRRR:::: DAMN IE EXPORER........

Firefox... OK

Thanks again Steve... I will now look how ACtions work.. and start learning with this as a basis.

dan

dwisn
 
Posts: 25
Joined: Wed Dec 31, 1969 5:00 pm

Postby dwisn » Tue Jan 23, 2007 8:05 am

#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
dwisn
 
Posts: 25
Joined: Wed Dec 31, 1969 5:00 pm

Postby shannah » Tue Jan 23, 2007 12:31 pm

Wow... thanks for finding this fix... I can safely say that I never would have found that.

-Steve
--
Steve Hannah
@shannah78 (on twitter)
sjhannah.com blog
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Postby dwisn » Tue Jan 23, 2007 1:04 pm

The MS IE fix? Its official @ http://support.microsoft.com/kb/323308
dwisn
 
Posts: 25
Joined: Wed Dec 31, 1969 5:00 pm

Postby danny » Wed May 23, 2007 2:55 am

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
danny
 
Posts: 6
Joined: Wed Dec 31, 1969 5:00 pm

Postby shannah » Wed May 23, 2007 8:26 am

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]
category=table_actions

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
--
Steve Hannah
@shannah78 (on twitter)
sjhannah.com blog
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Postby danny » Thu May 24, 2007 12:59 am

Works perfectly! Thanx a lot, Steve.
I«m very curious about all the other features not documented yet
danny
 
Posts: 6
Joined: Wed Dec 31, 1969 5:00 pm

Postby danw » Tue Jul 21, 2009 7:20 am

dwisn wrote: #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



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
danw
 
Posts: 9
Joined: Wed Jan 02, 2008 8:32 am

Postby shannah » Tue Jul 21, 2009 12:01 pm

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
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 29 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved