Import Menu problems

I've deleted all rows with client id=1, as well as the root row. Still getting duplicate entry errors. Is there anyway to force overwrite?

Attached csv file tested for import.

Here is error:

Import abort with exception

Duplicate entry '0-1-home-*' 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 ('mainmenu','Home','home','','home','index.php?option=com_content&view=featured','component','1','1','1','22','0','1','','0','{\"num_leading_articles\""1\",\"num_intro_articles\""3\",\"num_columns\""3\",\"num_links\""0\",\"multi_column_order\""1\",\"orderby_pri\""\",\"orderby_sec\""front\",\"order_date\""\",\"show_pagination\""2\",\"show_pagination_results\""1\",\"show_title\""\",\"link_titles\""\",\"show_intro\""\",\"show_category\""\",\"link_category\""\",\"show_parent_category\""\",\"link_parent_category\""\",\"show_author\""\",\"link_author\""\",\"show_create_date\""\",\"show_modify_date\""\",\"show_publish_date\""\",\"show_item_navigation\""\",\"show_vote\""\",\"show_readmore\""\",\"show_readmore_title\""\",\"show_icons\""\",\"show_print_icon\""\",\"show_email_icon\""\",\"show_hits\""\",\"show_noauth\""\",\"show_feed_link\""1\",\"feed_summary\""\",\"menu-anchor_title\""\",\"menu-anchor_css\""\",\"menu_image\""\",\"menu_text\":1,\"page_title\""\",\"show_page_heading\":1,\"page_heading\""\",\"pageclass_sfx\""\",\"menu-meta_description\""\",\"menu-meta_keywords\""\",\"robots\""\",\"secure\":0,\"gk_showtitle\""1\",\"gk_desc\""\",\"gk_cols\""1\",\"gk_group\""0\",\"gk_class\""\",\"gk_subcontent\""0\",\"gk_subcontent_pos_positions\""menu1\"}','11','12','1','*','0')

Yes, As I stated previously, There is an option in profile settings to choose operation type, the options are:

1. Insert ( allows you to only add the records
2. Update ( allows you to update records if primary key ID in most cases already exists in database table, if not then add all the new records
3. Synchronise does similar job as Update except It also deletes the record if any record found with a primary key value which doesn't exist in the data you are importing.

In your case update option would work.

When I change the profile settings to Update instead of Insert, I receive this error:

Primary key not found

Import Failed

When I change the profile to use Synchronize method, the same error is given.

Didn't you include ID column? In case of update and synchronise, Primary key column ( i.e. ID in your case ) is required. Or Please share your back end & FTP login credentials via Contact us form, We'll look into it.

client id was included

I'll send you my details for FTP and backend