How to extract test data from blue button to spreadsheet [closed]

asked 2014-02-23 01:03:39 +0200

PatMedDatOrgz gravatar image

updated 2020-08-02 17:10:05 +0200

Alex Kemp gravatar image

I am a Hepatitis C patient who is able to download my health info and blood test results from the VA xxxxxxx.bluebutton MAJOR edit to add more detail 9;30 PM EST 2-23

I would like a way to auto import certain test data in to a spreadsheet to view, create graphs and apply math formulas. Windows 7 ultimate 64bit LibreOffice 4.15

Partial text version of the blue button file as a text file with personal info redacted located

Partial description of what you will find on that file test are separated by long ===line test type, who ordered, date are between long ===line and long --- If more than 1 test name next is separated by short line--. If there are comments then there is a long ---line before the comments and the next long ===line that separates this from the next test type, who ordered, date


This area has type of test who ordered *date etc* (The date is always extracted from here for all test listed between the top ====line and the next ====line. There may be 1, 2 or more listed)

long ---

This area has *test name, results, reference range and other info* Result: 36.4 High - will show high or low if abnormal after the numerical number

extract test name: results (high, low or empty) Ref range date from above If there are more test names listed after then get the same info under the same type who ordered and date then short line-- separates etc.

Next ===== starts next test type and or date (at least 1 of these will be different)

I would like a way to auto import at least as much as I can to display a spreadsheet time line (Q1 most important ===line separates test type from another test type

test --------------- date X ----- date X reference range

1st test name --- result H --- result H

2nd test name --- result L--- result N

3rd test name --- result N--- result N

Ability to plot graphs of results over time display Red if high black if normal or purple if low. Could have another column next to results to show H for High L for Low and N for normal(empty) reference range could a column at the far right. this specific format just gives an idea of what I would like ... (more)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-19 11:53:18.629322


It could be helpful to provide information on "blue button".

ROSt52 gravatar imageROSt52 ( 2014-02-23 04:23:20 +0200 )edit

I provide the link that explains blue button and also posted a dropbox link for a sample of the download blue button format as text.

PatMedDatOrgz gravatar imagePatMedDatOrgz ( 2014-02-24 02:42:02 +0200 )edit

Hi @PatMedDatOrgz, is it the only format to download the data?, not impossible to do with the sample, but not easy.

m.a.riosv gravatar imagem.a.riosv ( 2014-02-24 03:34:07 +0200 )edit