I'm looking for guidance here. I believe it makes sense for me to set up a sharepoint site to accept users' workbooks to be used as input to my (currently Access) database. I have a set of users who periodically submit a workbook to my team that contains
updates to third party pricing in my application. I want to standardize the process and automate it. Basically, my app opens the workbook, validates its format and content, then proceeds to post the updates to a (currently Access 2007) table using a fairly
complex program (lots of data validation, business rules, etc.), puts notes about each row's status (system updated successfully, duplicate entry, invalid numbers, etc.) directly back into the workbook. The user saves the workbook with a slightly revised name,
then sends it back to the submitter.
It seem to me I should be able to create a Sharepoint-centric way to do this. A user adds a new workbook to a SP library. SP sees the new entry, somehow processes it, then posts the revised workbook back to the site and notifies all the appropriate parties
about the results of the run.
What's the strategy? Can I avoid user intervention? Do I need to rewrite the programs in C# or VB.NET and trigger them from some Sharepoint process? Help me with some ideas where to go. Here's my thought (though I am not sure how to implement....)
- User posts a wor
View Complete Post