Resolved Custom Fields For All

Hello,
You need to update your available fields to see it in quick add page.

I've done that, twice. It's still not showing up.

Hello,
Can you load the attached patch file using CSVI maintenance menu and then update your available fields? Check if you can see the fields after that.


patch_vm_available_fields_2016-11-08.zip

Hello,
You actually don't need custom fields for all fields as available fields, Please check the custom fields for all documentation to know how to create the import file for importing custom fields for all values.

OK I have done this and it appears to be working. I have exported the CSV in Excel, created an import template however when I try to import I get this message: File source is not set for the template. Please edit the template and set the source from Source tab

I have attached the CSV that was created on export from CSVI.

Hello,
The attached file is UTF-8Y, also known as a BOM file. The Byte Order Mark(BOM) is an invisible 3-characters at the beginning and it is seen in your file. You have to first save your file as a normal UTF-8 file before doing the import. Also, can you edit your template go to Source tab, set a source there and save the template? Try the import and see if it works.

Can I do this from within Excel? I can't find where to change the encoding.

OK I have converted to UTF-8 using jEdit. Now it says File source is not set for the template. Please edit the template and set the source from Source tab - but I don't have a Source tab?

Hello,

but I don't have a Source tab?

When you click on your template name on Templates page, what is the second tab name you see?

No, attached is what I see.

Hello,
Something is gone wrong with your installation. You should be seeing few more tabs along with details tab. Can you use firebug console and check if you see any javascript error in your template page?

Uncaught TypeError: Cannot read property 'value' of undefined(…) http://209.200.104.34/administrator/index.php?option=com_csvi&view=template&layout=edit&csvi_template_id=4

Hello,
Can you post the screenshot of firebug console please?

Surely it's easier for you to log in and have a look yourself? You have the login and FTP details. Hopefully then you can fix it whilst you're in there.

Hello,
I am not sure what went wrong with your Products Import template but when i created a new template on your site it went good. You can check the new Product import template created on your site. Can you also tell me if you had any error while creating your Products Import template?

Great, now my next question is this: is there any way to move the Export fields over to the Import fields? They're exactly the same, it would be a pain if I had to enter them all again manually.

Hello,

is there any way to move the Export fields over to the Import fields? They're exactly the same, it would be a pain if I had to enter them all again manually.

You don't have to create import fields manually if the fields are headers in your import file. In your import template settings on File tab, set 'Use file for configuration' option to yes and CSVI will use the fields from your import file. You can check if the fields are mapped correct in your import preview page and then do the import.

OK we're getting very close now. I have the import working, but there's a few problems with the export:

First, when I do the export, for some reason the following fields are not appearing, even though they are in the template:

Sector
Age Group
Environment

Second, I seem to have made some sort of mistake in the grouping. Please have a look at the attached file.

a) they should be grouped primarily by name, but they are not.
b) I am getting both prices (Guest and AU/NZ_FOB) for Little BOSS Chair - Natural but only one price (AU/NZ_FOB) for Little BOSS Chair - Natural2

If you can help me fix this, we should be all done and I can stop bothering you! Please log in and sort it if you can, rather than just sending a response.

All the best,

Brandon

Hello,

First, when I do the export, for some reason the following fields are not appearing, even though they are in the template:

Sector
Age Group
Environment

Can you send me your mysql dump file of your VirtueMart tables to check on this? I may need to check your data on how its stored so to find the cause for this.

a) they should be grouped primarily by name, but they are not.
b) I am getting both prices (Guest and AU/NZ_FOB) for Little BOSS Chair - Natural but only one price (AU/NZ_FOB) for Little BOSS Chair - Natural2

You products seems to have multiple prices and you have grouped by product_price and so duplicate product details rows are exported in your export file. If you remove the grouping of product_price, product details will be exported with the first found price of product in database without duplicate product details. For multiple prices export, you can do a export separately for products using Price export template and that wont export any product details.

Hi - you should be able to get everything you need here:


I want the multiple prices, I just want all of them.

Cheers,

Brandon