Importing Patient Demographics from Excel (paper charting previously)

Importing Patient Demographics from Excel (paper charting previously)

 \n

If you currently have your patient demographics in electronic form, we can import the data into ICANotes for you at no extra charge.

\n

 

\n

****IMPORTANT****

\n

ICANotes cannot be held responsible for the accuracy of the data you provide. Please ensure that all records are 100% accurate before submitting the file to ICANotes or be prepared to have your staff adjust the information record by record within the ICANotes system.

\n

 

\n

Please create an Excel spreadsheet (*.xls) named “Patient Demographics.xls\"

\n

 

\n

The following fields are REQUIRED in your spreadsheet:

\n

 

\n

First Name       should not contain salutation or initials

\n

Last Name       should not contain title or initials

\n

Patient ID        can be any format as long as it is unique

\n

Gender            M, F, O or Male, Female, Other or Man, Woman or Boy, Girl, Person

\n

DOB                1/31/2001 or 1/31/01 or 01/31/2001 or 01/31/01 (if providing a DOB for each patient is a hardship, we will speak to our developers about how to address).

\n

 

\n

 

\n

Fields listed at the base of this message (and found in our template) are optional and may also be imported. Please download our template linked immediately below.

\n

 

\n

Click HERE to download required Spreadsheet Template file with field headings appropriately configured.

\n

 

\n

Submit your file by uploading it to https://upload.icanotes.com/filedrop  After you upload your file to the Dropbox, please send an email notification to ticket@icanotes.com to let us know the file is there, including the following information:

\n
    \n
  • Your ICANotes username
    • \n
  • The name of the file you uploaded
    • \n
  • Contact person name, email address, and phone number in case we have questions about your data file
    • \n
  • Desired date for import (must be minimum 2 business days after file submission): mm/dd/yyyy
    • \n
\n

Our team will review your spreadsheet and contact you if we have any questions. You will receive an email notification as soon as your import is complete.

\n

 

\n

Please note that all imports are final.

\n

 

\n

The following fields are OPTIONAL and may also be imported.  There are no restrictions unless otherwise noted. Please review your spreadsheet before submission and make sure to title your columns exactly as you see them listed:

\n

 

\n

MiddleName           

\n

SocialSecurityNumber

\n

DateEntered            1/31/2001 or 1/31/01 or 01/31/2001 or 01/31/01

\n

Address                  

\n

City                       

\n

<span style=\"font-family: arial, helvetica, sans-serif

    • Related Articles

    • Importing Patient Demographics

      Index Sections ****IMPORTANT**** Please note that all imports are final. If you have patient demographics in electronic form, ICANotes will import the data for 50+ patients for you at no extra charge. If your caseload contains demographic data for ...

    • Custom Fields in Demographics

      Index Sections Frequently Asked Questions Q: What happens if I change the label of a Custom Field? A new Custom Fields option has been added to patient Demographics. This option allows for the creation of five custom fields that can be labeled ...

    • Data Export and Demographics Import

      1. The current owner of the data will need to run a full Clinical/Demographic Search report for all active, inactive and pending patients. Go to the Reports drop-down menu and select Clinical/Demographic Search. 2. On the Clinical/Demographic Search ...

    • Name Change Dialogue in Demographics

      1. After you select a patient from the Chart Room you are brought to the patient's Chart Face. 2. Go to the Demographics tab. 3. Change the name of the patient as needed. Then click the Continue button on the top or bottom. 4. If there is a note ...

    • Assigning Roles From The Demographics

      This knowledge base article covers how to assign providers to a patient's chart and assign the provider's roles. This is an example: 1. Go to the Chart Face and then Demographics (or create a new patient if needed). New Patient with no assigned ...