Code conversion
Bots supports code conversions. The code conversion is done in a mapping script; maintenance for the codes can be done via bots-monitor->Configuration->User codes as list.
This page contains 3 examples of code conversions:
- convert currency code list.
- convert internal article code to buyers article code.
- convert internal article code to description.
Code maintenance in GUI
First configure 2 code lists (bots-monitor->Configuration->user codes by type): Make the code conversions (bots-monitor->Configuration->user codes as list):
Code conversion in mapping script
import bots.transform as transform
#convert currency code
our_currency_code = inn.get({'BOTSID':'HEA','VALUTA':None})
converted_currency_code = transform.ccode('Currency',our_currency_code)
#convert internal article code to buyers article code:
buyer_article_number = transform.ccode('LookupArticleNumber',our_article_number)
#get description (in field 'attr1') for article
description = transform.ccode('LookupArticleNumber',our_article_number,field='attr1')
#code conversion also works via reverse lookup:
our_article_number = transform.reverse_ccode('LookupArticleNumber',buyer_article_number)
Codeconversion functions
transform.ccode(codelist, value, field, safe)
Convert 'value' to value in 'field' using a user-maintained code list.
Parameters:
- codelist: codelist as in bots-monitor->Configuration->user codes by type.
- value to be converted (should be in 'leftcode')
- field: the field to lookup (if not specified: 'rightcode')
-
safe: if False (default): raise exception when value is in found in codelist. If True: just return 'value'.
Example of usage for leftcode to rightcode:
transform.ccode('articles','8712345678906')
Example of usage for leftcode to attr1:
transform.ccode('articles','8712345678906','attr1')
transform.reverse_ccode(codelist, value, field)
as transform.ccode(), but conversion is from 'rightcode' to 'field'.
Changes in codeconversion functions
Note: These functions have changed over versions. The old functions are deprecated but still work.
bots < 2.1 | bots < 3.0 | bots >= 3.0 |
---|---|---|
codetconversion | ccode | ccode |
safecodetconversion | safe_ccode | ccode with parameter safe=True |
rcodetconversion | reverse_ccode | reverse_ccode |
safercodetconversion | safe_reverse_ccode | reverse_ccode with parameter safe=True |