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 [2011/05/22 02:48] – john | import_and_export:import_prescribers [2023/11/26 03:30] (current) – Mark Glover | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Importing prescribers ===== | + | {{indexmenu_n> |
+ | ====== 17.04. | ||
- | // Note: Applicable in Dispensary mode only// | + | <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> | ||
+ | |||
+ | <WRAP center round info 60%> | ||
+ | Applicable in Dispensary mode only | ||
+ | </WRAP> | ||
From the //File// menu, choose //Import Prescribers//, | From the //File// menu, choose //Import Prescribers//, | ||
Line 10: | 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: | ||
Line 24: | Line 30: | ||
{{ : | {{ : | ||
+ | <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. | ||
+ | |||
+ | {{: | ||
+ | |||
+ | </ | ||
+ | |||
+ | |||
+ | Choose import options from the preview window and click **OK** to begin import. | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | <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: | ||
---- struct data ---- | ---- struct data ---- | ||
+ | pagestatus.status | ||
---- | ---- | ||