Difference between revisions of "Talk:Import CSV data into a wiki"
From Organic Design wiki
(→Running from windows) |
(→syntax: notes) |
||
| Line 26: | Line 26: | ||
csv2wiki.pl job.txt | csv2wiki.pl job.txt | ||
| − | ==syntax== | + | == Job file syntax == |
| − | |||
*put all items in the same dir | *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. | *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. | ||
| Line 35: | Line 34: | ||
*when set up, run csv2wiki.pl job.txt | *when set up, run csv2wiki.pl job.txt | ||
| − | *csv: | + | *csv: c:\foo.csv ''(the full pathname of the CSV file for this job)'' |
| − | *wiki: | + | *wiki: http://www.mywiki.com/wiki/index.php ''(the URL of the wiki to update, must be long-form)'' |
| − | *user: | + | *user: WikiUser ''(the username to log in to the wiki as)'' |
*pass: | *pass: | ||
| − | *title: 7 | + | *title: 7 ''(index of field to use as article title, zero is first field)'' |
| + | *template: MyTemplate ''(defaults to "Record" if not included)'' | ||
Revision as of 20:18, 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
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)
