xml ¼öÁ¤ÇÏ´Â ¹ý ¾Ë°í °è½ÅºÐ °è½ÅÁö¿ä?
https://sourceforge.net/projects/multiputtymanager/
상기 원격 접속 프로그램의 DB파일을 수정중입니다.
장비리스트는 엑셀로 있어서...
엑셀에서 해당 DB 파일을 수정하려고 하는데
컨피그 자료인 첨부파일 및 하기 코드 자료를
코드 엑셀에서 개발도구로 열어서 수정해 내보내기로 해보려고 하는데...
잘 안되내요;
혹시 어떻게 해야 되는지 아시는분 계신지요?
<?xml version="1.0" encoding="utf-8"?>
<root type="database" name="Fortigate" expanded="True">
<container type="folder" name="SSH" expanded="False">
</container>
<container type="folder" name="Telnet" expanded="True">
<connection type="PuTTY" name="Site1">
<name>Site1</name>
<protocol>Telnet</protocol>
<host>192.168.6.1</host>
<port>23</port>
<session>Default Settings</session>
<description>
</description>
<login>admin</login>
<password>test</password>
<connectiontimeout>1500</connectiontimeout>
<logintimeout>1000</logintimeout>
<passwordtimeout>1000</passwordtimeout>
<commandtimeout>1000</commandtimeout>
<command1>exe backup config tftp 192.168.6.1.conf 192.168.6.43</command1>
<command2>exit</command2>
</connection>
<connection type="PuTTY" name="Site2">
<name>Site2</name>
<protocol>Telnet</protocol>
<host>192.168.254.254</host>
<port>23</port>
<session>Default Settings</session>
<description>
</description>
<login>admin</login>
<password>test</password>
<connectiontimeout>1500</connectiontimeout>
<logintimeout>1000</logintimeout>
<passwordtimeout>1000</passwordtimeout>
<commandtimeout>10000</commandtimeout>
<command1>exe backup config tftp 192.168.254.254 192.168.6.43</command1>
<command2>exit</command2>
</connection>
</container>
</root>
Àåºñ Á¢¼ÓÁ¤º¸´Â Mysql¿¡¼ xml ÆÄÀÏ·Î ¹Þ¾ÆÁö±â ¶§¹®¿¡ º° ¹®Á¦´Â ¾ÈµÇ´Âµ¥...
¿¢¼¿¿¡¼ Çà´ç µ¥ÀÌÅÍ ¸¸µé¾î
notepad++¿¡¼ °ø¹é±â´É(ÅÇÀ» ºóÄÀ¸·Î) & ¹Ù²Ù±â \r\n ¿É¼ÇÀ¸·Î ó¸®Çؼ ¸¸µé±îµµ »ý°¢ÇØ ºÃ¾ú½À´Ï´Ù¸¸...
2ÁÖ¸¶´Ù ÀÛ¾÷Çϱ⿡´Â ¿¢¼¿ÀÌ °¡Àå °£ÆíÇÒ °Í °°¾Æ¼¿ä.
cattools·Î ÇÒ±î »ý°¢Çߴµ¥...
cattoolsÀº À¯·á¿¡´Ù°¡.... Àåºñ´ç ÄÁÇÇ±× ³Ö¾îÁà¾ß µÇ´Â ºÎºÐÀÌ ´õ¸¹¾Æ¼...
Áö·Ê Æ÷±âÇÏ°í ¾Æ·¡ Åø·Î ¿¢¼¿ & plink ÅëÇؼ À߶ó¼ ó¸® Çß¾ú´Âµ¥...
http://www.sharontools.com/products/massconfig/
Åëä·Î µ¹¸®¸é ¿¢¼¿ > cmd plink ÀÌ·¸°Ô ÀÛµ¿ÇÏ´Ùº¸´Ï ¿¢¼¿ÀÌ ÀÀ´ä¾øÀ½ ¶ß¸é¼ Á×´õ¶ó°í¿ä;
¿¢¼¿ ¹öÀü°ú Àú°É µ¹¸®´Â PC »ç¾çÀº¿ä?
±×¸®°í °á·ÐÀûÀ¸·Î Àú XMLÀ» ¾î¶»°Ô ¼öÁ¤ÇØ¾ß ÇÏ´ÂÁö¿¡ ´ëÇÑ Áú¹®³»¿ëÀÌ ¾ø½À´Ï´Ù.
¹«¾ùÀ» ¼öÁ¤ÇÏ·Á°í ÇϽóª¿ä?
¾Æ¹«·¡µµ IP PW Á¤º¸¸¦ ¸®½ºÆ®·Î ±Ü¾î¿Í¼ ¸®½ºÆ®¸ñ·Ï ¸¸µç°ÍÀ» ´Ù½Ã °¡Á®°¡´Â ¹æ½ÄÀ¸·Î
¸ÞÅ©·Î°¡ ÀÛµ¿Çϴµ¥ ÀÌ ¶§¹®¿¡ ±×·±°Í °°½À´Ï´Ù.
¼öÁ¤ ¿øÇÏ´Â »çÇ×Àº
¿¢¼¿µ¥ÀÌÅÍ·Î °í°´¼ºñ½º¹øÈ£& Á¢¼ÓIP & °èÁ¤ & PW & port ÀÚ·á°¡ Àִµ¥...
ÀÌ°É À§¿Í °°Àº Æ÷¸äÀ¸·Î º¯°æ½ÃÅ°´Â ¹æ¹ýÀÔ´Ï´Ù
sed³ª ½©ÀÇ awk Á¤µµ Àúµµ Ãßõµå¸³´Ï´Ù.
º»°ÝÀûÀ¸·Î ÇÏ·Á¸é... ÅؽºÆ® °¡°øÀº ¿ª½Ã, ÆÄÀ̽ãÀÌÁÒ^^