Categories
View Replies (2)

Resolved splitted eancode, category tree

  1. planuwkantoor
    planuwkantoor
  2. RO CSVI
  3. Wednesday, 28 June 2017
  4.  Subscribe via email
CSVI Pro 7.2.3
virtuemart 3.2.2
Joomla 3.7.2

Hello,
My CSV file uses 2 fields for the ean code.
Can i join this two fields?
EAN PREFIX and ARTICLENUMBER joined is the EAN

then there is a field CATEGORY_PATH
wich looks like this: ['Keukenartikelen', 'Potten & pannen', 'Specials', 'Gourmetpan']
Can this also be imported together with the article?
So Potten & pannen is the child of Keukenartikelen
Specials is the child of Potten & pannen and so on.

The image field looks like this: ['110126_2017.jpg']
Shall i better strip the [' '] before importing? or is there a trick csvi can handle this.

A lot of questions at onces. if you like me to split the questions of course that is no problem

regards,

Marcel Lucassen
0
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Marcel Lucassen,
A lot of questions at onces. if you like me to split the questions of course that is no problem

That would be better as handling all questions in one forum post may cause confusions. I have answered your questions for now, For any new queries please start a new post.

Can i join this two fields?
EAN PREFIX and ARTICLENUMBER joined is the EAN

You can use Combine rule plugin to combine these two fields and apply the rule on EAN field.

then there is a field CATEGORY_PATH
wich looks like this:
Can this also be imported together with the article?
So Potten & pannen is the child of Keukenartikelen
Specials is the child of Potten & pannen and so on.

You can use the same combine rule as explained above and apply the rule on category_path field.

The image field looks like this:
Shall i better strip the before importing? or is there a trick csvi can handle this.

From your CSV file i see that your image field looks like ['111420_2017.jpg'], you can use find and replace rule using CSVI Multi replace plugin and apply the rule on your image field. Your rule should contain two sets of replacements. One for find and replace [' and the second two find '] and replace with empty.
Kind regards,

Tharuna

=========================
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. # 1
planuwkantoor
planuwkantoor
Accepted Answer Pending Moderation
THank you for the quick reply.
I go working with your tips and when i need help again i separate the questions.

regards,

Marcel
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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