LetoDMS Community Forum
substitute for ssconvert from gnumeric - Printable Version

+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: Technical Support (https://community.letodms.com/forumdisplay.php?fid=10)
+--- Thread: substitute for ssconvert from gnumeric (/showthread.php?tid=532)



substitute for ssconvert from gnumeric - AlSchedl - 07-19-2012

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


RE: substitute for ssconvert from gnumeric - steinm - 07-19-2012

(07-19-2012, 04:59 PM)AlSchedl Wrote: 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


RE: substitute for ssconvert from gnumeric - AlSchedl - 07-23-2012

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

Anything else to modify ?

Regards,
AlSchedl


(07-19-2012, 07:48 PM)steinm Wrote:
(07-19-2012, 04:59 PM)AlSchedl Wrote: 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




RE: substitute for ssconvert from gnumeric - steinm - 07-23-2012

(07-23-2012, 12:10 PM)AlSchedl Wrote: Hello steimn,
thanks for your quick answer.
I changed Line 34 of /Lucene/IndexedDocument.php on from
'application/vnd.ms-excel' => 'ssconvert -T Gnumeric_stfConfusedtf_csv -S %s fd://1',
to
'application/vnd.ms-excel' => 'xls2csv %s',

Anything else to modify ?

That should be it. Just try it.

Uwe