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
0
votes
1answer
733 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, ...
1
vote
1answer
857 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<...
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 ...
0
votes
0answers
12 views

EXCEL import: share point calculated field source columns are blank while others can see data in them

I understand that exporting a share point List view with calculated column will pull the source columns for that calculated column to excel even if they are not in the view. my issue is there is no ...
0
votes
1answer
996 views

SP2013 Export-SPWeb and Import-SPWeb preserve meta data

I want to move a list / library from one site collection to another. I tried to use Export-SPWeb and Import-SPWeb PowerShell commands, however the imported list items doesn't not preserve metadata ...
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 ...
1
vote
2answers
3k 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 ...
4
votes
3answers
811 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 "...
1
vote
1answer
1k 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 ...
1
vote
1answer
703 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 ...
0
votes
1answer
25 views

How do I move SharePoint Lists including metadata

on sharepoint 2013 on-prem, I would like to migrate a a few lists in the same site collection to a different subsite using powershell. I tried the following commands: Export-SPWeb "SiteURL" -ItemUrl "...
0
votes
1answer
427 views

Error Importing CSV list into Office 365 Sharepoint

I'm trying to add a list to the Office 365 SharePoint application by importing a CSV. After selecting my range of cells and starting the import, I am thrown this error: cannot connect to the server ...
1
vote
2answers
5k views

Import Spreadsheet - An unexpected error has occured. (Office 2016 / SharePoint 2013)

I'm doing research as to why the Import Spreadsheet app in SharePoint 2013 (on prem) no longer works as I have Office 2016 installed on my Windows 7 computer using IE11. the following message appears ...
1
vote
2answers
2k 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 ...
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 ...
1
vote
1answer
26 views

Bulk import hundreds of documents into new document library and retain all links

Is there a way to bulk load hundreds of MS Word documents and retain all hyperlinks within each document?
0
votes
1answer
41 views

How to import data into Excel from MS Access?

If I put an MS Access database on Sharepoint or One Drive, how can I import/link the database table into Excel? My Excel will also eventually be on Sharepoint. Current as a PoC, I put the database on ...
1
vote
1answer
60 views

DocumentSet.Import returns [Exception : Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))]

I'm getting the [Exception: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))] when trying to import documentSet programmatically from a site collection document library to ...
1
vote
2answers
3k 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" ...
1
vote
0answers
2k views

Unexpected identifier on javascript import statement

I'm getting the following error when trying to implement Google Analytics reporting in a Sharepoint site page. Uncaught SyntaxError: Unexpected identifier view-selector2.js:19 (js file and line ...
0
votes
1answer
34 views

Importing a Sharepoint website from a .wsp - List X does not exist

I'm a total noob in Sharepoint Development, but I'm quite skilled in .NET. I need to deploy a ready-to-go website from two .wsp files: App.wsp AppEmployeeService.wsp I suppose that Lists and other ...
0
votes
2answers
444 views

How to replace all items in a List with data from Excel sheet

For a specific use case, I need to synchronize/update all items in a SharePoint 365 List with fresh data from an excel sheet. If the sheet contains new items, they should be added to the list. If ...
0
votes
1answer
1k views

Importing Spreadsheet to SharePoint 2013

when attempting to import a Spreadsheet from Excel to SP13, I get the error "List cannot be imported because SP Foundation-compatible spreadsheet is not installed or compatible with your browser.
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-...
0
votes
1answer
45 views

SharePoint 2016 Managed Navigation Import CSV Parameter Mapping

I am interested in importing my managed navigation information from an existing site into another sharepoint site (we are creating environments for testing and production, so we want them to mirror ...
0
votes
0answers
47 views

Import list with Import-SPWeb changed certain Urls

We've exported some lists from one site collection SC1 in web application WA1 with the Export-SPWeb command, and imported it in site collection SC2 in web application WA2 with the Import-SPWeb command....
1
vote
2answers
122 views

Export/import SPWeb to rootweb of new SPSite results in empty + missing groups

We exported a SubSite using Export-SPWeb with IncludeUserSecurity and versions. Subsequently we imported the export to the root of a newly created SiteCollection on the same WebApp (SharePoint 2016). ...
0
votes
3answers
541 views

Custom Excel import into sharepoint list

I have a requirement like this. In Sharepoint there is list (lets call it master list) It has all required columns with their respective types. A user need to be able to import data from Excel file (...
0
votes
1answer
35 views

How to migrate 1000 list items from List1 in Site1 to List2 in Site2 Using Powershell

I'm using Microsoft.SharePoint.Deployment.SPExportSettings/SPImportSettings class to migrate 1 listitem successfully. But I need to migrate only 1000 listitems. Thanks in Advance:)
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?
0
votes
1answer
70 views

Import field from other forms on info path

I create a new list in SharePoint 2010 and start edit the form in info path and now I want to import part of the fields from other info path template( already exist) is that possible ? Thanks ...
1
vote
1answer
47 views

Are there any risks or drawbacks if i Import the same Pages library inside 2 site collections

I have 2 farms which are of type sharepoint 2013 on-premises 2013 enterprise. and inside FarmA i have a wiki pages library which contain many wiki pages for policies and procedures for IT departments. ...
0
votes
1answer
291 views

How i can copy term sets from on farm to another and preserve the term sets GUIDs

I have 2 sharepoint farm 2013 for 2 different customers. now i want to export a wiki page list from one farm and then import it to another farm. now the wiki page list is inside an enterprise wiki ...
0
votes
1answer
98 views

When Importing a list which contain Managed Metadata columns will associate the Managed Metadata columns with the related term group

I am facing this inconsistency inside my sharepoint 2013 on-premises farms, when Importing a Pages library inside different farms. as follow:- Now i have 3 farms. our live serve + our test server + ...
0
votes
1answer
560 views

PowerShell, Adding List Items, How do i declare a date/time?, and other issues

I got some solid help on here before with working with PowerShell and SharePoint. While I would consider myself an experienced SysAdmin and a Knowledgeable SharePoint Admin (front-end, Workflow Design,...
1
vote
0answers
30 views

Export then Import a list between 2 farms, when there are users who are no longer exists inside Active directory

I have 2 sharepoint on-premises farms 2013, which are inside the same domain (are integrated with the same Active directory and users), as follow:- FarmA which is an old farm, and it contain a lot of ...
1
vote
1answer
136 views

Quick Launch URLs not updating after Export\Import feature

I am trying to create a site in SharePoint 2016 using export-spweb import-spweb through Powershell. Everything is working fine except the URLs of Item in Left Navigation\Quick launch. The issue is ...
1
vote
5answers
25k 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 ...
2
votes
1answer
841 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 -...
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 ...
1
vote
1answer
92 views

Requirements and effect of Export/Import lists and documents from one farm to another

I want to export a list from one farm and import it inside another farm. using these commands:- Export-SPWeb -Identity "http://****/subsitename/" -ItemUrl "Sales" -Path "c:\export4.cmp" Import-SPWeb ...
1
vote
3answers
4k 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. ...
2
votes
1answer
174 views

Export document library. Are content types included?

We need to recreate a site from scratch, however we need to keep the data in some document libraries and custom lists. Therefore, we study the possibility of doing and export-import of the libraries/...
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 ...
1
vote
3answers
3k 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
294 views

SPO 2013: import spreadsheet app throws “browser requires activex” error

Same issue as this Cannot import spreadsheet into SharePoint. This feature requires a browser that supports ActiveX controls but answers don't work. When I click "import" I get: "Cannot import ...
1
vote
2answers
728 views

how to run JS code from SharePoint

I have data-source to import data from into a SharePoint list. One of my colleague is working on the code, but the issue how We don't know can run that JS file in SharePoint. So that it will ...
0
votes
1answer
510 views

Import-SPWeb: Document library Import Failed

I am doing document library import by using Import-SPWeb command but it failed with below error. There was no error or warning in Export process. Error: Cannot complete this action. Please try ...
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 ...
2
votes
1answer
159 views

How to import active directory SharePoint online

I'm new to SharePoint.I have a ,trial 365 Enterprise E3 Developer account with 2016 SharePoint site.I tried to find setting for the active directory import but i could not, is it because i have a ...