Shell Programming and Scripting

Hi Guys,

I've got a script that runs and collects statistics from one of our machines and outputs the data into a csv file. Now, that script runs fine and I managed to create another one (with a lot of help from this forum!!) to trim the csv file down to all the data that I need, rather than all the data it collects.

Anyway, I'm now trying to write a script to import this data from the csv file into Nagios so it can report the statistics. The easiest way I've heard of to do this is to create a script which involves populating an array from the csv file and then passing the contents of the array into Nagios (I can modify an existing script for that).

My knowledge on scripting is a bit limited and I certainly haven't created one involving passing a csv file into an array!! Does anyone have any pointers on how this can be done ? This is an example of the data in the csv file:

Code:

startup timestamp,1327702381482
cpu combined,0.0900
cpu idle,0.9100
cpu nice,0.0000
cpu sys,0.0360
cpu user,0.0540
cpu wait,0.0010
memory free,4415.501335 MB
memory max,4494.937500 MB
memory used,79.436165 MB

As you can see, there isn't a lot of data to insert into the array and I could possibly do without the first column as I can enter this in the Nagios script. Or, does anyone think there is a better way of doing this !?

Thanks for any help!

Cheers, Jim

What's your system?

What's your shell?

How do you want the contents of the array to be arranged?

Hi Corona,

The system its running on is Red Hat Enterprise Linux 6, and bash shell. As for the contents of the array, ideally it would just be arranged in the order that is in the csv file if that is possible?


Cheers, Jim

Code:

#!/bin/bash

N=0
ARR=()

IFS=","

while read STR
do
        set -- "$STR"

        while [ "$#" -gt 0 ]
        do
                ARR[$N]="$1"
                ((N++))
                shift
        done
done < input.csv

Corona688, you sir, are a genius!!

Thats exactly the kind of thing I've been looking for! How would I test it to see if, say, what is contained at number 5 in the array ? I just tried to add 'echo $ARR[2]' etc, but it always just outputs the first record in the array (and adds [2] to the end!).

It's been a long day and I'm getting confused . . . . . it doesn't take much though!

You need the {} brackets.

Code:

echo ${ARR[2]}

---------- Post updated at 04:45 PM ---------- Previous update was at 04:42 PM ----------

I think I made an error in my original code.

Code:

set -- $STR

not

Code:

set -- "$STR"

The quotes will prevent it from splitting.

Thanks Corona688 - honestly, your help has been invaluable with my problems. Can't thank you enough.

Just hope that one day, I'll be able to help out on these boards like you do. Now, to get the books out and study your script so I know each thing its doing, one step at a time so I can learn this.

Thanks again!

Cheers, Jim