Export demographics

General information about Medisoft
davidsinawi
Posts: 8
Joined: Thu Apr 07, 2011 11:33 am

Export demographics

Post by davidsinawi » Tue Oct 23, 2012 1:53 pm

Is there a way to export my patient list to an excel or csv document, to 1 row per patient?

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: Export demographics

Post by Gavin Walker » Tue Oct 23, 2012 4:04 pm

Yes, in Medisoft Advanced or higher, go to Lists -> Patients/Guarantors and Cases -> Right-Click on the Patient List -> Print Grid, then add the fields you want to export. Click OK -> Select Export Data to a CSV File -> Click Start.
Gavin Walker
Walker Tek Solutions, LLC
417-890-6777 x0
fax: 417-763-6386

davidsinawi
Posts: 8
Joined: Thu Apr 07, 2011 11:33 am

Re: Export demographics

Post by davidsinawi » Tue Oct 23, 2012 4:19 pm

Nothing is happening when I click on "Patient/Guarantors and Cases", the program doesn't respond. Any ideas?

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: Export demographics

Post by Gavin Walker » Wed Oct 24, 2012 8:18 am

That should open the Patient List window. There is a program option in Medisoft to auto-open the Patient List on start-up. If that is the case, then the window is already open and you can start by Right-Clicking on the Patient List.

davidsinawi
Posts: 8
Joined: Thu Apr 07, 2011 11:33 am

Re: Export demographics

Post by davidsinawi » Wed Oct 24, 2012 11:42 am

Awesome! Worked great, thanks for your help!

EHCS
Posts: 122
Joined: Tue Oct 02, 2012 10:34 am

Re: Export demographics

Post by EHCS » Thu Mar 07, 2013 3:35 pm

I know this is an old post, but does this also export patient balances to a CSV. I need a CSV file to import patient balances into our clients software. It uses their demographics to match up patients so I also need the demographics.

EHCS
Posts: 122
Joined: Tue Oct 02, 2012 10:34 am

Re: Export demographics

Post by EHCS » Thu Mar 07, 2013 9:41 pm

Ok I figured out how to export the file and also upload into my providers system..but one huge glitch....they will only except it if the Gender/sex field is indicated with a "F" or "m" and medisoft spells out the entire word "male" "female"...it is very counter productive to have to go into the file and retype every gender to the intial , hopefully there is a way to make medisoft do this or a really fast way to edit it in excel.

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: Export demographics

Post by Gavin Walker » Thu Mar 07, 2013 10:46 pm

I guess you found the Patient Reference Balance and Patient Remainder Balance fields? You will want to go into file maintenance and do all the recalc balances options before doing the export. Medisoft is notorious for leaving these fields calculated wrong in the database.

There are several ways to go about doing what you want to do. You could write a formula in Excel to convert Male to M and Female to F.

EHCS
Posts: 122
Joined: Tue Oct 02, 2012 10:34 am

Re: Export demographics

Post by EHCS » Sun Mar 10, 2013 2:22 am

Figured it out...thanks!

Sophiapta
Posts: 6
Joined: Thu Nov 02, 2017 8:22 am

Re: Export demographics

Post by Sophiapta » Fri Jan 12, 2018 10:15 am

Is there a way to have only recent patients printed? instead of a whole list?

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: Export demographics

Post by Gavin Walker » Fri Jan 12, 2018 8:29 pm

You'll probably need something custom for that. Maybe based on last service date.

Sophiapta
Posts: 6
Joined: Thu Nov 02, 2017 8:22 am

Re: Export demographics

Post by Sophiapta » Tue Jan 16, 2018 10:09 am

Do you know how to customize a list by any chance ?

User avatar
Gavin Walker
Posts: 4625
Joined: Wed Apr 04, 2007 10:11 pm
Location: Springfield, MO
Contact:

Re: Export demographics

Post by Gavin Walker » Tue Jan 16, 2018 10:44 pm

Yes I can. Will HL7 files work? Medisoft v21 has a utility to extract to HL7 files and you can exclude based on last seen, inactive, or deceased.

Rishel
Posts: 1
Joined: Wed Jan 10, 2018 5:24 am

Re: Export demographics

Post by Rishel » Fri Jan 19, 2018 9:29 am

Gavin Walker wrote:
Tue Jan 16, 2018 10:44 pm
Yes I can. Will HL7 files work? Medisoft v21 has a utility to extract to HL7 files and you can exclude based on last seen, inactive, or deceased.
Hi Gavin, is there an option make a custom filter or do you have to use one of those three?

Sophiapta
Posts: 6
Joined: Thu Nov 02, 2017 8:22 am

Re: Export demographics

Post by Sophiapta » Tue Feb 20, 2018 1:45 pm

I have Medisoft V19. not sure what an HL7 file is. Can you walk me through the steps?

Post Reply