Hi Raja,
You have an issue with either your understanding of cron or of shell
scripts. ssconvert is working fine so it's not really an issue for this
list.
You'll probably find your local LUG ie Linux Users Group will explain
the vagaries of these things better than we can because they have more
practice at such things.
Your favourite search engine with something like
Linux User Group Antartica
should turn up the Antartic user groups, well not quite so swap
antartica with any country you like, be it the one you're in, or just
one you like. Pick one, find its mailing list and there will likely be a
bunch of friendly, helpful people who will give you a hand with these
things. I'm sure there'd be good ones in Malaysia if you happen to be
thereabouts.
Try adding the full path to cd, mkdir, wget in your comands below and
the full path to ssconvert or by way of alternative, setting the PATH
variable early in your script.
PATH=$PATH:/opt/foo/wherever/you/keep/ssconvert:/opt/bar/other/stuff/you/need
Your LUG will explain better and provide more detail.
All the best.
Hal
On 3/Dec/10 5:31 PM, Raja Iskandar Shah wrote:
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 <m...@truenorth.nu <mailto:m...@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 <mailto:gnumeric-list@gnome.org>
http://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list
