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

For example, <ingredinstruc><instruction lineID="1" lineTYPE="0">Combine with Buttermilk and Water</instruction><instruction lineID="3" lineTYPE="0">Pour combination into Blender</instruction><instruction lineID="4" lineTYPE="0">Mix Butter, Buttermilk Powder and Water for 15 min at 45 RPMs</instruction><instruction lineID="7" lineTYPE="0">Combine Ingredients from Steps 1 to 4 with Bread Crumbs and Ricotta Cheese. Blend for 10 until smooth</instruction></ingredinstruc>

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