Resolved Custom Fields for All Import being Skipped

Hello David,

Also, my product descriptions keep getting cut off in the import process if there is a comma in the description. Do you know how to keep that from happening?

There are two reasons, first hat happens because your file is not UTF-8 encoded and second your file has no text enclosure. You use commas in your descriptions and as your field separator. It is impossible to know if the comma is for your text or your field separator. That is why you need to enclose your text with enclosures, which usually are double quotes. Let's fix that first and then see if your import runs as expected.

Thanks so much for your help. I figured out how to switch it over to UTF-8 encoded and I found some of the extended characters that was also causing a couple of problems.

Now I just need to figure out the Custom Fields For all plugin and why it's skipping over it. It's weird.

The files must always be UTF-8 to be processed correctly because in Joomla everything is UTF-8.

As for the skipping, now that the regular import is working, post your new file and debug log so I can check it for you.

Sorry for the delay in writing back. I tried it again without any luck. Attached is the download log and the spreadsheet I was using to upload.

Thanks so much for your help.

David J.

Hey David,

Ok, so I checked the debug log and CSV file and was a little dumbfounded as to why it wasn't processing the custom fields for all. Then I spotted it, there is a typo in the custom_value field.

customfieldsforall~customfieldsforall~customfieldsforall~customfieldsforall~customfieldsforall~customfieldsforall~~customfieldsforall

Notice the duplicate ~ before the last customfieldsforall value. That should be a single ~ and after that your import should be good to go.

Thanks for your eagle eye. That was the source of the problem but now I've got another. I apologize for being so high maintenance.

I'm now getting a sql error when I try to run the import:

*************************************************************
Oops something went wrong.

Let me try to show the warning below here. If nothing shows up then I didn't get any data, sometimes this is caused by faulty plugins.

Cancel the import and check if all settings are correct and try the import again. Status error: 500 Status message: Internal Server Error.

Error
An error has occurred.
1064 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 1 SQL=INSERT INTO `q507p_virtuemart_product_custom_plg_customsforall`
*************************************************************

Hello,

It seems that the value White has not yet been defined in CF4All. Have you already added this to value to your custom field?

Hello there. White is in there as one of the options. I attached a screen shot of what it looks like in the backend.

Thanks again for your help.

David J.

Hello David,

Have finally found the spot, the value in your CSV file should not be White but ffffff because White is the label and ffffff is the value. If you change that around, you are good to go.