Categories
View Replies (22)

Resolved import shows blank screen and fails to run

  1. johnf
    johnf
  2. RO CSVI
  3. Wednesday, 16 September 2020
  4.  Subscribe via email
CSVI version: 7.17.0
Joomla version: 3.9.21
PHP version: 7.3.22

I am in the process of migrating an existing website to a new server. Currently the new server is running under an IP address only as I am not transferring the domain name until setup and configuration is complete and I have finished testing the new site. I have quite a few import routines that I created using CSVI and nearly all of them work fine on the new site as well as the old site. However, there are two import routines that read the same source file on the new site and both fail to run. They continue to work on the original site. The only difference I can spot is that the Joomla version on the original site is 3.8.18.

I have attached the debug log (which stops at the first record) and a copy of one the templates involved. I will say that you helped solve an issue with this source file over a year ago and it is documented in this forum - it should be easy to find as I only have two previous threads on this forum. Here is a link to the source file

Thanks,

John
Attachments (2)
csvi_templates_162.214.145.66_20200916.xml
com_csvi.log.12.zip
0
Responses (22)
johnf
johnf
Accepted Answer Pending Moderation
Hi Tharuna,

Thank you for your quick response. Based on your answer I have a couple of questions.

First, when I click the Advanced button from the Source tab it only toggles visibility of the Delete After Import field. I do not see an Encode URL option. I am using the latest version of CSVI. Where is the Encode URL option?

Second, my source file has an XLS extension and when I download it from the site I linked to above and then open it with LibreOffice Calc (Spreadsheet) it opens perfectly without the need for any of the import setup (delimiter definition, etc) as it would with a CSV file. Even stranger is the fact that on my original site with the same XLS and the exact same template, the file is processed without a problem using the XLS option in CSVI. Most importantly, why would I choose CSV as the file type when it I am trying to import a file that is clearly an XLS file? This seems confusing and counterintuitive. I did notice that by choosing the 'Take from file' option in the Use file extension field I no longer see the blank screen but receive a message saying that my source file is '...not a readable file'.

I included the template again in this email because I am concerned that perhaps I sent the incorrect template the first time. (I am very confused by the CSV/XLS issue.)

Thanks for your help.

Kind regards,

John
Attachments (1)
csvi_templates_162.214.145.66_20200917.xml
  1. more than a month ago
  2. RO CSVI
  3. # 21
tharuna
tharuna
Accepted Answer Pending Moderation
Hello John,
The debug log did not have entries because of the error. So testing import with your template and import file, import says file cannot be read. I found few issues with template

1. On file tab set Use file extension to CSV instead of XLS. The source file link is getting CSV file and not XLS
2. On Source tab, click on Advanced button to see Encode URL setting, change it to No, save the template.

Run the import and check.
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. # 22
  • Page :
  • 1
  • 2


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