We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #2919070
Customize export PDF
Closed

Comments

  •  1
    Jan started the conversation
    November 18, 2021 at 9:27am

    Hi,

    I need help.

    I'm a newbie in coding, but I have som friends who can help me.

    My site consists of tables with data fro mysql and looks fine getting into tables.

    Every monday I have a newsletter i send to subscribers.

    My concern is about how I can customize the pdf export, because i need people to be able to click on the links in the pdf, change the font color, design it to look good, insert a header image

    How can I accomplish this in an easy way.

    Best Regards

    Jan Hoppe Winther Nielsen

  •  1
    Jan replied
    November 19, 2021 at 10:18am

    Hi again,

    is there any easy answer to my request.

    Best Regards

  • [deleted] replied
    November 23, 2021 at 12:33pm

    Hi Jan

    Thank you for reaching out to us.

    Unfortunately it is not possible to customize the export in the 3rd party HTML5 library we're using. 

    There are some limitations in this library we will emphasize for your awareness:

    • For tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export.
    • Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed
    • Conditional formatting is not reflected in any of generated export files.
    • Other front-end extensions cannot be combined with Table Tools. If you have row grouping enabled for the table, or there are some customizations you did yourself, they won’t be reflected in the generated Excel, CSV or PDF document, nor in the clipboard.
    • When you export tables with the wpDataTables plugin, please note that you can export values, but not formulas. WpDataTables doesn’t support exporting formulas, so a Formula column will be exported only with values; and any calculations of Average, MIN, MAX, and Total will not be exported at all.
    • Exporting images is not possible at the moment.
    • You can’t export columns that are hidden – they will not be visible in any exporting or printing tool



  •  1
    Jan replied
    November 23, 2021 at 1:04pm

    Hi Blaženka,

    Thanks for Your answer. It must be a feature request.

    Is it possible to extract data as csv from a table from the plugin, rather from the frontend?

    Best Regards 

    Jan

     

  • [deleted] replied
    November 25, 2021 at 11:56am

    Hi Jan

    Yes, of course, you can simply click on the table tools button on the backend as well to export the table, and then disable the table tools again when you are finished.

    6138116119.png