import_and_export:importing_assets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
import_and_export:importing_assets [2021/08/10 15:56] – [Doing the import] Gary Willettsimport_and_export:importing_assets [2022/01/19 15:27] (current) – [Import spreadsheet format] Gary Willetts
Line 1: Line 1:
 {{indexmenu_n>90}} {{indexmenu_n>90}}
- +====== 17.09. Importing assets ======
-====== 16.09. Importing assets ======+
 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 "//last name//,//first name//". Will be created if the user does not exist as a contact of the location. |+| 15             | O              | Asset user name                 | 255 alphanumeric characters. The name of the asset user in the format "//last name//,//first name//". Will be created if the user does not exist as a contact of the location (the first and last names only are used to determine whether the asset user exists. Phone number and email address are ignored in the check). |
 | 16             | P              | Asset user phone number         | 255 alphanumeric characters | | 16             | P              | Asset user phone number         | 255 alphanumeric characters |
 | 17             | Q              | Asset user email                | 255 alphanumeric characters | | 17             | Q              | Asset user email                | 255 alphanumeric characters |
Line 85: Line 84:
 \\ \\
 \\ \\
-|  //  Previous:  **[[import_and_export:importing_a_supplier_invoice]]** | | Next: **[[import_and_export:import_regions]]** //  |+|  //  Previous:  **[[import_and_export:importing_a_supplier_invoice]]** | | Next: **[[import_and_export:importing_regions]]** //  |
 ---- struct data ---- ---- struct data ----
 pagestatus.status    :  pagestatus.status    : 
 ---- ----
  
  • Last modified: 2021/08/10 15:56
  • by Gary Willetts