Neil Lydick, one of our developers, wrote an excellent document containing overview and how-to information for importing information using a Comma Separated Value (CSV) file. This feature can be used to:
· Create Configuration Item or Work Item instances from data stored in a tabular format
· Bulk-edit existing database instances
· Populate the SMCMDB with data exported from an external database
· Circumvent data entry through forms when many class instances must be created at once
To see the full document, click the title of this post and check out the attached file. If you're reading this post through an RSS feed, you'll need to click through to the http://blogs.technet.com/servicemanager/archive/2009/05/26/using-the-csv-import-feature.aspx to see the attachment.
[Edit: If you've noticed a lack of Appendix A in your document, grab that in my subsequent post, here: http://blogs.technet.com/servicemanager/archive/2009/05/26/appendix-a-to-previous-post.aspx ]
https://msdnshared.blob.core.windows.net/media/TNBlogsFS/prod.evol.blogs.technet.com/telligent.evolution.components.attachments/01/6241/00/00/03/24/59/31/CSVImport.docx
