Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revisionBoth sides next revision | ||
import_and_export:importing_names [2022/01/28 19:22] – [Introduction] Mark Glover | import_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: | | K | Last name. This column is the difference between a customer and a patient: | ||
| L | First name (applies only to people) | | L | First name (applies only to people) | ||
- | | M | Date of birth (please | + | | M | Date of birth (use 4-digit |
| N | Gender (enter " | | N | Gender (enter " | ||
| O | Custom 1 | | | O | Custom 1 | | ||
Line 48: | Line 48: | ||
| W | Postcode (Zip code) | | | W | Postcode (Zip code) | | ||
| X | On hold (" | | X | On hold (" | ||
+ | | 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, | Column C describes the type of the name being imported. That is, whether it is a customer, supplier, manufacturer, |