Differences

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

--- import_and_export:import_prescribers [2017/07/03 21:06] – rozanna
+++ import_and_export:import_prescribers [2023/11/24 00:16] – 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%>
@@ 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:
-<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:
 {{ :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 }}
+<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 ----
+pagestatus.status    :
 ----