import_and_export:import_prescribers

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
Last revisionBoth sides next revision
import_and_export:import_prescribers [2011/05/16 06:13] – johnimport_and_export:import_prescribers [2023/11/24 00:16] – Mark Glover
Line 1: Line 1:
-=====  Importing prescribers =====+{{indexmenu_n>40}} 
 +====== 17.04. Importing prescribers ======
  
-// 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//, and the //Import alert// window is displayed. 
 + 
 +{{ :import_and_export:import_alert.png?350 }}
  
 You may import a list of prescribers who have the authority to prescribe medicines. You may import a list of prescribers who have the authority to prescribe medicines.
  
 Your list should be in the format of a 6-column spreadsheet, saved as a tab delimited file. The columns should be in the following order: Your list should be in the format of a 6-column spreadsheet, saved as a tab delimited file. The columns should be in the following order:
-<HTML><div align="center"></HTML> 
  
-^ Column 1 ^ Unique code for each prescriber ^ +^ Column number ^ Column letter ^ Contents ^ Unique code for each prescriber ^ 
-| Column 2 | Last name | +| 1 | A | Code | Unique code for each prescriber | 
-| Column 3 | First name | +| 2 | B | Last name | The presciber's last name | 
-| Column 4 | Initials - these will appear on patient labels | +| 3 | C | First name | The presciber's first name | 
-| Column 5 | Registration code | +| 4 | D | Initials | The prescriber's initials. These will appear on patient labels | 
-| Column 6 | Category | +| 5 | E | Registration code | The prescriber's registration code | 
-<HTML></div></HTML>+| 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 20: Line 30:
 {{ :import_and_export:import_prescbr.png?500 }} {{ :import_and_export:import_prescbr.png?500 }}
  
 +<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.  
 +
 +{{:import_and_export:pasted:20201216-023239.png}}
 +
 +</WRAP>
 +
 +
 +Choose import options from the preview window and click **OK** to begin import.
 +
 +{{ :import_and_export:import_prescbr_preview.png?500 }}
 +
 +<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>_</wrap>).
 +</WRAP>
 +
 +
 +\\
 +\\
 +|  //  Previous:  **[[import_and_export:importing_names]]** | | Next: **[[import_and_export:import_abbrev]]** //  |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2023/11/26 03:30
  • by Mark Glover