troubleshooting Question
Use sharepoint to collect data from internal users and external vendor
paultran00
asked on
asked on
Here’s what I am trying to accomplish:
1a. Internal (REQUESTOR) user submits a form and I need to save the data into SQL SERVER. (I was thinking of using Sharepoint).
SQL SERVER needs to extract the record (and a unique key field) that the REQUESTOR submitted and export to an Excel form (populate the top half with values from SQL) then send that Excel form (the vendor needs to fill out the bottom of of the form) to an external vendor via email.
1b. NOTE: When a form is submitted into Sharepoint's SQL DATABASE, I want a copy of the record saved to my SQL database. How do we do this?
2. The vendor (RESPONDER) fills out the Excel form and emails back to my mailbox.
I want to take the Excel that I received via email and update that same record (unique key field) in SQL SERVER via sharepoint.
I only have a SQL SERVER 2008 R2 so I can create a table to store the data received. I have Sharepoint 2007.
Please provide a step-by-step how to accomplish these items.
Thanks.
1a. Internal (REQUESTOR) user submits a form and I need to save the data into SQL SERVER. (I was thinking of using Sharepoint).
SQL SERVER needs to extract the record (and a unique key field) that the REQUESTOR submitted and export to an Excel form (populate the top half with values from SQL) then send that Excel form (the vendor needs to fill out the bottom of of the form) to an external vendor via email.
1b. NOTE: When a form is submitted into Sharepoint's SQL DATABASE, I want a copy of the record saved to my SQL database. How do we do this?
2. The vendor (RESPONDER) fills out the Excel form and emails back to my mailbox.
I want to take the Excel that I received via email and update that same record (unique key field) in SQL SERVER via sharepoint.
I only have a SQL SERVER 2008 R2 so I can create a table to store the data received. I have Sharepoint 2007.
Please provide a step-by-step how to accomplish these items.
Thanks.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.