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

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

Can I create several steps to be run on a SharePoint list as a task to run on a daily basis?

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

We have a manual process that we do on a SharePoint list to export data from SharePoint to a spreadsheet that can then be used by non SharePoint programs.  I'd like to be able to automate this process so that it can be scheduled as a Task to run on a daily basis.   Not sure if a workflow can do what I'd like it to.  I have SharePoint Designer 2007 as well.

Here are the steps:

1. Load a particular View of a SharePoint List

2. From the view's Action menu, "Open with Access"

3. Save the resulting Access database as a file to a specific Folder on the computer hosting SharePoint

This would be run as a Task on the computer hosting SharePoint.

View Complete Post

More Related Resource Links

Can we create sharepoint task list which contain buttons in fields ?

Can we create sharepoint task list which contain buttons in fields in one column?

How to Create a Task List in SharePoint 2013?

Tasks lists in SharePoint are used for capturing actions, to-dos, and deadlines. Whenever multiple people are working together to deliver on time a joint project or initiative you need some way of effectively communicating what everyone is supposed to do. You also track what everyone has (or has not) done in order to manage the project properly.

Quick Note: Create Custom List Definitions in SharePoint 2010

In this exercise, you create a custom list definition in Microsoft SharePoint 2010 and then create an event receiver that is triggered when the list is used.

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

create new custom list form in sharepoint designer and edit in browser

hi, i have created a new list using sharepoint designer 2007. now i inserted a custom list form to modify some field and add new ones. when i finished i will tight my new custom list to the custom form. what i want to know is. i see the status field in my new form. and i only want the status field to appear in the edit form for the one that has the permission to edit the status. then i tought of open the list in my browser and go to the list settings. but what i notice is i dont see my fields i have modified in sharepiont designer in the columns section i only see the ones from the existing list. my question is how can i hide the status field in the new item form that it only show in the edit form. and how do i get my new form in the column section so the end user can add more fields if they want without using sharepointdesigner thnx

Sharepoint 2007 Task List problems

I have encountered some problems with the task list web part and I wondered if anyone could suggest any solutions?   So heres what is happening. I create a new task list and check the box to have it send out emails when tasks are assigned. I create a new task, assign it to myself and I get an email, great! Then I see that everyone elses tasks are viewable in sharepoint and in outlook 2007 when I sync the webpart with that, which is no good. Okay no problem I'll make a change in the advanced settings of the webpart so 'only their own' is set for read and edit. Sounds good. However now when I create a new task and assign it to myself (just like before) I don't get an email (and nor does anyone else). (Incidently I tried reversing the item level permissions but still no emails). A second problem seems to be that people now also don't see tasks in sharepoint that have been created by someone else and assigned to them. Useful!   Any help would be much appreciated. More info can be provided as needed.

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?

Create a custom search for searcing contents of a sharepoint list

Hi, I am new to sharepoint, i am working on a assignment to create a custom search for a specific sharepoint list . I would like to implement a search by multiple filter criteria's. I am using sharepoint 2007 and with no administrator privileges to the sharepoint server. Can someone guide me with this request. Thanks,  

How to stop the mail trigger while editing a task list item in sharepoint 2007

I have a requirement to stop the mail trigger while editing a task list item in SharePoint 2007. When I am creating a task the mail is sending to the “Assigned to” Properly. But when I am editing the same task item again a mail is sent to the Assigned to user which I want to stop. Is there any out of box feature / settings to stop this mail trigger while editing. Early response is much appreciated.Deeptyranjan

[Sharepoint 2007] How to send a task from calendar on a weekly basis ?

Hi all, I have created a sharepoint calendar. I would like to create a task every week. This task should show the details of a meeting. Also a document should be uploaded every week to this meeting by the adminsitrator.   Every week a user should receive a new weekly remainder in the tasks list at 9 am.   I have been using the workflow but it is sending just one task for all the series. I would like to trigger a new task every week based on the calendar.   How can i achieve that ?   Thanks

create task edit form issues for sharepoint 2010 workflow using visual studio 2010

I use infopath 2007 created a task edit form and I use VS 2010 to create a sequential workflow.I want to use the custom tash edit form in the workflow.The problem I got is the InfoPath form doesn't get deployed to sharepoint. I'm able to upload the infopath form to sharepoint though central admin app. here is the element.xml :<Elements xmlns="http://schemas.microsoft.com/sharepoint/">  <Workflow     Name="WorkflowProject4 - Workflow1"     Description="My SharePoint Workflow"     Id="e6aa6cdb-667f-456a-b216-7639a1dcd3c7"     CodeBesideClass="WorkflowProject4.Workflow1.Workflow1"     CodeBesideAssembly="$assemblyname$">    <Categories/>    <MetaData>      <AssociationCategories>List</AssociationCategories>            <Task0_FormURN>urn:schemas-microsoft-com:office:infopath:TaskForm:-myXSD-2009-12-10T22-33-23</Task0_FormURN>      <StatusPageUrl>_layouts/WrkStat.aspx</StatusPageUrl>    </MetaData>  </Workflow></Elements>and here is the feature1.template.xml<Feature xmlns="http://schemas.microsoft.com/sharepoint/">  <Properties>    <Property Key="GloballyAvailable" Value="true" />    <Property Key="RegisterForms" Value="*.xsn"/>  </Properties></Feature>anything

Create List Sharepoint Client Object Model Access Denied



I am trying to create a silverlight application by making use of the SharePoint 2010 Client Object Model using the following code:

private void CreateList(object sender, ClientRequestFailedEventArgs e)
  ClientContext ctx = new ClientContext("http://server");
  ListCreationInformation lc = new ListCreationInformation();
  lc.Title = "FlexiTime";
  lc.Description = "";
  lc.TemplateType = (int)ListTemplateType.GenericList;
  List newList = ctx.Web.Lists.Add(lc);
  System.Threading.ThreadPool.QueueUserWorkItem(new WaitCallback(CreateListCallback), ctx);

private void CreateListCallback(object s)
  var context = (ClientContext)s;  

The error I receive is as follows:


Create Lookup Site Column based on External List (SharePoint 2010)


I've got an External List and I want to create a Site Column, which is Lookup to a column in my external list. If I tick any of the columns in 'Add a column to show each of these additional fields' and click OK i get the following error message:

[NullReferenceException: Object reference not set to an instance of an object.]
  Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() +58
  Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) +809
  Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) +315
  Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) +240
  Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) +759
  Microsoft.SharePoint.SPFieldCollection.Add(SPField field) +61
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() +513
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) +46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +139

How to create global list in SharePoint 2010


Hello All,

I want to create global list which can be acessible to all the sub-sites in the SharePoint



----- Site 1

------------Site 1.1

------ Site 2

-------------Site 2.1

And so on,

I want to create list in which I can insert an item from any of the site from my site collection.

sharepoint 2010 task list to outlook 2007


I've connected to outlook a task list of sharepoint 2010.

Once connected I can see  only the activities assigned to one single user. All the activities assigned to multiple users are not reported

Does anyone know how to solve this bug?

Many thanks



Sharepoint 2010 Cannot create new List using saved List template

In Sharepoint Server 2010 Cannot create new List using saved List template. I have saved multiple list templates in the template gallery, but when I click on site actions -> More options. I do not see the list templates that are in the template gallery.

How to create custom control in .net which can retrive data from sharepoint list and redirect to sit


Hi help me!

I am strugling this problem!

My requirement is I need to create a custom control which need to retrive data from sharepoint list, The list contain some sites information like Title, url, Scope my requirement is i need to display sites Title in my custom control and when i click on title (site name) in custom control it need to be redirect to that site and whenever list data updated automaticaly custom control data also need to be apdated automatically .

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