Help with Importing from CSV file

Hi Tim,

Importing data from a CSV file can be very tricky.

Some methods:
1. Manually add your CSV data into MySQL INSERT statements.

2. Parse the CSV file with custom programming.

Here are some tips for manually inserting data:
- backup your database
- open your database backup and you will see examples of INSERT statements
- create one insert statement and try it out
- use the free MySQL Console plugin to execute your MySQL queries:
http://www.interactivetools.com/add-ons/detail.php?MySQL-Console-1011

Here is an example INSERT:
INSERT INTO `#TABLE_PREFIX#_news` VALUES("1","2010-04-13 21:37:29","1","2010-04-13 21:37:29","1","1271194649","Hello World","2010-04-13 00:00:00","<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. In sodales viverra lacus, non ullamcorper mi posuere non. t</p>");
- replace #TABLE_PREFIX#_ with your actual mysql table prefix. You can find that in Admin > General Settings -
Database Settings

This is based on the following fields in a News section:
num
createdDate
createdByUserNum
updatedDate
updatedByUserNum
dragSortOrder
title
date
content

- num - needs to be unique
- *ByUserNum - needs to match a user number
- all the Dates need to be in the correct format. If you are not sorting by date, you can use a date from your backup.
- and there may be other requirements based on your fields and setup.

Give this a try by first testing with one or two INSERT statements after you have backed up your database.

As I mentioned, this is tricky and can be tedious.

Hope that helps a little.