How do Comma Separated Value (CSV) or XML files need to be formatted to import Assets

Article:TECH89544  |  Created: 2008-01-16  |  Updated: 2013-05-02  |  Article URL http://www.symantec.com/docs/TECH89544
Article Type
Technical Solution


Issue



You want to import a series of Assets as a CSV or XML file, but you do not know the format to put the import file in.

 


Solution



The format may change from version to version of SSIM to ensure you get the format correct for your version of Symantec Security Information Manager (SSIM), export an existing Asset that was manually created. Use the exported Asset as a template for your Assets to import.
 

  •  Enter one asset correctly through the SSIM interface .
  •  Highlight that Asset in the Assets list page
  •  Export the asset, "CSV" is usually the easiest format to work with but you can also select xml. You cannot Import assets from "html" format.
  •  Open the exported CSV or XML file in Notepad or another text or xml editor such as Notepad++.


Any new Assets that you wish to import must follow the format of the Asset you exported and must have the fields below populated with something inside of double quotes.  Other fields can be left empty in this format "",

  • IP Address
  • MAC address - for a place holder use 00:00:00:00:00:00 and leave it unlocked to be updated by SSIM
  • Confidentiality - by default it will always be at least 1
  • Integrity - by default it will always be at least 1
  • Availability - by default it will always be at least 1
  • Locked - can be either Locked or Unlocked, this will depend on if you want this asset updated by SSIM Collectors
  • Last Updated - needs to be in Java Date format, see the example below

Example:
"IP Address","IPv6 Address1","IPv6 Address2","Hostname","MAC Address","DN","Confidentiality","Integrity","Availability","Vulnerable","Locked","Organization Unit","Location","OS Name","OS Version","Owner","External ID","Last Updated","Description"
"10.0.3.2","","","10.0.3.2","00:00:00:00:00:00","","1","1","1","Yes","Unlocked","ou=Default","","Linux Kernel 2.6","2.6","","","Feb 11, 2013 9:58:55 PM PST",""
"10.0.3.3","","","10.0.3.3","00:00:00:00:00:00","","1","1","1","Yes","Unlocked","ou=Default","","Linux Kernel 2.6","2.6","","","Feb 11, 2013 9:59:09 PM PST",""

Because Microsoft Excel occasionally inserts special "control" characters, using Excel or any other spreadsheet application to edit Asset files intended for import is not recommended or supported.





 



Legacy ID



2008051613310654


Article URL http://www.symantec.com/docs/TECH89544


Terms of use for this information are found in Legal Notices