How we can upload data tally to SQL only updated data

Question

Hi Please help me I want to upload data from tally to our Local SQLhow I can achieve it? i want only updated data should be uploadedwho uploaded earlier need not be uploaded. one more thing I want suppose we have uploaded data from 4 june 2016 but there was a receipt Receipt0012 who is updated today by amount 100000 to 10000 but tally entry is on same date i.e. 4 june 2016by mistake client gave 100000 instead of 10000.now he updates it in tally but now how i can update it in Local SQL? I am using C# and SQL. My software like first getting data from Tally to Local SQL and then Local SQL to cloud server I want to try upload data from tally to our local SQL and then Local SQL to Cloud server.how i can achieve it by using C# application? time consuming should be very-very small. please give me satisfied solution. Thanks.

Mohan Chandra · Answer

is it possible that tally know that this data has been uploaded in SQL server? suppose i am using C# and there is an file upload control with button control.and an excel is uploaded. and data coming from tally to Excel.and then i am uploading it in SQL by file upload control. now a situation come that 4 july data receptno-115 has been uploaded earlier but today it is modified in tally by amount 100000 to 10000. with same receiptno and same receipt date.now how i can put it in SQL server by using C#. means client will push it by my software so what i need to modify in my code.

Bikesh Srivastava · Answer

Hi Mohan Step 1:-Genrate xml data according your from tally according your requirment what data you want store in sql.you need to check your tally software and genrate xml. Step 2:-use ODBC data provider to store in sql.

Mohan Chandra · Answer

actually i am new on this so it will take only updated records those not uploaded in local SQL and only updated as I ask that back date entry modified by a client in tally so

Bikesh Srivastava · Answer

Hi XML Generation: It will not be a Real time Data export as you need manual interventions for someone to create those XML file from Tally 9 UI and place it for you. ODBC: ODBC options look great but AFIK you need to understand bit TDL language of Tally to get the required data. Apart from the above two options I would suggest you to choose with Tally XML Interface (Kind of SOAP web service) which will give you real time data.

How we can upload data tally to SQL, only updated data