Product Drives -- expand export to be like Distribution etc

[cielf]

Summary

Although there is a product drive export, to be really useful, it needs to have the items in it, like we do with the distribution and the donation exports

Why?

Increased utility. Saving banks time.

Details

• Export of product drive to be expanded to include the number of each item that were received from each product drive.
• Have a column for each active item whether or not any of that item were received in the drive.
• Item columns are in a stable order -- this will be used as input to other spreadsheets of the organization, so that is important
• Similar to Include columns for all the distributions items in the distribution export #3388 and Expand storage location export to include # of each item on hand. #3430

Criteria for completion

• Functionality as described above is available
• tests to support this functionality

[anoosh96]

Hey @cielf, I can take this up, can you please assign me this issue?

[cielf]

@anosh96 You got it!

[anoosh96]

Hi @cielf I need to clarify something. Do we need to have a column for each active item, whether or not they were received in the drive?, e.g if we have 90 active items, and only 8 of them were received in the drive then we will have 8 columns with their respective quantity and 82 columns with '0' as quantity.

[cielf]

Yes, but also inactive ones, because they may be pulling a report across a significant period of time.

From the way your phrased your question -- I want to point out that the unfiltered export is across multiple product drives.

[anoosh96]

thanks for clarification @cielf, can you please review the PR linked to this issue?

[cielf]

Hi @anoosh96 I'm really busy early this week, but will take a look before the weekend if no one else beats me to it.

[anoosh96]

hi @cielf, just a warm reminder about the PR review.

[cielf]

@anoosh96 Will start looking at it today, but may have fragments of time while waiting for other processes to finish to look at it, I'm afraid.

[anoosh96]

great, thanks @cielf

[github-actions]

This issue has been inactive for 250 hours (10.42 days) and will be automatically unassigned after 110 more hours (4.58 days).