Solved

Upload Tasks into Sharepoint

Posted on 2014-10-07
12
162 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

624 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