Resolved No VM3 fields available

Hello,
Can you check your template fields page on Javascript console and when you click on the save button after you add the field? Do you see any Javascript error? Can you post the screenshot of your console to check?

Hi,

Thanks for your assistance!!

Yes, I attach a screenshot.
The text in the green field: Message - item saved successfully.

Text in yellow field: no result.

Text in console: emply character chain..

No idea what can be wrong...

Hello,
Two things to check.

1. In your screenshot i see there is an error, what do you see if you click on the error link which says getElementById? Can you post that screenshot too?
2. Did you update your CSVI from old version or installed CSVI 7.0.2 version directly? I remember seeing this issue happen when there is a missing database field source_field in #__csvi_templatefields table? Can you check this table from your phpmyadmin? If you don't find source_field can you try running the below query and then check your template fields page? Dont forget to replace #_ with your table prefix.

ALTER TABLE `#__csvi_templatefields`

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

Hi,

Thanks for your answer :-)

1. the text is not clickable. just a text. No further explanations etc.

2. unfortunately i have no phpmyadmin, but I try to get one :-)

Thanks so much!!

Hello,

2. unfortunately i have no phpmyadmin, but I try to get one :-)

phpmyadmin is not a must. You can check the field with the software you use to access your database and its tables. Can you check if there is such field in the table i mentioned?

Sorry, I think I am not so professional :-(

There is no source field in the available fields, if you say so..

What do I have to do now?

Thanks so much for helping me!!

Hello,

There is no source field in the available fields, if you say so..

Source field is not an available fields but it is a column in your site database table. Can you check your database and table called #__csvi_templatefields? This table should have a column source_field. Do you see it? If you cannot find it, can you send me a private message of your site and database access details to check?

Ok, I have asked for a phpmyadmin from the hosting company, so as I can check the database I will inform you!

Thanks so much again!!

Hello,
Thank you for sending phpmyadmin details. As expected there was no source_field in #__csvi_templatefields table. I have added this field to your table. Can you tell me if you upgraded CSVI and from which version or installed CSVI 7.0.2 version directly? This will help me to find on how the field got missed. Can you also check if you see your template fields?

Thank you so much!

It seems to be working :-)

It was the first: com_csvi_6.6.3_pro.zip, then 7.0.2.

Thanks so much!!

Sorry, I need your help again :-(

I have a template to import with the fields I need. And I have a csv file with the data I need. But when I want to import, an error message is waiting for me at the preview stage: No supported fields have been found in the import file

I have checked the csv file several times, it seems to be valid. What could be wrong?

Thanks so much for your help..!

Hello,
The error shows that the headers of your csv file dont seem to match with the database fields. To avoid this error, you need to add equivalent template fields to your template and in the same order as column headers in your csv file. You then need to set Use file for configuration to No in your template settings and on File tab. This settings will not use the column headers from your csv file but use template fields and import the data in the same order as in your csv file. If you still have issues, post the sample of your import file, debug log and your template XML. To know how to get the debug log check Where to get the debug information? section on top of this page. To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it.

Thanks so much! " You then need to set Use file for configuration to No in your template settings and on File tab. This settings will not use the column" - this part was the solution.
Now the import works fine, no error at all, but the products are not in VM3 :-(

And if I want to run it again, it says: "Duplicate entry '0' for key 'PRIMARY' SQL=INSERT INTO `#__virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (0, 'product-name')".

Please help :-))

Here is the template xml and my tiny csv.

Thanks so much for helpin me!!

Hello,
You need to do three things with your import.
1. The duplicate entry is because there is already an entry in your virtuemart_products_en_gb table with virtuemart_product_id as 0. This entry is not valid as 0 cannot be a valid id. You need to clean up your data in these tables. If this is a test run and there is no needed data already in virtuemart_product table, you can clean up your VirtueMart tables from CSVI maintenance menu by selecting VirtueMart in first option and Empty database in other option. This will remove records from main VirtueMart tables.
2. There is virtuemart_product_id field in your import file, you need to remove that. virtuemart_product_id will be generated automatically by database when a new product is entered. If there is an virtuemart_product_id field in the import file then it says that the record is already in database and Joomla will try to update that record instead of inserting a new one.
3. You need to set Skip first line to Yes in your template settings on File tab.
Do all these and try doing a fresh import. If you still have issues post the debug log of your import.

Working fine at the moment!

Thanks so much for your fantastic support and patience!

Have a nice day!

Glad to know it is working. Would appreciate if you can give us a review on Joomla extension directory.