Wikipedia:CSVLoader/Walkthrough

From Wikipedia, the free encyclopedia

Create csv file[edit]

Create a csv or text file. The first column in each line must have the article name. In this example, csv file has three article pages.

Do not add the column headers, this will be done in the csv loader settings box later.

  • If the csv file contains non-English characters then the csv file needs to be saved in UTF-8 format. One way to do this is to change .csv file extension to .txt, and then open the created file in Notepad and use save as option to save in UTF-8 format.


Copy csv plugin[edit]

Copy the downloaded CSVLoader.dll file to the AutoWikiBrowser root folder (next to the AutoWikiBrowser.exe). This will make it automatically show up in the Plugins menu whenever AWB is started.

Open csv plugin[edit]

Start AutoWikiBrowser and login with your account

Select CSV Loader plugin from the Plugins menu

You will be prompted to select a file name. Choose your created csv or text file and click Open.

Choose plugin settings[edit]

The CSV Loader Settings box pops up. Fill in the column headers and the article text boxes.

In the csv loader settings box,

  1. select whether to skip if no changes are made (default is to skip)
  2. enter the column headers (enclose them with ## (or any other symbol), example:
    ##city##,##district##,##state##,##country##. The article list will not load if the Column Headers line is empty.
  3. select whether to append (add to the end), prepend (add to the beginning) or replace the new text.
  4. enter the new text (use the column headers where applicable, example: ##city## is a city in [[##district## district]] in the state of [[##state##]] in [[##country##]]). For templates, the ## is not needed, for example: {{city}}
  5. click OK

The article list will get loaded to the main window.

Final settings and run plugin[edit]

On the main screen, click the Skip tab.

At the very bottom in the skip section press the Exists radio button.

This will skip processing if the page exists, and create new articles only.

Click the Start tab.

Enter an edit summary.

Click Start, the first article listed in the csv file appears into the top window.

Click Save to save the changes

The next article will appears in the top window, repeat the process.

Repeat until all the articles are done.

To save the loader settings, select Save Settings As from the File menu

Enter a file name and click save to close.

For any replacements, click Normal Settings button on the Options tab, do this prior to clicking Start

Add the corrections to the list. Make sure to uncheck the add replacements to edit summaries box