Re: problem using ssconvert in shell script

[Raja Iskandar Shah <rajaiskandars gmail com>]

this is what i have added to cron (i have not included the dates and times)

00 18 01 * * sh /opt/scripts/download_eids.sh  # this works
15 18 01 * * sh /opt/scripts/ssconvert_eids.sh  # this does not work
30 18 01 * * sh /opt/scripts/etlclient_eids.sh   # this works


for download_eids.sh which works i have the following

mkdir /opt/scripts/eids_downloads_2010_12
cd /opt/scripts/eids_downloads_2010_12
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/2.9.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/2.3.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/2.1.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.19.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.13.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.15.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.20.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.17.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/2.5.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.21.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.19.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/2.4.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.29.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/2.10.xls
wget http://www.bnm.gov.my/files/publication/msb/2010/10/xls/1.3.xls


for the ssconvert_eids.sh which does not work i have the following

cd /opt/scripts
cd /opt/scripts/eids_downloads_2010_12
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="N 2.9a " separator=, format=raw quote="" eol=windows' 2.9.xls 2_9.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="2.3" separator=, format=raw quote="" eol=windows' 2.3.xls 2_3.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="N 2.1" separator=, format=raw quote="" eol=windows' 2.1.xls 2_1.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="1.19" separator=, format=raw quote="" eol=windows' 1.19.xls 1_19.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="1.13" separator=, format=raw quote="" eol=windows' 1.13.xls 1_13.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="1.15" separator=, format=raw quote="" eol=windows' 1.15.xls 1_15.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="1.20" separator=, format=raw quote="" eol=windows' 1.20.xls 1_20.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="1.17" separator=, format=raw quote="" eol=windows' 1.17.xls 1_17.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="2.5" separator=, format=raw quote="" eol=windows' 2.5.xls 2_5.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="1.21" separator=, format=raw quote="" eol=windows' 1.21.xls 1_21.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="1.19" separator=, format=raw quote="" eol=windows' 1.19.xls 1_19.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="2.4" separator=, format=raw quote="" eol=windows' 2.4.xls 2_4.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="1.29" separator=, format=raw quote="" eol=windows' 1.29.xls 1_29.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="2.10" separator=, format=raw quote="" eol=windows' 2.10.xls 2_10.csv
ssconvert --export-type=Gnumeric_stf:stf_assistant -O 'sheet="Table 1.3" separator=, format=raw quote="" eol=windows' 1.3.xls 1_3.csv

from the link that you gave, it looks like i should add the absolute path to the command ssconvert ? or is it the path to the files ?

2010/12/3 Mark Gannon <mark truenorth nu>

On Thursday 02 December 2010 20:10:40 Raja Iskandar Shah wrote:
> the problem is only when the cron to execute the shell script containing
> the ssconvert command

I'll offer my 2 cents worth.

I often have a problems with cron relating to paths.  Are you using complete
path names?  A quick Google turned up this page:
http://clickmojo.com/code/cron-tutorial.html

Regards,

Mark Gannon

--
 "I would rather be exposed to the inconveniencies attending too much liberty
than those attending too small a degree of it."

               --Thomas Jefferson

_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list