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:import_prescribers [2017/07/03 21:06] – rozanna | import_and_export:import_prescribers [2023/11/26 03:30] (current) – Mark Glover | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Importing prescribers ===== | + | {{indexmenu_n> |
+ | ====== 17.04. | ||
+ | <WRAP center round important 60%> | ||
+ | You need to be logged in to the store (dispensary) where the prescribers will prescribe before carrying out these steps. | ||
+ | </ | ||
<WRAP center round info 60%> | <WRAP center round info 60%> | ||
Line 13: | Line 17: | ||
Your list should be in the format of a 6-column spreadsheet, | Your list should be in the format of a 6-column spreadsheet, | ||
- | < | ||
- | ^ Column | + | ^ Column |
- | | Column 2 | Last name | | + | | A | Code | Unique code for each prescriber |
- | | Column 3 | First name | | + | | B |
- | | Column 4 | Initials | + | | C |
- | | Column 5 | Registration code | | + | | D |
- | | Column 6 | Category | | + | | E |
- | < | + | | F |
Your tab delimited spreadsheet file would appear something like this: | Your tab delimited spreadsheet file would appear something like this: | ||
{{ : | {{ : | ||
+ | |||
+ | <WRAP center round important 60%> | ||
+ | If the file you are importing has non-English characters (for example, accents), it is important to make sure the file is saved with a UTF-8 charset. You can check this by opening the file in Notepad (for Windows). When you save the file, you can choose the Charset used, as shown in the image below. | ||
+ | |||
+ | {{: | ||
+ | |||
+ | </ | ||
Line 31: | Line 41: | ||
{{ : | {{ : | ||
+ | |||
+ | <WRAP info center round 60%> | ||
+ | If there are non-printable characters before or after the first name, last name or code they will be removed. Any non-printable characters in the first name, last name or code will be replaced with an underscore (<wrap em> | ||
+ | </ | ||
- | // Previous: [[import_and_export: | + | \\ |
+ | \\ | ||
+ | | | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||