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
0answers
11 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
9 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
16 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 ...
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 ...
7
votes
5answers
25k 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
24 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
18 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: ...
1
vote
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
18 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
27 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 ...
0
votes
1answer
29 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
752 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
2k 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
28 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 ...
0
votes
1answer
781 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 ...
3
votes
0answers
754 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
15 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
32 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
26 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
30 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
27 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 ...
3
votes
1answer
724 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
9 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
2k 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 ...
1
vote
1answer
22 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
24 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
373 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
30 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
33k 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
46k 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
31 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
107 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
198 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
17 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
113 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
62 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
27 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
934 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
17 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
201 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
0answers
35 views

After importing, src attribute is removed from img tag [closed]

This is SP2010. I am using BCS and an external list to read in HTML from a non-SharePoint CMS. The HTML includes typical rich-text content, including images. Looking at the external list text, I can ...
1
vote
4answers
18k 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
1answer
51 views

SharePoint Designer 2013 - Imported Files are not viewable but says they exist

I am the site Collection Administrator on 40 different Site Collections. I have created 3 new Page Layouts that I would like to deploy to all sites and I have imported them to a test Site Collection ...
1
vote
1answer
15 views

Excel Service Not Work after Import an Exported Application

my Excel service is not working.My Excels opening in my Client MSExcel but not open in Browser.its happen after after my application has problem and I have to Export and import again to work ...
3
votes
4answers
1k 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: ...
1
vote
2answers
25 views

Name change not shown in Sharepoint

Our SharePoint 2007 farm imports user info from AD daily. We have found a problem with one user (there may be more). This user has changed her surname - it was changed on AD and imported to ...
1
vote
2answers
80 views

can I import spreadsheets into sharepoint list without excel installed locally?

Is there a way to import a spreadsheet into SharePoint List if you don't have Excel installed locally? Can Office Web Apps or even Google drive sheets be used instead of excel? Edit: I have Excel ...
0
votes
1answer
522 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 ...