thanks. now noted that i have posted in the wrong user group after looking at the link page, the absolute pathname for ssconvert is /usr/bin/ssconvert
meaning if need cron to execute ssconvert, then need to add in the shell script PATH=$PATH:/usr/bin/ssconvert On Fri, Dec 3, 2010 at 2:49 PM, Hal Ashburner <[email protected]> wrote: > 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 <[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 > [email protected]http://mail.gnome.org/mailman/listinfo/gnumeric-list > > > > _______________________________________________ > 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
