Importing department records
You can import department records into Storeroom, instead of manually creating a record. You must specify the data in a Microsoft Excel spreadsheet that is saved as a CSV file format. However, you can also use a text editor, such as Notepad, to create the file.
This table displays the format that is required for the file. You must specify each header name in the same order as displayed. These values are required to create a record:
- departmentKey
- description
| Column | Header name | Accepted data values |
|---|---|---|
| A | departmentKey | String |
| B | description | String |
| C | nonstockTransLimit | Numerical |
| D | transactionDailyLimit | Numerical |
| E | transactionMonthlyLimit | Numerical |
| F | transactionPertransactionLimit | Numerical |
| G | allowTransactionOverrideLimit | Numerical |
| H | activeStatus | True or False |
* To import multiple values, use the pipe symbol (|) as a separator. For example, Dep01|Dep02|Dep03.