Wikipedia:CSVLoader/Walkthrough

Create csv file

Image:WPCSV_0.JPG

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

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

Image:WPCSV_1.JPG

Start AutoWikiBrowser and login with your account

{{-}}

Image:WPCSV_4.JPG

Select CSV Loader plugin from the Plugins menu

{{-}}

Image:WPCSV_2.JPG

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

{{-}}

Choose plugin settings

Image:WPCSV_5.JPG

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

{{-}}

Image:WPCSV_3.JPG

The article list will get loaded to the main window.

{{-}}

Final settings and run plugin

Image:WPCSV_6.JPG

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.

{{-}}

Image:WPCSV_7.JPG

Click the Start tab.

Enter an edit summary.

{{-}}

Image:WPCSV_8.JPG

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

{{-}}

Image:WPCSV_9.JPG

Click Save to save the changes

{{-}}

Image:WPCSV_10.JPG

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

{{-}}

Image:WPCSV_11.JPG

Repeat until all the articles are done.

{{-}}

Image:WPCSV_12.JPG

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

{{-}}

Image:WPCSV_13.JPG

Enter a file name and click save to close.

{{-}}

Image:WPCSV_14.JPG

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

{{-}}

Image:WPCSV_15.JPG

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

{{-}}