Importing Help

[harvillo]

I'm importing files via phpmyadmin (or sqlyog) and run into the problem that my files are CSV. Some of the fields may have commas or # in the description which causes the import to either quit or to import the data incorrectly. Is there a way to rectify this without having to strip out the commas, # etc. prior to importing the data?

[hessian]

Depends on how your csv's are made. For fields that have special characters in it they need to be escaped, or enclosed by something like a quote.

"field,1","field,2","field,3"

you can import something like that with fgetcsv()
It will break it into an array.
$Array[0] = field,1
$Array[1] = field,2
etc.