category_left, category_right, category_depth

Hello,
I set data in the table cn_hikashop_category self.
It works.
But I set no data for fileds category_left, category_right, category_depth
So I have no tree for categories left up.
I want that Hikashop recalculate my imported data, that fileds category_left, category_right, category_depth filled.
Is it possible?

Thanks

Hello,

and how can I the script execute?
In joomla? On the shell?
What is a simple way?

Thanks

I don't understand, what a view for wich page is
Another way?

I started code
It does'nt work.
No errors
One Idea?

Does'nt work
I set my code as first - Echo "Anfang"; and last - Echo "Ende";
I see "Anfang" as output but not "Ende"
I set Echo $database; after $database =& JFactory::getDBO(); but I see nothing.
I think "& JFactory::getDBO()" does'nt work
With fake categorie does'nt work too

<?php
echo "Anfang";
$database =& JFactory::getDBO();
$categoryClass = hikashop::get('class.category');
$query = 'SELECT category_left,category_right,category_depth,category_id,category_parent_id FROM '.hikashop::table('category').' ORDER BY category_left ASC';
$database->setQuery($query);
$categories = $database->loadObjectList();
$root = null;
$categoryClass->categories = array();
foreach($categories as $cat){
$categoryClass->categories[$cat->category_parent_id][]=$cat;
echo $cat->categoriy_parent_id;
if(empty($cat->category_parent_id)){
$root = $cat;
}
}
$categoryClass->rebuildTree($root,0,1);
echo "Erfolg!";
I copied code from internet

Yes
That does'nt work with one single category, that I in Hikashop Menu set

Ok
I have it
It is not fine solution, but it works
I have inserted the code in category/lising.php
It works