Solved

Upload Tasks into Sharepoint

Posted on 2014-10-07
12
158 Views
Last Modified: 2014-10-11
Hello, I have a list of tasks due on certain dates to cover a year.  Am I able to upload this data to the Sharepoint calendar for each of the respective due dates?  Possibly there is a "canned" functionality in sharepoint for this?

fyi:  i do not work in IT and have limited programming experience.  

thank you
0
Comment
Question by:pdvsa
  • 7
  • 5
12 Comments
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40367134
Is your current task list stored in SharePoint?  If so just switch the view to Datasheet view and cut and paste your entries across the two.
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40367141
there is also a freeware software , but if you are novice with using IT stuff then I wouldn't recommend it

http://importexceldatatosplist.codeplex.com/
0
 

Author Comment

by:pdvsa
ID: 40367295
Jim jam:  I don I do not have anything in share point yet. I could upload it to share point but it it's only in Excel.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:pdvsa
ID: 40367297
I would be looking for something where I can upload say 200 records with due dates and a description and upload directly into the calender somehow and not by copy and paste
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40367302
do you know how to create a list in sharepoint?
0
 

Author Comment

by:pdvsa
ID: 40367481
I do not know how to do this.
0
 

Author Comment

by:pdvsa
ID: 40368127
If I create a list then is there some automation with communicating with the calendar?  Thank you
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40368171
i do not understand, what do you mean by automation,  based on your current skill level, i think best would be that every time you would update sharepoint list from excel via copy and paste.

if you mean automation like directly, with no human intervention then that is too advanced , i am not saying it is not possible, it is but require certain knowledge Windows Server FCI (File Classification Infrastructure)
0
 

Author Comment

by:pdvsa
ID: 40368792
Hello Professorjimjam,
Sorry but I don't completely understand what you mean here:
<i think best would be that every time you would update sharepoint list from excel via copy and paste.

thank you
0
 

Author Comment

by:pdvsa
ID: 40370825
Hi, let me know if you have a response...thank you
0
 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40374285
there below youtube will teach you how to export task list from excel to SharePoint.

http://www.youtube.com/watch?v=vay-J97xl44


the next link ave a very good free microsoft add-in that for syncronisation between excel and sharepoint list.

you need to know a little bit about how to use an add-in.  the add-in activation is based on the tables contextual tab.

here is the link http://rstagg.com/2010/04/13/how-to-bulk-upload-and-synchronize-data-into-sharepoint-using-the-excel-add-in-and-sharepoint-designer-workflows/
0
 

Author Closing Comment

by:pdvsa
ID: 40374987
thank you
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question