This is an automated notification sent by LCG Savannah.
It relates to:
task #12232, project CDS Invenio
==============================================================================
LATEST MODIFICATIONS of task #12232:
==============================================================================
Follow-up Comment #3, task #12232 (project cdsware):
The decision to use HTML tags instead of csv was taken in order to overcome
this big restriction: csv does not let us have commas in column data. Another
delimiter could still be used, but then it should maybe not have a .csv
extension. HTML also has the nice side-effect of enabling the use of
formatted text (colors, face, links).
The name "Excel" was chosen because the main target for this export are
people who don't know what CSV mean. Still, "Excel-compatible", or "Tabular
data" would be more appropriate to avoid confusion and still please our
target audience.
A .csv format could still be added, as well as a .xlsx format.
==============================================================================
OVERVIEW of task #12232:
==============================================================================
URL:
<http://savannah.cern.ch/task/?12232>
Summary: CDS Excel output format produces invalid HTML, not
Excel files
Project: CDS Invenio
Submitted by: vengmark
Submitted on: 2009-10-30 08:13
Should Start On: 2009-10-29 00:00
Should be Finished on: 2009-10-29 00:00
Category: WebSearch
Priority: 5 - Normal
Status: Invalid
Privacy: Public
Percent Complete: 0%
Assigned to: None
Open/Closed: Open
Discussion Lock: Any
Effort: 0.00
_______________________________________________________
How to reproduce:
1. Do a search in CDS, e.g.
<http://cdsweb.cern.ch/search?cc=Books+%26+Proceedings&ot=020&ot=970&ln=en&p=020%3A'1->z'&f=&action_search=Search&c=Books+%26+Proceedings&c=&sf=&so=d&rm=&rg=10&sc=0&of=hx>.
2. Set "Output format" to "Excel"
3. Click "Search"
4. Save result.xls to disk
The resulting file is not an Excel file, and should therefore not have the
extension .xls. It is also not an HTML file, first because it's missing the
<html>, <head>, <title>, and <body> tags, and second because it's not valid
according to the W3C validator <http://validator.w3.org/>, even after adding
those tags.
_______________________________________________________
Follow-up Comments:
-------------------------------------------------------
Date: 2009-10-30 10:34 By: Jerome Caffaro <jcaffaro>
The decision to use HTML tags instead of csv was taken in order to overcome
this big restriction: csv does not let us have commas in column data. Another
delimiter could still be used, but then it should maybe not have a .csv
extension. HTML also has the nice side-effect of enabling the use of
formatted text (colors, face, links).
The name "Excel" was chosen because the main target for this export are
people who don't know what CSV mean. Still, "Excel-compatible", or "Tabular
data" would be more appropriate to avoid confusion and still please our
target audience.
A .csv format could still be added, as well as a .xlsx format.
-------------------------------------------------------
Date: 2009-10-30 10:18 By: Victor Engmark <vengmark>
Even though it can be imported into Excel, it's not at all an XLS file, and
should not be named as such. CSV would be much better, since it would have
179 characters less per line (HTML tr/td), 83 characters less per file (HTML
start/end) of output, and would be supported by just about any spreadsheet
application under the sky.
Regarding the restrictions, I'm not sure valign, border-color, border-style
and border-width are really necessary for nice output.
-------------------------------------------------------
Date: 2009-10-30 08:36 By: Jerome Caffaro <jcaffaro>
"Excel" output is in fact an "Excel-compatible" output, that is an output
that can be transposed to an Excel stylesheet (unless we do an .xslx output,
we cannot produce a real Excel output AFAIK).
The output has been reported to be incompatible with Apple "Numbers"
application, and must be correctly imported into OpenOffice "Calc"
application.
For a less surprising results for non-Windows users, we could go to a comma,
tab or space delimited output, with all the consequent restrictions.
See task #3493
_______________________________________________________
Carbon-Copy List:
CC Address | Comment
------------------------------------+-----------------------------
2407 | -COM-
3964 | -SUB-
==============================================================================
This item URL is:
<http://savannah.cern.ch/task/?12232>
_______________________________________________
Message sent via/by LCG Savannah
http://savannah.cern.ch/
