issues with tables export

#1

Hi all,
I’ve been using Dundas recently. I’ve got problems exporting the tables. The table is loaded and displayed correctly, but when I try to export it using a script, the table that exports only has the headers, without the values in it. There may be an error in the table settings script, but I don’t know how to fix it.
I tried to add these parameters to the export script as in this example (https://www.dundas.com/support/work time/developer/script-library/export/exporting-with-parameters) but no result.

#2

Hi Christiana

Does the table export properly when you do it via the built in export functionality?
Can you share the relevant bits of your script?

Thanks

#3

Agree with @david.glickman - can you also share if you are seeing any JavaScript errors?

In Chrome it would be something like this:

#4

Dear Christina,

have you tried this sample?
https://www.dundas.com/Support/developer/script-library/export/create-an-excel-export

Best regards,
Olivier

#5

By the way, there is a video on export scripts that might be helpful to you.

https://www.dundas.com/resources/off-the-charts-tips-from-an-expert/elevate-your-dashboards-reports/exporting-embedded-for-a-better-user-experience

#6

@christiana hi, the export with parameter example you referred to pushes the parameter values in the dataRequest.

There is actually another way to export with parameter values, with short link service. You can find the example here:
https://www.dundas.com/Support/developer/script-library/export/create-an-export-with-a-short-link

#7

Dear Christiana,

Have you checked if the text in the fields is not simply set with a “white” colour? It happened to me recently, after importing a dashboard from one server to another (dev to prod), the colours were not “ported” and all the text colours defined in the original dashboard haven’t been taken into account, even if they were showing up properly, no colour definition was set when checking field by field. And when exporting to Excel, all the text was having “white” as colour.
Double check in your Excel file generated by the export, select all and set the text colour to “black”, if you text does appear, then edit your dashboard for setting again the colours for the headers and rows field by field.