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

2
votes
1answer
26 views

Batch/bulk create Document Libraries (SharePoint Online 2013)

As part of a very large migration of data from an internal network to SharePoint 2013 (O365), I need to create a very large number of Document Libraries (several thousand). Each Document Library ...
7
votes
6answers
19k 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 ...
0
votes
1answer
9 views

Importing into 2013 from 2010 export.cmp files

I have export.cmp files from a SharePoint 2010 environment outside my company. Is it possible to import them into a 2013 test environment I have setup? I have done a lot of fooling around with ...
3
votes
1answer
326 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 ...
0
votes
0answers
34 views

How to import large Term set CSV file?

I am importing a csv file with 1 term set and approximately 12,000 terms. When I begin the import, it says something like "Please wait while we import your terms", and about 5 minutes later the popup ...
1
vote
1answer
39 views

How to Import Sharepoint2013 site from the saved site template wsp?

I have saved the site using the method explained in Save site as template in SharePoint 2013 now , I want to import the site on another machine. how to achieve this?
0
votes
1answer
32 views

update the page layout links for all the publishing site collection pages

i have export/import a publishing site collection as a subsite. but i read that the page layout links inside publishing pages are hard coded. and to update all the page layout links i found the ...
0
votes
0answers
16 views

Is it possible to move a publishing site collection to a sub site

I am working on SharePoint 2013 web application. I have a site collection of type publishing-->enterprise wiki. I read on this link that moving a site collection to be a subsite is not possible ...
0
votes
1answer
25 views

What is the best practice to move/copy termset from global to local?

I am using sharepoint 2010. I have 1 webapplication with many site collections. In one of my site collection I have some specific site with a list with a managed metadata column. I have setup this ...
2
votes
1answer
40 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
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 ...
1
vote
2answers
888 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 ...
0
votes
1answer
30 views

Import Documents into SharePoint 2013

I want to import some documents to a SharePoint document library. I know how to import into this library, but the problem is with user rights. I have to many documents to import so, the process has to ...
0
votes
0answers
27 views

Import Spreadsheet fails with Method 'Post' of object 'IOWSPostData' failed

We use SharePoint 2010 (SP2) and office 2010 If i Create List from an Excel sheet (Import Spreadsheet) and i do this on a Sub-Site all goes well...however if i do it on a Top Site then it failes ...
0
votes
0answers
18 views

Mounting SP database where the DBs names and server names are in a CSV file

I want to mount SP content databases using powershell. The content DBs names and server names are in a CSV file. How to read the CSV file and use the mount -SPContentDatabase command? Can someone ...
0
votes
1answer
31 views

Sharepoint Excel Logic

I have an Excel spreadsheet that I would like to import onto Sharepoint. The import/export function is easy enough to use, however the math logic that four of the cells conduct in the Excel ...
1
vote
0answers
84 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 ...
0
votes
1answer
148 views

Import Excel Sheet and append items to SharePoint list [duplicate]

I have Excel sheet and existing SharePoint list (Import spredsheet app) on my SharePoint server. We need to append the data from the new excel sheets to the existing lists items of the SharePoint ...
0
votes
1answer
43 views

Error while importing site - duplicate field

I have exported a subsite under site collection in production and then tried to import on same subsite in dev. But I get error message that duplicate field "guid" was found. It does not import ...
1
vote
1answer
46 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 ...
0
votes
1answer
47 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
0
votes
1answer
21 views

Import Page with Web Part

Why when I import a publishing page with web part in the page content, the web part is declared "closed" and goes into closed web parts?
0
votes
1answer
87 views

Export subsite and Import in another web app (means another db)

I have one web application with site collections. Then I have a subsite inside. I want to export this subsite (and only this one), and import it in a new web app I will create. Question is : Is this ...
0
votes
0answers
86 views

Import/refresh automatically a CSV file ? Powershell or not?

I have to import a CSV file into a list (put it in a tab). But this CSV will be updated (weel, in fact it will be regenerated), and I need SharePoint to refresh the list with new data. I don't know ...
1
vote
2answers
225 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
0answers
20 views

“Unselect All” features when importing a site template to Visual Studio 2012?

In Visual Studio 2012 I'm importing a WSP of a site template using the "SharePoint Customization Wizard." The list of features displays with all items selected. I only want to import a couple ...
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 ...
0
votes
2answers
169 views

Error when importing listview webpart to subsite

I have a list on a root site (SP 2010). I want to create a list view webpart on a subsite that is connected to the list on the root site. All the guides I have read online say to go into the listview ...
0
votes
0answers
18 views

WSS 3.0 - Add directory as document library

I would like to ask if its possible to use a directory (located on the same server WSS is installed to) as a new document library. I know I can create a new library, open it in Windows Explorer and ...
1
vote
0answers
92 views

Able to Export a site but unable to import in another webapplication

Here I am using SharePoint 2013. I exported site collection with no errors, but when trying to Import site onto different web application as a site, I got below error Verbose: List URL: ...
1
vote
1answer
181 views

Import Sharepoint list via VBA in specific view

I am currenty trying to import a Sharepoint list in an Excel sheet via VBA and thanks to this: Import Sharepoint List into Excel Using VBA Only It is working pretty well, but if i leave the "VIEWNAME" ...
0
votes
3answers
673 views

Physical to Virtual Migration of SharePoint Machine

We are about to conduct a full virtual migration. Among the physical machines to be migrated is our SharePoint server, which hosts two SP sites. I know very little about SharePoint and I've only ...
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 ...
0
votes
2answers
622 views

Imported site collection has “Revert to template”

I've imported a site collection via PowerShell and all the pages show the message: The current page has been customized from its template. [Revert to template]. The original site collection didn't ...
0
votes
1answer
63 views

TermSet 'ID' is a ReadOnly property

I'm trying to set a TermSet.ID in Term Store, but fail since this is a read-only property. Is there any way to override the ReadOnly setting? if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" ...
1
vote
1answer
905 views

Import HTML into a SharePoint list as rich text

What I have: SQL Server 2008 R2 database with a table containing some columns whose values are raw HTML SharePoint 2007 list with standard rich text columns (not Enhanced Rich Text) Office 2007, ...
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
0answers
218 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. ...
0
votes
1answer
32 views

Importing data to SharePoint list

I have a spreadsheet that I would like to import to a SharePoint list daily. Data changes on it everyday and I need to be able to reflect that. Once an item is added to the SharePoint list, there ...
1
vote
0answers
195 views

Add new synchronization connection - NeedsFullImport Error

We are trying to setup a new sychronization connection on Sharepoint 2013 however after having filled in our account details and selecting User OU's, when pressing OK the following error is displayed ...
2
votes
1answer
291 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 ...
3
votes
1answer
124 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 ...
0
votes
0answers
25 views

Get a column data from an XSL and insert it and synchronize it in a SharePoint Column

I would like to get data from a XSL column and display it in a SharePoint column inside of a list. How can I do this ? and after, if someone add more items into the XSL table , how can I update the ...
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. ...
0
votes
1answer
54 views

Import Site Error

i'm trying to create a SharePoint Server for test and development exactly same as the prod one. So my server is ok, as my db and my central admin. Then I Created a new site collection on the TEST ...
1
vote
2answers
921 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. ...
0
votes
1answer
152 views

Delete a theme from the theme gallery with PowerShell

I've found that import-spweb duplicates items in the theme gallery. Using export-spweb and then import-spweb, the target site is doubled up on each of the themes in the theme gallery. Everytime I do ...
1
vote
0answers
36 views

Excel spreadsheet imported as a list into SharePoint 2010, is creating extra HTML tags

I have several lists that I imported into a publishing site on SharePoint 2010. It appears that the import process created lists with problems. All the fields ended up with extra html tags (i.e. ...
1
vote
0answers
74 views

Need to use existing list to create doc library based on template

I have an existing list with many items. I have created a doc library with the same columns as the list and associated a template with the library. I created a workflow to pull items from the list and ...
3
votes
3answers
18k 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 ...