RO CSVI

Import of Joomla menu items using RO CSVI

This document explains on how to import menu items using RO CSVI. 

1. The first step is to create an import template. To know on how to create a template see the linked document.

2. The import template should be created with Component selected as Joomla menus and Operation set as Menu.

3. Create template fields for import. There are two ways to tell RO CSVI about the template fields you want to import.

  •  You can have headers in your import file which has the name same as the RO CSVI available fields for Joomla menu import. You can tell RO CSVI to use these headers from your import file. To do that in your import template on File tab set Use file for Configuration as Yes. This setting will tell RO CSVI to use headers from the import file.
  • Other option is to add fields for the import template. To do that go to RO CSVI Templates page, select the import template you created and add the fields you want to import. In your import template on File tab set Use file for Configuration as No. By this you are telling RO CSVI to use the fields added in the template and not the headers from the import file.

4. There are few basic fields needed for Joomla menu import. They are path, type and menutype. This means that you need to have these basic fields in your import file along with other fields you would need to import. Now you may think what is the use of these basic fields? RO CSVI uses the value of these fields to find if there is a matching record in Joomla menu table(#__menu). If the matching record does not exist, a new record is created else if there is a matching record the existing record is updated.

5. Now that template and template fields are done, it is time to run the import. 

Example content for import.

"type";"path";"menutype";"component";"link";"level"
"component";"com-csvi/com-csvi-maintenance";"main";"com_csvi";"index.php?option=com_csvi&view=maintenance";"2"
"component";"article";"mainmenu";"com_content";"index.php?option=com_content&view=article&id=22293";"1"
"component";"import";"mainmenu";"com_csvi";"index.php?option=com_csvi&view=import&csvi_template_id=375&key=12345&task=import";"1"
"component";"orders";"mainmenu";"com_virtuemart";"index.php?option=com_virtuemart&view=orders&layout=list";"1"
"component";"hikashop-menu-for-products-listing";"hikashop_default";"com_hikashop";"index.php?option=com_hikashop&view=product&layout=listing";"1"