Solved

Uploading a file to SharePoint

Posted on 2013-05-16
5
252 Views
Last Modified: 2014-09-30
I have a SQL database where I export one the tables to XML and then use the XML files as Data Source on a few list forms.

I was able to use C# to pull and create the XML from the SQL table, but I'm having issues uploading the file through code.

I've tried Powershell and C# using WebDav. Tried the SharePoint Client Object as well as SharePoint web services.

Unfortunately, I do not have access to SharePoint to make any changes, so I'm stuck putting it together on the client side. I'm the owner of the SharePoint site i'm trying to upload it too.

I've received a 405 Method Not Allowed with WebDav and "The request failed with an empty" response using Web Services. I tried using SPWeb, but I received an invalid url error.

I think one of the problems may be that night site is a subsite with this url and probably security related as well. My office has proxy and web filtering. They use Blue Coat.

http://server.com/sites/subsite/mySite

Any other suggestions on what other methods I can try?
0
Comment
Question by:ajl7519
  • 2
5 Comments
 
LVL 15

Expert Comment

by:colly92002
ID: 39174225
You can do a HTTP PUT command to upload to Sharepoint.
Example here (MOSS version but still relevent with later versions):
http://msdn.microsoft.com/en-us/library/dd902097%28v=office.12%29.aspx

This wont set meta data but you can use the the lists web service for this.
0
 
LVL 1

Author Comment

by:ajl7519
ID: 39175252
Thanks for the reply. Still getting the 405 error. I'm wonding if I need to do via ASP and have it Open IE and run the code when IE loads the page. Just guessing here. My code below modified from the page in a Console project. Was getting a DirectoryNotFound exception so I used a file path instead.

namespace UploadToSharePoint
{
    class Program
    {
        static void Main(string[] args)
        {
            UploadFileToSharePoint();
        }
        static void UploadFileToSharePoint()
        {
            WebResponse response = null;
            string UploadedFilePath = @"C:\Reports\test.xml";
            string SharePointPath = "https://server/list/test.xml";
            try
            {
                // Create a PUT Web request to upload the file.
                WebRequest request = WebRequest.Create(SharePointPath);

                request.Credentials = CredentialCache.DefaultCredentials;
                request.Method = "PUT";

                // Allocate a 1 KB buffer to transfer the file contents.
                // You can adjust the buffer size as needed, depending on
                // the number and size of files being uploaded.
                byte[] buffer = new byte[1024];

                // Write the contents of the local file to the
                // request stream.
                using (Stream stream = request.GetRequestStream())
                using (FileStream fsWorkbook = File.Open(UploadedFilePath,
                    FileMode.Open, FileAccess.Read))
                {
                    int i = fsWorkbook.Read(buffer, 0, buffer.Length);

                    while (i > 0)
                    {
                        stream.Write(buffer, 0, i);
                        i = fsWorkbook.Read(buffer, 0, buffer.Length);
                    }
                }

                // Make the PUT request.
                response = request.GetResponse();
            }
            catch (DirectoryNotFoundException e)
            {
               //Result will be: Could not find a part of the path "C:\incorrect\path".
                Console.WriteLine(e.Message); 
                //Result will be: C:\incorrect\path
                Console.WriteLine(e.Message.Replace("Could not find a part of the path \"","").Replace("\".","")); 
            }
            finally
            {
                response.Close();
            }
        }

    }
}

Open in new window

0
 
LVL 1

Accepted Solution

by:
ajl7519 earned 0 total points
ID: 39175646
I found the issue using fiddler. I need to post login credentials (twice actually). Worked for the first one, but not the second.
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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Login 17 40
SharePoint List Calculated Field 4 22
C#.NET and microsoft certification. 3 34
Powercli - Changing network adapter after customization has finished. Script 2 13
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

895 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

14 Experts available now in Live!

Get 1:1 Help Now