Sidebar

How can i convert a csv with multiple rows into multiple HL7 message for each row?

0 votes
167 views
asked Apr 20, 2021 by deepthi-a-5184 (240 points)
Here is my source csv file: "Patient ID","Patient First Name","Patient Last Name","Patient DOB","Patient Gender","Patient Address Line1","Patient Address Line2","Patient City","Patient State","Patient Zip Code","Patient Home Phone","Patient Email Address","Primary Insurance Policy Company Name","Primary Insurance Policy Number","Primary Insurance Policy Group Number" "1","test","abc","19800819","F","flat 1 road no A","xyz colony","Hyderabad","Telangana","500097","987-889-5858","test.abc@cognizant.com","","","" "2","test","def","19800819","F","flat 1 road no A","xyz colony","Hyderabad","Telangana","500097","987-889-5858","test.abc@cognizant.com","","","" "3","test","ghi","19800819","F","flat 1 road no A","xyz colony","Hyderabad","Telangana","500097","987-889-5858","test.abc@cognizant.com","","",""

1 Answer

0 votes
Please see the following KB article, which addresses a similar situation:

https://www.qvera.com/kb/index.php/610/how-to-import-a-csv-and-generate-multiple-hl7-messages?show=610#q610
answered Apr 20, 2021 by jon-t-7005 (5,410 points)
...