Difference between revisions of "Information Systems:Updating MMBC"
(Created page with "This is a non-profit organization that is fully financed by industry to manage residential packaging and printed paper recycling programs in BC, either directly or by working...") |
|||
| Line 1: | Line 1: | ||
This is a non-profit organization that is fully financed by industry to manage residential packaging and printed paper recycling programs in BC, either directly or by working with local governments, First Nations, private companies, and other non-profit organizations. (www.multimaterialbc.ca) |
This is a non-profit organization that is fully financed by industry to manage residential packaging and printed paper recycling programs in BC, either directly or by working with local governments, First Nations, private companies, and other non-profit organizations. (www.multimaterialbc.ca) |
||
| − | + | =Download File to Excel= |
|
In InfoNet, go to UniView / Sales Statistics / Summarized Item Sales. Set ‘From Year/Month’ and ‘To Year/Month’ so that the entire year is included, and click on ‘Search’. Then click on ‘MMBC to Excel’. |
In InfoNet, go to UniView / Sales Statistics / Summarized Item Sales. Set ‘From Year/Month’ and ‘To Year/Month’ so that the entire year is included, and click on ‘Search’. Then click on ‘MMBC to Excel’. |
||
Revision as of 15:33, 13 October 2015
This is a non-profit organization that is fully financed by industry to manage residential packaging and printed paper recycling programs in BC, either directly or by working with local governments, First Nations, private companies, and other non-profit organizations. (www.multimaterialbc.ca)
Download File to Excel
In InfoNet, go to UniView / Sales Statistics / Summarized Item Sales. Set ‘From Year/Month’ and ‘To Year/Month’ so that the entire year is included, and click on ‘Search’. Then click on ‘MMBC to Excel’.
This will create an Excel file of item information, sales, and MMBC rates that have been previously uploaded. The user can key in new rates, calculate our payment, then upload the updated rates back into the i.
Upload File from Excel
Save the updated file as CSV. This must be in the same format as was previously downloaded – you cannot insert or remove columns (however, you can add columns to the end; they will be ignored in the upload). In InfoNet, go to Maintenance & Lists / MMBC / Upload CSV File. After it has been uploaded, the first 50 records of the file will be displayed. If they look correct – like, for example, everything is in the correct column – click on ‘Update’.