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
import_and_export:import_prescribers [2017/07/03 21:06] rozannaimport_and_export:import_prescribers [2023/11/26 03:30] (current) Mark Glover
Line 1: Line 1:
-=====  Importing prescribers =====+{{indexmenu_n>40}} 
 +====== 17.04. Importing prescribers ======
  
 +<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%> <WRAP center round info 60%>
Line 13: Line 17:
  
 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 ^ Unique code for each prescriber ^ + Column   Contents  ^  Unique code for each prescriber  
-Column 2 | Last name | +A  | Code  | Unique code for each prescriber 
-Column 3 | First name | +| B  | Last name  | The presciber's last name  
-Column 4 | Initials - these will appear on patient labels | +C  | First name  | The presciber's first name  
-Column 5 | Registration code | +D  | Initials  | The prescriber's initials. These will appear on patient labels  
-Column 6 | Category | +E  | Registration code  | The prescriber's registration code  
-<HTML></div></HTML>+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:
  
 {{ :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>
  
  
Line 31: Line 41:
  
 {{ :import_and_export:import_prescbr_preview.png?500 }} {{ :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|Importing Customers, Suppliers, Patients]]     Next: [[import_and_export:import_abbrev|Importing abbreviations]]//+\\ 
 +\\ 
 +|  //  Previous:  **[[import_and_export:importing_names]]** | | Next: **[[import_and_export:import_abbrev]]** //  |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2017/07/03 21:06
  • by rozanna