Import Data from CSV

DCIM_Support · ‎2020-07-04

Hello Team,

is there anyway to import sensors' values from a CSV file to DCE?

We have CRACs in one deploy that do not have SNMP or ModBus communication, but we can export from their inded portal web, temperature values to a CSV file.

Regards

DCIM_Support · ‎2020-07-04

Dear Javier Zurera,

From your question:

is there anyway to import sensors' values from a CSV file to DCE?

As far as I know, this is impossible, because DCE software is designed to monitor connected devices in real time.

We have CRACs in one deploy that do not have SNMP or ModBus communication, but we can export from their inded portal web, temperature values to a CSV file.

You can do this simply with a NetBotz device (for example, NetBotz-200) and one or two temperature sensors AP9335T. Thus, you do not just automatically get information on the temperature of your cooling unit in DCE software, but also increase the reliability of the cooling system as a whole (since you will have two independent temperature sensors).

If there are more questions, please ask.

With respect.

See Answer In Context

DCIM_Support · ‎2020-07-04

Dear Javier,

I am sorry to disappoint you. It is not possible to import sensor values from a CSV file to DCE. It is possible only to discover the third party devices via either SNMP or Modbus TCP options in DCE software.

regards,

Bala

DCIM_Support · ‎2020-07-04

Hi Balaraman Jagadeesan and Steven Marchetti,

and it could be possible to import this data in a computer and send it through SNMP to DCE?

Maybe with a software developer we could try to do this.

Regards

DCIM_Support · ‎2020-07-04

Hi Javier,

It may be possible but that would take a bit of coding on your customer's part. SNMP on a Windows computer can't just read a text file, There would have to be a specific agent / connection to the SNMP service in Windows and that would likely be more work (or at least as much) than the CRAC manufacturer adding SNMP to his system. spezialist idea of a NetBotz appliance or something similar being used to monitor values is probably a more usable idea.

Steve

DCIM_Support · ‎2020-07-04

Thank you all,

yes, the easy way could be install a Netbotz and or install a SNMP card into the CRAC, but we do not know if that could be possible.

The last option could be the development of a software to import data from a CSV and sending it through SNMP. That could be useful for future deployments being independent of the data imported.

Regards

DCIM_Support · ‎2020-07-04

Hi Javier,

No, you can not import sensor values into DCE. They can only be added to the database from the DCE scans of that device or when re-importing a backup which wipes out everything on the server and replaces with the information in that backup. As you've surmised, It needs to be discovered using Modbus or SNMP. Sensors are then added to the device during that discovery. Values are added in subsequent scans.

Steve

DCIM_Support · ‎2020-07-04

Dear Javier Zurera,

From your question:

is there anyway to import sensors' values from a CSV file to DCE?

As far as I know, this is impossible, because DCE software is designed to monitor connected devices in real time.

We have CRACs in one deploy that do not have SNMP or ModBus communication, but we can export from their inded portal web, temperature values to a CSV file.

You can do this simply with a NetBotz device (for example, NetBotz-200) and one or two temperature sensors AP9335T. Thus, you do not just automatically get information on the temperature of your cooling unit in DCE software, but also increase the reliability of the cooling system as a whole (since you will have two independent temperature sensors).

If there are more questions, please ask.

With respect.

DCIM_Support · ‎2020-07-04

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