Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: I could use some help with making a script
Top Forums Shell Programming and Scripting I could use some help with making a script Post 302841509 by jpontius on Wednesday 7th of August 2013 12:57:31 PM
Old 08-07-2013
Thanks for the fast reply!

Input is from the various workstations that users log into, via that perl script. It outputs the username and time in minutes,
Code:
  dronnow 40
  dwright3 272
  esoto1 52
  ewhite5 36
  gliu3 327
  gshaw1 382

I will make another csv file with their details having
Code:
username,supervisor,account_number
dwright3,Creary,327531**********
gliu3,Miller,330198**********

I would like something that takes the user login time and adds each individuals account_number and supervisor, plus what instrument/workstation the time was on (different rates for different instruments). This can probably be accomplished by setting the first variable ($1=Bruker_600) or something.

Output must be like this with a header then usage charges:
Code:
Primary Comments,Customer Account Number,Transaction Date,Service Description,Quantity,Unit,Price,Service Category,PI's Name,Purchaser's Last Name,Short Contributing Center Name,Resource Name,Line Item Assistant,Line Item Comments
600 NMR,201895**********,07/31/13,600 MHz,34.97,Hour,6,600 MHz,Ash,Ash,"""""",600 NMR,"""""",""""""
600 NMR,327531**********,07/31/13,600 MHz,25.25,Hour,6,600 MHz,Creary,Creary,"""""",600 NMR,"""""",""""""
600 NMR,261485**********,07/31/13,600 MHz,33.55,Hour,6,600 MHz,Helquist,Helquist,"""""",600 NMR,"""""",""""""
600 NMR,330198**********,07/31/13,600 MHz,11.48,Hour,6,600 MHz,Miller,Miller,"""""",600 NMR,"""""",""""""

---------- Post updated at 12:57 PM ---------- Previous update was at 12:55 PM ----------

I should add, this only needs to be done once a month. The perl script will run at 0001 on the 1st of the month for last months login data, eg wtmp.1
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Making a script exectuable

Hi, I'm pretty new to Unix and I just have a question concerning making a script executable without putting the "sh" command before it. In case it makes the difference I am on an Apple computer using the Terminal. Anyway here is the little test code I wrote followed by the commands I took to try to... (5 Replies)
Discussion started by: BuyoCat
5 Replies

2. Shell Programming and Scripting

Making flags for my script

I have no idea how to make my own flags. (6 Replies)
Discussion started by: rcunn87
6 Replies

3. Shell Programming and Scripting

Need help making a script

Here is what I have: #!/bin/bash # Setup year date and month YR=`date +%Y '{print $6}'` MON=`date +%b '{print $2}'` DAY=`date +%d '{print $3}'` file=$YR$MOY$DOM # clear # Dump database using USER/PASS to ..sql mysqldump --user=me -ppass database > database-db.$file.sql The YR, MON and... (2 Replies)
Discussion started by: npereira
2 Replies

4. Shell Programming and Scripting

making script

hello experts cany any one help me i want to make one script which can rlogin to another machine . but it should not ask me username/password from me of another machine it should take the username and password from the script only. please help me out. regards, shary (2 Replies)
Discussion started by: shary
2 Replies

5. Shell Programming and Scripting

making shell script

Hi , I am new to shell scripting I want to make script as to execute followng command mysqldump -u (user name) -p(password) database name>filename.sql this file saves with current date and time and execute automatically at particular time which I give (10 Replies)
Discussion started by: kaushik02018
10 Replies

6. Shell Programming and Scripting

Help making a tasklog script

I am trying to create a program called tasklog that integrates with one of my online accounts, to keep track of what tasks I have been working on. On login, I'd like it to display (up to) the five most recent entries, then ask me what I plan to work on during the new session. I then will type an... (3 Replies)
Discussion started by: santod
3 Replies

7. Shell Programming and Scripting

Need Help With making this script

Hello, im a new user on this site and learning scripting very slowly at a understanding pace. However i am up with a challenge and require help completing this. The script has to include arguments, variables, decisions and loops. So the script is about calculating the broadcast address for any... (5 Replies)
Discussion started by: tHe666
5 Replies

8. Shell Programming and Scripting

Making any script executable

Hi all, I'm new to Unix so just wanted some help. I've been self learning and came accross a question online that I was trying. It is to make any shell script executable, the name of the file is to be made executable. I would use nano and type in something like #! /bin/bash Chmod +x... (4 Replies)
Discussion started by: HelenaR
4 Replies

9. AIX

Making a trace for a script

Hello experts, I'm trying to make a trace (unix log) in hope to see why I have differences in some bases : I putted at the first { and in the last line } > $DATA_SAS 2>&1 Is it a right command ? Do you have another solution ? thank you, regards, (7 Replies)
Discussion started by: rimob
7 Replies

10. UNIX for Beginners Questions & Answers

Help me making this script

This script is executed whenever a new vehicle is added to the cycle-motor park of campus. The script asks for the following information about the car and adds a new line to the vehicle file.txt: name (name of an animal, unique identifier), color, mark, model, type (e.g., electrical, manual),... (2 Replies)
Discussion started by: andre2222
2 Replies

LEARN ABOUT DEBIAN

nfsidmap

nfsidmap(5)							File Formats Manual						       nfsidmap(5)

NAME

       nfsidmap - The NFS idmapper upcall program

SYNOPSIS

       nfsidmap [-v] [-t timeout] key desc
       nfsidmap [-v] [-c]
       nfsidmap [-v] [-u|-g|-r user]

DESCRIPTION

       The  file  /usr/sbin/nfsidmap is used by the NFS idmapper to translate user and group ids into names, and to translate user and group names
       into ids. Idmapper uses request-key to perform the upcall and cache the result.	/usr/sbin/nfsidmap is  called  by  /sbin/request-key,  and
       will perform the translation and initialize a key with the resulting information.

       nfsidmap  can also used to clear the keyring of all the keys or revoke one particular key.  This is useful when the id mappings have failed
       to due to a lookup error resulting in all the cached uids/gids to be set to the user id nobody.

OPTIONS

       -c     Clear the keyring of all the keys.

       -g user
	      Revoke the gid key of the given user.

       -r user
	      Revoke both the uid and gid key of the given user.

       -t timeout
	      Set the expiration timer, in seconds, on the key.  The default is 600 seconds (10 mins).

       -u user
	      Revoke the uid key of the given user.

       -v     Increases the verbosity of the output to syslog (can be specified multiple times).

CONFIGURING

       The file /etc/request-key.conf will need to be modified so /sbin/request-key can properly direct the upcall. The following line	should	be
       added before a call to keyctl negate:

       create	 id_resolver	*    *	  /usr/sbin/nfsidmap -t 600 %k %d

       This  will  direct all id_resolver requests to the program /usr/sbin/nfsidmap.  The -t 600 defines how many seconds into the future the key
       will expire.  This is an optional parameter for /usr/sbin/nfsidmap and will default to 600 seconds when not specified.

       The idmapper system uses four key descriptions:

	      uid: Find the UID for the given user
	      gid: Find the GID for the given group
	     user: Find the user name for the given UID
	    group: Find the group name for the given GID

       You can choose to handle any of these individually, rather than using the generic upcall program.  If you would like to use your  own  pro-
       gram for a uid lookup then you would edit your request-key.conf so it looks similar to this:

       create	 id_resolver	uid:*	  *    /some/other/program %k %d
       create	 id_resolver	*	  *    /usr/sbin/nfsidmap %k %d

       Notice  that the new line was added above the line for the generic program.  request-key will find the first matching line and run the cor-
       responding program.  In this case, /some/other/program will handle all uid lookups, and /usr/sbin/nfsidmap will handle gid, user, and group
       lookups.

AUTHOR

       Bryan Schumaker, <bjschuma@netapp.com>

								  1 October 2010						       nfsidmap(5)
All times are GMT -4. The time now is 10:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy