(~) multipart upload from excel VBA
I am trying to do a multi part upload of a file from a excel VBA to a webservice.
I have produced the code in the attached file based on a link I found on the internet.
This works for a text file but for an xls file I get the error below.
Now the developer of the webservice can upload either of my test files text or xls using something like
<form enctype="multipart/form-da
<input name="file" type="file" />
<input type="submit" value="Upload File" />
</form>
and as he can get it to work is not being particularly helpful.
Any ideas?
Attached also are the http string that is sent in each case.
TIA
uploadTest.vba.txt
httpouttext.txt
I have produced the code in the attached file based on a link I found on the internet.
This works for a text file but for an xls file I get the error below.
Now the developer of the webservice can upload either of my test files text or xls using something like
<form enctype="multipart/form-da
<input name="file" type="file" />
<input type="submit" value="Upload File" />
</form>
and as he can get it to work is not being particularly helpful.
Any ideas?
Attached also are the http string that is sent in each case.
TIA
uploadTest.vba.txt
"<!DOCTYPE HTML PUBLIC ""-//IETF//DTD HTML 2.0//EN"">
<html><head>
<title>500 Internal Server Error</title>
</head><body>
<h1>Internal Server Error</h1>
<p>The server encountered an internal error or
misconfiguration and was unable to complete
your request.</p>
<p>Please contact the server administrator,
root@localhost and inform them of the time the error occurred,
and anything you might have done that may have
caused the error.</p>
<p>More information about this error may be available
in the server error log.</p>
</body></html>
"
httpouttext.txt
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have you tried changing the file/content type?
You seem to be have a variable for the MIME type but you don't seem to use it and it only seems to be for text/xml anyway.
Shouldn't that be different for Excel files?
I'm not really an expert but when I've created code for downloading data to Excel I'm sure I've used something like application/excel or application/xls.
That of course is for downloading and there are other types - there might even be an xml 'type' for Excel, later versions of course.
PS When you mean the formatting is important what exactly do you mean?
You seem to be have a variable for the MIME type but you don't seem to use it and it only seems to be for text/xml anyway.
Shouldn't that be different for Excel files?
I'm not really an expert but when I've created code for downloading data to Excel I'm sure I've used something like application/excel or application/xls.
That of course is for downloading and there are other types - there might even be an xml 'type' for Excel, later versions of course.
PS When you mean the formatting is important what exactly do you mean?
ASKER
Yes tried various different mime-types and it is just the same text works but nothing else.
Formatting := excel formatting, column widths, date and number formats colouring etc etc
Formatting := excel formatting, column widths, date and number formats colouring etc etc
I must be missing something I think, you've declared and set a value ( for a variable called aMimeType but you don't seem to use it anywhere.
Also in this line of code:
strHttp = BuildFileUploadRequest(str
You seem to be passing "text/xml" as the value for the MimeType argument.
Also in this line of code:
strHttp = BuildFileUploadRequest(str
You seem to be passing "text/xml" as the value for the MimeType argument.
ASKER
imnorie
there may well be little buglets in the code this is still only a prototype but I have experimented with different mime-types and this has made no difference.
The mime-type does end up in the string that is sent as part of the post
"POST /services/ndb/?action=uplo
Host: admin.businessmonitor.uat
Content-Type: multipart/form-data, boundary=wKWSkuOUErwE2cBq0
Content-Length: 3625172
--wKWSkuOUErwE2cBq0v4HmQZv
Content-Disposition: form-data; name=""file""; filename=""C:\testfile.txt
Content-Type: image/bmp
this one was when i was testing an image which also did not work. Only text has been successful
If you can see that there is something wrong with th mime-type, please point it out
thanks. Still scratching my head
there may well be little buglets in the code this is still only a prototype but I have experimented with different mime-types and this has made no difference.
The mime-type does end up in the string that is sent as part of the post
"POST /services/ndb/?action=uplo
Host: admin.businessmonitor.uat
Content-Type: multipart/form-data, boundary=wKWSkuOUErwE2cBq0
Content-Length: 3625172
--wKWSkuOUErwE2cBq0v4HmQZv
Content-Disposition: form-data; name=""file""; filename=""C:\testfile.txt
Content-Type: image/bmp
this one was when i was testing an image which also did not work. Only text has been successful
If you can see that there is something wrong with th mime-type, please point it out
thanks. Still scratching my head
I'm getting confused here.
Is testfile.txt a bitmap file?
I can see that the MIME type is getting included but is it the right one for the file you are trying to upload?
Is testfile.txt a bitmap file?
I can see that the MIME type is getting included but is it the right one for the file you are trying to upload?
ASKER
I can see that the MIME type is getting included but is it the right one for the file you are trying to upload?
As far as uploading text files it doesn't seem to matter, text files upload ok whatever the mime type I include.
There seem to be a few different mime type for excel files. I have tried a few different ones but I believe application/vnd.ms-excel is the one I should use.
I have tried uploading other file types using the relevant mime type for each but all these fail
Sorry if this is confusing but I am trying lots of different things to get it to work.
Well I honestly can't think of anything else.
Who exactly 'developed' this webservice?
Who exactly 'developed' this webservice?
ASKER
Effectively a contractor based in Romania. I'll probably have to get my boss to lean on him a bit. But the thing is that it works for him posting in a unix environment so we can't test like for like but it does point to what I am generating. It is just a matter of identifying what is not quite right
Well, could that be it - UNIX?
It is kind of a completely different operating system, though I suppose most web stuff is supposed to be OS independent.
It is kind of a completely different operating system, though I suppose most web stuff is supposed to be OS independent.
ASKER
A webservice shouldn't know, or need to know, or care which OS created the request. However there may something subtly wrong with the request I am creating
ASKER
If I save an excel file with a txt extension and use text/xml mime type. it fails
so it seems that something in the content isn't being expected.
That may mean the content is wrong or I am not supplying the relevant informatiuon for the content to be expected.
But which and what?
so it seems that something in the content isn't being expected.
That may mean the content is wrong or I am not supplying the relevant informatiuon for the content to be expected.
But which and what?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Andy
Well done, I kind of thought it might be some sort of setting.
Well done, I kind of thought it might be some sort of setting.
ASKER
Thanks for your efforts
No problem - I'll admit I'm not quite an 'expert' with this sort of thing.
Can't even set up a 2 machine wireless network at home.:)
Can't even set up a 2 machine wireless network at home.:)
ASKER
I can upload a text file but not xls, doc, bmp. Basically anything that is not straightforward text.
It is just data in the xls but the formatting is important as they are to be used as xls files. It is not simply the data that is important. So yes the idead is to upload an entire file.
I suspect it must be something to do with the reading of the binary xl file into a string or putting that together with the rest of the multipart Post