Fee List Recreation - Accidental Deletion

Situation
I accidentally deleted the Fee List. I have a backup I could return to, but I would lose more time than is ideal. I don’t need to retrieve the entries I had - they were simple and can be recreated manually in GUI. I just get the original Fee List back would be fine. I can see the fee_list_options table still contains the entries, but i cannot figure out how to get the entries back into OpenEMR.

I have installed phpMyAdmin and reviewed the DB to see if I could solve recreating the list, but the logs are encrypted and I am a relative novice. Any assistance that can be offered will be much appreciated.

OpenEMR Version
7.0.4

Browser:
I’m using: Chrome

Operating System
I’m using: macOS 26.2

Search
Did you search the forum for similar questions?

Yes, I found some info re: recreating DB entries related to LBF, but not the specific entries needed for Fee List.

Logs
Did you check the logs?
Was there anything pertinent in them?

Yes, but they are encrypted, so not much help.

Hi @smithad150 Welcome to the community!

I am not a dev though I do have some old- school coding experience. At first I thought the solution to your problem was trivial: just make another fee list. But then checking more closely I see that the different lists are in fact multiple different forms that have their own special- function columns, depending on the list you select in the dropdown.

Looks to me that you’re going to have to dive into the code of the list manager and see where it gets the special- purpose components of the form it uses to build the fee list.

Also look at the ‘delete list’ button and see what happens when you delete the list. If that also deletes the form, you’re going to have to get that form from somewhere.

As I say, I’m not a dev so I could be off base. But it’s somewhere to start your investigations.

Best of luck!

  • Harley
1 Like

Nice tips @htuck. There’s another way that discovered recently:

  1. create a service category:
  2. add a code
  3. see the option appear in the fee sheet: