You can import your existing patients into CloudMedico from an Excel (.xlsx) or CSV file, such as the export from your current practice program.
From the Patients list, click 'Import Patients'. The import has four steps: upload the file, match its columns, review, and complete.
Choose an Excel or CSV file of up to 50 MB. The first row holds the column names, and each row after it is one patient. CSV files can use commas or semicolons. Accented and Greek letters are read correctly whether the file is saved as UTF-8 or in the encoding many Windows programs use: Windows-1253 (Greek) for practices in Greece and Cyprus, Windows-1252 (Western European) for practices elsewhere.
CloudMedico matches each column to a field by its name, in English, Greek, Spanish, German or Italian, with or without accents, for example 'Surname', 'Επώνυμο', 'Apellidos', 'Nachname' or 'Cognome', and 'Mobile', 'Κινητό Τηλέφωνο', 'Teléfono móvil', 'Handy' or 'Cellulare'. Check each match and change any that are wrong. Name and Surname must be matched, and columns set to 'Do not import' are skipped.
Each field takes one column, except Notes. Columns that have no field of their own, such as a father's name, a place of birth, an old patient code or a medical history, can all be matched to Notes. Each is saved on its own line as 'Column name: value', and empty values are skipped. When only one column goes to Notes, its value is saved as it is.
Date of birth: Excel date cells, dates written day/month/year (15/03/1980, 15.03.1980 or 15-03-1980), and year-month-day (1980-03-15). In practices whose country is the United States, a date with slashes is read month/day/year. A date that can't be read is left empty.
Gender: Male, Female, Intersex and Other in English, Greek, Spanish, German or Italian, and the short forms M, F, W (Weiblich), H and V (hombre, varón), Α (Άρρεν), Θ and Γ, in capitals or not. In a column that uses H or V and no F, M is read as female (mujer); otherwise M is male.
Country and Nationality: the names CloudMedico uses. If some values don't match, the review step lets you download the list.
Phone numbers: in practices whose country is Cyprus (in Practice settings), an 8-digit number gets +357 in front, and a number starting with 00357, or with 357 when Excel has dropped the zeros, is saved with +357. This lets SMS reminders reach it. Other numbers, and the numbers of practices in other countries, are saved as they are in the file.
The review step shows how many patients will be imported and lists the values that couldn't be matched: genders, countries and nationalities that aren't recognised, and dates of birth that can't be read. Those fields are left empty for the patients concerned. You can fix the file and upload it again, or complete the import and fill them in later.
A patient whose ID number is already in CloudMedico is updated instead of being added twice.