Categories
View Replies (8)

Resolved How to import multiple choices like color and size

  1. janwil
    janwil
  2. RO CSVI
  3. Sunday, 21 December 2014
  4.  Subscribe via email
Hello,

i'm trying to import a database delivered in xml from our delivery partner to virtuemart3.0.

How can i make it so csv improved checks the field and parses it to multiple values in that field.

For example: sees that color uses , as seperator and fill this as multiple values for the specific produkt sku table.

Also for clothing_size the seperator is / so it should fill 2 custom fields with clothing size.

And genre (i use the catagory field in the xml table for this). I am trying to import to custom field genre with multiple choices in it, seperated with ,

<colors>black,pink</colors>
<clothing_size>S/M</clothing_size>

So 3 things, special genre import procedure, special colors one and special clothing_size

Current csvi template http://paste.thezomg.com/15907/91979051/
Current csvi tablefields http://paste.thezomg.com/15909/41919876/
Multiple fields combine sql http://paste.thezomg.com/15910/41919993/

and example xml http://paste.thezomg.com/15908/91980451/

Greetings,
Jan Willem

password in the example csvi is fake :)
0
Responses (8)
janwil
janwil
Accepted Answer Pending Moderation
Should i make a own routine in administrator/templates/<templatedir>/com_csvivirtuemart/models/import/ ?

How would the system know that this is a special import routine?

And how can i select this, so it knows it has to use my special genre import routine or color input routine or color import routine
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

How can i make it so csv improved checks the field and parses it to multiple values in that field.
CSVI won't parse this field because it has no idea what it is.

And for clothing_size the seperator is / so it should fill 2 custom fields with clothing size. And same for colors.
CSVI can't do that either.

If you take a look at the documentation on custom fields under the section Custom fields with multiple values you will see you need different field names like custom_title, custom_param, and custom_value. The custom_title and custom_param (if needed) could be set with fixed values. You could merge the colors and clothing_size fields and replace the separator on them. So you get this: black~white;L~XL which is the correct format for the custom_value field. That is something you can try.

same for category with i am trying to import to custom field genre with multiple choices in it, seperated with ,
You are not importing the category into the category_path field?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
janwil
janwil
Accepted Answer Pending Moderation
Thanks for the quick response

You are not importing the category into the category_path field?


Nopes, i use a general category for this, like DVD, TOYS and such things.

So what is the import routine message about in the manual? Maybe its possible for me to make my own addition for this so i don't have to change the xml source file (we get this from our delivery partner).

It uses the own made subroutine when you choose the option template field for it? Or am i thinking wierd?
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
So what is the import routine message about in the manual?
Don't know which message you are referring to.

Yes, it is possible to build your own import routines using overrides.

Have you tried the combining of fields and the replacement rules?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
janwil
janwil
Accepted Answer Pending Moderation
So what is the import routine message about in the manual?
Don't know which message you are referring to.

Yes, it is possible to build your own import routines using overrides.


Page 99 of the PDF, section 3, overrides (path is not correct there, but that is possible joomla3)

Have you tried the combining of fields and the replacement rules?

the biggest problem is it is in the same field (for example color)

The combining works with images though, so i use the field image_1 image_2 image_3 and image_4 and combine those with | in it. After that i import the combined thing to image_url

I think the best solution is to make a own override to import that type of field. How can i point csvi to the new import_color.php ?
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
How can i point csvi to the new import_color.php ?
It can't be called import_color.php, it must be the same name as the routine you are overriding, as shown in the page I linked it is productimport.php. Usually you would make an override of the current productimport.php and then modify it to suit your own needs.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 6
janwil
janwil
Accepted Answer Pending Moderation
Hello Ronald,
Any new updates about this. Is this in new version possible, also by giving the split fields character, like , in colors and / in size (see my example xml). Or where to request it, it would be nice if you can just give a xml node and say the split charater and it gets imported correctly
Greetings,
Jan Willem
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Jan Willem,

There is no update in this regard as you have a very specific request. There are no plans either to add this kind of support. You will probably need a script that turns the XML into the needed format for CSV/XML where the data can be read by CSVI.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!