Import records with batch file
New records can be add automatically via batch import. It is performed from menu section Setings - Details - specify laboratory. Permissions for batch import are needed.
The batch import must meet the following conditions:
- The file extension is txt or csv.
- The file encoding is UTF-8 without BOM.
- The first row contains a header with the identification of the imported parameters.
- The column separator is a comma. If a comma exists within a text, it should be enclosed in quotation marks.
- Decimal numbers are separated by a dot.
- Dates are in the format DD/MM/YYYY.
The following parameters can be used for patient identification:
| firstName | name | text |
| lastName | surname | text |
| sex | sex | M - male F - female |
| address | adress | text |
| personalID | personal identification number | 700101/1111 |
| text@email.cz | ||
| telephone | telephone number | (+420)731111111 |
| healthInsurance | health insurance company | Name of health insurance company |
| city | city | Brno |
| postalCode | postal code | 60100 |
| birthDate | date of birth | 08/01/2012 |
Identification of other form parameters
The identification of other parameters on the form can be found in the data export to XLSX. An example of some parameters is shown in the image.
Before granting parameter a number, it is necessary to insert the form ID with an underscore in which the parameter is located. The form ID can be obtained by selecting Setings - Details - specify laborary (6) from the menu. IDs of forms (7) are displayed from the CRF templates tab section (6). An example for parameter number for import is form19_param18584.
Example of batch import file:
