import_and_export:importing_names

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revisionBoth sides next revision
import_and_export:importing_names [2022/01/28 19:22] – [Introduction] Mark Gloverimport_and_export:importing_names [2022/02/10 12:44] – [Setting up the import file] Gary Willetts
Line 36: Line 36:
 | K       | Last name. This column is the difference between a customer and a patient:  A customer will have a blank last name, a patient **must** have a non-blank last name | | K       | Last name. This column is the difference between a customer and a patient:  A customer will have a blank last name, a patient **must** have a non-blank last name |
 | L       | First name (applies only to people)         | | L       | First name (applies only to people)         |
-| M       | Date of birth (please use 4-digit year)     |+| M       | Date of birth (use 4-digit years)     |
 | N       | Gender (enter "F" or "True" for females. All other values taken as male) | | N       | Gender (enter "F" or "True" for females. All other values taken as male) |
 | O       | Custom 1                  | | O       | Custom 1                  |
Line 48: Line 48:
 | W       | Postcode (Zip code)       | | W       | Postcode (Zip code)       |
 | X       | On hold ("T" or "Y" for true, anything else, including blank, for false) | | X       | On hold ("T" or "Y" for true, anything else, including blank, for false) |
 +| Y       | ID. The ID of the name record in the mSupply database. Optional and ignored unless updating a name. If you're updating a name then it is mandatory. During an update, the name this ID belongs to is compared with the name the code in column A belongs to. If they are the same record then the update will proceed, otherwise this line in the import file will be skipped. |
  
 Column C describes the type of the name being imported. That is, whether it is a customer, supplier, manufacturer, donor or patient. A name could be any one of these or several of them. To indicate which of these the name is, simply include the letter shown in the table below in the type field (letter order is not important): Column C describes the type of the name being imported. That is, whether it is a customer, supplier, manufacturer, donor or patient. A name could be any one of these or several of them. To indicate which of these the name is, simply include the letter shown in the table below in the type field (letter order is not important):
  • Last modified: 2024/04/04 15:07
  • by Gary Willetts