Uploading instructions for formula Item lines in BDL Stage table

The instructions for the formula item lines are stored in the XML format using a special function code INSTRUC in the FSFORMULADOC sheet. These columns are mandatory:
  • FORMULA_CODE
  • VERSION
  • FUNCTION_CODE
  • TEXT_DATA
  • ATTCH_CNT
  • ATTACH_TYPE

The instruction XML document has a root node “ingredinstruc” and can have multiple child nodes, each node called as an “instruction”. The “instruction” node has two attributes, “lineID” which is match line id of an item line in formula ingredients, the other attribute is “lineType” and is always 0 (i.e. 0 – ingredients).

The Instruction node supports font styling like bold, italics, strikethrough, and underline. Instruction also supports font coloring.

Tag Description

b}bold instruction {/b}

To bold an Instruction or part of an instruction, it needs to be embedded within {b} tag

.

{i} italics instruction{i}

To italics an instruction or part of an instruction, it needs to be embedded within {i} tag.

u} underline instruction {/u}

To underline an instruction or part of an instruction, it needs to be embedded within {u) tag.

{s} strikethrough instruction {/s}

To strikethrough an instruction or part of an instruction, it needs to be embedded within {s} tag.

To apply color to an instruction or part of an instruction, the required text must be embedded within the “{font color="colorCode"} {/font}” tag. For example, to apply red color: {font color="#d66221”} red{/font}.