RO CSVI

Update fields using Joomla custom fields

Using RO CSVI it is possible to update fields using Joomla custom fields. This feature is available for the following imports:

  • Joomla Categories
  • Joomla Contacts
  • Joomla Content
  • PhocaCart Products

This document explains on how to use this feature with Joomla content import.

Please note Import based on works only on custom fields that contain a single value like a Text field.

  1.  From Joomla article manager on Fields page add a new Text custom field. Say for example field name is userdesignation.
  2. Update available fields in RO CSVI
  3. Create Joomla content import template.
  4. Edit the import template
  5. Go to the Options tab
  6. In case you do not see the Import based on field then click on Advanced button in the toolbar.
  7. Set Import based on field to userdesignation. By default this field is set to alias.
  8. Click on Run Template from the toolbar to start the import
  9. Once the import is finished, the article will be created or updated based on userdesignation field.
  10. Note that if Import based on field is set in template then it acts as override for needed fields alias/title or category_path/catid fields. Which means articles are selected from database based on Import based on field.

Sample CSV file will look like

title,alias,category_path,state,introtext,userdesignation
Random article,random-article,news/local-news,1,"<p><a>A random site</a></p>",Speaker

Other imports 

Steps for adding Import based on in the other imports and usage in import file is the same as Joomla content import as explained above.