Addresses File
It lets you add adresses in Medisoft using input in the form of CSV file.
Note that row 1 is not used. This row can contain column names or a comment.
Key for Type column:
Text = alpha characters (e.g. a, b, c)
Numeric = numbers, whole and fractions e.g. (20.00,-7.50,-4,65)
Date = a YYYYMMDD format or MM/DD/YYYY (e.g. 20020625 or 06/25/2002).
| See notes below | Column# | Data Element | Data Type | Max. Length | Remark |
| ** | 1 | Address Code | Text | 9 | |
| ** | 2 | Full Title | Text | 40 | |
| 3 | Last Name | Text | 20 | ||
| 4 | First Name | Text | 20 | ||
| 5 | Middle Initial | Text | 1 | ||
| * | 6 | Address Line 1 | Text | 39 | |
| * | 7 | Address Line 2 | Text | 39 | |
| * | 8 | City | Text | 25 | |
| * | 9 | State | Text | 2 | |
| * | 10 | Zip | Text | 10 | |
| * | 11 | Phone | Numeric | 14 | |
| * | 12 | Extension | Numeric | 5 | |
| * | 13 | FAX number | Numeric | 14 | Telephone numbers must not use any brackets or dashes e.g. 8015620111 |
| 14 | Insurance Code 1 | Text | 13 | ||
| 15 | Insurance Code 2 | Text | 13 | ||
| ** | 16 | Address Type | Text | 1 | A=Attorney E=Employee F=Facility R=Referring Physician O=Other |
Note:
* field improves quality of imported data, but can be left empty
** field requires a value