This is an old revision of the document!
Import and Export Patient Data
Data gets exported to the following formats:
NOAH CSV format
NOAH CSV File field names:
Field Number | Field Name | Notes |
---|---|---|
1 | Client No | |
2 | Create Date | |
3 | Created By | |
4 | First Name | |
5 | Last Name | |
6 | Middle Name | |
7 | Sex/Gender | |
8 | Birth date | |
9 | Salutation | |
10 | Title | |
11 | Address1 | |
12 | Address2 | |
13 | Address3 | |
14 | State / Province | |
15 | Zip | |
16 | City | |
17 | Home Phone | |
18 | Fax Phone | |
19 | SS number | |
20 | ||
21 | CountryCode | Noah 3.x is expecting CountryCode (not Country Code) |
22 | Language Code | |
23 | ClientGroup | Noah 3.x is expecting ClientGroup (not Client Group) |
24 | Alpha1 | |
25 | Alpha2 | |
26 | Alpha3 | |
27 | Alpha4 | |
28 | Alpha5 | |
29 | Alpha6 | |
30 | Alpha7 | |
31 | Alph8 | Noah 3.x is expecting Alph8 (not Alpha8) |
32 | Alpha9 | |
33 | Alpha10 | |
34 | Alpha12 | |
35 | Alpha13 | |
36 | Alpha14 | |
37 | Alpha15 |
- noah-export-sample.csv
Client No, Create Date, Created By, First Name, Last Name, Middle Name, Sex/Gender, Birth date, Salutation, Title, Address1, Address2, Address3, State / Province, Zip, City, Home Phone, Work Phone, Fax Phone, SS number, E-Mail, CountryCode, Language Code, ClientGroup, Alpha1, Alpha2, Alpha3, Alpha4, Alpha5, Alpha6, Alpha7, Alph8, Alpha9, Alpha10, Alpha11, Alpha12, Alpha13, Alpha14, Alpha15
Generic CSV format
Generic CSV File field names:
Field Number | Field Name | Notes |
---|---|---|
1 | Patient Number | |
2 | Patient ID | |
3 | First Name | |
4 | Last Name | |
5 | Gender | |
6 | Birthdate | |
7 | Address 1 | |
8 | Address 2 | |
9 | City | |
10 | State | |
11 | Zip | |
12 | Country | |
13 | ||
14 | Home Phone | |
15 | Work Phone | |
16 | Mobile Phone | |
17 | Right 250 | |
18 | Right 500 | |
19 | Right 750 | |
20 | Right 1000 | |
21 | Right 1500 | |
22 | Right 2000 | |
23 | Right 3000 | |
24 | Right 4000 | |
25 | Right 6000 | |
26 | Right 8000 | |
27 | Left 250 | |
28 | Left 500 | |
29 | Left 750 | |
30 | Left 1000 | |
31 | Left 1500 | |
32 | Left 2000 | |
33 | Left 3000 | |
34 | Left 4000 | |
35 | Left 6000 | |
36 | Left 8000 |