Rather than manually modifying individual users, locations or reference numbers, an administrator can export information to a file and modify multiple records. The modified file can then be imported back into UPS CampusShip to add to an existing file or write over a list of existing information.
For more information on Importing Files, see File Importing in the Gather Key Information section of this guide.
The Export file will be a Comma Separated Value (.csv) file, a simple-text-only file in which each field is separated by a comma without spaces. Each record should be on its own line. The file should end with the .csv extension.
Using a comma as the field delimiter:
When exporting information, a comma will be used to separate the information in each field of a record. If a field is empty, a comma is inserted to "skip" to the next field. Thus, the format could contain multiple commas in a row without spaces.
Company Administrators can:
For more information on exporting specific file categories (locations, users, etc.), refer to the Administer UPS CampusShip section of this guide.
You can easily export and modify a .csv file in a spreadsheet program such as Microsoft Excel and most other spreadsheet programs.
Microsoft, Windows, and Microsoft Excel are trademarks of Microsoft Corporation.