Skip to main content

A program removing qTranslate language section

Overview

This is a program for migrating from a Wordpress with qTranslate to Wordpress multi-site. It removes the language-specific contents and tags attached by qTranslate plugin.

Keywords: qTranslate, qTranslate-X, multi-site, multi-language, Wordpress

Introduction

Ten years ago from now (abound 2013), it is common that the cheapest web hosting service had 0 SQL databases, and even the next level service with database had up to 2 SQL databases. Therefore, if you want to use Wordpress in multiple languages, qTranslate multilingual plug-ins https://qtranslatexteam.wordpress.com/ was a common solution to reduce the number of database use.

How does the qTranslate plugin work?

The qTranslate plugin puts special tags ([:ja], [:], etc.) in the text. The plugin will retrieve the specific language text based on the tag.

Advantages and disadvantage of the qTranslate plugin

The biggest advantage of the qTranslate plugin is that it needs only one database even if it is multilingual. Ten years ago (2013), this was a significant advantage for a hosting service to limit the number of databases to one. However, qTranslate distinguishes language section by own tags in the text, so there is a risk of accidentally edit tags. If the tag is accidentally erased or if the same string in the text, it could cause display problems. In addition, some plug-ins cannot be used at the same time because they do not know that other plug-ins switch languages by inserting tags into the content. Thus, there are restrictions on the use of the plugin.

qTranslate no longer supported, Wordpress version up

The price of databases has dropped comparing to the 10 years ago. It is not unusual for an introductory web hosting service to have 10 databases available. And qTranslate is no longer supported in Wordpress 4.x. qTranslate plugin does not work well with the current 6.x version.

remove_qtrans.py

During the migration, we considered manually editing the exported xml file from WordPress.  However, due to the large number of articles and the fact that my site uses 3 languages, I decided to write a program to handle it: remove_qtrans.py. You can found here on github .

How to use remove_qtrans.py

To remove the German (de) part from a Wordpress export file (export.xml) and output (out.xml) file, use the following command. This is a python3 program.

   python3 remove_qtrans.py --language de --infile _export.xml --outfile out.xml

Tip: You can use your editor's replacezfunction to remove the last remaining language tags.

Conclusion

I have developed a program to remove specific language parts and language tags from qTranslate. License: the New BSD. I hope this may useful for someone. It is under the New BSD License, there is no warranties. 2023-9-15(Fri)


Comments

Popular posts from this blog

Why A^{T}A is invertible? (2) Linear Algebra

Why A^{T}A has the inverse Let me explain why A^{T}A has the inverse, if the columns of A are independent. First, if a matrix is n by n, and all the columns are independent, then this is a square full rank matrix. Therefore, there is the inverse. So, the problem is when A is a m by n, rectangle matrix.  Strang's explanation is based on null space. Null space and column space are the fundamental of the linear algebra. This explanation is simple and clear. However, when I was a University student, I did not recall the explanation of the null space in my linear algebra class. Maybe I was careless. I regret that... Explanation based on null space This explanation is based on Strang's book. Column space and null space are the main characters. Let's start with this explanation. Assume  x  where x is in the null space of A .  The matrices ( A^{T} A ) and A share the null space as the following: This means, if x is in the null space of A , x is also in the null spa

Gauss's quote for positive, negative, and imaginary number

Recently I watched the following great videos about imaginary numbers by Welch Labs. https://youtu.be/T647CGsuOVU?list=PLiaHhY2iBX9g6KIvZ_703G3KJXapKkNaF I like this article about naming of math by Kalid Azad. https://betterexplained.com/articles/learning-tip-idea-name/ Both articles mentioned about Gauss, who suggested to use other names of positive, negative, and imaginary numbers. Gauss wrote these names are wrong and that is one of the reason people didn't get why negative times negative is positive, or, pure positive imaginary times pure positive imaginary is negative real number. I made a few videos about explaining why -1 * -1 = +1, too. Explanation: why -1 * -1 = +1 by pattern https://youtu.be/uD7JRdAzKP8 Explanation: why -1 * -1 = +1 by climbing a mountain https://youtu.be/uD7JRdAzKP8 But actually Gauss's insight is much powerful. The original is in the Gauß, Werke, Bd. 2, S. 178 . Hätte man +1, -1, √-1) nicht positiv, negative, imaginäre (oder gar um

Why parallelogram area is |ad-bc|?

Here is my question. The area of parallelogram is the difference of these two rectangles (red rectangle - blue rectangle). This is not intuitive for me. If you also think it is not so intuitive, you might interested in my slides. I try to explain this for hight school students. Slides:  A bit intuitive (for me) explanation of area of parallelogram  (to my site, external link) .