How to customize Export widget ?

[bhushan3004]

hello,

I want to export all the data displayed on my mashup including grid data also in excel or pdf format. As the thingworx Export widget do not have any custom option to do that. So how can I achieve this. Which thingworx widget I can use or there is any way to do that using custom services. ???

[AdamR]

You can export data from a grid or service to a CSV file format.  Since a mashup is built and rendered using the Thingworx Runtime structure it cannot be exported easily to a PDF for standard excel format.  There is no widget or service available to do this at this time.

[paic]

Once you have the CSV format though, it can be opened directly in Excel and from there you can export it to PDF.

You will have to use a custom extension otherwise to achieve what you want to do.

[kmagdum]

You can write a service which takes all the required data from mashup as input parameter. Then you can give the All Data to Export widget, this way you will have your all data in csv. It will cost only a additional Datashape.

As far as Grid data is concerned, while giving input to service you can export grid data to JSON and use that use JSON as input.