Uploading Input Quota Assignments via an Excel Spreadsheet

It is possible to set input quotas for a single input for multiple farmers at one time by uploading an Excel sheet.

Context

Procedure

Click on the Input Supply tab on the left side of the screen.
Click Download Template at the top right of the screen.
Click on the Quota Assignment Sheet that you have just downloaded. The Quota Assignment sheet may also be found in the Downloads folder of your computer, if you are using a PC computer.
Open the Quota Assignment Excel file that you just downloaded.
Decide on which input you want to assign to assign an input quota.
Enter the <Producer Code> that is assigned to a farmer in the Administrator system. Then enter the <Quantity> of the input you want to assign as his or her quota.

Check what unit of measurement is assigned to the input in the Administrator system. For example, Urea may come in grams while seeds may come in bags. Check this in the Master Data tab on the Products page.
Repeat on each row of the sheet, entering all Producer Codes and Quantities of the input you want to assign.
After you have added all the quota assignments for all farmers who need a specific input, save the Excel file to your computer in a location that you will remember, such as on your Desktop or in a specific folder.
Return to the main Input Supply tab in the administrator system.
Click Import at the top right of the page.
Click Browse in the pop-up window and find the Quota Assignment Excel file you completed and saved in Step 8. Search for and click on that file in the pop-up window. Click Open in the pop-up window.

You will then see the name of the Quota Assignment sheet file in the box.
Choose the product/input that the quota assignment applies to. The unit of measurement for the input will be shown beside each possible selection. Ensure that it is the unit of measurement you expected for that input.

Note

Remember that you can only upload a bulk batch of quota assignments for one product/input at a time. If you had quota assignments in your Excel sheet for different inputs, go back and revise the sheet so all farmers’ quotas apply to the same type of input.
Click Save.

Now the quota assignment set for the input for the selected farmers is effective in the Administrator System.
If you wish to upload a quota assignment for multiple farmers for a different input, repeat steps 1-13 to fill in and upload a Quota Assignment Excel sheet for another input.

Note

If there is an error with the upload, an error message will display and tell you what the problem is.

A common mistake that can causes errors while importing a quota assignment sheet is if you have included a Producer Code that does not exist in the Rural Sourcing Management System.