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

1
vote
2answers
670 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
16 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 ...
7
votes
5answers
16k 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
0answers
15 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
17 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 ...
3
votes
1answer
301 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
1answer
24 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
40 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
109 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
35 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 ...
0
votes
1answer
28 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
26 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
56 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
46 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
156 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
15 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
114 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
16 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
74 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
138 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
609 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
9k 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
599 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
52 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
806 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
148 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
30 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
163 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
246 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
113 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
24 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
52 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
799 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
126 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
71 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
16k 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 ...
0
votes
1answer
132 views

Error while importing to sharepoint 2013

I am importing a sitecollection from moss to sharepoint 2013. While importing a fatal error occurs and migration ends there. This is the stack trace of the exception: FatalError: Value does not fall ...
0
votes
1answer
83 views

How to import multiple excel columns into a single metadata column?

Consider: I work for an organization that has eight service territories. We have a series of procedural documents that can apply to one territory up to all eight territories, and I am attempting to ...
0
votes
1answer
298 views

Error loading sitepage: cannot find the file specified. Exception 0x80070002

We have done a import from a .cmp and deployed several .wsp (webparts, usercontrols...) of our site in a new environment. We can access to back-end (_layouts/settings.aspx), but we cannot access to ...
0
votes
1answer
90 views

SharePoint 2013 Site Collection Move Owner to Group

I am in process of migrating our WSS 3.0 installation to 2013 and I am at the point where I need to break the single site collection down into more manageable sizes and I have a script that ...
1
vote
1answer
87 views

How to import the data from a Google Public Data Explorer into SharePoint 2010 out-of-box charts

using the new Google PDE I was wondering if there was a way of importing the data into my nicely formatted Chart Web Parts in sharepoint 2010.
2
votes
1answer
202 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
76 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 ...
2
votes
1answer
507 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
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 ...