topic Re: Exporting CSV files from Line Chart in ThingWorx Developers

Exporting CSV files from Line Chart

VC_10938534 — Mon, 18 Mar 2024 18:46:17 GMT

Hi everyone, I am currently trying to export data to CSV in which I have collected in my LineChart from my mashup. I have seen the following article: Solved: Re: How to Export a Custom Excel file from Thingwo... - PTC Community.

In which shows how to import CSV files but I am trying to export that data out and if its possible can is there a way to export in 30 minute intervals?
I would be exporting data from a thing in thingworx from a thing group that updates that chart if that information is helpful.
I'm using ThingWorx 9.3.5

Re: Exporting CSV files from Line Chart

Velkumar — Tue, 19 Mar 2024 04:36:44 GMT

Hi @VC_10938534

You can use Thingworx Data Export Widget to export CSV file from InfoTable Data

Data Export Widget (ptc.com)

/VR

Re: Exporting CSV files from Line Chart

VC_10938534 — Tue, 19 Mar 2024 21:51:51 GMT

I read up on that Data Export Widget, but what is the best way to bind that?
@Velkumar

Re: Exporting CSV files from Line Chart

Velkumar — Wed, 20 Mar 2024 04:41:13 GMT

Hi @VC_10938534

You can bind any InfoTable output to the Data Export widget. If you want to download Line Chart data as CSV, you can bind Line Chart data to the Data Export Widget.

/VR

Re: Exporting CSV files from Line Chart

Kishore_K — Wed, 20 Mar 2024 07:51:53 GMT

You can bind the "QueryPropertyHistory" if you are looking to plot time history.

Re: Exporting CSV files from Line Chart

VC_10938534 — Wed, 20 Mar 2024 15:37:02 GMT

Thank you for your response, it is greatly appreciated. It definitely helped me to understand!

Re: Exporting CSV files from Line Chart

VC_10938534 — Tue, 09 Apr 2024 20:26:14 GMT

Hi Kishore_K
With the QueryPropertyHIstory, am I able to export multiple types of data (ABCD....XZY variables) that I am pulling from a line chart, or will I only be able to Export and XY Variables

Re: Exporting CSV files from Line Chart

Kishore_K — Wed, 10 Apr 2024 06:39:31 GMT

all the variables that are to 'logged' to the valuestream will be exported.

Re: Exporting CSV files from Line Chart

VC_10938534 — Wed, 17 Apr 2024 18:15:15 GMT

What if I'm not currently using Value Stream, and pulling from a thing itself, how would I bind that?