Printing Order

[defyentParticipant]

I’m using the example on the site to create printable datatables, however the row order changes when the data is exported, and there does not seem to be any way to sort the rows when exporting the data, which pretty much makes exporting useless, can you shed some light? Cheers

[HristoParticipant]

Hello defyent,

I tested this example and it seems to work fine.
Could you clarify it?

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[defyentParticipant]

Thanks for the reply, yes I see that does work, the only difference between my example and this one is that my source is json. It seems to be using the order that the server provides the data in, not the order that the table has been sorted in.

[HristoParticipant]

Hello defyent,

The table has been exported in the way like it looks (filtered and/or sorted).
Please, take a look at this example:
http://jsfiddle.net/txhi/g6k3qgfp/

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[defyentParticipant]

Back to this issue which I still have not solved, in your example when I click the print button, I get a “undefined” message in the page, and nothing else, and I still not get the correct order when using json as the source.

[defyentParticipant]

Half fixed it, I’ve fixed it so the initial loaded order prints, by removing sortcolumn and sortdirection from the datasource, however when I resort a column it only prints in the originally loaded order.

[defyentParticipant]

Further to this issue, when I fix the undefined problem by adding exportSettings: { fileName: null }, to your example, the printable is also in the wrong order, however if I export the data using the other buttons, it is in the correct order.

[defyentParticipant]

Another potentially hazard I’ve found while trying to fix this sorting problem. My software is running over an ssl connection, and I’ve just gotten the error

“?’ was loaded over a secure connection, but contains a form which targets an insecure endpoint ‘http://jquerygrid.net/export_server/dataexport.php’. This endpoint should be made available over a secure connection.”

Does this mean jqx is sending my data to another website?? And not only that, but over an insecure connection???

[HristoParticipant]

Hello defyent,

Thank you for the feedback about printing with a sorted order.
Also, the error that you saw (in “JSFiddle” maybe) it is because it has some restrictions.
About the “dataexport.php” file you do not need to worry it is only for demonstration purposes.
Also, if you have a license you could host this file (or relevant) on your server.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[defyentParticipant]

Any update on whether this issue has been resolved? It’s the only thing preventing me from moving forward with a commercial license.

[HristoParticipant]

Hello defyent,

Unfortunately, it is not fixed, yet.
We work on many tasks and they have a different priority.
You could check regularly our “Release History” page.
Also, I would like to suggest you look at the bigger equivalent of the jqxDataTable – jqxGrid.
Please, take a look this demo (it support this features – printing, and sorting):
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/printing.htm?light

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[defyentParticipant]

I have always wondered what the difference is between jqxGrid and jqxDatatables? Does the printing order bug exist in jqxGrid? I assumed it did since it uses the same exporting code, correct?

[HristoParticipant]

Hello defyent,

The Grid support correct items order when you print the items after the sorting them. You could check this with the provided demo.
You could find more about the difference between the jqxGrid and jqxDataTable you could find in this forum topic:
https://www.jqwidgets.com/community/topic/grid-or-table/#post-52988

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[defyentParticipant]

Interesting, thank you that helps a lot.

[defyentParticipant]

It seems that jqxGrid has the same issue with trying to export data to an external website, I still feel this is a huge security concern, and it is also preventing me from using jqxGrid on a secure connection. There error is

The page at ‘https://…./’ was loaded over a secure connection, but contains a form which targets an insecure endpoint ‘http://jquerygrid.net/export_server/dataexport.php’. This endpoint should be made available over a secure connection.

[Author]

Posts