<!--
  Licensed to the Apache Software Foundation (ASF) under one
  or more contributor license agreements.  See the NOTICE file
  distributed with this work for additional information
  regarding copyright ownership.  The ASF licenses this file
  to you under the Apache License, Version 2.0 (the
  "License"); you may not use this file except in compliance
  with the License.  You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

  Unless required by applicable law or agreed to in writing,
  software distributed under the License is distributed on an
  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  KIND, either express or implied.  See the License for the
  specific language governing permissions and limitations
  under the License.
-->
<section id="tools_excelexport_wizard">
	<title>Excel Export wizard</title>
	<para>This wizard is used to export entries to Excel files.</para>
	<para>
		To start the wizard choose one of the following options:
		<itemizedlist>
			<listitem>
				<para>
					In the LDAP Browser view select an entry or a search
					and choose
					<emphasis role="strong">
						Export >
						<inlinemediaobject>
							<imageobject>
								<imagedata scale="50"
									fileref="icons/export_xls.gif" format="GIF" />
							</imageobject>
						</inlinemediaobject>
						Excel Export...
					</emphasis>
					from context menu.
				</para>
			</listitem>
			<listitem>
				<para>
					In the Connections view select a connection and
					choose
					<emphasis role="strong">
						Export >
						<inlinemediaobject>
							<imageobject>
								<imagedata scale="50"
									fileref="icons/export_xls.gif" format="GIF" />
							</imageobject>
						</inlinemediaobject>
						Excel Export...
					</emphasis>
					from context menu.
				</para>
			</listitem>
			<listitem>
				<para>
					In the Workbench menu bar select
					<emphasis role="strong">File > Export...</emphasis>
					and choose
					<emphasis role="strong">
						<inlinemediaobject>
							<imageobject>
								<imagedata scale="50"
									fileref="icons/export_xls.gif" format="GIF" />
							</imageobject>
						</inlinemediaobject>
						LDAP to Excel
					</emphasis>
					.
				</para>
			</listitem>
		</itemizedlist>
	</para>


	<simplesect id="tools_excelexport_wizard_1">
		<title>Data to Export</title>
		<para>
			On the Data to Export page you have to specify which
			entries and attributes to export. 
		</para>

		<para>
			The layout of the page is similar to the 
			<link
				linkend="tools_search_dialog">
				LDAP Search page
			</link>
			. In the <emphasis role="strong">Returning Attributes</emphasis> section
			you can also choose the following option:
		</para>

		<para>
			<informaltable frame="all">
				<tgroup cols="3">
					<colspec colname="Option" colwidth="1*" />
					<colspec colname="Description" colwidth="1*" />
					<colspec colname="Default" colwidth="1*" />
					<thead>
						<row>
							<entry>Option</entry>
							<entry>Description</entry>
							<entry>Default</entry>
						</row>
					</thead>
					<tbody>
						<row>
							<entry>Export DN</entry>
							<entry>
								Exports the distinguished name as first column in the Excel file.
							</entry>
							<entry>on</entry>
						</row>
						<row>
							<entry>All user attributes</entry>
							<entry>
								Exports all user attributes.
							</entry>
							<entry>on if the Returning Attributes field is empty</entry>
						</row>
						<row>
							<entry>
								Operational attributes
							</entry>
							<entry>
								Exports all operational attributes.
							</entry>
							<entry>off</entry>
						</row>
					</tbody>
				</tgroup>
			</informaltable>
		</para>
	</simplesect>

	<simplesect id="tools_excelexport_wizard_2">
		<title>Excel File</title>
		<para>
			On the Excel File page you have to select the target Excel file.
		</para>
		<para>
			<screenshot>
				<mediaobject>
					<imageobject>
						<imagedata scale="50"
							fileref="images/tools_excelexport_wizard_1.png" format="PNG" />
					</imageobject>
				</mediaobject>
			</screenshot>
		</para>
		<para>
			<informaltable frame="all">
				<tgroup cols="3">
					<colspec colname="Option" colwidth="1*" />
					<colspec colname="Description" colwidth="2*" />
					<colspec colname="Default" colwidth="1*" />
					<thead>
						<row>
							<entry>Option</entry>
							<entry>Description</entry>
							<entry>Default</entry>
						</row>
					</thead>
					<tbody>
						<row>
							<entry>Excel File</entry>
							<entry>
								The Excel file to export to. Type in the
								full path or
								<emphasis role="strong">
									Browse...
								</emphasis>
								to select the path on the file system.
								The drop-down list provides a history of
								recently used files.
							</entry>
							<entry>empty</entry>
						</row>
						<row>
							<entry>Overwrite existing Excel file</entry>
							<entry>
								If the export file already exist, you
								must permit to overwrite the file.
							</entry>
							<entry>off</entry>
						</row>
						<row>
							<entry>Text Formats</entry>
							<entry>
								Opens the
								<link
									linkend="preferences_text_formats">
									Text Formats preferences
								</link>
								where you could modify the Excel format.
							</entry>
							<entry>-</entry>
						</row>
					</tbody>
				</tgroup>
			</informaltable>
		</para>
	</simplesect>
	
</section>