xls2csv doesnt like me!

brew · 03-29-2004, 08:33 PM

heyas - great little engine guys , installed her in minutes and after some tinkering i have both pdf and doc files getting indexed!

but for the life of me i cant get xls files to work. im using linux (suse9) and checked the file permissions on the relevant dirs ...

define('PHPDIG_INDEX_MSWORD',true);
define('PHPDIG_PARSE_MSWORD','/usr/local/bin/catdoc');
define('PHPDIG_OPTION_MSWORD','-s 8859-1');

define('PHPDIG_INDEX_PDF',true);
define('PHPDIG_PARSE_PDF','/usr/bin/pdftotext');
define('PHPDIG_OPTION_PDF','');
define('PHPDIG_PDF_EXTENSION','.txt');

define('PHPDIG_INDEX_MSEXCEL',true);
define('PHPDIG_PARSE_MSEXCEL','/usr/local/bin/xls2csv');
define('PHPDIG_OPTION_MSEXCEL','');
define('PHPDIG_MSEXCEL_EXTENSION','');

and i have managed to get results out of the cmd for xls2csv:

/usr/local/bin/xls2csv test.xls

"About",,"Choose",,"Study",,"International",,,"Business",,"Alumni",,"Jobs", ,"Contact"

so i know its physically working on the server. anyone offer any help? would be great to get xls files as well as pdf/doc ones.

Charter · 03-29-2004, 08:51 PM

Hi. Uncomment //print $answer."<br>\n"; in robot_functions.php and check the content type when PhpDig hits an XLS file, and then look for the following line in robot_functions.php and check whether the content type matches vnd.ms-excel or msexcel and if the latter try modifying the following line:

PHP Code:


			
else if ($regs[2] == 'vnd.ms-excel' && PHPDIG_INDEX_MSEXCEL == true) {

brew · 03-29-2004, 09:10 PM

fixed! okay heres the low down ...

im using apache2 and it seems the default mime.type for xls files is now application/excel (so i got it working by commenting out this line in my mime.types file in apache config dir and added one for application/vnd.ms-excel

you might want to add this extra application/excel in the next release of phpdig - given more and more users will be on apache2

thanks for your prompt help

03-29-2004, 08:33 PM	#1
brew Green Mole Join Date: Mar 2004 Posts: 2	xls2csv doesnt like me! heyas - great little engine guys , installed her in minutes and after some tinkering i have both pdf and doc files getting indexed! but for the life of me i cant get xls files to work. im using linux (suse9) and checked the file permissions on the relevant dirs ... define('PHPDIG_INDEX_MSWORD',true); define('PHPDIG_PARSE_MSWORD','/usr/local/bin/catdoc'); define('PHPDIG_OPTION_MSWORD','-s 8859-1'); define('PHPDIG_INDEX_PDF',true); define('PHPDIG_PARSE_PDF','/usr/bin/pdftotext'); define('PHPDIG_OPTION_PDF',''); define('PHPDIG_PDF_EXTENSION','.txt'); define('PHPDIG_INDEX_MSEXCEL',true); define('PHPDIG_PARSE_MSEXCEL','/usr/local/bin/xls2csv'); define('PHPDIG_OPTION_MSEXCEL',''); define('PHPDIG_MSEXCEL_EXTENSION',''); and i have managed to get results out of the cmd for xls2csv: /usr/local/bin/xls2csv test.xls "About",,"Choose",,"Study",,"International",,,"Business",,"Alumni",,"Jobs", ,"Contact" so i know its physically working on the server. anyone offer any help? would be great to get xls files as well as pdf/doc ones.

03-29-2004, 08:51 PM	#2
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hi. Uncomment //print $answer."<br>\n"; in robot_functions.php and check the content type when PhpDig hits an XLS file, and then look for the following line in robot_functions.php and check whether the content type matches vnd.ms-excel or msexcel and if the latter try modifying the following line: PHP Code: `else if ($regs[2] == 'vnd.ms-excel' && PHPDIG_INDEX_MSEXCEL == true) {` __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
catdoc catppt xls2csv problems PLEASE HELP	navanick	External Binaries	0	12-15-2005 02:58 PM
catdoc and xls2csv not indexing	greener_02445	External Binaries	14	04-13-2004 08:33 PM
no indexing with catdoc and xls2csv	Kylord	External Binaries	2	04-09-2004 08:19 AM
catdoc & xls2csv binaries	Hitman	External Binaries	1	01-13-2004 10:52 AM

03-29-2004, 09:10 PM	#3
brew Green Mole Join Date: Mar 2004 Posts: 2	fixed! okay heres the low down ... im using apache2 and it seems the default mime.type for xls files is now application/excel (so i got it working by commenting out this line in my mime.types file in apache config dir and added one for application/vnd.ms-excel you might want to add this extra application/excel in the next release of phpdig - given more and more users will be on apache2 thanks for your prompt help