Import of data is the automated or semi-automated input of data sets between different software applications. It involves "translating" from the format used in one application into that used by the other.

learn more… | top users | synonyms

7
votes
5answers
18k views

Why are fields in Datasheet View read only?

I have four metadata columns into which I cannot paste data for a bulk upload. A diaglog box: "The selected cells are read only" appears when I try to paste. The cells are defined as "multiple lines ...
4
votes
3answers
8k views

Move list from root site to subsite

We accidentally created a few lists at the root of our SharePoint 2010 site and need to move them to a subsite. How do you do this? We tried exporting as a template, but then the list became a library ...
4
votes
1answer
963 views

Import throws “Could not load file or assembly”

We've exported a web site on SP2010 using this command: Export-SPWeb -Identity http://vmdev95/ -Path \\vmdev95\sp_backup\acm -NoFileCompression -HaltOnError -HaltOnWarning -IncludeUserSecurity Then ...
4
votes
3answers
4k views

How to export a list in SharePoint 2010 and import it into 2013

Is there a good free way of exporting a list in SharePoint 2010 and importing it into 2013. Need to keep structure, data, attachments and other data but revisions, permissions etc not necessary. ...
4
votes
2answers
956 views

<xsl:import> not working in SP2010

I have been trying for days to understand why, following an upgrade to Sp2010, none of the statements used in my web part definitions are working. The work fine in SP Designer 2010 and render as ...
3
votes
2answers
1k views

Moving a Site Collection from SharePoint 2010 Foundation to SharePoint Server 2010

Is it possible to move a Site Collection from SharePoint 2010 Foundation to SharePoint Enterprise Server 2010. I tried import/export using PowerShell and get an "Access is Denied" error on import. ...
3
votes
3answers
17k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
3
votes
1answer
58 views

how to find Imported web

I exported a web from a site collection and imported it to a newly created site collection but when I try to access it, I get 404. My new site collection is, https://2020.develop.com/custs/newsiteco ...
3
votes
2answers
479 views

Content Deployment and Migration API not importing no error thrown

The following http://blogs.technet.com/b/stefan_gossner/archive/2007/08/30/deep-dive-into-the-sharepoint-content-deployment-and-migration-api-part-4.aspx provides the follwoinf code to import and ...
3
votes
1answer
300 views

Migrate from 2007 to 2010 without access to database

one of our customers has a sharepoint 2007 environment in a shared environment. Now they want us to move there sharepoint to 2010 on another server in another domain. Because i'm not very ...
3
votes
2answers
2k views

Move documents from SharePoint 2007 to SharePoint 2010

I have an old sharepoint site containing around 50 document libraries with subfolders and files. No these document libraries should be moved to a new SharePoint 2010 site. I've tried this using the ...
3
votes
1answer
3k views

export / import spweb problem with DataConnectionLibrary feature

I'm attempting to export a subsite from staging to production using powershell and export-spweb and import-spweb. This worked just fine from staging to development. When we try to run this on ...
3
votes
2answers
2k views

How to import a large number of files into SharePoint?

I have 500 GB in .pdf and .doc files on my file share and I want to put all of those into SharePoint. What is the best way to do it? I have a database size of 250 GB. I also want to be able to search ...
3
votes
1answer
122 views

Importing a list from one visual studio project to another

I have sp project (say project a) in visual studio that is supposed to deploy the sp solution to my website (say that its running at http://localhost:xxxx/). My goal would be to add the list ...
3
votes
2answers
147 views

Is there a way to detect if a content deployment is ready?

I need to detect if a content deployment between two different sharepoint 2010 farms is finished. Is there a way to achieve this programmatically? I've been looking around for some days now but ...
3
votes
1answer
312 views

Import-Spweb is changing the user id if the user does not exist in the organisation anymore

We had to restore a list (which has versionsing enabled) in our PROD enviornment SP 2010 August CU 2012. We used the following command metioned below: Import-SPWeb http://example.com/projects/myList ...
2
votes
2answers
1k views

Powershell backup/restore or import/export to keep all document versions?

I need to move a test SharePoint 2010 site collection and database to a new server (and new database). I want to make sure that I keep user security and all document versions. Does backup/restore keep ...
2
votes
2answers
3k views

Working with data imported from Excel into a SharePoint List

I just imported an Excel spreadsheet into a SharePoint list, and all of my data was imported as single or multiple lines of text. While appropriate for some instances, in other cases, like a name ...
2
votes
5answers
2k views

Migrating content from one content database to another

We have a content database on our live moss server. It contains one site collection with several sub-sites. I'm using the stsadm export command to produce a cmp file, then moving this to our test ...
2
votes
2answers
2k views

Importing a WSP template - Error, require feature {69cadbef-ac7d-494d-9d0a-39a26e008377}

I've made a back up of site to produce a template file (WSP) in SharePoint 2010 online. I have then tried to import into my development platform, which is also SP 2010 online but keep getting the ...
2
votes
4answers
411 views

How to add column data in bulk?

I have a new SP 2007 site which I have been loading about a terabyte of files into. File types include .doc, .docx, .ppt, .pptx, .xls, .xlsx, .xlsm, .jpg, .gif, .pdf. What I need to do is add custom ...
2
votes
3answers
1k views

Excel import to SharePoint

I'd like to be able to import a spreadsheet from Excel into SharePoint and be able to select a list template I've already built. Is this possible? I need to be able to do this so the proper ...
2
votes
1answer
7k views

Copy of same content database running on two web applications

I have a backup of content database (*.bak) file. I have one web application running it now. However I have restored it again under different name on my SQL Server. I would like to create another ...
2
votes
1answer
338 views

SharePoint and several Active Directory sources(solved)

I have either a SharePoint AD sync problem or AD problem. I have mapped several AD sources to be imported into SharePoint: SP-domain AD 1 AD 2 - > groups to be imported into SC 2 AD 3 - > groups ...
2
votes
1answer
1k views

How to import a library from Export-SPWeb outputs?

I am trying to understand how to restore an arbitrary library to an arbitrary site in an arbitary site collection - inspired by some future user announcing he accidentally deleted a document from the ...
2
votes
2answers
1k views

Importing/uploading files from file share to SP 2010 Doc Lib using CSV

Can someone please provide a good link (or if you already have a powershell working) that can import files from file share into SharePoint document library using a cvs flat file. I have about 20 ...
2
votes
2answers
2k views

Can I export a list from SharePoint 2007 and then import to SharePoint 2010?

I have a user that has requested we copy her Shared Documents library from SharePoint 2007 team site to an existing SharePoint 2010 team site. Can this be accomplished with OOB STSADM export/import ...
2
votes
3answers
1k views

Object Reference Not Set Error in SPImport.Run()

I'm trying to move my site from a server to another. I exported my site using Export-SPWeb, moved the data to destination server and ran the function below: (Taken from here.) function ...
2
votes
1answer
33 views

Convert Single line of Text to Lookup type after importing data from Excel file

I imported the data from excel file, but some column data type I need to change from single line of text to Lookup value. How to do this? I am using SharePoint 2013
2
votes
1answer
279 views

error when importing list _catalogs/fpdatasources

I'm pretty new to Sharepoint. I am importing (with Import-SPWeb) the lists of a Sharepoint 2010 site into a 2013 server. While the process completes without problems in other lists with ...
2
votes
1answer
552 views

Trouble promoting subsite or moving it to a different site collection

My company is just starting to use sharepoint for some of our contractors. And I am now tasked with the administration. (yay) Development was done on a standalone server and they were planning on ...
2
votes
1answer
104 views

Import Summary Links Collection

I am trying to insert summary links into a custom content type. PublishingPage newPage = publishingWeb.GetPublishingPages().Add(filename, layout); newPage.Title = page.NewPage.Title; ...
2
votes
1answer
207 views

How to import one single row of data from excel to one list item in a SharePoint 2010 list?

I have a problem where we want users to attach a file to a new item and the SharePoint list will automatically read on row or column of data (maybe 20 cells-worth of data) and populate some additional ...
1
vote
2answers
4k views

Export-spweb / Import-spweb leaves the lookup columns empty

The export / import operations seems to be working quite well except for lookup columns. The lookup columns and other columns associated with the lookup are all empty. Is this a limitation? Is there ...
1
vote
4answers
10k views

Import from Excel to an existing list

I'm trying to import data from excel into an existing list. I can paste one line at a time by opening the excel doc and the sharepoint list in datasheet view, but that's not very efficient. Any ...
1
vote
2answers
241 views

How to find out if a web template is missing from a site collection

Is there any utility out there that can tell me if there is any custom web template missing or faulty from a site collection, I keep getting error "WEB template #00000 not found" while importing a ...
1
vote
1answer
2k views

Has anyone seen this error; $Resources:core,ImportErrorMessage;

In my local machine i deployed my web part and also i can use it but when i want to use this web part another sharepoint site importing web part shows this error: $Resources:core,ImportErrorMessage; ...
1
vote
1answer
1k views

Move an Item between lists maintaining version history

I wish to move/cut a item from list in SharePoint to another list. I can copy the item across to a list and delete the original. Sadly version history is lost. I want a way to be able to copy an item ...
1
vote
1answer
4k views

export and import document library from one site to a subsite using code?

This should be possible, I have find some examples but with list items, or entire sites, not with only a document library. Id be happy if somebody can provide working code!!
1
vote
2answers
196 views

How do I migrate a document library (and just the documents) with PowerShell

I need to migrate the documents of an existing library to a new library. The requirements of the migration is that I maintain versions and audit data (who/when created the document and last modified ...
1
vote
2answers
810 views

SharePoint 2010 - Bulk Upload List Data that contains Managed Metadata (Terms)

I have a list that contains a few columns of type Managed Metadata and want to upload a bunch of data (records) to the list. I understand that you can't do this within the Datasheet View of the list ...
1
vote
2answers
877 views

Error while trying to Import Term Set using .CSV file

When i try to import a termset(in a Site collection) using the .CSV file,i get the below error, An error was encountered while attempting to import the term set at line 2 of the submitted file. ...
1
vote
2answers
79 views

Updating a Visual Studio project made from an imported WSP file?

I have a project in Visual Studio 2010 that was created by importing a WSP file. This file was generated by saving a site as a template. Now the original site has changed (new list definitions and ...
1
vote
1answer
81 views

Edit Termset using CSV file

I understand that we can add termset by importing the terms created in CSV file, But i would like to know the possibility to edit(addition of terms) the same CSV file in the future and update the ...
1
vote
1answer
401 views

Is it possible to import an Excel spreadsheet, including the comments and hyperlinks, into a List?

I would like to import a Microsoft Excel spreadsheet into a SharePoint 2007 List. The spreadsheet contains comments and hyperlinks. Could those also be imported in the List? Comments I know would ...
1
vote
3answers
2k views

How do you programmatically create a list using an excel spreadsheet?

I have an excel spreadsheet that I would like to use as data for a SharePoint 2010 list. I know how to do this without code, but for this particular task, I need a coded solution. Does anyone know ...
1
vote
2answers
534 views

bulk importing content from existing non-SP website?

I'm pretty new to the SharePoint world, apologies in advance. Our shop just lit up a new SP2010 farm, and we're in the planning stages for getting content from our existing not-SP intranet into SP. At ...
1
vote
1answer
679 views

Unable to Import MasterPage

I am trying to Import a master page to Master Page folder from SharePoint designer 2010. Unfortunately it is coming under page Layouts. Not sure what am I doing wrong here? I tried with the import ...
1
vote
3answers
2k views

Import-SPWeb with Overwrite always appends

I'm exporting a Custom List from one SharePoint instance and importing into another. The documentation says I should be able to use UpdateVersions with Overwrite to remove all items and then insert ...
1
vote
1answer
2k views

Import-SPWeb throws exception “A duplicate field named [guid here] was found”

From the SharePoint 2010 Powershell console, I'm importing a site collection into the same parent site collection as the source. (ie. http://parent/sites/sourcesite has been exported with Export-SPWeb ...