Solved

Upload Tasks into Sharepoint

Posted on 2014-10-07
12
133 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 25

Expert Comment

by:ProfessorJimJam
Comment Utility
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 25

Expert Comment

by:ProfessorJimJam
Comment Utility
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
Comment Utility
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
 

Author Comment

by:pdvsa
Comment Utility
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 25

Expert Comment

by:ProfessorJimJam
Comment Utility
do you know how to create a list in sharepoint?
0
 

Author Comment

by:pdvsa
Comment Utility
I do not know how to do this.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:pdvsa
Comment Utility
If I create a list then is there some automation with communicating with the calendar?  Thank you
0
 
LVL 25

Expert Comment

by:ProfessorJimJam
Comment Utility
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
Comment Utility
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
Comment Utility
Hi, let me know if you have a response...thank you
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
Comment Utility
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
Comment Utility
thank you
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Instant VM Recovery 4 73
Page structure in SharePoint 2013 9 46
SharePoint integration. 1 36
Sharepoint 3.0 migration 4 38
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now