We have an Excel template (Loading Quote Items as Products into Salesforce [url removed, login to view]) that needs to be populated from one of 2 sources.
1. [url removed, login to view]
2. [url removed, login to view]
We need a button within the Excel template which will enable the user to select which of the 2 Suppliers we are loading data from.
Then a Select File Dialog box will be displayed (limited to CSV for Supplier 1; XLS for Supplier 2)
When the file is selected the application should populate data into the Data sheet of the Template (see the Mapping Tabs for examples of where data is to be mapped to plus a few additional notes).