Hello,
I am in need of a simple shell script for my job. When given product quantity is shipped from factory, I want to reduce related subparts existing in product tree and keep my warehouse stocks up to date by running a script.
Scenario:
I sold and produced 5pcs of the product nr101.
Here is its product tree:
product_nr101.xls
first column shows subpart nr , partname and quantity in use in product nr101:
Code:
144126201 PART NAME1 4,00 PCS
144126202 PART NAME2 4,00 PCS
144126203 PART NAME3 4,00 PCS
144126204 PART NAME4 1,00 PCS
144126205 PART NAME5 2,00 PCS
144126206 PART NAME6 6,00 PCS
144126207 PART NAME7 4,00 KG
144126208 PART NAME8 1,00 KG
144126209 PART NAME9 0,10 KG
144126210 PART NAME10 1,00 PCS
Warehouse.xls
First column is subpart nr and second column is showing how many pcs of part I have in my stocks.
Code:
144126201 50,00 PCS
144126202 40,00 PCS
144126203 40,00 PCS
144126204 50,00 PCS
144126205 200,00 PCS
144126206 200,00 PCS
144126207 100,00 KG
144126208 100,00 KG
144126209 100,00 KG
144126210 230,00 PCS
When 5pcs of product101 is shipped, it will multiply quantity in each row, will find it in warehouse.xls and reduce the quantity.
I tried to write something in shell but dont know how to proceed:
Code:
#!/bin/sh
echo "enter shipped product code"
read productcode
echo "enter how many pcs product shipped"
read quantity
.....?....
Thanks Rudic,
I will give it a try at my end.
Normally that was not directly related to unix/shell script but I want to do such things in linux. At the office, I use a licenced software and we are waiting for having an education program being directed by the company. Do you recommend excel?
Again and again.... many thanks for your effort
Boris
Hi,
I am totally a newbie to any programming languages and I just started an entry level job in an IT company. One of my recent tasks is to create a script that is able to show the log file of linux service (i.e. ntpd service)
lets say, if I run my script ./test.sh, the output should be... (3 Replies)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk... (2 Replies)
Hi All,
I have new for shell scripting.
Problem : I have one scrip at serv1 and path of server is /apps/dev/provimage/scripts and script name:extract_ancillary.bat.
I need to call this script at server2(my working server) and execute at server2 .
Please let me know how to build the... (5 Replies)
i want use ssh on the host01 to execute autoexec.sh on the host02 like following :
host01> ssh host02 autoexec.sh
autoexec.sh include nohup command like follwing :
nohup /home/jack/deletedata.sh &
after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Hi, folks,
A new release, v.0.30.1, of CK-ERP, has been posted, at SourceForge.Net, sourceforge.net/projects/ck-erp .
New features comprise seven new modules (ck-teacher, ck-counsellor, ck-student, ck-applicant, ck-family, ck-registrar, ck-eduadmin) for deployment within educational... (0 Replies)
Hi,
I have an HTML form through which I get some text as input. i need to run a shell script say script.sh inside a perl-cgi script named main_cgi.sh on the form input.
I want to write the contents of the form in a file and then perform some command line operations like grep, cat on the text... (2 Replies)
Dear friends,
exec 0<$SuppFile
while read LINE
do
echo $LINE
gatewayArchive=`ssh root@mrp-gateway "cd /usr/local/apache/data/PLAT/MIMUS/upload/PROD/archive && ls $LINE"`
echo "gateway files :"$gatewayArchive
done
this loop is not repeating when i use ssh root@mrp-gateway line of code.... (1 Reply)