Resolved Ways to delete record using import file

Hello Joseph,

Which records do you want to delete? In addition with which extension are you using CSVI?

We are using custom tables. The compoent is csvi.

Hello Joseph,
There is no way to delete a record in custom table import. One option here is that you can add your own custom available fields like say custom_delete and write query to delete the record in import override file.

Thank you for the reply. Why don't you add this feature to the core? This should be straight forward. I will post back see if I can accomplish that.

Joseph

Hello Joseph,
Thank you for your suggestion. We will think of adding this feature in our future release.

I would like to add a field delete_row in the available field. I don't want to create the field in my table, though. Not sure how to add an available field when it is not in the custom table. The field not even showing in the template field selection even when it is added to the csvi_availablefields table.

The instruction for adding an available field is not very clear (or to be blunt, somewhat misleading). I don't know what the skip and combine means and what they are for.

I have created the override to delete a row when the primary key is negative (my key is positive integer). That works but not an intuitive way to allow deletion for clients.

Joseph

Hello Joseph,

I would like to add a field delete_row in the available field. I don't want to create the field in my table, though. Not sure how to add an available field when it is not in the custom table. The field not even showing in the template field selection even when it is added to the csvi_availablefields table.

You don't have to create this field in your table as it used only during import. I guess it wont work if you add it directly to csvi_availablefields table as whenever you Update your available fields, the fields in this table are cleared and a new set of fields are inserted so add field is not the right way of doing it.

The instruction for adding an available field is not very clear (or to be blunt, somewhat misleading). I don't know what the skip and combine means and what they are for.

The instructions given are same like creating a override in Joomla. You need to create a override.sql file in location administrator/templates/isis/html/com_csvi/com_csvi/install/ as you are using custom table import. In the override.sql file you need to add query for your new delete_row field like
INSERT IGNORE INTO `#__csvi_availablefields` (`csvi_name`, `component_name`, `component_table`, `component`) VALUES
('delete_row', 'delete_row', 'tablename', 'com_csvi');
Note that you need to replace your custom table name in place of tablename in the query. skip and combine are CSVI custom fields and they are just given for an example.

Thanks for the advise. I understand the need of the override.sql but insert the fields directly into the database is faster. I am pretty sure the client will not update the available field list.
I will suggest some modifications to the documentation on "Adding your own custom available fields"

Explanation of the fields:
csvi_name
This is the name of the field used in the template. This is usually the same as the component_name below.
component_name
Usually the actual field name used in the component table. You can also use an available field for import processing logic. In that case, component_name does not need to exist in the component table. But it must be a unique name for the same component_table and component below.

Joseph

Hello Joseph,
Thank you so much for your suggestion.

Hello Joseph,
Thank you so much for your suggestion.