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 <[email protected]> > 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 > [email protected] > http://mail.gnome.org/mailman/listinfo/gnumeric-list > >
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
