1. cappu
  2. RO CSVI
  3. Tuesday, 09 May 2023
  4.  Subscribe via email
Hey, for soem reason I cannot Preview XLSX (or CSV) data with the latest RO 8.7.0: I do get the following error message:

The filename /home/www/<mydomain>/tmp/com_csvi/2843977181/amiravita-pflegeanbieter-v02-20230509.xlsx is not recognised as an OLE file

What am I missing?
Thanks for a hint.
Kind regards,
Bernhard

[Edit] The php.ini
upload_max_filesize = 150M
post_max_size = 150M
max_file_uploads=50
max_input_vars=3000
max_execution_time=60
Attachments (1)
Accepted Answer Pending Moderation
Hello,
There is no problem in loading the attached file. It loads fine with RO CSVI 8.7.0 version. See attached screenshot. May I know the Joomla version you are using? Can you post the template XML you are using? To get the template XML file, in RO CSVI maintenance menu select RO CSVI on first option, backup templates on second option, select the import template and download the XML file. Post the XML file.
Attachments (1)
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
Accepted Answer Pending Moderation
Hi Tharuna,
thanks for your help. I user the latest in Joomla 4.3.1
See attachment for the requested XML file. There are two templates. All of them share the same problem.
Kind regards,
Bernhard
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Bernhard,

The OLE error comes from a problem with reading the XLSX file. Both Tharuna and I cannot reproduce this on our local machines but I cannot reproduce it either on our demo site. You can test it there yourself as well if you want, the demo site is at https://demo4.rolandd.com/administrator or use this direct link to the content import template https://demo4.rolandd.com/administrator/index.php?option=com_csvi&task=imports.selectsource&csvi_template_id=383

You said you cannot preview CSV files either, what error do you get there?

Which PHP version are you running?

Let me know and we can check further.
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. # 3
Accepted Answer Pending Moderation
Hi RolandD,
I use PHP 8.1 on a new Web-Hosting environment. I used RO CSVI successfully a couple of times. -
Guess I have to contact the Support on this. -
Thanks for your help so far.
Kind regards,
Bernhard
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Bernhard,

Let us know if you have any further questions, we will be happy to help.
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. # 5
Accepted Answer Pending Moderation
Hi RolnadD,
Support could not help. Temporarily disabled and removed diverse Extensions (Admin Tools, RSFirewall, etc.). ... No success.
Tested on another Joomla instance on the same Web-Hosting space - no problem there. :o
The only difference is, that this is a Migration project from Joomla 3.x.
Any ideas?
Thanks and kind regards,
Bernhard
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hi RolandD,
checking the code I noticed that the error is cause by this routine:

/administrator/components/com_csvi/assets/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Shared/OLERead.php -> read()

/// Edit: It is called by

/administrator/components/com_csvi/assets/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Xls.php

(Why it does not call the Xlsx.php?)
/// End Edit
It is just called on this project but seems to get bypassed on other Joomla instances, where there aren't errors.
Any ideas?
Thanks for any hint.
Kind regards,
Bernhard
  1. more than a month ago
  2. RO CSVI
  3. # 7
Accepted Answer Pending Moderation
Hello Bernhard,

So I have been doing more testing to see if I can reproduce it. One thing that came to mind was to enforce XLS use during import. This resulted in the error you see about the OLE object. Which is correct because an XLSX file is not the same as an XLS file. An XLSX file is actually just a zipfile with files in it. You can even see that if you rename the file to .zip.

In the template you posted I saw that XLSX is set to use as file extension. Since your file has the correct extension, set this to Take from file. Do you get the same error in that case?

(Why it does not call the Xlsx.php?)
RO CSVI does actually tell which reader to create in the file administrator/components/com_csvi/helper/file/import/xls.php on line 73. On line 72 it gets the file extension to use. Perhaps you can check what value you get there. That should be xlsx.

I do wonder what you get on that line 73. Let me know what you find.
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. # 8
Accepted Answer Pending Moderation
Hi RolandD,

OMG. I guess I could solve the problem. I defined a template for XLS - and should have defined it for XLST. - For some reason I missed that this is crucial on defining the template. Using the correct template type everything works perfect :)

As far as I understand it is not possible to change that type afterwards. - Maybe it would be an improvement to print out the template type in the Template overview table and/or inside the Template definition form, as well.

Anyways, thanks for your help and time ... and this great extension.

Kind regards,
Bernhard
  1. more than a month ago
  2. RO CSVI
  3. # 9
Accepted Answer Pending Moderation
Hello Bernhard,

For some reason I missed that this is crucial on defining the template.
You should not have to change this setting and just leave it to Take from file, in that case it does not matter if you import a different type of file. This is also why this option is hidden by default and only shown when you click the Advanced button.

As far as I understand it is not possible to change that type afterwards.
You can definitely change the Use file extension afterwards, the option is a list of options you can change any time.

Maybe it would be an improvement to print out the template type in the Template overview table and/or inside the Template definition form, as well.
I do not think we will add this as the majority of the users has this set to Take from file as there is no need to change this unless you get a file with a non-default file-extension.

Anyways, thanks for your help and time ... and this great extension.
Thank you.
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. # 10
  • Page :
  • 1


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