Resolved Possible to mirror attached spreadsheet in csvi?

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.

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?

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 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.

Hello Eddie,
I have added the combinerule.png screenshot to my previous post. Please check.