Is there a way to update excell cell on a regular basis according to a particular data in DCE?

[DCIM_Support]

I want DCE to update total power in an excel cell in my excel table? Is it possible?

(CID:129412706)

[DCIM_Support · Accepted solution]

Hi Ibrahim.

DCE can post reports to a windows server or to an FTP server. It does not post .xls or any other Excel specific formatted files, it can post delimited text files which can be opened in Excel.

If you want to update an existing file on your computer, you'll need to poll the device directly using SNMP and edit the Excel file yourself. You can also poll the DCE server using the web API and again update your file using your code. The third option is to use the report export feature and again create your own code to pull data from that file and update your Excel file.

Thanks,

Steve.

(CID:129412879)

[DCIM_Support]

Thanks for your help.Can DCE automatically export reports in somewhere my computer.For example,I want DCE to export zone 1 temperatures everyday in excel format.Is it possible?

(CID:130096552)

[DCIM_Support]

Hi Ibrahim,

Not exactly. First you have to create a report. Choose the reports perspective, temperature, and generate report:

Choose a relative range such as the last 24 hours and a summary or table format depending on what exactly you're looking for. Choose the device group(s) and the specific sensors you're looking for:

If you're looking for one day's data, always use relative range as if you choose a specific date, that date's data will always be reported. Run the report and once you've verified it's what you want to see, save that report:

If you now go to reports–>manage export scheduling:

you can see the report you just made:

Choose export action configuration.

Here you can add an export such as a windows export.

Once finished creating the export type, select the report and edit the criteria:

Enable the export. Choose the export you created in the previous step, (no Excel option) choose the appropriate delimiter choose a locale, and schedule it for a specific day or all days.

K-base FA301697 can be helpful here as well as the system's on-line help files.

Thanks,

Steve

(CID:130096787)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.