MSCRM2011: excels uplodsa in mscrm

<html><head>
<meta charset="utf-8">
<title></title>
<link rel="stylesheet" type="text/css" href="../styles/styles.css">
<script type="text/javascript" src="../Scripts/JQuery1.4.4.min.js"></script>

<script type="text/javascript" src="../Scripts/JQueryLibrary.js"></script>

<script type="text/javascript" src="../Scripts/json2.js"></script>
<script type="text/javascript" src="../Scripts/XrmServiceToolkitSOAP.js"></script>
<script type="text/javascript">
function ExcelUpload() {
debugger;

if (window.File) {
var guId = window.parent.Xrm.Page.data.entity.getId();

var FileName = document.getElementById("Browse").value;

var validExts = new Array(".xlsx", ".xls");
var fileExt = FileName;
fileExt = fileExt.substring(fileExt.lastIndexOf('.'));
if (fileExt == ".xlsx" || fileExt == ".xls") {
var fullPath = FileName;
var FileType;
var startIndex = (fullPath.indexOf('\\') >= 0 ? fullPath.lastIndexOf('\\') : fullPath.lastIndexOf('/'));
var filename = fullPath.substring(startIndex);
if (filename.indexOf('\\') === 0 || filename.indexOf('/') === 0) {
filename = filename.substring(1);

FileType = filename.substr(0, filename.lastIndexOf('.')) || input;
}

var excel = new ActiveXObject("Excel.Application");
var excel_file = excel.Workbooks.Open(FileName);
var excel_sheet = excel_file.Worksheets("Sheet1");
var Rows = excel_sheet.UsedRange.Cells.Rows.Count;
var Columns = excel_sheet.UsedRange.Cells.Columns.Count;
var PaymentMode = excel_file.ActiveSheet.Cells(1, 1).Value;
var date = excel_file.ActiveSheet.Cells(1, 2).Value;
var Number = excel_file.ActiveSheet.Cells(1, 3).Value;
var Name = excel_file.ActiveSheet.Cells(1, 4).Value;
var ICRefno = excel_file.ActiveSheet.Cells(1, 5).Value;
var Amount = excel_file.ActiveSheet.Cells(1, 6).Value;

for (var i = 1; i < Rows - 1 ; i++) {

var modeofpayment = excel_file.ActiveSheet.Cells(i + 1, 1).Value;
var Ddate = new Date(excel_file.ActiveSheet.Cells(i + 1, 2).Value);
var DDNumber = String(excel_file.ActiveSheet.Cells(i + 1, 3).Value);
var BankName = excel_file.ActiveSheet.Cells(i + 1, 4).Value;
var ICRRefno = excel_file.ActiveSheet.Cells(i + 1, 5).Value;
var DDAmount = excel_file.ActiveSheet.Cells(i + 1, 6).Value;
var Paymode = new XrmServiceToolkit.Soap.BusinessEntity("paymentmodeselection");
Paymode.attributes[name"] = modeofpayment;
Paymode.attributes["dddate"] = Ddate;
Paymode.attributes["transactionnumber"] = DDNumber;
Paymode.attributes["bankname"] = BankName;
Paymode.attributes["referencenumber"] = ICRRefno;
Paymode.attributes["paymentmodeid"] = { id: guId, logicalName: "paymentmodeselection", type: "EntityReference" };
Paymode.attributes["bankreconcilation"] = { value: 1, type: "OptionSetValue" };
Paymode.attributes["htt_transactionidentifier"] = { value: 2, type: "OptionSetValue" };
Paymode.attributes["htt_fees"] = { value: DDAmount, type: "Money" };
var fetchXML = "<fetch version='1.0' output-format='xml-platform' mapping='logical' >" +

else {
alert("Mode ");
break;
}

}

if (FileType.toLowerCase() == "bankreconciliation" || " reconciliation" && PaymentMode.length > 0) {

alert(" Reconciliation file successfully uploaded.");

var webResource = window.parent.Xrm.Page.ui.controls.get("WebResource_TMLSubgridPaymentSelection");
webResource.setSrc(webResource.getSrc());

}

}

else {
alert("Invaild Bank Reconciliation excel file format.");

}

}
else {
alert(" .");
}

}
else {

alert("mmmm");
}

}
else {
alert("Browser does not support file reader method");
}
}

</script>

</head><body>



<div id="dataInfo">
<p>
            Upload Collection  file:

<br>
<input id="Browse" name="datafile" size="40" type="file">
</p>
<input id="upload" onclick="ExcelUpload()" value="Upload file" type="button">
</div>

</body></html>

MSCRM2011

Wednesday, 13 May 2015

excels uplodsa in mscrm

No comments:

Post a Comment