Solved

Upload Tasks into Sharepoint

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

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
 

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 25

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
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.

 

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 25

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 25

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

27 Experts available now in Live!

Get 1:1 Help Now