Wikipedia:CSVLoader

CSVLoader is an AutoWikiBrowser plug-in that allows creating and updating articles using CSV data files. This plugin can create new articles (for example, cities or plants) or add text to existing articles (for example, add missing infoboxes). It was developed by Ganeshk. The first version of the tool was made available on 25 May 2008.

'''The use of CSVLoader tool may require a request for bot approval on Wikipedia and other projects. Please read the bot policy to check if your task requires an approval.'''

Please test your changes in sandbox before running the plugin on the article space.

Download

 * If you are using the new AWB 6.0, here is the Download link (Current Version 1.0.0.25). After the DLL file is extracted from the zip file, right click on the file and select properties. In the Properties dialog, click Unblock button under the General tab and click Apply and then OK.


 * If you are using the older AWB 5.0, here is the Download link (Older version: 1.0.0.18). Please select File menu - Download option. Please extract the DLL from the zip file and copy it to AutoWikiBrowser folder. If the download is blocked by Microsoft SmartScreen filter, use the Run Anyway function to download the file.

Walkthrough to create articles with AutoWikiBrowser

 * Step by step walkthrough can be found at this page.

Walkthrough to find and replace strings using CSV data files

 * Step by step walkthrough can be found at this page.

Examples and Tips

 * Data samples and tips can be found at this page.

Projects that used this plugin
[ Click here to add your project]

Source
Full source code is available on Google Drive for version 1.0.0.25 and version 1.0.0.18. The plugin was originally developed using Visual Basic 2008 Express and recently recompiled with Visual Studio Community Edition 2017 on .NET 4.5 and x86 build. The language used is Visual Basic.NET.

History

 * 1.0.0.25 - Convert first character to upper case and replace underscore with space if language is English (removed Wikipedia check from 1.0.0.16 and 1.0.0.17) - March 1, 2020
 * 1.0.0.24 - Fix the broken Find and Replace functionality - January 6, 2019
 * 1.0.0.23 - Disable plugin when settings are reset or cleared. ##BR## special keyword will now add two line feeds - December 29, 2018‎
 * 1.0.0.22 - Add ability to add numbered or bulleted lists with List symbol option. - December 27, 2018
 * 1.0.0.21 - Fix an issue with Find and Replace. AWB was adding additional slashes (\) to the find word, these were removed. Skip checkbox will not auto-select - December 24, 2018
 * 1.0.0.20 - Recompiled the source code to be compatible with .NET 4.5 and AWB 6.0. - December 23, 2018
 * 1.0.0.18 - Convert first character of the title to upper case only if the current project is English Wikipedia. - April 29, 2014
 * 1.0.0.17 - Display the article that has the column mismatch error. - February 4, 2013
 * 1.0.0.16 - Convert first character of the title to upper case only if the language is English and site is Wikipedia.
 * 1.0.0.15 - Fixed a bug with converting the first letter of article titles to upper case and site is Wikipedia.
 * 1.0.0.14 - Fixed a bug when the edit summary is blank. Changed the delimiter default from tilde to comma (the instructions use comma). Added a special keyword ##BR## that will add a newline.
 * 1.0.0.13 - Fixed caption spelling for separator. Fix when article name has underscore character. Check to make sure the number of columns on the file matches the number of columns on the column header. - September 18, 2011
 * 1.0.0.12 - Fixed a bug with custom Edit summary box. Edit summary was not showing up in manual edit mode. - September 3, 2011
 * 1.0.0.11 - Added custom Edit summary box. Fields can be used in the edit summary. - August 30, 2011
 * 1.0.0.10 - Use Monospaced font for the content box. Changed the caption from Article text to Append/Prepend/Replace text. - February 6, 2011
 * 1.0.0.9 - Compatibility test with AWB 5.2.0.0 was successful. - February 4, 2011
 * 1.0.0.9 - Fixed a bug with the Replace option - May 19, 2010
 * 1.0.0.8 - Find and Replace function (example) - May 6, 2010
 * 1.0.0.7 - Option to create lists - April 21, 2010
 * 1.0.0.6 - Support for UTF-8 format - March, 10, 2010
 * 1.0.0.5 - Added ability to accept a CSV file to overcome limitations of the AWB text file upload program - February 27, 2010
 * 1.0.0.4 - Compatibility test with AWB build 5001 was successful. - February 22, 2010
 * 1.0.0.4 - Fixed bugs so that the plug-in works with AWB build 4902
 * 1.0.0.3 - Added ability to use custom separators (for example, tilde). This will be needed when the CSV data contains "comma" characters.

To do

 * Allow the settings window to be resized.
 * Add support for find and replace using Advanced settings.