Pagination and Search attributes bug

Resolved edudude
(@edudude)

1 year, 2 months ago
Hi! I’ve tried your CSV to HTML plugin for WordPress and I really love it.

But there’s a bug, I think. When using pagination or search attributes it breaks. For example using the search attribute, it first works, but when I try to search for example “otto” it doesn’t find it but also the header texts are weird.

After searching:

It looks the same when trying to use pagination.

I’m using google drive spreadsheet as the source.

Hopefully you can help!
- This topic was modified 1 year, 2 months ago by edudude.
The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)

Thread Starter edudude
(@edudude)

1 year, 2 months ago
Debugging functionality initiated. (CSV to HTML plugin)
(Debugging info is shown even if the shortcode is working. The result of shortcode is always shown at the bottom of this page)

The most common error is not specifying source_type to “guess”. (Default is visualizer_plugin but most common type is guess)
Another common error is to use wrong form of quote-sign when specifying attributes (” instead of “).

If you can’t figure out why your shotrcode is not working, try this shortcode:
[csvtohtml_create debug_mode=”no” source_type=”guess” source_files=”https://docs.google.com/spreadsheets/d/e/2PACX-1vSLG7HAERMdqt_NLbxy3OvFdAn_0tRGNqrI2CU4139jkHZfEezh_zR8JUZSnlQFNKmdvOsGlAgB0YSS/pub?gid=0&output=csv”%5D
If you get this to work, just add attributes needed (besides attributes given in above shortcode).
There is a shortcode generator available in the Tools/CSV to HTML menu (here it is possible to get a preview of the layout. It also give suggestions if needed.)

When having several tables it’s easy to just copy and paste shortcode and sometimes
you also get the same html_id on several shortcodes which could mess things up
(same ID on a html-element is not allowed), especially if you’re using search or pagination functionality.

For demos and examples using this plugin check out CSV To HTML demos
Note! A shortcode must be on ONE line to work!

If it still doesn’t work, please send a mail till info@wibergseweb.se and I will try to get back to you ASAP!
If it works, a donation to info@wibergsweb.se (PayPal) and/or a review of the plugin is very much appreciated!
It seems like you are trying to access the csv file through google drive. You have to publish that document to the web chosing csv as an option.

The link should end with pub?output=csv (copy the link first time you try to publish the csv file on the web)
Array
(
[responsive] => yes
[css_max_width] => 760
[css_min_devicewidth] => 768
[css_max_devicewidth] => 1024
[0] => 1
[html_class] => tablesorter
[title] =>
[path] =>
[source_type] => guess
[source_files] => https://docs.google.com/spreadsheets/d/e/2PACX-1vSLG7HAERMdqt_NLbxy3OvFdAn_0tRGNqrI2CU4139jkHZfEezh_zR8JUZSnlQFNKmdvOsGlAgB0YSS/pub?gid=0&output=csv
[csv_delimiter] => ,
[editable] => no
[fetch_lastheaders] => 0
[exclude_cols] =>
[include_cols] =>
[include_rows] =>
[table_in_cell_cols] =>
[table_in_cell_header] =>
[table_in_cell_wrapperclass] =>
[filter_data] =>
[filter_data_ucfirst] => no
[filter_operator] => equals
[filter_removechars] =>
[filter_col] =>
[eol_detection] => auto
[convert_encoding_from] =>
[convert_encoding_to] =>
[sort_cols] =>
[sort_cols_order] =>
[add_ext_auto] => no
[float_divider] => .
[pagination] => no
[pagination_below_table] => yes
[pagination_above_table] => no
[pagination_start] => 1
[pagination_text_start] => Start
[pagination_text_prev] => Prev
[pagination_text_next] => Next
[pagination_text_last] => Last
[pagination_rows] => 10
[pagination_links_max] => 10
[search_functionality] => yes
[hidetable_load] => no
[hidetable_reset] => no
[searchbutton_text] => Etsi
[resetbutton_text] => Tyhjennä
[searchinput_placeholder] =>
[notfound_message] => no
[search_requiredchars] => 0
[search_requiredchars_message] =>
[search_realtime] => no
[htmltags_autoconvert] => no
[htmltags_autoconvert_newwindow] => no
[htmltags_autoconvert_imagealt] =>
[totals_cols_bottom] =>
[totals_cols_bottom_empty] =>
[totals_cols_prefix] =>
[totals_cols_suffix] =>
[totals_cols_bottom_title] =>
[totals_cols_bottom_title_col] =>
[total_percentage_above_table] => yes
[total_percentage_below_table] => no
[total_percentage_checkvalue] =>
[total_percentage_col] =>
[total_percentage_text] =>
[total_percentage_decimals] => 0
[downloadable] => yes
[downloadable_text] => Lataa .csv tiedostona
[downloadable_filename] => elokuvakerhopalvelu_csvtohtml.csv
[api_cdn] => yes
[fetch_interval] =>
[json_startlevel] => 1
[return_rows_array] => no
[design_template] => pyjamas
[debug_mode] => yes
[html_id] => elokuvataulukko
)
File:https://docs.google.com/spreadsheets/d/e/2PACX-1vSLG7HAERMdqt_NLbxy3OvFdAn_0tRGNqrI2CU4139jkHZfEezh_zR8JUZSnlQFNKmdvOsGlAgB0YSS/pub?gid=0&output=csv
Return code: 200
Return message: OK
Array
(
[0] =>
[1] => Ohjaaja
[2] => Tuotantomaa
[3] => Vuosi
)
Array
(
[0] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => A Man Called Otto
)

[1] => Array
(
[0] => Ohjaaja
[1] => Forster, Marc
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[1] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Aftersun – Päivämme auringossa
)

[1] => Array
(
[0] => Ohjaaja
[1] => Wells, Charlotte
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Britannia/USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[2] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => All the Beauty and the Bloodshed
)

[1] => Array
(
[0] => Ohjaaja
[1] => Poitras, Laura
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[3] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Anna joen virrata
)

[1] => Array
(
[0] => Ohjaaja
[1] => Giaever, Ove
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Norja
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[4] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Babylon
)

[1] => Array
(
[0] => Ohjaaja
[1] => Chazelle, Damien
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[5] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Beau is Afraid
)

[1] => Array
(
[0] => Ohjaaja
[1] => Aster, Ari
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[6] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Close
)

[1] => Array
(
[0] => Ohjaaja
[1] => Dhont, Lukas
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Belgia/Hollanti/Ranska
)

[3] => Array
(
[0] => Vuosi
[1] => 2023
)

)

[7] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Cocaine Bear
)

[1] => Array
(
[0] => Ohjaaja
[1] => Banks, Elizabeth
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2023
)

)

[8] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Corsage – kuriton keisarinna
)

[1] => Array
(
[0] => Ohjaaja
[1] => Kreutzer, Maria
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Itävalta/Ranska/Saksa
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[9] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Decision to Leave
)

[1] => Array
(
[0] => Ohjaaja
[1] => Chan-Wook, Park
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Etelä-Korea
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[10] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Ei karhuja
)

[1] => Array
(
[0] => Ohjaaja
[1] => Panahi, Jafar
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Iran/Ranska
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[11] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Enys Men
)

[1] => Array
(
[0] => Ohjaaja
[1] => Jenkin, Mark
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Britannia
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[12] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => EO
)

[1] => Array
(
[0] => Ohjaaja
[1] => Skolimowski, Jerzy
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Puola
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[13] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Hamsterit
)

[1] => Array
(
[0] => Ohjaaja
[1] => Pölönen, Markku
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Suomi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[14] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Hassisen kone 40 vuotta myöhemmin
)

[1] => Array
(
[0] => Ohjaaja
[1] => Kaurismäki, Mika
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Suomi
)

[3] => Array
(
[0] => Vuosi
[1] => 2023
)

)

[15] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Hiljainen tyttö
)

[1] => Array
(
[0] => Ohjaaja
[1] => Bairéad, Colm
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Irlanti/Britannia
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[16] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Holy Spider
)

[1] => Array
(
[0] => Ohjaaja
[1] => Abbasi, Ali
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Tanska/Saksa/Ruotsi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[17] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Jonain päivänä kaikki tämä on sinun
)

[1] => Array
(
[0] => Ohjaaja
[1] => Öhman, Andreas
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Ruotsi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[18] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Järjettömän paska idea
)

[1] => Array
(
[0] => Ohjaaja
[1] => Tola, Pamela
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Suomi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[19] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Kaunis aamu
)

[1] => Array
(
[0] => Ohjaaja
[1] => Hansen-Löve, Mia
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Ranska
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[20] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Koputus
)

[1] => Array
(
[0] => Ohjaaja
[1] => Pajunen, Joonas; Seeck, Max
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Suomi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[21] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Kotiinpaluu
)

[1] => Array
(
[0] => Ohjaaja
[1] => Chou, Davy
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Kambodza/Ranska
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[22] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Kutsumus
)

[1] => Array
(
[0] => Ohjaaja
[1] => Pálmason, Hlynur
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Islanti/Tanska
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[23] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Laupias taksikuski
)

[1] => Array
(
[0] => Ohjaaja
[1] => Hristov, Tonislav
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Bulgaria/Suomi/Ruotsi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[24] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Polta nämä kirjeet
)

[1] => Array
(
[0] => Ohjaaja
[1] => Runge, Björn
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Ruotsi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[25] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => R.M.N. – kylmä talvi
)

[1] => Array
(
[0] => Ohjaaja
[1] => Mungiu, Cristian
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Romania/Ranska
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[26] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Rakkaani merikapteeni
)

[1] => Array
(
[0] => Ohjaaja
[1] => Härö, Klaus
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Suomi/Irlanti
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[27] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Rakkauden supersankari
)

[1] => Array
(
[0] => Ohjaaja
[1] => Genovese, Paolo
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Italia
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[28] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Salaliitto Kairossa
)

[1] => Array
(
[0] => Ohjaaja
[1] => Saleh, Tarik
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Ruotsi/Ranska/Suomi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[29] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Sisu
)

[1] => Array
(
[0] => Ohjaaja
[1] => Helander, Jalmari
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Suomi
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[30] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Tár
)

[1] => Array
(
[0] => Ohjaaja
[1] => Field, Todd
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[31] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => The Banshees of Inisherin
)

[1] => Array
(
[0] => Ohjaaja
[1] => McDonagh, Martin
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Irlanti/Britannia/USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[32] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => The Fabelmans
)

[1] => Array
(
[0] => Ohjaaja
[1] => Spielberg, Steven
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[33] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => The Menu
)

[1] => Array
(
[0] => Ohjaaja
[1] => Mylod, Mark
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Britannia/USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[34] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => The Whale
)

[1] => Array
(
[0] => Ohjaaja
[1] => Aronofsky, Darren
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[35] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => To Leslie
)

[1] => Array
(
[0] => Ohjaaja
[1] => Morris, Michael
)

[2] => Array
(
[0] => Tuotantomaa
[1] => USA
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[36] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Tyttäreni laulu
)

[1] => Array
(
[0] => Ohjaaja
[1] => Ruiz de Azua, Alauda
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Espanja
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[37] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Utama
)

[1] => Array
(
[0] => Ohjaaja
[1] => Loayza Grizi, Alejandro
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Bolivia/Espanja
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[38] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Valon valtakunta
)

[1] => Array
(
[0] => Ohjaaja
[1] => Mendes, Sam
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Britannia
)

[3] => Array
(
[0] => Vuosi
[1] => 2022
)

)

[39] => Array
(
[0] => Array
(
[0] => Elokuvan nimi
[1] => Vortex
)

[1] => Array
(
[0] => Ohjaaja
[1] => Noé, Gaspar
)

[2] => Array
(
[0] => Tuotantomaa
[1] => Ranska
)

[3] => Array
(
[0] => Vuosi
[1] => 2021
)

)

)
- This reply was modified 1 year, 2 months ago by Steven Stern (sterndata).
Plugin Author wibergsweb
(@wibergsweb)

1 year, 2 months ago

Hi!

Nice you love my plugin. Bad thing it does not work 😉

I’ve looked into this and it seems to be some extra metadata that is sent when retrieving when doing the actual search. I don’t know why, but it obviously works to fetch the data initially. I will deep diver into the issue and get back to you as soon as I can!

Plugin Author wibergsweb
(@wibergsweb)

1 year, 2 months ago

I’ve updated the plugin to 1.7.7 that should solve the issue!

For the technial interested I did an explode into an array based on ampersand (&) AFTER decoding a string that contained a lot of key/pair values (e.g. source_files=”https://docs.google.com/spreadsheets/d/e/2PACX-1vSLG7HAERMdqt_NLbxy3OvFdAn_0tRGNqrI2CU4139jkHZfEezh_zR8JUZSnlQFNKmdvOsGlAgB0YSS/pub?gid=0&output=csv“&search_functionality=”yes”&source_type=”guess”) etc) which was a bad idea because output is not a key that plugin uses. It’s ). Now the exploding into array based on ampersand (&) BEFORE decoding!

Thread Starter edudude
(@edudude)

1 year, 2 months ago

Thank you so much! Now it seems to work as intended.

P.S. Sorry for the long message earlier. I thought it would have been an “show more/show less” piece of text since I wrote put it in code block but oh well.
Plugin Author wibergsweb
(@wibergsweb)

1 year, 2 months ago
Thank you for maknig me aware of this! I did not do enough testing with google sheets apparently… It’s no problem with long message !

Please give review and/or donation to make this plugin to continue to “live”!
- This reply was modified 1 year, 2 months ago by wibergsweb.