radioterra's Replies | WordPress.org

Forum Replies Created

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

Forum: Plugins
In reply to: [TablePress - Tables in WordPress made easy] Encoding errors in tablepress HTML import

Thread Starter radioterra
(@radioterra)

9 years, 8 months ago

Oh it seems that the result is not showed correctly in Forum, I try again:

14-09-2016;ASSENTIRÉ DE GRAT | L'irradiador;"<a href=""http://laradio.cat/popup-reproductor.php?reproductor_url=http://www.ivoox.com/assentire-de-grat-l-irradiador_mf_12890286_feed_1.mp3"" onclick=""window.open('http://laradio.cat/popup-reproductor.php?reproductor_url=http://www.ivoox.com/assentire-de-grat-l-irradiador_mf_12890286_feed_1.mp3','player','status=no,toolbar=no,location=no,resizable=no,width=520,height=333');return false;"" ><img class=""tablepress-boto-descarrega"" src=""http://laradio.cat/podcasting/boto-escoltar.png"" alt=""Descarrega""/></a>"

Forum: Plugins
In reply to: [TablePress - Tables in WordPress made easy] Encoding errors in tablepress HTML import

Thread Starter radioterra
(@radioterra)

9 years, 8 months ago

Hi,

I applied reverse engineering. So, I exported to a CSV file an TablePress table with the content that I created manually (without quotation marks or anything, just the text that I want to display in the table).

I observed how Tablepress format everything and I applied the same format to my PHP script that generates automatically my CSV files.

For now I’m importing a CSV file which has no problems with encoding and I also can import an HTML content inside columns. That is the result in case anybody needs a similar solution

14-09-2016;ASSENTIRÉ DE GRAT | Diari de Fuster;””

Thanks for you time Tobias 😉

Forum: Plugins
In reply to: [TablePress - Tables in WordPress made easy] Encoding errors in tablepress HTML import

Thread Starter radioterra
(@radioterra)

9 years, 8 months ago

Hello Tobias,

I understand that is a tricky issue, don’t worry.

I discovered that wp_posts table (where is publish TablePress content) in wordpress database has an utf8_general_ci collation while most of the tables uses utf8_unicode_ci. I also saw that post content colum has the correct encoding in the majority of my post entries but not in TablePress post_content registers, so the fact it has to be related with import script that writes incorrectly the content to the database.

So…I decided to follow your advice and use CSV import but the fact is that I have to import rows like this one:

13-09-2016;ASSENTIRÉ DE GRAT | Programa de presentació;””

Obsviusly, every “;” is detected like a new colum, so TablePress detects 5 columns. The problem is “;return false;” sentence which I have to include in order to execute HTML behavior correctly. This problem causes extra split columns and also the last character of the column #5 it should not appear because is part of the enclosure

1) 13-09-2016
2) ASSENTIRÉ DE GRAT | Programa de presentació
3) <a href=”http://laradio.cat/popup-reproductor.php?reproductor_url=http://www.ivoox.com/11-setembre-entrevista-esquerra-independentista-barcelones_mf_12858503_feed_1.mp3″ onclick=”window.open(‘http://laradio.cat/popup-reproductor.php?reproductor_url=http://www.ivoox.com/11-setembre-entrevista-esquerra-independentista-barcelones_mf_12858503_feed_1.mp3′,’player’,’status=no,toolbar=no,location=no,resizable=no,width=520,height=333′);
4) return false
5) >”

Any ideas to solve these additional problems?
Thanks a lot!

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