Resolved Help with importing multiple custom fields/values

Hello Colin,

I noticed you are using an older version of CSVI, the error you mentioned I believe has already been fixed in that.

Looking at your ImportMultipleProductswithMultipleFields.csv file I notice an issue as well. The custom_param field has more values than the custom_title and custom_value fields has. That has to be the first thing to sort out. You can have a look at the Custom fields for all for VirtueMart tutorial.

Thanks Rolandd,

I noticed you are using an older version of CSVI, the error you mentioned I believe has already been fixed in that.

I'll get CSVI updated firstly.

The custom_param field has more values than the custom_title and custom_value fields has

I see where ive been going wrong now, i had mixed up my ~ and # in the custom_value fields.

I'll make these changes and will let you know when I get a chance to retry the import.

Many Thanks.

Hi Rolandd,

I have now adjusted my CSV file for importing the Custom Fields and their values, attached.
I am able to import all my categories, manufacturers, products and Custom Fields ok, CSV files attached, but when I try to import the Custom Fields Values I receive an error..(log file attached)

Table 'neills13_evo3x.jos_virtuemart_custom_plg_customsforall_values' doesn't exist SQL=SELECT `customsforall_value_id` FROM `jos_virtuemart_custom_plg_customsforall_values` WHERE `virtuemart_custom_id` = 25 AND `virtuemart_custom_id` = 25

I have included all of my CSV files and the order in which I imported them is as follows,
1) Manufacturers.csv (this file contains the manufacturers) - imported ok
2) Categories.csv (this file contains the product categories) - imported ok
3) CustomFields.csv (this file contains the main custom field names) - imported ok
4) product import.csv (this file contains all the products and the relevant details for each) - imported ok
5) product import custom values.csv (this file is the one I get the error on, it contains the product SKU along with the Custom Fields and Values for each)

I had originally tried to have just one CSV file to import the product details and custom fields/values, but when this did not process correctly i split it into the two separate files.
At least from this I now know it is the Custom Fields which is causing the failure.

I am most likely missing a simple step but could you please have a look and see where I am going wrong.

If my CSV files are set up correctly, is it likely a problem with the virtuemart Tables as I see the error message mentions a table. I just dont want to start to remove tables until I am sure what may be wrong.

Thanks again.

Hello,
You dont seem to have installed Virtuemart custom fields for all plugin and which is why the table is missing. Install the plugin and enable it, the issue would be solved.

Hello Colin,

As Tharuna pointed out you need to have the Custom Fields For All plugin installed for your custom fields to work. This is a plugin created by Breakdesigns. I am not sure if that is what you plan on using. Might it not be that you are looking for the Multi Variant option?

I am most likely missing a simple step but could you please have a look and see where I am going wrong.

I think you just need to find out which kind of custom fields you want to use.

Thanks for the reply guys,

We are actually going to be using CustomFieldsForAll as well as Custom Filters as we want the user to be able to search by for their product by using a checkbox system through the CustomFilters Module.
I have checked the plugin status for CF4A and it is installed and published. (CustomFieldsForAll published.PNG)

I have looked at the Product Custom Fields in Virtuemart (CustomFieldsForAll virtuemart.PNG) and there does seem to be a problem, I am able to see all of the Custom Fields I have imported but when I try to add any Values to them I am get an error.

1146 Table 'neills13_evo3x.jos_virtuemart_custom_plg_customsforall_values' doesn't exist SQL=SHOW FULL COLUMNS FROM `jos_virtuemart_custom_plg_customsforall_values`

Again, it looks like this is probably an issue I have to solve with Breakdesigns support rather than yourselves?

Many thanks again.

Hello Colin,

It seems like the plugin didn't install correctly or something, I just did install the plugin and I get the table jos_virtuemart_custom_plg_customsforall_values (amongst others). Perhaps try uninstalling and installing the plugin again. Otherwise it is indeed an issue to take up with Breakdesigns.

Hi again Roland

Joomla! version 3.4.5
Virtuemart Version 3.0.12
CSVI Version 6.4.2
PHP version 5.5.30

Just a follow up on the situation with importing the multiple cusstom field values.

We have restored Virtuemart back to its basic install and have reinstalled all modules and plugins as required.
Unfortunately when trying to import the csv file (ProductCustomFieldValues.csv attached) with Custom Field values on it for each product in a virtuemart store, I still seem to get errors.
The site is set up to use CustomFieldsForAll and I have the customfieldsforall plugin installed and enabled.

I manually set up one product in virtuemart, product nv1000, with custom fields and values and exported it to receive the correct layout for the .csv template file.

I have also created Categories, Manufacturers, Custom Fields and some Products on the site.

Unfortunately, when I try to import the Custom Field Values I receive the following error,

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 SQL=DELETE FROM `jos_virtuemart_product_custom_plg_customsforall` WHERE `virtuemart_product_id` = 1596 AND `customsforall_value_id` IN ()

Im a bit unsure as to what could be wrong, as I do not think it is my .csv file. (Log File Attached com_csvi.log.28.zip)

Also, it seems that some of the Custom Field Values are actually importing but not them all, screenshot attached..(ProductScreenshot nv1002.png), the line in the .csv file reads,
product_sku,custom_title,custom_value,custom_param
nv1002,NewUsed~Massey Ferguson,customfieldsforall~customfieldsforall,New Part~65#135#165#35X

I am sorry for the bother I am putting you to but I am totally lost with databases/tables and it may be some simple step I have missed in the setup, but Im sure I did follow all instructions correctly.

I have attached all of the .csv files I used for importing the data.

If you need access to the site, I have sent you a PM with login details.

Kind regards.

Hello Colin,

There is an issue in CSVI that didn't catch empty values correctly. If you load the patch file the import should run without a problem.

I was able to import your file after the patch.

Let me know how it goes.

Hi RonaldD,

Thanks for the speedy response and solution.

Looks like the patch solved the problem.

I am just checking that all the products now show the correct custom field values and from what I can see its working correctly.

Many thanks for your help.

Kind regards.

Colin.

Hello Colin,

Glad to hear all is working for you. Just so you know, this patch is included in today's release of 6.4.3.