Bug 631

Summary:	Add CSV output to budget-sync
Product:	Libre-SOC Organisation	Reporter:	Jacob Lifshay <programmerjake>
Component:	Planning	Assignee:	Jacob Lifshay <programmerjake>
Status:	RESOLVED FIXED
Severity:	enhancement	CC:	libre-soc-org, programmerjake
Priority:	High
Version:	unspecified
Hardware:	PC
OS:	Linux
See Also:	https://bugs.libre-soc.org/show_bug.cgi?id=464
NLnet milestone:	---	total budget (EUR) for completion of task and all subtasks:	0
budget (EUR) for this task, excluding subtasks' budget:	0	parent task for budget allocation:
child tasks for budget allocation:		The table of payments (in EUR) for this task; TOML format:

Description Jacob Lifshay 2021-04-25 05:45:02 BST

from lkcl:
nlnet is having difficulty keeping track of rhe task subdivision given that many different people contribute over time.
could you add CSV write to budgetsync which has, as columns, each person's amount, date requested, date paid, plus a "percentage" column showing how much of total has been paid for rhe task.
each Grant should have its own separate CSV file.

Comment 1 Jacob Lifshay 2021-09-22 05:33:28 BST

I pushed a fix for this, I adjusted the generated CSVs for milestones to include columns for:
budget_excluding_subtasks: value from bugzilla
budget_including_subtasks: value from bugzilla
fixed_budget_excluding_subtasks: value guessimated to hopefully be consistent
fixed_budget_including_subtasks: value guessimated to hopefully be consistent
submitted_excluding_subtasks: sum of all payments that are submitted and/or paid
paid_excluding_subtasks: sum of all payments that are paid

I also adjusted it to include all bugs that have payments and/or money assigned, rather than just those bugs with payments.

I'm assuming nlnet is quite capable of dividing one column by another to derive percentages (paid_excluding_subtasks * 100% / budget_excluding_subtasks)

lkcl, if you're happy with this, please mark this fixed

Comment 2 Jacob Lifshay 2022-02-24 20:39:09 GMT

assuming fixed since no one complained