I would like to propose a small feature to allow text export of
selected results. Output document could help to make quick analysis
and statistics on metadata records in a spreadsheet for example.
The complete proposal is available here [1] and patch here [2].
If motion pass, this new feature will be added to GeoNetwork trunk
(for 2.5 release).
There is just a small "hic" with this export (experienced it myself in geocat.ch):
If there is a ";" in the abstract or elsewhere in an attribute, then the spreadsheet is "messed up". Could you use another separator, that is more unlikely to be used (e.g. a tabulator)?
Thanks
Annina
-----Ursprüngliche Nachricht-----
Von: Francois Prunayre [mailto:fx.prunayre@anonymised.com]
Gesendet: Dienstag, 2. März 2010 10:37
An: Devel geonetwork-devel@lists.sourceforge.net
Betreff: [GeoNetwork-devel] Proposal to add text export of selected results
Dear PSC members,
I would like to propose a small feature to allow text export of selected results. Output document could help to make quick analysis and statistics on metadata records in a spreadsheet for example.
The complete proposal is available here [1] and patch here [2].
If motion pass, this new feature will be added to GeoNetwork trunk (for 2.5 release).
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________
GeoNetwork-devel mailing list GeoNetwork-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
There is just a small "hic" with this export (experienced it myself in geocat.ch):
If there is a ";" in the abstract or elsewhere in an attribute, then the spreadsheet is "messed up". Could you use another separator, that is more unlikely to be used (e.g. a tabulator)?
True, but you could easily change that separator
Instead of
<xsl:variable name="sep" select="';'"/>
use
<xsl:variable name="sep" select="'	'"/>
for a tab separator. I will add a comment to the patch.
But the problem remains if you have tabs in the abstract ...
Thanks for your comment.
Francois
Thanks
Annina
-----Ursprüngliche Nachricht-----
Von: Francois Prunayre [mailto:fx.prunayre@anonymised.com]
Gesendet: Dienstag, 2. März 2010 10:37
An: Devel geonetwork-devel@lists.sourceforge.net
Betreff: [GeoNetwork-devel] Proposal to add text export of selected results
Dear PSC members,
I would like to propose a small feature to allow text export of selected results. Output document could help to make quick analysis and statistics on metadata records in a spreadsheet for example.
The complete proposal is available here [1] and patch here [2].
If motion pass, this new feature will be added to GeoNetwork trunk (for 2.5 release).
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________
GeoNetwork-devel mailing list GeoNetwork-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
I think this is a problem we always face when exporting/importing through CSV. That is also why a program like Excel will allow you to use different separators, put text within quotes etc.. Hard to avoid.
There is just a small "hic" with this export (experienced it myself in geocat.ch):
If there is a ";" in the abstract or elsewhere in an attribute, then the spreadsheet is "messed up". Could you use another separator, that is more unlikely to be used (e.g. a tabulator)?
True, but you could easily change that separator
Instead of
<xsl:variable name="sep" select="';'"/>
use
<xsl:variable name="sep" select="'	'"/>
for a tab separator. I will add a comment to the patch.
But the problem remains if you have tabs in the abstract ...
Thanks for your comment.
Francois
Thanks
Annina
-----Ursprüngliche Nachricht-----
Von: Francois Prunayre [mailto:fx.prunayre@anonymised.com]
Gesendet: Dienstag, 2. März 2010 10:37
An: Devel geonetwork-devel@lists.sourceforge.net
Betreff: [GeoNetwork-devel] Proposal to add text export of selected results
Dear PSC members,
I would like to propose a small feature to allow text export of selected results. Output document could help to make quick analysis and statistics on metadata records in a spreadsheet for example.
The complete proposal is available here [1] and patch here [2].
If motion pass, this new feature will be added to GeoNetwork trunk (for 2.5 release).
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________
GeoNetwork-devel mailing list GeoNetwork-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Alle 13:31:05 di giovedì 4 marzo 2010, Jeroen Ticheler ha scritto:
I think this is a problem we always face when exporting/importing through
CSV. That is also why a program like Excel will allow you to use different
separators, put text within quotes etc.. Hard to avoid.
+1 from me, nice small additional functionality.
Ciao,
Jeroen
On 3 mrt 2010, at 17:08, Francois Prunayre wrote:
> Hello Annina,
>
> 2010/3/3 Hirschi-Wyss Annina LT <Annina.Hirschi-Wyss@anonymised.com>:
>> There is just a small "hic" with this export (experienced it myself in
>> geocat.ch): If there is a ";" in the abstract or elsewhere in an
>> attribute, then the spreadsheet is "messed up". Could you use another
>> separator, that is more unlikely to be used (e.g. a tabulator)?
>
> True, but you could easily change that separator
> Instead of
> <xsl:variable name="sep" select="';'"/>
> use
> <xsl:variable name="sep" select="'	'"/>
> for a tab separator. I will add a comment to the patch.
>
> But the problem remains if you have tabs in the abstract ...
>
> Thanks for your comment.
>
> Francois
>
>> Thanks
>> Annina
>>
>> -----Ursprüngliche Nachricht-----
>> Von: Francois Prunayre [mailto:fx.prunayre@anonymised.com]
>> Gesendet: Dienstag, 2. März 2010 10:37
>> An: Devel geonetwork-devel@lists.sourceforge.net
>> Betreff: [GeoNetwork-devel] Proposal to add text export of selected
>> results
>>
>>
>> Dear PSC members,
>>
>> I would like to propose a small feature to allow text export of selected
>> results. Output document could help to make quick analysis and
>> statistics on metadata records in a spreadsheet for example.
>>
>> The complete proposal is available here [1] and patch here [2].
>>
>> If motion pass, this new feature will be added to GeoNetwork trunk (for
>> 2.5 release).
>>
>> Looking forward to your votes, Regards.
>>
>> Francois
>>
>> [1] http://trac.osgeo.org/geonetwork/wiki/CSVExport
>> [2] http://trac.osgeo.org/geonetwork/attachment/wiki/CSVExport/csv.patch
>>
>> ------------------------------------------------------------------------
>>------ Download Intel® Parallel Studio Eval
>> Try the new software tools for yourself. Speed compiling, find bugs
>> proactively, and fine-tune applications for parallel performance. See
>> why Intel Parallel Studio got high marks during beta.
>> http://p.sf.net/sfu/intel-sw-dev
>> _______________________________________________ GeoNetwork-devel mailing
>> list GeoNetwork-devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
>> GeoNetwork OpenSource is maintained at
>> http://sourceforge.net/projects/geonetwork
>
> -------------------------------------------------------------------------
>----- Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> GeoNetwork-devel mailing list
> GeoNetwork-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
> GeoNetwork OpenSource is maintained at
> http://sourceforge.net/projects/geonetwork
---------------------------------------------------------------------------
--- Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
+1 also from me (I realize its already been added :-)).
Cheers,
Simon
Francois Prunayre wrote:
Dear PSC members,
I would like to propose a small feature to allow text export of
selected results. Output document could help to make quick analysis
and statistics on metadata records in a spreadsheet for example.
The complete proposal is available here [1] and patch here [2].
If motion pass, this new feature will be added to GeoNetwork trunk
(for 2.5 release).
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net geonetwork-devel List Signup and Options
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork