Data Entry
i have sharepoint 3.0 installed on a box along with sql 2005 and this site has all our reports posted to it but now i would like to be able to create a page that users can enter field data and have a button on that page to upload the data to the database. can i do that with sharepoint or does that require another website?
May 29th, 2010 9:23pm

> have a button on that page to upload the data to the database "upload" or save? If they are just entering data, and then saving to a list, then you can just create a custom list with the fields that you need. The users can then just go to the list and click New, or you can add a link to Quick Launch (or anywhere) that just takes them to the URL of the New item page. If needed, you can customize the "New" page using SharePoint Designer to add instructions or validation. And if you want to do some coding, you can create a custom Site Page to collect the data and save it to a list.Mike Smith TechTrainingNotes.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2010 9:52pm

they are entering lab data, ie...2.34, 5.34, and so on. if i create a list with the fields i need, how do i create an upload to database button? and where is the data then loaded? can i point the fields in the list to a specific database?
May 29th, 2010 10:10pm

If you create a list in SharePoint, the data is stored in the SharePoint database. Are we talking about the same database? I'm assuming you are asking about the SharePoint database. Are you asking about how to enter data in a form in SharePoint and then save to an external database? Mike Smith TechTrainingNotes.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2010 11:08pm

WSS 3.0 doesn't support this functionality out of the box. To get this functionality you will need to either A: Custom create your own functionality, a web-based infopath form, or a custom coded web part, or an editable Data Form Web Part with a SqlDataSource would be the common ways to approach this. Another approach I have used in the past where I wanted information in a SP List and a Database is an event reciever on a custom list which writes it's contents to the DB. B: Use a 3rd party solution. I'm not familiar with any of these but there is a few around if you search.
May 31st, 2010 11:39am

Yes, off course. I'm ready to do the job.Dhani palit
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2011 4:41pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics