[Claudiu]

Hi everyone,

I had to make a script lately that made me use the miva_output_header function. I wanted to share a small function that can be handy when someone wants to share files ( put files on download ) without making links.

I wrote an article here: http://mivascript.org/miva_script_fr...ad_script.html . Any comments welcomed...

PS: I promise i won't write a post for every function I share in the future but this one can be tricky...

Thank you
Claudiu

[Kent Multer]

Hey Claudiu, are you reading my mind? I've been thinking about exactly this subject recently; I need this download capability for a project I'm working on. You just saved me some hours of reading, experimenting, and head-scratching.

I miss Ivo's contributions around here, but you're a good substitute . Thanks --

[Claudiu]

Hi Kent

So glad it helps ! That's the big idea with the shared code You have no idea how much your book helped (and still helps) me... so I should thank you first

Thanks
Claudiu

[Claudiu]

While trying to find a way to create excel files on the fly, I found a dirty and ugly solution, that you can find here: http://mivascript.org/miva_script_create_excel.html

It's dirty, as we play with the header, and excel will see that the content of the file is not excel. But I'll try to find a solution for that matter too ...

Anyway, it's a good solution if you want to give the possibility to export excel file on Linux server, using Miva Script

Any comments welcomed !

[RayYates]

I've done something very similar for streaming live .csv and txt reports out as a download.

As for excel, I've output a .csv file this way.

<MvASSIGN NAME = "l.null" VALUE = "{ miva_output_header('Content-type', 'application/vnd.ms-excel') }">

Excel is offered as the default program during the download dialog box, and opens the file just fine.

A note about .csv files; you need to make sure any data that contains commas gets wrapped in double quotes.

[brian_77]

Hi Claudiu,

On this page http://mivascript.org/miva_script_fr...ad_script.html

there is code for force download not for create xls file.

>>THE CODE

You can see the code here: http://mivascript.org/share/scripts/...ownload.mv.txt

[Claudiu]

Hi Brian

Yes, indeed, the page is talking about forced download. The excel one is here: http://mivascript.org/miva_script_create_excel.html . I used the same link for the forum apparently

PS: Thanks Ray for your suggestion !

Best regards,
Claudiu

[BPS]

Hi,


I visited this link http://mivascript.org/miva_script_create_excel.html

but i only get code for the function force download.did not get function for create xls file.

[RayYates]

The example is creating the data and outputing the file at the same time, so no physical file is ever created.

By setting the headers you get the browser 'file download" dialog box and the contents are streamed to your hard disk instead of to the browser screen.

Using Toolbelt, you can even do this in a Storemorph page template. Use Query to get the data, then format it as a simple tab separated text file.

I've created custom data export screens for several clients this way.

[Claudiu]

Hi again,

Indeed, this way you cannot save the file, you can only stream it to the browser (and it's a very "amateur" approach with lots of inconvenient). I'll make the function to save the binary excel file this week and I'll post it here. I'll try to do it in mivascript (oh yes, it's possible) or in a C++ library (it's easier).

PS: I updated the excel page... You were right, I messed up the links and there was an example of the forced download, not the one with the excel file...

Cheers,
Claudiu