Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
import_and_export:importing_assets [2021/04/30 08:20] – [Import spreadsheet format] Gary Willetts | import_and_export:importing_assets [2022/01/19 15:27] (current) – [Import spreadsheet format] Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
{{indexmenu_n> | {{indexmenu_n> | ||
- | + | ====== | |
- | ====== | + | |
Assets are imported directly from Excel spredsheets so there is no need to export data from the spreadsheet to a tab delimited text file first (as you need to do for other imports). | Assets are imported directly from Excel spredsheets so there is no need to export data from the spreadsheet to a tab delimited text file first (as you need to do for other imports). | ||
Line 34: | Line 33: | ||
| 13 | M | Location code | 20 alphanumeric characters. The code the location name will have. Will be matched against the names currently in the database. If a name with this code does not exist, one will be created with the name provided in the Location name field. If the Location name field is empty the name will be created with the code as its name. This field is mandatory if you want mSupply to create the name. | | | 13 | M | Location code | 20 alphanumeric characters. The code the location name will have. Will be matched against the names currently in the database. If a name with this code does not exist, one will be created with the name provided in the Location name field. If the Location name field is empty the name will be created with the code as its name. This field is mandatory if you want mSupply to create the name. | | ||
| 14 | N | Location name | 255 alphanumeric characters. | | 14 | N | Location name | 255 alphanumeric characters. | ||
- | | 15 | O | Asset user name | 255 alphanumeric characters. The name of the asset user in the format "// | + | | 15 | O | Asset user name | 255 alphanumeric characters. The name of the asset user in the format "// |
| 16 | P | Asset user phone number | | 16 | P | Asset user phone number | ||
| 17 | Q | Asset user email | 255 alphanumeric characters | | | 17 | Q | Asset user email | 255 alphanumeric characters | | ||
Line 42: | Line 41: | ||
| 21 | U | Custodian email | 255 alphanumeric characters | | | 21 | U | Custodian email | 255 alphanumeric characters | | ||
| 22 | V | Current status | | 22 | V | Current status | ||
- | | 23 | W | Proposed status | + | | 23 | W | Proposed status |
| 24 | X | Type | 255 alphanumeric characters. Will be created if it doesn' | | 24 | X | Type | 255 alphanumeric characters. Will be created if it doesn' | ||
| 25 | Y | Condition | | 25 | Y | Condition | ||
Line 51: | Line 50: | ||
| 30 | AD | Disposal value | Number, currency. The value of the asset at the end of its useful life | | | 30 | AD | Disposal value | Number, currency. The value of the asset at the end of its useful life | | ||
| 31 | AE | Insurer name | 255 alphanumeric characters | | | 31 | AE | Insurer name | 255 alphanumeric characters | | ||
- | | 32 | AF | Insurance policy | + | | 32 | AF | Insurance policy |
| 33 | AG | Insurance renewal date | Valid date in current operating system format. The date the insurance should be renewed by | | | 33 | AG | Insurance renewal date | Valid date in current operating system format. The date the insurance should be renewed by | | ||
| 34 | AH | Notes | Lots of alphanumeric characters! Any other information that needs to be stored against the asset | | | 34 | AH | Notes | Lots of alphanumeric characters! Any other information that needs to be stored against the asset | | ||
Line 85: | Line 84: | ||
\\ | \\ | ||
\\ | \\ | ||
- | | // Previous: | + | | // Previous: |
---- struct data ---- | ---- struct data ---- | ||
pagestatus.status | pagestatus.status | ||
---- | ---- | ||