1. BluSky
  2. RO CSVI
  3. Monday, 30 November 2020
  4.  Subscribe via email
Hi,
I have 2 tables that have 3 fields in common, one of which represents the quantity.

While importing the file in the first table, it is possible to update the quantity field of the second table according to 2 common fields.

Thanks
Accepted Answer Pending Moderation
Hello,

I am not really clear on what you are trying to achieve but all fields in the import file are always updated based on either the primary key or the field given in the import template.

Perhaps you can give me an example of what you are trying to do and I can see if anything is possible.
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
Accepted Answer Pending Moderation
Hi,
I have two tables Table A and Table B. Table B is populated with the Sample.csv file and I would like the quantities sold to be subtracted from Table A.

SAMPLE.CSV
The import file contains:
PRODUCTCODE! DESCRIPTION! QUANTITY! IDKEY
12345678! SANDWICH! 3! AY230
12345698! HAMBURGER! 1! AY230

Before importing the file:

Table A
PRODUCTCODE - DESCRIPTION - QUANTITY - IDKEY
---------------
12345678 - SANDWICH - 10 - AY230
12345678 - SANDWICH - 31 - RP980
54123985 - SWEET CHEESE - 23 - AY230
63325689 - TOMATO BIG - 35 - AY230
12345698 - HAMBURGER - 5 - AY230
12345698 - HAMBURGER - 14 - FTQL1

Table B
PRODUCTCODE - DESCRIPTION - QUANTITY - IDKEY

After importing the file I would like this result:

Table A (if the item with PRODUCTCODE + IDKEY is present, the values ​​are subtracted)

PRODUCTCODE - DESCRIPTION - QUANTITY - IDKEY
---------------
12345678 - SANDWICH - 7 - AY230
12345678 - SANDWICH - 31 - RP980
54123985 - SWEET CHEESE - 23 - AY230
63325689 - TOMATO BIG - 35 - AY230
12345698 - HAMBURGER - 4 - AY230
12345698 - HAMBURGER - 14 - FTQL1

Table B (import .csv file)
PRODUCTCODE - DESCRIPTION - QUANTITY - IDKEY
---------------
12345678 - SANDWICH - 3 - AY230
12345698 - HAMBURGER - 1 - AY230

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello,
You did not tell us which import operation you are using so with the mentioned fields i am guessing you are using RO CSVI Custom table import.

With RO CSVI Custom table import you can add or update values only with one table but you want to change the value in one table when you are importing values into another. You need to write custom code to change values of another table on import. There are two ways of writing custom code.

1. Create a RO CSVI custom rule to do subtraction on field in Table A. The rule should be applied on QUANTITY field in import.
2. Create an override for import to do the subtraction on Table A field on import.
Kind regards,

Tharuna

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

unfortunately I'm not practical. I have tried to use RO CSVI Margin but without success.

I have a certain urgency so I ask you, if possible, for help.

Thanks
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
You still haven't told us which import operation you are using.

unfortunately I'm not practical. I have tried to use RO CSVI Margin but without success.

RO CSVI Margin plugin will not work here. The RO CSVI rule plugins we have now do not support of updating a field in another table. As i mentioned in my previous reply you need to write a custom rule plugin for this feature.

I have a certain urgency so I ask you, if possible, for help.

This feature is specific to your site and would need customisation in RO CSVI. We do such custom jobs at an extra cost. You can write an email to Roland about your requirements and he would send you a quote in doing this job.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
Accepted Answer Pending Moderation
ok
On which email should I send the request?
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
You can send your request to support@rolandd.com email.
Kind regards,

Tharuna

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


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