Resolved getting error when attempting to load category from csv file

Hello Stephen,
Did you update your CSVI recently? The error says there is a missing field in one of CSVI tables. To check that using phpmyadmin or any other software you use to access your database, select your site database and look for table #__csvi_templatefields (#_ will be your table prefix). Check if there is a column name source_field and if not run the below query to create it. Dont forget to replace #_ with your table prefix. See if your import runs after that.

ALTER TABLE `#__csvi_templatefields`

	ADD COLUMN `source_field` VARCHAR(255) NOT NULL COMMENT 'Field name of the source table' AFTER `xml_node`;

thank you your fix worked a treat
but now i am having this error come "The field category_path is not found in the import file." catagorys.csv
it this happens when i run the category import the category_path is mapped to cat path
setting Value
Display errors No
Magic quotes runtime No
Magic quotes gpc No
PHP version 7.0.26
Joomla! version 3.8.3
Database schema version 7.3.0
any ideas
thank you in advance

Hello,
Can you post the debug log of your import? To know on how to get the debug log check How to collect debug information? document.

com_csvi.log.54.zip attached is the log file

Hello,
Your debug log shows there is no category_path field is added to template fields. category_path field is a required field for VirtueMart category import. You need to add it and then run the import.

I AM NOW SO TOTALLY CONFUSED BY THIS SOFTWARE make changes to settings and save them u go back in and they are gone i dont know where to go next i think it would be quicker to enter my 8000 products by hand i think the software is over complicated for what it needs to do do you have a simpler version ps i have work extensively on applications like ms dynamics (customisation )that was simple compared to this. i cant work out out the software flow

Hello,
Did you check the document i linked in my previous post? That document explains step by step procedure on what has to be done for creating a template and fields for category import. Your import was missing a required field category_path so i told you to add it to your import fields. Not sure what is the difficulty you are having with it. Can you post your sample import file and template XML file to check? To get the template XML file go to CSVI maintenance menu, select CSVI Pro in first option and Backup templates in second option. Select the import template and click continue. Post the downloaded XML file.