Talk:Import CSV data into a wiki

Here lies the documentatation for csv2wiki.pl

Description

csv2wiki is a way to import data from a CSV file into a wiki running mediawiki. There are two versions of this program. The first is a command-line driven version written in the Perl language. The second is a PHP version that can be run from a web browser.

Running from windows

If you are needing to run Csv2wiki from a Windows machine, you will first need to install Active Perl. Refer to their site for documentation.

• Copy your job description file (eg job.txt) to the same directory as the csv2wiki.pl and wiki.pl scripts
• Open up a command prompt
• change to the directory containing the csv2wiki.pl script

csv2wiki.pl job.txt

Job file syntax

• put all items in the same dir
• update the job.txt with the full pathname of your CSV file, the wiki URL (must be long form including the index.php), and the wiki user/password.
• The title parameter currently just specifies the column number (starting at 0) of the heading to use as the article title.
• The name of the template to use can be specified using "template=blabla" and defaults to "Record" if not included.

• when set up, run csv2wiki.pl job.txt

• csv: c:\foo.csv (the full pathname of the CSV file for this job)
• wiki: http://www.mywiki.com/wiki/index.php (the URL of the wiki to update, must be long-form)
• user: WikiUser (the username to log in to the wiki as)
• pass:
• title: 7 (index of field to use as article title, zero is first field)
• template: MyTemplate (defaults to "Record" if not included)