search

serenity-health / roadmap

Public roadmap for development of Serenity's apps reported by our community of users
0 stars 1 forks source link

feature/bulk upload healthcare services #15

Open chris-dare opened 2 years ago

chris-dare commented 2 years ago

Tell us about your request! The bulk upload feature needs to be updated to support robust upload of diagnostic services

Which app does this concern? Provider portal

Describe the solution you'd like

  1. Read excel sheet with pandas
  2. Find Service Information sheet
  3. Apply janitorial processes on column names and row data. See pyjanitor for details
  4. Isolate and ignore records with invalid data
  5. Repeat steps 2 - 4 for price tiers
  6. Isolate and ignore services that do not have at least one new (from the sheet) or existing (from db) price tier
  7. Create services and price tiers
  8. Create an excel sheet with the list of services and their upload comments
  9. Return the file This file can be emailed to the provider admin as a summary of the bulk upload operation. Overtime, we can also build this into the app as a self-admin feature

Describe alternatives you've considered Services can currently be created or updated via the application

Additional context N/A