I want to import stock purchase order to tally from excel.

Hi,

I am creating a .net application for import PO and SO excel data into tally by XML

my code is below. The XML I use is export from the tally. I don't know its correct or not but when I runt that code its give error 1.

try
{
string xmlpo = "" + "\r\n";
xmlpo += "
" + "\r\n";
xmlpo += "Import Data" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Vouchers" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Abc" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "
testaddress1
" + "\r\n";
xmlpo += "
testaddress2
" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Warehouse Complex," + "\r\n";
xmlpo += "Mumbai" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += " 201124739" + "\r\n";
xmlpo += "-1" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "20190504" + "\r\n";
xmlpo += "9536a79f-d51d-48d5-968c-ecfe2e5c91cb-00000678" + "\r\n";
xmlpo += "being items ordered to HQ" + "\r\n";
xmlpo += "Delhi" + "\r\n";
xmlpo += "Easy Co. Ltd." + "\r\n";
xmlpo += "Purchase Order" + "\r\n";
xmlpo += "LGM0119058523" + "\r\n";
xmlpo += "99" + "\r\n";
xmlpo += "Easy Co. Ltd." + "\r\n";
xmlpo += "Easy Co. Ltd." + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Default" + "\r\n";
xmlpo += "Invoice Voucher View" + "\r\n";
xmlpo += "27AANCS6E3ZP" + "\r\n";
xmlpo += "ABC" + "\r\n";
xmlpo += "180 Days" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Palam" + "\r\n";
xmlpo += "[email protected]" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "20190504" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += " 4209" + "\r\n";
xmlpo += " 166" + "\r\n";
xmlpo += "25874159" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += " 201724369" + "\r\n";
xmlpo += "-1" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Easy Co. Ltd." + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "28.22 USD @ ₹ 69.9001/ USD = ₹ 1972.58" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "football" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "4.36 USD = ₹ 304.76/pcs" + "\r\n";
xmlpo += "-17.44 USD @ ₹ 69.90/ USD = -₹ 1219.06" + "\r\n";
xmlpo += " 4 pcs" + "\r\n";
xmlpo += " 4 pcs" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Main Location" + "\r\n";
xmlpo += "Primary Batch" + "\r\n";
xmlpo += "Main Location" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "LGM011905925184" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "-17.44 USD @ ₹ 69.90/ USD = -₹ 1219.06" + "\r\n";
xmlpo += "0.00 USD @ ₹ 69.90/ USD = -₹ 0.00" + "\r\n";
xmlpo += " 4 pcs" + "\r\n";
xmlpo += " 4 pcs" + "\r\n";
xmlpo += "180 Days" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += " 201724739" + "\r\n";
xmlpo += "-1" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Purchase Import" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "-17.44 USD @ ₹ 69.90/ USD = -₹ 1219.06" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Hockey" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "10.78 USD = ₹ 753.52/pcs" + "\r\n";
xmlpo += "-10.78 USD @ ₹ 69.90/ USD = -₹ 753.52" + "\r\n";
xmlpo += " 1 pcs" + "\r\n";
xmlpo += " 1 pcs" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Main Location" + "\r\n";
xmlpo += "Primary Batch" + "\r\n";
xmlpo += "Main Location" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "LGM0119058547" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "-10.78 USD @ ₹ 69.90/ USD = -₹ 753.52" + "\r\n";
xmlpo += "0.00 USD @ ₹ 69.90/ USD = ₹ 0.00" + "\r\n";
xmlpo += " 1 pcs" + "\r\n";
xmlpo += " 1 pcs" + "\r\n";
xmlpo += "180 Days" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += " 201724739" + "\r\n";
xmlpo += "-1" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Purchase Import" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "Yes" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "No" + "\r\n";
xmlpo += "-10.78 USD @ ₹ 69.90/ USD = -₹ 753.52" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += " " + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "9536a79f-d21d-48d5-968c-evbfg2e5c91cb" + "\r\n";
xmlpo += "ABC" + "\r\n";
xmlpo += "Maharashtra" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "d775d1ad-cd56-4a75-b8c9-gt21b4c05d0e" + "\r\n";
xmlpo += "ABC" + "\r\n";
xmlpo += "Maharashtra" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "9536a79f-d21d-48d5-968c-ecfe2e5c91cb" + "\r\n";
xmlpo += "ABC" + "\r\n";
xmlpo += "Maharashtra" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "d775d1ad-cd56-4a75-b8c9-cb21b4c05d0e" + "\r\n";
xmlpo += "ABC" + "\r\n";
xmlpo += "Maharashtra" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
xmlpo += "" + "\r\n";
HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create("http://localhost:9000/");
httpWebRequest.Method = "POST";
httpWebRequest.ContentLength = xmlpo.Length;
httpWebRequest.ContentType = "application/x-www-form-urlencoded";
StreamWriter streamWriter = new StreamWriter(httpWebRequest.GetRequestStream());
streamWriter.Write(xmlpo);
streamWriter.Close();
string result;
HttpWebResponse objResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (StreamReader sr = new StreamReader(objResponse.GetResponseStream()))
{
result = sr.ReadToEnd();
sr.Close();
}
MessageBox.Show(result);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.StackTrace);
}

If this XML is wrong please suggest a correct one or where I can find the XML formate for other tally import entries.