Bulk Upload of Smartcard Manifests
Overview
The system provides a bulk upload feature that allows administrators to add, update, or remove Smartcard Manifest records using a spreadsheet file. This functionality enables users to manage multiple manifest records efficiently instead of editing them individually in the system.
Users can download a template or the current manifest list, update the required fields in the spreadsheet, and upload the file to perform the bulk action.
Where to Access the Feature
The Smartcard Manifest bulk upload feature can be accessed from two locations in the system.
1. Routes Screen
- Navigate to Routes.
- Click Import Route Manifests.
2. Route Details Page
- Open a specific route.
- Click Import Smartcard Manifest.
Both options will open the Import Smartcard Manifests dialog where the template can be downloaded and files can be uploaded.
Downloading the Template or Existing Manifest List
Before performing a bulk action, download a reference file from the Import Smartcard Manifests/ Import Route dialog.
Available options include:
- Blank File
Download an empty template file to create new Smartcard Manifest entries. - Smartcard Manifests List
Download the existing manifest list for the selected route. This is useful when updating or reviewing current records.
Steps to Perform Bulk Upload
Step 1 – Download the Template or Existing List
Open the Import Smartcard Manifests dialog and download either the Blank File or the Smartcard Manifests List.
Step 2 – Update the File
Open the downloaded spreadsheet and update the rows with the information required to add, update, or remove manifest records.
Ensure all required fields are correctly populated. When performing ADD or UPDATE actions, fields such as start_date and end_date should be set accordingly.
Example configuration:
| Column | Example Value | Description |
|---|---|---|
| repeat_interval | 10 | Number of repeat intervals |
| repeat_unit | years | Unit for the repeat interval |
| start_date | 2025-01-01 | Start date of the manifest validity |
| end_date | 2035-01-01 | End date of the manifest validity |
Note: The above example shows a 10-year validity period. Other values can be used depending on the operational requirement.
Step 3 – Save the File
Save the spreadsheet after completing the necessary updates.
Step 4 – Upload the File
In the Import Smartcard Manifests dialog:
- Select the file using the File input option.
Step 5 – Process the File
Choose the appropriate action depending on the required operation:
- ADD – Create new Smartcard Manifest records
- UPDATE – Modify existing Smartcard Manifest records
- REMOVE – Delete Smartcard Manifest records
Click the corresponding button to process the uploaded file.
Important Notes
- Do not modify or remove column headers in the template file.
- Click on the question mark (?) icon to view the required format for each data field.
- Missing or incorrectly formatted fields may cause the upload process to fail.
- When updating records, ensure the uploaded data matches the existing records that need to be modified.