Wikipedia:CSVLoader/Find and replace: Difference between revisions

Revision as of 22:38, 5 January 2014

Latest revision as of 20:14, 11 January 2025

(3 intermediate revisions by 3 users not shown)

Line 1:

== Using AWB to find and replace withstrings string fromusing CSV data files==

This option is very useful for collecting data related to articles, infoboxes, images, etc. in a spreadsheet, then processing and or cleaning it in the spreadsheet and reuploading results back to articles or images.

Steps:

# Create a CSV file. The first column must be the article name. See example [[User:Ganeshk/CSVLoader/Find_%26_Replace#Data|here]]. Don't specify the column headers. You will do that later.

#*If csv file contains non-english characters than it needs to be saved in [[UTF-8]] format. One way to do this is to change .csv file extension to .txt, and open resulting file in [[NotepadMicrosoft (software)Notepad|Notepad]] and use ''save as'' option to save in [[UTF-8]] format.

# Copy CSVLoader.dll to the AWB directory.

# Log in to AWB (<u>with bot account</u>)

# Create replacement rules in ''option'' tab ''Normal settings'' button. See [[:File:Wpcsv-5-6-10-1.JPG|here]] for examples. All replacement rules must be related to CSV file. You can use ''option'' tab ''Advanced settings'' button to create additional rules not related to CSV file.

# Select "CSV Loader plugin" from the Plugins menu. In the CSV loader settings box, (see example [[:File:Wpcsv-5-6-10-2.JPG|here]])

#* In ''Text File'' area select the CSV file that will be used.

#* In ''Options'' area check "Find and Replace" and filefield separator (comma or semicolon for CSV).

#* In ''Column Headers'' area enter the column headers (enclose them with ## (or any other symbol), example: <code><nowiki>##city##,##district##,##state##,##country##</nowiki></code>). Do ''not'' include spaces between around the commas.

#* Leave ''Article Text'' area unchanged