Re: [Fez-developers] Excel and CSV

[Lachlan K. <l....@uq...>]

Hi Dr Keitch,

ŒExport to Excel¹ currently exists in trunk; it has superseded the old
ŒExport to CSV¹ option. I¹d suggest upgrading to trunk.

If you wanted to merge the functionality in manually, the pertinent code
seems to be in revisions 1973, 2109, 2111, 2236, and 3376.

Hope this is of some use.

Regards,
Lachlan
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lachlan Kuhn
Senior Web Developer
Library Technology Service
The University of Queensland, Australia QLD 4072
Telephone : (+61) (7) 3346 4349
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


On 21/10/10 10:45 PM, "bkeitch" <bk...@ph...> wrote:

> Dear developers,
> 
> I suspect you don't want to hear this, if like me, you've battled with MS and
> their non-compliance with RFCs. However, we are using FEX at the ETH in Zurich
> http://e-citations.ethbib.ethz.ch/
> 
> Our secretary would like to download the output as CSV so that is can open in
> Excel (!). Not being very computer literate this needs to be as simple as
> possible. However, the returned file is
> 
> export.csv.txt
> 
> with mime
> 
> text/csv
> 
> Now of course, you can associate the MIME with Excel. Sadly however, because
> the ending is not CSV this means that Excel does not run its import script.
> Ideally the ending would be simply CSV. That keeps dumb Excel happy and makes
> non-computer literate people happy too. I am running Mozilla/5.0 (Windows; U;
> Windows NT 6.1; en-US; rv:1.9.2.11) Gecko/20101012 Firefox/3.6.11 which is ETH
> policy. I don't think this is a function of the browser as my HTTP sniffer
> informs me:
> 
> Content-Disposition: attachment; filename=export.csv.txt
> Set-Cookie: *deleted*
> Keep-Alive: timeout=5, max=98
> Connection: Keep-Alive
> Transfer-Encoding: chunked
> Content-Type: text/csv
> 
> 
> Any chance you could change it? Or even add an Excel option, that is CSV but
> with .CSV extension and the Excel MIME type?
> 
>  
> 
> Thanks,
> 
>  
> 
> Dr. Ben Keitch
> 
>  
> 
>  
> 
> --
> 
> Trapped Ion Quantum Information Group
> Quantum Optics and Photonics
> Institute for Quantum Electronics
> ETH Zurich
> Schafmattstrasse 16 / HPF E10
> 8093 Zurich
> Tel. + 41 (0) 44 633 32 58
> Fax. + 41 (0) 44 633 10 56
> 
> 
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America contest
> Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> http://p.sf.net/sfu/nokia-dev2dev
> 
> _______________________________________________
> Fez-developers mailing list
> Fez...@li...
> https://lists.sourceforge.net/lists/listinfo/fez-developers



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Lachlan Kuhn
Senior Web Developer
Library Technology Service
The University of Queensland, Australia QLD 4072
Telephone : (+61) (7) 3346 4349
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~