https://community.cisco.com/t5/network-access-control/acs-5-3-error-message-while-importing-devices-using-import/m-p/2931753#M37530 <P>Hi,</P> <P>Iam getting below error message while importing devices(<SPAN>using the template)</SPAN>&nbsp;to ACS 5.3 server.</P> <P>checked the header of the file using text editor.</P> <P>I tried with the new csv file by copying the contents of the import template. But, no luck.</P> <P>Please advise how to fix this issue.</P> <P></P> <P>Error message</P> <P>Cisco Secure ACS <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_taglib.js"></SCRIPT> <SCRIPT>// &amp;amp;amp;lt;![CDATA[ cuesKnownLocation='/acsadmin/';cuesImageFolder='cues_images';cuesIconFolder='cues_icons';cuesVersion='60';cuesXslSkin='base';cuesImageSuffix=''; // ]]&amp;amp;amp;gt;</SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/tree.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/cuesDrawer_tree_tpl.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/tree_tpl.js"></SCRIPT> <SCRIPT type="text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-custom.js"></SCRIPT> <SCRIPT type="text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-control.js"></SCRIPT> <SCRIPT type="text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-x-autosizing.js"></SCRIPT> <SCRIPT type="text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-style.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_fonts.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_drawn.js"></SCRIPT> <SCRIPT>// &amp;amp;amp;lt;![CDATA[ msgInvalidData="Invalid data has been entered";msgNoncontiguousReorder="You can only reorder selected rows that are contiguous";altExpandDrawer="Expand";altCollapseDrawer="Collapse";altExpandNav="Expand Navigation Pane";altCollapseNav="Collapse Navigation Pane";altExpandTree="Expand tree item";altCollapseTree="Collapse tree item";altLeafTree="Leaf";altWizardStepErrorState="Wizard step contains 1 or more errors";altTabErrorState="Tab contains 1 or more errors";msgEmptyRow="No data to display";altExpandPane="Expand";altCollapsePane="Collapse";var cuesMaskeditFormatError = new Array();cuesMaskeditFormatError["time2"]="The entered time must be in the range of 1:00 to 12:59";cuesMaskeditFormatError["netmask"]="A valid netmask consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3";cuesMaskeditFormatError["miltime2"]="The entered time must be in the range of 0:00 to 23:59";cuesMaskeditFormatError["mac"]="A valid MAC address is nn:nn:nn:nn:nn:nn where the 'n's are either digits (0-9) or letters (A-F)";cuesMaskeditFormatError["ipv4"]="A valid IPv4 address consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3"; // ]]&amp;amp;amp;gt;</SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/pages/framework/acsgfw.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/client-input-validation.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/pages/framework/customAlert/acsCustomAlert.jsp"></SCRIPT> </P> <DIV id="content" style="overflow: auto; height: 634px; width: 799px; position: relative; margin-left: 10px; padding-right: 10px;"><FORM accept-charset="UTF-8" method="post" name="ImportForm" action="https://community.cisco.com/acsadmin/ImportAction.do"> <DIV class="cuesFormPane"><FIELDSET id="monitor_grpbx_log" class="cuesGroupBox"> <TABLE width="90%" align="center"> <TBODY> <TR> <TD> <DIV id="importlog" style="overflow: auto; height: 320px; width: 100%; border: 2px inset;" align="left">2016-11-19 11:14:02: File Format Validation Failed<BR />Header is incorrect. Download Import Template for required header record.<BR /><BR />Aborting......<BR />---------- End ----------<BR />Please refresh the table to see the changes.</DIV> </TD> </TR> </TBODY> </TABLE> </FIELDSET></DIV> </FORM></DIV> <P><BR /> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_taglib.js" type="mce-no/type"></SCRIPT> <SCRIPT type="mce-no/type">// &amp;amp;amp;lt;![CDATA[ cuesKnownLocation='/acsadmin/';cuesImageFolder='cues_images';cuesIconFolder='cues_icons';cuesVersion='60';cuesXslSkin='base';cuesImageSuffix=''; // ]]&amp;amp;amp;gt;</SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/tree.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/cuesDrawer_tree_tpl.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/tree_tpl.js" type="mce-no/type"></SCRIPT> <SCRIPT type="mce-text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-custom.js"></SCRIPT> <SCRIPT type="mce-text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-control.js"></SCRIPT> <SCRIPT type="mce-text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-x-autosizing.js"></SCRIPT> <SCRIPT type="mce-text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-style.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_fonts.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_drawn.js" type="mce-no/type"></SCRIPT> <SCRIPT type="mce-no/type">// &amp;amp;amp;lt;![CDATA[ msgInvalidData="Invalid data has been entered";msgNoncontiguousReorder="You can only reorder selected rows that are contiguous";altExpandDrawer="Expand";altCollapseDrawer="Collapse";altExpandNav="Expand Navigation Pane";altCollapseNav="Collapse Navigation Pane";altExpandTree="Expand tree item";altCollapseTree="Collapse tree item";altLeafTree="Leaf";altWizardStepErrorState="Wizard step contains 1 or more errors";altTabErrorState="Tab contains 1 or more errors";msgEmptyRow="No data to display";altExpandPane="Expand";altCollapsePane="Collapse";var cuesMaskeditFormatError = new Array();cuesMaskeditFormatError["time2"]="The entered time must be in the range of 1:00 to 12:59";cuesMaskeditFormatError["netmask"]="A valid netmask consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3";cuesMaskeditFormatError["miltime2"]="The entered time must be in the range of 0:00 to 23:59";cuesMaskeditFormatError["mac"]="A valid MAC address is nn:nn:nn:nn:nn:nn where the 'n's are either digits (0-9) or letters (A-F)";cuesMaskeditFormatError["ipv4"]="A valid IPv4 address consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3"; // ]]&amp;amp;amp;gt;</SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/pages/framework/acsgfw.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/client-input-validation.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/pages/framework/customAlert/acsCustomAlert.jsp" type="mce-no/type"></SCRIPT> </P> <DIV id="content" style="overflow: auto; height: 634px; width: 799px; position: relative; margin-left: 10px; padding-right: 10px;"><FORM accept-charset="UTF-8" method="post" name="ImportForm" action="https://community.cisco.com/acsadmin/ImportAction.do"> <DIV class="cuesFormPane"><FIELDSET id="monitor_grpbx_log" class="cuesGroupBox">&nbsp;</FIELDSET></DIV> </FORM></DIV> Mon, 11 Mar 2019 07:14:33 GMT SK Ameen . 2019-03-11T07:14:33Z https://community.cisco.com/t5/network-access-control/acs-5-3-error-message-while-importing-devices-using-import/m-p/2931753#M37530 <P>Hi,</P> <P>Iam getting below error message while importing devices(<SPAN>using the template)</SPAN>&nbsp;to ACS 5.3 server.</P> <P>checked the header of the file using text editor.</P> <P>I tried with the new csv file by copying the contents of the import template. But, no luck.</P> <P>Please advise how to fix this issue.</P> <P></P> <P>Error message</P> <P>Cisco Secure ACS <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_taglib.js"></SCRIPT> <SCRIPT>// &amp;amp;amp;lt;![CDATA[ cuesKnownLocation='/acsadmin/';cuesImageFolder='cues_images';cuesIconFolder='cues_icons';cuesVersion='60';cuesXslSkin='base';cuesImageSuffix=''; // ]]&amp;amp;amp;gt;</SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/tree.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/cuesDrawer_tree_tpl.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/tree_tpl.js"></SCRIPT> <SCRIPT type="text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-custom.js"></SCRIPT> <SCRIPT type="text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-control.js"></SCRIPT> <SCRIPT type="text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-x-autosizing.js"></SCRIPT> <SCRIPT type="text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-style.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_fonts.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_drawn.js"></SCRIPT> <SCRIPT>// &amp;amp;amp;lt;![CDATA[ msgInvalidData="Invalid data has been entered";msgNoncontiguousReorder="You can only reorder selected rows that are contiguous";altExpandDrawer="Expand";altCollapseDrawer="Collapse";altExpandNav="Expand Navigation Pane";altCollapseNav="Collapse Navigation Pane";altExpandTree="Expand tree item";altCollapseTree="Collapse tree item";altLeafTree="Leaf";altWizardStepErrorState="Wizard step contains 1 or more errors";altTabErrorState="Tab contains 1 or more errors";msgEmptyRow="No data to display";altExpandPane="Expand";altCollapsePane="Collapse";var cuesMaskeditFormatError = new Array();cuesMaskeditFormatError["time2"]="The entered time must be in the range of 1:00 to 12:59";cuesMaskeditFormatError["netmask"]="A valid netmask consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3";cuesMaskeditFormatError["miltime2"]="The entered time must be in the range of 0:00 to 23:59";cuesMaskeditFormatError["mac"]="A valid MAC address is nn:nn:nn:nn:nn:nn where the 'n's are either digits (0-9) or letters (A-F)";cuesMaskeditFormatError["ipv4"]="A valid IPv4 address consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3"; // ]]&amp;amp;amp;gt;</SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/pages/framework/acsgfw.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/client-input-validation.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/pages/framework/customAlert/acsCustomAlert.jsp"></SCRIPT> </P> <DIV id="content" style="overflow: auto; height: 634px; width: 799px; position: relative; margin-left: 10px; padding-right: 10px;"><FORM accept-charset="UTF-8" method="post" name="ImportForm" action="https://community.cisco.com/acsadmin/ImportAction.do"> <DIV class="cuesFormPane"><FIELDSET id="monitor_grpbx_log" class="cuesGroupBox"> <TABLE width="90%" align="center"> <TBODY> <TR> <TD> <DIV id="importlog" style="overflow: auto; height: 320px; width: 100%; border: 2px inset;" align="left">2016-11-19 11:14:02: File Format Validation Failed<BR />Header is incorrect. Download Import Template for required header record.<BR /><BR />Aborting......<BR />---------- End ----------<BR />Please refresh the table to see the changes.</DIV> </TD> </TR> </TBODY> </TABLE> </FIELDSET></DIV> </FORM></DIV> <P><BR /> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_taglib.js" type="mce-no/type"></SCRIPT> <SCRIPT type="mce-no/type">// &amp;amp;amp;lt;![CDATA[ cuesKnownLocation='/acsadmin/';cuesImageFolder='cues_images';cuesIconFolder='cues_icons';cuesVersion='60';cuesXslSkin='base';cuesImageSuffix=''; // ]]&amp;amp;amp;gt;</SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/tree.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/cuesDrawer_tree_tpl.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/tigra/tree_tpl.js" type="mce-no/type"></SCRIPT> <SCRIPT type="mce-text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-custom.js"></SCRIPT> <SCRIPT type="mce-text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-control.js"></SCRIPT> <SCRIPT type="mce-text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-x-autosizing.js"></SCRIPT> <SCRIPT type="mce-text/javascript" src="https://community.cisco.com/acsadmin/udm-resources/udm-style.js"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_fonts.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/cues_utility/cues_drawn.js" type="mce-no/type"></SCRIPT> <SCRIPT type="mce-no/type">// &amp;amp;amp;lt;![CDATA[ msgInvalidData="Invalid data has been entered";msgNoncontiguousReorder="You can only reorder selected rows that are contiguous";altExpandDrawer="Expand";altCollapseDrawer="Collapse";altExpandNav="Expand Navigation Pane";altCollapseNav="Collapse Navigation Pane";altExpandTree="Expand tree item";altCollapseTree="Collapse tree item";altLeafTree="Leaf";altWizardStepErrorState="Wizard step contains 1 or more errors";altTabErrorState="Tab contains 1 or more errors";msgEmptyRow="No data to display";altExpandPane="Expand";altCollapsePane="Collapse";var cuesMaskeditFormatError = new Array();cuesMaskeditFormatError["time2"]="The entered time must be in the range of 1:00 to 12:59";cuesMaskeditFormatError["netmask"]="A valid netmask consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3";cuesMaskeditFormatError["miltime2"]="The entered time must be in the range of 0:00 to 23:59";cuesMaskeditFormatError["mac"]="A valid MAC address is nn:nn:nn:nn:nn:nn where the 'n's are either digits (0-9) or letters (A-F)";cuesMaskeditFormatError["ipv4"]="A valid IPv4 address consists of four numbers (0-255) separated by periods, e.g. 123.0.255.3"; // ]]&amp;amp;amp;gt;</SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/pages/framework/acsgfw.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/client-input-validation.js" type="mce-no/type"></SCRIPT> <SCRIPT language="JavaScript" src="https://community.cisco.com/acsadmin/pages/framework/customAlert/acsCustomAlert.jsp" type="mce-no/type"></SCRIPT> </P> <DIV id="content" style="overflow: auto; height: 634px; width: 799px; position: relative; margin-left: 10px; padding-right: 10px;"><FORM accept-charset="UTF-8" method="post" name="ImportForm" action="https://community.cisco.com/acsadmin/ImportAction.do"> <DIV class="cuesFormPane"><FIELDSET id="monitor_grpbx_log" class="cuesGroupBox">&nbsp;</FIELDSET></DIV> </FORM></DIV> Mon, 11 Mar 2019 07:14:33 GMT https://community.cisco.com/t5/network-access-control/acs-5-3-error-message-while-importing-devices-using-import/m-p/2931753#M37530 SK Ameen . 2019-03-11T07:14:33Z https://community.cisco.com/t5/network-access-control/acs-5-3-error-message-while-importing-devices-using-import/m-p/2931754#M37531 <P>Hi,</P> <P></P> <P>there is problem in Template headers, you have to delete one column from the Template file, i can't tell you exactly which one but you can figure it out. try if you fail then let me know.</P> <P></P> <P>regards,</P> <P>- Moin -&nbsp;</P> Mon, 21 Nov 2016 00:47:44 GMT https://community.cisco.com/t5/network-access-control/acs-5-3-error-message-while-importing-devices-using-import/m-p/2931754#M37531 Shaik Moinuddin 2016-11-21T00:47:44Z