Editing: Upload Files from a Local Machine to a SharePoint Document Library Automatically (DOS Command)

Title
From research I have found there are so many ways to upload files / documents from File server or from local desktop to SharePoint document library. There are lots of JavaScript available to achieve this goal. But using these methods end user definitely becomes crazy. Here I have used a very simple method which automatically uploads document from source folder to SharePoint document library. Following steps we have to implement to use this method. <ul style="padding-bottom: 0px; text-indent: 0px; margin: 0px; padding-left: 10px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;"> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">On your machine map a SharePoint site, make sure to create a mapped drive of SharePoint site (not a network place) </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">This will assign a letter to site (i.e. Z), and this will create a SharePoint site as a folder. </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">So now we have “Z” drive which contains our SharePoint site and all its content and when you navigate to any of the content make sure it will open a folder with “z:\content folder” (as simple as opening a local folder in C / D drive) </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">Now we have two local drives one is Source folder and one is SharePoint site. </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">Now run following command to check whether we are able to copy documents from one location to another (From local source folder to SharePoint site) </li> </ul> COPY “sourcefolder\filename” “destination (SharePoint Site)” Copy c:\Pratik\*.* z:\Documents <ul style="padding-bottom: 0px; text-indent: 0px; margin: 0px; padding-left: 10px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;"> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">(Above command will copy all files from “C:\Pratik” folder to SharePoint site) </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">If this will be done successfully then simply create a batch file which copies documents on a click </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">And to make this click automated put that batch file in windows task scheduler so that @ a specific time frame it will run and picks up document from local source folder and uploads it to SharePoint site. </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">You might face some issues while making map drive, to resolve it follow these steps </li> </ul> On Windows XP machine <ul style="padding-bottom: 0px; text-indent: 0px; margin: 0px; padding-left: 10px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;"> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">Right click “My Computer” > Map Network Drive </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">It will open a wizard, provide SharePoint site name with UNC path (i.e \\<a href="http://sitename/Folder" style="padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; font-family: inherit; color: #cc0000; font-size: 19px; vertical-align: baseline; padding-top: 0px;border: 0px;">sitename\Folder</a>) </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">If you will get any error please chec webclient is activated on the machine. </li> </ul> On Windows 7 machine <ul style="padding-bottom: 0px; text-indent: 0px; margin: 0px; padding-left: 10px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;"> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">Right click “My Computer” > Map Network Drive </li> <li style="padding-bottom: 0px; margin: 7px 0px 8px 10px; padding-left: 0px; padding-right: 0px; font-family: inherit; font-size: 12px; vertical-align: baseline; padding-top: 0px;border: 0px;">It will open a wizard, provide SharePoint site name same as you provide in explorer address bar (<a href="http://sitename/" style="padding-bottom: 0px; margin: 0px; padding-left: 0px; padding-right: 0px; font-family: inherit; color: #cc0000; font-size: 19px; vertical-align: baseline; padding-top: 0px;border: 0px;">http://sitename/</a>) </li> </ul> Suggations and feedbacks are always welcome J. Feel free to reach me n case of any issues.
Comment
Tags
Please add 5 and 6 and type the answer here:

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?