Table Scripting Post: 302794251

Sponsored Content

Homework and Emergencies Homework & Coursework Questions Table Scripting Post 302794251 by Catori on Monday 15th of April 2013 10:20:14 PM

04-15-2013

Registered User

Because each script is going to be doing three different things.
Human Resources script will have the sales persons(five of more) with ID numbers and names within it.
Manufacturing script will have all the products manufactured with part numbers, product names, Cost of Manufacturing, and sell price with 40% markup or more.
and the Sales script will have all the products sold: Salesperson ID, part numbers, costs of goods sold, and gross profit.

After that, i need to generate a report, gathering data from each department's data files created by the scripts.
I simply do not know what my teacher means when she writes "Write three scripts to create tables, "flat database files, using colon delimiters. Each script should ask for the department name."
I cannot write pseudocode or an algorithm to something I don't even understand. So when I figure out the algorithm, i'll try starting the script...

i'll read some more on unix/linux shell scripts and programming shells, as well as variables, environment and configuration variables, shell variables, and operators.

---------- Post updated at 07:20 PM ---------- Previous update was at 10:21 AM ----------

Ahh! Here we go!!
How does this script sound?

Code:

#=============================================
#Script Name: Add Employee
#By: Catori
#
#=============================================
trap "rm~/tmp/* 2> /dev/null; exit" 0 1 2 3
employeefile=./humanresources/employees
looptest=y
while [ $looptest = y ]
do
   clear
   tput cup 1 4; echo "Corporate Employee Addition"
   tput cup 2 4; echo "====================="
   tput cup 3 4; echo "Id Number:"
   tput cup 4 4; echo "Last Name:"
   tput cup 5 4; echo "First Name:"
   tput cup 6 4; echo "====================="
   tput cup 7 4; echo "Add another? (Y)es or (Q)uit:"
   tput cup 3 15; read idnum
   if [ "$idnum" = "Q" ]
   then 
      clear; exit
   fi
   tput cup 4 15; read lname
   tput cup 5 15; read fname
   #check blank
   if [ "$lname" > "       " ]
   then
      echo "$idnum:$lname:$fname" >> $employeefile
   fi
   tput cup 7 34; read looptest
   if [ "$looptest" = "Q" ]
   then
      clear; exit
   fi
done

Last edited by vbe; 04-16-2013 at 10:28 AM.. Reason: code tags, typos (missing $, t...) & indent...

Catori

View Public Profile for Catori

Find all posts by Catori

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

[bash scripting] Generating a table with aligned fields

Hi everyone, I want to write a function which calculates the space needed between fields, to generate a table with aligned fields, like when you type "ls -l", the operating system generates a table with beautifully aligned fields. I've got this code so far: for line in $(cat tmpSearch)...

2. Shell Programming and Scripting

Create a table using shell scripting

Hi Can we create a rectangular table as i have attached in the query . This is primarily for populating the created table with data gathered . Hope I made myself clear ... Pls suggest Thanks

3. Shell Programming and Scripting

How to get the file size and count of a table using shell scripting?

Hi there, im a beginner to the shell scripting.i trying to extract a table from a db(IMD) and i have to get the count of that table and size of the file. can you help me out how to write the shall scriping for the above query.

4. Shell Programming and Scripting

Table Scripting

Okay. I've been charged with an assignment to create tables. I "Made" a manufacturing company called "Suit and Tie". I need subdirectories for the company, using three departments: Human resources, Manufacturing, and Sales. 1) mkdir Suit_and_Tie 2) cd Suit_and_Tie 3) mkdir Human...

5. Shell Programming and Scripting

How to update a Oracle table through shell scripting?

My Code is get_week_date() { `sqlplus -s ${DQM_SQL_LOGON}@${DQM_SID} << EOF SET ECHO OFF SET FEEDBACK OFF SET PAGES 0 SET SERVEROUTPUT ON SET VERIFY OFF SET TRIMSPOOL ON (update file_level_qc fq set FQ.DATA_FILE_NAME='Hyvee_Pharmacy_Solutions_201304_v1.txt'...

6. Shell Programming and Scripting

Shell scripting unable to send the sql query data in table in body of email

I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email. spool table_update.html; SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription'; spool off; exit; Please use code tags next time for your code and data....

7. Shell Programming and Scripting

Please help in populating output in table using shell scripting

Below is my code where i tried using table tag to print out put in table but its not working #!/bin/ksh #] && . ./.profile 2>/dev/null if test -f '.profile'; then . ./.profile; fi; #. .profile LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1";...

8. UNIX for Advanced & Expert Users

How can i populate the record in to table using shell scripting?

LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7" ( echo "From: $pzFrom\nTo: $pzTo\nSubject: $pzTitle${pzReplyTo:+\nReply-To: $pzReplyTo}" ] && echo...

9. Forum Support Area for Unregistered Users & Account Problems

Creation of Oracle table through shell scripting

Hi, I am trying to create a table through shell scripting . I used a command sqlplus -s to connect to sqlplus and user as sysdba. but there is a problem in it. can anyone please solve this . #!/bin/bash $(`sqlplus -s / as sysdba <<eof create table sample (id,int); insert into sample...

10. Web Development

Getting Rid of Annoying Bootstrap Table Borders and Wayward Table Lines

Bootstrap is great; but we have had some issues with Bootstrapped <tables> (and legacy <fieldset> elements) showing annoying, wayward lines. I solved that problem today with this simple jQuery in the footer: <script> $(function(){ $('tr, td, fieldset,...

LEARN ABOUT OSX

conjure

conjure(1)						      General Commands Manual							conjure(1)

NAME

       conjure - interprets and executes scripts written in the Magick Scripting Language (MSL).

SYNOPSIS

       conjure [options] script.msl

OVERVIEW

       The conjure program is a member of the ImageMagick(1) suite of tools.  Use it to process a Magick Scripting Language (MSL) script. The Mag-
       ick scripting language (MSL) will primarily benefit those that want to accomplish custom image processing tasks but do not wish to program,
       or those that do not have access to a Perl interpreter or a compiler.

       For  more  information  about  the  conjure  command,  point your browser to file:///usr/share/doc/packages/ImageMagick/www/conjure.html or
       http://www.imagemagick.org/script/conjure.php.

DESCRIPTION

       Image Settings:
	 -monitor	      monitor progress
	 -quiet 	      suppress all warning messages
	 -regard-warnings     pay attention to warning messages
	 -seed value	      seed a new sequence of pseudo-random numbers
	 -verbose	      print detailed information about the image

       Miscellaneous Options:
	 -debug events	      display copious debugging information
	 -help		      print program options
	 -log format	      format of debugging information
	 -list type	      print a list of supported option arguments
	 -version	      print version information

       In additiion, define any key value pairs required by your script.  For example,

	   conjure -size 100x100 -color blue -foo bar script.msl

SEE ALSO

       ImageMagick(1)

COPYRIGHT

       Copyright (C) 1999-2010 ImageMagick Studio LLC. Additional copyrights and licenses apply to this software, see  file:///usr/share/doc/pack-
       ages/ImageMagick/www/license.html or http://www.imagemagick.org/script/license.php

ImageMagick						     Date: 2009/01/10 01:00:00							conjure(1)