Resolved Custom Fields For All

Hello Brandon,
Sorry to hear about the issues but as far as the CSVI export what is stored in the database is what you get in the export file. If you think you need to customise the export you can do it by creating an override routine for export. You can write your code in this override file and customise the export as per your requirement. I am not sure on what you are looking for in the export but you can write to me on tharuna@csvimproved.com on your queries and i will help you to the best i can.

Hi Tharuna - that doesn't really help me as I'm in too deep now. This project has been driving me crazy for 6 weeks now and going back and forth between you guys and Custom Fields and it just isn't working. I need the three of us to get into a conversation TOGETHER so we can sort this out. Can you please email me directly on brandon@mindspyder.com - I'm going to ask the same thing of Custom Fields so we can all work together to solve this. Once we all have each others' emails we can work together in one conversation to find a solution.

My client is hysterical and furious. I'm spending untold hours that I'm not getting paid for to try to fix this, and I see this as the only solution. If I can't fix this I stand to lose over a thousand dollars.

I know this is probably outside the way your normally operate but please please please help me.

All the best,

Brandon

Hello,
Can you check custom_param field in your export file? do you see the value Baby for Sector in there?

Hi,

This still has not fixed my problem. For example, the field SECTOR should be returning Toy Baby Internet and Education. Instead its just returning the word customfieldsforall.

Thanks Brandon

Hello Brandon,
Your site was missing installation of CSVI custom fields for all extension and so you were not seeing the actual values. I have installed and enabled this extension on your site and now export shows customfieldsforall values in custom_param field. Can you test and let me know?

You have all the log in info probably quicker and easier for you to go in and look around yourself. That way you can also see how everything is currently set up.

Thanks
Brandon

Hello,
Can you send me your export debug log and the downloaded export file to check?

Hi Tharuna,

So this is the issue I'm faced with, I have these three custom fields:
Sector
Age Group
Environment

As you said they are plugin fields and support multiple values. How do i get these fields and values into the CSV? Currently is only exporting the value customfieldsforall for those three fields not the actual values themselves which I assumed would be pipe separated like the other multi value fields. If this is not how it works can you please provide me an alternate solution or approach.

Thanks
Brandon

Hello,

When I follow your instructions all the custom fields are lumped into one.For example, you can see all the Inner Field are exporting properly.

That is the way we export custom fields including the string fields as all fields are treated as just custom fields and there is no distinction made while using custom_title, custom_value and custom_param fields in the export. The inner fields you are saying are string type fields and are independent fields so they are available as a individual field on export and import but that is not possible with plugin type fields as they depend on other fields and support multiple values too.

HI, this did not solve the problem. All of the custom fields are exporting properly except these three:
Sector
Age Group
Environment

When I follow your instructions all the custom fields are lumped into one. This is not what I want. For example, you can see all the Inner Field are exporting properly.

Hello Brandon,
Please do not post your login details on forum. It is not safe and advisable. You can either send your details in Private message or send it as an email.

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

The reason you are not seeing these fields are because they are customfieldsforall plugin fields, you need to use custom_title, custom_value and custom_params fields in your export fields and then do the export. These are the fields CSVI supports while doing a Custom fields for all import and so the export uses the same.

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

There are two ways to get your multiple prices
1. Please check 'Price export' template on your site. I have added a new template which would get multiple prices of a product with its product_sku.
2. if you want product price details in your Product exports template all the product details will be duplicated as a row for each product price. Add group by field to be product_price and virtuemart_product_id in Product exports template so you can get multiple prices in your Product exports template.

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


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

Cheers,

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.

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,

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.

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,
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?

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,
Can you post the screenshot of firebug console please?

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