Тёмный

2 Ways of Importing an Excel Staff List to SharePoint 

kalmstrom.com
Подписаться 27 тыс.
Просмотров 169 тыс.
50% 1

Peter Kalmstrom shows one quick and easy way to get data in a staff list from an Excel table into a SharePoint list - and one way that uses Access and is much more powerful. Peter uses the 2013 versions for this demo. Also refer to www.kalmstrom.com/Tips/ExcelTo...

Наука

Опубликовано:

 

13 сен 2013

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 55   
@stanislavhomer3745
@stanislavhomer3745 9 лет назад
Excellent! Thanks for this, very useful.
@PeterBowers94
@PeterBowers94 9 лет назад
That was an excellent demo!
@kalmstrom
@kalmstrom 9 лет назад
I am glad you liked it :-) Thanks for sharing!
@kattascloud7292
@kattascloud7292 4 года назад
Hi, me planning to build a small sharepoint site for searching the employees info(like personal data, fist name , last name, official email id, designation , then department) in the organization, can you please provide the exact videos that help for me.
4 года назад
I would be delighted to work with you on a consultancy basis. Please let me know if you are interested.
@kattascloud7292
@kattascloud7292 4 года назад
@ I don't know how it goes for now, I am just initializing the things first , looking to work individually for the org which currently I am working in as a employee.
4 года назад
@@kattascloud7292 Ok, good luck with your project! My videos are here for free :-)
@BeauCrenshaw
@BeauCrenshaw 8 лет назад
Great content - thank you
@kalmstrom
@kalmstrom 8 лет назад
+Beau Crenshaw Most welcome.
@johngonzales4806
@johngonzales4806 5 лет назад
Great tutorial sir. I am trying to add a master sheet with about 30 columns, then using this as the data source for other buttons on the same page. For example, the master sheet will have all the employees information, but then other buttons will only display certain portions of it. Maybe like 5 to 7 columns. Then if I choose the employee, their information will pop up automatically pulling from the master sheet. Thanks in advance.
@kalmstrom
@kalmstrom 5 лет назад
I would recommend viewing my demonstrations on connected web parts. That should get you started on your project. Start here and click forward to see more articles: kalmstrom.com/Tips/SharePoint-Online-Course/Connect-Web-Parts-Choice.htm
@jdvroum
@jdvroum 10 лет назад
Hum, this tutorial open a lot of questions... Like : How to see the picture in Outlook when you put the picture in Library and not attachment ? How to display only thumnail in the list and full picture in the contact window ? How to add a page with form to upload picture and fill contact détails in the same time ?
@alexeybelyi341
@alexeybelyi341 8 лет назад
Great Demo, one thing need to be explained: how to update SharePoint list using Excel, i.e. I have about 4000 employee records and some were changed (hired,fired,married, etc. :-) in Excel file and need to reflect this in SharePoint.
@kalmstrom
@kalmstrom 8 лет назад
You would have to make a more complex query in Access to do that. Only select the ones that have been changed since the last run etc.
@lantoshka
@lantoshka 6 лет назад
Alexey Belyi у вас получилось сделать запросы в access на обновление списка SharePoint? Сейчас стоит такая же задача, не могу найти готового ответа :(
@AmalJoAntony
@AmalJoAntony 9 лет назад
Thanks for the Demo..I tried it with 1000 records. But is it possible to update the list with more than 90,000 records from multiple sheets?
@kalmstrom
@kalmstrom 9 лет назад
In general SharePoint lists create problems when the number of items is above 5 000 items. If you want to manage 90 000 items or more I would suggest creating multiple SharePoint lists, in your case probably approaching 20! Sounds a bit crazy but you could easily use a Content Search Web Part to search among all the items quickly. This would make an interesting series of tips articles! ;-)
@alextv5794
@alextv5794 4 года назад
Great! demo
@maico9039
@maico9039 8 лет назад
Hello, Is there any way to import csv files from excel to sharepoint. thank you
@kalmstrom
@kalmstrom 8 лет назад
Yes, either almost exactly like in this video or using Access
@arielalaniz2311
@arielalaniz2311 2 года назад
Hi, I'm working on Shp Online, I've created a subsite. When I want to create a list, the "From Excel" option doesn't appear. Do I need to enable any option for it appear? Greetings.-
@srikanthbenoni2362
@srikanthbenoni2362 7 лет назад
Hi- Can you show how to add data into existing list in sharepoint
@kalmstrom
@kalmstrom 7 лет назад
That is one of the things that Access does better: www.kalmstrom.com/tips/SharePoint-Online-Course/Import-Access.htm
@RotterStudios
@RotterStudios 3 года назад
If you have 400 employees, how does it know what photo to put with each person so it shows the correct photo? Do you have to paste each path for each photo for each person? Based on this video, it looks like all 200+ images were just done......is it magic? I'm lost on that part.
@kalmstrom
@kalmstrom 3 года назад
There is no magic behind the scenes. I had just prepared the images with the proper file names beforehand.
@burrellsyt
@burrellsyt 8 лет назад
great going..
@kalmstrom
@kalmstrom 8 лет назад
+burrell sinclair Thank You!
@DominicJohnson83
@DominicJohnson83 9 лет назад
you're quite the gun!!
@kalmstrom
@kalmstrom 9 лет назад
Thank you!
@fernandojannuzzi7692
@fernandojannuzzi7692 8 лет назад
Using the second method, how do I update the list in access (which had 20 registers) with an excel (with 30 registers), and add only the new registers, and not duplicates?
@kalmstrom
@kalmstrom 8 лет назад
+Fernando Jannuzzi For this you have to use a more complex query. Please contact sales@kalmstrom.com if you need our assistance.
@meerakhanna6609
@meerakhanna6609 7 лет назад
Hi! Is it possible to have the same Excel sheet, whenever modified and the same modification getting reflected in SPS List?
@kalmstrom
@kalmstrom 7 лет назад
We have published more Excel-SharePoint demos and also described what you are asking for. Please refer to www.kalmstrom.com/Tips/SharePoint-Online-Course/Excel-vs-SP.htm
@alexscott1554
@alexscott1554 4 года назад
kalmstrom.com can you link the video ?
@excessiveforce03
@excessiveforce03 9 лет назад
Is it possible to add a single column from Excel 2013 to a new column in SharePoint 2013 this way?
@kalmstrom
@kalmstrom 9 лет назад
I am not sure which process you are asking about, since I am showing two. Both of them have the ability to work with single columns if needed.
@stuj01
@stuj01 9 лет назад
Trying to do the first Excel simple import. Getting the error "Cannot connect to your server at this time. Your table can not be published". Do you need to have BDC installed? I think I am on a SharePoint standard environment.
@kalmstrom
@kalmstrom 9 лет назад
Most likely the problem is the URL, it is very important that you make sure the address is correct. Note that you need to link to the site, not a document library or a page. In the video you can see how I do that. You don’t need to have BDC installed and this has worked the same way for quite a long time in Excel.
@stuj01
@stuj01 9 лет назад
***** Thank you! Now it works!
@kalmstrom
@kalmstrom 9 лет назад
stuj01 You are most welcome!
@enisbaftiu1302
@enisbaftiu1302 3 года назад
I'm looking at creating Vlookup from SharePoint list to Excel - I have all the Data on the Excel sheet and I would to connect this data with SharePoint list and do vlookup. Is that possible?
@kalmstrom
@kalmstrom 3 года назад
As far as I know that is not possible without coding.
@zoooh7702
@zoooh7702 7 лет назад
There are a lot of issues with this technique: I was not able to export multiline text fields as well as person and group fields
@kalmstrom
@kalmstrom 7 лет назад
Multiline text fields can only be imported using this technique if the column is set to be plain text only. For person/group fields you need to supply the id of the user, not the name. I have described the use of the person/group columns here: www.kalmstrom.com/Tips/SharePoint-Online-Course/HelpDesk-ExampleData-Access.htm
@enjoyeast2568
@enjoyeast2568 5 лет назад
How to do that uploaded every day excel file was showed in list automatically?
@kalmstrom
@kalmstrom 5 лет назад
You could possibly do that with a scheduled Flow, but it is rather tricky to do. I hope to do a demo soon on how to get started on that.
@emunsey
@emunsey 9 лет назад
Can this work with multi-value columns?
@kalmstrom
@kalmstrom 9 лет назад
No, Excel does handle multi-valued columns well. Access is better for that!
@sandysysq
@sandysysq 8 лет назад
How do we set users to people picker column using Import SpreadSheet ? Have you guys thought of this ? Awaiting your response !
@kalmstrom
@kalmstrom 8 лет назад
+Shandeep AM I hope you can find what you need in this Tip: www.kalmstrom.com/Tips/SharePoint-Online-Course/HelpDesk-ExampleData-Access.htm. Peter
@sandysysq
@sandysysq 8 лет назад
+kalmstrom.com : Appreciate your response. But, if you look at the video, you would have used Single line of text and multi line of text. But, you have not used people picker column. Have you tried mapping users to the people picker column while uploading the excel ?
@kalmstrom
@kalmstrom 8 лет назад
+Shandeep AM You will have to make a look-up query against the Users list. It is a bit tricky, so please contact sales@kalmstrom.com if you need our assistance.
@sandysysq
@sandysysq 8 лет назад
Thanks much... Kalmstrom...appreciate your response....
@ashishgoyal4166
@ashishgoyal4166 3 года назад
Very difficult to understand
@kalmstrom
@kalmstrom 3 года назад
Thank you for your feedback
Далее
Add Live Graph To SharePoint
5:36
Просмотров 153 тыс.
Create a Small Business SharePoint Intranet
13:45
Просмотров 504 тыс.
Script for Auto-Update of Excel Chart in SharePoint
4:35
Export Excel Lists To SharePoint And Connect Them
10:18
How To Connect a SharePoint List To Excel
12:06
Просмотров 86 тыс.
Resource Booking in SharePoint
9:21
Просмотров 98 тыс.
Regular Import of Excel Sheet To SharePoint List
5:41
ПОКУПКА ТЕЛЕФОНА С АВИТО?🤭
1:00