Where exactly did you get stuck? Doing such things you should be familiar with Oracle and SQL, maybe awk to parse the xml into SQL code (I bet there are tools already to do this) and also getting familiar with the command ldapsearch to extract user information from an LDAP server will be helpful. Maybe the LDAP server itself has an export function, where you can even select trunks of it's tree.
Edit:
Thought xlm is a typo - maybe there is a perl module for this.
By export ldap users do you mean create a list?
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
Heres the situation: I have a script that creates user.xml files and ldap accounts that runs nightly. The script copies xml files to a directory on the unix server. I want to get/copy/export whatever the best way is to get those xml files and date created and dump them into a oracle table.
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)
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)
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)
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)
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)
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)
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)