Welcome Chris.

The easiest way to get data out of OpenVPMS is to:

1. write a JasperReport that uses an SQL query to extract the data

2. load this report as a document templates in Administation - Templates

3. run the report via Reporting - Reports and export the results as a CSV

For some background to reporting in OpenVPMS see Introduction - Reporting.

You can find sample SQL reports in the release distribution in the reports directory. All SQL reports have a report.jrxml suffix, e.g. patient list report.jrxml

An SQL query for patient visit data might look something like:

select visit.act_id, visit.activity_start_time, visit.status, item.act_id, item.arch_short_name, item_detail.name, item_detail.value
from acts visit
join participations patient on patient.arch_short_name = "participation.patient" and visit.act_id = patient.act_id and visit.arch_short_name = "act.patientClinicalEvent"
join act_relationships item_relationship on item_relationship.source_id = visit.act_id
join acts item on item_relationship.target_id = item.act_id
join act_details item_detail on item_detail.act_id = item.act_id
order by visit.activity_start_time desc

To limit that to a single patient, you can supply the patient identifier as a report parameter e.g.

select visit.act_id, visit.activity_start_time, visit.status, item.act_id, item.arch_short_name, item_detail.name, item_detail.value
from acts visit
join participations patient on patient.arch_short_name = "participation.patient" and visit.act_id = patient.act_id and visit.arch_short_name = "act.patientClinicalEvent"
join act_relationships item_relationship on item_relationship.source_id = visit.act_id
join acts item on item_relationship.target_id = item.act_id
join act_details item_detail on item_detail.act_id = item.act_id
where patient.entity_id = $P{patientId}
order by visit.activity_start_time desc

The patientId parameter can be prompted for when you run the report.

In the as-yet-unreleased 1.8 version, there is a predefined field you can use instead:

$F{OpenVPMS.patient.id}

This will constrain the query to the current selected patient in OpenVPMS. See Application Fields for more details.