.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Using Sharepoint to accept User Workbook Input

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :SharePoint

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....)

  1. User posts a wor

    View Complete Post

More Related Resource Links

Programmatically creating a SharePoint Site based on user input


I am working on developing a “Create Website Wizard” for SharePoint 2007 that would do the following (I am simplifying a little for the sake of this post):


1.      Take user input as follows:



Product Code:

Category (I, II, III):

The category will be a choice field (radio buttons or a dropdown)

Using a sharepoint list to populate a form then capture user input


Hi.  New to this forum but looks like a great resource.  I am using MOSS2007, Infopath 2007 and Nintex workflow 2007.

I have a form that will act as a report for each of the operational sites in my company.  Each site receives freight movements on a daily basis and these are on a schedule; I am trying to record the variances to that schedule.  What I have attempted to do is the following:

  • Create a sharepoint list that contains each of the scheduled arrivals per site.
  • Connect to this list in Infopath as a secodary data source.
  • Drop this in to the form as a repeating table.
  • Filter the list of arrivals by using the conditional formatting control on the section, bound to a drop-list where the user specifies the facility/site.

What I am trying to do is present these arrivals and have the user enter an "actual" arrival time next to each, then store the results on submit.  I therefore need to know two things, 1) how to capture an "actual" value for each row in the repeating table (at the moment this is pulled in as an empty field from the list) and 2) how to store the data on submit so it is there when the form is re-opened.

I hope this makes sense, happy to give you any further information that may be required.

Thanks, Matt

Making a SharePoint list as readonly upon a user input.



I have a requirement here for which I am using a custom list. I have status field in the list and the business wants the list to be read only once the status has been changed to 'Closed'. Is that possible at all if yes how can I make all other list items as non editable once the status is closed? Please help me in doing this.

Thanks in advance.

PS: Moderator, if you think this question should belong to some other thread please move it to the correct one. Thanks.

Choosing Between a User Control or Web Part for SharePoint

SharePoint will only display Web Parts on a page. However, there are publicly available shims that allow you to write user controls and have them be displayed as a Web Part. From SharePoint's point of view, the shim is a Web Part. From the point of view of the user control, the shim is simply a control in .NET that is including the user control

Creating Sites/Lists/List Items under Current User Context in SharePoint By Using SPUserToken

Usually we do this by performing the action under RunWithElevatedPrivileges method and updating the listitem using SPListItem.SystemUpdate() method (see here). but this approach has its own flaws like (RunWithElevatedPrivileges will run under system account, we cannot use SystemUpdate for SPSite,SPWeb,SPList, since it runs under system we will "CreatedBy" by as SystemAccount).

How to track the changes of user contacts(colleagues) by using SharePoint API

We might have seen colleague tracker web part which keep tracks the changes made in our contacts/colleagues details like profile/lists/sites. The same tracking mechanism can be implemented by using MOSS API in any custom web part/ web control/ feature/web service...

UserProfile.GetColleagueChanges is the method which returns all changes happened with the contacts, this method also accepts a Query (UserProfileChangeQuery) where we can specify different parameters to filter the changes

Configuring User Profiles in SharePoint Server 2010

Note: I've added the necessary links relating to SharePoint Server 2010 prerequisites, along with instructions for configuring the user profile synchronization service, at the end of this

InfoPath: Turn User Input into XML with Custom Forms Using Office InfoPath 2003


Office InfoPath 2003 is a new Microsoft Office product that lets you design your own data collection forms that, when submitted, turn the user-entered data into XML for any XML-supporting process to use. With an InfoPath solution in place, you can convert all those commonly used paper forms into Microsoft Office-based forms and end the cycle of handwriting and reentering data into your systems. Today organizations are beginning to realize the value of the mountains of data they collect every day, how hard it is to access it, and are striving to mine it effectively. InfoPath will aid in the design of effective data collection systems. Here the author shows you how to get started.

Aaron Skonnard

MSDN Magazine September 2003

Unable to search Custom User Property Created in User Profiles in SharePoint 2010


Hi ,

I have created a custom user property,and created metadata property and added mapping to it, still i m not able to Search in People,Please advise

create current user filter in sharepoint designer or wss3

hi, how can i create a current user filter in sharepoint designer?

How to show previouse user comments on the task form of a user in sharepoint Designer

I am using sharepoint designer for designing workflow. I have 4 steps. on each step a user write some comments for the next user. now I want to show all those comments on task form for the current user to whom the task has been assigned.

Developer Training: User Interfaces and Lists in SharePoint 2010

Learn about the new user experience in SharePoint 2010 and how you can use the new UI in your customizations. This training module also discusses improvements in list handling, including list relationships and new form-rending options.

Chapter 3: The SharePoint User Experience, Part 1 (Professional SharePoint 2007 Development)

Learn how SharePoint 2007 takes advantage of many ASP.NET 2.0 features. This means that you can build ASP.NET web pages and blend them into a SharePoint site without a lot of rework.

Chapter 3: The SharePoint User Experience, Part 2 (Professional SharePoint 2007 Development)

Get an introduction to the out-of-the-box features SharePoint provides. Then learn how to use these features to "develop" a site from within the user interface as well as how to add to code like CAML to the other user interface elements.

Quick Note: Working with the SharePoint 2010 Ribbon User Interface

Learn to extend the Microsoft SharePoint 2010 ribbon by adding a custom button that executes server-side code.

Video: Developing with the New User Interface Features in SharePoint 2010

This SharePoint Conference video shows how to customize the Ribbon without taking your users out of the look and feel of Microsoft SharePoint 2010. (Length: 01:02:38)

Video: The SharePoint 2010 Fluent User Interface

Learn how your applications can extend the ribbon interface, which is now integrated into the SharePoint 2010 user experience, to include new menu items and options both on a global level and based on the context of the user. (Length: 9:04)
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend