Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Exporting or quering 2 issues
Top Forums Shell Programming and Scripting Exporting or quering 2 issues Post 302493325 by jim mcnamara on Wednesday 2nd of February 2011 10:56:48 AM
Old 02-02-2011
By export ldap users do you mean create a list?
Code:
ldaplist passwd '*' >  ldap.txt

creates a file with usernames. You can use sqlldr to insert those username
from the file into an Oracle table.

xlm files are Windows Excel macro files. UNIX does not do Excel per se. You will have to
find an xlm -> text converter to make a text file on the PC. I personally do not know of one.
After you convert to text, you can use sqlldr to insert those values into a table

sqlldr requires two files: a data file, and a ctl (control file). The ctl file tells sqlldr how to load the table. Here is a start on using sqlldr:
SQL Loader Demo
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

exporting a directory

How do I export a directory ? I am trying to link the directory from another machine. (2 Replies)
Discussion started by: brv
2 Replies

2. UNIX for Dummies Questions & Answers

quering unix boxes for attaced printers

Greetings All, I was wanting some info seeing i am a ms geek looking to go into UNIX if i want to query a UNIX box for info regarding printers, LPDs and such source how would i go about this !!!! All comments that would point me in the right direction would be most useful. Cheers (1 Reply)
Discussion started by: seekerO
1 Replies

3. UNIX for Dummies Questions & Answers

exporting display

how do I export my display from my unix box to my pc basically what is the syntax for export DISPLAY (2 Replies)
Discussion started by: csaunders
2 Replies

4. Windows & DOS: Issues & Discussions

Exporting data

My friend's boss has asked me to help update a customer database. They have a limited amount of space and have asked if I can do this from my home computer. She is working on a Unix system with a program called Accuterm. My understanding is that this program is a dedicated program for the... (0 Replies)
Discussion started by: clearchoice
0 Replies

5. Windows & DOS: Issues & Discussions

exporting exchange information

Hey all, I have teh job of exporting all the information for around 500 e-mail addresses from exchange into something like a excel sheet. I was pretty quiet one afternoon last week (and bore) so I added them to my adddresses book then exported them to excel. But I now have a problem, it does... (0 Replies)
Discussion started by: woofie
0 Replies

6. Solaris

Exporting X display question

I have a sun box i can connect to using exceed in broadcast or query mode. I have been using passive mode to call up just a few apps, xcalc for example. How do i get the solaris 9 user login screen using passive mode? is it dtlogin or something that im should run frmo the shell? (0 Replies)
Discussion started by: BG_JrAdmin
0 Replies

7. Shell Programming and Scripting

Exporting to excel

Can someone help me out to export awk output to excel file in different rows? Plzzzz its urgent...:( (4 Replies)
Discussion started by: goutam_igate
4 Replies

8. Solaris

variable exporting

Hi, can anyone tell me the difference between the below two examples: Eg-1: # name=bravo # echo $bravo what would be the o/p Eg-2: # name1=jhonny # export name1 # echo $name1 what would be the o/p If the o/p's of both examples are the same then what is the use of the cmd export... (3 Replies)
Discussion started by: rahul_11d
3 Replies

9. Shell Programming and Scripting

exporting variable

Hi All; I m working on a script and came across an issue ,to explain it briefly here is the sample code echo $HOSTNAME|while read IN; do var=`echo $IN|awk -F "-" '{print $2}'`; export var; echo $var; done now I get the value of $var but when it is out of the while loop it does not return... (3 Replies)
Discussion started by: maverick_here
3 Replies

10. Red Hat

Help with exporting DISPLAY from Linux to Windows XP

Hi Experts, I am using Cygwin and Xming server to bring back the display from Linux to a Windows machine. I am following the below steps :- 1. Close down all X Servers 2. Run XMing – XLaunch 3. Select Multiple 4. Select Start no clients 5. Tick No Access Control box 6. Click Finish... (7 Replies)
Discussion started by: oopsalion
7 Replies

LEARN ABOUT DEBIAN

excel::template::element::formula

Excel::Template::Element::Formula(3pm)			User Contributed Perl Documentation		    Excel::Template::Element::Formula(3pm)

NAME

       Excel::Template::Element::Formula - Excel::Template::Element::Formula

PURPOSE

       To write formulas to the worksheet

NODE NAME

       FORMULA

INHERITANCE

       Excel::Template::Element::Cell

ATTRIBUTES

       All attributes a CELL can have, a FORMULA can have, including the ability to be referenced using the 'ref' attribute.

CHILDREN

       None

EFFECTS

       This will consume one column on the current row.

DEPENDENCIES

       None

USAGE

	 <formula text="=(1 + 2)"/>
	 <formula>=SUM(A1:A5)</formula>

	 <formula text="$Param2"/>
	 <formula>=(A1 + <var name="Param">)</formula>

       In the above example, four formulas are written out. The first two have the formula hard-coded. The second two have variables. The third
       and fourth items have another thing that should be noted. If you have a formula where you want a variable in the middle, you have to use
       the latter form. Variables within parameters are the entire parameter's value.

AUTHOR

       Rob Kinyon (rob.kinyon@gmail.com)

SEE ALSO

       CELL

perl v5.14.2							    2010-06-17				    Excel::Template::Element::Formula(3pm)
All times are GMT -4. The time now is 03:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy