Difference between revisions of "Talk:Import CSV data into a wiki"
From Organic Design wiki
(→Job file syntax) |
(→Running from windows: need to specify perl on windows) |
||
| Line 24: | Line 24: | ||
*Open up a command prompt | *Open up a command prompt | ||
*change to the directory containing the csv2wiki.pl script | *change to the directory containing the csv2wiki.pl script | ||
| − | csv2wiki.pl job.txt | + | perl csv2wiki.pl job.txt |
== Job file syntax == | == Job file syntax == | ||
Revision as of 20:19, 26 March 2008
Here lies the documentatation for csv2wiki.pl
Contents
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.
How It Works
Source File
Template
Logging In
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
perl csv2wiki.pl job.txt
Job file syntax
The job files contain the following parameters to specify a parsing job:
- 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)
