Client Management Suite

 View Only
Back to discussions
Expand all | Collapse all

How to add data class attributes values from spreadsheet-CSV,TXT

  • 1.  How to add data class attributes values from spreadsheet-CSV,TXT

    Posted Sep 29, 2010 10:38 PM

    I would like to create a new data class and add some attributes i.e. Host Name, IP address, Server Status to denote Production or Non-Production Environment.

    So is there any way /method to add the attribute values of the custome data class from a spreadsheet ( *.CSV, *.TXT) since the environment is not yet standarized!!!So Its not possinle to use IP/Subnet/Naming Convention or AD OU etc
     


  • 2.  RE: How to add data class attributes values from spreadsheet-CSV,TXT

    Posted Sep 30, 2010 03:45 AM

    Typically you do this using Import/Export rules and a data connector. If you want to match data to a device you will need to use a Key i.e. Server Name.

    Create the data classes and resource associations before hand and always start with a small subset of your data, invariably there is an element of trial and error in matching data from different sources. Also remember the golden rule of CMDB management "Adding information is easy removing it is hard".

    In the ideal world you should be trying to get the information from the assets, managing a spreadsheet requires just that Management, consider what you are importing and if automation is possible.

    If you want more information send me an email.