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_names [2022/02/10 12:44] – [Setting up the import file] Gary Willetts | import_and_export:importing_names [2024/04/04 15:07] (current) – [Setting up the import file] Gary Willetts | ||
---|---|---|---|
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. | | + | | Y | Latitude (positive or negative decimal number) |
+ | | Z | Longitude (positive or negative decimal number) | | ||
+ | | AA | ||
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, | ||
Line 74: | Line 76: | ||
* Ignore the first line. You will want to if you have used the first row for column headings | * Ignore the first line. You will want to if you have used the first row for column headings | ||
* Strip out line feeds and quote characters. | * Strip out line feeds and quote characters. | ||
- | * If there are non-printable characters before or after the name, code, last name or first name they will be removed. Any non-printable characters in the name, code, last name or first name will be replaced with an underscore (<wrap em> | + | * If there are non-printable characters before or after the name, code, last name or first name they will be removed. Any non-printable characters in the name, code, last name or first name will be replaced with an underscore (<wrap em> |
</ | </ | ||