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

0
votes
1answer
8 views

SP-Import 'File Not Found' error

I am trying to import an Enterprise wiki site I have created from its test location to its live location which will be a new site collection. SP-Export worked fine and the SP-Import also completed ...
1
vote
0answers
11 views

How to Make Lotus Notes Items Display In InfoPath

I'm taking on a task from someone else and I'm trying to understand how this was done. The old contractor took data from Lotus Notes ranging from MT No 803-809 (there are thousands of items and I'm ...
0
votes
1answer
20 views

Importing from Excel to a Calendar

I have a new calendar that currently has no events on it. There is a calendar on one of my other sharepoint sites that I'd like to copy all the events in it over to this new one. I've exported all the ...
0
votes
1answer
895 views

An unexpected error has occurred (-2147467259) when Importing spreadsheet

I trying to Import from Spreadsheet to create a list and the above error occurs - the site is trusted and office activated - I have tried various spreadsheets so its not a number of cells issue. Can ...
0
votes
1answer
1k 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
11 views

Accessing an Imported Site with Contribute Permission Level

I am using a 2013 site that was upgraded from 2010. I needed to copy/move some sub sites that were originally created on SP 2010 as Work Spaces (template MPS#0) to a new content database. So I ...
1
vote
3answers
214 views

Importing specific profiles from AD

I want to import accounts in specific OU's and not the whole Active Directory. I have created the connection to AD and everything is working well. I'm sure it is possible to import specific accounts ...
0
votes
1answer
24 views

Import-SPWeb command not working

Trying to import one subsite from one site to other exported the site successfully using Export-SPWeb –Identity http://sitename -Path E:\backups\site.cmp but when trying to import using the below ...
5
votes
3answers
11k 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'...
0
votes
0answers
18 views

Importing Excel sheet to SharePoint Lists

I`ve created a SharePoint list by importing a Excel sheet in tabular format. My issue, though the data is imported. However, every time the first column which in my case is a number column doesn't ...
0
votes
0answers
15 views

Importing multiple lists with lookups

I have a legacy database that was originally written in SQL Server 7 and then upgraded to SQL 2000. My client would like to now use Sharepoint Online to manage this database. There are 25 tables and ...
0
votes
0answers
18 views

Lists created in subsites are not visible in parent intranet site

I`m deeply confused as why lists created in subsite example: http://intranet.abc.com/projects are visible in its respective site content: http://intranet.abc.com/projects/_layouts/15/viewlists.aspx ...
8
votes
5answers
28k 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 ...
2
votes
3answers
31 views

Copying sites / site collections with workflows

I have copied a site in order to create a test environment of it in a different web application. The process has finalized without no issues and all the lists, documents, and items are there. ...
0
votes
1answer
37 views

How to migrate a team site with publishing infrastructure enabled under another publishing subsite

We are using SP2013 standard on-premise. There are 2 existing site collection. Both are built with team site template with publishing infrastructure enabled. The URLs are: http://sharepoint.com/sites/...
2
votes
2answers
3k 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 ...
0
votes
1answer
20 views

Import Spreadsheet with field name listed vertically/per row

I need to import a spreadsheet, but the field names (title) are listed vertically. Is there any way I can import it? e.g. field 1 | axy field 2 | 30 field 3 | ax21
1
vote
1answer
31 views

importing HTML into Sharepoint

I'm successfully importing an XML files into Sharepoint as wiki pages, following this template. However, the HTML that's in the XML is being imported as text, so my page reads "<p>Hello World<...
0
votes
1answer
30 views

Import .cmp file to webapplication

I have exported my site with Central Admin to .cmp Now I use Import-spweb to import it to another webapplication like this : `Import-SPWeb http://srvdev:7070/Linstance/ -Path C:\Bak\Linstance.cmp -`...
0
votes
0answers
6 views

Import of spreadsheet into SharePont 2010 stalls

I am importing a spreadsheet from Excel into a SharePoint 2010 list. I followed the directions I got in SharePoint for Dummies. After I click the IMPORT button, it just sits there, no obvious action ...
0
votes
1answer
864 views

Export and Import the lookup relationship data in SharePoint 2013

In SharePoint 2013 having a blog site with Posts and Comments list, these 2 lists having the lookup relation ship, I export and import from one site to another site but in comments list PostTitle ...
1
vote
1answer
3k 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
2answers
36 views

How can you minimize export time on a large site collection?

I'm attempting to perform triage on a 1.5TB subsite in SP2013. I've reduced content as much as the business unit will allow, and my next step will be to move the site into its own site collection &...
3
votes
0answers
794 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. ...
1
vote
0answers
19 views

Timezone issues and file size differing for spfilezilla

I've uploaded some files from a local server to the Office 365 sharepoint cloud using spfilezilla. However I notice the times are different by the same offset of a few hours. Would this be a timezone ...
0
votes
1answer
135 views

Error “Method Post of object IOWSPostData failed” when import Excel as new list

We are using SharePoint 2013 on-premise standard edition. Our users desktop have Office 2010 installed. Recently user test the import Excel spreadsheet into SharePoint 2013 list function. He tested ...
0
votes
0answers
28 views

New page in Pages Library failing on SharePoint 2013

I have recently migrated a SharePoint 2013 site collection with publishing enabled. After the migration, everything looks fine, except for When user clicks on creating a new articles page in Pages ...
1
vote
1answer
49 views

Import multiple excel spreadsheets to sharepoint 2010 lists

I have a user asking if its possible to import an excel file with multiple spreadsheets to a SharePoint 2010 solution? Each spreadsheet should be turned into one list. It is an autogenerated excel ...
1
vote
0answers
43 views

Import-SPWeb not importing Custom Person / Group Column Values

I have a SharePoint 2013 Multi-Tenant farm configured to use FBA. I tried exporting a site in one of the site collections of the tenant using Export-SPWeb. I did include the option IncludeUserSecurity....
3
votes
1answer
760 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
12 views

Import-SPSiteSubscriptionSettings

Has anyone used Import-SPSiteSubscriptionSettings PowerShell successfully? If so, can you please provide me with the detailed steps to use it? The Technet article is not so helpful for me. Any help ...
1
vote
1answer
3k views

Unable to import multiple .cmp files

I have run the command Export-SPWeb -Identity $url -ItemUrl $largeList -CompressionSize 15 -Path "c:\itemFolder\backup.cmp" This results in 3 files. c:\itemFolder\backup.cmp c:\itemFolder\...
1
vote
1answer
26 views

Sharepoint import users from OpenLDAP (Ubuntu)

We are running a Sharepoint 2013 server. How can we import users that are using Ubuntu as Client and OpenLDAP as Active Directory? We want to connect those users from OpenLDAP to Sharepoint.
1
vote
0answers
26 views

Speed up indexing a column when rows > 5000

I've got a large list (>75,000 items, 41 columns) and therefore have to follow all the rules for handling large lists. If a new column needs to be filtered on (and therefore needs to be indexed) ...
5
votes
0answers
481 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 ...
0
votes
1answer
32 views

Non-Sharepoint metadata being imported to Sharepoint

We're going to be implementing SharePoint some time next year. However, in the shorter term people will be going through and organizing current docs and images, and I'm trying to see if there's any ...
3
votes
3answers
34k 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 ...
10
votes
10answers
48k 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 ...
1
vote
0answers
32 views

Import documents from Oracle to SharePoint 2010

I want to know that how can I import my documents from an Oracle database to my SharePoint document library. I have more than 50,000 documents stored in Oracle database and want to get them in my ...
1
vote
1answer
172 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 ...
0
votes
1answer
285 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 ...
0
votes
0answers
20 views

Sharepoint - Import spreadsheet with workflow

is it possible in sharepoint that when a user uses the "import spreadsheet", the list that was created will automatically have a associated workflow. Or if there is a work around,. Thanks
1
vote
0answers
139 views

Feed a sharepoint list from a google sheet

I have a Google sheet that's being fed from a Google form. I am looking to import the new data into a list on Sharepoint as people continue to submit new items through the form. So far, I've been ...
2
votes
1answer
74 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 ...
1
vote
3answers
2k 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
1answer
30 views

Error while importing Sharepoint site in SP 2010

I am trying to export a Sharepoint site from one environment to another. The steps I followed are as below created the site collection with web application from Sharepoint central admin in the new ...
1
vote
1answer
1k 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
0answers
18 views

Trouble importing Sharepoint task list to Project Professional 2013

When I try to import a Sharepoint task list into Project Professional 2013 I get all the tasks, with their names and their respective Due Date. But there are columns in Sharepoint wich I created and ...
0
votes
0answers
271 views

Unexpected error occurred import excel spreadsheet

I am trying to use the Import Spreadsheet app. I do not have multiple versions of Office installed or multiple languages. I have followed this and it did not work: SharePoint 2010 error when importing ...
1
vote
4answers
19k 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 ...