Questions and answers

Requirements: CSVI 5.6+

In CSVI Pro it is possible to add your own custom available fields without having to modify any core files.

Adding fields

Steps to add your own available fields:

  1. Go to the folder administrator/templates/<template name>/html/com_csvi/<component name>/install/
    For example: administrator/templates/isis/html/com_csvi/com_virtuemart/install/
  2. Create a file called override.sql
  3. Add the following code in the file:
    INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`) VALUES
    ('skip', 'skip', 'productimport', 'com_virtuemart');

    Explanation of the fields:
    1. csvi_name
      This is the name of the field used by CSVI (this is usually the same as the component_name)
    2. component_name
      The name of the field used in the component table
    3. component_table
      The name of the import/export routine where the field is to be used with
    4. component
      The name of the component the field is used for
  4. Add more lines if needed
  5. Run the Update from the Available Fields to add your custom available fields

A file with multiple lines could look like this:

INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`) VALUES
('skip', 'skip', 'productimport', 'com_virtuemart'),
('combine', 'combine', 'productimport', 'com_virtuemart');

Processing fields

To have CSVI process these custom available fields, you will need to write your own code.

Last Updated: Tuesday, 28 March 2017 13:50

My Member Software

My Member Software

My Member Software is the downloadable open source member administration program with which Associations, Clubs, Foundations and even companies can administrate their members and is integrated in the Joomla CMS.

You can use CSV Improved to easily import your user data into My Member Software.

Read all about My Member Software.