Spreadsheets |
Top Previous Next |
VEHCS allows a batch data upload option for the following certificates:
To upload commodities to a certificate, you must use the VEHCS provided Excel spreadsheet as your template. The template requires Microsoft Excel 2010 or later. Click Save when prompted to save the template to your hard drive. Follow the instructions in the template to enter and upload the data. The instructions are the same for each type of certificate.
SAMPLE INSTRUCTIONS The Cattle for Breeding/Rearing (or Circus/Exhibition) to Canada instructions are as follows:
1. Enter one animal per row using the columns below to describe the animal. Make sure the data is entered inside the mapped cell range which begins at cell A4 and expands as new rows are consecutively entered. The end of the mapped cell range is indicated by a small arrow at the right-bottom of the last cell. If there is data outside of the cell range, drag the arrow to include these rows. NOTE: If a calf was born after its mother was tested and the animal is being shipped with its mother, the association between the calf and mother must be done in VECHS after the data is uploaded.
2. Once the data entry is complete, save the data as an XML data file. a. Click File then Save As. b. Select a folder and file name c. Select XML Data (*.xml) as ‘save as type’. d. Click Save to export the spreadsheet into XML data file. e. Click Continue on the "Saving the file as XML Data will result in the loss of worksheet features..." message.
3. To upload the commodity XML data file into VEHCS, follow the instructions on the Commodities page of the Certificate.
HELPFUL TIPS To use an Excel spreadsheet template, complete the following steps:
NOTE: The error message will not be the exact row number that you see in Excel since the first 3 rows in Excel are the instructions and column headers. The actual animal data itself starts on Excel row 4. If an error is found on the very first animal entered in the spreadsheet, the error message will state the nature of the error as being “on data row 1” which actually corresponds to Excel row 4. If any errors are found, no data from the spreadsheet will be loaded. Once all the errors are corrected, all the data will be uploaded.
NOTE: You can use a combination of Option 1 (manual entry) and Option 2 for the batch upload, to get all your animals in the Certificate. For example, when you batch upload more than one swine into the Certificate, but then they 5 more swine to add to the shipment. You can add each swine manually using Option 1 -> Generate Rows. (You will not have to use the spreadsheet option again. However, if you want to use the batch upload option again, ensure that only the new 5 swine are in the Excel template.) |