Import Menu problems

I have exported Menu as a CSV using your component on a Joomla 2.5 website. I am trying to reimport the menu file onto a Joomla 3.4 website, and I get this error:

Import abort with exception

Duplicate entry '0-1-root-*' for key 'idx_client_id_parent_id_alias_language' SQL=INSERT INTO `in2ho_menu` (`menutype`,`title`,`alias`,`note`,`path`,`link`,`type`,`published`,`level`,`browserNav`,`access`,`img`,`template_style_id`,`params`,`lft`,`rgt`,`home`,`language`,`client_id`) VALUES ('','Menu_Item_Root','root','','','','','1','0','0','0','','0','','0','419','0','*','0')

I do not know what to do from here. What would you recommend?

Thanks,
Dan

Hello Daniel,
There is an option in Profile settings to choose either Insert, update or synchronise, You need to choose Insert to Add new menus to your Joomla 3.x site. And you also need to choose skip for ID column as This is the primary key and other records might have the same value as on your old site.

** And There is a root record in Menu table which needs to be removed from you CSV file or you can apply a filter in your Export profile on Joomla 2.5 website to skip Root record with 1 as the primary key value ( ID ). ( This is the issue at your end, Please correct )

Thanks for the response. I tried what you selected, ensuring my import profile is set to insert, and skip for ID column. I also deleted the row that included root, this did not work, but instead gave this error:

Import abort with exception

Duplicate entry '1-1-Banners-*' for key 'idx_client_id_parent_id_alias_language' SQL=INSERT INTO `in2ho_menu` (`menutype`,`title`,`alias`,`note`,`path`,`link`,`type`,`published`,`parent_id`,`level`,`component_id`,`browserNav`,`access`,`img`,`template_style_id`,`params`,`lft`,`rgt`,`home`,`language`,`client_id`) VALUES ('menu','com_banners','Banners','','Banners','index.php?option=com_banners','component','0','1','1','4','0','0','class:banners','0','','1','10','0','*','1')

I have attached my export from the Joomla 2.5 site.

Hello Daniel,
As I can see in the error message It's stating that a Menu already exists with ID 1 and Title Banners, that's why you can not add a duplicate Item.
Apply another filter in export profile client_id = 0. It will export all the Front end Menus only. Right now It's exporting back end Menus as well.

Hi,
I have wiped out my old Joomla 2.5 installation. Is there any way I can modify the csv file to import properly?

Yes, you need to delete all the records from your CSV file where client_id is 1