SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast mr_nabo's Avatar
    Join Date
    May 2006
    Posts
    33
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exporting data incl HTML using PHPMyAdmin as csv

    Hi,

    I'm having trouble trying to export a csv file from a Joomla database which contains some HTML. I can see the data laid out perfectly in PHPMyAdmin when I carry out an SQL command like this:

    Code:
    SELECT `id` , `title` , `alias` , `introtext` , `fulltext`
    FROM `jos_content`
    However, when I try to export the data as a csv file, everything goes a bit awry (I'm assuming it's because there's a delimiter in the introtext or fulltext HTML). When I try to open the file in Numbers (Mac equivalent of Excel), there are multiple rows i.e. it's not in the same tabble format as in PHPMyAdmin.

    The settings I'm using in PHPMyAdmin to export the data are:

    Export : CSV
    Fields terminated by : ,
    Fields enclosed by : "
    Fields escaped by : \
    Lines terminated by : AUTO
    Replace NULL by : NULL
    Does anyone know what I can try as I'm new to this?

    Thanks,

    mn

  2. #2
    SitePoint Enthusiast mr_nabo's Avatar
    Join Date
    May 2006
    Posts
    33
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Anyone got any ideas? Sorry for urgency, but I need to do this asap.

    Thanks


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •