Benchmarks
Plugin footprint 83% from 16 tests
Installer Passed 1 test
🔺 Critical test (weight: 50) | All plugins must install correctly, without throwing any errors, warnings, or notices
The plugin installed successfully, without throwing any errors or notices
Server metrics [RAM: ▲0.07MB] [CPU: ▼0.50ms] Passed 4 tests
An overview of server-side resources used by WP Excel 2 DB
This plugin has minimal impact on server resources
| Page | Memory (MB) | CPU Time (ms) |
|---|---|---|
| Home / | 3.53 ▲0.07 | 41.31 ▲3.64 |
| Dashboard /wp-admin | 3.37 ▲0.07 | 48.11 ▼2.07 |
| Posts /wp-admin/edit.php | 3.48 ▲0.13 | 46.45 ▲0.05 |
| Add New Post /wp-admin/post-new.php | 5.97 ▲0.08 | 86.28 ▼2.14 |
| Media Library /wp-admin/upload.php | 3.29 ▲0.06 | 33.77 ▲2.18 |
| Excel Uploader /wp-admin/options-general.php?page=media-selector | 3.28 | 33.49 |
Server storage [IO: ▲6.20MB] [DB: ▲0.00MB] Passed 3 tests
Analyzing filesystem and database footprints of this plugin
The plugin installed successfully
Filesystem: 286 new files
Database: no new tables, 6 new options
| New WordPress options |
|---|
| widget_recent-comments |
| theysaidso_admin_options |
| widget_theysaidso_widget |
| can_compress_scripts |
| db_upgraded |
| widget_recent-posts |
Browser metrics Passed 4 tests
WP Excel 2 DB: an overview of browser usage
This plugin has a minimal impact on browser resources
| Page | Nodes | Memory (MB) | Script (ms) | Layout (ms) |
|---|---|---|---|---|
| Home / | 2,916 ▲181 | 13.97 ▼0.41 | 8.69 ▲6.97 | 43.08 ▼6.22 |
| Dashboard /wp-admin | 2,214 ▲29 | 5.86 ▲0.00 | 120.15 ▲20.45 | 49.81 ▲7.49 |
| Posts /wp-admin/edit.php | 2,097 ▲26 | 2.02 ▼0.03 | 34.34 ▼1.46 | 35.14 ▼0.63 |
| Add New Post /wp-admin/post-new.php | 1,521 ▲4 | 23.35 ▲5.77 | 659.16 ▲35.08 | 61.89 ▲4.32 |
| Media Library /wp-admin/upload.php | 1,396 ▲5 | 4.29 ▲0.07 | 97.35 ▼1.45 | 42.18 ▼0.72 |
| Excel Uploader /wp-admin/options-general.php?page=media-selector | 960 | 3.00 | 39.02 | 22.20 |
Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 75% from 4 tests
🔸 Tests weight: 35 | The uninstall procedure must remove all plugin files and extra database tables
Please fix the following items
- Zombie WordPress options detected upon uninstall: 6 options
- theysaidso_admin_options
- can_compress_scripts
- widget_theysaidso_widget
- widget_recent-posts
- widget_recent-comments
- db_upgraded
Smoke tests 50% from 4 tests
Server-side errors Passed 1 test
🔹 Test weight: 20 | A shallow check that no server-side errors were triggered
The smoke test was a success, however most plugin functionality was not tested
SRP 0% from 2 tests
🔹 Tests weight: 20 | The single-responsibility principle: PHP files have to remain inert when accessed directly, throwing no errors and performing no actions
Almost there! Just fix the following items
- 2× GET requests to PHP files return non-empty strings:
- > /wp-content/plugins/wp-excel-2-db/public/partials/wp-excel-2-db-public-display.php
- > /wp-content/plugins/wp-excel-2-db/admin/partials/wp-excel-2-db-admin-display.php
- 101× PHP files trigger server-side errors or warnings when accessed directly (only 10 are shown):
- > PHP Fatal error
Uncaught Error: Class 'PHPExcel_Writer_Abstract' not found in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Writer/HTML.php:28
- > PHP Fatal error
Uncaught Error: Class 'PHPExcel_Shared_OLE_PPS' not found in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Shared/OLE/PPS/File.php:30
- > PHP Fatal error
Uncaught Error: Class 'PHPExcel_Style_Supervisor' not found in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Style/Alignment.php:27
- > PHP Fatal error
Uncaught Error: Class 'PHPExcel_Writer_Excel5_BIFFwriter' not found in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Writer/Excel5/Workbook.php:63
- > PHP Fatal error
Uncaught Error: Class 'PHPExcel_Writer_Excel2007_WriterPart' not found in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Writer/Excel2007/Style.php:28
- > PHP Fatal error
Uncaught Error: Class 'PHPExcel_Writer_Excel2007_WriterPart' not found in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Writer/Excel2007/Chart.php:28
- > PHP Fatal error
Uncaught Error: Class 'PHPExcel_Style_Supervisor' not found in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Style.php:28
- > PHP Fatal error
Uncaught Error: Class 'PHPExcel_Writer_OpenDocument_WriterPart' not found in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Writer/OpenDocument/Styles.php:28
- > PHP Warning
Use of undefined constant PHPEXCEL_ROOT - assumed 'PHPEXCEL_ROOT' (this will throw an Error in a future version of PHP) in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Shared/trend/powerBestFitClass.php on line 3
- > PHP Warning
Use of undefined constant PHPEXCEL_ROOT - assumed 'PHPEXCEL_ROOT' (this will throw an Error in a future version of PHP) in wp-content/plugins/wp-excel-2-db/public/phpexcel/Classes/PHPExcel/Shared/trend/polynomialBestFitClass.php on line 3
- > PHP Fatal error
User-side errors Passed 1 test
🔹 Test weight: 20 | A shallow check that no browser errors were triggered
Everything seems fine on the user side
Optimizations
Plugin configuration Passed 29 tests
readme.txt Passed 16 tests
Don't ignore readme.txt as it is the file that instructs WordPress.org on how to present your plugin to the world
6 plugin tags: import, database, reader, table, excel...
wp-excel-2-db/wp-excel-2-db.php Passed 13 tests
"WP Excel 2 DB" version 1.0.0's primary PHP file adds more information about the plugin and serves as the entry point for WordPress
72 characters long description:
Import excel sheet to wordpress database table form wordpress dashboard.
Code Analysis 95% from 3 tests
File types Passed 1 test
🔸 Test weight: 35 | A short glimpse at programming languages used with this plugin and a check that no dangerous files are present
No dangerous file extensions were detected58,201 lines of code in 231 files:
| Language | Files | Blank lines | Comment lines | Lines of code |
|---|---|---|---|---|
| PHP | 227 | 10,894 | 36,303 | 58,141 |
| JavaScript | 2 | 13 | 35 | 60 |
| CSS | 2 | 0 | 8 | 0 |
PHP code 0% from 2 tests
An overview of cyclomatic complexity and code structure
The following items need your attention
- Please reduce cyclomatic complexity of classes to less than 1000 (currently 1,019)
- Method cyclomatic complexity should be reduced to less than 100 (currently 387)
| Cyclomatic complexity | |
|---|---|
| Average complexity per logical line of code | 0.39 |
| Average class complexity | 48.11 |
| ▷ Minimum class complexity | 1.00 |
| ▷ Maximum class complexity | 1,019.00 |
| Average method complexity | 4.61 |
| ▷ Minimum method complexity | 1.00 |
| ▷ Maximum method complexity | 387.00 |
| Code structure | ||
|---|---|---|
| Namespaces | 0 | |
| Interfaces | 7 | |
| Traits | 0 | |
| Classes | 213 | |
| ▷ Abstract classes | 10 | 4.69% |
| ▷ Concrete classes | 203 | 95.31% |
| ▷ Final classes | 0 | 0.00% |
| Methods | 2,889 | |
| ▷ Static methods | 630 | 21.81% |
| ▷ Public methods | 2,292 | 79.34% |
| ▷ Protected methods | 80 | 2.77% |
| ▷ Private methods | 517 | 17.90% |
| Functions | 15 | |
| ▷ Named functions | 15 | 100.00% |
| ▷ Anonymous functions | 0 | 0.00% |
| Constants | 812 | |
| ▷ Global constants | 118 | 14.53% |
| ▷ Class constants | 694 | 85.47% |
| ▷ Public constants | 694 | 100.00% |
Plugin size 50% from 2 tests
Image compression 50% from 2 tests
All PNG images should be compressed to minimize bandwidth usage for end users
8 PNG files occupy 0.49MB with 0.30MB in potential savings
Potential savings
| Compression of 5 random PNG files using pngquant | |||
|---|---|---|---|
| File | Size - original | Size - compressed | Savings |
| assets/screenshot-3.png | 48.21KB | 12.67KB | ▼ 73.72% |
| assets/screenshot-2.png | 116.75KB | 18.65KB | ▼ 84.02% |
| assets/icon-128x128.png | 3.40KB | 2.20KB | ▼ 35.43% |
| assets/icon-256x256.png | 7.03KB | 3.94KB | ▼ 43.93% |
| assets/screenshot-5.png | 55.01KB | 15.75KB | ▼ 71.36% |