Hello I'm looking to generate json FHIR messages based off a patient demographic CSV extract. Essentially the data I receive will be an excel file with columns containing patient demographics (i.e. first name, last name, address, DOB, etc). I need to go line by line through the excel file and generate a json FHIR message. I'm using excel VBA and would like to create a macro to do this.
Here's what I've done so far and I'm certain there must be an easier way. I've created a json FHIR message template and basically perform a find/replace.
Template would contain:
{
"use": "official",
"family": "zLASTNAME",
"given": [
"zFIRSTNAME"
]
}
And then when comes to the lastname and firstname column in the excel file. I would find/replace zLASTNAME and zFIRSTNAME. I know this is by far the wrong way to do it but I don't know what the best practice is for this case.
Any help would be much appreciated!
