[ic] log_transaction question

DB DB at M-and-D.com
Thu Sep 30 20:50:00 UTC 2010


>> >> [import table=transactions type=LINE continue=NOTES]
>> >> ...
>> >> 
>> >> [if value mv_payment_mode eq purchase_order]
>> >> paid: 1
>> >> [/if]
>> >> 
>> >> [/import]
>> > 
>> > It's better to put it in the data portion only:
>> > 
>> > paid: [if value mv_payment_mode eq purchase_order]1[/if]
>> > 
>> > -- 
>> > Mike Heins
>> > Perusion -- Expert Interchange Consulting    http://www.perusion.com/
>> > phone +1.765.328.4479  <mike at perusion.com>
>> 
>> 
>> Thanks - this does not seem to be working and I've double checked for
>> typos and restarted IC. I don't know if it matters but my "paid" field
>> is type char(1). Do I need to perhaps use
>> 
>> paid: [if value mv_payment_mode eq purchase_order]'1'[/if]
>> 
>> or something like that?
> 
> No. Something else is going on, what that is I can't say.
> 
> -- 
> Mike Heins

Further up in log_transaction I see

payment_method: [value mv_payment]
payment_mode: [data session payment_mode]

I really don't know how these differ - maybe I really want

paid: [if value mv_payment eq purchase_order]1[/if]






More information about the interchange-users mailing list