Categories
View Replies (3)

Resolved Virtuemart Import : Get Value(s) in other tables

  1. ekcsvi
    ekcsvi
  2. RO CSVI
  3. Sunday, 24 February 2019
  4.  Subscribe via email
Hello

Hope you are well

I want now to import products in virtuemart from a given CSV file but need to find the values in an othertable (manufacturers).

exemple for manufacturers :

I have a field "MARQUE" in my csv source file looking like "DLIN"

I read "DLIN" in source csv file, then must find it in the manufacturer table located in field "metakey" and need to return full name located in manufacturer "mf_name" ( "D-LINK" ) in order to write it in my product field "manufacturer_name"

Well, hope this is clear enought and that you can help me ;-)

Thank you in advance for your explanations
Eric
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Eric,

What you are asking is not something CSVI can do out-of-the box. The only way to do this using the core is to create replacement rules but these values would be hardcoded. The only option I see that you have here is to write your own replacement rule. We have documentation on Writing a rule plugin.

Once you have the rule plugin you can assign it to the manufacturer_name field and it can retrieve the data for you.
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. # 1
ekcsvi
ekcsvi
Accepted Answer Pending Moderation
Hi RolandD

This is SO sad the possibility is not there :dry: Maybe a great improvement for the future ...

OK, no choice, as I don't understand much in plugins and as I don't have much time lets go for replacement rule...

Thank you anyway for the answer

Eric
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Eric,

I understand this is not good news for you but then again, it is rather a specific request. At least there is an alternative. We will keep the request in mind.
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. # 3
  • Page :
  • 1


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