Resolved Custom import to custom table not inserting/adding new records

Hello,
We found the cause for the problem of records not removed before import and have fixed it with the attached patch file. The issue with Skip new items is also fixed. Can you load the attached patch file and give custom table import another try? If you still have any issues, please post the import debug log.

patch_csvi_2017_10_26.zip

The empty table isn't working with the 10-26 patch. The Skip new items is working correctly. The update is still working wonderfully so the only thing I've noticed in this version is that the Empty Table option is now not deleting the rows in the destination table (where as before, the table was being purged, but the import didn't complete fully).

Since the data I had been using had production information in it, it was hard to share the logs and such. So I created a streamed down version to provide you with sample data and logs...

The table structure is:

CREATE TABLE `jgs5u_test_table` (

  `MemberNbr` varchar(255) NOT NULL,

  `FirstName` varchar(255) DEFAULT NULL,

  `State` varchar(255) DEFAULT NULL,

  `2018-Officers` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`MemberNbr`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I created a template to Update existing, NO to Skip new, and Empty table: csvi_templates_test_table.xml
And here is the log for the Import: com_csvi.log.48.txt.zip
Here is the import CSV file: test_table.csv
Are the patches accumulative? Should I reinstall CSVI and then just apply the last patch?

p.s. thanks for everyone's help on this...the update custom table for any primary key is such a relief to me in the project I have to automate a member's roster from our parent organization. This will save me so much time. Thank you!!

Hello,

The empty table isn't working with the 10-26 patch. The Skip new items is working correctly. The update is still working wonderfully so the only thing I've noticed in this version is that the Empty Table option is now not deleting the rows in the destination table (where as before, the table was being purged, but the import didn't complete fully).

From your debug log i can see that the query for removing the records from custom table has not run though Empty table before import is set to Yes. Did the installation of patch go good? Can you check if there is a file at location plugins/csviaddon/csvi/com_csvi/helper/com_csvi.php? If not can you place the attached file at that location manually and then run the import again?

Are the patches accumulative? Should I reinstall CSVI and then just apply the last patch?

yes, patch files are accumulative so you don't need to reinstall CSVI. The files will be overwritten at their corresponding locations.

p.s. thanks for everyone's help on this...the update custom table for any primary key is such a relief to me in the project I have to automate a member's roster from our parent organization. This will save me so much time. Thank you!!

We are happy to hear this. Would appreciate if you can give us a review on Joomla extension directory

plugins.zip

I missed this...when the patch attempted, this is what I get...

0 Incorrect Failure Cannot copy patch file from /home/wemo/public_html/tmp/com_csvi/patch/1509122825/plugins/csviaddon/csvi/com_csvi/helper/com_csvi.php to /home/wemo/public_html/plugins/csviaddon/csvi/com_csvi/helper/com_csvi.php

In fact, in my installation, there isn't a path /helper in the ../plugins/csviaddon/csvi/com_csvi directory at all...so I created the helper folder and re-applied the patch.
Everything is working!!

Glad to know that everything is working

Would be great if you can give us a review on Joomla Extension Directory.