Categories
View Replies (3)

Resolved Small error found when exporting / importing templates

  1. anth
    anth
  2. RO CSVI
  3. Friday, 15 May 2026
  4.  Subscribe via email
I think I've found a bug!

I set up an export template in my dev site, then imported that template into my live site.
Then when trying to modify a core CSVI export file, I was confused why nothing was changing.
Turns out the imported template is still using the URL of the dev site! The local csvi files were being bypassed & since the dev site is still up, then the dev site files were being used.

There is no field in the joomla CSVI admin to see or edit the URL. I found it after inspecting the database - in:

_csvi_templates settings


BTW, I was editing: File / Export / Xlxs: Csvimproved.php
so that the exported xlsx file could have headers at the top of every page when printed

If anyone else wanted that, the code is:




public function write(string $processFile): void

	{

		$this->processCustomHeaderText();

		$this->processCustomImage();

		$this->processCustomFooterText();

	/* add headers to all print pages */

		$this->spreadSheet->getActiveSheet()->getPageSetup()->setRowsToRepeatAtTop(['1', '3']);



		$writer = new Xlsx($this->spreadSheet);

		$writer->save($processFile);



But its a hack so it would need to be re-edited after every update, of course. ... unless the developers include it in future release :-)
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Note that in my initial post on this topic, I mistakenly thought that the (wrong) 'URL' (local path) was the cause of the problems I was having. Actually the problem was fixed by just editing the new helper file in the new location. I'm not certain if that URL had any impact on the functionality at all. So that might have caused some confusion in my initial post.

Local path URL has no impact on the helper issue. The local path URL is used to save export file in given location.

But that URL was in the database & it (probably) shouldn't be (would an incorrect localpath change things? I really don't know).

That path has been saved in database when you backup and restored template.

Or it could be that the Backup / Restore template was never intended to be used to transfer templates to a different website!

Backup and restore template is to move templates from one site to another. That way all the settings are moved without doing it manually all over again.

So the Backup / Restore template function placed a localpath in the "settings" part of the _csvi_templates database table. If that's an issue, it might cause problems for people if they use the export/import to move templates between sites.

When we move templates with backup and restore RO CSVI will not know the new location so all settings are moved as it is. The issue would be when you run the export from live site instead of saving file in live site URL it will save in dev site.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # Permalink
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I set up an export template in my dev site, then imported that template into my live site.
Then when trying to modify a core CSVI export file, I was confused why nothing was changing.
Turns out the imported template is still using the URL of the dev site! The local csvi files were being bypassed & since the dev site is still up, then the dev site files were being used.

Is it import file URL on source tab? Can you explain more on this issue? I am not able to follow on which URL you are talking about.

But its a hack so it would need to be re-edited after every update, of course. ... unless the developers include it in future release :-)

Thank you for posting the fix. We will include this fix in our upcoming RO CSVI release. For now you can create it as a custom helper in RO CSVI so you don't have to hack the core.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 3 weeks ago
  2. RO CSVI
  3. # 1
anth
anth
Accepted Answer Pending Moderation
Yes my post was a bit muddled & I got some parts wrong. This might be a nothingburger.

When I was troubleshooting some modifications to an export file, I checked the debug log and saw an incorrect (localpath) URL:

[DEBUG] localpath: /home/customer/www/dev.mysite.com/public_html

This is a local path for my testing (dev) site. (I incorrectly called it a URL earlier) I had exported the template in the dev site and restored it in the live site.
(At the same time I read of the change in location of the helper files <- this was the real cause of the problem I was investigating.)

Note that in my initial post on this topic, I mistakenly thought that the (wrong) 'URL' (local path) was the cause of the problems I was having. Actually the problem was fixed by just editing the new helper file in the new location. I'm not certain if that URL had any impact on the functionality at all. So that might have caused some confusion in my initial post.

But that URL was in the database & it (probably) shouldn't be (would an incorrect localpath change things? I really don't know).

Or it could be that the Backup / Restore template was never intended to be used to transfer templates to a different website!

So the Backup / Restore template function placed a localpath in the "settings" part of the _csvi_templates database table. If that's an issue, it might cause problems for people if they use the export/import to move templates between sites.
  1. 2 weeks ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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