1. iMbroidr
  2. RO CSVI
  3. Friday, 25 August 2017
  4.  Subscribe via email
I need to connect downloadable files stored in the vmfiles folder. If I use "import media," the items get added to the Media Library and everything looks correct when the media item is opened and viewed, but when the product is purchased, the files download as "0 bytes" To correct, I have to delete the files from the server, and then go into each media item and replace the files.

Also, I get an error after the import runs because csvi is trying to treat the files as images and is looking at the default image storage file.

What do I need to be doing instead?

Attaching a sample file and the log file.
csvi 7.2.3, joomla, 3.7.5, virtuemart 3.2.2
Accepted Answer Pending Moderation
Hello,

In your debug log I see the issue you have. images/stories/virtuemart/product//home/lindpyei/vmfiles/lgs069-colors.zip that is the problematic line. If the product files path is emtpy CSVI will use the default shown. There are 2 things you can do:
  1. Put in the product files path your path /home/lindpyei/vmfiles/ and in your import file you only need lgs069-colors.zip and CSVI will combine these two into the full path
  2. You can set the product path to / and keep the full path in your import file.
I believe the import should be OK after that. Let me know how it goes.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Thanks for your quick reply. I've been playing with this and I'm still not doing something right. Can you explain a little more please?

Where are you putting the product files path? Does that go in the import file or are you setting that in "Location product files" under General options on the Image tab? Isn't the latter just for images? I'm trying to add product ('for sale";) files?

Even when I set the product files to point to the vmfiles folder and don't include it in the import file, I still get the same error. (Error is sl;ight different this time since site is now on a different server but it's still appending extra path info.)

I can import images just fine, but downloadable "For Sale" media items are making me crazy.

Another wrinkle in the project - I've had to move my site to a new hosting company and all my product links have "broken" and the only way to correct them is to open each For Sale media and do a manual replace on each. I'm hoping I can do some import script to fix them (some 22K products). I think this is problem is with the Spiral Scripts plugin but I'm hoping to find a more automated fix.

Lindee
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Lindee,
Where are you putting the product files path? Does that go in the import file or are you setting that in "Location product files" under General options on the Image tab? Isn't the latter just for images? I'm trying to add product ('for sale";) files?

Yes, try putting the path in your import file. Since you are importing product files and not images you can try setting Process images to No on Images tab and set the full path for product in your import file like /mnt/data/vhosts/http://casite-780205.cloudaccess.net/vmfiles/lgs03601-details.pdf for file_url field.

Even when I set the product files to point to the vmfiles folder and don't include it in the import file, I still get the same error. (Error is sl;ight different this time since site is now on a different server but it's still appending extra path info.)

Yes it is because of the duplicate path in your product file. Try the solution i posted above and see if it works. Post the latest debug log and import file if you have issues.

Another wrinkle in the project - I've had to move my site to a new hosting company and all my product links have "broken" and the only way to correct them is to open each For Sale media and do a manual replace on each. I'm hoping I can do some import script to fix them (some 22K products). I think this is problem is with the Spiral Scripts plugin but I'm hoping to find a more automated fix.

You can import product_sku and product_url fields using VirtueMart product import. Did you try that? didn't that help?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!