<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
	<title>%%LNG_QuestionImportTutorialTitle%%</title>

	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
	<link rel="icon" href="%%GLOBAL_faviconLink%%" />
	<link rel="stylesheet" href="styles/styles.css" type="text/css">

	<script language="JavaScript" type="text/javascript">

		function ShowHelp(img, title, desc)
		{
			div = document.createElement('div');
			div.id = 'help';

			div.style.display = 'inline';
			div.style.position = 'absolute';
			div.style.width = '170';


			div.style.backgroundColor = 'lightyellow';
			div.style.border = 'dashed 1px black';
			div.style.padding = '10px';
			div.innerHTML = '<b>' + title + '<\/b><br><img src="images/blank.gif" width="1" height="5" alt=""><br><div style="padding-left:10px; padding-right:5px;">' + desc + '<\/div>';

			img.parentNode.appendChild(div);
		}

		function HideHelp(img)
		{
			div = document.getElementById('help');
			img.parentNode.removeChild(div);
		}

	</script>

	<style type="text/css">
		body {
			padding: 0px;
			margin: 0px;
		}
	</style>

</head>

<body bgcolor="#ADAEAD" text="#000000">
<table width="100%" style="height: 100%">
<tr>
	<td>
	<!-- 100% Height Table -->
	<table border="0" style="height: 100%" width="100%" cellpadding="0" cellspacing="0">
	<tr>
		<td height="100%" valign="top">
			<img src="images/1x1.gif" width="1" height="10" alt=""><br>
			<table width="100%" align="center" border="0" cellspacing="0" cellpadding="0">
			<tr>
				<td width="15"><img src="images/lc2.gif" width="15" height="17" alt=""></td>
				<td width="100%"><img src="images/tbg2.gif" width="100%" height="17" alt=""></td>
				<td width="10"><img src="images/rc2.gif" width="15" height="17" alt=""></td>
			</tr>
			</table>
			<table width="100%" align="center" border="0" cellspacing="0" cellpadding="0" style="height: 100%">
			<tr>
				<td width="6" style="background-image: URL('images/l_bg.gif')"></td>
				<td bgcolor="#FFFFFF" class="body" style="padding:0px;" valign="top">
					<table>
					<tr>
						<td class="Main"></td>
						<td width="100%" align="right" style="padding-right:40px">
							<a href="javascript:window.close()" class="topLink">[x] %%LNG_Close%%</a>
						</td>
					</tr>
					</table>
					<table cellspacing="0" cellpadding="0" width="100%" bgcolor="white">
					<tr>
						<td valign="top" bgcolor="white" style="padding: 8px 20px 0px 50px" class="body">
							<!-- END PAGE HEADER -->
							<div class="heading1">%%LNG_QuestionImportTutorialTitle%%</div>
							<p>
							If you have existing questions that
							you'd like to import into Knowledgebase, then follow this tutorial.
							Firstly, you will need to export the questions
							from your other program. You should export
							your questions into a CSV (comma separated
							value) file. A CSV file will contain a list of your
							question details in a line-by-line format,
							such as:
								<blockquote style="white-space: nowrap">
								"Queston 1","This is the answer to question 1","meta keywords, install","meta description", 0, 1, 0<br />
								"Queston 2","This is the answer to question 2","meta keywords, sales","meta description", 0, 1, 0<br />
								"Queston 3","This is the answer to question 3","meta keywords, processing","meta description", 0, 1, 1<br />
								</blockquote>
							</p>

							<p>
							The example above includes three records, and each
							record is separated with a new line. Each record
							contains seven fields, and each field is separated
							with a comma. Some fields are also enclosed within
							double quote marks. The CSV file will typically
							have a .CSV or .TXT file extension. Start by
							clicking on the "Browse..." button in the form to
							select your CSV file from your hard drive.
							</p>

							<p>
							Next, you will need to choose the category or
							categories that you would like to import the questions
							into. In ActiveKB a question may appear in more than
							one category and by holding down select as you click
							on different categories or by dragging your mouse
							over several categories while holding the mouse
							button down, you can associate the question with
							multiple categories in one step.
							</p>

							<p>
							Some programs also give you the option to ouput a
							line containing field headers into your CSV file. If
							your CSV file contains a line of headers, it will
							look something like this:
								<blockquote style="white-space: nowrap;">
								"title","answer","metakeywords","metadescription","sortorder","visible","detectrelated"
								</blockquote>
							</p>

							<p>
							If this is the case, tick the "Contains Headers"
							checkbox. These headers will then be shown in step 2
							to help you decide which import fields to
							link to which question fields.
							</p>

							<p>The fields that you can import are as follows:
							<ul>
								<li><b>title</b> <span class="required">(required)</span> - The title of the question, with a maximum length of 255 letters.</li>
								<li><b>answer</b> <span class="required">(required)</span> - The answer to the question. This can be as long as you like and can also contain HTML formatting.</li>
								<li><b>metakeywords</b> - Keywords for the question. These get checked for searches and are placed inside the headers of the question page as the meta keyword tag for search engines. Keywords are separated by a comma.</b></li>
								<li><b>metadescription</b> - Description to put in the description meta tag of the page, used by search engines.</li>
								<li><b>sortorder</b> - The higher the number, the higher the result will appear when viewing the list of questions in a category. This can be any positive number. The default is 0.</li>
								<li><b>visible</b> - Is this question visible or not? If the value is 1 then it will be visible, otherwise it will be hidden. This can be either 0 or 1. The default is 1.</li>
								<li><b>detectrelated</b> - When viewing the question, do you want ActiveKB to try and find related questions automatically or do you want to manually specify related questions. This can be either 0 or 1. The default is 0 (Don't automatically detect related questions).</li>
							</ul>
							</p>

							<p>
							If one of your import fields
							contains commas, you can surround the field with double
							quotes, for example: "keyword1, keyword2, keyword3".
							</p>

							<p>
							If one of your fields has commas
							and double quote characters, you can still enclose the
							field in double quotes, however any double quote
							inside the field itself must be escaped with a backslash
							'\' character. For example "Click &lt;a href=\"#\"&gt;here&lt;/a&gt;, ok ?".
							</p>

							<p>
							Once you have completed the form, click next and you
							will be presented with a screen which lets you map
							fields in the import file into fields in the ActiveKB database. On the
							left you have the field in the database, and in a
							dropdown next to each one you can choose the field
							in your import file to associate with it. If you didn't
							put a column in for one of the fields (e.g. the
							visible field) then you can choose "Don't link it to
							anything" and it will use the defaults. Title and
							answer fields are required, however.
							</p>

							<p>
							When you are happy with your field associations, click next
							and the import will start. Once the import is finished
							you will see a summary of how many questions were
							imported. Congratulations, you are done.
							</p>
							<!-- START PAGE FOOTER -->
						</td>
					</tr>
					<tr>
						<td valign="top" style="padding-right:60" align="right">
							<a href="javascript:window.close()" class="topLink">%%LNG_Close%% &raquo;</a>
						</td>
					</tr>
					</table>
				</td>
				<td width="6" style="background-image: URL('images/r_bg.gif')"></td>
			</tr>
			</table>
			<br>
			<!-- 100% Height Table -->
		</td>
	</tr>
	<tr>
		<td valign="bottom">
			<!-- Do not delete -->
			<table width="100%" align="center" border="0" cellspacing="0" cellpadding="0">
			<tr>
				<td width="15" height="17"><img src="images/lcb.gif" width="15" height="17" alt=""></td>
				<td style="background-image: url('images/bbg.gif')" height="16"><img src="images/1x1.gif" width="1" height="1" alt=""></td>
				<td width="15" height="17"><img src="images/rcb.gif" width="15" height="17" alt=""></td>
			</tr>
			</table>
			<table class="PageFooter">
			<tr>
				<td>&nbsp;</td>
			</tr>
			</table>
			<!-- 100% Height Table -->
		</td>
	</tr>
	</table>
	<!-- Do not delete -->
	<!-- END PAGE FOOTER -->
	</td>
</tr>
</table>
</body>
</html>

