05-03-2016
LDAP data in CSV format
Hi all,
I am new here, please don't eat me alive..
I am trying to find a good community to learn and participate in unix / linux discussions to help me improve in my current job.
That being said, I have a problem which I didn't expect to challenge me, but I can't seem to find a viable solution..
I am trying to do one of two things:
1. Take an LDIF export from an LDAP directory and convert it to a CSV format where the first line contains attributes and the preceding lines contain values, one line per object.
2. Find a way to export directly from the LDAP directory into a CSV format in the above configuration.
I am not good at writing scripts, so I've searched around for a pre-existing solution. Perhaps a program which takes an LDIF and a few attribute names as an input and outputs a CSV. Or maybe something which can search an LDAP directory and export the contents directly into CSV format.
Can this be done?
This is Redhat Linux, the process is IBM Security Directory Server which is an LDAP directory.
This User Gave Thanks to tfm217 For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi There
I needed to write a Unix shell script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file.
Currently I am in the proess of Data Import to "Remedy System" (A one kind of incident mangement Application) and this... (8 Replies)
Discussion started by: Uday1982
8 Replies
2. Shell Programming and Scripting
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
Discussion started by: mdap
1 Replies
3. UNIX for Advanced & Expert Users
Hi all,
I have written a shell script to search a specified directory (e.g. /home/user) for a list of specific words (shown as ${TMPDIR}/wordlist below). The script works well enough, but I was wondering if there was a way to display the line number that the word is found on?
Thanks!
cat... (1 Reply)
Discussion started by: tmcmurtr
1 Replies
4. Shell Programming and Scripting
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies
5. Shell Programming and Scripting
Hi Unix Gurus,
I tried to convert the attached xhtml table content into csv file using unix shell script (lynx -dump filename) and got the below results:
Title ID Owner Priority Estimate Project Change Date Changed By
Complexity Create Date Created By Detail Estimate Total De tail... (6 Replies)
Discussion started by: bi.infa
6 Replies
6. Shell Programming and Scripting
Hi There
I need a script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file.
I am using an application that will only take data in a particular format and need something that will convert without manual intervention.
The... (4 Replies)
Discussion started by: rbggbr16
4 Replies
7. Shell Programming and Scripting
User Aia had created this below script to help translate LDIF files to CSV format, and it works very well (thanks again Aia if you are reading this)
Here is the original thread.
https://www.unix.com/shell-programming-and-scripting/265753-ldap-data-csv-format.html?referrerid=302170129
However... (2 Replies)
Discussion started by: tfm217
2 Replies
8. Shell Programming and Scripting
I am new to html and need to convert the attached csv file data to html format ; running into issues. please assist.
#!/bin/ksh
echo "<html>" ;
echo "<head><style> table {border-collapse: collapse;} table, td, th {border: 1px solid black;} </style></head>"
echo "<title> REPORT </title>"
echo... (0 Replies)
Discussion started by: archana25
0 Replies
9. Shell Programming and Scripting
HI ,
I m looking for help here!!!
Can we filter the below log data into CSV format ?
timestamp INFO <text > - Some text Drive ..
Need a format of separate field such as
1 2 3 4 ... (2 Replies)
Discussion started by: MohSalNiz
2 Replies
10. UNIX for Beginners Questions & Answers
I m looking for help here!!!
Can we filter the below log data into CSV format ?
1 2 3 4 5 6 7 8
timestamp INFO <text > - Some text (1 Reply)
Discussion started by: MohSalNiz
1 Replies
LEARN ABOUT DEBIAN
confdb2ldif
confdb2ldif(8) System Manager's Manual confdb2ldif(8)
NAME
confdb2ldif - Create an LDIF file from a cluster configuration
SYNOPSIS
confdb2ldap <basedn> [<config object base>]
DESCRIPTION
confdb2ldif reads the cluster configuration from the openais object database and generates an LDIF file suitable for importing into an LDAP
database. The LDIF file is written to standard output.
OPTIONS
<basedn>
This is the base DN of the LDAP server into which the configuration will be imported. confdb2ldif will create a "cn=cluster" object
below this to contain the cluster configuration. The base DN is usually derived from the host's domain name. So if the host is
ldapsrv.mycorp.com then the base DN could be dc=mycorp,dc=com.
[<config object base>]
Configuration object in the objdb to start from. This defaults to "cluster" and there should rarely be any need to change it.
COMMENTS
confdb2ldif uses the openais libconfdb to read the configuration. The default way to do this is run against a running aisexec to read the
live configuration. It is possible to generate an LDIF file from a non-running system by using the standalone feature of openais's lib-
confdb.
eg to read the configuration from /etc/cluster/cluster.conf, use the following command:
OPENAIS_DEFAULT_CONFIG_IFACE=xmlconfig:cmanpreconfig confdb2ldif dc=mycompany,dc=com
or to do it from CCS
OPENAIS_DEFAULT_CONFIG_IFACE=ccsconfig:cmanpreconfig confdb2ldif dc=mycompany,dc=com
The LDIF file is written to stdout and so can be saved or piped straight into ldapmodify if required.
It's important that the 99cluster.ldif schema file has been loaded into the LDAP server before adding the contents of this generated LDIF
file.
EXAMPLE
confdb2ldif dc=mycorp,dc=com | ldapmodify -x -a -D"cn=Directory Manager" -c -v -W
BUGS
confdb2ldif parses the cluster configuration without checking it against the loaded schema. So if there are attributes in the config file
that are not known to the schema, parts of the load will fail. It is important to check the results of feeding the output into ldapmodify.
In particular aisexec logging operations will not convert into LDIF because they rely on duplicate keys.
SEE ALSO
libconfdb(3), openais(8), cluster.conf(5)
confdb2ldif(8)