Index: trunk/kernel/admin_templates/incs/script.js
===================================================================
diff -u -N -r3299 -r3543
--- trunk/kernel/admin_templates/incs/script.js	(.../script.js)	(revision 3299)
+++ trunk/kernel/admin_templates/incs/script.js	(.../script.js)	(revision 3543)
@@ -464,11 +464,261 @@
 	{
 		if ( $kf.elements[i].id.match($cb_mask) )
 		{
-//			alert('found:' + $kf.elements[i].id);
 			if ($kf.elements[i].checked) $tmp += '|'+$kf.elements[i].value;
 		}
 	}
 	if($tmp.length > 0) $tmp += '|';
 	document.getElementById($hidden_id).value = $tmp.replace(/,$/, '');
-//	alert('field: '+$hidden_id+' = '+document.getElementById($hidden_id).value );
-}
\ No newline at end of file
+}
+
+// related to lists operations (moving)
+
+	
+	
+	function move_selected($from_list, $to_list)
+	{
+		if (typeof($from_list) != 'object') $from_list = document.getElementById($from_list);
+		if (typeof($to_list) != 'object') $to_list = document.getElementById($to_list);
+			
+		if (has_selected_options($from_list))
+		{
+			var $from_array = select_to_array($from_list);
+			var $to_array = select_to_array($to_list);
+			var $new_from = Array();
+			var $cur = null;
+			
+			for (var $i = 0; $i < $from_array.length; $i++)
+			{
+				$cur = $from_array[$i];
+				if ($cur[2]) // If selected - add to To array
+				{ 
+					$to_array[$to_array.length] = $cur;
+				}
+				else //Else - keep in new From
+				{ 
+					$new_from[$new_from.length] = $cur;
+				}
+			}
+			
+			$from_list = array_to_select($new_from, $from_list);
+			$to_list = array_to_select($to_array, $to_list);
+		}
+		else
+		{
+			alert('Please select items to perform moving!');
+		}
+	}
+	
+	function select_to_array($aSelect)
+	{
+		var $an_array = new Array();
+		var $cur = null;
+		
+		for (var $i = 0; $i < $aSelect.length; $i++)
+		{
+			$cur = $aSelect.options[$i];
+			$an_array[$an_array.length] = new Array($cur.text, $cur.value, $cur.selected);
+		}
+		return $an_array;
+	}
+	
+	function array_to_select($anArray, $aSelect)
+	{
+		var $initial_length = $aSelect.length;
+		for (var $i = $initial_length - 1; $i >= 0; $i--)
+		{
+			$aSelect.options[$i] = null;
+		}
+			
+		for (var $i = 0; $i < $anArray.length; $i++)
+		{
+			$cur = $anArray[$i];
+			$aSelect.options[$aSelect.length] = new Option($cur[0], $cur[1]);
+		}
+	}
+	
+	function select_compare($a, $b)
+	{
+		if ($a[0] < $b[0])
+			return -1;
+		if ($a[0] > $b[0])
+			return 1;
+		return 0;
+	}
+	
+	function select_to_string($aSelect)
+	{
+		var $result = '';
+		var $cur = null;
+		
+		if (typeof($aSelect) != 'object') $aSelect = document.getElementById($aSelect);
+		
+		for (var $i = 0; $i < $aSelect.length; $i++)
+		{
+			$result += $aSelect.options[$i].value + '|';
+		}
+		
+		return $result.length ? '|' + $result : '';
+	}
+	
+	function selected_to_string($aSelect)
+	{
+		var $result = '';
+		var $cur = null;
+		
+		if (typeof($aSelect) != 'object') $aSelect = document.getElementById($aSelect);
+		
+		for (var $i = 0; $i < $aSelect.length; $i++)
+		{
+			$cur = $aSelect.options[$i];
+			if ($cur.selected && $cur.value != '')
+			{
+				$result += $cur.value + '|';
+			}
+		}
+		
+		return $result.length ? '|' + $result : '';
+	}
+	
+	function string_to_selected($str, $aSelect)
+	{
+		var $cur = null;
+		for (var $i = 0; i < $aSelect.length; $i++)
+		{
+			$cur = $aSelect.options[$i];
+			$aSelect.options[$i].selected = $str.match(',' + $cur.value + ',') ? true : false;
+		}
+	}
+	
+	function set_selected($selected_options, $aSelect)
+	{
+		if (!$selected_options.length) return false;
+		
+		for (var $i = 0; $i < $aSelect.length; $i++)
+		{
+			for (var $k = 0; $k < $selected_options.length; $k++)
+			{
+				if ($aSelect.options[$i].value == $selected_options[$k])
+				{
+					$aSelect.options[$i].selected = true;
+				}
+			}
+		}
+	}
+	
+	function get_selected_count($theList)
+	{
+		var $count = 0;
+		var $cur = null;
+		for (var $i = 0; $i < $theList.length; $i++)
+		{
+			$cur = $theList.options[$i];
+			if ($cur.selected) $count++;
+		}
+		return $count;
+	}
+	
+	function get_selected_index($aSelect, $typeIndex)
+	{
+		var $index = 0;
+		for (var $i = 0; $i < $aSelect.length; $i++)
+		{
+			if ($aSelect.options[$i].selected)
+			{
+				$index = $i;
+				if ($typeIndex == 'firstSelected') break;
+			}
+		}
+		return $index;
+	}
+	
+	function has_selected_options($theList)
+	{
+		var $ret = false;
+		var $cur = null;
+		
+		for (var $i = 0; $i < $theList.length; $i++)
+		{
+			$cur = $theList.options[$i];
+			if ($cur.selected) $ret = true;
+		}
+		return $ret;
+	}
+	
+	function select_sort($aSelect)
+	{
+		if (typeof($aSelect) != 'object') $aSelect = document.getElementById($aSelect);
+		
+		var $to_array = select_to_array($aSelect);
+		$to_array.sort(select_compare);
+		array_to_select($to_array, $aSelect);
+	}
+	
+	function move_options_up($aSelect, $interval)
+	{
+		if (typeof($aSelect) != 'object') $aSelect = document.getElementById($aSelect);
+		
+		if (has_selected_options($aSelect))
+		{
+			var $selected_options = Array();
+			var $first_selected = get_selected_index($aSelect, 'firstSelected');
+			
+			for (var $i = 0; $i < $aSelect.length; $i++)
+			{
+				if ($aSelect.options[$i].selected && ($first_selected > 0) )
+				{
+					swap_options($aSelect, $i, $i - $interval);
+					$selected_options[$selected_options.length] = $aSelect.options[$i - $interval].value;
+				}
+				else if ($first_selected == 0)
+				{
+					alert('Begin of list');
+					break;
+				}			
+			}
+			set_selected($selected_options, $aSelect);
+		}
+		else
+		{
+			alert('Check items from moving');
+		}
+	}
+		
+	function move_options_down($aSelect, $interval)
+	{
+		if (typeof($aSelect) != 'object') $aSelect = document.getElementById($aSelect);
+				
+		if (has_selected_options($aSelect))
+		{
+			var $last_selected = get_selected_index($aSelect, 'lastSelected');
+			var $selected_options = Array();
+			
+			for (var $i = $aSelect.length - 1; $i >= 0; $i--)
+			{
+				if ($aSelect.options[$i].selected && ($aSelect.length - ($last_selected + 1) > 0))
+				{
+					swap_options($aSelect, $i, $i + $interval);
+					$selected_options[$selected_options.length] = $aSelect.options[$i + $interval].value;
+				}
+				else if ($last_selected + 1 == $aSelect.length)
+				{
+					alert('End of list');
+					break;
+				}
+			}
+			set_selected($selected_options, $aSelect);
+		}
+		else
+		{
+			alert('Check items from moving');
+		}
+	}
+	
+	function swap_options($aSelect, $src_num, $dst_num)
+	{
+		var $src_option = new Option($aSelect.options[$src_num].innerHTML, $aSelect.options[$src_num].value);
+		var $dst_option = new Option($aSelect.options[$dst_num].innerHTML, $aSelect.options[$dst_num].value);
+		
+		$aSelect.options[$src_num] = $dst_option;
+		$aSelect.options[$dst_num] = $src_option;
+	}
\ No newline at end of file
Index: trunk/core/kernel/db/dbitem.php
===================================================================
diff -u -N -r3282 -r3543
--- trunk/core/kernel/db/dbitem.php	(.../dbitem.php)	(revision 3282)
+++ trunk/core/kernel/db/dbitem.php	(.../dbitem.php)	(revision 3543)
@@ -135,12 +135,14 @@
 	 */
 	function SetError($field, $pseudo, $error_label = '')
 	{
-		$error_msg = $this->Application->Phrase($error_label);
-		if( !($error_msg && getArrayValue($this->ErrorMsgs,$pseudo)) )
+		$error_field = isset($this->Fields[$field]['error_field']) ? $this->Fields[$field]['error_field'] : $field;
+		$this->FieldErrors[$error_field]['pseudo'] = $pseudo;
+		
+		$error_msg = $error_label ? $this->Application->Phrase($error_label) : '';
+		if ($error_label && !getArrayValue($this->ErrorMsgs, $pseudo))
 		{
 			$this->ErrorMsgs[$pseudo] = $error_msg;
 		}
-		$this->FieldErrors[$field]['pseudo'] = $pseudo;
 	}
 	
 	/**
Index: trunk/admin/include/mainscript.js
===================================================================
diff -u -N -r3145 -r3543
--- trunk/admin/include/mainscript.js	(.../mainscript.js)	(revision 3145)
+++ trunk/admin/include/mainscript.js	(.../mainscript.js)	(revision 3543)
@@ -153,6 +153,31 @@
 	if(\$window.parent) \$window = \$window.parent;
 	\$window.document.title = (main_title.length ? main_title + ' - ' : '') + \$title;
 }
+
+// sets hidden field value
+// if the field does not exist - creates it
+function set_hidden_field(\$field_id, \$value)
+{
+//	alert('form: '+\$form_prefix+'_form');
+
+	var \$kf = document.getElementById(\$form_prefix+'_form');
+	var \$field = \$kf.elements[\$field_id];
+	if(\$field)
+	{
+		\$field.value = \$value;
+		return true;
+	}
+
+	\$field = document.createElement('INPUT');
+	\$field.type = 'hidden';
+	\$field.name = \$field_id;
+	\$field.id = \$field_id;
+	\$field.value = \$value;
+
+	\$kf.appendChild(\$field);
+	return false;
+}
+
 var env = "$env2";
 </script>
 
Index: trunk/core/kernel/event_manager.php
===================================================================
diff -u -N -r3374 -r3543
--- trunk/core/kernel/event_manager.php	(.../event_manager.php)	(revision 3374)
+++ trunk/core/kernel/event_manager.php	(.../event_manager.php)	(revision 3543)
@@ -23,7 +23,7 @@
 		 *
 		 * @var Array
 		 */
-		var $queryMaps=Array();
+		var $queryMaps = Array();
 
 		/**
 		 * Build events registred for
@@ -85,9 +85,9 @@
 		 */
 		function setQueryMaps($new_query_maps)
 		{
-			$this->queryMaps=$new_query_maps;
+			$this->queryMaps = $new_query_maps;
 		}
-
+		
 		/**
 		 * Registers new regular event
 		 *
Index: trunk/kernel/module_help/visits_list.txt
===================================================================
diff -u -N -r2976 -r3543
--- trunk/kernel/module_help/visits_list.txt	(.../visits_list.txt)	(revision 2976)
+++ trunk/kernel/module_help/visits_list.txt	(.../visits_list.txt)	(revision 3543)
@@ -1,24 +1,24 @@
-<span style="font-weight: bold;">Visits (In-portal Platform)<br/>
-<br/>
-</span>This section displays the log of all visits to your website. The visit is recorded when a user comes to your site. If the user logs in during his or her visit, the username will be updated in the visit record. If the user&rsquo;s session expires during the visit, a new visit record will be created when he or she comes back to the site. <br/>
-The grid on this page displays the following columns:<br/>
-<ul>
-    <li>Visit Date &ndash; Date and Time of the visit&rsquo;s start</li>
-    <li>IP Address &ndash; the IP address of the visitor, as identified by the web server</li>
-    <li>Referrer &ndash; the URL the visitor came from, as reported by visitor&rsquo;s browser </li>
-    <li>Username &ndash; the username of the visitor if he or she logs in during the visit</li>
-</ul>
-<br/>
-<span style="font-weight: bold;">Visits (with In-commerce installed)<br/>
-<br/>
-</span>This section displays the log of all visits to your website. The visit is recorded when user comes to your site. If the user logs in during his or her visit, the username will be updated in the visit record. If the user&rsquo;s session expires during the visit, a new visit record will be created when he or she comes back to the site. <br/>
-The grid on this page displays the following columns:<br/>
-<ul>
-    <li>Visit Date &ndash; Date and Time of the visit&rsquo;s start</li>
-    <li>IP Address &ndash; the IP address of the visitor, as identified by the web server</li>
-    <li>Referrer &ndash; the URL the visitor came from, as reported by visitor&rsquo;s browser </li>
-    <li>Username &ndash; the username of the visitor if he or she logs in during the visit</li>
-    <li>Affiliate User &ndash; the username of affiliate who has referred the visitor</li>
-    <li>Order Total &ndash; the total amount of the orders made during this visit</li>
-    <li>Affiliate Commission &ndash; amount of affiliate commission received for the orders made during the visit</li>
+<span style="font-weight: bold;">Visits (In-portal Platform)<br/>
+<br/>
+</span>This section displays the log of all visits to your website. The visit is recorded when a user comes to your site. If the user logs in during his or her visit, the username will be updated in the visit record. If the user&rsquo;s session expires during the visit, a new visit record will be created when he or she comes back to the site. <br/>
+The grid on this page displays the following columns:<br/>
+<ul>
+    <li>Visit Date &ndash; Date and Time of the visit&rsquo;s start</li>
+    <li>IP Address &ndash; the IP address of the visitor, as identified by the web server</li>
+    <li>Referrer &ndash; the URL the visitor came from, as reported by visitor&rsquo;s browser </li>
+    <li>Username &ndash; the username of the visitor if he or she logs in during the visit</li>
+</ul>
+<br/>
+<span style="font-weight: bold;">Visits (with In-commerce installed)<br/>
+<br/>
+</span>This section displays the log of all visits to your website. The visit is recorded when user comes to your site. If the user logs in during his or her visit, the username will be updated in the visit record. If the user&rsquo;s session expires during the visit, a new visit record will be created when he or she comes back to the site. <br/>
+The grid on this page displays the following columns:<br/>
+<ul>
+    <li>Visit Date &ndash; Date and Time of the visit&rsquo;s start</li>
+    <li>IP Address &ndash; the IP address of the visitor, as identified by the web server</li>
+    <li>Referrer &ndash; the URL the visitor came from, as reported by visitor&rsquo;s browser </li>
+    <li>Username &ndash; the username of the visitor if he or she logs in during the visit</li>
+    <li>Affiliate User &ndash; the username of affiliate who has referred the visitor</li>
+    <li>Order Total &ndash; the total amount of the orders made during this visit</li>
+    <li>Affiliate Commission &ndash; amount of affiliate commission received for the orders made during the visit</li>
 </ul>
\ No newline at end of file
Index: trunk/kernel/units/general/cat_dbitem_export.php
===================================================================
diff -u -N
--- trunk/kernel/units/general/cat_dbitem_export.php	(revision 0)
+++ trunk/kernel/units/general/cat_dbitem_export.php	(revision 3543)
@@ -0,0 +1,848 @@
+<?php
+
+	define('EXPORT_STEP', 200); // export by 200 items (e.g. links)
+	define('IMPORT_CHUNK', 50120); // 5 KB
+	
+	class kCatDBItemExportHelper extends kHelper {
+		
+		
+		var $cache = Array();
+		
+		var $exportFields = Array();
+		
+		/**
+		 * Export options
+		 *
+		 * @var Array
+		 */
+		var $exportOptions = Array();
+		
+		/**
+		 * If we have custom fields in export
+		 *
+		 * @var unknown_type
+		 */
+		var $hasCustomFields = false;
+		
+		/**
+		 * Custom field values for last item beeing exported
+		 *
+		 * @var Array
+		 */
+		var $customValues = Array();
+		
+		/**
+		 * Item beeing currenly exported
+		 *
+		 * @var kCatDBItem
+		 */
+		var $curItem = null;
+		
+		/**
+		 * Dummy category object
+		 *
+		 * @var CategoriesItem
+		 */
+		var $dummyCategory = null;
+		
+		/**
+		 * Pointer to opened file
+		 *
+		 * @var resource
+		 */
+		var $filePointer = null;
+		
+		/**
+		 * Returns value from cache if found or false otherwise
+		 *
+		 * @param string $type
+		 * @param int $key
+		 * @return mixed
+		 */
+		function getFromCache($type, $key)
+		{
+			return getArrayValue($this->cache, $type, $key);
+		}
+		
+		/**
+		 * Adds value to be cached
+		 *
+		 * @param string $type
+		 * @param int $key
+		 * @param mixed $value
+		 */
+		function addToCache($type, $key, $value)
+		{
+//			if (!isset($this->cache[$type])) $this->cache[$type] = Array();
+			$this->cache[$type][$key] = $value;
+		}
+		
+		/**
+		 * Fill required fields with dummy values
+		 *
+		 * @param kEvent $event
+		 */
+		function fillRequiredFields(&$event)
+		{
+			$object =& $event->getObject();
+			
+			$fields = array_keys($object->Fields);
+			foreach ($fields as $field_name)
+			{
+				$field_options =& $object->Fields[$field_name];
+				if (isset($object->VirtualFields[$field_name]) || !getArrayValue($field_options, 'required') ) continue;
+				
+				$formatter_class = getArrayValue($field_options, 'formatter');
+				if ($formatter_class) // not tested
+				{
+					$formatter =& $this->Application->recallObject($formatter_class);
+					$sample_value = $formatter->GetSample($field_name, $field_options, $object);
+				}
+				$object->SetDBField($field_name, isset($sample_value) && $sample_value ? $sample_value : 'dummy');
+			}
+		}
+		
+		/**
+		 * Verifies that all user entered export params are correct
+		 *
+		 * @param kEvent $event
+		 */
+		function verifyOptions(&$event)
+		{
+			if ($this->Application->RecallVar($event->getPrefixSpecial().'_ForceNotValid'))
+			{
+				$this->Application->StoreVar($event->getPrefixSpecial().'_ForceNotValid', 0);
+				return false;
+			}
+			
+			$this->fillRequiredFields($event);
+			
+			$object =& $event->getObject();
+			$cross_unique_fields = Array('FieldsSeparatedBy', 'FieldsEnclosedBy');
+			if (($object->GetDBField('CategoryFormat') == 1) || ($event->Special == 'import')) // in one field
+			{
+				$object->setRequired('CategorySeparator', true);
+				$cross_unique_fields[] = 'CategorySeparator';
+			}
+			
+			$ret = $object->Validate();
+			
+			// check if cross unique fields has no same values
+			foreach ($cross_unique_fields as $field_index => $field_name)
+			{
+				if (getArrayValue($object->FieldErrors, $field_name, 'pseudo') == 'required') continue;
+				
+				$check_fields = $cross_unique_fields;
+				unset($check_fields[$field_index]);
+				
+				foreach ($check_fields as $check_field)
+				{
+					if ($object->GetDBField($field_name) == $object->GetDBField($check_field))
+					{
+						$object->SetError($check_field, 'unique');
+					}
+				}
+			}
+			
+			if ($event->Special == 'import')
+			{
+				$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
+				
+				$automatic_fields = ($object->GetDBField('FieldTitles') == 1);
+				$object->setRequired('ExportColumns', !$automatic_fields);
+				$category_prefix = '__CATEGORY__';
+				if ( $automatic_fields && ($this->exportOptions['SkipFirstRow']) ) {
+					$this->openFile($event);
+					$this->exportOptions['ExportColumns'] = $this->readRecord();
+					$this->closeFile();
+					
+					// remove additional (non-parseble columns)
+					foreach ($this->exportOptions['ExportColumns'] as $field_index => $field_name) {
+						if (!$this->validateField($field_name, $object)) {
+							unset($this->exportOptions['ExportColumns'][$field_index]);
+						}
+					}
+					$category_prefix = '';
+				}
+				
+				// 1. check, that we have column definitions
+				if (!$this->exportOptions['ExportColumns']) {
+					$object->setError('ExportColumns', 'required');
+					$ret = false;
+				}
+				
+				// 2. check, that we have only mixed category field or only separated category fields
+				$category_found['mixed'] = false;
+				$category_found['separated'] = false;
+			
+				foreach ($this->exportOptions['ExportColumns'] as $import_field) {
+					if (preg_match('/^'.$category_prefix.'Category(Path|[0-9]+)/', $import_field, $rets)) {
+						$category_found[$rets[1] == 'Path' ? 'mixed' : 'separated'] = true;
+					}
+				}
+				if ($category_found['mixed'] && $category_found['separated']) {
+					$object->SetError('ExportColumns', 'unique_category', 'la_error_unique_category_field');
+					$ret = false;
+				}
+				
+				// 3. check, that duplicates check fields are selected & present in imported fields
+				if ($this->exportOptions['ReplaceDuplicates']) {
+					if ($this->exportOptions['CheckDuplicatesMethod'] == 1) {
+						$check_fields = Array($object->IDField);
+					}
+					else {
+						$check_fields = $this->exportOptions['DuplicateCheckFields'] ? explode('|', substr($this->exportOptions['DuplicateCheckFields'], 1, -1)) : Array();
+					}
+					
+					if (!$check_fields) {
+						$object->setError('CheckDuplicatesMethod', 'required');
+						$ret = false;
+					}
+					else {
+						foreach ($check_fields as $check_field) {
+							if (!in_array($check_field, $this->exportOptions['ExportColumns'])) {
+								$object->setError('ExportColumns', 'required');
+								$ret = false;
+								break;
+							}
+						}
+					}
+				}
+			}
+			
+			return $ret;
+		}
+		
+		/**
+		 * Returns filename to read import data from
+		 *
+		 * @return string
+		 */
+		function getImportFilename()
+		{
+			if ($this->exportOptions['ImportSource'] == 1)
+			{
+				$ret = $this->exportOptions['ImportFilename']['name'];
+			}
+			else {
+				$ret = $this->exportOptions['ImportLocalFilename'];
+			}
+			return EXPORT_PATH.'/'.$ret;
+		}
+		
+		/**
+		 * Returns filename to write export data to
+		 *
+		 * @return string
+		 */
+		function getExportFilename()
+		{
+			return EXPORT_PATH.'/'.$this->exportOptions['ExportFilename'].'.'.$this->getFileExtension();
+		}
+		
+		/**
+		 * Opens file required for export/import operations
+		 *
+		 * @param kEvent $event
+		 */
+		function openFile(&$event)
+		{
+			if ($event->Special == 'export') {
+				$write_mode = ($this->exportOptions['start_from'] == 0) ? 'w' : 'a';
+				$this->filePointer = fopen($this->getExportFilename(), $write_mode);
+			}
+			else {
+				$this->filePointer = fopen($this->getImportFilename(), 'r');
+			}
+		}
+		
+		/**
+		 * Closes opened file
+		 *
+		 */
+		function closeFile()
+		{
+			fclose($this->filePointer);
+		}
+		
+		function getExportSQL($count_only = false)
+		{
+			if ($this->exportOptions['export_ids'] === false)
+			{
+				// get links from current category & all it's subcategories
+				$sql = 'SELECT item_table.*, ci.CategoryId
+						FROM '.$this->curItem->TableName.' item_table
+						LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = item_table.ResourceId
+						LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
+						WHERE ';
+				
+				if ($this->exportOptions['export_cats_ids'][0] == 0)
+				{
+					$sql .= '1';
+				}
+				else {
+					foreach ($this->exportOptions['export_cats_ids'] as $category_id) {
+						$sql .= '(c.ParentPath LIKE "%|'.$category_id.'|%") OR ';
+					}
+					$sql = preg_replace('/(.*) OR $/', '\\1', $sql);
+				}
+				
+				$sql .= ' ORDER BY ci.PrimaryCat DESC'; // NEW
+			}
+			else {
+				// get only selected links
+				$sql = 'SELECT item_table.*, '.$this->exportOptions['export_cats_ids'][0].' AS CategoryId
+						FROM '.$this->curItem->TableName.' item_table
+						WHERE '.$this->curItem->IDField.' IN ('.implode(',', $this->exportOptions['export_ids']).')';
+			}
+			
+			if (!$count_only)
+			{
+				$sql .= ' LIMIT '.$this->exportOptions['start_from'].','.EXPORT_STEP;
+			}
+			else {
+				$sql = preg_replace("/^.*SELECT(.*?)FROM(?!_)/is", "SELECT COUNT(*) AS count FROM ", $sql);
+			}
+			
+			return $sql;
+		}
+		
+		/**
+		 * Enter description here...
+		 *
+		 * @param kEvent $event
+		 */
+		function performExport(&$event)
+		{
+			$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
+			$this->exportFields = $this->exportOptions['ExportColumns'];
+			$this->curItem =& $event->getObject( Array('skip_autoload' => true) );
+			
+			$this->openFile($event);
+			
+			if ($this->exportOptions['start_from'] == 0) // first export step
+			{
+				if ($this->exportOptions['IsBaseCategory'] ) {
+					$sql = 'SELECT CachedNavbar
+							FROM '.TABLE_PREFIX.'Category
+							WHERE CategoryId = '.$this->Application->GetVar('m_cat_id');
+					$this->exportOptions['BaseLevel'] = substr_count($this->Conn->GetOne($sql), '>') + 1; // level to cut from other categories
+				}
+				
+				// 1. export field titles if required
+				if ($this->exportOptions['IncludeFieldTitles'])
+				{
+					$data_array = Array();
+					foreach ($this->exportFields as $export_field)
+					{
+						$data_array = array_merge($data_array, $this->getFieldCaption($export_field));
+					}
+					$this->writeRecord($data_array);
+				}
+				$this->exportOptions['total_records'] = $this->Conn->GetOne( $this->getExportSQL(true) );
+				$this->exportOptions['has_custom_fields'] = $this->scanCustomFields();
+			}
+			
+			$this->hasCustomFields = $this->exportOptions['has_custom_fields'];
+			
+			// 2. export data
+			$records = $this->Conn->Query( $this->getExportSQL() );
+			$records_exported = 0;
+			foreach ($records as $record_info) {
+				$this->curItem->SetDBFieldsFromHash($record_info);
+				if ($this->hasCustomFields)
+				{
+					$this->loadItemCustomFields();
+				}
+				
+				$data_array = Array();
+				foreach ($this->exportFields as $export_field)
+				{
+					$data_array =  array_merge($data_array, $this->getFieldValue($export_field) );
+				}
+				$this->writeRecord($data_array);
+				$records_exported++;
+			}
+			$this->closeFile();
+			
+			$this->exportOptions['start_from'] += $records_exported;
+			$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($this->exportOptions) );
+			
+			return $this->exportOptions;
+		}
+		
+		function getItemFields()
+		{
+			// just in case dummy user selected automtic mode & moved columns too :(
+			return array_merge($this->curItem->Fields['AvailableColumns']['options'], $this->curItem->Fields['ExportColumns']['options']);
+		}
+		
+		/**
+		 * Checks if field really belongs to importable field list
+		 *
+		 * @param string $field_name
+		 * @param kCatDBItem $object
+		 * @return bool
+		 */
+		function validateField($field_name, &$object)
+		{
+			// 1. convert custom field
+			$field_name = preg_replace('/^Custom_(.*)/', '__CUSTOM__\\1', $field_name);
+			
+			// 2. convert category field (mixed version & serparated version)
+			$field_name = preg_replace('/^Category(Path|[0-9]+)/', '__CATEGORY__Category\\1', $field_name);
+			
+			$valid_fields = $object->getPossibleExportColumns();
+			return isset($valid_fields[$field_name]);
+		}
+		
+		/**
+		 * Enter description here...
+		 *
+		 * @param kEvent $event
+		 */
+		function performImport(&$event)
+		{
+			if (!$this->exportOptions) {
+				// load import options in case if not previously loaded in verification function
+				$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
+			}
+			
+			$this->curItem =& $event->getObject( Array('skip_autoload' => true) );
+			
+			$backup_category_id = $this->Application->GetVar('m_cat_id');
+			$this->Application->SetVar('m_cat_id', (int)$this->Application->RecallVar('ImportCategory') );
+			
+			$this->openFile($event);
+			
+			$bytes_imported = 0;
+			if ($this->exportOptions['start_from'] == 0) // first export step
+			{
+				// 1st time run
+				if ($this->exportOptions['SkipFirstRow']) {
+					$this->readRecord();
+					$this->exportOptions['start_from'] = ftell($this->filePointer);
+					$bytes_imported = ftell($this->filePointer);
+				}
+				
+				$current_category_id = $this->Application->GetVar('m_cat_id');
+				if ($current_category_id > 0) {
+					$sql = 'SELECT ParentPath FROM '.TABLE_PREFIX.'Category WHERE CategoryId = '.$current_category_id;
+					$this->exportOptions['ImportCategoryPath'] = $this->Conn->GetOne($sql);
+				}
+				else {
+					$this->exportOptions['ImportCategoryPath'] = '';
+				}
+				$this->exportOptions['total_records'] = filesize($this->getImportFilename());
+			}
+			else {
+				$this->cache['new_ids']	= $this->exportOptions['new_ids_hash'];
+			}
+			$this->exportFields = $this->exportOptions['ExportColumns'];
+			$this->addToCache('category_parent_path', $this->Application->GetVar('m_cat_id'), $this->exportOptions['ImportCategoryPath']);
+			
+			// 2. import data
+			$this->dummyCategory =& $this->Application->recallObject('c.-tmpitem', 'c', Array('skip_autoload' => true));
+			fseek($this->filePointer, $this->exportOptions['start_from']);
+								
+			while (($bytes_imported < IMPORT_CHUNK) && !feof($this->filePointer)) {
+				$this->customValues = Array();
+				$data = $this->readRecord();
+				if ($data) {
+					foreach ($data as $field_index => $field_value) {
+						$this->setFieldValue($field_index, $field_value);	
+					}
+					$this->curItem->setID( $this->curItem->GetDBField($this->curItem->IDField) );
+					$this->processCurrentItem($event);
+				}
+				$bytes_imported = ftell($this->filePointer) - $this->exportOptions['start_from'];
+			}
+			
+			$this->closeFile();
+			$this->Application->SetVar('m_cat_id', $backup_category_id);
+			
+			$this->exportOptions['start_from'] += $bytes_imported;
+			$this->exportOptions['new_ids_hash'] = getArrayValue($this->cache, 'new_ids');
+			$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($this->exportOptions) );
+			
+			return $this->exportOptions;
+		}
+		
+		function setFieldValue($field_index, $value)
+		{
+			$field_name = $this->exportFields[$field_index];
+			
+			if (substr($field_name, 0, 7) == 'Custom_') {
+				$field_name = substr($field_name, 7);
+				$this->customValues[$field_name] = $value;
+			}
+			elseif ($field_name == 'CategoryPath') {
+				$this->curItem->CategoryPath = explode($this->exportOptions['CategorySeparator'], $value);
+			}
+			elseif (substr($field_name, 0, 8) == 'Category') {
+				$this->curItem->CategoryPath[ (int)substr($field_name, 8) ] = $value;
+			}
+			else {
+				$this->curItem->SetField($field_name, $value);
+			}
+		}
+		
+		/**
+		 * Returns temporary items for import procedures
+		 *
+		 * @param kEvent $event
+		 * @return kCatDBItem
+		 */
+		function &getTempItem(&$event)
+		{
+			return $this->Application->recallObject($event->Prefix.'.-tmpitem', $event->Prefix, Array('skip_autoload' => true));
+		}
+		
+		/**
+		 * Enter description here...
+		 *
+		 * @param kEvent $event
+		 */
+		function processCurrentItem(&$event)
+		{
+			$tmp_item =& $this->getTempItem($event);
+			
+			// create/update categories
+			$backup_category_id = $this->Application->GetVar('m_cat_id');
+
+			foreach ($this->curItem->CategoryPath as $category_name) {
+				if (!$category_name) continue;
+				$category_id = $this->getFromCache('category_names', $category_name);
+				if ($category_id === false) {
+					// get parent category path to search only in it
+					$current_category_id = $this->Application->GetVar('m_cat_id');
+					$parent_path = $this->getParentPath($current_category_id);
+					
+					// get category id from database by name
+					$sql = 'SELECT CategoryId
+							FROM '.TABLE_PREFIX.'Category
+							WHERE (Name = '.$this->Conn->qstr($category_name).') AND (ParentPath LIKE "'.$parent_path.'%")';
+					$category_id = $this->Conn->GetOne($sql);
+					
+					if ($category_id === false) {
+						// category not in db -> create
+						$category_fields = Array(	'Name' => $category_name, 'Description' => $category_name, 
+													'Status' => STATUS_ACTIVE, 'ParentId' => $current_category_id,
+											);
+						$this->dummyCategory->SetDBFieldsFromHash($category_fields);
+						if ($this->dummyCategory->Create()) {
+							$category_id = $this->dummyCategory->GetID();
+							$this->addToCache('category_parent_path', $category_id, $this->dummyCategory->GetDBField('ParentPath'));
+							$this->addToCache('category_names', $category_name, $category_id);
+						}
+					}
+					else {
+						$this->addToCache('category_names', $category_name, $category_id);
+					}
+				}
+				
+				if ($category_id) {
+					$this->Application->SetVar('m_cat_id', $category_id);
+				}
+			}
+			
+			// create main record
+			$save_method = 'Create';
+			if ($this->exportOptions['ReplaceDuplicates']) {
+				if ($this->exportOptions['CheckDuplicatesMethod'] == 1) {
+					$load_keys = Array($this->curItem->IDField => $this->curItem->GetID());
+				}
+				else {
+					$key_fields = explode('|', substr($this->exportOptions['DuplicateCheckFields']) );
+					foreach ($key_fields as $key_field) {
+						$load_keys[$key_field] = $this->curItem->GetDBField($key_field);
+					}
+				}
+				
+				$where_clause = '';
+				foreach ($load_keys as $field_name => $field_value) {
+					$where_clause .= '(item_table.`'.$field_name.'` = '.$this->Conn->qstr($field_value).') AND ';
+				}
+				$where_clause = preg_replace('/(.*) AND $/', '\\1', $where_clause);
+				
+				$item_id = $this->getFromCache('new_ids', $where_clause);
+				if (!$item_id) {
+					$parent_path = $this->getParentPath($category_id);
+					$sql = 'SELECT '.$this->curItem->IDField.'
+							FROM '.$this->curItem->TableName.' item_table
+							LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = item_table.ResourceId
+							LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
+							WHERE (c.ParentPath LIKE "'.$parent_path.'%") AND '.$where_clause;
+					$item_id = $this->Conn->GetOne($sql);
+				}
+				$save_method = $tmp_item->Load($item_id) ? 'Update' : 'Create';
+			}
+			
+			$resource_id = $tmp_item->isLoaded() ? $tmp_item->GetDBField('ResourceId') : 0;
+			$tmp_item->SetDBFieldsFromHash($this->curItem->FieldValues);
+			if( ($save_method == 'Update') && $resource_id ) {
+				$tmp_item->SetDBField('ResourceId', $resource_id);
+			}
+			
+			if (!$tmp_item->$save_method()) return false;
+			
+			if ( ($save_method == 'Create') && $this->exportOptions['ReplaceDuplicates'] ) {
+				// map new id to old id
+				$this->addToCache('new_ids', $where_clause, $tmp_item->GetID() );
+			}
+			
+			// set custom fields
+			foreach ($this->customValues as $custom_field => $custom_value) {
+				if (($save_method == 'Create') && !$custom_value) continue;
+				$tmp_item->SetCustomField($custom_field, $custom_value);
+			}
+			
+			// assign item to categories
+			$tmp_item->assignToCategory($category_id, false);
+			
+			$this->Application->SetVar('m_cat_id', $backup_category_id);
+			return true;
+		}
+		
+		/**
+		 * Returns category parent path, if possible, then from cache
+		 *
+		 * @param int $category_id
+		 * @return string
+		 */
+		function getParentPath($category_id)
+		{
+			$parent_path = $this->getFromCache('category_parent_path', $category_id);
+			if ($parent_path === false) {
+				$sql = 'SELECT ParentPath
+						FROM '.TABLE_PREFIX.'Category
+						WHERE CategoryId = '.$category_id;
+				$parent_path = $this->Conn->GetOne($sql);
+				$this->addToCache('category_parent_path', $category_id, $parent_path);
+			}
+			return $parent_path;
+		}
+		
+		function loadItemCustomFields()
+		{
+			$sql = 'SELECT meta_data.Value, cf.FieldName
+					FROM '.TABLE_PREFIX.'CustomMetaData meta_data
+					LEFT JOIN '.TABLE_PREFIX.'CustomField cf ON cf.CustomFieldId = meta_data.CustomFieldId
+					WHERE meta_data.ResourceId = '.$this->curItem->GetDBField('ResourceId');
+			$this->customValues = $this->Conn->GetCol($sql, 'FieldName');
+		}
+		
+		function getFileExtension()
+		{
+			return $this->exportOptions['ExportFormat'] == 1 ? 'csv' : 'xml';
+		}
+		
+		function getLineSeparator($option = 'LineEndings')
+		{
+			return $this->exportOptions[$option] == 1 ? "\r\n" : "\n";
+		}
+		
+		function scanCustomFields()
+		{
+			$ret = false;
+			$export_fields = $this->exportOptions['ExportColumns'];
+			foreach ($export_fields as $field)
+			{
+				if (substr($field, 0, 10) == '__CUSTOM__')
+				{
+					$ret = true;
+					break;
+				}
+			}
+			return $ret;
+		}
+		
+		/**
+		 * Returns field caption for any exported field 
+		 *
+		 * @param string $field
+		 * @return string
+		 */
+		function getFieldCaption($field)
+		{
+			if (substr($field, 0, 10) == '__CUSTOM__')
+			{
+				$ret = 'Custom_'.substr($field, 10, strlen($field) );
+			}
+			elseif (substr($field, 0, 12) == '__CATEGORY__')
+			{
+				return $this->getCategoryTitle();
+			}
+			else
+			{
+				$ret = $field;
+			}
+			
+			return Array($ret);
+		}
+		
+		/**
+		 * Returns requested field value (including custom fields and category fields)
+		 *
+		 * @param string $field
+		 * @return string
+		 */
+		function getFieldValue($field)
+		{
+			if (substr($field, 0, 10) == '__CUSTOM__')
+			{
+				$field = substr($field, 10, strlen($field) );
+				$ret = isset($this->customValues[$field]) ? $this->customValues[$field] : '';
+			}
+			elseif (substr($field, 0, 12) == '__CATEGORY__')
+			{
+				return $this->getCategoryPath();
+			}
+			else
+			{
+				$ret = $this->curItem->GetField($field);
+			}
+			
+			$ret = str_replace("\r\n", $this->getLineSeparator('LineEndingsInside'), $ret);
+			return Array($ret);
+		}
+		
+		/**
+		 * Returns category field(-s) caption based on export mode
+		 *
+		 * @return string
+		 */
+		function getCategoryTitle()
+		{
+			if ($this->exportOptions['CategoryFormat'] == 1)
+			{
+				// category path in one field
+				return Array('CategoryPath');
+			}
+			else
+			{
+				// category path in separated fields
+				$category_count = $this->getMaxCategoryLevel();
+				
+				$i = 0;
+				$ret = Array();
+				while ($i < $category_count) {
+					$ret[] = 'Category'.($i + 1);
+					$i++;
+				}
+				return $ret;
+			}
+		}
+		
+		/**
+		 * Returns category path in required format for current link
+		 *
+		 * @return string
+		 */
+		function getCategoryPath()
+		{
+			$category_id = $this->curItem->GetDBField('CategoryId');
+			$category_path = $this->getFromCache('category_path', $category_id);
+			if (!$category_path)
+			{				
+				$sql = 'SELECT CachedNavbar
+						FROM '.TABLE_PREFIX.'Category
+						WHERE CategoryId = '.$category_id;
+				$category_path = $this->Conn->GetOne($sql);
+				$category_path = explode('>', $category_path);
+				
+				if ($this->exportOptions['IsBaseCategory'] ) {
+					$i = $this->exportOptions['BaseLevel'];
+					while ($i > 0) {
+						array_shift($category_path);
+						$i--;
+					}
+				}
+				
+				if ($this->exportOptions['CategoryFormat'] == 1) {
+					// category path in single field
+					$category_path = Array( implode($this->exportOptions['CategorySeparator'], $category_path) );
+				}
+				else {
+					// category path in separated fields
+					$category_count = $this->getMaxCategoryLevel();
+					$levels_used = count($category_path);
+					if ($levels_used < $category_count)
+					{
+						$i = 0;
+						while ($i < $category_count - $levels_used) {
+							$category_path[] = '';
+							$i++;
+						}
+					}
+				}
+				$this->addToCache('category_path', $category_id, $category_path);
+			}
+			
+			return $category_path;
+		}
+		
+		/**
+		 * Get maximal category deep level from links beeing exported
+		 *
+		 * @return int
+		 */
+		function getMaxCategoryLevel()
+		{
+			static $max_level = -1;
+			
+			if ($max_level != -1)
+			{
+				return $max_level;
+			}
+			
+			$sql = 'SELECT IF(c.CategoryId IS NULL, 0, MAX( LENGTH(c.ParentPath) - LENGTH( REPLACE(c.ParentPath, "|", "") ) - 1 ))
+					FROM '.$this->curItem->TableName.' item_table
+					LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON item_table.ResourceId = ci.ItemResourceId
+					LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
+					WHERE (ci.PrimaryCat = 1) AND ';
+			
+			$where_clause = '';
+			if ($this->exportOptions['export_ids'] === false) {
+				// get links from current category & all it's subcategories
+				if ($this->exportOptions['export_cats_ids'][0] == 0) {
+					$where_clause = 1;
+				}
+				else {
+					foreach ($this->exportOptions['export_cats_ids'] as $category_id) {
+						$where_clause .= '(c.ParentPath LIKE "%|'.$category_id.'|%") OR ';
+					}
+					$where_clause = preg_replace('/(.*) OR $/', '\\1', $where_clause);
+				}
+			}
+			else {
+				// get only selected links
+				$where_clause = $this->curItem->IDField.' IN ('.implode(',', $this->exportOptions['export_ids']).')';
+			}
+
+			$max_level = $this->Conn->GetOne($sql.'('.$where_clause.')');
+			
+			if ($this->exportOptions['IsBaseCategory'] ) {
+				$max_level -= $this->exportOptions['BaseLevel'];
+			}
+			
+			return $max_level;
+		}
+		
+		/**
+		 * Saves one record to export file
+		 *
+		 * @param Array $fields_hash
+		 */
+		function writeRecord($fields_hash)
+		{
+			fputcsv2($this->filePointer, $fields_hash, $this->exportOptions['FieldsSeparatedBy'], $this->exportOptions['FieldsEnclosedBy'], $this->getLineSeparator() );
+		}
+		
+		function readRecord()
+		{
+			return fgetcsv($this->filePointer, 10000, $this->exportOptions['FieldsSeparatedBy'], $this->exportOptions['FieldsEnclosedBy']);
+		}
+	}
+
+?>
Index: trunk/core/units/general/cat_dbitem_export.php
===================================================================
diff -u -N
--- trunk/core/units/general/cat_dbitem_export.php	(revision 0)
+++ trunk/core/units/general/cat_dbitem_export.php	(revision 3543)
@@ -0,0 +1,848 @@
+<?php
+
+	define('EXPORT_STEP', 200); // export by 200 items (e.g. links)
+	define('IMPORT_CHUNK', 50120); // 5 KB
+	
+	class kCatDBItemExportHelper extends kHelper {
+		
+		
+		var $cache = Array();
+		
+		var $exportFields = Array();
+		
+		/**
+		 * Export options
+		 *
+		 * @var Array
+		 */
+		var $exportOptions = Array();
+		
+		/**
+		 * If we have custom fields in export
+		 *
+		 * @var unknown_type
+		 */
+		var $hasCustomFields = false;
+		
+		/**
+		 * Custom field values for last item beeing exported
+		 *
+		 * @var Array
+		 */
+		var $customValues = Array();
+		
+		/**
+		 * Item beeing currenly exported
+		 *
+		 * @var kCatDBItem
+		 */
+		var $curItem = null;
+		
+		/**
+		 * Dummy category object
+		 *
+		 * @var CategoriesItem
+		 */
+		var $dummyCategory = null;
+		
+		/**
+		 * Pointer to opened file
+		 *
+		 * @var resource
+		 */
+		var $filePointer = null;
+		
+		/**
+		 * Returns value from cache if found or false otherwise
+		 *
+		 * @param string $type
+		 * @param int $key
+		 * @return mixed
+		 */
+		function getFromCache($type, $key)
+		{
+			return getArrayValue($this->cache, $type, $key);
+		}
+		
+		/**
+		 * Adds value to be cached
+		 *
+		 * @param string $type
+		 * @param int $key
+		 * @param mixed $value
+		 */
+		function addToCache($type, $key, $value)
+		{
+//			if (!isset($this->cache[$type])) $this->cache[$type] = Array();
+			$this->cache[$type][$key] = $value;
+		}
+		
+		/**
+		 * Fill required fields with dummy values
+		 *
+		 * @param kEvent $event
+		 */
+		function fillRequiredFields(&$event)
+		{
+			$object =& $event->getObject();
+			
+			$fields = array_keys($object->Fields);
+			foreach ($fields as $field_name)
+			{
+				$field_options =& $object->Fields[$field_name];
+				if (isset($object->VirtualFields[$field_name]) || !getArrayValue($field_options, 'required') ) continue;
+				
+				$formatter_class = getArrayValue($field_options, 'formatter');
+				if ($formatter_class) // not tested
+				{
+					$formatter =& $this->Application->recallObject($formatter_class);
+					$sample_value = $formatter->GetSample($field_name, $field_options, $object);
+				}
+				$object->SetDBField($field_name, isset($sample_value) && $sample_value ? $sample_value : 'dummy');
+			}
+		}
+		
+		/**
+		 * Verifies that all user entered export params are correct
+		 *
+		 * @param kEvent $event
+		 */
+		function verifyOptions(&$event)
+		{
+			if ($this->Application->RecallVar($event->getPrefixSpecial().'_ForceNotValid'))
+			{
+				$this->Application->StoreVar($event->getPrefixSpecial().'_ForceNotValid', 0);
+				return false;
+			}
+			
+			$this->fillRequiredFields($event);
+			
+			$object =& $event->getObject();
+			$cross_unique_fields = Array('FieldsSeparatedBy', 'FieldsEnclosedBy');
+			if (($object->GetDBField('CategoryFormat') == 1) || ($event->Special == 'import')) // in one field
+			{
+				$object->setRequired('CategorySeparator', true);
+				$cross_unique_fields[] = 'CategorySeparator';
+			}
+			
+			$ret = $object->Validate();
+			
+			// check if cross unique fields has no same values
+			foreach ($cross_unique_fields as $field_index => $field_name)
+			{
+				if (getArrayValue($object->FieldErrors, $field_name, 'pseudo') == 'required') continue;
+				
+				$check_fields = $cross_unique_fields;
+				unset($check_fields[$field_index]);
+				
+				foreach ($check_fields as $check_field)
+				{
+					if ($object->GetDBField($field_name) == $object->GetDBField($check_field))
+					{
+						$object->SetError($check_field, 'unique');
+					}
+				}
+			}
+			
+			if ($event->Special == 'import')
+			{
+				$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
+				
+				$automatic_fields = ($object->GetDBField('FieldTitles') == 1);
+				$object->setRequired('ExportColumns', !$automatic_fields);
+				$category_prefix = '__CATEGORY__';
+				if ( $automatic_fields && ($this->exportOptions['SkipFirstRow']) ) {
+					$this->openFile($event);
+					$this->exportOptions['ExportColumns'] = $this->readRecord();
+					$this->closeFile();
+					
+					// remove additional (non-parseble columns)
+					foreach ($this->exportOptions['ExportColumns'] as $field_index => $field_name) {
+						if (!$this->validateField($field_name, $object)) {
+							unset($this->exportOptions['ExportColumns'][$field_index]);
+						}
+					}
+					$category_prefix = '';
+				}
+				
+				// 1. check, that we have column definitions
+				if (!$this->exportOptions['ExportColumns']) {
+					$object->setError('ExportColumns', 'required');
+					$ret = false;
+				}
+				
+				// 2. check, that we have only mixed category field or only separated category fields
+				$category_found['mixed'] = false;
+				$category_found['separated'] = false;
+			
+				foreach ($this->exportOptions['ExportColumns'] as $import_field) {
+					if (preg_match('/^'.$category_prefix.'Category(Path|[0-9]+)/', $import_field, $rets)) {
+						$category_found[$rets[1] == 'Path' ? 'mixed' : 'separated'] = true;
+					}
+				}
+				if ($category_found['mixed'] && $category_found['separated']) {
+					$object->SetError('ExportColumns', 'unique_category', 'la_error_unique_category_field');
+					$ret = false;
+				}
+				
+				// 3. check, that duplicates check fields are selected & present in imported fields
+				if ($this->exportOptions['ReplaceDuplicates']) {
+					if ($this->exportOptions['CheckDuplicatesMethod'] == 1) {
+						$check_fields = Array($object->IDField);
+					}
+					else {
+						$check_fields = $this->exportOptions['DuplicateCheckFields'] ? explode('|', substr($this->exportOptions['DuplicateCheckFields'], 1, -1)) : Array();
+					}
+					
+					if (!$check_fields) {
+						$object->setError('CheckDuplicatesMethod', 'required');
+						$ret = false;
+					}
+					else {
+						foreach ($check_fields as $check_field) {
+							if (!in_array($check_field, $this->exportOptions['ExportColumns'])) {
+								$object->setError('ExportColumns', 'required');
+								$ret = false;
+								break;
+							}
+						}
+					}
+				}
+			}
+			
+			return $ret;
+		}
+		
+		/**
+		 * Returns filename to read import data from
+		 *
+		 * @return string
+		 */
+		function getImportFilename()
+		{
+			if ($this->exportOptions['ImportSource'] == 1)
+			{
+				$ret = $this->exportOptions['ImportFilename']['name'];
+			}
+			else {
+				$ret = $this->exportOptions['ImportLocalFilename'];
+			}
+			return EXPORT_PATH.'/'.$ret;
+		}
+		
+		/**
+		 * Returns filename to write export data to
+		 *
+		 * @return string
+		 */
+		function getExportFilename()
+		{
+			return EXPORT_PATH.'/'.$this->exportOptions['ExportFilename'].'.'.$this->getFileExtension();
+		}
+		
+		/**
+		 * Opens file required for export/import operations
+		 *
+		 * @param kEvent $event
+		 */
+		function openFile(&$event)
+		{
+			if ($event->Special == 'export') {
+				$write_mode = ($this->exportOptions['start_from'] == 0) ? 'w' : 'a';
+				$this->filePointer = fopen($this->getExportFilename(), $write_mode);
+			}
+			else {
+				$this->filePointer = fopen($this->getImportFilename(), 'r');
+			}
+		}
+		
+		/**
+		 * Closes opened file
+		 *
+		 */
+		function closeFile()
+		{
+			fclose($this->filePointer);
+		}
+		
+		function getExportSQL($count_only = false)
+		{
+			if ($this->exportOptions['export_ids'] === false)
+			{
+				// get links from current category & all it's subcategories
+				$sql = 'SELECT item_table.*, ci.CategoryId
+						FROM '.$this->curItem->TableName.' item_table
+						LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = item_table.ResourceId
+						LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
+						WHERE ';
+				
+				if ($this->exportOptions['export_cats_ids'][0] == 0)
+				{
+					$sql .= '1';
+				}
+				else {
+					foreach ($this->exportOptions['export_cats_ids'] as $category_id) {
+						$sql .= '(c.ParentPath LIKE "%|'.$category_id.'|%") OR ';
+					}
+					$sql = preg_replace('/(.*) OR $/', '\\1', $sql);
+				}
+				
+				$sql .= ' ORDER BY ci.PrimaryCat DESC'; // NEW
+			}
+			else {
+				// get only selected links
+				$sql = 'SELECT item_table.*, '.$this->exportOptions['export_cats_ids'][0].' AS CategoryId
+						FROM '.$this->curItem->TableName.' item_table
+						WHERE '.$this->curItem->IDField.' IN ('.implode(',', $this->exportOptions['export_ids']).')';
+			}
+			
+			if (!$count_only)
+			{
+				$sql .= ' LIMIT '.$this->exportOptions['start_from'].','.EXPORT_STEP;
+			}
+			else {
+				$sql = preg_replace("/^.*SELECT(.*?)FROM(?!_)/is", "SELECT COUNT(*) AS count FROM ", $sql);
+			}
+			
+			return $sql;
+		}
+		
+		/**
+		 * Enter description here...
+		 *
+		 * @param kEvent $event
+		 */
+		function performExport(&$event)
+		{
+			$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
+			$this->exportFields = $this->exportOptions['ExportColumns'];
+			$this->curItem =& $event->getObject( Array('skip_autoload' => true) );
+			
+			$this->openFile($event);
+			
+			if ($this->exportOptions['start_from'] == 0) // first export step
+			{
+				if ($this->exportOptions['IsBaseCategory'] ) {
+					$sql = 'SELECT CachedNavbar
+							FROM '.TABLE_PREFIX.'Category
+							WHERE CategoryId = '.$this->Application->GetVar('m_cat_id');
+					$this->exportOptions['BaseLevel'] = substr_count($this->Conn->GetOne($sql), '>') + 1; // level to cut from other categories
+				}
+				
+				// 1. export field titles if required
+				if ($this->exportOptions['IncludeFieldTitles'])
+				{
+					$data_array = Array();
+					foreach ($this->exportFields as $export_field)
+					{
+						$data_array = array_merge($data_array, $this->getFieldCaption($export_field));
+					}
+					$this->writeRecord($data_array);
+				}
+				$this->exportOptions['total_records'] = $this->Conn->GetOne( $this->getExportSQL(true) );
+				$this->exportOptions['has_custom_fields'] = $this->scanCustomFields();
+			}
+			
+			$this->hasCustomFields = $this->exportOptions['has_custom_fields'];
+			
+			// 2. export data
+			$records = $this->Conn->Query( $this->getExportSQL() );
+			$records_exported = 0;
+			foreach ($records as $record_info) {
+				$this->curItem->SetDBFieldsFromHash($record_info);
+				if ($this->hasCustomFields)
+				{
+					$this->loadItemCustomFields();
+				}
+				
+				$data_array = Array();
+				foreach ($this->exportFields as $export_field)
+				{
+					$data_array =  array_merge($data_array, $this->getFieldValue($export_field) );
+				}
+				$this->writeRecord($data_array);
+				$records_exported++;
+			}
+			$this->closeFile();
+			
+			$this->exportOptions['start_from'] += $records_exported;
+			$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($this->exportOptions) );
+			
+			return $this->exportOptions;
+		}
+		
+		function getItemFields()
+		{
+			// just in case dummy user selected automtic mode & moved columns too :(
+			return array_merge($this->curItem->Fields['AvailableColumns']['options'], $this->curItem->Fields['ExportColumns']['options']);
+		}
+		
+		/**
+		 * Checks if field really belongs to importable field list
+		 *
+		 * @param string $field_name
+		 * @param kCatDBItem $object
+		 * @return bool
+		 */
+		function validateField($field_name, &$object)
+		{
+			// 1. convert custom field
+			$field_name = preg_replace('/^Custom_(.*)/', '__CUSTOM__\\1', $field_name);
+			
+			// 2. convert category field (mixed version & serparated version)
+			$field_name = preg_replace('/^Category(Path|[0-9]+)/', '__CATEGORY__Category\\1', $field_name);
+			
+			$valid_fields = $object->getPossibleExportColumns();
+			return isset($valid_fields[$field_name]);
+		}
+		
+		/**
+		 * Enter description here...
+		 *
+		 * @param kEvent $event
+		 */
+		function performImport(&$event)
+		{
+			if (!$this->exportOptions) {
+				// load import options in case if not previously loaded in verification function
+				$this->exportOptions = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
+			}
+			
+			$this->curItem =& $event->getObject( Array('skip_autoload' => true) );
+			
+			$backup_category_id = $this->Application->GetVar('m_cat_id');
+			$this->Application->SetVar('m_cat_id', (int)$this->Application->RecallVar('ImportCategory') );
+			
+			$this->openFile($event);
+			
+			$bytes_imported = 0;
+			if ($this->exportOptions['start_from'] == 0) // first export step
+			{
+				// 1st time run
+				if ($this->exportOptions['SkipFirstRow']) {
+					$this->readRecord();
+					$this->exportOptions['start_from'] = ftell($this->filePointer);
+					$bytes_imported = ftell($this->filePointer);
+				}
+				
+				$current_category_id = $this->Application->GetVar('m_cat_id');
+				if ($current_category_id > 0) {
+					$sql = 'SELECT ParentPath FROM '.TABLE_PREFIX.'Category WHERE CategoryId = '.$current_category_id;
+					$this->exportOptions['ImportCategoryPath'] = $this->Conn->GetOne($sql);
+				}
+				else {
+					$this->exportOptions['ImportCategoryPath'] = '';
+				}
+				$this->exportOptions['total_records'] = filesize($this->getImportFilename());
+			}
+			else {
+				$this->cache['new_ids']	= $this->exportOptions['new_ids_hash'];
+			}
+			$this->exportFields = $this->exportOptions['ExportColumns'];
+			$this->addToCache('category_parent_path', $this->Application->GetVar('m_cat_id'), $this->exportOptions['ImportCategoryPath']);
+			
+			// 2. import data
+			$this->dummyCategory =& $this->Application->recallObject('c.-tmpitem', 'c', Array('skip_autoload' => true));
+			fseek($this->filePointer, $this->exportOptions['start_from']);
+								
+			while (($bytes_imported < IMPORT_CHUNK) && !feof($this->filePointer)) {
+				$this->customValues = Array();
+				$data = $this->readRecord();
+				if ($data) {
+					foreach ($data as $field_index => $field_value) {
+						$this->setFieldValue($field_index, $field_value);	
+					}
+					$this->curItem->setID( $this->curItem->GetDBField($this->curItem->IDField) );
+					$this->processCurrentItem($event);
+				}
+				$bytes_imported = ftell($this->filePointer) - $this->exportOptions['start_from'];
+			}
+			
+			$this->closeFile();
+			$this->Application->SetVar('m_cat_id', $backup_category_id);
+			
+			$this->exportOptions['start_from'] += $bytes_imported;
+			$this->exportOptions['new_ids_hash'] = getArrayValue($this->cache, 'new_ids');
+			$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($this->exportOptions) );
+			
+			return $this->exportOptions;
+		}
+		
+		function setFieldValue($field_index, $value)
+		{
+			$field_name = $this->exportFields[$field_index];
+			
+			if (substr($field_name, 0, 7) == 'Custom_') {
+				$field_name = substr($field_name, 7);
+				$this->customValues[$field_name] = $value;
+			}
+			elseif ($field_name == 'CategoryPath') {
+				$this->curItem->CategoryPath = explode($this->exportOptions['CategorySeparator'], $value);
+			}
+			elseif (substr($field_name, 0, 8) == 'Category') {
+				$this->curItem->CategoryPath[ (int)substr($field_name, 8) ] = $value;
+			}
+			else {
+				$this->curItem->SetField($field_name, $value);
+			}
+		}
+		
+		/**
+		 * Returns temporary items for import procedures
+		 *
+		 * @param kEvent $event
+		 * @return kCatDBItem
+		 */
+		function &getTempItem(&$event)
+		{
+			return $this->Application->recallObject($event->Prefix.'.-tmpitem', $event->Prefix, Array('skip_autoload' => true));
+		}
+		
+		/**
+		 * Enter description here...
+		 *
+		 * @param kEvent $event
+		 */
+		function processCurrentItem(&$event)
+		{
+			$tmp_item =& $this->getTempItem($event);
+			
+			// create/update categories
+			$backup_category_id = $this->Application->GetVar('m_cat_id');
+
+			foreach ($this->curItem->CategoryPath as $category_name) {
+				if (!$category_name) continue;
+				$category_id = $this->getFromCache('category_names', $category_name);
+				if ($category_id === false) {
+					// get parent category path to search only in it
+					$current_category_id = $this->Application->GetVar('m_cat_id');
+					$parent_path = $this->getParentPath($current_category_id);
+					
+					// get category id from database by name
+					$sql = 'SELECT CategoryId
+							FROM '.TABLE_PREFIX.'Category
+							WHERE (Name = '.$this->Conn->qstr($category_name).') AND (ParentPath LIKE "'.$parent_path.'%")';
+					$category_id = $this->Conn->GetOne($sql);
+					
+					if ($category_id === false) {
+						// category not in db -> create
+						$category_fields = Array(	'Name' => $category_name, 'Description' => $category_name, 
+													'Status' => STATUS_ACTIVE, 'ParentId' => $current_category_id,
+											);
+						$this->dummyCategory->SetDBFieldsFromHash($category_fields);
+						if ($this->dummyCategory->Create()) {
+							$category_id = $this->dummyCategory->GetID();
+							$this->addToCache('category_parent_path', $category_id, $this->dummyCategory->GetDBField('ParentPath'));
+							$this->addToCache('category_names', $category_name, $category_id);
+						}
+					}
+					else {
+						$this->addToCache('category_names', $category_name, $category_id);
+					}
+				}
+				
+				if ($category_id) {
+					$this->Application->SetVar('m_cat_id', $category_id);
+				}
+			}
+			
+			// create main record
+			$save_method = 'Create';
+			if ($this->exportOptions['ReplaceDuplicates']) {
+				if ($this->exportOptions['CheckDuplicatesMethod'] == 1) {
+					$load_keys = Array($this->curItem->IDField => $this->curItem->GetID());
+				}
+				else {
+					$key_fields = explode('|', substr($this->exportOptions['DuplicateCheckFields']) );
+					foreach ($key_fields as $key_field) {
+						$load_keys[$key_field] = $this->curItem->GetDBField($key_field);
+					}
+				}
+				
+				$where_clause = '';
+				foreach ($load_keys as $field_name => $field_value) {
+					$where_clause .= '(item_table.`'.$field_name.'` = '.$this->Conn->qstr($field_value).') AND ';
+				}
+				$where_clause = preg_replace('/(.*) AND $/', '\\1', $where_clause);
+				
+				$item_id = $this->getFromCache('new_ids', $where_clause);
+				if (!$item_id) {
+					$parent_path = $this->getParentPath($category_id);
+					$sql = 'SELECT '.$this->curItem->IDField.'
+							FROM '.$this->curItem->TableName.' item_table
+							LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON ci.ItemResourceId = item_table.ResourceId
+							LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
+							WHERE (c.ParentPath LIKE "'.$parent_path.'%") AND '.$where_clause;
+					$item_id = $this->Conn->GetOne($sql);
+				}
+				$save_method = $tmp_item->Load($item_id) ? 'Update' : 'Create';
+			}
+			
+			$resource_id = $tmp_item->isLoaded() ? $tmp_item->GetDBField('ResourceId') : 0;
+			$tmp_item->SetDBFieldsFromHash($this->curItem->FieldValues);
+			if( ($save_method == 'Update') && $resource_id ) {
+				$tmp_item->SetDBField('ResourceId', $resource_id);
+			}
+			
+			if (!$tmp_item->$save_method()) return false;
+			
+			if ( ($save_method == 'Create') && $this->exportOptions['ReplaceDuplicates'] ) {
+				// map new id to old id
+				$this->addToCache('new_ids', $where_clause, $tmp_item->GetID() );
+			}
+			
+			// set custom fields
+			foreach ($this->customValues as $custom_field => $custom_value) {
+				if (($save_method == 'Create') && !$custom_value) continue;
+				$tmp_item->SetCustomField($custom_field, $custom_value);
+			}
+			
+			// assign item to categories
+			$tmp_item->assignToCategory($category_id, false);
+			
+			$this->Application->SetVar('m_cat_id', $backup_category_id);
+			return true;
+		}
+		
+		/**
+		 * Returns category parent path, if possible, then from cache
+		 *
+		 * @param int $category_id
+		 * @return string
+		 */
+		function getParentPath($category_id)
+		{
+			$parent_path = $this->getFromCache('category_parent_path', $category_id);
+			if ($parent_path === false) {
+				$sql = 'SELECT ParentPath
+						FROM '.TABLE_PREFIX.'Category
+						WHERE CategoryId = '.$category_id;
+				$parent_path = $this->Conn->GetOne($sql);
+				$this->addToCache('category_parent_path', $category_id, $parent_path);
+			}
+			return $parent_path;
+		}
+		
+		function loadItemCustomFields()
+		{
+			$sql = 'SELECT meta_data.Value, cf.FieldName
+					FROM '.TABLE_PREFIX.'CustomMetaData meta_data
+					LEFT JOIN '.TABLE_PREFIX.'CustomField cf ON cf.CustomFieldId = meta_data.CustomFieldId
+					WHERE meta_data.ResourceId = '.$this->curItem->GetDBField('ResourceId');
+			$this->customValues = $this->Conn->GetCol($sql, 'FieldName');
+		}
+		
+		function getFileExtension()
+		{
+			return $this->exportOptions['ExportFormat'] == 1 ? 'csv' : 'xml';
+		}
+		
+		function getLineSeparator($option = 'LineEndings')
+		{
+			return $this->exportOptions[$option] == 1 ? "\r\n" : "\n";
+		}
+		
+		function scanCustomFields()
+		{
+			$ret = false;
+			$export_fields = $this->exportOptions['ExportColumns'];
+			foreach ($export_fields as $field)
+			{
+				if (substr($field, 0, 10) == '__CUSTOM__')
+				{
+					$ret = true;
+					break;
+				}
+			}
+			return $ret;
+		}
+		
+		/**
+		 * Returns field caption for any exported field 
+		 *
+		 * @param string $field
+		 * @return string
+		 */
+		function getFieldCaption($field)
+		{
+			if (substr($field, 0, 10) == '__CUSTOM__')
+			{
+				$ret = 'Custom_'.substr($field, 10, strlen($field) );
+			}
+			elseif (substr($field, 0, 12) == '__CATEGORY__')
+			{
+				return $this->getCategoryTitle();
+			}
+			else
+			{
+				$ret = $field;
+			}
+			
+			return Array($ret);
+		}
+		
+		/**
+		 * Returns requested field value (including custom fields and category fields)
+		 *
+		 * @param string $field
+		 * @return string
+		 */
+		function getFieldValue($field)
+		{
+			if (substr($field, 0, 10) == '__CUSTOM__')
+			{
+				$field = substr($field, 10, strlen($field) );
+				$ret = isset($this->customValues[$field]) ? $this->customValues[$field] : '';
+			}
+			elseif (substr($field, 0, 12) == '__CATEGORY__')
+			{
+				return $this->getCategoryPath();
+			}
+			else
+			{
+				$ret = $this->curItem->GetField($field);
+			}
+			
+			$ret = str_replace("\r\n", $this->getLineSeparator('LineEndingsInside'), $ret);
+			return Array($ret);
+		}
+		
+		/**
+		 * Returns category field(-s) caption based on export mode
+		 *
+		 * @return string
+		 */
+		function getCategoryTitle()
+		{
+			if ($this->exportOptions['CategoryFormat'] == 1)
+			{
+				// category path in one field
+				return Array('CategoryPath');
+			}
+			else
+			{
+				// category path in separated fields
+				$category_count = $this->getMaxCategoryLevel();
+				
+				$i = 0;
+				$ret = Array();
+				while ($i < $category_count) {
+					$ret[] = 'Category'.($i + 1);
+					$i++;
+				}
+				return $ret;
+			}
+		}
+		
+		/**
+		 * Returns category path in required format for current link
+		 *
+		 * @return string
+		 */
+		function getCategoryPath()
+		{
+			$category_id = $this->curItem->GetDBField('CategoryId');
+			$category_path = $this->getFromCache('category_path', $category_id);
+			if (!$category_path)
+			{				
+				$sql = 'SELECT CachedNavbar
+						FROM '.TABLE_PREFIX.'Category
+						WHERE CategoryId = '.$category_id;
+				$category_path = $this->Conn->GetOne($sql);
+				$category_path = explode('>', $category_path);
+				
+				if ($this->exportOptions['IsBaseCategory'] ) {
+					$i = $this->exportOptions['BaseLevel'];
+					while ($i > 0) {
+						array_shift($category_path);
+						$i--;
+					}
+				}
+				
+				if ($this->exportOptions['CategoryFormat'] == 1) {
+					// category path in single field
+					$category_path = Array( implode($this->exportOptions['CategorySeparator'], $category_path) );
+				}
+				else {
+					// category path in separated fields
+					$category_count = $this->getMaxCategoryLevel();
+					$levels_used = count($category_path);
+					if ($levels_used < $category_count)
+					{
+						$i = 0;
+						while ($i < $category_count - $levels_used) {
+							$category_path[] = '';
+							$i++;
+						}
+					}
+				}
+				$this->addToCache('category_path', $category_id, $category_path);
+			}
+			
+			return $category_path;
+		}
+		
+		/**
+		 * Get maximal category deep level from links beeing exported
+		 *
+		 * @return int
+		 */
+		function getMaxCategoryLevel()
+		{
+			static $max_level = -1;
+			
+			if ($max_level != -1)
+			{
+				return $max_level;
+			}
+			
+			$sql = 'SELECT IF(c.CategoryId IS NULL, 0, MAX( LENGTH(c.ParentPath) - LENGTH( REPLACE(c.ParentPath, "|", "") ) - 1 ))
+					FROM '.$this->curItem->TableName.' item_table
+					LEFT JOIN '.TABLE_PREFIX.'CategoryItems ci ON item_table.ResourceId = ci.ItemResourceId
+					LEFT JOIN '.TABLE_PREFIX.'Category c ON c.CategoryId = ci.CategoryId
+					WHERE (ci.PrimaryCat = 1) AND ';
+			
+			$where_clause = '';
+			if ($this->exportOptions['export_ids'] === false) {
+				// get links from current category & all it's subcategories
+				if ($this->exportOptions['export_cats_ids'][0] == 0) {
+					$where_clause = 1;
+				}
+				else {
+					foreach ($this->exportOptions['export_cats_ids'] as $category_id) {
+						$where_clause .= '(c.ParentPath LIKE "%|'.$category_id.'|%") OR ';
+					}
+					$where_clause = preg_replace('/(.*) OR $/', '\\1', $where_clause);
+				}
+			}
+			else {
+				// get only selected links
+				$where_clause = $this->curItem->IDField.' IN ('.implode(',', $this->exportOptions['export_ids']).')';
+			}
+
+			$max_level = $this->Conn->GetOne($sql.'('.$where_clause.')');
+			
+			if ($this->exportOptions['IsBaseCategory'] ) {
+				$max_level -= $this->exportOptions['BaseLevel'];
+			}
+			
+			return $max_level;
+		}
+		
+		/**
+		 * Saves one record to export file
+		 *
+		 * @param Array $fields_hash
+		 */
+		function writeRecord($fields_hash)
+		{
+			fputcsv2($this->filePointer, $fields_hash, $this->exportOptions['FieldsSeparatedBy'], $this->exportOptions['FieldsEnclosedBy'], $this->getLineSeparator() );
+		}
+		
+		function readRecord()
+		{
+			return fgetcsv($this->filePointer, 10000, $this->exportOptions['FieldsSeparatedBy'], $this->exportOptions['FieldsEnclosedBy']);
+		}
+	}
+
+?>
Index: trunk/core/module_help/visits_list.txt
===================================================================
diff -u -N -r2976 -r3543
--- trunk/core/module_help/visits_list.txt	(.../visits_list.txt)	(revision 2976)
+++ trunk/core/module_help/visits_list.txt	(.../visits_list.txt)	(revision 3543)
@@ -1,24 +1,24 @@
-<span style="font-weight: bold;">Visits (In-portal Platform)<br/>
-<br/>
-</span>This section displays the log of all visits to your website. The visit is recorded when a user comes to your site. If the user logs in during his or her visit, the username will be updated in the visit record. If the user&rsquo;s session expires during the visit, a new visit record will be created when he or she comes back to the site. <br/>
-The grid on this page displays the following columns:<br/>
-<ul>
-    <li>Visit Date &ndash; Date and Time of the visit&rsquo;s start</li>
-    <li>IP Address &ndash; the IP address of the visitor, as identified by the web server</li>
-    <li>Referrer &ndash; the URL the visitor came from, as reported by visitor&rsquo;s browser </li>
-    <li>Username &ndash; the username of the visitor if he or she logs in during the visit</li>
-</ul>
-<br/>
-<span style="font-weight: bold;">Visits (with In-commerce installed)<br/>
-<br/>
-</span>This section displays the log of all visits to your website. The visit is recorded when user comes to your site. If the user logs in during his or her visit, the username will be updated in the visit record. If the user&rsquo;s session expires during the visit, a new visit record will be created when he or she comes back to the site. <br/>
-The grid on this page displays the following columns:<br/>
-<ul>
-    <li>Visit Date &ndash; Date and Time of the visit&rsquo;s start</li>
-    <li>IP Address &ndash; the IP address of the visitor, as identified by the web server</li>
-    <li>Referrer &ndash; the URL the visitor came from, as reported by visitor&rsquo;s browser </li>
-    <li>Username &ndash; the username of the visitor if he or she logs in during the visit</li>
-    <li>Affiliate User &ndash; the username of affiliate who has referred the visitor</li>
-    <li>Order Total &ndash; the total amount of the orders made during this visit</li>
-    <li>Affiliate Commission &ndash; amount of affiliate commission received for the orders made during the visit</li>
+<span style="font-weight: bold;">Visits (In-portal Platform)<br/>
+<br/>
+</span>This section displays the log of all visits to your website. The visit is recorded when a user comes to your site. If the user logs in during his or her visit, the username will be updated in the visit record. If the user&rsquo;s session expires during the visit, a new visit record will be created when he or she comes back to the site. <br/>
+The grid on this page displays the following columns:<br/>
+<ul>
+    <li>Visit Date &ndash; Date and Time of the visit&rsquo;s start</li>
+    <li>IP Address &ndash; the IP address of the visitor, as identified by the web server</li>
+    <li>Referrer &ndash; the URL the visitor came from, as reported by visitor&rsquo;s browser </li>
+    <li>Username &ndash; the username of the visitor if he or she logs in during the visit</li>
+</ul>
+<br/>
+<span style="font-weight: bold;">Visits (with In-commerce installed)<br/>
+<br/>
+</span>This section displays the log of all visits to your website. The visit is recorded when user comes to your site. If the user logs in during his or her visit, the username will be updated in the visit record. If the user&rsquo;s session expires during the visit, a new visit record will be created when he or she comes back to the site. <br/>
+The grid on this page displays the following columns:<br/>
+<ul>
+    <li>Visit Date &ndash; Date and Time of the visit&rsquo;s start</li>
+    <li>IP Address &ndash; the IP address of the visitor, as identified by the web server</li>
+    <li>Referrer &ndash; the URL the visitor came from, as reported by visitor&rsquo;s browser </li>
+    <li>Username &ndash; the username of the visitor if he or she logs in during the visit</li>
+    <li>Affiliate User &ndash; the username of affiliate who has referred the visitor</li>
+    <li>Order Total &ndash; the total amount of the orders made during this visit</li>
+    <li>Affiliate Commission &ndash; amount of affiliate commission received for the orders made during the visit</li>
 </ul>
\ No newline at end of file
Index: trunk/kernel/units/general/cat_event_handler.php
===================================================================
diff -u -N -r3299 -r3543
--- trunk/kernel/units/general/cat_event_handler.php	(.../cat_event_handler.php)	(revision 3299)
+++ trunk/kernel/units/general/cat_event_handler.php	(.../cat_event_handler.php)	(revision 3543)
@@ -237,9 +237,25 @@
 	 * @param kCatDBItem $object
 	 * @param kEvent $event
 	 */
-	function PrepareObject(&$object, &$event)
+	function prepareObject(&$object, &$event)
 	{
+		$this->prepareItemStatuses($event);
+		
+		if ($event->Special == 'export' || $event->Special == 'import')
+		{
+			$this->prepareExportColumns($event);
+		}
+	}
 
+	/**
+	 * Creates calculated fields for all item statuses based on config settings
+	 *
+	 * @param kEvent $event
+	 */
+	function prepareItemStatuses(&$event)
+	{
+		$object =& $event->getObject( Array('skip_autoload' => true) );
+		
 		$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
 
 		$new_days_var = getArrayValue($property_mappings, 'NewDays');
@@ -279,7 +295,7 @@
 														%1$s.PopItem)');
 		}
 	}
-
+	
 	function CalculateHotLimit(&$event)
 	{
 		$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
@@ -1005,7 +1021,365 @@
 
 		$object->SetPage($page);
 	}
+	
+/* === RELATED TO IMPORT/EXPORT: BEGIN === */
+	
+	/**
+	 * Returns module folder
+	 *
+	 * @param kEvent $event
+	 * @return string
+	 */
+	function getModuleFolder(&$event)
+	{
+		return $this->Application->getUnitOption($event->Prefix, 'ModuleFolder');
+	}
+	
+	/**
+	 * Shows export dialog
+	 *
+	 * @param kEvent $event
+	 */
+	function OnExport(&$event)
+	{
+		$selected_ids = $this->Application->GetVar('linklist');
+		$selected_cats_ids = $this->Application->GetVar('export_categories');
+		
+		$this->Application->StoreVar($event->Prefix.'_export_ids', $selected_ids ? implode(',', $selected_ids) : '' );
+		$this->Application->StoreVar($event->Prefix.'_export_cats_ids', $selected_cats_ids);
+		
+		$event->redirect = $this->getModuleFolder($event).'/export';
+		
+		$redirect_params = Array(	'm_opener' => 'd',
+									'index_file' => 'index4.php',
+									$this->Prefix.'.export_event' => 'OnNew',
+									'pass' => 'all,'.$this->Prefix.'.export');
+		
+		$event->setRedirectParams($redirect_params);
+	}
+	
+	/**
+	 * Export form validation & processing
+	 *
+	 * @param kEvent $event
+	 */
+	function OnExportBegin(&$event)
+	{
+		$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
+		if (!$items_info)
+		{
+			$items_info = unserialize( $this->Application->RecallVar($event->getPrefixSpecial().'_ItemsInfo') );
+		}
+		
+		list($item_id, $field_values) = each($items_info);
+		
+		$object =& $event->getObject( Array('skip_autoload' => true) );
+		$object->SetFieldsFromHash($field_values);
+		$object->setID($item_id);
+		$this->setRequiredFields($event);
+		
+		$export_object =& $this->Application->recallObject('CatItemExportHelper');
+		
+		// save export/import options
+		if ($event->Special == 'export')
+		{
+			$export_ids = $this->Application->RecallVar($event->Prefix.'_export_ids');
+			$export_cats_ids = $this->Application->RecallVar($event->Prefix.'_export_cats_ids');
+			
+			// used for multistep export
+			$field_values['export_ids'] = $export_ids ? explode(',', $export_ids) : false;
+			$field_values['export_cats_ids'] = $export_cats_ids ? explode(',', $export_cats_ids) : Array( $this->Application->GetVar('m_cat_id') );
+		}
+		
+		$field_values['ExportColumns'] = $field_values['ExportColumns'] ? explode('|', substr($field_values['ExportColumns'], 1, -1) ) : Array();
+		$field_values['start_from'] = 0;
+		$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($field_values) );
+			
+		if( $export_object->verifyOptions($event) )
+		{
+			$this->doExport($event);
+		}
+		else
+		{
+			$event->status = erFAIL;
+			$event->redirect = false;
+		}
+	}
+	
+	/**
+	 * Enter description here...
+	 *
+	 * @param kEvent $event
+	 */
+	function doExport(&$event)
+	{
+		if ($event->Name == 'OnExportBegin')
+		{
+			$done_percent = 0;
+		}
+		else {
+			$export_options = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
+			$done_percent = round($export_options['start_from']  * 100 / $export_options['total_records'], 0);
+		}
+		
+		$block_params = Array(	'name' => $this->getModuleFolder($event).'/'.$event->Special.'_progress',
+								'percent_done' => $done_percent,
+								'percent_left' => 100 - $done_percent);
 
+		$this->Application->InitParser();
+		$this->Application->setUnitOption($event->Prefix, 'AutoLoad', false);
+		echo $this->Application->ParseBlock($block_params);
+		flush();
+		
+		$export_object =& $this->Application->recallObject('CatItemExportHelper');
+		
+		$action_method = 'perform'.ucfirst($event->Special);
+		$field_values = $export_object->$action_method($event);
+		
+		if ($field_values['start_from'] == $field_values['total_records'])
+		{
+			if ($event->Special == 'import') {
+				$this->Application->StoreVar('PermCache_UpdateRequired', 1);
+				$event->SetRedirectParam('index_file', 'category/category_maint.php');
+			}
+			else {
+				$event->redirect = $this->getModuleFolder($event).'/'.$event->Special.'_finish';
+			}
+		}
+		else {
+			$event->redirect = $this->getModuleFolder($event).'/'.$event->Special.'_progress';
+			$redirect_params = Array($event->getPrefixSpecial().'_event' => 'OnExportProgress', 'pass' => 'm,'.$event->getPrefixSpecial());
+			$event->setRedirectParams($redirect_params);
+		}
+	}
+	
+	/**
+	 * Next export steps
+	 *
+	 * @param kEvent $event
+	 */
+	function OnExportProgress(&$event)
+	{
+		$this->doExport($event);
+	}
+	
+	/**
+	 * Sets correct available & export fields
+	 *
+	 * @param kEvent $event
+	 */
+	function prepareExportColumns(&$event)
+	{
+		$object =& $event->getObject( Array('skip_autoload' => true) );
+		
+		$available_columns = Array();
+		
+		// category field (mixed)
+		$available_columns['__CATEGORY__CategoryPath'] = 'CategoryPath';
+		
+		if ($event->Special == 'import') {
+			// category field (separated fields)
+			$max_level = $this->Application->ConfigValue('MaxImportCategoryLevels');
+			$i = 0;
+			while ($i < $max_level) {
+				$available_columns['__CATEGORY__Category'.($i + 1)] = 'Category'.($i + 1);
+				$i++;
+			}
+		}
+		
+		// db fields
+		$fields = array_keys($object->Fields);
+		foreach ($fields as $field_name)
+		{
+			if (!$object->SkipField($field_name))
+			{
+				$available_columns[$field_name] = $field_name;
+			}
+		}
+		
+		// custom fields
+		$fields = array_keys($object->CustomFields);
+		foreach ($fields as $field_name)
+		{
+			$available_columns['__CUSTOM__'.$field_name] = $field_name;
+		}
+		
+		// columns already in use
+		$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
+		if ($items_info)
+		{
+			list($item_id, $field_values) = each($items_info);
+			$export_keys = $field_values['ExportColumns'];
+			$export_keys = $export_keys ? explode('|', substr($export_keys, 1, -1) ) : Array();
+		}
+		else {
+			$export_keys = Array();	
+		}
+		
+		$export_columns = Array();
+		foreach ($export_keys as $field_key)
+		{
+			$field_name = $this->getExportField($field_key);
+			$export_columns[$field_key] = $field_name;
+			unset($available_columns[$field_key]);
+		}
+		
+		$options = $object->GetFieldOptions('ExportColumns');
+		$options['options'] = $export_columns;
+		$object->SetFieldOptions('ExportColumns', $options);
+		
+		$options = $object->GetFieldOptions('AvailableColumns');
+		$options['options'] = $available_columns;
+		$object->SetFieldOptions('AvailableColumns', $options);
+		
+		if ($event->Special == 'import')
+		{
+			$import_filenames = Array();
+			
+			if ($folder_handle = opendir(EXPORT_PATH)) {
+				while (false !== ($file = readdir($folder_handle))) {
+					if ( substr($file, 0, 1) == '.' || strtolower($file) == 'cvs' || strtolower($file) == 'dummy' || filesize(EXPORT_PATH.'/'.$file) == 0) continue;
+					
+					$file_size = formatSize( filesize(EXPORT_PATH.'/'.$file) );
+					$import_filenames[$file] = $file.' ('.$file_size.')';
+				}
+				closedir($folder_handle);
+			}
+   			$options = $object->GetFieldOptions('ImportLocalFilename');
+			$options['options'] = $import_filenames;
+			$object->SetFieldOptions('ImportLocalFilename', $options);
+		}
+	}
+		
+	
+//	ImportLocalFilename
+	
+	function getExportField($field_key)
+	{
+		$prepends = Array('__CUSTOM__', '__CATEGORY__');
+		foreach ($prepends as $prepend)
+		{
+			if (substr($field_key, 0, strlen($prepend) ) == $prepend)
+			{
+				$field_key = substr($field_key, strlen($prepend), strlen($field_key) );
+				break;
+			}
+		}
+		return $field_key;
+	}
+	
+	/**
+	 * Shows export dialog
+	 *
+	 * @param kEvent $event
+	 */
+	function OnImport(&$event)
+	{
+		
+		$event->redirect = $this->getModuleFolder($event).'/import';
+		
+		$redirect_params = Array(	'm_opener' => 'd',
+									'index_file' => 'index4.php',
+									$this->Prefix.'.import_event' => 'OnNew',
+									'pass' => 'all,'.$this->Prefix.'.import');
+		
+		$event->setRedirectParams($redirect_params);
+	}
+	
+	/**
+	 * Prepares item for import/export operations
+	 *
+	 * @param kEvent $event
+	 */
+	function OnNew(&$event)
+	{
+		parent::OnNew($event);
+		
+		if ($event->Special != 'import' && $event->Special != 'export') return ;
+		$this->setRequiredFields($event);
+	}
+	
+	/**
+	 * set required fields based on import or export params
+	 *
+	 * @param kEvent $event
+	 */
+	function setRequiredFields(&$event)
+	{
+		$required_fields['common'] = Array('FieldsSeparatedBy', 'FieldsEnclosedBy', 'LineEndings', 'CategoryFormat');
+		
+		$required_fields['export'] = Array('ExportFormat', 'ExportFilename','ExportColumns');
+		$required_fields['import'] = Array('FieldTitles', 'ImportSource', 'CheckDuplicatesMethod'); // ImportFilename, ImportLocalFilename
+		
+		$object =& $event->getObject();
+		if ($event->Special == 'import')
+		{
+			$import_source = Array(1 => 'ImportFilename', 2 => 'ImportLocalFilename');
+			$used_field = $import_source[ $object->GetDBField('ImportSource') ];
+			
+			$required_fields[$event->Special][] = $used_field;
+			$object->Fields[$used_field]['error_field'] = 'ImportSource';
+			
+			if ($object->GetDBField('FieldTitles') == 2) $required_fields[$event->Special][] = 'ExportColumns'; // manual field titles
+		}
+		
+		$required_fields = array_merge($required_fields['common'], $required_fields[$event->Special]);
+		foreach ($required_fields as $required_field) {
+			$object->setRequired($required_field, true);
+		}
+	}
+	
+	/**
+	 * Saves selected category as new import category
+	 *
+	 * @param kEvent $event
+	 */
+	function OnSelectItems(&$event)
+	{
+		$items_info = $this->Application->GetVar('c');
+		
+		if ($items_info)
+		{
+			$selected_categories = array_keys($items_info);
+			$cat_id = array_shift($selected_categories);
+			
+			$sql = 'SELECT CategoryId FROM '.TABLE_PREFIX.'Category WHERE ResourceId = '.$cat_id;
+			$cat_id = $this->Conn->GetOne($sql);
+		}
+		else {
+			$cat_id = 0;
+		}
+		
+		$this->Application->StoreVar('ImportCategory', $cat_id);
+		$this->Application->StoreVar($event->getPrefixSpecial().'_ForceNotValid', 1); // not to loose import/export values on form refresh
+		
+		$this->Application->SetVar($event->getPrefixSpecial().'_id', 0);
+		$this->Application->SetVar($event->getPrefixSpecial().'_event', 'OnExportBegin');
+		
+		$passed = $this->Application->GetVar('passed');
+		$this->Application->SetVar('passed', $passed.','.$event->getPrefixSpecial());
+		$event->setEventParam('pass_events', true);
+		
+		$this->finalizePopup($event, null, $this->getModuleFolder($event).'/'.$event->Special);
+
+	}
+	
+	/**
+	 * Saves Import/Export settings to session
+	 *
+	 * @param kEvent $event
+	 */
+	function OnSaveSettings(&$event)
+	{
+		$event->redirect = false;
+		$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
+		if ($items_info) {
+			$this->Application->StoreVar($event->getPrefixSpecial().'_ItemsInfo', serialize($items_info));
+		}
+	}
+	
+/* === RELATED TO IMPORT/EXPORT: END === */
+
 }
 
 ?>
\ No newline at end of file
Index: trunk/core/kernel/globals.php
===================================================================
diff -u -N -r3523 -r3543
--- trunk/core/kernel/globals.php	(.../globals.php)	(revision 3523)
+++ trunk/core/kernel/globals.php	(.../globals.php)	(revision 3543)
@@ -394,5 +394,54 @@
 	{
 		return round(($pounds + ($ounces / 16)) * POUND_TO_KG, 5);
 	}
+	
+	/**
+	 * Formats file/memory size in nice way
+	 *
+	 * @param int $bytes
+	 * @return string
+	 * @access public
+	 */
+	function formatSize($bytes)
+	{
+		if ($bytes >= 1099511627776) {
+			$return = round($bytes / 1024 / 1024 / 1024 / 1024, 2);
+			$suffix = "TB";
+		} elseif ($bytes >= 1073741824) {
+			$return = round($bytes / 1024 / 1024 / 1024, 2);
+			$suffix = "GB";
+		} elseif ($bytes >= 1048576) {
+			$return = round($bytes / 1024 / 1024, 2);
+			$suffix = "MB";
+		} elseif ($bytes >= 1024) {
+			$return = round($bytes / 1024, 2);
+			$suffix = "KB";
+		} else {
+			$return = $bytes;
+			$suffix = "Byte";
+		}
+		$return .= ' '.$suffix;
+		return $return;
+	}
+	
+	/**
+	 * Enter description here...
+	 *
+	 * @param resource $filePointer the file resource to write to
+	 * @param Array $data the data to write out
+	 * @param string $delimiter the field separator
+	 * @param string $enclosure symbol to enclose field data to
+	 * @param string $recordSeparator symbols to separate records with
+	 */
+	function fputcsv2($filePointer, $data, $delimiter = ',', $enclosure = '"', $recordSeparator = "\r\n")
+	{
+		foreach($data as $field_index => $field_value) {
+			// replaces an enclosure with two enclosures
+			$data[$field_index] = str_replace($enclosure, $enclosure.$enclosure, $field_value);
+		}
 
+		$line = $enclosure.implode($enclosure.$delimiter.$enclosure, $data).$enclosure.$recordSeparator;
+		fwrite($filePointer, $line);
+	}
+
 ?>
\ No newline at end of file
Index: trunk/core/units/general/cat_event_handler.php
===================================================================
diff -u -N -r3299 -r3543
--- trunk/core/units/general/cat_event_handler.php	(.../cat_event_handler.php)	(revision 3299)
+++ trunk/core/units/general/cat_event_handler.php	(.../cat_event_handler.php)	(revision 3543)
@@ -237,9 +237,25 @@
 	 * @param kCatDBItem $object
 	 * @param kEvent $event
 	 */
-	function PrepareObject(&$object, &$event)
+	function prepareObject(&$object, &$event)
 	{
+		$this->prepareItemStatuses($event);
+		
+		if ($event->Special == 'export' || $event->Special == 'import')
+		{
+			$this->prepareExportColumns($event);
+		}
+	}
 
+	/**
+	 * Creates calculated fields for all item statuses based on config settings
+	 *
+	 * @param kEvent $event
+	 */
+	function prepareItemStatuses(&$event)
+	{
+		$object =& $event->getObject( Array('skip_autoload' => true) );
+		
 		$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
 
 		$new_days_var = getArrayValue($property_mappings, 'NewDays');
@@ -279,7 +295,7 @@
 														%1$s.PopItem)');
 		}
 	}
-
+	
 	function CalculateHotLimit(&$event)
 	{
 		$property_mappings = $this->Application->getUnitOption($event->Prefix, 'ItemPropertyMappings');
@@ -1005,7 +1021,365 @@
 
 		$object->SetPage($page);
 	}
+	
+/* === RELATED TO IMPORT/EXPORT: BEGIN === */
+	
+	/**
+	 * Returns module folder
+	 *
+	 * @param kEvent $event
+	 * @return string
+	 */
+	function getModuleFolder(&$event)
+	{
+		return $this->Application->getUnitOption($event->Prefix, 'ModuleFolder');
+	}
+	
+	/**
+	 * Shows export dialog
+	 *
+	 * @param kEvent $event
+	 */
+	function OnExport(&$event)
+	{
+		$selected_ids = $this->Application->GetVar('linklist');
+		$selected_cats_ids = $this->Application->GetVar('export_categories');
+		
+		$this->Application->StoreVar($event->Prefix.'_export_ids', $selected_ids ? implode(',', $selected_ids) : '' );
+		$this->Application->StoreVar($event->Prefix.'_export_cats_ids', $selected_cats_ids);
+		
+		$event->redirect = $this->getModuleFolder($event).'/export';
+		
+		$redirect_params = Array(	'm_opener' => 'd',
+									'index_file' => 'index4.php',
+									$this->Prefix.'.export_event' => 'OnNew',
+									'pass' => 'all,'.$this->Prefix.'.export');
+		
+		$event->setRedirectParams($redirect_params);
+	}
+	
+	/**
+	 * Export form validation & processing
+	 *
+	 * @param kEvent $event
+	 */
+	function OnExportBegin(&$event)
+	{
+		$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
+		if (!$items_info)
+		{
+			$items_info = unserialize( $this->Application->RecallVar($event->getPrefixSpecial().'_ItemsInfo') );
+		}
+		
+		list($item_id, $field_values) = each($items_info);
+		
+		$object =& $event->getObject( Array('skip_autoload' => true) );
+		$object->SetFieldsFromHash($field_values);
+		$object->setID($item_id);
+		$this->setRequiredFields($event);
+		
+		$export_object =& $this->Application->recallObject('CatItemExportHelper');
+		
+		// save export/import options
+		if ($event->Special == 'export')
+		{
+			$export_ids = $this->Application->RecallVar($event->Prefix.'_export_ids');
+			$export_cats_ids = $this->Application->RecallVar($event->Prefix.'_export_cats_ids');
+			
+			// used for multistep export
+			$field_values['export_ids'] = $export_ids ? explode(',', $export_ids) : false;
+			$field_values['export_cats_ids'] = $export_cats_ids ? explode(',', $export_cats_ids) : Array( $this->Application->GetVar('m_cat_id') );
+		}
+		
+		$field_values['ExportColumns'] = $field_values['ExportColumns'] ? explode('|', substr($field_values['ExportColumns'], 1, -1) ) : Array();
+		$field_values['start_from'] = 0;
+		$this->Application->StoreVar($event->getPrefixSpecial().'_options', serialize($field_values) );
+			
+		if( $export_object->verifyOptions($event) )
+		{
+			$this->doExport($event);
+		}
+		else
+		{
+			$event->status = erFAIL;
+			$event->redirect = false;
+		}
+	}
+	
+	/**
+	 * Enter description here...
+	 *
+	 * @param kEvent $event
+	 */
+	function doExport(&$event)
+	{
+		if ($event->Name == 'OnExportBegin')
+		{
+			$done_percent = 0;
+		}
+		else {
+			$export_options = unserialize($this->Application->RecallVar($event->getPrefixSpecial().'_options'));
+			$done_percent = round($export_options['start_from']  * 100 / $export_options['total_records'], 0);
+		}
+		
+		$block_params = Array(	'name' => $this->getModuleFolder($event).'/'.$event->Special.'_progress',
+								'percent_done' => $done_percent,
+								'percent_left' => 100 - $done_percent);
 
+		$this->Application->InitParser();
+		$this->Application->setUnitOption($event->Prefix, 'AutoLoad', false);
+		echo $this->Application->ParseBlock($block_params);
+		flush();
+		
+		$export_object =& $this->Application->recallObject('CatItemExportHelper');
+		
+		$action_method = 'perform'.ucfirst($event->Special);
+		$field_values = $export_object->$action_method($event);
+		
+		if ($field_values['start_from'] == $field_values['total_records'])
+		{
+			if ($event->Special == 'import') {
+				$this->Application->StoreVar('PermCache_UpdateRequired', 1);
+				$event->SetRedirectParam('index_file', 'category/category_maint.php');
+			}
+			else {
+				$event->redirect = $this->getModuleFolder($event).'/'.$event->Special.'_finish';
+			}
+		}
+		else {
+			$event->redirect = $this->getModuleFolder($event).'/'.$event->Special.'_progress';
+			$redirect_params = Array($event->getPrefixSpecial().'_event' => 'OnExportProgress', 'pass' => 'm,'.$event->getPrefixSpecial());
+			$event->setRedirectParams($redirect_params);
+		}
+	}
+	
+	/**
+	 * Next export steps
+	 *
+	 * @param kEvent $event
+	 */
+	function OnExportProgress(&$event)
+	{
+		$this->doExport($event);
+	}
+	
+	/**
+	 * Sets correct available & export fields
+	 *
+	 * @param kEvent $event
+	 */
+	function prepareExportColumns(&$event)
+	{
+		$object =& $event->getObject( Array('skip_autoload' => true) );
+		
+		$available_columns = Array();
+		
+		// category field (mixed)
+		$available_columns['__CATEGORY__CategoryPath'] = 'CategoryPath';
+		
+		if ($event->Special == 'import') {
+			// category field (separated fields)
+			$max_level = $this->Application->ConfigValue('MaxImportCategoryLevels');
+			$i = 0;
+			while ($i < $max_level) {
+				$available_columns['__CATEGORY__Category'.($i + 1)] = 'Category'.($i + 1);
+				$i++;
+			}
+		}
+		
+		// db fields
+		$fields = array_keys($object->Fields);
+		foreach ($fields as $field_name)
+		{
+			if (!$object->SkipField($field_name))
+			{
+				$available_columns[$field_name] = $field_name;
+			}
+		}
+		
+		// custom fields
+		$fields = array_keys($object->CustomFields);
+		foreach ($fields as $field_name)
+		{
+			$available_columns['__CUSTOM__'.$field_name] = $field_name;
+		}
+		
+		// columns already in use
+		$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
+		if ($items_info)
+		{
+			list($item_id, $field_values) = each($items_info);
+			$export_keys = $field_values['ExportColumns'];
+			$export_keys = $export_keys ? explode('|', substr($export_keys, 1, -1) ) : Array();
+		}
+		else {
+			$export_keys = Array();	
+		}
+		
+		$export_columns = Array();
+		foreach ($export_keys as $field_key)
+		{
+			$field_name = $this->getExportField($field_key);
+			$export_columns[$field_key] = $field_name;
+			unset($available_columns[$field_key]);
+		}
+		
+		$options = $object->GetFieldOptions('ExportColumns');
+		$options['options'] = $export_columns;
+		$object->SetFieldOptions('ExportColumns', $options);
+		
+		$options = $object->GetFieldOptions('AvailableColumns');
+		$options['options'] = $available_columns;
+		$object->SetFieldOptions('AvailableColumns', $options);
+		
+		if ($event->Special == 'import')
+		{
+			$import_filenames = Array();
+			
+			if ($folder_handle = opendir(EXPORT_PATH)) {
+				while (false !== ($file = readdir($folder_handle))) {
+					if ( substr($file, 0, 1) == '.' || strtolower($file) == 'cvs' || strtolower($file) == 'dummy' || filesize(EXPORT_PATH.'/'.$file) == 0) continue;
+					
+					$file_size = formatSize( filesize(EXPORT_PATH.'/'.$file) );
+					$import_filenames[$file] = $file.' ('.$file_size.')';
+				}
+				closedir($folder_handle);
+			}
+   			$options = $object->GetFieldOptions('ImportLocalFilename');
+			$options['options'] = $import_filenames;
+			$object->SetFieldOptions('ImportLocalFilename', $options);
+		}
+	}
+		
+	
+//	ImportLocalFilename
+	
+	function getExportField($field_key)
+	{
+		$prepends = Array('__CUSTOM__', '__CATEGORY__');
+		foreach ($prepends as $prepend)
+		{
+			if (substr($field_key, 0, strlen($prepend) ) == $prepend)
+			{
+				$field_key = substr($field_key, strlen($prepend), strlen($field_key) );
+				break;
+			}
+		}
+		return $field_key;
+	}
+	
+	/**
+	 * Shows export dialog
+	 *
+	 * @param kEvent $event
+	 */
+	function OnImport(&$event)
+	{
+		
+		$event->redirect = $this->getModuleFolder($event).'/import';
+		
+		$redirect_params = Array(	'm_opener' => 'd',
+									'index_file' => 'index4.php',
+									$this->Prefix.'.import_event' => 'OnNew',
+									'pass' => 'all,'.$this->Prefix.'.import');
+		
+		$event->setRedirectParams($redirect_params);
+	}
+	
+	/**
+	 * Prepares item for import/export operations
+	 *
+	 * @param kEvent $event
+	 */
+	function OnNew(&$event)
+	{
+		parent::OnNew($event);
+		
+		if ($event->Special != 'import' && $event->Special != 'export') return ;
+		$this->setRequiredFields($event);
+	}
+	
+	/**
+	 * set required fields based on import or export params
+	 *
+	 * @param kEvent $event
+	 */
+	function setRequiredFields(&$event)
+	{
+		$required_fields['common'] = Array('FieldsSeparatedBy', 'FieldsEnclosedBy', 'LineEndings', 'CategoryFormat');
+		
+		$required_fields['export'] = Array('ExportFormat', 'ExportFilename','ExportColumns');
+		$required_fields['import'] = Array('FieldTitles', 'ImportSource', 'CheckDuplicatesMethod'); // ImportFilename, ImportLocalFilename
+		
+		$object =& $event->getObject();
+		if ($event->Special == 'import')
+		{
+			$import_source = Array(1 => 'ImportFilename', 2 => 'ImportLocalFilename');
+			$used_field = $import_source[ $object->GetDBField('ImportSource') ];
+			
+			$required_fields[$event->Special][] = $used_field;
+			$object->Fields[$used_field]['error_field'] = 'ImportSource';
+			
+			if ($object->GetDBField('FieldTitles') == 2) $required_fields[$event->Special][] = 'ExportColumns'; // manual field titles
+		}
+		
+		$required_fields = array_merge($required_fields['common'], $required_fields[$event->Special]);
+		foreach ($required_fields as $required_field) {
+			$object->setRequired($required_field, true);
+		}
+	}
+	
+	/**
+	 * Saves selected category as new import category
+	 *
+	 * @param kEvent $event
+	 */
+	function OnSelectItems(&$event)
+	{
+		$items_info = $this->Application->GetVar('c');
+		
+		if ($items_info)
+		{
+			$selected_categories = array_keys($items_info);
+			$cat_id = array_shift($selected_categories);
+			
+			$sql = 'SELECT CategoryId FROM '.TABLE_PREFIX.'Category WHERE ResourceId = '.$cat_id;
+			$cat_id = $this->Conn->GetOne($sql);
+		}
+		else {
+			$cat_id = 0;
+		}
+		
+		$this->Application->StoreVar('ImportCategory', $cat_id);
+		$this->Application->StoreVar($event->getPrefixSpecial().'_ForceNotValid', 1); // not to loose import/export values on form refresh
+		
+		$this->Application->SetVar($event->getPrefixSpecial().'_id', 0);
+		$this->Application->SetVar($event->getPrefixSpecial().'_event', 'OnExportBegin');
+		
+		$passed = $this->Application->GetVar('passed');
+		$this->Application->SetVar('passed', $passed.','.$event->getPrefixSpecial());
+		$event->setEventParam('pass_events', true);
+		
+		$this->finalizePopup($event, null, $this->getModuleFolder($event).'/'.$event->Special);
+
+	}
+	
+	/**
+	 * Saves Import/Export settings to session
+	 *
+	 * @param kEvent $event
+	 */
+	function OnSaveSettings(&$event)
+	{
+		$event->redirect = false;
+		$items_info = $this->Application->GetVar( $event->getPrefixSpecial(true) );
+		if ($items_info) {
+			$this->Application->StoreVar($event->getPrefixSpecial().'_ItemsInfo', serialize($items_info));
+		}
+	}
+	
+/* === RELATED TO IMPORT/EXPORT: END === */
+
 }
 
 ?>
\ No newline at end of file
Index: trunk/core/units/general/cat_dbitem.php
===================================================================
diff -u -N -r3282 -r3543
--- trunk/core/units/general/cat_dbitem.php	(.../cat_dbitem.php)	(revision 3282)
+++ trunk/core/units/general/cat_dbitem.php	(.../cat_dbitem.php)	(revision 3543)
@@ -4,16 +4,23 @@
 	
 	var $CustomFields = Array();
 	
+	/**
+	 * Category path, needed for import
+	 *
+	 * @var Array
+	 */
+	var $CategoryPath = Array();
+	
 	function Init($prefix, $special, $event_params = null)
 	{
 		parent::Init($prefix, $special, $event_params);
 		
 		$item_type = $this->Application->getUnitOption($this->Prefix, 'ItemType');
-		$sql = 'SELECT CustomFieldId, FieldName FROM '.TABLE_PREFIX.'CustomField WHERE Type = %s';
-		$this->CustomFields = $this->Conn->GetCol( sprintf($sql, $item_type), 'FieldName' );
+		$sql = 'SELECT CustomFieldId, FieldName FROM '.TABLE_PREFIX.'CustomField WHERE Type = '.$item_type;
+		$this->CustomFields = $this->Conn->GetCol($sql, 'FieldName');
 	}
 	
-	function Create()
+	function Create($force_id=false, $system_create=false)
 	{
 		if (!$this->Validate()) return false;
 		
@@ -23,7 +30,7 @@
 		$this->SetDBField('CreatedById', $this->Application->GetVar('u_id'));
 		$this->generateFilename();
 		
-		$ret = parent::Create();
+		$ret = parent::Create($force_id, $system_create);
 		if($ret)
 		{
 			if ( kTempTablesHandler::IsTempTable($this->TableName) ) {
@@ -40,15 +47,15 @@
 		return $ret;
 	}
 	
-	function Update($id=null)
+	function Update($id=null, $system_update=false)
 	{
 		$this->checkFilename();
 		$this->VirtualFields['ResourceId'] = true;
 		$this->SetDBField('Modified', adodb_mktime() );
 		$this->SetDBField('ModifiedById', $this->Application->GetVar('u_id'));
 		$this->generateFilename();
 		
-		return parent::Update($id);
+		return parent::Update($id, $system_update);
 	}
 	
 	function checkFilename()
@@ -270,6 +277,78 @@
 		
 		if ( $name != $this->GetDBField('Filename') ) $this->SetDBField('Filename', $name);
 	}
+	
+	/**
+	 * Check if value is set for required field
+	 *
+	 * @param string $field field name
+	 * @param Array $params field options from config
+	 * @return bool
+	 * @access private
+	 */
+	function ValidateRequired($field, $params)
+	{
+		$res = true;
+		$error_field = isset($params['error_field']) ? $params['error_field'] : $field;
+		if ( getArrayValue($params,'required') )
+		{
+			if (getArrayValue($params, 'formatter') == 'kUploadFormatter')
+			{
+				$value = $this->GetDBField($field);
+				$res = is_array($value) && $value['size'] ? true : false;
+			}
+			else {
+				$res = ( (string) $this->FieldValues[$field] != '');
+			}
+		}
+		if (!$res) $this->FieldErrors[$error_field]['pseudo'] = 'required';
+		return $res;
+	}
+	
+	/**
+	 * Adds item to other category
+	 *
+	 * @param int $category_id
+	 * @param bool $is_primary
+	 */
+	function assignToCategory($category_id, $is_primary = false)
+	{
+		$check_sql = '	SELECT CategoryId
+						FROM '.TABLE_PREFIX.'CategoryItems
+						WHERE (ItemResourceId = '.$this->GetDBField('ResourceId').') AND (PrimaryCat = 1)';
+		$primary_category_id = $this->Conn->GetOne($check_sql);
+		if (!$primary_category_id) $is_primary = true;
+		
+		if ($primary_category_id == $category_id) return ;
+		
+		$sql = 'INSERT INTO '.TABLE_PREFIX.'CategoryItems (CategoryId,ItemResourceId,PrimaryCat) VALUES (%s,%s,%s)';
+		$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId'), $is_primary ? 1 : 0) );
+	}
+	
+	/**
+	 * Removes item from category specified
+	 *
+	 * @param int $category_id
+	 */
+	function removeFromCategory($category_id)
+	{
+		$sql = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems WHERE (CategoryId = %s) AND (ItemResourceId = %s)';
+		$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId')) );
+	}
+	
+	/**
+	 * Returns list of columns, that could exist in imported file
+	 *
+	 * @return Array
+	 */
+	function getPossibleExportColumns()
+	{
+		static $columns = null;
+		if (!is_array($columns)) {
+			$columns = array_merge($this->Fields['AvailableColumns']['options'], $this->Fields['ExportColumns']['options']);
+		}
+		return $columns;
+	}
 }
 
 ?>
\ No newline at end of file
Index: trunk/core/kernel/db/db_event_handler.php
===================================================================
diff -u -N -r3330 -r3543
--- trunk/core/kernel/db/db_event_handler.php	(.../db_event_handler.php)	(revision 3330)
+++ trunk/core/kernel/db/db_event_handler.php	(.../db_event_handler.php)	(revision 3543)
@@ -1269,7 +1269,8 @@
 			$opener_stack = $opener_stack ? unserialize($opener_stack) : Array();
 			//array_pop($opener_stack);
 
-			$new_level = 'index4.php|'.ltrim($this->Application->BuildEnv($t, Array('m_opener' => 'u'), 'all'), ENV_VAR_NAME.'=');
+			$pass_events = $event->getEventParam('pass_events');
+			$new_level = 'index4.php|'.ltrim($this->Application->BuildEnv($t, Array('m_opener' => 'u'), 'all', $pass_events), ENV_VAR_NAME.'=');
 			array_push($opener_stack,$new_level);
 			$this->Application->StoreVar('opener_stack',serialize($opener_stack));
 		}
Index: trunk/kernel/units/general/cat_dbitem.php
===================================================================
diff -u -N -r3282 -r3543
--- trunk/kernel/units/general/cat_dbitem.php	(.../cat_dbitem.php)	(revision 3282)
+++ trunk/kernel/units/general/cat_dbitem.php	(.../cat_dbitem.php)	(revision 3543)
@@ -4,16 +4,23 @@
 	
 	var $CustomFields = Array();
 	
+	/**
+	 * Category path, needed for import
+	 *
+	 * @var Array
+	 */
+	var $CategoryPath = Array();
+	
 	function Init($prefix, $special, $event_params = null)
 	{
 		parent::Init($prefix, $special, $event_params);
 		
 		$item_type = $this->Application->getUnitOption($this->Prefix, 'ItemType');
-		$sql = 'SELECT CustomFieldId, FieldName FROM '.TABLE_PREFIX.'CustomField WHERE Type = %s';
-		$this->CustomFields = $this->Conn->GetCol( sprintf($sql, $item_type), 'FieldName' );
+		$sql = 'SELECT CustomFieldId, FieldName FROM '.TABLE_PREFIX.'CustomField WHERE Type = '.$item_type;
+		$this->CustomFields = $this->Conn->GetCol($sql, 'FieldName');
 	}
 	
-	function Create()
+	function Create($force_id=false, $system_create=false)
 	{
 		if (!$this->Validate()) return false;
 		
@@ -23,7 +30,7 @@
 		$this->SetDBField('CreatedById', $this->Application->GetVar('u_id'));
 		$this->generateFilename();
 		
-		$ret = parent::Create();
+		$ret = parent::Create($force_id, $system_create);
 		if($ret)
 		{
 			if ( kTempTablesHandler::IsTempTable($this->TableName) ) {
@@ -40,15 +47,15 @@
 		return $ret;
 	}
 	
-	function Update($id=null)
+	function Update($id=null, $system_update=false)
 	{
 		$this->checkFilename();
 		$this->VirtualFields['ResourceId'] = true;
 		$this->SetDBField('Modified', adodb_mktime() );
 		$this->SetDBField('ModifiedById', $this->Application->GetVar('u_id'));
 		$this->generateFilename();
 		
-		return parent::Update($id);
+		return parent::Update($id, $system_update);
 	}
 	
 	function checkFilename()
@@ -270,6 +277,78 @@
 		
 		if ( $name != $this->GetDBField('Filename') ) $this->SetDBField('Filename', $name);
 	}
+	
+	/**
+	 * Check if value is set for required field
+	 *
+	 * @param string $field field name
+	 * @param Array $params field options from config
+	 * @return bool
+	 * @access private
+	 */
+	function ValidateRequired($field, $params)
+	{
+		$res = true;
+		$error_field = isset($params['error_field']) ? $params['error_field'] : $field;
+		if ( getArrayValue($params,'required') )
+		{
+			if (getArrayValue($params, 'formatter') == 'kUploadFormatter')
+			{
+				$value = $this->GetDBField($field);
+				$res = is_array($value) && $value['size'] ? true : false;
+			}
+			else {
+				$res = ( (string) $this->FieldValues[$field] != '');
+			}
+		}
+		if (!$res) $this->FieldErrors[$error_field]['pseudo'] = 'required';
+		return $res;
+	}
+	
+	/**
+	 * Adds item to other category
+	 *
+	 * @param int $category_id
+	 * @param bool $is_primary
+	 */
+	function assignToCategory($category_id, $is_primary = false)
+	{
+		$check_sql = '	SELECT CategoryId
+						FROM '.TABLE_PREFIX.'CategoryItems
+						WHERE (ItemResourceId = '.$this->GetDBField('ResourceId').') AND (PrimaryCat = 1)';
+		$primary_category_id = $this->Conn->GetOne($check_sql);
+		if (!$primary_category_id) $is_primary = true;
+		
+		if ($primary_category_id == $category_id) return ;
+		
+		$sql = 'INSERT INTO '.TABLE_PREFIX.'CategoryItems (CategoryId,ItemResourceId,PrimaryCat) VALUES (%s,%s,%s)';
+		$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId'), $is_primary ? 1 : 0) );
+	}
+	
+	/**
+	 * Removes item from category specified
+	 *
+	 * @param int $category_id
+	 */
+	function removeFromCategory($category_id)
+	{
+		$sql = 'DELETE FROM '.TABLE_PREFIX.'CategoryItems WHERE (CategoryId = %s) AND (ItemResourceId = %s)';
+		$this->Conn->Query( sprintf($sql, $category_id, $this->GetDBField('ResourceId')) );
+	}
+	
+	/**
+	 * Returns list of columns, that could exist in imported file
+	 *
+	 * @return Array
+	 */
+	function getPossibleExportColumns()
+	{
+		static $columns = null;
+		if (!is_array($columns)) {
+			$columns = array_merge($this->Fields['AvailableColumns']['options'], $this->Fields['ExportColumns']['options']);
+		}
+		return $columns;
+	}
 }
 
 ?>
\ No newline at end of file
Index: trunk/core/units/general/my_application.php
===================================================================
diff -u -N -r3103 -r3543
--- trunk/core/units/general/my_application.php	(.../my_application.php)	(revision 3103)
+++ trunk/core/units/general/my_application.php	(.../my_application.php)	(revision 3543)
@@ -12,6 +12,7 @@
 			$this->registerClass('InpSessionStorage',MODULES_PATH.'/kernel/units/general/inp_ses_storage.php','SessionStorage');
 
 			$this->registerClass('kCatDBItem',MODULES_PATH.'/kernel/units/general/cat_dbitem.php');
+			$this->registerClass('kCatDBItemExportHelper',MODULES_PATH.'/kernel/units/general/cat_dbitem_export.php', 'CatItemExportHelper');
 			$this->registerClass('kCatDBList',MODULES_PATH.'/kernel/units/general/cat_dblist.php');
 			$this->registerClass('kCatDBEventHandler',MODULES_PATH.'/kernel/units/general/cat_event_handler.php');
 			$this->registerClass('kCatDBTagProcessor',MODULES_PATH.'/kernel/units/general/cat_tag_processor.php');
Index: trunk/admin/browse.php
===================================================================
diff -u -N -r3376 -r3543
--- trunk/admin/browse.php	(.../browse.php)	(revision 3376)
+++ trunk/admin/browse.php	(.../browse.php)	(revision 3543)
@@ -192,54 +192,54 @@
 </div>
 <!-- alex mark -->
 <table class="toolbar" height="30" cellspacing="0" cellpadding="0" width="100%" border="0">
-  <tbody>
-   <tr>
-   <td>
-       <div name="toolBar" id="mainToolBar">
-          <tb:button action="upcat" title="<?php echo admin_language("la_ToolTip_Up"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="homecat" title="<?php echo admin_language("la_ToolTip_Home"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="new_cat" title="<?php echo admin_language("la_ToolTip_New_Category"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="editcat" title="<?php echo admin_language("la_ToolTip_Edit_Current_Category"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+	<tbody>
+		<tr>
+			<td>
+				<div name="toolBar" id="mainToolBar">
+					<tb:button action="upcat" title="<?php echo admin_language("la_ToolTip_Up"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="homecat" title="<?php echo admin_language("la_ToolTip_Home"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="new_cat" title="<?php echo admin_language("la_ToolTip_New_Category"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="editcat" title="<?php echo admin_language("la_ToolTip_Edit_Current_Category"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
 
-<?php
-            foreach($NewButtons as $btn)
-            {
-                print "<tb:button action=\"".$btn["Action"]."\" title=\"".$btn["Alt"]."\" ImagePath=\"".$btn["ImagePath"]."\" ";
-                if(strlen($btn["Tab"])>0)
-                    print "tab=\"".$btn["Tab"]."\"";
-                print ">\n";
-            }
-?>
-          <tb:button action="edit" title="<?php echo admin_language("la_ToolTip_Edit"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="delete" title="<?php echo admin_language("la_ToolTip_Delete"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="approve" title="<?php echo admin_language("la_ToolTip_Approve"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="decline" title="<?php echo admin_language("la_ToolTip_Decline"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-<?php          
-          /*<tb:button action="import" title="<?php echo admin_language("la_ToolTip_Import"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="export" title="<?php echo admin_language("la_ToolTip_Export"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">*/
-?>          	
+					<?php
+					    foreach($NewButtons as $btn)
+					    {
+					        print '<tb:button action="'.$btn['Action'].'" title="'.$btn['Alt'].'" ImagePath="'.$btn['ImagePath'].'" ';
+					        if (getArrayValue($btn, 'Tab')) print 'tab="'.$btn['Tab'].'"';
+					        print ">\n";
+					    }
+					?>
+					
+					<tb:button action="edit" title="<?php echo admin_language("la_ToolTip_Edit"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="delete" title="<?php echo admin_language("la_ToolTip_Delete"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="approve" title="<?php echo admin_language("la_ToolTip_Approve"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="decline" title="<?php echo admin_language("la_ToolTip_Decline"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					
+					<tb:button action="import" title="<?php echo admin_language("la_ToolTip_Import"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="export" title="<?php echo admin_language("la_ToolTip_Export"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
 
-			<tb:button action="rebuild_cache" title="<?php echo admin_language("la_ToolTip_RebuildCategoryCache"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="rebuild_cache" title="<?php echo admin_language("la_ToolTip_RebuildCategoryCache"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+		          	<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
           
-		  <tb:button action="cut" title="<?php echo admin_language("la_ToolTip_Cut"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="copy" title="<?php echo admin_language("la_ToolTip_Copy"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="paste" title="<?php echo admin_language("la_ToolTip_Paste"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="move_up" title="<?php echo admin_language("la_ToolTip_Move_Up"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="move_down" title="<?php echo admin_language("la_ToolTip_Move_Down"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="print" title="<?php echo admin_language("la_ToolTip_Print"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-          <tb:button action="view" title="<?php echo admin_language("la_ToolTip_View"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
-       </div>
-   </td>
-   </tr>
-  </tbody>
+					<tb:button action="cut" title="<?php echo admin_language("la_ToolTip_Cut"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="copy" title="<?php echo admin_language("la_ToolTip_Copy"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="paste" title="<?php echo admin_language("la_ToolTip_Paste"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="move_up" title="<?php echo admin_language("la_ToolTip_Move_Up"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="move_down" title="<?php echo admin_language("la_ToolTip_Move_Down"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:separator ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="print" title="<?php echo admin_language("la_ToolTip_Print"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+					<tb:button action="view" title="<?php echo admin_language("la_ToolTip_View"); ?>" ImagePath="<?php echo $imagesURL."/toolbar/";?>">
+				</div>
+			</td>
+		</tr>
+	</tbody>
 </table>
+
 <table cellspacing="0" cellpadding="0" width="100%" bgcolor="#e0e0da" border="0" class="tableborder_full_a">
    <tbody>
     <tr>
Index: trunk/kernel/units/general/cat_tag_processor.php
===================================================================
diff -u -N -r2893 -r3543
--- trunk/kernel/units/general/cat_tag_processor.php	(.../cat_tag_processor.php)	(revision 2893)
+++ trunk/kernel/units/general/cat_tag_processor.php	(.../cat_tag_processor.php)	(revision 3543)
@@ -23,6 +23,58 @@
 			
 			return isset($icons[$value]) ? $icons[$value] : $icons['default'];
 		}
+		
+		/**
+		 * Returns path where exported category items should be saved
+		 *
+		 * @param Array $params
+		 */
+		function ExportPath($params)
+		{
+			$ret = EXPORT_PATH.'/';
+
+			if( getArrayValue($params, 'as_url') )
+			{
+				$ret = str_replace( FULL_PATH.'/', $this->Application->BaseURL(), $ret);
+			}
+			
+			$export_options = unserialize($this->Application->RecallVar($this->getPrefixSpecial().'_options'));
+			$ret .= $export_options['ExportFilename'].'.'.($export_options['ExportFormat'] == 1 ? 'csv' : 'xml');
+			
+			return $ret;
+		}
+		
+		function CategoryPath($params)
+		{
+			if (!isset($params['cat_id']))
+			{
+				$params['cat_id'] = $this->Application->RecallVar($params['session_var'], 0);
+			}
+			
+			$block_params['separator'] = $params['separator'];
+			
+			if($params['cat_id'] == 0)
+			{
+				$block_params['name'] = $params['rootcatblock'];
+				return $this->Application->ParseBlock($block_params);
+			}
+			else 
+			{
+				$cat_object =& $this->Application->recallObject('c', 'c_List');
+				$sql = 'SELECT CategoryId, ParentId, Name FROM '.$cat_object->TableName.' WHERE CategoryId = '.$params['cat_id'];
+				$res = $this->Conn->GetRow($sql);
+				
+				$block_params['name'] = $params['block'];			
+				$block_params['cat_name'] = $res['Name'];
+				$block_params['cat_id'] = $res['CategoryId'];
+				
+				$next_params['separator'] = $params['separator'];
+				$next_params['rootcatblock'] = $params['rootcatblock'];
+				$next_params['block'] = $params['block'];
+				$next_params['cat_id'] = $res['ParentId'];
+				return $this->CategoryPath($next_params).$this->Application->ParseBlock($block_params);
+			}
+		}	
 	}
 
 ?>
\ No newline at end of file
Index: trunk/kernel/units/general/my_application.php
===================================================================
diff -u -N -r3103 -r3543
--- trunk/kernel/units/general/my_application.php	(.../my_application.php)	(revision 3103)
+++ trunk/kernel/units/general/my_application.php	(.../my_application.php)	(revision 3543)
@@ -12,6 +12,7 @@
 			$this->registerClass('InpSessionStorage',MODULES_PATH.'/kernel/units/general/inp_ses_storage.php','SessionStorage');
 
 			$this->registerClass('kCatDBItem',MODULES_PATH.'/kernel/units/general/cat_dbitem.php');
+			$this->registerClass('kCatDBItemExportHelper',MODULES_PATH.'/kernel/units/general/cat_dbitem_export.php', 'CatItemExportHelper');
 			$this->registerClass('kCatDBList',MODULES_PATH.'/kernel/units/general/cat_dblist.php');
 			$this->registerClass('kCatDBEventHandler',MODULES_PATH.'/kernel/units/general/cat_event_handler.php');
 			$this->registerClass('kCatDBTagProcessor',MODULES_PATH.'/kernel/units/general/cat_tag_processor.php');
Index: trunk/core/units/general/cat_tag_processor.php
===================================================================
diff -u -N -r2893 -r3543
--- trunk/core/units/general/cat_tag_processor.php	(.../cat_tag_processor.php)	(revision 2893)
+++ trunk/core/units/general/cat_tag_processor.php	(.../cat_tag_processor.php)	(revision 3543)
@@ -23,6 +23,58 @@
 			
 			return isset($icons[$value]) ? $icons[$value] : $icons['default'];
 		}
+		
+		/**
+		 * Returns path where exported category items should be saved
+		 *
+		 * @param Array $params
+		 */
+		function ExportPath($params)
+		{
+			$ret = EXPORT_PATH.'/';
+
+			if( getArrayValue($params, 'as_url') )
+			{
+				$ret = str_replace( FULL_PATH.'/', $this->Application->BaseURL(), $ret);
+			}
+			
+			$export_options = unserialize($this->Application->RecallVar($this->getPrefixSpecial().'_options'));
+			$ret .= $export_options['ExportFilename'].'.'.($export_options['ExportFormat'] == 1 ? 'csv' : 'xml');
+			
+			return $ret;
+		}
+		
+		function CategoryPath($params)
+		{
+			if (!isset($params['cat_id']))
+			{
+				$params['cat_id'] = $this->Application->RecallVar($params['session_var'], 0);
+			}
+			
+			$block_params['separator'] = $params['separator'];
+			
+			if($params['cat_id'] == 0)
+			{
+				$block_params['name'] = $params['rootcatblock'];
+				return $this->Application->ParseBlock($block_params);
+			}
+			else 
+			{
+				$cat_object =& $this->Application->recallObject('c', 'c_List');
+				$sql = 'SELECT CategoryId, ParentId, Name FROM '.$cat_object->TableName.' WHERE CategoryId = '.$params['cat_id'];
+				$res = $this->Conn->GetRow($sql);
+				
+				$block_params['name'] = $params['block'];			
+				$block_params['cat_name'] = $res['Name'];
+				$block_params['cat_id'] = $res['CategoryId'];
+				
+				$next_params['separator'] = $params['separator'];
+				$next_params['rootcatblock'] = $params['rootcatblock'];
+				$next_params['block'] = $params['block'];
+				$next_params['cat_id'] = $res['ParentId'];
+				return $this->CategoryPath($next_params).$this->Application->ParseBlock($block_params);
+			}
+		}	
 	}
 
 ?>
\ No newline at end of file
Index: trunk/kernel/admin_templates/incs/form_blocks.tpl
===================================================================
diff -u -N -r3310 -r3543
--- trunk/kernel/admin_templates/incs/form_blocks.tpl	(.../form_blocks.tpl)	(revision 3310)
+++ trunk/kernel/admin_templates/incs/form_blocks.tpl	(.../form_blocks.tpl)	(revision 3543)
@@ -208,14 +208,22 @@
 <inp2:m_blockend/>
 
 <inp2:m_block name="inp_radio_item"/>
-	<input type="radio" <inp2:m_param name="checked"/> name="<inp2:$prefix_InputName field="$field"/>" id="<inp2:$prefix_InputName field="$field"/>_<inp2:m_param name="key"/>" value="<inp2:m_param name="key"/>" onclick="<inp2:m_param name="onclick"/>"><label for="<inp2:$prefix_InputName field="$field"/>_<inp2:m_param name="key"/>"><inp2:m_phrase label="$option"/></label>&nbsp;
+	<input type="radio" <inp2:m_param name="checked"/> name="<inp2:$prefix_InputName field="$field"/>" id="<inp2:$prefix_InputName field="$field"/>_<inp2:m_param name="key"/>" value="<inp2:m_param name="key"/>" onclick="<inp2:m_param name="onclick"/>" onchange="<inp2:m_param name="onchange"/>"><label for="<inp2:$prefix_InputName field="$field"/>_<inp2:m_param name="key"/>"><inp2:m_param name="option"/></label>&nbsp;
 <inp2:m_blockend/>
 
-<inp2:m_block name="inp_edit_radio" is_last="" pass_tabindex="" onclick=""/>
+<inp2:m_block name="inp_radio_phrase"/>
+	<input type="radio" <inp2:m_param name="checked"/> name="<inp2:$prefix_InputName field="$field"/>" id="<inp2:$prefix_InputName field="$field"/>_<inp2:m_param name="key"/>" value="<inp2:m_param name="key"/>" onclick="<inp2:m_param name="onclick"/>" onchange="<inp2:m_param name="onchange"/>"><label for="<inp2:$prefix_InputName field="$field"/>_<inp2:m_param name="key"/>"><inp2:m_phrase label="$option"/></label>&nbsp;
+<inp2:m_blockend/>
+
+<inp2:m_block name="inp_edit_radio" is_last="" pass_tabindex="" onclick="" onchange="" use_phrases="1"/>
 	<tr class="<inp2:m_odd_even odd="table_color1" even="table_color2"/>">
 		<inp2:m_ParseBlock name="inp_edit_field_caption" prefix="$prefix" field="$field" title="$title" is_last="$is_last"/>
 		<td>
-			<inp2:$prefix_PredefinedOptions field="$field" tabindex="$pass_tabindex" block="inp_radio_item" selected="checked" onclick="$onclick" />
+			<inp2:m_if check="m_ParamEquals" name="use_phrases" value="1">
+				<inp2:$prefix_PredefinedOptions field="$field" tabindex="$pass_tabindex" block="inp_radio_phrase" selected="checked" onclick="$onclick" onchange="$onchange" />
+			<inp2:m_else />
+				<inp2:$prefix_PredefinedOptions field="$field" tabindex="$pass_tabindex" block="inp_radio_item" selected="checked" onclick="$onclick" onchange="$onchange" />
+			</inp2:m_if>	
 		</td>
 		<td class="error"><inp2:$prefix_Error field="$field"/>&nbsp;</td>
 	</tr>
@@ -226,7 +234,8 @@
 		<inp2:m_ParseBlock name="inp_edit_field_caption" prefix="$prefix" field="$field" title="$title" is_last="$is_last" NamePrefix="_cb_"/>
 		<td>
 			<input type="hidden" id="<inp2:$prefix_InputName field="$field"/>" name="<inp2:$prefix_InputName field="$field"/>" value="<inp2:$prefix_Field field="$field" db="db"/>">
-			<input tabindex="<inp2:m_get param="tab_index"/>" type="checkbox" id="_cb_<inp2:$prefix_InputName field="$field"/>" name="_cb_<inp2:$prefix_InputName field="$field"/>" <inp2:$prefix_Field field="$field" checked="checked" db="db"/> class="<inp2:m_param name="field_class"/>" onclick="update_checkbox(this, document.getElementById('<inp2:$prefix_InputName field="$field"/>'))" onchange="<inp2:m_param name="onchange" />">
+			<!--<input tabindex="<inp2:m_get param="tab_index"/>" type="checkbox" id="_cb_<inp2:$prefix_InputName field="$field"/>" name="_cb_<inp2:$prefix_InputName field="$field"/>" <inp2:$prefix_Field field="$field" checked="checked" db="db"/> class="<inp2:m_param name="field_class"/>" onclick="update_checkbox(this, document.getElementById('<inp2:$prefix_InputName field="$field"/>'));" onchange="<inp2:m_param name="onchange"/>">-->
+			<input tabindex="<inp2:m_get param="tab_index"/>" type="checkbox" id="_cb_<inp2:$prefix_InputName field="$field"/>" name="_cb_<inp2:$prefix_InputName field="$field"/>" <inp2:$prefix_Field field="$field" checked="checked" db="db"/> class="<inp2:m_param name="field_class"/>" onchange="update_checkbox(this, document.getElementById('<inp2:$prefix_InputName field="$field"/>'));<inp2:m_param name="onchange"/>">
 			<inp2:m_if check="{$prefix}_HasParam" name="hint_label"><inp2:m_phrase label="$hint_label"/></inp2:m_if>
 		</td>
 		<td class="error"><inp2:$prefix_Error field="$field"/>&nbsp;</td>
Index: trunk/kernel/admin/include/toolbar/browse.php
===================================================================
diff -u -N -r3427 -r3543
--- trunk/kernel/admin/include/toolbar/browse.php	(.../browse.php)	(revision 3427)
+++ trunk/kernel/admin/include/toolbar/browse.php	(.../browse.php)	(revision 3543)
@@ -266,6 +266,7 @@
 			case 'unselect':
 				k4_action = 'unselect("'+prefix_special+'")';
 				break;
+			
 			case 'approve':
 				k4_action = 'approve_items("'+prefix_special+'")';
 				break;
@@ -276,13 +277,22 @@
 			case 'm_rebuild_cache':
 				k4_action = 'rebuild_cache("c")';
 				break;
+
+		 	case 'import':
+				k4_action = 'import_items("'+prefix_special+'")';
+				break;
+
+			case 'export':
+				k4_action = 'export_items("'+prefix_special+'")';
+				break;
 				
 			case 'copy':
   				k4_action = 'copy_items("'+prefix_special+'")';
   				break;
   			case 'cut':
   				k4_action = 'cut_items("'+prefix_special+'")';
   				break;
+  			
   			case 'move_up':
   				k4_action = 'move_up("'+prefix_special+'")';
   				break;
@@ -312,6 +322,18 @@
 		submit_event(prefix_special,'OnMassDecline','')
 	}
   
+	function import_items(prefix_special)
+	{
+		set_hidden_field('remove_specials['+prefix_special+']',1);
+		submit_event(prefix_special,'OnImport','')
+	}
+	
+	function export_items(prefix_special)
+	{
+		set_hidden_field('remove_specials['+prefix_special+']',1);
+		submit_event(prefix_special,'OnExport','')
+	}
+	
 	function edit()
 	{
 		edit_item( queryTabRegistry('tab_id', activeTab.id, 'prefix_special') );
@@ -371,15 +393,14 @@
       //toggleMenu();
    }
 
-   function AddButtonAction(actionname,actionval)
+   function AddButtonAction(action_name,action_value)
    {
-     var item = new Array(actionname,actionval);
-     actionlist[actionlist.length] = item;
+     actionlist[actionlist.length] = new Array(action_name, action_value);
    }
 
    function actionHandler(button)
    {
-     //alert('a button has been pressed!');
+//     alert('a button has been pressed!');
      for(i=0; i<actionlist.length;i++)
      {
 
@@ -511,58 +532,80 @@
       return true;
    }
 
-   function check_submit(page,actionValue)
-   {      
-   	 
-   	 if (actionValue.match(/delete$/)) {
+	function check_submit(page, actionValue)
+	{      
+		if (actionValue.match(/delete$/))
+		{
 			if (!theMainScript.Confirm(lang_DeleteConfirm)) return;	
 		}
    	 
-     var formname = '';
-     var action_prefix ='';
+		var formname = '';
+		var action_prefix ='';
 
-     if ((activeTab) && (!isAnyChecked('categories')))
-     {
-     	 form_name = activeTab.id;
-       action_prefix = activeTab.getAttribute("ActionPrefix");
-       if(page.length==0)
-         page = activeTab.getAttribute("EditURL");
+		var isCatImportExport = activeTab && isAnyChecked('categories') && (actionValue == 'import' || actionValue == 'export');
+		
+		if (activeTab && (!isAnyChecked('categories') || isCatImportExport))
+		{
+			form_name = activeTab.id;
+			action_prefix = activeTab.getAttribute("ActionPrefix");
+			if (page.length == 0) page = activeTab.getAttribute("EditURL");
        
-       if ( action_prefix.match("k4:(.*)") )
-       {
-       		act = RegExp.$1;
-       		act = act.replace('$\$event$$', actionValue);
-       		act = act.replace('$\$prefix$$', activeTab.getAttribute("PrefixSpecial") );
-			eval(act);
-			return;
-       }
-     }
-     else
-     {
-     	 form_name = 'categories';
-       action_prefix = 'm_cat_';
-       if(page.length==0)
-       page="$admin" + '/category/addcategory';
-     }
-     var f = document.getElementsByName(form_name+'_form')[0];
-     
-     if(f)
-     {
-     	if (actionValue.substring(0,2) == 'm_')
-     	{
-     		f.Action.value = actionValue;
+			if ( action_prefix.match("k4:(.*)") )
+			{
+				act = RegExp.$1;
+				act = act.replace('$\$event$$', actionValue);
+				act = act.replace('$\$prefix$$', activeTab.getAttribute("PrefixSpecial") );
+				eval(act);
+				return;
+			}
+			else if(actionValue == 'import' || actionValue == 'export')
+			{
+				save_selected_categories('export_categories');
+				return k4_actionHandler(actionValue, activeTab.getAttribute("PrefixSpecial"));
+			}
+		}
+		else
+		{
+			form_name = 'categories';
+			action_prefix = 'm_cat_';
+			if (page.length == 0) page = "$admin" + '/category/addcategory';
+		}
+		
+		var f = document.getElementsByName(form_name+'_form')[0];
+		if(f)
+		{
+			if (actionValue.substring(0,2) == 'm_')
+			{
+     			f.Action.value = actionValue;
+     		}
+     		else
+     		{
+	     		f.Action.value = action_prefix + actionValue;
+     		}
+     		
+      		f.action = '$rootURL' +  page + '.php?'+ env;
+//			alert(f.name+ ' is submitting to '+ f.action + ' action=' + f.Action.value);
+			f.submit();
      	}
-     	else
-     	{
-     		f.Action.value = action_prefix + actionValue;
-     	}      
-      
-      f.action = '$rootURL' +  page + '.php?'+ env;
-//      alert(f.name+ ' is submitting to '+ f.action + ' action=' + f.Action.value);
-      f.submit();
-     }
-   } // check submit
+	} // check submit
 
+	function save_selected_categories(field_name)
+	{
+		var result = '';
+		var checkboxes = document.getElementsByName('catlist[]');
+		
+		for (var i = 0; i < checkboxes.length; i++)
+		{
+			if (checkboxes[i].checked == true)
+			{
+				result += checkboxes[i].value + ',';
+			}
+		}
+		result = result.replace(/(.*),\$/, '\$1');
+		if (activeTab) \$form_prefix = activeTab.id;
+		set_hidden_field(field_name, result);
+	}
+	
     function edit_current()
     {
       if(CurrentCat==0)