{"id":2252,"date":"2015-04-07T16:13:28","date_gmt":"2015-04-07T20:13:28","guid":{"rendered":"http:\/\/batchpatch.com\/?p=2252"},"modified":"2015-04-07T16:25:48","modified_gmt":"2015-04-07T20:25:48","slug":"importing-hosts-and-other-information-into-a-batchpatch-grid","status":"publish","type":"post","link":"https:\/\/batchpatch.com\/importing-hosts-and-other-information-into-a-batchpatch-grid","title":{"rendered":"Importing Hosts and Other Information into a BatchPatch Grid"},"content":{"rendered":"

In the April 2015 release of BatchPatch we updated the method responsible for importing computers so that you can now import other items in addition to computer names and IP addresses.<\/p>\n

The allowed values are:<\/p>\n\n

1\n<\/pre><\/td>
# MAC       | NOTES\t      || NOTES2       ||| DESCRIPTION       |||| LOCATION        |U| USERNAME        |P| PASSWORD        |D| DOMAIN<\/pre><\/td><\/tr><\/table><\/div>\n\n
As long as you preserve the overall order of items listed above, you can enter as few or as many of them as you want when you import host names.  It doesn’t matter whether you’re importing host names by using the “File > Add hosts” option or if you have a text file that you’re simply dragging and dropping on to the grid.  The format rules will apply in either case.  Below are some common examples of how one might choose to enter host names or IP addresses into the grid with additional information.<\/p>\n
For example, if you only want to enter host names into a grid, the required format is as follows:<\/p>\n\n
1\n2\n3\n4\n5\n<\/pre><\/td>
host1\nhost2\nhost3\nhost4\nhost5<\/pre><\/td><\/tr><\/table><\/div>\n\n
However, if you want to add host names with MAC addresses, use the following syntax:<\/p>\n\n
1\n2\n3\n4\n5\n<\/pre><\/td>
host1#CCDDEECCDDEE\nhost2#DDEECCDDEECC\nhost3#EECCDDEECCDD\nhost4#CCDDCCDDEEEE\nhost5#CCDDEEEECCDD<\/pre><\/td><\/tr><\/table><\/div>\n\n
If you want to add host names, MAC addresses, and location information, use the following syntax:<\/p>\n\n
1\n2\n3\n4\n5\n<\/pre><\/td>
host1#CCDDEECCDDEE||||3rd Floor Office\nhost2#DDEECCDDEECC||||Server room\nhost3#EECCDDEECCDD||||Data center\nhost4#CCDDCCDDEEEE||||4th Floor Office\nhost5#CCDDEEEECCDD||||4th Floor Office<\/pre><\/td><\/tr><\/table><\/div>\n\n
If you want to add host names, MAC addresses, usernames, and passwords, use the following syntax:<\/p>\n\n
1\n2\n3\n4\n5\n<\/pre><\/td>
host1#CCDDEECCDDEE||||3rd Floor Office|U|username|P|password\nhost2#DDEECCDDEECC||||Server room|U|username|P|password\nhost3#EECCDDEECCDD||||Data center|U|username|P|password\nhost4#CCDDCCDDEEEE||||4th Floor Office|U|username|P|password\nhost5#CCDDEEEECCDD||||4th Floor Office|U|username|P|password<\/pre><\/td><\/tr><\/table><\/div>\n\n
If you want to add host names, MAC addresses, special notes, descriptions, usernames, and passwords, use the following syntax:<\/p>\n\n
1\n2\n3\n4\n5\n<\/pre><\/td>
host1#CCDDEECCDDEE|Don't Reboot Unless host 23 is powered off|||host1 is responsible for video monitoring||||3rd Floor Office|U|username|P|password\nhost2#DDEECCDDEECC|Don't Reboot Unless host 24 is powered off|||host2 is responsible for intranet website monitoring||||Server room|U|username|P|password\nhost3#EECCDDEECCDD||||Data center|U|username|P|password\nhost4#CCDDCCDDEEEE||||4th Floor Office|U|username|P|password\nhost5#CCDDEEEECCDD||||4th Floor Office|U|username|P|password<\/pre><\/td><\/tr><\/table><\/div>\n\n
If you want to add host names and notes, use the following syntax:<\/p>\n\n
1\n2\n3\n4\n5\n<\/pre><\/td>
host1|special notes for host1\nhost2|special notes for host2\nhost3|special notes for host3\nhost4|special notes for host4\nhost5|special notes for host5<\/pre><\/td><\/tr><\/table><\/div>\n\n","protected":false},"excerpt":{"rendered":"
In the April 2015 release of BatchPatch we updated the method responsible for importing computers so that you can now import other items in addition to computer names and IP addresses. The allowed values are: 1 # MAC | NOTES || NOTES2 ||| DESCRIPTION |||| LOCATION |U| USERNAME |P| PASSWORD |D| DOMAIN As long as […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1,17,3],"tags":[89],"class_list":["post-2252","post","type-post","status-publish","format-standard","hentry","category-blog","category-general","category-tutorials","tag-import"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/2252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/comments?post=2252"}],"version-history":[{"count":4,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/2252\/revisions"}],"predecessor-version":[{"id":2256,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/posts\/2252\/revisions\/2256"}],"wp:attachment":[{"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/media?parent=2252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/categories?post=2252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/batchpatch.com\/wp-json\/wp\/v2\/tags?post=2252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}