Export does not handle long view names #946

New Issue

Closed

opened 2022-08-05 22:59:37 +00:00 by Chris Paschen · 3 comments

Chris Paschen commented

2022-08-05 22:59:37 +00:00

Member

Steps to reproduce the issue

Create a component with a view name that is longer than 31 characters
(ex. "PROFILE Status Notification Types")
Compile, Run
Add some entries into the view
Select some entries from the admin list view and select EXPORT DATA button

Expected result

Data is exported to a file.

Actual result

Error is displayed:

Maximum 31 characters allowed in sheet title.
C:\wamp64\www\COMPONENT\libraries\phpspreadsheet\vendor\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Worksheet\Worksheet.php:470

System information (as much as possible)

OS Name & Version: WAMP
MySql Version: 5.7.31
Apache Version: 2.4.46
PHP Version: 7.4.9
Joomla Version: 3.10.10
JCB Version: 3.1.4
Browser: Firefox developer

Additional comments

It appears that it is using the 'System Name' of the admin view.
Maybe if the name is > 31 charachters, then use the 'Name (list of records)' or possibly just cut-off at 31 characters, rather than error out.

### Steps to reproduce the issue Create a component with a view name that is longer than 31 characters (ex. "PROFILE Status Notification Types") Compile, Run Add some entries into the view Select some entries from the admin list view and select EXPORT DATA button ### Expected result Data is exported to a file. ### Actual result Error is displayed: Maximum 31 characters allowed in sheet title. C:\wamp64\www\COMPONENT\libraries\phpspreadsheet\vendor\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Worksheet\Worksheet.php:470 ### System information (as much as possible) - OS Name & Version: WAMP - MySql Version: 5.7.31 - Apache Version: 2.4.46 - PHP Version: 7.4.9 - Joomla Version: 3.10.10 - JCB Version: 3.1.4 - Browser: Firefox developer ### Additional comments It appears that it is using the 'System Name' of the admin view. Maybe if the name is > 31 charachters, then use the 'Name (list of records)' or possibly just cut-off at 31 characters, rather than error out.

Chris Paschen commented

2022-08-05 23:00:52 +00:00

Author

Member

BTW / FYI ... this is a pretty low priority issue because it can be resolved by just making the System Name shorter; however, some complex components really need more detailed (longer) System Names to make it easier to work with during development.

Llewellyn commented

2022-08-15 08:11:18 +00:00

Owner

Far as I know this is a Joomla/Database limitation, in all honesty I have never ran into this issue. Been building many many extentions and with many clients and have never had this issue.

So at this point we will not be making any changes in this area, maybe once in J4 we can come back to this... maybe.

Far as I know this is a Joomla/Database limitation, in all honesty I have never ran into this issue. Been building many many extentions and with many clients and have never had this issue. So at this point we will not be making any changes in this area, maybe once in J4 we can come back to this... maybe.

Llewellyn closed this issue

2022-08-15 08:11:19 +00:00

Chris Paschen commented

2022-08-15 15:11:21 +00:00

Author

Member

You're just not as 'wordy' as me :-)

I can live with it as it's pretty easy to just rename the view of the file as it's only that field that causes the problem.

(Just strange that it is 31 charachters, a rather odd length)

You're just not as 'wordy' as me :-) I can live with it as it's pretty easy to just rename the view of the file as it's only that field that causes the problem. (Just strange that it is 31 charachters, a rather odd length)