Difference between revisions of "ImportTextFiles.php"

From PKC
Jump to navigation Jump to search
Line 11: Line 11:
==Preprocess file names==
==Preprocess file names==
Give a list of input data files, for example, a list of files from Wikipedia's Module text file collection, which are given unique IDs as file names. Each of these unique IDs can be mapped to a unique Module name through a text file. The following command will produce a smaller file that contains the replacement.
Give a list of input data files, for example, a list of files from Wikipedia's Module text file collection, which are given unique IDs as file names. Each of these unique IDs can be mapped to a unique Module name through a text file. The following command will produce a smaller file that contains the replacement.
  ls ./images/MODULE/ | xargs -i grep {} wp_articles_module.csv > module_replacement.txt
  ls ./MODULE/ | xargs -i grep {} wp_articles_module.csv > module_replacement.txt
When performing data extraction, one usually uses <code>,</code>(comma) as a way to delimit words. To be compatible with the [[moveBatch.php]] syntax, we need to perform a substitution task. In case you want to add a string to the beginning of each line<ref>[https://linuxconfig.org/add-character-to-the-beginning-of-each-line-using-sed Add character to the beginning of each line using sed]</ref>, you may use the following command in place of the earlier statement:
When performing data extraction, one usually uses <code>,</code>(comma) as a way to delimit words. To be compatible with the [[moveBatch.php]] syntax, we need to perform a substitution task. In case you want to add a string to the beginning of each line<ref>[https://linuxconfig.org/add-character-to-the-beginning-of-each-line-using-sed Add character to the beginning of each line using sed]</ref>, you may use the following command in place of the earlier statement:
  ls ./MODULE/ | sed "s/^/Module:/" | xargs -i grep {} wp_articles_module.csv > module_replacement.txt
  ls ./MODULE/ | sed "s/^/Module:/" | xargs -i grep {} wp_articles_module.csv > module_replacement.txt

Revision as of 03:28, 28 January 2022

Please refer to the original MediaWiki document[1]

A Typical Importation Process

  1. Extract text content from some sources, ideally Wikipedia or some reputable data source with existing data model.
    1. In the case of Wikipedia, every page can be considered as a single text file, and each page has a unique ID provided in either XML or MediaWiki data model.
    2. Dump all the textual data content into a directory. Each page should be stored in a unique file, whose page name is stored in a comma delimited file (CSV), that each line associates a unique ID with a the page name.
    3. For importing Modules, where all textual content should be treated by the Content Model named:Scribunto, it might be useful to add the prefix option[1]:--prefix "‎Module:", so that while adding the content, the system knows to mark the page information to use Scribunto as it Content Handling model. (This is to be tried).
  2. Move the file into a place where MediaWiki's maintenance script can easily have access, such as /var/www/html/images. For Docker deployments, this directory is likely to be mapped onto the host machine's hard drive, therefore, easy to put the text files under this directory. For example:MODULE under /var/www/html/images.
  3. Go to the terminal of the host machine that serves MediaWiki, then, run the importTextFiles.php script like follows:
root@hostname:/var/www/html/#php ./maintenance/importTextFiles.php -s "Loading Textual Content from external sources"  --overwrite --use-timestamp --prefix "‎Module:" ./images/MODULE/*

Preprocess file names

Give a list of input data files, for example, a list of files from Wikipedia's Module text file collection, which are given unique IDs as file names. Each of these unique IDs can be mapped to a unique Module name through a text file. The following command will produce a smaller file that contains the replacement.

ls ./MODULE/ | xargs -i grep {} wp_articles_module.csv > module_replacement.txt

When performing data extraction, one usually uses ,(comma) as a way to delimit words. To be compatible with the moveBatch.php syntax, we need to perform a substitution task. In case you want to add a string to the beginning of each line[2], you may use the following command in place of the earlier statement:

ls ./MODULE/ | sed "s/^/Module:/" | xargs -i grep {} wp_articles_module.csv > module_replacement.txt

In case you want to fix the comma-separated delimiter, use the following command.

sed -i "s/,/|/g" module_replacement.txt

Move pages to its proper names

After the replacement file is ready, one can simply run the moveBatch.php script to change the page names.

php ../maintenance/moveBatch.php --r="change page names to proper title" --noredirects module_replacement.txt

Note: The original instruction on the MediaWiki manual shows an --u=user option. The string user should be a user name in the database that you are trying to load this data. For simplicity, --u option can be ignored most of the time. If you insist to use this option, make sure that you know a user name that already exists on the database, otherwise, it will throw exceptions.

Remove temporary page names

Since we initially created the pages with temporary page names, we need to remove these page names. Use mw:Manual:deleteBatch.php to perform this job. Create a list of page names by using the following instructions:

ls ./TEMPLATE > tmpPageNameList.txt
php ../maintenance/deleteBatch.php tmpPageNameList.txt


References

Related Pages