Support

 View Only

  • 1.  Images and table format in word/pdf exports

    Posted 03-23-2023 13:17

    Hi,

    I've been having issues with Jama requirement exports.

    Images and tables from rich text exported into word and pdf files are often too big for the page. This can be manually addressed but the process is time consuming. Is there a way to automate it such that all content fits on the page when exported?

    Thanks for the support.

    Dan



    ------------------------------
    Daniel Escamilla
    ------------------------------


  • 2.  RE: Images and table format in word/pdf exports

    Posted 03-23-2023 14:15

    I use the <img tag to size graphics in Word. I have not tried this in Excel.

    For example:

    <p><img src="{image url}" height="40" width="160"></p>



    ------------------------------
    Jeff Abbott
    Leidos
    Orlando FL
    ------------------------------

    Original Message


  • 3.  RE: Images and table format in word/pdf exports

    Posted 03-24-2023 08:31

    Hi Daniel,

    we have adopted two strategies :

    • Preprocessing : fix it at the source -> see Jeff's hint. I have formalized this in my organization: I have written a context-sensitive velocity report -> the user can directly detect the images that do not fit to a specific size
    • Postprocessing : add a VBA macro to your Word template (.docx -> .docm) in which you can resize the images in the generated Word document.

    I prefer the first option -> one change and it is done. With the postprocessing you do it for each export again and again and VBA is not that performing :-/

    Best regards, 



    ------------------------------
    Alessandro
    Systems Engineer
    SICK AG
    ------------------------------

    Original Message


  • 4.  RE: Images and table format in word/pdf exports

    Posted 03-24-2023 15:46
    Edited by Romain Bornet 03-24-2023 15:46

    Hi,

    For the second option mentioned by @Alessandro Valli , Jama Professional Services had published several VBA macros/functions to fix various pitfalls in Word exports. Fix image size, tables size, font/font size, ... 

    The code is available on Github at https://github.com/jamasoftware-ps/VBA_Word, a good starting point.



    ------------------------------
    Romain Bornet
    ------------------------------

    Original Message


  • 5.  RE: Images and table format in word/pdf exports

    Posted 03-26-2023 15:19

    Alessandro, I could not agree more. Fix all problems at the source to avoid work arounds and recurring effort.



    ------------------------------
    Jeff Abbott
    Leidos
    Orlando FL
    ------------------------------

    Original Message


  • 6.  RE: Images and table format in word/pdf exports

    Posted 03-27-2023 14:38

    Hi Daniel,

    In addition to the other comments, if you are using a Velocity template to PDF, we have published some guidance on Images and Tables in the Quick Start: HTML Templates for Velocity PDF Reports that will help adjust to fit the page size. 

    Our Professional Services can also assist, as mentioned, with custom templates that fit your specific needs and can help clean up/adjust content within Rich Text fields. 



    ------------------------------
    Katie Huckett
    Senior Product Manager
    Jama Software
    ------------------------------

    Original Message