Categories
View Replies (25)

Resolved Importing List of Images (imagelist) 404

  1. centervanliempd
    centervanliempd
  2. RO CSVI
  3. Wednesday, 04 October 2023
  4.  Subscribe via email
Hi support,

Really enjoying the RO CSVI module, I think I am just scratching the surface of this amazing software.

I am having a particular problem importing a list of images to create a gallery (using yootheme pagebuilder)

When having some image filenames in the CSV file that are not on existing in the file system, the gallery returns a 404 page.
Now, when I resave the Joomla article, somehow the image list is updated and point to the files that do exist in the file system and the page returns a 200 OK

The filenames that not exist in the file system are not added to the file list upon import, which is a good thing I believe.

Is there some way to validate if images exists or maybe there is another approach avoiding the 404 pages after import.

I hope the screenshot give you som more insight of this particular issue.

kind regards and thanks :)
Center
Attachments (4)
only the existing files in list.png only the existing files in list.png
custom field.png custom field.png
file system joomla.png file system joomla.png
list images csv.png list images csv.png
0
Responses (25)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
When having some image filenames in the CSV file that are not on existing in the file system, the gallery returns a 404 page.
Now, when I resave the Joomla article, somehow the image list is updated and point to the files that do exist in the file system and the page returns a 200 OK

Do you have images with these names already saved in your system? That is the way I can see Joomla articles can be linked to existing images.

Is there some way to validate if images exists or maybe there is another approach avoiding the 404 pages after import.

Please post the import debug log to check? To get the debug log see How to collect debug information? document. Also post the import file you are using.
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. # 1
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
Hello Tharuna,

Do you have images with these names already saved in your system? That is the way I can see Joomla articles can be linked to existing images.

yes, image files are saved in the system.

However, it can occur that the data contains some filenames that are not saved in the file system (please see column gallery)

When this is the case the the article returns a 404 noting "0 The image file does not exist."

I have attached the requested files.
The CSV file has one column named gallery that pulls in the image list data.

I also attached a CSV and log with one affected article, LOG com_csvi.log.106.zip and CSV LTC4-16742.csv

https://dev.centersites.nl/producten/metaalbewerkingsmachines/plaatbewerking/hefboomplaatschaar-hu-10-hs-16742
If I resave this article in the Joomla admin the page renders a 200 again.

imported image list data: 16742.jpg|16742a.jpg|16742b.jpg|16742c.jpg|16742d.jpg
files on the system are: 16742.jpg 16742b.jpg and 16742c.jpg

ik hope you can pin point the issue with this extra information.

kind regards
Center
Attachments (5)
com_csvi.log.105.zip
LTC4.csv
LTC4-16742.csv
com_csvi.log.106.zip
Scherm­afbeelding 2023-10-04 om 14.54.16.png Scherm­afbeelding 2023-10-04 om 14.54.16.png
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
Thank you for the files. When we import ImageList there was no check to see if the image actually exists. With the attached patch file I have added a check to check if image exists and then insert into database. That way you will not see "0 The image file does not exist." in frontend. Load the attached patch file and run the import again. See if it solves the issue.
Attachments (1)
patch_cf_2023_10_05.zip
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
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
WOW! great support providing patches like this, however it is not yet working as expected.

I applied the patch and reimported the above attached file LTC4-16742.CSV and got a 500 error in the attached screenshot.
Also attached the log file.

Is it possible to remove the patch from the Joomla admin for further testing?

kind regards,
Center
Attachments (2)
error after patch.png error after patch.png
com_csvi.log.111.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
I applied the patch and reimported the above attached file LTC4-16742.CSV and got a 500 error in the attached screenshot.
Also attached the log file.

Log file will not give us details of 500 error. We need to know what is causing 500 error so to fix it. From Joomla configuration page in backend on Server tab set Error reporting to maximum and save the config. Run the import and check if you get details of the error. Another way if to check server error logs and see if you can get details of 500 error. Post the details here so I can check.

Is it possible to remove the patch from the Joomla admin for further testing?

Yes, you can load the attached modified patch file which will reset the fix. But I would suggest to send us details on 500 error so we can fix it.
Attachments (1)
patch_2023_10_06.zip
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. # 5
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
Hello Tharuna,

Setting the Error reporting to maximum does show som deprecated code in the module, i'vv attached a screen shot.
Also attached some logs for you to inspect.

Running the template with max error reporting does show the same 500 popup
TitleThe 500 internal server error link in the popup

kind regards
Center
Attachments (4)
import template.png import template.png
error after patch.png error after patch.png
error logs.zip
all logs on server.png all logs on server.png
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
I found the cause for 500 error. We have code modified which will be coming with upcoming RO CSVI release. The patch file sent earlier has code for ImageList field but the changes in other files should also be included so import runs without any error. Please load the attached modified patch file and run the import. Let me know on how it goes.
Attachments (1)
patch_cf_2023_10_06.zip
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. # 7
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
Great news, it makes my day!
Nice to hear that the 'bug' gets fixed with the next released :D

Should I reset the former patch first or just overwrite it ?

kind regards
Center
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
Should I reset the former patch first or just overwrite it ?

You can overwrite it by loading the last patch file.
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. # 9
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
Wonderful!

tested re-importing the affected article with succes!

https://dev.centersites.nl/producten/metaalbewerkingsmachines/plaatbewerking
no more 404

thank a lot, I will drop a ****** review on the Joomla extension page


Kind regards :D
Center
Attachments (2)
new-notices.png new-notices.png
patch loaded.png patch loaded.png
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
Thank you for confirming patch is working. This fix will be included in upcoming RO CSVI release.
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. # 11
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
Hi Tharuna,

I believe I have found a bug in the latest patch, it seems that the field with the pipe character separated list with images is not imported at all! And hence, no 404 pages.

Attached the import file with list data, and an export file from right after importing shows no list data, please take a look at the column 'gallery'

kind regards
Center
Attachments (3)
reimport meta LTC.csv
CSVI_LTC Joomla Content Export_17-10-2023_22.09.csv
com_csvi.log.132.zip
  1. more than a month ago
  2. RO CSVI
  3. # 12
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
I see error "Local file images/15431-draaibank-LTC-DR300-2-Vario-a.jpg does not exist" for images in the debug log. Looks like images you are importing are missing in the given location. Check if you have images in the given path.
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. # 13
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
Hello Tharuna

The custom field (imagelist) points to the folder images/import in the configuration

Despite the fact that the picture exists in this location, should not matter in my humble opinion.

The import template just fills this list with values from the csv data and selects those list items that belong to the article I believe.
Or did the patch do the check "if image exist"?

I did a reimport white the files also available in the images folder but no gallery data is attached to the list items in my custom field.

please see attached screenshots :-)

kind regards
Center
Attachments (6)
import.png import.png
datapreview.png datapreview.png
all files avalable in images folder.png all files avalable in images folder.png
items not selected.png items not selected.png
images avalable in import folder.png images avalable in import folder.png
images avalable in import folder.png images avalable in import folder.png
  1. more than a month ago
  2. RO CSVI
  3. # 14
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
The custom field (imagelist) points to the folder images/import in the configuration

Despite the fact that the picture exists in this location, should not matter in my humble opinion.

By default images are imported from path images/. If the path is different from this then you need to set the path in Import template settings on Image tab. See attached screenshot. Did you try that?

The import template just fills this list with values from the csv data and selects those list items that belong to the article I believe.
Or did the patch do the check "if image exist"?

Yes the patch also checks if image exists and then link it to the article.

I did a reimport white the files also available in the images folder but no gallery data is attached to the list items in my custom field.

Please post the latest import debug log to check. To get the debug log see How to collect debug information? document.
Attachments (1)
Screenshot 2023-10-19 at 6.12.58 PM.png Screenshot 2023-10-19 at 6.12.58 PM.png
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. # 15
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
Hi Tharuna

Some confusion on my side.

Before i used a path before the main and intro images in my csv file. (import/filename.jpg)
Did a reimport with a csv with no path's, just de image filenames as attached.

I think i am all set now and did add the import folder name into the template configuration.
The import still 'complains' that the files cannot be found but i am sure their there...

What do you suggest me to do?
1 add the path's in the CSV file to be imported (main image, intro image, filelist images)
2 only have the filenames in the CSV file to be imported and config the path's in Joomla

attached some screenshots of what i am trying to do.

kind regards
Center
Attachments (7)
import-15431 no path.csv
log after import.png log after import.png
location image file.png location image file.png
no path used in import file.png no path used in import file.png
all 15431 images in import folder.png all 15431 images in import folder.png
article 15431 no images.png article 15431 no images.png
com_csvi.log.136.zip
  1. more than a month ago
  2. RO CSVI
  3. # 16
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
Images are not found in the given path and so you see the error "File not found: /data/sites/web/centersitesnl/subsites/dev.centersites.nl/import/15431-draaibank-LTC-DR300-2-Vario.jpg" for images. Are you sure path is correct? Send us Joomla administrator login details and (S)FTP details to check. Will check what is going wrong with image path. You can post the details on Site Details tab under your reply.
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. # 17
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
What do you suggest me to do?
1 add the path's in the CSV file to be imported (main image, intro image, filelist images)
2 only have the filenames in the CSV file to be imported and config the path's in Joomla

You can do both ways and result is same considering the image exists in given path. In your case RO CSVI does not find the image in the path and so you see the error.
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. # 18
centervanliempd
centervanliempd
Accepted Answer Pending Moderation
Great that you want to take a live look at the issue... credentials should work
  1. more than a month ago
  2. RO CSVI
  3. # 19
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Center,
Thank you for posting the credentials. Will look into the issue and get back with an update.
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. # 20
  • Page :
  • 1
  • 2


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