Menu

#844 (ok 4.5) Structure in PDF export

Next_release
resolved
Low
2015-04-02
2005-12-08
No

PDF export could also show table structure (see LaTex
or Word exports for example).

Discussion

  • Aayush

    Aayush - 2015-02-01

    I would like to work on it.. If discussion and decision is done whether it is required?

     
  • Isaac Bennetch

    Isaac Bennetch - 2015-02-01

    Hi Aayush, yes this is something you could work on. Please let us know if you have any questions as you proceed.

     
  • Aayush

    Aayush - 2015-02-01

    thanks.. I am working on it

     
  • Madhura Jayaratne

    Ayush, are you still working on this? Any update on the progress?

     
  • Aayush

    Aayush - 2015-03-10

    hi Madhura. Sorry I am not able to provide any update in these days. I am stuck in between of my mid-semester exams.
    But yes I have worked on this and willing to complete this task which I have taken.
    I will update you in two days after my next paper.

     
  • pratik

    pratik - 2015-03-16

    Hi devs, I have started to work on this request.
    1) can we use writeHTML() function of TCPDF Library for writing the structure?
    2) I'm also having an issue while importing column properties by using

    $columns = $GLOBALS['dbi']->getColumns($this->dbAlias, $this->tableAlias);

    in file PMA_ExportPdf.class.php
    The isset($columns) is returning false. Please guide me.

     
  • Aayush

    Aayush - 2015-03-17

    Hi Madhura,
    I have some what developed the back end functions to create the table structure. But now I need to make the change in interface of Format-specific options. For that, I believe the same interface as that for MS-word will work. Please comment.
    Hi pratik, I am already working on it friend.

     
  • Aayush

    Aayush - 2015-03-18

    https://github.com/phpmyadmin/phpmyadmin/pull/1592
    please see this. I need some suggestions too.

     
  • Aayush

    Aayush - 2015-03-24

    Hi developers,
    While working on this patch, I found that two checks are done to decide if comment, mime type and relations has to be printed. One is through cfgRelation and other through checkbox present in UI (like in sql export format) to give do_comment, do_mime and do_relation values. An isset($GLOBALS[$what . xx] condition is used. But for formats like word and pdf, these checkboxes are not present. So, in such condition it will always return false. So, if I am thinking in correct direction, then just like sql export format, other formats also require the checkboxes.
    I would also like share that, first I started to work on this feature in phpmyadmin_QA_4_2, and everything worked well. But when I implemented the same patch in phpmyadmin_QA_4_4, it was not working well mainly due to changed behaviour of PMA_getMime and PMA_getRelation. I checked it in ExportHtmlword.class also. It also had same problem. So, these two functions again need to be integrated in these export formats well.
    I would like to implement all these for better export features in these formats. So, please tell me if I am thinking in correct direction, so that I can start working in all this asap.
    For this, I require one help. I can't get the sole purpose of cfgRelation check. I know it is a global array modified in relation.lib.php. But I am not getting the sense of it. Please help me out.
    I would also like to request you to comment over my patch for this feature, so that I can improve it if required. https://github.com/phpmyadmin/phpmyadmin/pull/1604
    thank you

     
  • Marc Delisle

    Marc Delisle - 2015-04-02
    • summary: Structure in PDF export --> (ok 4.5) Structure in PDF export
    • status: open --> resolved
    • assigned_to: Marc Delisle
    • Group: --> Next_release
     
  • Marc Delisle

    Marc Delisle - 2015-04-02
    • Priority: Normal --> Low