Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revisionLast revisionBoth sides next revision | ||
import_and_export:importing_assets [2021/04/23 10:07] – [Doing the import] Gary Willetts | import_and_export:importing_assets [2021/10/08 09:31] – 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 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 57: | Line 56: | ||
Here is an example spreadsheet you can use (contains no property columns, only the standard mSupply columns): {{ : | Here is an example spreadsheet you can use (contains no property columns, only the standard mSupply columns): {{ : | ||
+ | |||
+ | <WRAP important center round 90%> | ||
+ | When entering dates in the spreadsheet, | ||
+ | </ | ||
===== Doing the import ===== | ===== Doing the import ===== | ||
Line 81: | Line 84: | ||
\\ | \\ | ||
\\ | \\ | ||
- | | // Previous: | + | | // Previous: |
---- struct data ---- | ---- struct data ---- | ||
pagestatus.status | pagestatus.status | ||
---- | ---- | ||