Skip to main content

Auto-Update Master Patient List via CSV

L
Written by Luvelo Support
Updated over 2 months ago

Purpose: This guide explains how to automatically update your master patient record list via routine CSV exports.
​
One method we support is automatic import of your most recently uploaded patient list as a CSV file. This export is securely saved to a shared Dropbox folder that we configure for you, enabling automated ingestion into our systems without manual effort.


What You'll Need

  • Access to Luvelo

  • Email address for Dropbox account (we will share an invitation for a secure folder with you)

  • Scheduled task, script, or automation tool that can:

    • Query/export patient list

    • Save as .csv

    • Upload to Dropbox (via local Dropbox sync client or API)

      • We will share a private Dropbox folder with you titled:
        ​/LuveloDataExchange/[CompanyName]/

      • Make sure the Dropbox desktop sync client is installed or obtain API access credentials if you plan to upload via script.
        ​

CSV Export Template

Your patient list export should include the following:

Field Name

Mandatory

Description

HealthId

Yes

Unique health identifier

NationalId

No

Government issued identifier

FirstName

Yes

Patient first name

MiddleName

No

Patient middle name

LastName

Yes

Patient last name

DisplayName

No

Patient preferred display name

Birthdate

Yes

In format YYYY-MM-DD

Gender

Yes

Male: 1 or "M" or "male"
Female: 2 or "F" or "female"

EmailAddress

No

Email address

Phone1

Yes

Primary phone number

Phone2

No

Secondary phone number

IsActive

Yes

True/False

CreatedOn

No

Date time created in format YYYY-MM-DDThh:mm:ss

UpdatedOn

No

Date time updated in format YYYY-MM-DDThh:mm:ss

Did this answer your question?