Solved

Upload Tasks into Sharepoint

Posted on 2014-10-07
12
145 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
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)

 

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
 

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
InfoPath 2013 4 75
Sharepoint 2010 Audit Logs 11 102
Licensing Sharepoint 2016 for developers 11 47
SharePoint List Calculated Field 4 35
A question that is asked often, is how to generate sequential numbers in InfoPath Forms. The best way to achieve this is to use a SQL database, along with a stored procedure and a web service to connect Forms Services to the DB. The first thing t…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

809 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