Butter Production livelihood strategies require Livelihood Activity Labels for the pipeline to recognize the Livelihood Strategy, and changes to them can have unintended side effects.
For butter production, set up specific Activity Labels for these lines that use the following values:
|
Column |
Value |
Notes |
|---|---|---|
|
status |
Override |
Use this label to set the metadata |
|
is_start |
True |
This label indicates the start of a Livelihood Strategy |
|
strategy_type |
ButterProduction |
This indicates that all the rows after this are about ButterProduction, rather than MilkProduction |
|
attribute |
percentage_milk_sold |
|
|
product_name |
Cow’s Milk Butter (for example) |
Even though the label contains cows' milk we know that for the ButterProduction Strategy the product needs to be Cow's Milk Butter rather than Cow's Milk. Similarly, you would use Goat’s Milk Butter or Sheep’s Milk Butter. |
|
season |
Season 1 |
BSSs assume that all butter sales are in Season 1 and don't have a line for Season 2 sales. Therefore, the first Butter Production Strategy is always for Season 1. |
This setup allows the pipeline to correctly know that it has found the Butter Production section, and what type of butter it is. Without this setup to force a new Livelihood Strategy the pipelines will always return an error indicating a duplicate value ButterProduction for the existing strategy_type MilkProduction.
This differs from the normal approach. Both the Regular Expression approach and the Activity Label approach to recognizing metadata rely on the fact that certain labels in column A always indicate the start of a new Livelihood Strategy.
Example
For all Crop Production Strategies, the quantity produced is always the start of a new Strategy. As we process the Data worksheet row by row if we see a line like Niébé: kg produits, because the line contains kg produits we know that a) it is start of a new Strategy; b) the product is Niébé; and c) the following lines (kcals per kg, price, quantity sold, etc.) are all referring to the LivelihoodStrategy we started at this row.
This approach works well in most cases, but it doesn't work for Butter Production because there is no line in the BSS that says, for example, Butter from Cows' Milk, so we have no way to identify the correct product. Therefore, we use Activity Label overrides as a workaround.
The Livelihood Strategies related to Butter Production always start immediately after a line containing the percentage of milk sold, with a label like % cows' milk sold. It can't logically be added to the Milk Production Strategies because it is a statistic about total annual production but there are actually two Livelihood Strategies - one for each Season. The line contains calculated data (the total of Season 1 and Season 2 Sales divided by total of Season 1 and Season 2 production), so there is no need to store it.