Resolved Joomla custom field export/import only one value

Hello Yaniv,

The export of multiple values for a custom field is not yet fully implemented. It currently only does this for an imagelist. Which field type are you using?

To import multiple values, the values need to be separated by a | pipe-symbol. Depending on the field type you use we may need to massage this further. Let me know and we can see what can be done.

Hi Rolandd,
Thanks for the quick answer.

I used SQL field type
And i try to use the pipe-symbol like you suggest, but it's not working as well.
Do you have any work around for this issue?
Let me now if you need more information to investigate this problem.

Thanks!
yaniv

Hey Yaniv,

Can you post me an example of what you are trying to import? An image of how you setup the custom field will be useful as well. It will give me some direction to check.

Hi,

I'v build the site with virtuemart as the store part of the site, and the com_articles we build the blog for the site.

we want to show in every article the product that related to this article.
So we need in the article the option to select product, and i was successful to accomplished that with the new custom fields for the article.
With the SQL type i was able to get the product ID and Title from virtuemart, to select in the Custom fields on the Article edit page:
SELECT virtuemart_product_id as value, product_name as text FROM #__virtuemart_products_he_il
And i build a module to show in the article page the related product as well.

The problem is that i need to import more than thousand of product and article from other site that build on ASP, and that's the problem that i can't import to the custom field more than 1 product, because i used with Multiple select and needed to select for every article 5-6 deterrent product.
I hope i was able to explain my self, please let me know if you need more information.

Hello Yaniv,

Your explanation is clear. I am going to look into this and get back to you.

Thanks rolandd,
I really appreciate your help

Hello Yaniv,

Attached is a patch file that you can load. After that you can run an export and you should have duplicate values in your export file. The values are separated by a pipe-symbol. These are just the virtuemart product IDs and not the actual names but you can import them as such back into the content.

Let me know how it goes.

Hi Roland,
Thanks for the update.

After i was update the patch and try to export the articles, i get an error.
Attached screen shot of the error.
I try to update the Available fields also bit with same result.




yaniv

Hello Yaniv,

My bad, I sent you a file based on the upcoming CSVI. Attached is the patch for your version of CSVI. Let me know how it goes.

Hi Roland,

Ok so the export working now with the customs fields
But the import still not working and can't import multi custom with pipe, no errors but no multi id's as well.
I look in to the patch and see that there is only file for the export, should there be another file for the import?

Thank you Roland
yaniv

Hello Yaniv,

I have sent you an email with some details. The current CSVI release doesn't support multiple values but the upcoming 7.3.0 will. That is why you are having the issues you have. Give the version I sent you a try and let's see how it goes.

Hi,

Sory but i have installed the new CSVI that you send to me but still can't import multi Custom fields to article.
but it's ok, i think i can manage to do that with SQL from phpmyadmin, i understand that the current version is not supporting in this feature.

Thanks for the time and for your help
yaniv

Hey Yaniv,

Why can't you import it with the new version? I was able to import what I exported.

I don't know,
I installed the component ant try to import test's articles with multi custom with the pipe symbol, but only one value(the first one) was saved after the import.
And i was trying it for several import to check this.

I will try again in the evening, i will make a new template for the import from scratch.
I will let you know about the result.
Thanks,
yaniv

Hey Yaniv,

Send me the debug log as well so I can see what is going on.

I will

Hi,
Ok it's work's!
Thank you Roland for all your help
yaniv