substitute for ssconvert from gnumeric

[AlSchedl]

Hello,

is there any possibility to use other tools than ssconvert from gnumeric to extract plain text from Excel-spreadsheet to feed the indexer ? I just ask, because installing gnumeric requires to install gnome - or at least a lot of libraries it depends on . I´d like to avoid the arising "dependency hell" on a production server.

VG
Alex

[steinm]

Hello,

is there any possibility to use other tools than ssconvert from gnumeric to extract plain text from Excel-spreadsheet to feed the indexer ? I just ask, because installing gnumeric requires to install gnome - or at least a lot of libraries it depends on . I´d like to avoid the arising "dependency hell" on a production server.

You could try xls2csv instead, but letodms 3.3.x doesn't allow to configure the converters. You have to modify the source code.

3.4.0 will have configuration options to set converters for all mimetypes.

Uwe

[AlSchedl]

Hello steimn,
thanks for your quick answer.
I changed Line 34 of /Lucene/IndexedDocument.php on from
'application/vnd.ms-excel' => 'ssconvert -T Gnumeric_stftf_csv -S %s fd://1',
to
'application/vnd.ms-excel' => 'xls2csv %s',

Anything else to modify ?

Regards,
AlSchedl

Hello,

is there any possibility to use other tools than ssconvert from gnumeric to extract plain text from Excel-spreadsheet to feed the indexer ? I just ask, because installing gnumeric requires to install gnome - or at least a lot of libraries it depends on . I´d like to avoid the arising "dependency hell" on a production server.

You could try xls2csv instead, but letodms 3.3.x doesn't allow to configure the converters. You have to modify the source code.

3.4.0 will have configuration options to set converters for all mimetypes.

Uwe

[steinm]

Hello steimn,
thanks for your quick answer.
I changed Line 34 of /Lucene/IndexedDocument.php on from
'application/vnd.ms-excel' => 'ssconvert -T Gnumeric_stftf_csv -S %s fd://1',
to
'application/vnd.ms-excel' => 'xls2csv %s',

Anything else to modify ?

That should be it. Just try it.

Uwe