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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

Can I import a databse from MS Access into a SharePoint list if it contains attachments?

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :SharePoint
 

I have 2 issues I am trying to accomplish:

Background:  I have a SharePoint list of over 8000 entries.  This list contains Text (entries) and document attachments.  The list is approximately 400MB.  I have exported the entire SharePoint list into an Access database.  I now want to import parts of the database back into seperate SharePoint lists.

Endstate:  Break the list into seperate lists.  The seperate lists will be broken down by month.  The lists need to include all content from the original list (attachements included)

Issue 1:  Can I import only selected filtered fields into SharePoint from the Access database?

Issue 2:  Can I import the selected filtered fields to include the attachements?

 




View Complete Post


More Related Resource Links

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/> [

Import Excel spreadsheet To Sharepoint List

  
Hi, I am having sharepoint 2010 RTM trial on Windows Server 2008 SP2. I want to populate csv filke data to new sharepoint list. I am using custom List Wizard to achieve this... When I Import csv on server then everything is fine but when i inport csv from client, i get the following error "The Specified is not valid Spreadsheet or contains no data to import" I have also checked to import excel workbook but it gives the same error on client and do great on server..... can anybody have any idea what is wrong ?? thanks

How to link SharePoint List with MS Access 2007 programmatically

  
Hi, can anybody tell me how to link SharePoint List with MS Access 2007 without opening Access environment. I want to do it programmatically through C#/VB.net doesn't matter. Your help will very much appreciated. Thank you so much! -Jarexs

Cannot access parent site list from subsite in XSLt List View webpart in sharepoint designer 2010

  
Hi    We are using sharepoint 2010  for internet facing sites for our big client in healthcare domain .  I am using XSLT list view webpart in sharepoint designer 2010 for retrieving contents from sharepoint list & displaying it by using XSLT List view webpart in publishing sites. We are having lot of list in rootsite collection, If i am creating pages by using XSLt list view webpart in root site collection I can access the list,View and Display in Pages by XSLT List view webpart. Now the requirement is i have to access the list in roosite collection(parent site) from subsites.  In Sharepoint designer 2010, while i am inserting XSLT list view webpart, i could not find datasource to access the list that exist in rootsite collection(Parent site) from subsite. Below is the the code i am using for accessing the list& view from parent site & creating the pages in parent site by using xslt list view webpart,now i wants to access parent site list from subsite by using XSLT list view webpat in subsite pages.  Pls let me know what i have to change in the code level <WebPartPages:XsltListViewWebPart runat="server" Description="The list for the conditions details" ListDisplayName="" PartOrder="2" Default="FALSE" HelpLink="" AllowRemove="True" IsVisible="True" All

Cannot access parent site list from subsite in XSLt List View webpart in sharepoint designer 2010

  
Hi    We are using sharepoint 2010  for internet facing sites for our big client in healthcare domain .  I am using XSLT list view webpart in sharepoint designer 2010 for retrieving contents from sharepoint list & displaying it by using XSLT List view webpart in publishing sites. We are having lot of list in rootsite collection, If i am creating pages by using XSLt list view webpart in root site collection I can access the list,View and Display in Pages by XSLT List view webpart. Now the requirement is i have to access the list in roosite collection(parent site) from subsites.  In Sharepoint designer 2010, while i am inserting XSLT list view webpart, i could not find datasource to access the list that exist in rootsite collection(Parent site) from subsite. Below is the the code i am using for accessing the list& view from parent site & creating the pages in parent site by using xslt list view webpart,now i wants to access parent site list from subsite by using XSLT list view webpat in subsite pages.  Pls let me know what i have to change in the code level <WebPartPages:XsltListViewWebPart runat="server" Description="The list for the conditions details" ListDisplayName="" PartOrder="2" Default="FALSE" HelpLink="" AllowRemove="True" IsVisible="True" All

how to access items inside Sharepoint List Folder

  
hi all i have a list with structure as below  QuckList(List)                A(Folder)                       1(List Items)                       2(List Items)                B(Folder)                        1(List Items)   i have to display the List items inside the folder in drop down   i am able to access the folder as Splistitem, but not able to access the items inside the folder   any ideas how to access the items inside the List Folder   ragava_28

Access list from other site-sharepoint 2010

  
i am building a SharePoint site with many sub sites , in a publishing sub site i need to display a data view of a list that exists in other site how do i do it through Share-point designer 2010 or is there way using Visual Studio 2010 .Please provide me the best solution.  Thanks in advance.

import data from infopath xml forms to SharePoint list

  
Hi. I have this issue, a customer has an old application that consists of a SharePoint 2003 site and a 'forms library' with forms listing information about physical servers. The infopath (2003) form is pretty straight forward and has a few dropdowns from lists and so on. Now, we need to move this to 2010 and preferably to a list only using oob functionality. I would like to know if anyone has a clue as to how I can get the data from the hundreds of xml files into a list, could be to excel and then to SharePoint, or any means Necessary. I would prefer it if it can be scripted or done using standard tools from Microsoft, no 3rd party custom xml importer...(if it's not really good and free :-) ) ThanksThomas BalkestÃ¥hl - Technical Specialist - SharePoint

How to provision custom list and import custom aspx pages automatically in sharepoint?

  
What is best way to create custom list (Document library) and import custom .Net pages automatically. The goal is to avoid create the list and upload those .net page to the list manually. Any code snippet that would be great help. thanks

Sharepoint List Attachments

  
Hi, I have different excel, ppt documents uploaded in the sharepoint 2007 list items. I have a major problem, when i clicked on the list item it takes me to Dispform.aspx page. There's attachments shown but when i clicked on attached files, it says "Could Not open http://xxx/abc.xsl". I am not sure why this is happening. I cant even right click on the document to save it. Issue is there on the entire list. All the documents attached in the list are broken, any suggestions please.Munna

Create List Sharepoint Client Object Model Access Denied

  

Hi,

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;  
  context.ExecuteQuery();
  this.Dispatcher.BeginInvoke(GetList);
}

The error I receive is as follows:

{System.Security.Se

Access Denied Error While trying edit sharepoint list item

  

 I have a sharepoint site (2007) with two subsites . while I am trying to edit  list items in subsite its giving me Access denied error even though I have the Site collection Admin Rights. 

     Please help . 


Access a SharePoint list from a WinForm

  
I have created a winform. The winform runs on the server that is in the SharePoint Farm. It is throwing an exception when I try to connect to the list. Any ideas? Is there some special consideratoin I need to have when connecting with a winform? The winform just has a button that when pressed I want to give the created date a new value, which is part of the name of the file in the list.

Code:

 

using (SPSite site = new SPSite(http://inet533/sites/aamc/refctr/))
{

Not able to Import Spreadsheet into SharePoint list.

  

Hello All,

I am working on WSS 3.0  and with MS Office 2007. I want to import an excel spreadsheet into SharePoint list using the feature provided under "Custom List -> Import Spreadsheet". Whenever I try to Import SpreadSheet i got following error;

Cannot connect to server at this time. Your table cannot be published.

Simultaneously, I am not able to utilize Export to Spreadsheet functionality present under " Actions => Export to Spreadsheet". Whe i tried to export the list it gives "Cannot connect to sharepoint list" error.

Can anyone help me to fix this issues?
Thanks in advance. Waiting for your valuable response.

 


-Kaustubh

Opening SharePoint List Attachments - HTTP 500 Internal Server Error

  

We are getting "HTTP 500 - internal server error" upon opening list attachments. The list attachments are added programmatically to the list item.

This doesn't happen for all the items in the list, but only for few items.

There is no error in the SharePoint logs and the event viewer.

Has anyone encountered this issue/error?


Sharepoint Export Import List Items

  

Hello,

My requirement is to export the list items in Pages library with its meta data i.e. Created Time and Modified Time.

I am trying Export Import code, but it does not import time. It imports the CreatedBy and ModifiedBY acuurately but createdTIme and Modified Time comes as current time, the time i run the import.

Pls help

Code:

private static void ExportItems()
    {
      string exportFolder = @"C:\exports\";
      string exportFileName = "Export_File.cmp";

      using (SPSite site = new SPSite(sourceSiteUrl))
      {
        using (SPWeb oWeb = site.OpenWeb())
        {
          SPList oList = oWeb.Lists["Pages"];
          SPListItem oItemA = oList.GetItemById(2480);

          SPExportObject exportObject = new SPExportObject();
          exportObject.Id = oItemA.UniqueId;
          exportObject.Type = SPDeploymentObjectType.ListItem;

          SPExportSettings exportSettings = new SPExportSettings();
          exportSettings.LogExportObjectsTable = true;
          exportSettings.LogFilePath = exportFolder + "Exportlog.log";
          exportSettings.SiteUrl = sourceSiteUrl;
          expo

Opening attachments to list items in SharePoint 2010

  

Hello,

We have some sites that use lists with attachments (generally PDFs). When we click on the item and then on the attachment, we only get the option to Save or Cancel. I thought this might be related to the web applications Strict vs. Permissive setting, but it occurs even after switching the web app to permissive file handling. List attachments in Microsoft formats (word, excel) open correctly in the web apps, and PDFs in document libraries correctly show the Open option since switching the web application to permissive. Is there a way for that to affect list attachments as well?

Thanks,

Aaron

 


Categories: 
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