hrdfsique wrote:Glenn...
I've recreated Glenn's issue and there is indeed an issue.
Maybe someone can help with why this isn't working on production servers?
I'll keep at it until someone else beats me to it.
Until then, if you just want to get your site up (which is my motivation) then run the code on your local iis server and then update your website from your local files.
As far as database, you can connect to a remote database from your local iis or connect to local database and then update your remote. I would recommend the later as this gives backups.
hrdfsique -
I don't actually have my store files saved locally, just a test site that I use for testing this stuff. I installed my live site direct to my website (probably a silly thing to do). I also don't have my database saved locally and at present don't know how to get a copy of it to my computer. I do of course take backups of both my site and database, but my database server does not allow me to save the database to my PC.
I have been playing around with this and this is the outcome.
1. I downloaded all my web server files.
2. I modified my connection string to point to my live database, but created a backup first!
3. I then replaced the three "Nop.BusinessLogic" files in my local bin folder with the ones from yours.
4. I also modified the xls to point to the correct path on my PC.
5. Then I launched the site from VWD (I haven't been using iis either)
Now when I build my site in VWD and it launches, when I upload the xls it creates the products and adds the thumb nail image. It also updates this on my live site so when I go to my live store the products are there too, with the images :o)
I don't really know how it is doing this as I have not uploaded any files to the web, i.e. "Nop.BusinessLogic"/bin files. I gather it is doing this through the connectionstrings file. However this has made me very happy! Ideally I now need to get a full copy of my live website files and database so I can do all of these changes locally and then just upload both to my server when complete.
I Hope this helps. Thanks a lot for your help and I will keep an eye on the post for updates, as I am sure I will want to be able to add multiple pictures for single products soon.
Thanks again
Glenn.