Difference between revisions of "Talk:Import CSV data into a wiki"

From Organic Design wiki
m (Running from windows)
m (some more work)
Line 20: Line 20:
  
 
If you are needing to run Csv2wiki from a Windows machine, you will first need to install [http://www.activestate.com/store/productdetail.aspx?prdGuid=81fbce82-6bd5-49bc-a915-08d58c2648ca  Active Perl]. Refer to their site for documentation.
 
If you are needing to run Csv2wiki from a Windows machine, you will first need to install [http://www.activestate.com/store/productdetail.aspx?prdGuid=81fbce82-6bd5-49bc-a915-08d58c2648ca  Active Perl]. Refer to their site for documentation.
 +
 +
*Copy your source file (csv) to the same directory as the csv2wiki.pl script
 +
*Open up a command prompt
 +
*change to the directory containing the csv2wiki.pl script
 +
csv2wiki.pl job.csv
  
 
==syntax==
 
==syntax==

Revision as of 19:55, 26 March 2008

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.

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 source file (csv) to the same directory as the csv2wiki.pl script
  • Open up a command prompt
  • change to the directory containing the csv2wiki.pl script
csv2wiki.pl job.csv

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:
  • wiki:
  • user:
  • pass:
  • title: 7