Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Using finger in a loop
Top Forums UNIX for Dummies Questions & Answers Using finger in a loop Post 302889480 by Don Cragun on Thursday 20th of February 2014 11:55:01 PM
Old 02-21-2014
Quote:
Originally Posted by stew
I have test file like below

Code:
sinlga
e34f,n,Mon,Aug,19,,2013,on
ggi11
ggi11,n,Thu,Jul,12,,2012,on
hca05
hca05,n,Mon,Apr,4,,2011,on,
r45fv
r45fv,n,Fri,Feb,7,2014,16:5
e43vg,
4er34,n,Tue,Aug,21,,2012,on
rt4566
rt4566,n,Tue,Nov,12,2013,12:

I would like to load this .txt file into table.

I used two program

Code:
program1:
 
#!/bin/ksh
load data
infile 'userreport.txt'
INSERT INTO lastlogon
FIELDS TERMINATED BY ','
(
userid
Day
Month
Date
year )
 
program 2:
 
#!/bin/ksh
filename=userreport.txt
while IFS=, userid Day Month Date year
do
INSERT INTO lastlogon
(userid, Day, Month, Date, year)
values(  ................)

when I compile program 1: I am getting below error

Code:
loaddata.ksh[2]: load:  not found
+ infile userreport.txt
loaddata.ksh[3]: infile:  not found
+ INSERT INTO lastlogon
loaddata.ksh[4]: INSERT:  not found
+ FIELDS TERMINATED BY ,
loaddata.ksh[5]: FIELDS:  not found
+ userid
loaddata.ksh[7]: userid:  not found
+ Day
loaddata.ksh[8]: Day:  not found
+ Month
loaddata.ksh[9]: Month:  not found
+ Date
loaddata.ksh[10]: Date:  not found
+ year
loaddata.ksh[11]: year:  not found

But in program 2: I am not sure how to pass .txt data values to Insert table(marked as red text)
Please help me on this.
I have absolutely no idea how message #16 is related to anything else in this thread.

Did the changes I suggested in message #15 in this thread work for you?

Have all of the issues you raised in the 1st message in this thread been resolved?

If you have a different problem where you also need help, open a new thread with a clear description of what you are trying to do, what code you're using, what you input looks like, what output you are trying to produce from that input, and a clear description of what processing should be performed to transform your input into the desired output.

The trace log from running (not compiling) loaddata.ksh clearly shows that other than the comment on the first line of the script and the start of the subshell on line 6, no other line in your shell script contains a valid shell command. Your second script suffers from similar problems.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

finger and newsgroups

Hi, I've been using unix at college for a few weeks now and I have come up against a few stumbling blocks: - Most unix commands seem to work w/ regexps - the computers I and my group are allowed to logon to are all itsunXX where XX is a number. if I can {finger @itsun88} to find out that I and... (1 Reply)
Discussion started by: the_man_who
1 Replies

2. UNIX for Dummies Questions & Answers

finger

is there a way to show information on all the users on your system? when i use 'finger' is only shows users names and info who are currently on the system. is there a way to show all accounts? thanx! (5 Replies)
Discussion started by: djatwork
5 Replies

3. UNIX for Dummies Questions & Answers

Finger Information

Hey, I was wondering If anybody knew of a way to make a log of all users who type the command finger username when username is my own. I would like to see who is keeping track of me :) Thanks (3 Replies)
Discussion started by: hanley_ie
3 Replies

4. UNIX for Advanced & Expert Users

finger command

Hello all, Here is what I am trying to do. If a user exist, then send an echo "EXIST" or else "DOES NOT EXIST". (under HP-UX) Kind of: #!/usr/bin/sh USER=mylogin finger $USER if $? = 0 then echo "EXIST"" else echo "DOES NOT EXIST" fi (10 Replies)
Discussion started by: qfwfq
10 Replies

5. Shell Programming and Scripting

help in finger command.

Hi, iam using sunsolaris. when you type finger command -- it dispalys information about local and remote users. but here it shows as can't stat /dev/gold:8664 can anybody help what is the solution for this error. previously the output came. thanks, shan (1 Reply)
Discussion started by: shanshine
1 Replies

6. UNIX for Dummies Questions & Answers

finger question

How can I change the name in the 'finger' information? anybody has an idea? (2 Replies)
Discussion started by: ksainth
2 Replies

7. UNIX for Dummies Questions & Answers

finger

Is there any possible way to get rid of the header when I do finger ? I want to get rid of Login Name Tty Idle Login Time Office Office Phone as the header. Please let me know how to do it. (2 Replies)
Discussion started by: felixwhoals
2 Replies

8. UNIX for Advanced & Expert Users

finger command

I want to know the correct version of how i should use the finger command in this example below.(os is debian lenny) (nymserver.pl is located in /home/nymserv directory.) the two versions are : (in/etc/inetd.conf) finger stream tcp nowait nymuser /usr/nym/nymserv nymserv... (3 Replies)
Discussion started by: xstation
3 Replies

9. Shell Programming and Scripting

Finger has gone crazy

Two things : On the first place i am really desperate, on the second i am about to throw my laptop away to the recycle bin in a while. Ok now that i expressed my feeling let me describe you this mad situation. Code: print $1; ("finger -m " $1 "| head -1") | getline userinfo print... (6 Replies)
Discussion started by: beatblaster666
6 Replies

10. UNIX for Dummies Questions & Answers

Finger command help

Hi Does anyone know if there is anyway of doing the finger command for all user id's in my enviroment. What I need to obtain is the full names of all users on the system. I know if i do the finger command with no arguments it will list users currently logged in, but i need all users... ... (2 Replies)
Discussion started by: m3y
2 Replies

LEARN ABOUT CENTOS

fprintd

fprintd(1)																fprintd(1)

NAME

       fprintd - Fingerprint management daemon, and test applications

SYNOPSYS

       fprintd-enroll [username]

       fprintd-list username [usernames...]

       fprintd-verify [-f finger] [usename]

       fprintd-delete username [usernames...]

DESCRIPTION

       This manual page documents briefly the fprintd command-line utilities.

       The fprintd daemon is accessed through D-Bus by those command-line utilities.

ARGUMENTS

       username
	       The username for the user for which you want to query or modify the fingerprint database.

	       Not that fprintd-list and fprintd-delete require at least one username to be passed, and support multiple usernames.

	       fprintd-enroll and fprintd-verify will use the current username if none are passed on the command-line.

       -f finger
	       For fprintd-enroll, the finger to enroll. Possible values are:

	       left-thumb, left-index-finger, left-middle-finger, left-ring-finger, left-little-finger, right-thumb, right-index-finger, right-
	       middle-finger, right-ring-finger, right-little-finger.

	       The default is automatic, selecting the first available finger for swipe devices, or all the enrolled fingers, for press devices.

TEST APPLICATIONS

   fprintd-enroll
	       Will enroll the user's right index finger into the database.

   fprintd-list
	       Will list the user's enrolled fingerprints.

   fprintd-verify
	       Will enroll the user's right index finger into the database.

   fprintd-enroll
	       Will enroll the user's right index finger into the database.

AUTHOR

       fprintd was written by Bastien Nocera and Daniel Drake.

DIRECTORIES

       By default, fprintd stores the fingerprints in /var/lib/fprint/

SEE ALSO

       dbus-daemon, gnome-about-me

freedesktop							    2014-06-10								fprintd(1)
All times are GMT -4. The time now is 06:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy