How-to : Bulk import sites
- Updated on July 27th, 2024
- 49 Minute to read
- Share
-
Dark
1. Quick Overview
Purpose: The OPUS Bulk Sites Importer enables administrators to efficiently import multiple sites into OPUS, streamlining the setup process and ensuring data accuracy.
Pre-Requisites
Needed Access / Permissions: Administrator access to the OPUS platform.
Pre-setup Requirements: Ensure access to the OPUS platform and download the provided Excel import template
2. Step-by-Step Instructions
-
Download the Excel import template by clicking on the provided link: OPUSBulkSiteImporterTemplate.xlsx.
The link is available by clicking on the “i” button: -
Fill in the required information in the Excel spreadsheet, including Site Reference, Site Name, Country, Latitude and Longitude. Ensure all compulsory fields are completed.
- Columns with a Red Banner are considered Mandatory and must be captured
-
Check the validation indicators in column A to ensure data accuracy.
- Green indicates correct entries, while
- Red indicates incomplete or invalid entries.
- Once the spreadsheet is filled out, log in to OPUS as an administrator and navigate to the "Sites" section on the left menu panel
- Click on the "Sites Import" button located in the Actions menu.
- Select the “Select and Import button” and open the Import sheet captured
3. Tips and Tricks
Best Practices: Double-check the data in the spreadsheet before importing to ensure accuracy.
Common Issues and Fixes:
If any entries show as invalid, review and correct the data in the spreadsheet accordingly.
Ensure all compulsory fields are completed before importing. Compulsory fields are marked by having a red banner on the column header.
Additional Resources
- Refer to the OPUS documentation or contact the support team.