{"id":808,"date":"2011-12-21T17:33:19","date_gmt":"2011-12-21T16:33:19","guid":{"rendered":"http:\/\/blog.kodono.info\/wordpress\/?p=808"},"modified":"2013-04-05T10:39:41","modified_gmt":"2013-04-05T08:39:41","slug":"create-a-file-into-sharepoint-document-librairies-with-the-copy-asmx-web-service-javascript","status":"publish","type":"post","link":"https:\/\/blog.kodono.info\/wordpress\/2011\/12\/21\/create-a-file-into-sharepoint-document-librairies-with-the-copy-asmx-web-service-javascript\/","title":{"rendered":"Create a file into Sharepoint document librairies with the Copy.asmx web service [Javascript]"},"content":{"rendered":"
This is the English version of my previous article<\/em><\/strong><\/p>\n

EDIT:<\/strong> I’ve created a JavaScript API for Sharepoint that handles the file creation. Just look at http:\/\/aymkdn.github.com\/SharepointPlus\/symbols\/%24SP%28%29.html#.createFile<\/a><\/p>\n

Did you know it’s possible to create a file from scratch and to add it into a shared documents library of Sharepoint, and only with Javascript ?<\/p>\n

To do it we’ll use the “copy.asmx” web service with the “CopyIntoItems” function.
\nIf you check http:\/\/your_sharepoint\/_vti_bin\/copy.asmx?op=CopyIntoItems<\/strong> you’ll see that we have several details about the “CopyIntoItems” function. Unfortunately it’s very difficult to find any information regarding this on the Web, and specially for Javascript…<\/p>\n

So, here is the solution to create a file, e.g. an Excel file (.xls) with a regular HTML table, and we’re going to save it to this library: “http:\/\/your_sharepoint\/Shared Documents\/” (Note: I’m using jQuery for the AJAX requests).<\/p>\n

\r\n\/\/ The file content must be encoded into Base64. To do it I use the function available on my blog (http:\/\/blog.kodono.info\/wordpress\/2011\/07\/27\/midi-code-encoder-decoder-en-base64-pour-javascript-programmation\/)\r\nfunction encode_b64(a,b,c,d,e,f){b=\"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+\/\";c='=';for(d=f='';e&=3,a.charAt(d++)||(b=';=',e);f+=b.charAt(63&c>>++e*2))c=c<<8|a.charCodeAt(d-=!e);return f}\r\n\r\n\/\/ \"Upload\" is the name of our function to do the job\r\n\/\/ txtContent is a plain text, the content of our file\r\n\/\/ destinationUrl is the full path URL to the document library (with the filename included)\r\nfunction Upload(txtContent, destinationUrl) {\r\n    var jsStream = encode_b64(txtContent);\r\n    var soapEnv  = "<?xml version=\\"1.0\\" encoding=\\"utf-8\\"?>"\r\n                  +"<soap:Envelope xmlns:xsi=\\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\\" xmlns:xsd=\\"http:\/\/www.w3.org\/2001\/XMLSchema\\" xmlns:soap=\\"http:\/\/schemas.xmlsoap.org\/soap\/envelope\/\\">"\r\n                  +"<soap:Body>"\r\n                  +"<CopyIntoItems xmlns=\\"http:\/\/schemas.microsoft.com\/sharepoint\/soap\/\\">"\r\n                  +"<SourceUrl>http:\/\/null<\/SourceUrl>"\r\n                  +"<DestinationUrls><string>"+destinationUrl+"<\/string><\/DestinationUrls>"\r\n                  +"<Fields><FieldInformation Type='File' \/><\/Fields>"\r\n                  +"<Stream>"+jsStream+"<\/Stream>"\r\n                  +"<\/CopyIntoItems>"\r\n                  +"<\/soap:Body>"\r\n                  +"<\/soap:Envelope>";\r\n    jQuery.ajax({\r\n        url: "http:\/\/your_sharepoint\/_vti_bin\/copy.asmx",\r\n        type: "POST",\r\n        dataType: "xml",\r\n        data: soapEnv,\r\n        beforeSend: function(xhr) { xhr.setRequestHeader('SOAPAction', 'http:\/\/schemas.microsoft.com\/sharepoint\/soap\/CopyIntoItems'); },\r\n        contentType: "text\/xml; charset=\\"utf-8\\""\r\n    });\r\n}\r\n\r\nUpload(\"<html><table><tr><th>Colonne 1<\/th><th>Colonne B<\/th><\/tr><tr><td>Total:<\/td><td>1500<\/td><\/tr><\/table><\/html>\",\"http:\/\/your_sharepoint\/Shared Documents\/test.xls\");\r\n<\/pre>\n
Then, when you’ll click on the new “test.xls” file, your web browser will want to open it with Excel. MS Excel should show you a warning message, but just click YES and you’ll see your table inside the sheet !<\/p>\n
Of course you can create any type of files (.txt, .jpg, .doc, …) and with any content.<\/p>\n
Related links:<\/p>\n