Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
import_and_export:import_prescribers [2011/06/05 12:32] – Craig Drown | import_and_export:import_prescribers [2023/08/22 07:41] – [17.04. Importing prescribers] Gary Willetts | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Importing prescribers ===== | + | {{indexmenu_n> |
- | {{entry> | + | ====== 17.04. |
- | + | <WRAP center round info 60%> | |
- | <note> Applicable in Dispensary mode only</note> | + | Applicable in Dispensary mode only |
+ | </WRAP> | ||
From the //File// menu, choose //Import Prescribers//, | From the //File// menu, choose //Import Prescribers//, | ||
Line 11: | Line 12: | ||
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 | + | | 1 | A | Code | Unique code for each prescriber | |
- | | Column | + | | 2 | B | Last name | The presciber' |
- | | Column | + | | 3 | C | First name | The presciber' |
- | | Column | + | | 4 | D | Initials |
- | | Column | + | | 5 | E | Registration |
- | < | + | | 6 | F | Category | The category the presciber belongs to | |
Your tab delimited spreadsheet file would appear something like this: | Your tab delimited spreadsheet file would appear something like this: | ||
Line 25: | Line 25: | ||
{{ : | {{ : | ||
+ | <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 | ||
---- | ---- | ||