1. EsSa55
  2. RO CSVI
  3. Wednesday, 31 July 2019
  4.  Subscribe via email
Hello

I wish to output the equivalent of the attached spreadsheet in csvi, possible.

The sheet contains just 1 row which is sufficient to explain the request.

The highlighted fields can be used in a template.

The output needs to be filtered by discount_id = -1

The required result is the Difference column (T) which contains the formula and should only be output where Column T <> 0.

Is it possible to mirror the filter & formula using 1 or more rules?

u84uz_virtuemart_product_prices.zip

TIA

Eddie
Accepted Answer Pending Moderation
Hello Eddie,
You can use two rules here to get the calculation as per formula in your file. Check if you are able to perform the needed calculation with below rules.

1. Create RO CSVI Field Combine rule where you select Operation as Calculation and Perform operation as Subtraction. In the Source fields, add the fields you need the calculation to be performed and in the Target field where the calculated result should be applied. Check combinerule.png screenshot attached for field settings.
2. Create another rule using RO CSVI Conditional rule plugin which will check calculated value from the above rule and use value accordingly.
3. Apply these rules on the template field in the order of Combine rule first and then Conditional rule.
Attachments (1)
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. # 1
Accepted Answer Pending Moderation
Hello Theruna

I cannot see the attachment:

"Check combinerule.png screenshot attached for field settings."

The target field does not exist in the db; it is merely a calculation.

Does it need to exist?

Also, can I achieve:

"The output needs to be filtered by field "discount_id" = -1"

Best

Eddie

p.s. I notice the topic has been transferred to rolandd.com.

Was that deliberate?
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Eddie,

You cannot see the screenshot as @tharuna seems to have forgotten it. ;) She will be in tomorrow and can post the screenshot, I don't have it either.

"The output needs to be filtered by field "discount_id" = -1"
We do not have the option in the template settings for doing this. What I am thinking is that you could include the field in the template for export. Set the field to unpublished, this will prevent it from ending up in the output file. You can use the Skip rule to skip any row that does not match the -1. I am thinking that may be the way to go.

p.s. I notice the topic has been transferred to rolandd.com.
Yes, very deliberate :D The site csvimproved.com is closed down as we integrated all our products and support into a single site. We announced this last week on the site and via Twitter. For the time being we leave the site up and running for reference if needed, but we did post a notice on the forum that support has moved here. Hopefully that explains it.
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
Accepted Answer Pending Moderation
Hello Eddie,
I have added the combinerule.png screenshot to my previous post. Please check.
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. # 4
  • Page :
  • 1


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