68% wpxlsdata

Code Review | Wp Convert Excel Data To Tabel And DB

WordPress plugin Wp Convert Excel Data To Tabel And DB scored68%from 54 tests.

About plugin

  • Plugin page: wpxlsdata
  • Plugin version: 1.2.0
  • PHP version: 7.4.16
  • WordPress compatibility: 3.0.1-5.5.1
  • WordPress version: 6.3.1
  • First release: Sep 18, 2019
  • Latest release: Oct 9, 2020
  • Number of updates: 14
  • Update frequency: every 27.6 days
  • Top authors: behzadrohizadeh (100%)

Code review

54 tests

User reviews

1 review

Install metrics

100+ active /2,699 total downloads

Benchmarks

Plugin footprint 65% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | It is important to correctly install your plugin, without throwing errors or notices
The plugin installed gracefully, with no errors

Server metrics [RAM: ▲0.23MB] [CPU: ▲0.13ms] Passed 4 tests

A check of server-side resources used by Wp Convert Excel Data To Tabel And DB
This plugin has minimal impact on server resources
PageMemory (MB)CPU Time (ms)
Home /3.69 ▲0.2342.96 ▼1.84
Dashboard /wp-admin3.53 ▲0.2348.86 ▼3.28
Posts /wp-admin/edit.php3.65 ▲0.2950.97 ▲2.82
Add New Post /wp-admin/post-new.php6.13 ▲0.25102.50 ▲9.33
Media Library /wp-admin/upload.php3.46 ▲0.2339.70 ▲2.80
Add excel /wp-admin/admin.php?page=wpxlsdata_add_new3.4235.27
Excel to db /wp-admin/admin.php?page=wpxlsdata_Admin_menue3.4245.92

Server storage [IO: ▲0.45MB] [DB: ▲0.00MB] Passed 3 tests

How much does this plugin use your filesystem and database?
This plugin installed successfully
Filesystem: 110 new files
Database: 3 new tables, 6 new options
New tables
wp_wpxlsdata
wp_wpxlsdata_shortcode
wp_wpxlsdata_meta
New WordPress options
can_compress_scripts
db_upgraded
widget_recent-comments
widget_theysaidso_widget
widget_recent-posts
theysaidso_admin_options

Browser metrics Passed 4 tests

This is an overview of browser requirements for Wp Convert Excel Data To Tabel And DB
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,849 ▲8813.18 ▼1.204.49 ▲2.4438.20 ▼11.67
Dashboard /wp-admin2,258 ▲554.85 ▼1.04101.68 ▼14.5240.01 ▼6.42
Posts /wp-admin/edit.php2,134 ▲342.03 ▲0.0141.02 ▲6.1934.71 ▼0.19
Add New Post /wp-admin/post-new.php1,555 ▲1923.22 ▲0.17618.78 ▼37.7250.80 ▼17.94
Media Library /wp-admin/upload.php1,431 ▲314.26 ▲0.01103.37 ▲4.3844.94 ▼2.76
Add excel /wp-admin/admin.php?page=wpxlsdata_add_new1,4739.40295.9371.27
Excel to db /wp-admin/admin.php?page=wpxlsdata_Admin_menue8791.6724.2526.57

Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 50% from 4 tests

🔸 Tests weight: 35 | Checking the uninstaller removed all traces of the plugin
These items require your attention
  • Zombie tables detected upon uninstall: 3 tables
    • wp_wpxlsdata_shortcode
    • wp_wpxlsdata_meta
    • wp_wpxlsdata
  • Zombie WordPress options detected upon uninstall: 6 options
    • db_upgraded
    • theysaidso_admin_options
    • widget_theysaidso_widget
    • widget_recent-comments
    • widget_recent-posts
    • can_compress_scripts

Smoke tests 50% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | This is a short smoke test looking for server-side errors
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
Please fix the following
  • 3× PHP files output non-empty strings when accessed directly via GET requests:
    • > /wp-content/plugins/wpxlsdata/inc/vendor/asan/phpexcel/tests/csvTest.php
    • > /wp-content/plugins/wpxlsdata/inc/vendor/asan/phpexcel/tests/xlsxTest.php
    • > /wp-content/plugins/wpxlsdata/inc/vendor/asan/phpexcel/tests/xlsTest.php
  • 26× PHP files trigger server errors when accessed directly (only 10 are shown):
    • > PHP Warning
      require_once(wp-content/plugins/wpxlsdata/inc/vendor/ellumilel/php-excel-writer/examples/../vendor/autoload.php): failed to open stream: No such file or directory in wp-content/plugins/wpxlsdata/inc/vendor/ellumilel/php-excel-writer/examples/big-data.php on line 2
    • > PHP Warning
      require_once(wp-content/plugins/wpxlsdata/inc/vendor/ellumilel/php-excel-writer/test/XLSX/../vendor/autoload.php): failed to open stream: No such file or directory in wp-content/plugins/wpxlsdata/inc/vendor/ellumilel/php-excel-writer/test/XLSX/XLSXtest.php on line 2
    • > PHP Warning
      require_once(wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/../vendor/autoload.php): failed to open stream: No such file or directory in wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/big-data.php on line 2
    • > PHP Warning
      "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in wp-content/plugins/wpxlsdata/inc/vendor/asan/phpexcel/src/Parser/Excel2007.php on line 383
    • > PHP Warning
      require_once(wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/../vendor/autoload.php): failed to open stream: No such file or directory in wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/formula.php on line 2
    • > PHP Fatal error
      require_once(): Failed opening required 'wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/test/XLSX/../vendor/autoload.php' (include_path='.:/usr/share/php') in wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/test/XLSX/XLSXtest.php on line 2
    • > PHP Warning
      require_once(wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/../vendor/autoload.php): failed to open stream: No such file or directory in wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/more-than-one.php on line 2
    • > PHP Fatal error
      require_once(): Failed opening required 'wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/../vendor/autoload.php' (include_path='.:/usr/share/php') in wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/one.php on line 2
    • > PHP Fatal error
      require_once(): Failed opening required 'wp-content/plugins/wpxlsdata/inc/vendor/ellumilel/php-excel-writer/examples/../vendor/autoload.php' (include_path='.:/usr/share/php') in wp-content/plugins/wpxlsdata/inc/vendor/ellumilel/php-excel-writer/examples/one.php on line 2
    • > PHP Fatal error
      require_once(): Failed opening required 'wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/../vendor/autoload.php' (include_path='.:/usr/share/php') in wp-content/plugins/wpxlsdata/inc/fastexcel/vendor/ellumilel/php-excel-writer/examples/formula.php on line 2

User-side errors Passed 1 test

🔹 Test weight: 20 | Just a short smoke test targeting errors on the browser (console and network errors and warnings)
Everything seems fine on the user side

Optimizations

Plugin configuration 93% from 29 tests

readme.txt 88% from 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
Attributes that require attention:
  • Screenshots: Add an image for screenshot #1 (Add New Excel File)
  • Tags: Too many tags (11 tag instead of maximum 10); only the first 5 tags are used in your directory listing
The official readme.txt is a good inspiration

wpxlsdata/wpxlsdata.php Passed 13 tests

"Wp Convert Excel Data To Tabel And DB" version 1.2.0's primary PHP file adds more information about the plugin and serves as the entry point for WordPress
93 characters long description:
An Plugin to convert Excel files to WordPress database And manage data in your WordPress menu

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | Executable files are not allowed as they can serve as attack vectors
Good job! No executable or dangerous file extensions detected6,782 lines of code in 66 files:
LanguageFilesBlank linesComment linesLines of code
PHP511,8302,2665,630
CSS1342293
Markdown2440234
JSON600222
PO File287101222
JavaScript1881151
YAML23022
XML1008

PHP code Passed 2 tests

An overview of cyclomatic complexity and code structure
No cyclomatic complexity issues were detected for this plugin
Cyclomatic complexity
Average complexity per logical line of code0.33
Average class complexity21.94
▷ Minimum class complexity1.00
▷ Maximum class complexity276.00
Average method complexity3.34
▷ Minimum method complexity1.00
▷ Maximum method complexity57.00
Code structure
Namespaces13
Interfaces1
Traits0
Classes48
▷ Abstract classes12.08%
▷ Concrete classes4797.92%
▷ Final classes00.00%
Methods414
▷ Static methods4911.84%
▷ Public methods28669.08%
▷ Protected methods307.25%
▷ Private methods9823.67%
Functions16
▷ Named functions425.00%
▷ Anonymous functions1275.00%
Constants65
▷ Global constants11.54%
▷ Class constants6498.46%
▷ Public constants64100.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

PNG files should be compressed to save space and minimize bandwidth usage
1 PNG file occupies 0.01MB with 0.01MB in potential savings
Potential savings
Compression of 1 random PNG file using pngquant
FileSize - originalSize - compressedSavings
screenshot-1.png10.34KB4.96KB▼ 52.04%