Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Having formatting problems when exporting table from phpMyAdmin ..

Discussion in 'Database Discussion' started by ahmadka, May 19, 2013.

  1. ahmadka

    ahmadka Member

    May 19, 2013
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Website Owner
    I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.

    The table I'm exporting has 2 columns in it:

    Movie Name | Description
    Movie Name contains a name, such as Argo. No problems in the movie name. The corresponding entry for Description contains this:

    <h2>Product Details</h2>
        <li><b>Actors:</b> Ben Affleck, Bryan Cranston, Alan Arkin, John Goodman</li>
        <li><b>Directors:</b> Ben Affleck</li>
        <li><b>Writers:</b> Chris Terrio</li>
        <li><b>Producers:</b> Ben Affleck, Grant Heslov, George Clooney, David Klawans, Nina Wolarsky</li>
        <li><b>Format:</b> AC-3, Blu-ray, Dolby, NTSC, Subtitled, Widescreen</li>
        <li><b>Language:</b> English, Spanish</li>
        <li><b>Subtitles:</b> Spanish, Portuguese, French</li>
        <li><b>Subtitles for the Hearing Impaired:</b> English</li>
        <li><b>Region:</b> Region A/1 (Read more about DVD/Blu-ray formats.)</li>
        <li><b>Aspect Ratio:</b> 2.40:1</li>
        <li><b>Number of discs:</b> 2</li>
        <li><b>Rated: </b> <span class=""medSprite s_medR ""><span>R (Restricted)</span></span></li>
        <li><b>Studio:</b> Warner Home Video</li>
        <li><b>DVD Release Date:</b> February 19, 2013</li>
        <li><b>Run Time:</b> 120 minutes</li>
    That is, the WHOLE HTML block above is the Description value for that Argo record.

    But when I export the above from phpMyAdmin, this is what I see for the Movie Name & Description combined:

    Argo;&lt;h2&gt;Product Details&lt;/h2&gt;                   
        &lt;li&gt;&lt;b&gt;Actors:&lt;/b&gt; Ben Affleck     Bryan Cranston  Alan Arkin  John Goodman&lt;/li&gt;        
        &lt;li&gt;&lt;b&gt;Directors:&lt;/b&gt; Ben Affleck&lt;/li&gt;                  
        &lt;li&gt;&lt;b&gt;Writers:&lt;/b&gt; Chris Terrio&lt;/li&gt;                   
        &lt;li&gt;&lt;b&gt;Producers:&lt;/b&gt; Ben Affleck  Grant Heslov    George Clooney  David Klawans   Nina Wolarsky&lt;/li&gt;   
        &lt;li&gt;&lt;b&gt;Format:&lt;/b&gt; AC-3    Blu-ray     Dolby   NTSC    Subtitled   Widescreen&lt;/li&gt;
        &lt;li&gt;&lt;b&gt;Language:&lt;/b&gt; English   Spanish&lt;/li&gt;             
        &lt;li&gt;&lt;b&gt;Subtitles:&lt;/b&gt; Spanish  Portuguese  French&lt;/li&gt;          
        &lt;li&gt;&lt;b&gt;Subtitles for the Hearing Impaired:&lt;/b&gt; English&lt;/li&gt;                 
        &lt;li&gt;&lt;b&gt;Region:&lt;/b&gt; Region A/1 (Read more about DVD/Blu-ray formats.)&lt;/li&gt;                   
        &lt;li&gt;&lt;b&gt;Aspect Ratio:&lt;/b&gt; 2.40:1&lt;/li&gt;                    
        &lt;li&gt;&lt;b&gt;Number of discs:&lt;/b&gt; 2&lt;/li&gt;                  
        &lt;li&gt;&lt;b&gt;Rated: &lt;/b&gt; &lt;span class=&quot;medSprite s_medR &quot;&gt;&lt;span&gt;R (Restricted)&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;                    
        &lt;li&gt;&lt;b&gt;Studio:&lt;/b&gt; Warner Home Video&lt;/li&gt;                   
        &lt;li&gt;&lt;b&gt;DVD Release Date:&lt;/b&gt; February 19   2013&lt;/li&gt;                
        &lt;li&gt;&lt;b&gt;Digital Copy Expiration Date:&lt;/b&gt; February 19   2015 (Click here for more information)&lt;/li&gt;              
        &lt;li&gt;&lt;b&gt;Run Time:&lt;/b&gt; 120 minutes&lt;/li&gt;                   
    Secondly, the CSV file that I output from phpMyAdmin puts the individual lines from the above block into separate Excel rows and columns. This is not what I want.

    How can I export data from phpMyAdmin such that the whole Description block appears in just ONE excel cell, next to the corresponding movie name ?

    And also, if possible (although not required), have the Description shown in normal HTML tags (like in the top most code block shown in this thread) ?

    This is what I want:

    Argo | .....Complete Argo HTML here.....
    Batman Begins | .....Complete Batman Begins HTML here.....
    Flight | .....Complete Flight HTML here.....
    Fight | .....Complete Fight HTML here.....
    How can I export from phpMyAdmin so that the output is in the above mentioned format ?
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    Hello :)

    It's likely this is a limitation of the phpMyAdmin software itself. I suggest browsing their forums at:

    phpMyAdmin Discussions

    I noticed several CSV export threads there that could be helpful.

    Thank you.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice