csv import Articles & Posts

Enable CSV Import for all controllers/models in a CakePHP 2.x project

CakePHP LogoI often use phpMyAdmin to import csv data into projects I am building, this can be tedious as phpMyAdmin requires the number of fields and field order to match exactly for the csv import to work.

This frustration prompted me to explore the (continue reading…)

Keywords:

  • cakephp csv import
  • cakephp import csv

How to Import CSV Data into MediaWiki as pages

1.) Create a FREE account for the Mediawiki CSV Import tool.

2.) Upload your CSV file, making sure you have column names in the first row, ie.

State, Abbreviation, Population
Texas, TX, 24782302
California, CA, 36961664
Florida, FL, 18801310

3.) Define a Page Template by clicking on Add Template. The template can contain mediawiki mark and variable from your csv data file. The template you are defining represents one row of data per page.

Variables for the CSV example above would be {$State}, {$Abbreviation}, and {$Population}.

4.) Click Generate Merge File to build a Mediawiki XML Import file

5.) Download this xml file to your computer.

6.) Login to your Mediawiki site and goto Special Pages.

7.) Click on the Import Pages link and upload the XML file.

8.) That’s it, Mediawiki will show you a summary of imported pages that you can click and view.

Check out the Mediawiki CSV Import tool from PRONIQUE Software


Mediawiki CSV Import 2.1.0 Release

We have released a new version of Mediawiki CSV Import (mwcsvimport). The latest version is now a web app rather than a download/install. You must register and login to use the latest version of the tool.

You can upgrade to a paid account with a one-time payment of $7.99. This will remove a 15 page export limit of free accounts. The latest version is available at http://mwcsvimport.pronique.com/. Give it a go and don’t forget to send us your feedback and comments.

Mediawiki CSV Import

The latest version is available in multiple languages but we need your help translating. Read more: Translators Needed

Read the release notes for more info about the 2.1.0 release.


Copyright © 1996-2012 PRONIQUE Software. All rights reserved.