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 SQL,how I can achieve it?
i want only updated data should be uploaded,who 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 2016,by 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.

Answer 1

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.

Answer 2

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.

Answer 3

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

Answer 4

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.