LDIF to CSV Example (Sort and Convert)

followed by

CSV to LDIF and XML Example (Filter, Sort, Convert)

---

LDIF to CSV Example (Sort and Convert)

Input File Excerpt (chiefs.dap):

Name: George
LastName: Washington
Year: 1789-1797
Party: FED
State: VA

...
FirstName: George
LastName: Bush
Year: 2001-2009
Party: REP
State: CT

CoSort SortCL Job Specification File: 
Converts LDIF File to CSV and Sorts

/INFILE=chiefs.dap
	/process=ldif
	/field=(FirstName, pos=1, sep='|')
	/field=(LastName, pos=2, sep='|')
	/field=(Year, pos=3, sep='|')
	/field=(Party, pos=4, sep='|')
	/field=(State, pos=5, sep='|')

/SORT
	/key=LastName

/OUTFILE=chiefs.csv
	/process=csv
	/field=(FirstName, pos=1, sep=',')
	/field=(LastName, pos=2, sep=',')
	/field=(Year, pos=3, sep=',')
	/field=(Party, pos=4, sep=',')
	/field=(State, pos=5, sep=',')

CSV Output File Excerpt (chiefs.csv):

FirstName,LastName,Year,Party,State
"John","Adams","1797-1801","FED","MA"

...
"Woodrow","Wilson","1913-1921","DEM","VA"

---

CSV to LDIF and XML Example (Filter, Sort, Convert)

Full CSV Input File (chiefs.csv):

FirstName,LastName,Year,Party,State
"John","Adams","1797-1801","FED","MA"
"John Quincy","Adams","1825-1829","D-R","MA"
"Chester A.","Arthur","1881-1885","REP","VT"
"James","Buchanan","1857-1861","DEM","PA"
"George H.W.","Bush","1989-1993","REP","MA"
"George W.","Bush","2001-2009","REP","CT"
"James E.","Carter","1977-1981","DEM","GA"
"Grover","Cleveland","1885-1889","DEM","NJ"
"Grover","Cleveland","1893-1897","DEM","NJ"
"William J.","Clinton","1993-2001","DEM","AR"
"Calvin","Coolidge","1923-1929","REP","VT"
"Dwight D.","Eisenhower","1953-1961","REP","TX"
"Millard","Fillmore","1850-1853","WHG","NY"
"Gerald R.","Ford","1973-1977","REP","NB"
"James A.","Garfield","1881-1881","REP","OH"
"Ulysses S.","Grant","1869-1877","REP","OH"
"Warren G.","Harding","1921-1923","REP","OH"
"William Henry","Harrison","1841-1841","WHG","VA"
"Benjamin","Harrison","1889-1893","REP","OH"
"Rutherford B.","Hayes","1877-1881","REP","OH"
"Herbert C.","Hoover","1929-1933","REP","IA"
"Andrew","Jackson","1829-1837","DEM","SC"
"Thomas","Jefferson","1801-1809","D-R","VA"
"Lyndon B.","Johnson","1963-1969","DEM","TX"
"Andrew","Johnson","1865-1869","REP","NC"
"John F.","Kennedy","1961-1963","DEM","MA"
"Abraham","Lincoln","1861-1865","REP","KY"
"James","Madison","1809-1817","D-R","VA"
"William","McKinley","1897-1901","REP","OH"
"James","Monroe","1817-1825","D-R","VA"
"Richard M.","Nixon","1969-1973","REP","CA"
"Franklin","Pierce","1853-1857","DEM","NH"
"James K.","Polk","1845-1849","DEM","NC"
"Ronald W.","Reagan","1981-1989","REP","IL"
"Theodore","Roosevelt","1901-1909","REP","NY"
"Franklin D.","Roosevelt","1933-1945","DEM","NY"
"William H.","Taft","1909-1913","REP","OH"
"Zachary","Taylor","1849-1850","WHG","VA"
"Harry S.","Truman","1945-1953","DEM","MI"
"John","Tyler","1841-1845","WHG","VA"
"Martin","Van Buren","1837-1841","DEM","NY"
"George","Washington","1789-1797","FED","VA"
"Woodrow","Wilson","1913-1921","DEM","VA" 

CoSort SortCL Job Specification File:
Filters, Sorts, and Converts CSV File to LDIF and XML Files

/INFILE=chiefs.csv
	/process=csv
	/field=(FirstName, pos=1, sep=',')
	/field=(LastName, pos=2, sep=',')
	/field=(Year, pos=3, sep=',')
	/field=(Party, pos=4, sep=',')
	/field=(State, pos=5, sep=',')
	/include where State EQ "NY"

/SORT
  /key=Party
  /key=LastName
/OUTFILE=chiefs2.dap
	/process=ldif
	/field=(LastName, pos=1)
	/field=(FirstName, pos=2)
	/field=(Year, pos=3)
	/field=(Party, pos=4)
	/field=(State, pos=5)
/OUTFILE=chiefs2.xml
	/process=xml
	/field=(Year,POS=2,SEP='|',XDEF="/chiefs/chief/term")
	/field=(LastName,POS=2,SEP='|',XDEF="/chiefs/chief@president")
	/field=(state,POS=3,SEP='|',XDEF="/chiefs/chief/state")
	/field=(party,POS=4,SEP='|',XDEF="/chiefs/chief/party")


Filtered, Sorted, & Converted Output LDIF File (chiefs2.dap)

LastName: 
Roosevelt
FirstName: Franklin D.
Year: 1933-1945
Party: DEM
State: NY
LastName: Van Buren
FirstName: Martin
Year: 1837-1841
Party: DEM
State: NY

LastName: Roosevelt
FirstName: Theodore
Year: 1901-1909
Party: REP
State: NY
LastName: Fillmore
FirstName: Millard
Year: 1850-1853
Party: WHG
State: NY

Filtered, Sorted, & Converted Output XML File (chiefs2.xml): 

<?xml version="1.0" encoding="UTF-8" 
  standalone="yes" ?>
<chiefs>
	<chief president="Roosevelt"><term>1933-1945</term><state>NY</state><party>DEM</party></chief>
	<chief president="Van Buren"><term>1837-1841</term><state>NY</state><party>DEM</party></chief>
	<chief president="Roosevelt"><term>1901-1909</term><state>NY</state><party>REP</party></chief>
	<chief president="Fillmore"><term>1850-1853</term><state>NY</state><party>WHG</party></chief>
</chiefs>