0
votes
0answers
16 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 ...
0
votes
0answers
21 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 ...
1
vote
1answer
608 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
0answers
30 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
62 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 ...
1
vote
1answer
410 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
0answers
189 views

List Does Not Exist Error After Importing

I have a set of sites that are using one of the Fab-40 templates and we are upgrading to 2013 and as you all know, none of the templates are compatible with 2013. So, I'm having to export the content ...
2
votes
1answer
185 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 ...
0
votes
2answers
1k views

Need to convert text to lookup field

I am inputting a list in Sharepoint that has a lookup to it. For example I have all the client data in excel, I need to import this in Sharepoint and then convert the client association from a multi ...
1
vote
1answer
369 views

Is it possible to import an Excel spreadsheet, including the comments and hyperlinks, into a List?

I would like to import a Microsoft Excel spreadsheet into a SharePoint 2007 List. The spreadsheet contains comments and hyperlinks. Could those also be imported in the List? Comments I know would ...
1
vote
3answers
2k views

How do you programmatically create a list using an excel spreadsheet?

I have an excel spreadsheet that I would like to use as data for a SharePoint 2010 list. I know how to do this without code, but for this particular task, I need a coded solution. Does anyone know ...
0
votes
2answers
2k views

Using Import-SPweb -IncludeUserSecurity slow

I am quite often asked to move lists/document libraries etc. between Sharepoint sites and retain the Author, Modified by data and the like. Now I can do this fine using the -IncludeUserSecurity switch ...
0
votes
1answer
1k views

Automate exporting SharePoint list 2010 items to Excel 2010

I found this Import Sharepoint List into Excel Using VBA Only that people have been successfully using to automate the exporting SharePoint 2010 list items to Excel 2010. Currently I m also using web ...
1
vote
1answer
666 views

Access denied when Importing a Sharepoint list

I have a serious problem when importing a Sharepoint List exported from a test server. During import, the log file encounter many problems of right access like Debug: Security check failed in ...
1
vote
0answers
126 views

Excel -> SP List with correct column types?

Are there solutions available for importing an Excel to SharePoint with SharePoint column types? Or has someone tried this with the help of OpenXml (with a custom import web part with default values, ...
3
votes
3answers
14k 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 ...
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 ...
0
votes
0answers
628 views

Import Excel as List Fails

I have an Excel Spreadsheet that I want to import into SharePoint 2010 as a list but upon doing so I receive the following errors. As a work around I have saved the spreadsheet as csv and then ...
3
votes
3answers
7k views

Move list from root site to subsite

We accidentally created a few lists at the root of our SharePoint 2010 site and need to move them to a subsite. How do you do this? We tried exporting as a template, but then the list became a library ...
0
votes
0answers
217 views

Import from Excel Spreadsheet works in IE6 not IE8

I'm having an issue in SharePoint 2007 in IE 8 where, when creating a new List using Excel Spreadsheet Import, I get redirected to a 403 error. This feature works in IE 6 but not IE 8. Can anyone ...
0
votes
1answer
375 views

List exists error when using stsadm -o import command

When using the stsadm -o import command I am getting an error relating to a list already existing, the import then seems to fail. Should it not handle this scenario of a list already existing on the ...