Wikipedia:CSVLoader/Find and replace: Difference between revisions

Revision as of 20:50, 16 February 2013

Latest revision as of 20:14, 11 January 2025

(4 intermediate revisions by 4 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

#* click OK

#* Plugin will add the article list to the main window

# At this point do not make any changes to replacement rules. If you need to change something thanthen reload CSV Loader plugin. (In fact, while the plugin is running all changes to rules will be overwritten.)

# Review the page skip setting on the Skip tab. Do not use skip options in bot "auto save" mode, it seems to break the tool (version 1.0.0.10).

# Enter an edit summary