Author Topic: CSV import with images hosted on Dropbox  (Read 3870 times)

Offline timlight10

  • Full Member
  • ***
  • Posts: 124
  • Karma: +15/-1
    • View Profile
    • Dedicated Presentation Solutions
CSV import with images hosted on Dropbox
« on: April 03, 2021, 10:54:09 AM »
Hello, AbanteCart is not loading images that are hosted on Dropbox when performing a CSV file import. The links for example are https://www.dropbox.com/s/rtxa0ex3fksjebh/3.Aeon_Blue.jpg?dl=1. Any advice?

Offline timlight10

  • Full Member
  • ***
  • Posts: 124
  • Karma: +15/-1
    • View Profile
    • Dedicated Presentation Solutions
Re: CSV import with images hosted on Dropbox
« Reply #1 on: April 07, 2021, 09:34:00 PM »
Any ideas? This is what I see in the error log, but it's not very helpful...
2021-04-08 18:46:48 - Error: Unable to download file from https://www.dropbox.com/s/wcgcudl7izt9m5t/aeon_main_award745.jpg?raw=1
« Last Edit: April 08, 2021, 08:49:35 PM by timlight10 »

Offline timlight10

  • Full Member
  • ***
  • Posts: 124
  • Karma: +15/-1
    • View Profile
    • Dedicated Presentation Solutions
Re: CSV import with images hosted on Dropbox
« Reply #2 on: April 11, 2021, 03:33:45 PM »
Was unable to resolve with Dropbox, instead downloaded all of the files, FTPed up to my server and using some Excel formula manipulations, re-directed the upload to my local server.

Offline maxter

  • Full Member
  • ***
  • Posts: 228
  • Karma: +64/-0
    • View Profile
Re: CSV import with images hosted on Dropbox
« Reply #3 on: April 26, 2021, 06:54:28 AM »
Is the image URL that id on dropbox has a publick URL? Can you view it in the browser without login to dropbox? AbanteCart import can load images only from publick URLs.

Offline timlight10

  • Full Member
  • ***
  • Posts: 124
  • Karma: +15/-1
    • View Profile
    • Dedicated Presentation Solutions
Re: CSV import with images hosted on Dropbox
« Reply #4 on: April 26, 2021, 08:08:07 AM »
Yes and yes, go ahead and click the links and they will appear!

Offline maxter

  • Full Member
  • ***
  • Posts: 228
  • Karma: +64/-0
    • View Profile
Re: CSV import with images hosted on Dropbox
« Reply #5 on: April 26, 2021, 08:21:33 AM »
Very strange, could be something to do with URL itself or your server. I have done this before and it worked for me.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: CSV import with images hosted on Dropbox
« Reply #6 on: May 04, 2021, 02:43:02 AM »
Hello, AbanteCart is not loading images that are hosted on Dropbox when performing a CSV file import. The links for example are https://www.dropbox.com/s/rtxa0ex3fksjebh/3.Aeon_Blue.jpg?dl=1. Any advice?

Please share the CSV file with at least one product

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: CSV import with images hosted on Dropbox
« Reply #7 on: May 12, 2021, 01:26:19 AM »
Hello.
Please try to apply changes from this commit in 13.1 branch and import again.

Offline timlight10

  • Full Member
  • ***
  • Posts: 124
  • Karma: +15/-1
    • View Profile
    • Dedicated Presentation Solutions
Re: CSV import with images hosted on Dropbox
« Reply #8 on: January 04, 2022, 08:10:17 AM »
I was able to resolve this by applying the patched files in your previous post and by changing line 664 of import_process.php from
Code: [Select]
$image_basename = basename($source); to
Code: [Select]
$image_basename = basename($source,"?dl=1");
Thanks for your help, this is a real time saver in getting products updated and loaded to my store.

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: CSV import with images hosted on Dropbox
« Reply #9 on: January 04, 2022, 08:15:19 AM »
Thank you, timlight10

 

Powered by SMFPacks Social Login Mod