Re: problem using ssconvert in shell script

[Raja Iskandar Shah <rajaiskandars gmail com>]

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 <hal ashburner info> 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 <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

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