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