Questions tagged [import]

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.

Filter by
Sorted by
Tagged with
12
votes
5answers
71k views

Is there a way to duplicate or copy a list into the same site

So here is my problem. I have a site collection. In this site I have a list (ListA) that has lots of columns and lots of attachments and lots of items and over the threshold. I would like to create a ...
10
votes
12answers
70k 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 ...
10
votes
3answers
24k 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 ...
10
votes
1answer
3k views

The remote server returned an error: (403) Forbidden when accessing office365 site through external APIs

We have built a desktop app that import/exports SharePoint lists into/from Office 365 sites. The app works perfectly, and we were able to do the import/export of Office 365 site pages for many clients ...
8
votes
3answers
32k views

How to import MS Excel data into an exisiting SharePoint List?

Is it possible to import an excel list or excel data into a SharePoint List that has already been created? Not create a new list. I know you can import a spreadsheet which will create a new list, but ...
7
votes
1answer
146 views

Are there any risks of doing an Export/Import for a document library between 2 farms, where these 2 farms have different farm build numbers

I have two farms which are sharepoint on-premises 2013, that have the same license type which is "SharePoint Server with Enterprise Client Access License" license. but the farms' build numbers are ...
6
votes
2answers
56k 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 ...
6
votes
3answers
16k 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. I'...
6
votes
1answer
8k views

Import/Copy/Paste Data from Excel into Existing SharePoint List

How can I import data from Excel into an existing Task List (or other list) for the various column types using the Datasheet View?
5
votes
1answer
2k views

SharePoint Online: Import data from excel to SharePoint list

I have to upload data of excel columns to SharePoint list and the excel has got 8 to 9 sheets. I tried copy paste every thing but is quite hectic. Then I tried using Import Excel Sheet app but then ...
4
votes
1answer
1k 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
1answer
6k 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 ...
4
votes
2answers
1k 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 ...
4
votes
2answers
3k 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 ...
4
votes
1answer
763 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
4
votes
1answer
4k views

Export a page and import using SP2013 designer. all webpart missed

I am using SP2013 Designer to export a page from site collection A and then import to site collection B. The page contain custom layout and two webparts (search result and refinement panel). Before ...
4
votes
3answers
817 views

Move specific folder in a document library

UPDATE 1: I have the following script, but it's not working correctly: Add-PSSnapin Microsoft.SharePoint.PowerShell #input = https://sharepoint.oshirowanen.com/sites/oshdev $websiteurl = read-host "...
4
votes
1answer
416 views

Exporting a list with lookup fields

I'm in a situation where I need to export 2 lists from site Site A to Site B. The lists I'm exporting have a lookup relation. List X has a lookup to List Y. List Y gets imported to the new location ...
3
votes
2answers
7k 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 ...
3
votes
2answers
2k 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
2answers
733 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
3k 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 ...
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
1answer
327 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
3answers
2k 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 ...
3
votes
4answers
6k views

Adding JQuery and Bootstrap references to Master Page

I'm new to Sharepoint and I've a problem trying to add Jquery and Bootstrap references to a MasterPage. Just created a new master page (copied seatle.master to seatle2.master) and wanted to add: <...
3
votes
2answers
3k 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
736 views

Restore/Import Managed Metadata from another SP 2013 Farm

My situation: SP2013 Farm A: Managed Metadata Service Application with database named "ManagedMetadataDB" SP2013 Farm B: Managed Metadata Service Application with database named "ManagedMetadataDB" ...
3
votes
1answer
1k 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 -...
3
votes
1answer
442 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
3k 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 ...
3
votes
2answers
190 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
3answers
2k 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 import-spweb($...
3
votes
3answers
489 views

Can I suppress Import-SPWeb log created message

Using the SharePoint Administrator PowerShell command Import-SPWeb, I loop through many backup files, each generates the output: Log file generated: C:\somepath\backup.cmp.import.log With the ...
3
votes
0answers
1k views

Import-SPWeb : Access is denied

We were able to export site backup and when we are trying to import content of backup file to newly created site collection we are encountering with below error message which says access denied. ...
2
votes
2answers
2k 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
2k views

Change data type to People or Group

I have done a excel import and all the columns are successfully imported. One of the field is Assigned to whose data type is Single Line of Text. Is there a way to change the data type of this field ...
2
votes
2answers
7k 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
3answers
3k 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 ...
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
1answer
846 views

Import-SPWeb can not find my .cmp folder

I have exported a document library from Farm A as follow:- Export-SPWeb -Identity "http://famrA/***" -ItemUrl "Our Library" -Path "c:\16.cmp" -nofilecompression -IncludeVersions All -...
2
votes
2answers
516 views

Script to import a CSV file to a SharePoint List

My organisation has an old SharePoint2010 website. The employees have used this site to fill a form to subscribe to some courses. Now a new version of this form is created in a new SharePoint2010 ...
2
votes
2answers
3k 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
1answer
5k 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; ...
2
votes
4answers
564 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
1answer
185 views

Unable to upload a design package by using powershell scripts?

I need to Upload the Design package (.wsp file)by using Powershell scripts, I tried to run below commands but it throws an error message The term 'Import-SPDesignPackage' is not recognized Add-...
2
votes
1answer
2k views

Cannot edit column type or delete it in Sharepoint 2013

I have imported an excel file into SharePoint 2013. One of the columns I imported was PolicyType. It is currently set as a text field but I need to change it to a choice from a menu field. I don't ...
2
votes
1answer
3k 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
1answer
13k 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
3answers
4k 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 ...