To support bulk import data, we created a console application with an ASMX service to communicate with web application. The console application would scan an excel file for the bulk data, and then through the service it would insert records into the server database.This is an automated process that only needs to run whenever we they needed to import bulk record.
For offline support, we have created a WPF application, through which we performed the offline delivery and then synced the delivery data by ASMX services when be online.
This was a more efficient way to handle records for clinics. We reduced the functionality without affecting other functions that were critical to the clinic process.