Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Excel export feature
-
Hello, I want to export to excel point values using this feature
But if I have more than one point selected in the exported file the points are one after another and the file is very long and hard to go through it. It is a way to make so the exported file gives me on first column dates, on the second column point values for the first point, on the third column point values for the second point and so on if I have multiple points selected?
This is the result that I get:
And this is the result that I'm looking for:
Thank you!
-
You can get this format by using the watchlist download button (in the new UI). Assuming you are using Mango 3.x
-
Yes, in Mango V3.x works if I select download as CSV (Separate Value Columns), but also I have some issue with this.
The time stamp it is a number which I cannot format into date in excel (in Mango V2.x I was able to format the timestamp into date). Below is an image with the time stamp, first line I tried to format the cell type to date and the result was that:
Some of the values are displayed in line, but other are displayed on separate lines, all should have the same timestamp.
Also, in Mango V2.x it is possible to export .csv file like Separate Value Columns file from Mango V3.x?
-
You can select a different date format when downloading the data, such as Excel compliant formats.
-
Hmm, do you have any idea way I don't see Time format line and Time zone line?
Thanks!
-
What versions of Core, Mango API, Watchlists, and Mango UI do you have installed?
-
Core: 3.1.1+20170620163725
MangoApi: 3.1.3
Watchlist: 3.1.0
MangoUI: 3.1.5 -
That's why then, it must have been added in a later version. You could update...
-
@phildunlap It give's me this error when I check for upgrades:
-
Yeah, that module was discontinued in favor of the UI module and its dashboarding tools. You will have to remove it (which you can do from the legacy modules page in that version) and restart before you can update through the UI.
-
@phildunlap I've upgraded and now I have Time Format. But if I use this feature, from the picture from bellow, to download, in the .csv file I have only 2 values.
But if i use this feature, from the picture from bellow, to download, I get all the data for respective time period.
I should get to identical files, no? Any idea why is that difference?
Thanks!
-
It appears to be caused by a bug in the Download button with an improper limit being imposed on the download. We'll have this fixed soon.
-
@georgestefan said in Excel export feature:
I should get to identical files, no?
They will not be identical, they will probably be formatted a little different but they should contain the same timestamps and values. The bug you were seeing has been fixed the the mangoUI module v.3.4.2 that I just released. Sorry about that.
-
I've updated mangoUI to V.3.4.2 and now the download feature works. But I still have a problem with the timestamp, some points are note displayed correctly. Below is an example with the problem.
First 18 lines are ok, I want all the line to be like those lines.
-
The two rows you highlighted have different timestamps. Are they from the same data source?
-
@jared-wiltshire Yes, they are from the same data source.
-
What kind of data source?
You could use a rollup. That would ensure all the timestamps are the same.
-
When you say to use a rollup, at this settings are you referring?
If yes, still not working, the points are on separate lines.
-
The rollup interval set in the date bar (that image ^^) is the rollup used in the data download, but only if the rollup type in the download menu is selected.
-
Worked with Rollup Type, the file is ok now.
Thank you!
