I want to save excel PublishObjects to AWS S3. When I use Excel PublishObjects to C drive it works fine. When I use Excel PublishObjects to AWS S3 using a CloudberryDrive path the resulting HTTP response header says content type is Octet stream instead of HTML and the macro crashes. When Excel publishes the object to my local C drive and then I copy that directory to S3 using the file manager the HTML file has the correct HTML content type in its header when served.
The simplest solution here would be perhaps using Upload Rules that will set the correct headers for the files in question. Please keep us posted regarding the results.
The simplest solution here would be perhaps using Upload Rules that will set the correct headers for the files in question. Please keep us posted regarding the results.
Hi. I asked about this issue over in Stackoverflow, and the comment from an independent certified amazon developer was that the problem is likely to to do with Cloudberry as Amazon won't change the type.
That is correct, so you basically set it to the content type you are interested in and it should assign it properly. Now regarding changing it to octet i presume it is happening due to the way driver handles the files. We take a closer look at this issue with our R&D.
So I tried setting an upload rule from the "Managed Drive Options" . The rule sets uploaded files with suffix . html to be type text/html. However it doesn't change anything. I guess writing to a file on S3 from within Excel isn't seen as an upload.
Did you find a solution to this? Having the same problem. The upload rules seems to work when creating a new file. But if it's editing an existing file it seems to override text/html with application/octet-stream
You should be able to create a rule for this within the product. The issue with rules was addressed with the 180 version sometime ago. Can you verify what version you're running and if there was a reboot after the upgrade to 1.8? Also check your rules because if there are multiple rules for that file type, then only the first rule is applied on upload.
Thanks David. Yes that seems to have done the trick. My first rule where I was trying to apply it to only html files didn't seem to work. But the 2nd rule applying to all files when I was testing wasn't being applied.